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
- Účetnictví
- Sklad
- PoS
- Project
- MRP
This question has been flagged
1
Odpovědět
4508
Zobrazení
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Přihlásit se