How to import multiple reordering rules per product?

Question

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_26f98d3

Parker D · Accepted 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

Gerelateerde posts	Antwoorden	Weergaven
Many2many Fields import v14	1 jul. 23	3850
Import button is missing Opgelost import v14	1 apr. 23	9278
import in odoo 14 Opgelost import v14	1 jun. 21	4097
Is there a shortcut to manually creating reodering rules? reordering rules	1 apr. 20	5290
HR EMPLOYEE IMPORT ERROR import employees v14	4 jun. 25	7952

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

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

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