Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
2 Trả lời
4022 Lượt xem

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 managament in Odoo is really painful.

Using Odoo 13


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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


Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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


Ảnh đại diện
Huỷ bỏ
Tác giả

This way it tries to create new pricelists instead of changing existing lines

I have tried it and it works as expected i.e. it updates existing lines and does not create new lines.

You need the Pricelist Items/External ID field in your file for the lines to be updated. If this field is missing it will create new lines.

"id" (1. column) was sufficient for me. Also tick the box below while exporting:

Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 8 25
531
3
thg 10 24
3782
4
thg 12 23
22723
0
thg 7 20
2227
0
thg 9 19
3343