Price Import and Export¶
Export Prices From the Price List¶
You might need to export price information and download it as a .csv file to reuse it in the third-party systems. Another scenario for using export is when you plan bulk data update that is easily automated in the spreadsheet software (e.g. raise the price by 20%).
To export the prices in a .csv format:
Navigate to the Sales > Price Lists in the main menu and click on the necessary price list to open its details.
The following screen opens.
After the following notification, you will receive an email with the link to download the .csv file.
Open the email and click the Download link.
The file is automatically downloaded.
Example of the exported information
Product SKU Quantity Unit Code Price Currency 0RT28 1 item 89.99 USD 0RT28 10 item 85.49 USD 0RT28 20 item 80.99 USD 0RT28 50 item 76.49 USD 0RT28 100 item 71.99 USD 1AB92 1 item 85.5 USD 1AB92 20 item 76.95 USD 1AB92 50 item 72.68 USD 1AB92 100 item 68.4 USD 1GB82 20 set 16.19 USD 1GB82 100 set 14.39 USD 1GS46 1 item 22.49 USD 1GS46 20 item 20.24 USD 1GS46 50 item 19.12 USD 1GS46 100 item 17.99 USD 1TB10 1 set 270 USD 1TB10 10 set 256.5 USD 1TB10 20 set 243 USD 1TB10 50 set 229.5 USD 1TB10 100 set 216 USD
Import Prices Into the Price List¶
To streamline adding a large bulk of items, like customer information, products, prices or inventory information, you can import the bulk details from a .csv file.
Import the product prices into the price list using the .csv file that follows the price details data structure.
Example of prices bulk import template
|Product SKU||Quantity||Unit Code||Price||Currency|
The unit and currency should be created before the inventory levels import.
To import a bulk of price information:
- Navigate to the Sales > Price Lists and click on the price list which you would like to update using the bulk import.
Get a sample: To download a sample .csv file with the necessary headers, click Download Data Template in the list next to Import.
Follow the on-screen guidance for any additional actions. For example, for the inventory template, select one of the options: a) inventory statuses only or b) detailed inventory levels.
Prepare data for import: Based on the downloaded file, create your bulk information in .csv format. Once your file is ready, click Import, select the prepared comma-separated values (.csv) file, and click Submit.
Validate import results: Review import validation results. If there are any Records with errors, fix them in the .csv file before starting the import.
Launch import: After successful validation, click Import.
Interactive status messages inform about the import progress, and once the import is complete, the changes are reflected in the list upon refresh. Additionally, an email message with the import status is delivered to your mailbox.
See this two-minute demo of the import process: