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 |
ItemExternalID | item code |
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:
- 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
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.
0 comments
Please sign in to leave a comment.