SA Retail Product Data Standardisation: Cleaning Up Catalogue Records
Inconsistent product data across POS, ERP, and ecommerce puts the wrong price on shelf and online, fails marketplace listings, and burns hours of merchandiser rework every week. Your retail catalogue cleanup is overdue.
We standardise the catalogue so one clean product record feeds every channel.
Sound Familiar?
These are the exact issues our clients faced before SKU standardisation:
- The same product carries three names across POS, Pastel or Sage, and the online store
- Duplicate SKUs split sales history, so merchandisers cannot trust which record to price
- Category codes do not match between store systems and marketplace feeds
- Takealot and other channel listings fail because barcodes or GTINs are missing or non-GS1
- Merchandisers burn evenings cleaning spreadsheets instead of planning assortment
Takealot now verifies GTINs upfront via Verified by GS1, and GS1 South Africa warns that barcodes from unofficial sellers are routinely rejected by Takealot, Checkers, and Food Lovers Market. Bad product data is no longer a back-office annoyance. It blocks listings and trading-partner trust.
What Product Normalisation Actually Does
Audit → golden record → write-back → channel-ready catalogue. No more spreadsheet archaeology.
Extract Every Master
Pull product records from POS, Pastel or Sage, and ecommerce into one comparison set
Match & Deduplicate
Cluster duplicate SKUs by GTIN, supplier code, and fuzzy name, then pick a golden survivor
Normalise Attributes
Standardise names, pack sizes, categories, and barcodes to one retail-ready schema
Publish Everywhere
Write clean masters back so shelf, web, and marketplace feeds share one product truth
Everything You Need for SKU Standardisation
Cross-System Catalogue Audit
We extract product masters from POS, ERP, and ecommerce, then score naming drift, duplicate SKUs, category mismatches, and barcode gaps in one view.
SKU Deduplication & Golden Records
Fuzzy and exact matching collapse duplicate SKUs into one golden product record with clear survivors, aliases, and a merge audit trail.
Naming & Attribute Normalisation
Titles, brands, pack sizes, and units of measure are standardised so shelf tickets, online listings, and ERP descriptions finally say the same thing.
Category & Taxonomy Alignment
Your internal category tree maps cleanly to channel taxonomies, cutting failed marketplace listings and broken navigation.
Barcode & GTIN Consistency
We flag missing, duplicated, or non-GS1 barcodes so Takealot, Checkers-style trading partners, and POS scans stop rejecting good stock.
Governed Write-Back
Approved golden records write back to the systems you nominate, with rules that block the next supplier import from recreating the mess.
Systems We've Standardised Catalogues Across
From 18% Duplicate SKUs to Under 1%
How a Gauteng multi-channel retailer cleaned 8,200 catalogue records and stopped wasting 13 hours a week on product data firefighting.
The Messy Catalogue
- POS, Pastel, Shopify, and Takealot feeds each held a different name for the same item
- About 18% of active records were duplicates or near-duplicates across systems
- Category codes drifted so marketplace loadsheets failed quality review
- Non-GS1 and missing barcodes blocked listings and confused till scans
- Three merchandisers spent ~40% of their week reconciling product spreadsheets
The Standardised Catalogue
- One golden product record feeds POS, Pastel, and channel listings
- Duplicate rate on active SKUs fell below 1%
- Names, pack sizes, and categories follow one agreed schema
- GTIN coverage repaired so Takealot submissions pass first-time checks more often
- Merchandisers review exceptions only, instead of rebuilding the master every week
Before vs After Catalogue Standardisation
How It Works
From first export to live golden records in 3–6 weeks for most mid-size catalogues.
Export & Score
We take product extracts from POS, ERP, and ecommerce, then score duplicate rate, naming drift, and barcode coverage.
Free Scoping Call
30-minute call to agree which system owns the master, merge rules, and which channels must receive the clean catalogue first.
Standardise & Review
We build golden records, normalise attributes and categories, and walk edge cases with your merchandising lead before write-back.
Publish & Guard
Clean masters publish across platforms. Optional intake rules keep new SKUs from recreating duplicate and barcode debt.
Frequently Asked Questions
What is SA retail product data standardisation?
It is catalogue master-data cleanup: fixing inconsistent naming, duplicate SKUs, mismatched category codes, and barcode or GTIN problems so one clean product record feeds POS, ERP, and ecommerce. It is not stock-on-hand repair. Inventory count discrepancies are a separate job.
How is this different from inventory discrepancy repair?
Inventory repair aligns units on hand across systems. Product data standardisation fixes the item master itself: names, SKUs, categories, and barcodes. If the catalogue is wrong, pricing, listings, and analytics stay broken even when counts match.
Will you overwrite live products without approval?
No. We stage golden records, show before-and-after packs for material merges, and only write back once merchandising or ops signs off. Historical sales stay linked via alias SKUs where your systems support them.
Which systems can you standardise across?
We routinely work with Pastel, Sage, Xero, Shopify, WooCommerce, Takealot loadsheet or feed exports, and custom POS or ERP catalogues. If you can export product masters by SKU (or give API access), we can audit, merge, and write back.
Do you handle GS1 and Takealot barcode rules?
Yes. We check for missing, duplicated, and non-GS1 barcodes that major SA trading partners reject, and we align GTIN fields so marketplace listings and POS scans use the same identifier. Official GS1 South Africa numbers remain the source of truth for licensed barcodes.
How much does product data standardisation cost?
Focused catalogue cleanup for a mid-size SA assortment typically starts from around R25,000. Multi-system SKU standardisation with category mapping, GTIN repair, and governed write-back usually ranges from R40,000 to R90,000. Most clients recover the cost inside one to three months once merchandiser rework and failed listings drop.
Stop Paying Merchandisers to Rebuild Product Data
If POS, ERP, and ecommerce still disagree on names, SKUs, and barcodes, you are funding a problem that product normalisation already solves.
Tell us which systems hold your product masters, how many active SKUs you run, and where listings or shelf tickets fail first. We will show you exactly how SA product data standardisation would work for your retail operation.