I have tried to make an inventory adjustment with a csv file, however when I upload the file Odoo doesn't find the product_id because the product I want to change its quantity is actually a product variant.
How can make an inventory adjustment for a product variant with a csv file
There are two scenarios when you are importing inventory adjustment
1. The product you want to import is zero at the location
2. The product exists or has quantity at the location
In the first case the there is no record of that product so the field you would need to import are
Second case would be
In the first case, which i believe is also your case, I prefer you use the external id of the products. If you choose to use the name however, it must match the exact same way odoo displays names of product.product (product variants) i.e "[internal ref] name (variant)". Using the exernal id is just better, easier and safer honestly
In the second case you need the id of the record in the "inventory adjustment module" to just update the counted quantity so make sure your csv file does not have products in a location that already exist in the model.
Let me know if it dosent work.
Hello, thanks for your answer!!
When I tried to import using the external id of product.product it doesn't recognize the field from the CSV it seems only let me use the product "name":
This what it displays
No matching records found for the following name in field Product:
__export__.product_product_2406_5324cd43 at row 2
__export__.product_product_2407_bf353a7e at row 3
__export__.product_product_2408_d14d1193 at row 4
Using the product variant name doesn't work neither, I downloaded the exact name of the product.product_id but it is the same error "No matching records"
Do you thing I am making a mistake? or how can I import the product variant on inventory adjustment
You're trying to to import the ids to the product field. Use the "product/external id" field
The module named "VKS Import Excel" can help you solve this problem easily: https://apps.odoo.com/apps/modules/16.0/vks_import_excel.
Please contact me via email anhtuan.acoi@gmail.com if you need further assistance.
Hello,
You have Imported the product_id that for product only but you want to import product variant so for that import product variant external id that is product.product_id like this external id you can import from sales module -> product menu -> product variant tab in that then you can import data of product variant name wise and also external id wise then try to import data in inventory adjustment because here system considers the product_id as variant at the time of inventory adjustment import.
Thanks,
Hello,
I tried this, but when importing the product variant name or its external id as the product_id on the inventory adjustment it only shows "No matching record" wether I use the name or external ID I get the same result.
Opret en konto i dag for at få glæde af eksklusive funktioner, og bliv en del af vores skønne fællesskab!
Tilmeld dig| Relaterede indlæg | Besvarelser | Visninger | Aktivitet | |
|---|---|---|---|---|
|
0
okt. 23
|
3206 | ||
|
5
okt. 21
|
19993 | ||
|
2
mar. 25
|
5838 | ||
|
6
nov. 24
|
54490 | ||
|
2
aug. 19
|
8277 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
