Uploading a Price List Items file allows you to:
- Upload a file with prices for the items price list
- Overwrite prices in an entire price list
- Selective Overwrites to items in a specific price list
Before uploading the price list items, you must first define the price list in a file called Price List Information. This file also uploads the price list description and currency.
Create a CSV file with the following fields. Sample file is attached at the bottom.
|PriceListExternalID||ID/Code of the price list|
|Price||price of the item|
|Hidden||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.
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
Go to Settings -> ERP Integration -> File Upload and Logs -> Click "Upload":
Select API PriceLevelItem, API PriceLevelItem Overwrite, or API PriceLevelItem SelectiveOverwrite:
Browse to your file and upload.