Special Price Lists are designed to allow you to override existing Price levels that are currently loaded, for a sub-set of items. The "special price" will be presented in the cart as the item’s price for the customer.
Note: You must be using Price Level to begin with in order to use "Special" Price Lists. If you are using the same price for all yoru customers (such as the Retail or Wholesale price field) you cannot overwrite the prices using Special Price Lists, you will need to change the price itself.
You may want to use this feature if you want to load a list of prices for some of your items that will override your existing prices for a limited time. You can then disable the special price list (by hiding it) and the pricing will return to the original price lists.
This is not a feature for loading your regular or default price. Regular pricing should be loaded via the Items data. For more info on regular pricing see this article: All About Pricing in Pepperi
For example if you have a list of particular items that you DO NOT want to receive any discounts, or that you want to enter a special price for other than the Price List price, you may load a Special Price List for them.
Special Price Lists are assigned to Accounts. Accounts with no Special Price List assigned will continue to use their regular price list and discounts.
This article will explain how to configure Special Price Lists:
1) Create 2 CSV files - Header and Lines - with the Special Prices you wish to assign to specific items.
2) Load the files using the ERP Configuration Upload file option.
3) Assign Special Price Lists to Accounts via the Accounts Excel file mapping called "Special Price List"
4) View your Special Price Lists in the Pepperi web Admin.
1) Create 2 CSV files - Header and Lines
The Header file creates the price lists while the Lines file contains the actual item prices.
The Header CSV file contains the following fields:
Field Name |
Is mandatory? |
Example value |
ExternalID - the ID of the special price list in your system |
Yes |
SpecialPL123 |
Description - the description of the special price list that will be displayed in the Pepperi admin |
Yes |
Special PL for 123 stores |
CurrencySymbol - use the currency code for your country |
No |
USD/AUD/etc. |
Hidden - controls if the special price list should be active (=false/0) or inactive (=true/1) |
No |
True or False also 1 or 0 |
The Lines CSV file contains the following fields:
Field Name |
Is mandatory? |
Example value |
PriceListExternalID - the ID of the special price list as named in the Header file |
Yes |
SpecialPL123 |
ItemExternalID - Item code |
Yes |
Item999 |
Hidden - controls if the special price should be active (=false) or inactive (=true) for this item |
No |
false |
Price - the special price of the item, no currency symbol |
No |
17.50 |
A sample Special Price List Lines CSV file is attached below that contains 3 different special price lists - SP1 SP3 and SP4. Each special price list has special prices for 5 different items.
If you are loading the file automatically by FTP the file naming convention is:
API_SpecialPriceLevel_yyyy-mm-dd_hhmmss_Distributor_xxxx.csv
API_SpecialPriceLevel_Overwrite_yyyy-mm-dd_hhmmss_Distributor_xxxx.csv
For details on the meaning of the Overwrite file see: Uploading Overwrite and Selective overwrite data files
2) Load the Special Price List CSV File
Each file, Header and Lines, is loaded separately.
Go to Settings -> ERP Integration- > File Upload and Logs -> Upload
Select "API Special price level" from the Data File types.
Browse to your Header CSV file and load it.
Select "API pricelevelitem" from the Data file types.
Browse to your Lines CSV file and load it.
3) Assign Special Price Lists to Accounts
You now need to assign the Special Price Lists you loaded to Accounts. Add a column to your existing Accounts Excel file with the Special Price List assignment by the Price List Name you entered in the CSV file above.
Re-import your Accounts file without modifying any of the mapping of the other columns.
Map the Special Price List column you added:
4) View your Special Price Lists in the Pepperi Web Admin
You may want to view the Special Prices assigned to the items in order to review them for your reference.
You may do so by going to Settings - > Pricing Policy -> Account Special Price Lists
Here you may select the Special Price List and click on Edit where you can change the code/Description and the currency.
You can also select a Special Price List and click the export button. This will export an Excel file with a list of all the items and the Special Prices assigned to them for this Special Price List.
Exports this kind of file containing the price for each item in the selected Special Price List:
0 comments
Please sign in to leave a comment.