コンテンツへスキップ
メニュー
この質問にフラグが付けられました

When executing Inventory > Adjustments > Physical Inventory, the list only shows a few products (which are on hand). But all other (6000+ products) are not shown, so I cannot export, to adjust the 'counted' parameter, and re-import. Or is there another way to export-adjust-import inventory counts ? 


Help highly appreciated !

アバター
破棄
著作者 最善の回答

Dear Hamid, 

Thank you very much for your input ! Indeed, I need to export Product Variants, although I have no variants. Furthermore  I exported product_id/id , counted_quantity and added a unique id per product line in the import file. (e.g. Inventory1, Inventory2, ...)

If I import for the first time, it worked ! If I adjust again the counted_quantity , and not change the ID's (Inventory1, Inventory2) , I get an error. If I replace the ID's with a new unique ID, the products are duplicated, and in the end, one product gets an amount equal to the previous quantity, increased with the newly updated quantity. 

So, I am almost there... but not yet. Any suggestion ? 

Your help is highly appreciated !


Dirk 

アバター
破棄
最善の回答

It's not recommended to enter a quantity if there is currently no stock.  To create stock you should do a receipt (can be from a dummy supplier), or create a Purchase Order (also from a dummy supplier) and a receipt.

If you want to see all the inventory, create a new menu option for stock.quant and you can export / import from there.

アバター
破棄
最善の回答

Hi Dirk,

The adjustment list is not the list of the products. Export all your product variants and then with their external IDs add the required Location and the Counted Quantity and do the import.

Probably you will need to export your locations, too, if you have many locations. In this case, you should also use external IDs of the locations.

I hope it could help.

Regards,

Hamid - bitigloo GmbH

アバター
破棄
関連投稿 返信 ビュー 活動
1
7月 24
2546
2
6月 24
2229
2
5月 24
2745
2
4月 24
5508
1
7月 23
2782