How to Import / Export Product Pricing in CSV File

There might be plenty of planning for your upcoming promotions as well as updating the current outdated product pricing to ensure your product price is always up-to-date to compete with the competitors in this market. Worry not, we are giving you an alternative way here by using CSV export or import at the heart of effectively manage your product pricing.

Step 1: Export Product Pricing List
Step 2: Bulk Update Product Pricing in CSV
Step 3: Import Product Pricing List

Step 1: Export Product Pricing List

1. Navigate Products and then Products List.

2. Click on More and Manage Pricing.

3. Click More icon and choose Export.

4. Tick Export option and proceed with Export button.

5. Product Pricing will be downloaded in CSV file.

Step 2: Bulk Update Product Pricing in CSV

1. Open inventory.csv via Open Office. Download Open Office.

2. Ensure the settings are correct especially Character Set, Separator Options and Text Delimeter. Click OK button.

3. Update product pricing in Price (required) column.

Note: Each CSV import supports 1000 rows. If you have more than 1000 rows, please save it separately.

type(required): type of promotional discount and the value can either be Special or Discount only. (Note: Special stands for Customer Group Special Pricing whereas; Discount stands for Bulk Discount Pricing and it must be used in combination with Quantity(required).)

quantity(required): The minimum quantity purchase in order to get the Discount Price. (Note: If you are not giving Discount (type), this quantity column leave it as stated by default in the csv that you exported.)