Special Price Lists are designed to allow you to override existing Price levels and discounts 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 or all of your items that will override your existing prices. 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 CSV file 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 (=no) or inactive (=yes)	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 (=no) or inactive (=yes) for this item	No	no
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: