Sale pricelist configuration.

Tick 'Import Sales pricelist'.

The import pricelist menu.

You can download a sample file by clicking on 'PRICELIST CSV FILE' or 'PRICELIST EXCEL FILE' button. You can apply a pricelist on the product, product variant & product category by name, internal reference number & barcode. You can apply import pricelist by Add sales pricelist or Update sales pricelist & price computation by fixed price. Apply price computation by Fixed price. Select the file which you want to import. Click on 'Apply' button.

You can apply price computation by percentage wise or discount wise.

You can apply price computation by formula wise(sales price, cost price or other pricelist).

Success message looks like below.

Pricelist tree view with imported pricelist.

Imported pricelist form view.

Your CSV file must looks like below.

Your Excel file must looks like below.

About Fields

---

Column	Product Model	Field Name	Description	Required
A	Pricelists (product.pricelist)	Unique Identification	You can identify the same name Journal Entry by "Unique Identification" field.	Yes
B	Pricelists (product.pricelist)	Name	You have to write a name here.	Yes
C	Pricelists (product.pricelist.item)	Applicable On	Define the Category/Product/Product Variant.	Yes
D	Pricelists (product.pricelist.item)	Min. Quantity	You have to write a Minimum Quantity here.	Yes
E	Pricelists (product.pricelist.item)	Start Date	Define the Start Date.	No
F	Pricelists (product.pricelist.item)	End Date	Define the End Date.	No
G	Pricelists (product.pricelist.item)	Fixed Price	You have to write a Fixed Price here.	No
H	Pricelists (product.pricelist.item)	Percentage Price	You have to write a Percentage Price here.	No
I	Pricelists (product.pricelist.item)	Rounding Method	You have to write a Rounding Method here.	No
J	Pricelists (product.pricelist.item)	Price Discount	You have to write a Price Discount here.	No
K	Pricelists (product.pricelist.item)	Minimum Margin	You have to write a Minimum Margin here.	No
L	Pricelists (product.pricelist.item)	Maximum Margin	You have to write a Maximum Margin here.	No
M	Pricelists (product.pricelist.item)	Price Surcharge	You have to write a Price Surcharge here.	No
N	Pricelists (product.pricelist.item)	Other Pricelist	Define the Other Pricelist.	Yes

General Notes:

---

1) Don't remove the column from the sample sheet given, you can leave an empty column if the column is not the required type. You can see the table above for that.

2) Don't change the sample sheet column sequence.

3) Please don't use excel if you don't know the very well sheet formatting which is given in the sample sheet. Use CSV for hassle-free import without format issue. If you want to use excel and want to clear the format then please check this video.
Watch Video