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:
- ลูกค้าสัมพันธ์
- e-Commerce
- ระบบบัญชี
- สินค้าคงคลัง
- PoS
- โปรเจกต์
- MRP
คำถามนี้ถูกตั้งค่าสถานะ
1
ตอบกลับ
4224
มุมมอง
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
สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!
สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!
ลงชื่อ