One Product, Three Records

A product is created once, then copied: into the ERP by operations, into the website by merchandising, into a marketplace feed by the channel team. Each copy gets its own title, its own identifier and its own attribute names. A variant gets listed as a new SKU. A UPC is missing from one feed. The colour is in the title in one system and in an attribute in another.

To a person these are obviously the same product. To software they are three. Inventory is split across them, so a product shows out of stock in one channel while it sits in the warehouse. Prices drift apart between channels. Reviews and ratings are spread over “different” listings, and sales reports undercount your best sellers.

Teams patch this with lookup spreadsheets and exact matches on whatever code happens to be shared. It works until a code is missing or wrong, and it has to be redone for every new channel and every new supplier.

Match product records across every system on everything that identifies them: codes like UPC and GTIN where they exist, and titles, brands, models and attributes where they do not. Group each product’s records under one stable ID and build a golden record from the best values in each.

Then let every system and report use that ID. Inventory, pricing, sales and reviews roll up to the real product, and a new listing or supplier feed joins the product it belongs to instead of creating another one.