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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
4503
Weergaven
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.
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
Aanmelden