Hi All,
How do we import the initial product stock quantity?
Which folder and file should I refer to?
Thanks!
@ZeeshanAhmad I am reviewing the demo csv and config.xml file and couldn’t find related file to import product qty.
Thanks
Maybe the stock_inventoryLine.csv file in the axelor-stock module ?
"inventory.importId";"product.importId";"currentQty";"realQty";"description";"productVariant_importId";"trackingNumber.importId"
1;111;"0.00";"300.00";;;
1;110;"0.00";"35.00";;;
1;120;"0.00";"40.00";;;
1;121;"0.00";"300.00";;;
1;130;"0.00";"150.00";;;
1;131;"0.00";"100.00";;;
1;200;"0.00";"100.00";;;
1;201;"0.00";"50.00";;;
1;210;"0.00";"80.00";;;
1;211;"0.00";"70.00";;;
1;220;"0.00";"300.00";;;
1;230;"0.00";"260.00";;;
1;231;"0.00";"190.00";;;
1;240;"0.00";"130.00";;;
1;241;"0.00";"90.00";;;
1;250;"0.00";"130.00";;;
1;300;"0.00";"500.00";;;
1;301;"0.00";"500.00";;;
1;302;"0.00";"600.00";;;
1;303;"0.00";"400.00";;;
1;304;"0.00";"290.00";;;
1;305;"0.00";"70.00";;;
1;306;"0.00";"100.00";;;
1;307;"0.00";"200.00";;;@PakMax Have tried that but the « real quantity » does not show. I believe it should show up in Products - Real Quantity and the « Stock Move Lines » will show too. Both modules did not reflect any changes of such.
Thanks.
@PakMax @ZeeshanAhmad
Thanks and the help and found the method to import.
-
Use « stock_inventory.csv » to create a new entry with new ID. To avoid using the axelor demo « 1 » ID.
-
Use " stock_inventoryLine.csv" to import and map to the inventory.ID
-
Go to Inventories → Select the inventory line → Redo the phases till Validated.
It must be validated or re-validated to trigger stock move lines.
Still trying to understand what is « Future qty ».
(Been looking at the wrong place as mistook « stock move line » with « inventory lines »)
-
Go to « Purchase → Products and Services »
Select the edited product quantities and it should be reflected there.
1 J'aime