Good morning,
Starting from scratch, I have imported a lot of data into the product modules, using both the Dolibarr import facilities, and directly importing into the tables (using HeidiSQL) when there did not seem to be import facility for certain tables (it is possible I am just not able to see these import scripts).
- Entrepot
- Product (of course)
- Stock Warehouse → I used this to import the baseline products from where they would be dispatched to other warehouses
- product_lot
- product_batch
- stock_movement
Although I can see the stock movements OK, The stock at the main warehouse does not go down, even though the products have ‘gone’ to the other warehouses (I entered 2 records for each movement. E.g.:
rowid;tms;datem;fk_product;batch;eatby;sellby;fk_entrepot;value;price;type_mouvement;fk_user_author;label;inventorycode;fk_project;fk_origin;origintype;model_pdf;fk_projet
1;2025-02-10 09:58:27;2024-02-06 00:00:00;863;E232D302;\N;2026-05-31;110;-300;2.50000000;0;3;Sale Ref: 010056709-DM010028453;T10020612;0;0;\N;\N;0
2;2025-02-10 10:07:23;2024-02-06 00:00:00;863;E232D302;\N;2026-05-31;324;300;2.50000000;1;3;Sale Ref: 010056709-DM010028453;T10020612;0;0;\N;\N;0
)
What am I missing? Where am I going wrong?
Thank you in advance
