ssossossosso
Documentation Home »User Guide »Pricing »Create a Price List »Price Import and Export
current version

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:

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

  2. Click Export.

    After the following notification, you will receive an email with the link to download the .csv file.

  3. 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
sku_001 42 kg 100 USD

Note

The unit and currency should be created before the inventory levels import.

To import a bulk of price information:

  1. Navigate to the Sales > Price Lists and click on the price list which you would like to update using the bulk import.
  1. Get a sample: To download a sample .csv file with the necessary headers, click Download Data Template in the list next to Import.

    Note

    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.

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

  3. Validate import results: Review import validation results. If there are any Records with errors, fix them in the .csv file before starting the import.

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

Browse maintained versions:
current1.4