Uploading this file allows you to:

• Upload a file with prices for the items price list
• Overwrite prices in an entire price list
• Selective overwrites to specific items in a price list

There is another file called Price List Information, which uploads the price list currency and description. 

Depending on how you name the file, the appropriate action will be taken:

API_PriceLevelItem_2011-03-24_114327_Distributor_xxxx.csv

API_PriceLevelItem_Overwrite_2011-03-24_114327_Distributor_xxxx.csv

API_PriceLevelItem_SelectiveOverwrite_2011-03-24_114327_Distributor_xxxx.csv

For detailed explanation of the overwrite options see: Uploading Overwrite and Selective overwrite data files

Sample file and template files are attached below.

Create a CSV file with the following fields.

PriceListExternalID - the ID of the price list

ItemExternalID - the item code

Price - the price of the item

Hidden - boolean value of true (1) or false (0) (default is false)

If hidden is true, the price of the item will show as zero in this price list. 

Go to Settings -> ERP Integration -> File upload and logs -> Click "Upload"

Select API PriceLevelItem, API PriceLevelItemOverwrite, or API PriceLevelItem SelectiveOverwrite

Browse to your file and upload.