跳至内容
菜单
此问题已终结
1 回复
3722 查看

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 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 😀

形象
丢弃
相关帖文 回复 查看 活动
1
7月 23
2128
1
4月 23
7449
1
6月 21
2521
1
4月 20
3777
4
6月 25
5741