Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
1 Rispondi
3735 Visualizzazioni

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
Abbandona
Autore

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

Autore Risposta migliore

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 A/Stock 0 0 1
RO_00002 [SKU 1]Produkt 1 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
Abbandona
Post correlati Risposte Visualizzazioni Attività
1
lug 23
2133
1
apr 23
7458
1
giu 21
2524
1
apr 20
3786
4
giu 25
5763