Skip to Content
This question has been flagged
importreorderingrulesv14
1 Reply
3721 Views
Avatar
Parker D

Hello there 😀. I have two different warehouses with their own production each. Therefore I need two reordering rules for some products - one for each production site.

But when I import multiple rules for one product via a spreadsheet, the second rules overwrites the first one and in the end only one of two rules is imported.

Here is an example if my import file for testing:

id product_id location_id product_min_qty product_max_qty qty_multiple
__export__.stock_warehouse_orderpoint_91_26f98d3a [123]Prod 1
 F/Stock 1 2 3
__export__.product_product_44333_eb5d47f4 [123]Prod 1
O/Stock 4 5 6


In this case, only the second line gets imported.

What am I doing wrong? 🤔

Avatar
Discard
Parker D
Author

It would also help me, if some lovely Odoo ace would tell me that it is not possible... 😉

Avatar
Parker D
Author Best Answer

I got it myself. The trick is to add the external ID yourself. Just an unique ID like this:

External ID product_id uom_id location_id product_min_qty product_max_qty qty_multiple
RO_00001 [SKU 1]Produkt 1 m² A/Stock 0 0 1
RO_00002 [SKU 1]Produkt 1 m² B/Stock 80 120 1
RO_00003 [SKU 2]Produkt 2 Units A/Stock 200 1200 1
RO_00004 [SKU 2]Produkt 2 Units B/Stock 10 100 1
RO_00005 [SKU 3]Produkt 3 Units A/Stock 20 100 1
RO_00006 [SKU 3]Produkt 3 Units B/Stock 500 200 1


... or just 1, 2, 3...

I hope, that helps someone someday 😀

Avatar
Discard
Related Posts Replies Views Activity
Many2many Fields
import v14
Avatar
Avatar
1
Jul 23
2128
Import button is missing Solved
import v14
Avatar
Avatar
1
Apr 23
7449
import in odoo 14 Solved
import v14
Avatar
Avatar
1
Jun 21
2521
Is there a shortcut to manually creating reodering rules?
reordering rules
Avatar
Avatar
1
Apr 20
3777
HR EMPLOYEE IMPORT ERROR
import employees v14
Avatar
Avatar
Avatar
Avatar
Avatar
4
Jun 25
5741