Creating Standardised SKUs for Wholesale Commercial Cleaning Supplies So Sites Stay Consistent

Australian wholesale cleaning catalogues break down in predictable ways: duplicate items across supplier feeds, inconsistent pack sizes, and “same product, different code” across sites. Standardised SKUs solve this by giving every sellable unit a single internal identity that stays stable across ecommerce, ERP, warehouse picking, and procurement uploads.

A good SKU system is not a barcode standard. It is your internal control layer that makes inventory tracking and product discovery dependable, even when suppliers change names, part numbers, or packaging.

Define A Single Product Truth Before You Mint SKUs

Choose The Master Identifiers You Will Accept And Store

Start by separating what you control from what you inherit when deciding which master identifiers to accept and store. While the GTIN is the global trade item identifier used in barcodes and product identity systems, the SKU is your internal identifier for each sellable unit and is handled within your own systems. Australian procurement reporting and tender categorization, including AusTender, employ the standard classification structure provided by UNSPSC codes.

GTINs should be kept wherever they are, even if your company does not actively use barcodes. GS1 specifies the GTIN as a product identification number and associates it with a standardized set of product data, like weight and size, that may be exchanged and maintained across systems. GS1 Australia's Verified by GS1 program provides a useful standard for essential product qualities, assisting in the reduction of errors and duplication in product listings for companies that serve marketplaces or clients with stringent master data needs.

Decide What Counts As A Unique Sellable Unit

You need a hard definition of a sellable unit, otherwise you will mint SKUs that should never exist. A sellable unit needs a new SKU when any change affects ordering, receiving, storage, picking, or customer expectations. In wholesale commercial cleaning supplies, the usual triggers are:

Pack quantity changes (6 bottles vs 8 bottles)
Net volume or net weight changes (1 L vs 5 L)
Concentration or strength changes (ready to use vs concentrate)
Fragrance or formulation changes that alters the product’s purpose or compliance profile
Compatibility changes for dispensers, pads, filters, or machine parts

Pack size discipline is not optional. Australia’s trade measurement laws regulate pre-packaged goods by quantity and require accurate measurement markings. The National Measurement Institute guidance explains obligations for correct labelling and accurate stated quantities, including the net content rules and sampling expectations.

Lock The Minimum Attribute Set That Drives Findability

Inventory control and product discoverability must be addressed as a single issue in order to lock in the minimum attribute set that drives findability. Both depend on a uniform set of characteristics that enable systems and people to swiftly and precisely differentiate things.

The brand, product family (such as cleaner, disinfectant, hand soap, bin liner, paper towel, mop head, dispenser, or squeegee), and a clear variant driver (such as fragrance, color, material, or compatibility) are a practical minimum for basic commercial cleaning products. Along with UNSPSC coded at a reasonable level for procurement users, it should also provide pack quantity, unit size expressed as net volume or net weight where applicable, the unit of measure, and the GTIN when available.

Although not required for all companies, UNSPSC closely resembles the classification of purchases in Australian public procurement. UNSPSC is especially pertinent for providers serving public sector clients because the Australian government specifically employs it in procurement scenarios.

Build A SKU Syntax That Scales Across Categories And Variants

Segment Rules That Prevent Collisions And Make Codes Predictable

SKU codes should be reliable, distinct, and predictable so that systems can reliably validate them and people can recognise them. Fixed segments divided by a single delimiter, such as an underscore, that is straightforward and secure across systems are a powerful strategy for wholesale settings.

Although this is a conceptual sample rather than a necessary format, typical segments could include a category code, product family code, variant code, pack code, size code, and a check digit or sequence. Stability is more crucial than embedding. When marketing renames a line or a supplier merges items, SKUs may break due to over-encoding meaning.

Lifecycle Rules For Replacements Discontinued Lines And Supplier Changes

Most catalogue inconsistency comes from lifecycle events, not day 1 setup. Adopt these controls:

Never reuse a SKU, even after discontinuation.
When a supplier replaces a product, decide whether it is a true replacement or a new product. If performance, formulation, net content, or compatibility changes, assign a new SKU and link the old SKU as replaced.
Keep supplier part numbers as references, not keys. Supplier part numbers change often and collide across suppliers.

For industrial chemical products and ingredients, understand the regulator landscape. AICIS is the national regulator for import and manufacture of industrial chemicals. Cleaning products can sit inside that broader category depending on composition and intended use, so your product records should be able to store regulatory context and supporting documents without SKU churn.

Convert Supplier Catalogues Into Your Standard Without Losing Traceability

Supplier Intake Template And Validation Checks Before Import

Treat supplier feeds as raw material. Your goal is to normalise into a consistent master format and only then assign SKUs.

Use a single intake template for every supplier. At minimum it should capture: supplier name, supplier part number, product name, pack quantity, unit size, unit of measure, GTIN, and a short description. Then run a validation pass before anything goes live. One controlled checklist is enough:

