I have a problem i follow your steps but after importing and asjusting with one single product it generates a new row with the counted quality i imported but the previous record appears in a totally different row the counted quantity is not in the row it is suppose to be. What am i doing wrong?
I have the same issue. Apparently, Odoo doesn't recognize a product based on product_id, which is basically the internal reference + the product name. Oddly enough, if you export the external ID of the product template, or of the stock adjustment and then try to re-import it with adjusted counted stock values, it yields an error.
What product ID are you importing? If you have product variants in your DB then you should import your products from the variant section not the product section
i have three products with same name but with different internal reference numbers and these three products are located in three rack locations. Assuming I want to use the Excel file to do bulk update, what are the headers to use to set the three products inside the three locations to ZERO?
The process is a bit different where you are using Warehouses and Locations. In that case each Location/Product combination will have a unique id that needs to be included in the upload template.
Thank you very much for this video ! I am using V17 and for some reason, I cannot find the right handle (name, display name, id, ...) how to link the counted quantity to the right product. #desperate
لما بيكون فيه كمية غير الصفر واضيف الكمية اللي انا عايزها بيجمع الكمية القديمة+الكمية الجديدة انا عايز اضيف الكمية الجديدة بس من غير الحركة دي ... أعمل ايه
thank you but i have a quastion if I have on hand ? how to add last on hand quantity ?
I have a problem i follow your steps but after importing and asjusting with one single product it generates a new row with the counted quality i imported but the previous record appears in a totally different row the counted quantity is not in the row it is suppose to be. What am i doing wrong?
I have the same issue. Apparently, Odoo doesn't recognize a product based on product_id, which is basically the internal reference + the product name.
Oddly enough, if you export the external ID of the product template, or of the stock adjustment and then try to re-import it with adjusted counted stock values, it yields an error.
What product ID are you importing?
If you have product variants in your DB then you should import your products from the variant section not the product section
HELLO I HAVE THE SAME PROBLEM, HAVE YOU FOUND A SOLUTION?
@@dxb_coder كيف ارجوك ؟
I have exactly the same problem, it will just add up the current stock with the new count instead of updating the number.
i have three products with same name but with different internal reference numbers and these three products are located in three rack locations. Assuming I want to use the Excel file to do bulk update, what are the headers to use to set the three products inside the three locations to ZERO?
You need to do it separately. Each location with a separate file.
You can do them in one file but the risk of an error to be generated is high.
The process is a bit different where you are using Warehouses and Locations. In that case each Location/Product combination will have a unique id that needs to be included in the upload template.
Yes indeed! What I suggest here is to create an inventory for each location where you can group the ids of location in each inventory.
@@dxb_coder I have uploaded a file to inventory adjustment and it is adding the counted quantity my on hand stock. How can i correct this.
@@dxb_coder Hi! Thank you very much for this tutorial. Do you have anything recorded to Import inventory using warehouses and locations?
@alevilarino7 hello...yes you can check my channel I already uploaded a video for that purpose.
Thank you very much for this video ! I am using V17 and for some reason, I cannot find the right handle (name, display name, id, ...) how to link the counted quantity to the right product. #desperate
I will post an inventory management for the 17 after two days
How to import product quantity with the same name but different category?
if you have two products with the same name ... in that case you have to use External ID field and not the name
@@dxb_coder Thank you so much ❤
لما بيكون فيه كمية غير الصفر
واضيف الكمية اللي انا عايزها
بيجمع الكمية القديمة+الكمية الجديدة
انا عايز اضيف الكمية الجديدة بس من غير الحركة دي ... أعمل ايه
انا عندي نفس سؤال ؟ حليت مشكلة ؟
اشكرك
لا شكر على واجب اخي العزيز