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

Question

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 10

Pascal Tremblay · Accepted Answer

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

المنشورات ذات الصلة	الردود	أدوات العرض
Price List imports تم الحل import csv pricelist	7 أكتوبر 23	14041
error product import product import csv	1 سبتمبر 19	3748
Cannot see imported products product import v7 csv	3 يوليو 19	7238
Import product and supplier using CSV تم الحل product import csv supplier	5 ديسمبر 23	18075
What should be used in "seller_ids" field to specify a given supplier while importing products? Is it possible to use the "external id"? product import csv supplier	2 مايو 15	7168

لقد تم الإبلاغ عن هذا السؤال

image

The trick is to import 3 times the same xls file, just with some changes at each import.

First import

Second import

Third import

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!