Skip to Content
āđ€āļĄāļ™āļđ
āļ„āļļāļ“āļ•āđ‰āļ­āļ‡āļĨāļ‡āļ—āļ°āđ€āļšāļĩāļĒāļ™āđ€āļžāļ·āđˆāļ­āđ‚āļ•āđ‰āļ•āļ­āļšāļāļąāļšāļ„āļ­āļĄāļĄāļđāļ™āļīāļ•āļĩāđ‰
āļ„āļģāļ–āļēāļĄāļ™āļĩāđ‰āļ–āļđāļāļ•āļąāđ‰āļ‡āļ„āđˆāļēāļŠāļ–āļēāļ™āļ°
1 āļ•āļ­āļšāļāļĨāļąāļš
3895 āļĄāļļāļĄāļĄāļ­āļ‡

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? ðŸĪ”

āļ­āļ§āļ•āļēāļĢ
āļĨāļ°āļ—āļīāđ‰āļ‡
āļœāļđāđ‰āđ€āļ‚āļĩāļĒāļ™

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

āļœāļđāđ‰āđ€āļ‚āļĩāļĒāļ™ āļ„āļģāļ•āļ­āļšāļ—āļĩāđˆāļ”āļĩāļ—āļĩāđˆāļŠāļļāļ”

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 😀

āļ­āļ§āļ•āļēāļĢ
āļĨāļ°āļ—āļīāđ‰āļ‡
Related Posts āļ•āļ­āļšāļāļĨāļąāļš āļĄāļļāļĄāļĄāļ­āļ‡ āļāļīāļˆāļāļĢāļĢāļĄ
1
āļ.āļ„. 23
2298
Import button is missing āđāļāđ‰āđ„āļ‚āđāļĨāđ‰āļ§
1
āđ€āļĄ.āļĒ. 23
7640
import in odoo 14 āđāļāđ‰āđ„āļ‚āđāļĨāđ‰āļ§
1
āļĄāļī.āļĒ. 21
2685
1
āđ€āļĄ.āļĒ. 20
3944
4
āļĄāļī.āļĒ. 25
5968