Duplicate products in odoo 17 and 18

Question

"You discovered that several products have been accidentally duplicated in the Odoo database (same name, category, and UoM but different internal references). How would you identify and fix the duplicated products while ensuring historical data (e.g., sales, purchases, inventory) is not lost?"
if you know how to fix this please answer it?

Ujjwal Basnet · Answer

the best option would be to archive the duplicate products; in my case, I archived all the duplicate products by adding '(archived)' at the end of each product name (e.g., 'Apple (archived)'); this helps avoid confusion in the future when extracting inventory reports and also archived items will not appear in products lists or reporting → stock but they will still appear in operations → physical inventory
in some cases of scenarios

İlgili Gönderiler	Cevaplar	Görünümler
Disallowing picking materials not in sales order / disable ability to add new lines during picking and packing in v18 Inventory	0 Şub 25	1220
How to avoid processing the same inventory movement in parallel? Inventory	1 Şub 24	2160
Simple Inventory for Office Consumables Inventory	1 Oca 24	1610
Unable to sort by "Last Count Date" in the Inventory Adjustments screen Inventory	0 Ağu 23	1612
Odoo Inventory complies with Annex 24 and 31??? Inventory	0 Haz 23	1428

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!