SKU codes for handmade jewellery: commissioning a simple catalogue without mix-ups

Define unique jewellery item codes, separate variants, protect customer information and test the catalogue before moving the whole stock.

Names and photographs are not enough for stock control

When several handmade earrings look similar, saying “the green pair” is unreliable across batches. Photos buried in messages can be hard to find later. List which distinctions matter when packing an order: material, colour, fastening, size, batch and condition. Use these to design a straightforward identifier, without embedding so many hidden details that the code becomes impossible to maintain.

Agree clear rules with the catalogue assistant

Give a stock organiser sample products, existing spreadsheets and examples of items that are easy to confuse. Ask them to propose rules for unique SKU assignment, correcting mistakes and recording variations. Decide what happens when a model is discontinued or already sold: deleting its record can destroy useful order history. Link every photograph to the correct item or version, not just the wider collection.

Keep customer and financial access separate

A person building product records may not need access to buyer contacts, payment systems or commercial accounts. Prepare a test list that contains no personal data. If the catalogue lives in a shared spreadsheet, grant only the permissions required for the task. Discuss how to back it up and export it before adopting any software. The business owner should still understand the system once the temporary assistant has left.

Test against everyday stock operations

Try finding a pair from its code, distinguishing two similar colours, marking a returned item and recording an unavailable product. If two codes open the same photograph with no explanation, the structure needs refinement. Check that material names match approved product information; do not add unverified claims about origins or properties. Only after these tests should the rest of the inventory be migrated.

Prevent duplicate and recycled codes

Manual entry can confuse similar characters or lead someone to reuse a number from a discontinued line. Agree how codes are reserved, how uniqueness is checked and when identifiers must never be reused. If an item is sold both individually and as part of a set, record the relationship explicitly so it is not counted twice. A convenient label is useful only if everyone applies it consistently.

An imaginary UK studio example

Imagine a handmade jewellery business in Sheffield with several closely related collections. Instead of asking a helper to enter everything at once, the owner commissions a small trial catalogue. During testing, the team discovers that two types of fastening must be kept in separate fields. This example is fictional and does not describe a review of any real software or service.

Find a practical helper through Match2Go

Not every maker needs a complicated inventory package; a well-managed spreadsheet with a backup may be enough. On Match2Go, specify whether you need data entry, a code scheme, product photography links or a complete stock workflow. Match2Go is a geosocial service built by people for people. It does not buy paid advertising and grows through personal recommendations. Tell friends and colleagues running small enterprises about it; the platform does not guarantee a particular provider or outcome.

Prepared with AI assistance; independent human editorial review has not been confirmed.