When I try to import List of products categories in order to have products classified in categories I get an error: > Cannot add or update a child row: a foreign key constraint fails (demoerp2.erpd2_categorie_product, CONSTRAINT fk_categorie_product_product_rowid FOREIGN KEY (fk_product) REFERENCES erpd2_product (rowid))
First I imported products and then I created categories. After that I wanted to link products with categories.
What am I doing wrong?
I use Dolibar version 3.2.3
I’m not sure, but probably you should import the products with the category field already in.
How do I set that it is possible to import also with category field?
Do an export of a product with all fields and then you will see what fields are accepted for a product so you edit an csv file accordingly.
Thank you for your respond.
When I try to export products there is no category field in “Exportable fields” so I assume that it is also not possible to import Products with the category field already in.
Try to look directly into the database tables.
The field to store link between product and category is stored into another table.
Import will be available with 3.3.
Hi, I am trying 3.3.1.
The source fields and target fields are not correponding in the import process for products. Therefore the import process is not succesfull.
The field for Minim. selling price Net of tax is missing in the import list of products.
