How to update reordering rules in bulk?

Question

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?

Jorge Ojeda · Accepted Answer

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 h

Lars Aam · Answer

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 wiz

関連投稿	返信	ビュー
Reordering Rules SNOOZE not Working. ReorderingRule reordering-rules	1 1月 23	2410
0/0/1 Replenishment rule not available in version 18 ? ReorderingRule	3 7月 25	1710
Reordering rule to specific location not working V16.0 reordering-rules	2 8月 23	3148
Reodering Rules, how to set them up correctly? 解決済 ReorderingRule	1 9月 22	2411
Automatic Reordering based on sales etc (moving average method)? ReorderingRule	3 10月 20	3144

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！