Start with the practical question
A small, carefully maintained register helps connect product descriptions with the labels and records used by your team. It can begin as a spreadsheet without becoming a large database project. The aim is to make differences visible and preserve decisions, rather than to build a complicated system before you know what information is needed.
Choose a record that people can recognise
Start with a stable internal reference and a precise product description. Add fields for brand, variant, declared quantity, unit of measure and packaging level. Record what is actually specified on the product rather than estimating it from an old photograph. A named person should be responsible for confirming uncertain entries and recording when the information was checked.
In an illustrative Bulawayo business, a single jar and a case containing several jars may both appear on a stock list. Give them separate descriptive rows in your training register so the team can distinguish what is ordered and handled. This is an organisational example, not a determination of which identifiers your products require. Consult the applicable identification standard and trading partner before assigning numbers.
Add a source for each identifier
When an identifier is confirmed, record its full value as text and include the source document reference. Keeping identifiers as text helps avoid a spreadsheet treating them as quantities. Check imported values against the source instead of assuming that a displayed cell preserves every digit exactly. Record uncertainty explicitly if a historic file contains a shortened or unexplained entry.
Use a separate field for the internal stock reference. Do not rename every internal code GTIN just to make a sheet look consistent. The distinction matters when someone exports a file for a retailer or supplier. Add a short field description at the top of the register so a new colleague does not need to guess what a heading means.
Connect the artwork to the record
Add the approved artwork filename, version and approval date. Keep a link or path to the actual file in a shared location your team can access. A filename such as final-new-latest does not explain which product or packaging version it represents. Agree a simple naming convention that combines your internal reference with a controlled version label.
Keep superseded files separately and mark their status. If a designer sends a revision, compare the encoded value and visible product description with the register before replacing the approved file. Do not overwrite the old approval evidence. The purpose is to preserve the relationship between a product decision and the file that implements it.
| Field | Illustrative entry | What to confirm |
|---|---|---|
| Internal reference | TRAIN-SOAP-A | Training reference, not a GTIN |
| Description | Unscented soap, single unit | Actual approved product specification |
| Identifier source | Awaiting confirmation | Allocation and permitted use |
| Artwork version | Training proofA | Approval and matching packaging level |
Practise a small review
Ask someone who did not build the sheet to find one product, its packaging level, the identifier source and the approved artwork. Note any ambiguity they encounter. Correct the field definitions before extending the register to the whole range. A useful register is one another person can navigate reliably, not one with the largest number of columns.
Review access and backup arrangements alongside the data. Keep customer information and unrelated personal documents out of a product-identification workbook. This register supports an orderly workflow, but it does not establish that an identifier is validly allocated or that a receiving retailer has accepted the item.
Sources & further reading
Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.
This guide is general information. Source notes are not a claim of independent professional review.