How to import pricelists

Step 1: Access the Import Pricelist page.

You can access the Import Pricelist function by:

+ Clicking on the Import Pricelist button on the Supplier Pricelist page.

image-20240415-073417.png

Step 2: Import file

This is the Import Supplier popup

 

image-20240415-073442.png

 

First, you can click on Download button to download a sample csv file then fill in that file.

Field Name

Description

Supplier Code

  • The supplier code of the supplier

Product SKU

  • The product sku of the product

Minimal Qty

  • The minimal qty of the product

  • If the user does not fill in the

Minimal Qty field in the CSV, after importing successfully
-> The Minimal Qty of the product in the Pricelist page will be blank

  • If the product is turned on the qty decimal configuration on the Backend,

-> After the importation, automatically round to 4 decimal points if the user fills in the number with more than 4 decimal points

Cost

  • The cost of the product

  • If the user does not fill in the

Cost field in the CSV, after importing successfully
-> The Cost of the product on the Pricelist page will be blank

  • After the importation, automatically round to 2 decimal points if the user fills in the number with more than 2 decimal points

Start Date

  • The start date of the pricelist

  • Format in the CSV: yyyy-mm-dd

End Date

  • The end date of the pricelist

  • Format in the CSV: yyyy-mm-dd

After you have filled in the data for the supplier (must fill in all required fields).

After clicking on Select File button, the Select File popup will show, then you select the file you want to import.

 

After that, you can click on Import button. The data will be validated then imported.

 

 

If you import successfully, it will show message as below: