I want to import product name, variant name, quantity on hand and warehouse name in products menu in inventory module in csv format. I am able to import product name and variant name but unable to import quantity on hand and warehouse name so that i can use these values in multiple records. Is there any solution for the above problem?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
3
Replies
18608
Views
1- Import product templates and variants and GET variant_id
2- Import an Inventory Adjustment
watch this video: https://www.youtube.com/watch?v=0Z_KtCe9HSk
if you have product_variant_id, use field name: Inventories/ Product/ Database ID
done!
The quantity on hand value is not in the same table as product templates and product variants.
I suggest that you perform two separate imports:
1- Import product templates and variants
2- Import an Inventory Adjustment
The second step might be a little complicated, I advise that you enter some demo data and the export them, and use the export file to import your new data after emptying it and keeping only the column titles in the first row of the exported file.
This way you will have a clear idea of what the database fields are and what fields are required.
watch this video - https://www.youtube.com/watch?v=0Z_KtCe9HSk
