I want to update my current products in Oddo by uploading a database from excel sheets or similar. In Odoo I already have the category ID and SKU and HCPC for each product. I would like to upload an excel file with SKU or ID and then Odoo or adds HCPC to Odoo based on that excel file.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
4227
Views
Hi,
Export the products as an excel or csv from odoo, just only export the product name and once you import you will be getting external id of the products in the sheet, copy paste the data that you need to import to this exported sheet and import the updated sheet to the database. Then based on the external id, odoo will update the existing records in the db.
Thanks
I have 100 000 products in my Odoo database. I want to update product data for all these products by using default code or barcode as key. Exporting this amount of products to Excel and manually editing each row and then importing the file back is not a viable option in this case.
I have an excel sheet with two columns: barcode and standard price. I just want to update this standard price to all products by using barcode as key.
Is there a proper method to do this or should I find a helper module from app store?
Thank you very much for this great information. Keep moving
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up