Odoo Help


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

Pascal Tremblay
on 2/17/17, 8:48 AM 1,721 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



Pascal Tremblay

--Pascal Tremblay--
| 5 3 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


Second import

id_product_1; 9; pricelist2_name

id_product_2; 68; pricelist2_name

id_product_3; 34; pricelist2_name


Third import

id_product_1; 8; pricelist3_name

id_product_2; 9; pricelist3_name

id_product_3; 12; pricelist3_name


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.


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)


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