Odoo Help

0

How to import product from xls or csv file when this product has 3 different prices in 3 pricelists?

By
Pascal Tremblay
on 2/17/17, 8:48 AM 126 views

Hello there,

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


image




0

Pascal Tremblay

--Pascal Tremblay--
1512
| 5 2 7
Alma, Canada
--Pascal Tremblay--


Pascal Tremblay
On 2/17/17, 10:31 AM

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.

First 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

etc...


Second import

id_product_1; 9; pricelist2_name

id_product_2; 68; pricelist2_name

id_product_3; 34; pricelist2_name

etc...


Third import

id_product_1; 8; pricelist3_name

id_product_2; 9; pricelist3_name

id_product_3; 12; pricelist3_name

etc...


Your Answer

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

Question tools

1 follower(s)

Stats

Asked: 2/17/17, 8:48 AM
Seen: 126 times
Last updated: 2/17/17, 10:32 AM