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 your 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_PriceLevelItem_yyyy-mm-dd_hhmmss_Distributor_xxxx.csv

API_PriceLevelItem_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 SpecialPriceLevel" from the Data File types.

Browse to your Header CSV file and load it. 

Select "API Price Level Item" 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. Either load the API Accounts file via the CSV upload, or if you are loading via Excel 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 (Studio)

You may want to view the Special Prices assigned to the items in order to review them for your reference.

Go to Settings - > Price Level -> Special Price Levels

Here you may select the Special Price List and click on Action -> Edit where you can change the code/Description and the currency.

 

 

You can also select a Special Price List and click the Integration Export button. This will export an Excel file of the Special Price List header file with the correct headings, which you can then use to import additional Special Price Lists.

Select Import from the Menu, and you will be brought directly to the Upload interface with the correct file type - API SpecialPriceLevel - already selected.

Add a column with the heading "Hidden" with values:

1 - to hide the Special Price List (deactivating it)

0 - to reactivate it again. When it is Hidden it will not show in the list, when it is reactivated it will reappear in the list.

To see the Special Price List Items go to the Price Level Items tab. All Price Level Items are listed here, Price Levels as well as Special Price Lists.

You can do an Integration Export from the Menu. This will export a CSV file with the headings you can use to update the PriceLevelItems. 

Select Import from the Menu, and you will be brought directly to the Upload interface with the correct file type - API PriceLevelItems - already selected.