Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
How to import product from xls or csv file when this product has 3 different prices in 3 pricelists?
I have, for example, 100 lines in a xls file for 100 products to import in odoo 10. Importation works well for the moment.
Each one product in the xls file has 3 differents different prices to put in 3 different pricelists. See image below for what we need.
I have created the Test product below, I exported it and the new file from this export has 3 lines for this only product Test... Not only one line.
So should my xls file have 300 lines instead of 100 lines? Should I import my 100 products 3 times each? Can we achieve this with only one line per product?
What is the easiest way to import product with many prices in different pricelists?
Thanks for your comment
Here is our easy solution. This is absolutely great!
The trick is to import 3 times the same xls file, just with some changes at each import.
external_id; Pricelist items/Fixed Price; Pricelist items/Pricelist
id_product_1; 4; pricelist1_name
id_product_2; 5; pricelist1_name
id_product_3; 6; pricelist1_name
id_product_1; 9; pricelist2_name
id_product_2; 68; pricelist2_name
id_product_3; 34; pricelist2_name
id_product_1; 8; pricelist3_name
id_product_2; 9; pricelist3_name
id_product_3; 12; pricelist3_name
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/17/17, 8:48 AM|
|Seen: 126 times|
|Last updated: 2/17/17, 10:32 AM|