Override existing pricelist lines using import

Question

I need to import a file with new prices. When I'm importing a file with columns like that:
pricelist external id | product external id | variant external id | fixed price

I adds new lines to the pricelist instead of changing the existing ones. I also tried to use pricelist line external id like this:
pricelist_line external id | fixed price
But this does not work at all. It says it is missing pricelist name because it actually wants to create new pricelist...
How do I do this? Pricelist managam

Sariyer Borekcisi · Answer

"id" (1. column in Paresh's answer) was sufficient for me. Also tick the box below while exporting:

Paresh Wagh · Answer

Hi Marcus:
You can export the existing lines in the Pricelist, update the prices in the spreadsheet and import the file back into Odoo. The file layout should look like so when you export the data.
*External ID, Pricelist Items/External ID, Pricelist Items/Product/External ID, Pricelist Items/Fixed Price*

相关帖文	回复	查看
How to bulk import new prices into a price list using an Excel template import pricelist	1 8月 25	488
How to import a new fixed-price price list from Excel? 已解决 import pricelist	3 10月 24	3762
new row for relation "res_partner" violates check constraint 已解决 sales import	4 12月 23	22683
¿How can i sell courtains by measure? sales pricelist	0 7月 20	2204
View all products in a pricelist in Odoo sales module sales pricelist	0 9月 19	3328

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！