Every time the same database is imported, the seller_ids/id is duplicated. Importing a blank id does no wipe out the data in the system, there is a very big mess in my database now and I do not want to manually delete them one by one for each product, what solution is there?
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
1
Reply
3756
Views
Fixed this myself:
#1 - Delete all products #2 - Export all products, find actual last sequence number #3 - Go into PSQL <database>, restart sequence product_product_id_seq, product_template_id_seq, product_supplierinfo_id_seq #4 - Re-import products without external id.
All products are populated properly with only one supplierinfo.