Hi all,
We accidentally uploaded product data from another store into our current D365 F&O environment, which created duplicate items with only one difference: the barcode.
Example:
0788821150202 (from another store)
0788821150202
788821150202 (our correct one)
788821150202
Same product name, but different prices and transactions. The wrong one is already linked to purchase/sales orders, so deletion isn’t possible.
Problems:
Duplicate SKUs
Wrong item used at POS
Pricing conflicts
Looking for advice on:
Merging or handling duplicates safely
Preventing this in the future
Keeping system clean without breaking references
Has anyone fixed this before? Any help would be appreciated.
Thanks, Ghulam Ahmed
To resolve the duplicates, deactivate the incorrect items by stopping them in all dimensions, renaming them (e.g., “Do Not Use”), and removing them from POS, catalogs, and price lists. Keep them for historical reference, but prevent future use. Enforce barcode uniqueness, validate all imports in a staging environment, and implement checks in your data templates to avoid similar issues as we advance.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 665 User Group Leader
Martin Dráb 595 Most Valuable Professional
Yng Lih 558
