I have file excel products and have imported them into the inventory.
Now i want to import the number of products into all products, but when i import the error "insert or update on table" stock_inventory_line "violates foreign key constraint" stock_inventory_line_product_id_fkey "DETAIL: Key (product_id) = (134) is not present in table "product_product". "
the xls file to add products:
| name | Barcode | Description | Internal Reference | ||
| Xoai | 0001 | Xoai loai I |
| ||
| Oi | 0002 |
|
the xls file to add qty:
| name | line_ids/product_qty | line_ids/location_id/id | line_ids/product_id/id | line_ids/product_uom_id/id | |||
| Update | 20 | stock.stock_location_stock | __export__.product_template_134_6248f021 | product.product_uom_unit | |||
| 50 |
|
|
|
How i fix it? Thanks
