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:
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.