Skip to Content
Menú
This question has been flagged

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

Avatar
Descartar
Best Answer

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

  • Counted Quantity
  • Location or Location/external id
  • Product or Product/external id

Second case would be

  • id
  • counted quantity

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.

Avatar
Descartar
Autor

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

Best Answer

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.

Avatar
Descartar
Best Answer

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,

Avatar
Descartar
Autor

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.

Related Posts Respostes Vistes Activitat
0
d’oct. 23
1472
5
d’oct. 21
17262
2
de març 25
3491
6
de nov. 24
47530
2
d’ag. 19
6141