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

I'm trying to update more than 25 thousand reordering rules and I can't.

I am using a template with the following headers


product_id, id, product_max_qty, product_min_qty, route_id, location_id


but it sends me the message "the values of the fields "location_id, product_id, company_id" already exist


It's an emergency with a client, can someone help me?

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

Thank you very much for the contribution. I was able to solve it in the following way. First I checked the integrity of the data and cleaned it because there were some invalid values. The fields that are needed to upload new rules, which are not registered, are:

product_id, product_min_qty, qty_to_order, route_id, location_id


If it is about updating the existing ones, the fields are:

Id, product_id, product_min_qty, qty_to_order, route_id, location_id

But you have to be careful because if you have a product in 4 warehouses, 4 different IDs will be displayed and this can cause conflict.

In my case, I found the errors in:

“Dirty” input data

Id's incorrectly cataloged

Wanting to update more columns than just: product_id, product_min_qty, qty_to_order, route_id, location_id

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

I thinl it is because you do not have the xml id of the records. Then Odoo assume you want to add records.

Export the transctions and make sure you select the box "I want to update".  Then you get the XML id for each record.  

When import with your changes, only select the fields you want to update in additon to the xml id.

To make sure you get the correct id in fields you want to change, make sure that one record that you export have the correct value that you want to change to.

In the import wizard there on each related field there is also an option like "Create if not exist".  It should not be ticked.

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
1
thg 1 23
2344
3
thg 7 25
1571
2
thg 8 23
3010
1
thg 9 22
2326
3
thg 10 20
3055