How do I keep a clean SKU master across all sales channels?
A clean SKU master gives every product one code mapped to every channel listing, so stock, costing, GST and reports stay accurate as your catalogue grows.
Anadoris Digital · · 4 min read

Almost every inventory, costing and reporting problem in a D2C brand eventually traces back to the item master. Two codes for the same product split its stock. A missing HSN code breaks invoices. A combo created as a separate item instead of a kit means stock never reduces correctly. Fixing these one at a time is slow; preventing them is cheap.
A clean SKU master is the list of everything you sell and buy, with one record per item and rules for how new items are added.
What every SKU record should hold
- Internal SKU code that never changes and is never reused.
- Product name, variant and pack size written in a consistent pattern.
- Unit of measure for stock, and conversions for cases or cartons.
- HSN code and GST rate.
- Barcode, such as a GS1 GTIN where used.
- Batch and expiry tracking flag.
- Bill of materials or kit definition where relevant.
- Status: active, discontinued or blocked.
Design a coding pattern that lasts
SKU codes do not need to describe the product, but a simple pattern helps humans. A short brand or category prefix, a product number and a variant suffix is enough for most brands. Avoid encoding things that change, such as price or supplier, in the code. Avoid spaces and special characters, which cause problems in marketplace uploads and barcode labels.
Once a code is used, never change it or reuse it for a different product. Discontinue it and create a new one instead. History, reports and returns depend on codes staying stable.
Map channels to SKUs, not the other way round
Each channel has its own identifier: Shopify variant IDs, Amazon ASINs and seller SKUs, Flipkart listing IDs and FSNs, quick-commerce item codes. Store these as mappings on the internal SKU rather than creating a new item per channel. One SKU can have many mappings; each mapping points to exactly one SKU.
Where a marketplace listing represents a multipack or bundle, map it to a kit that consumes the right quantity of component SKUs.
Governance: who can change the master
Most duplicates come from well-meaning people creating items to finish a task quickly. Restrict item creation to one or two people. Use a simple request process for new SKUs, with required fields that must be complete before the item becomes active. Review changes to tax fields and units with your accountant.
SKU master health checklist
- No two active items describe the same physical product.
- Every active item has HSN code, GST rate and unit of measure.
- Every channel listing maps to exactly one SKU or kit.
- Combos and multipacks are kits, not standalone stock items.
- Discontinued items are marked, not deleted.
- Only named people can create or edit items.
- A monthly report lists items missing required fields and unmapped listings.
Cleaning up an existing mess
If your master already has duplicates, do not delete them. Pick the item to keep, move stock and mappings to it, block the duplicate and note what it was merged into. Do this before an ERP migration, not after, because migrating duplicates multiplies the problem.
Changing a GST rate or HSN code on an existing item affects future invoices only. Confirm with your CA whether any past invoices need correction.
Keeping channel listings in step
Listings drift from the master over time. Someone edits a title on a marketplace, creates a new variant directly on the website, or a marketplace merges two listings. Run a regular mapping report: every active listing on every channel with its mapped SKU, and every listing that is unmapped. Unmapped listings are a risk, because their sales will not reduce stock or appear in SKU reports.
Where possible, create new products in the ERP first and push them to channels, rather than creating them on a channel and importing later. That keeps the master as the starting point for every product.
Purchased items need the same care
The item master covers what you buy as well as what you sell: packaging, labels, raw materials, promotional inserts and consumables. Apply the same rules. Each component gets one code, a unit of measure and a clear description. Messy purchased-item records cause wrong BOMs, wrong costing and packaging shortages, even when finished goods look clean.
A good test of master health is whether a new team member can find the right item for any product or component in under a minute by searching the ERP. If they find two candidates, or none, the master needs work. Use that test after each clean-up round and whenever you onboard someone new to purchasing or the warehouse.
Where to start
- Export item lists from your ERP, website and every marketplace.
- Build one sheet that maps each listing to a single internal code.
- Mark duplicates and decide which code survives.
- Fill missing HSN, GST, unit and barcode fields.
- Restrict item creation and set up the monthly health report.
Anadoris Digital often starts ERP projects with exactly this clean-up, because a sound SKU master makes every later step simpler.
Related service: ERP Solutions · More on this topic: ERP Solutions articles
