Skip to Content
Dette spørgsmål er blevet anmeldt
importreorderingrulesv14
1 Svar
4552 Visninger
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
Kassér
Parker D
Forfatter

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

Avatar
Parker D
Forfatter Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
Many2many Fields
import v14
Avatar
Avatar
1
jul. 23
2842
Import button is missing Løst
import v14
Avatar
Avatar
1
apr. 23
8167
import in odoo 14 Løst
import v14
Avatar
Avatar
1
jun. 21
3183
Is there a shortcut to manually creating reodering rules?
reordering rules
Avatar
Avatar
1
apr. 20
4464
HR EMPLOYEE IMPORT ERROR
import employees v14
Avatar
Avatar
Avatar
Avatar
Avatar
4
jun. 25
6652