Documentation Home »User Guide: Commerce »Pricing »Price Lists Management »Price Import and Export
current version

Price Import and Export

Export Prices From the Price List

Export option helps export the prices from the price list in the .csv file.

Example of prices bulk export template

Product SKU Quantity Unit Code Price Currency
sku_001 42 kg 100 USD

To export the prices in a .csv format:

  1. In the main menu, navigate to Sales > Price Lists and click the necessary price list to open its details.

    The following screen opens.

  2. Select the items to export using check boxes at the beginning of the corresponding rows. You can filter the list in the table header, if necessary.

  1. Click Export.

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

  2. Open the email and click the Download link.

    The file is automatically downloaded.

Import Prices Into the Price List

Import File option helps import a large bulk of product prices into the price list using the .csv file.

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 product prices:

  1. In the main menu, navigate to Sales > Price Lists and click the necessary price list to open its details.

  2. Click Import File on the top right.

  3. Click Choose File and select the .csv file you prepared.

  4. Click Export Template to download a sample .csv file with the necessary headers.

  5. Prepare data for import: Based on the downloaded file, create your bulk information in the .csv format. Once your file is ready, click Choose File and select the prepared comma-separated values (.csv) file.

  6. Select the strategy for uploading the file:

    • Add and Replace strategy overrides the existing prices with the ones mentioned in the file for the corresponding product item. Also, it adds new prices to the products with the empty values.

    • Reset and Add strategy removes all the existing prices and adds only the ones listed in the .csv file.

  7. Validate import results: Click Validate to check your import results. If there are any Records with errors, fix them in the .csv file before starting the import.

  8. Launch import: After successful validation, click Import File.

  9. Click Cancel to decline the import.

Important

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.

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.

Browse maintained versions:
current1.6

You will be redirected to [title]. Would you like to continue?

Yes No
ssossossosso