Confirm pack quantity and unit size are present and consistent.
Confirm unit of measure matches the product type, for example litres for liquids, kilograms for powders, rolls for paper.
Confirm the product name contains the differentiator, for example “concentrate” or “ready to use”.
Capture GTIN when supplied and store it.
Assign UNSPSC at the family or class level where it helps procurement matching.
Check for duplicates using GTIN and a normalised name plus pack and size.

Normalise Units Pack Quantities And Product Names For Search

This is where the National Measurement Institute guidance becomes operational, because wholesale catalogues often inherit messy quantities. The same item will appear as 5 L, 5000 ml, or 5 litre. Your normalisation layer should store a canonical unit and a display value, but search should resolve them to a common value for filtering and comparison.

For chemicals, store both the selling unit and a derived “use unit” if relevant, for example a 5 L concentrate that dilutes at a ratio. Do not encode dilution ratios into the SKU. Keep it in attributes for discovery and comparison.

Deduplicate And Maintain Cross References For Legacy SKUs And GTINs

Deduplication aims to keep one internal SKU for every item that can be sold, even if there are several IDs available in the market. Organisations should have a cross-reference table that connects the internal SKU to the GTIN, supplier part number, and any historical SKUs that are still in use on older systems or locations in order to accomplish this.

By mapping new goods back to the current internal SKU instead of generating new codes, this method avoids site drift during relaunches, platform migrations, or supplier onboarding. GS1 Australia highlights the significance of barcode compliance with requirements to enable dependable scanning when barcodes are used in warehouses, as failures result in human entry and inefficiencies. This emphasises how important it is to keep precise GTIN and barcode information next to every SKU.

Governance And Metrics That Keep Every Site Aligned

Ownership Approval Workflow And Change Control

Ownership, approval processes, and change control are crucial since consistency is ultimately a governance issue rather than just a data problem. A single product data owner should be assigned by each organisation to oversee SKU creation guidelines, keep a change log for any master record modifications that impact ordering or product discovery, and implement a controlled request procedure for adding new products or replacements.

Safety data sheets must be handled properly as part of governance for chemical products. Safe Work Australia emphasises the significance of systems that provide compliant documentation and controlled updates across sites, emphasising the necessity of regular SDS review cycles and compliance with Australian work health and safety criteria for importers.

Inventory Control Outcomes To Track Stock Accuracy Pick Errors And Write Offs

Pick a small set of metrics that show whether standardised SKUs are paying off:

stock accuracy by SKU
pick error rate by SKU
write offs linked to misidentification or wrong variant
duplicate SKU count in the master catalogue

If you also use standard identifiers and automation, there is precedent for meaningful savings from reducing manual entry and improving data integrity. A NIST summary of GS1 standards case studies includes an Australia related supply chain example where automation reduced manual entry errors and delivered savings and material reductions in manual labour.

Discoverability Outcomes To Track Site Search Filters And Procurement Matching

Because product discovery is quantifiable and may be enhanced with the correct data, discoverability outcomes should be actively monitored throughout site search and procurement matching. The percentage of searches that provide no results, the frequency with which users narrow their searches using criteria like size, pack, or compatibility, the quantity of duplicate product pages, and the success of procurement matching when consumers search by UNSPSC or GTIN are all important indications.

Supporting procurement visibility and e-commerce classification is a major function of UNSPSC. According to Australian government materials, UNSPSC is an effective buying and selling classification system that, when used regularly, can lessen procurement friction for consumers who base their search and purchase decisions on these codes.

SKU Versus GTIN Versus UNSPSC

Identifier	What It Does	Who Controls It	Why It Matters For Cleaning Supplies
SKU	Internal identity for a sellable unit	You	Inventory accuracy, picking, site consistency
GTIN	Global trade item identification used in barcodes	Brand owner that allocates GTINs	Fast receiving, fewer duplicates, easier marketplace and customer matching
UNSPSC	Classification code	Standard plus your chosen assignment	Procurement search, tender categorisation, spend visibility

FAQ

What is the difference between a SKU and a GTIN?

A SKU is your internal code for a sellable unit. A GTIN is a globally recognised product identifier used in barcodes and shared product data systems.

When does a new pack size need a new SKU?

When the pack quantity or unit size changes in a way that affects ordering, receiving, storage, picking, or customer expectations. Trade measurement requirements reinforce why net quantity accuracy matters.

Should cleaning chemicals have different SKU rules than paper and equipment?

The SKU structure can stay consistent, but chemicals need stronger attribute governance around SDS and regulatory fields so compliance updates do not force SKU changes.

How do you stop different sites creating duplicates for the same product?

Centralise SKU creation, enforce an intake template, and deduplicate using normalised name plus pack and size, with GTIN where available.

Is UNSPSC worth using for wholesale cleaning catalogues?

If you sell to organisations that buy through procurement workflows or reference tender categories, yes. It is used in Australian government procurement categorisation and is widely recognised in that context.

What is the fastest win if your catalogue is already messy?

Build the cross reference table and stop creating new SKUs during migrations. Map every supplier line to a single internal SKU, then clean naming and units progressively.

Sources:

Back to blog