Import Pricelist and Pricelist Items (Multiple)
Import Pricelists from Excel App for Odoo
This app allow you to import pricelists and pricelist items from excel file.
Main Features:
- Allow you to import pricelists from excel.
- Make sure you have xlrd Python libarary installed.
- Sample Excel is available inside sample folder inside module.
Menu:
- Sales
- Sales
- Products
- Import Pricelists
- Sales
Following fields can be Import From Excel Column.
- Pricelist ID : Pricelist ID for Pricelist.
- Pricelist Name : Name of Pricelist.
- Currency : Name of Currency.
- Apply On : Apply On for Pricelist Items.
- Product Category : When you're enter Product Category in Apply on column then you can compulsory put Product Category name.
- Product : When you're enter Product in Apply on column then you can compulsory put Product name or Product code or Product Barcode.
- Product Variant : When you're enter Product Variant in Apply on column then you can compulsory put Product Variant name or Product Variant code or Product Variant Barcode.
- Min. Quantity : Min. Quantity for Pricelist Items.
- Start Date : Start Date for Pricelist Items.
- End Date : End Date for Pricelist Items.
- Compute Price : Compute Price for Price Computation of Pricelist Items.
- Fixed Price : When you're enter Fix Price in Compute Price column then you can compulsory put Fixed Price.
- Percentage (discount) : When you're enter Percentage in Compute Price column then you can compulsory put Percentage (discount).
- Based On : When you're enter Formula in Compute Price column then you can compulsory put Based On.
- Price Discount : When you're enter Formula in Compute Price column then you can compulsory put Price Discount.
- Price Surcharge : When you're enter Formula in Compute Price column then you can compulsory put Price Surcharge.
- Rounding Method : When you're enter Formula in Compute Price column then you can compulsory put Rounding Method.
- Min. Margin : When you're enter Formula in Compute Price column then you can compulsory put Min. Margin.
- Max. Margin : When you're enter Formula in Compute Price column then you can compulsory put Max. Margin.
Make sure you have xlrd Python module installed. https://pypi.python.org/pypi/xlrd
For more details please see Video in Live Preview section. Excel sample is available inside module.