RESELLER GUIDES / SKU SETUP

A SKU system you can still understand next month.

Your SKU identifies the item. Its storage location tells you where to look. Keeping those jobs separate makes the record useful when an item moves.

Choose a stable, readable ID

For individually tracked resale items, a simple sequence such as IIQ-000101 is a workable starting point. The example prefix is illustrative, not a required ItemIQ format. Use a scheme that fits your existing labels and tools. Avoid putting a changing price, condition, or shelf name inside the permanent ID.

Assign one ID to each distinct item you need to track. If you sell quantities of identical stock, decide explicitly how your system handles quantity rather than accidentally creating duplicate identities. This example tracks individual items.

Worked example: three items and a move

When the bag moves to the show table, keep IIQ-000102 and change the location to Show table / Position 04. Its photos and listing record keep the same ID. After the show, record the actual outcome and location; do not rename it to match the new shelf.

Connect label, photos, and record

1. Create the ID and check for an existing record with the same ID.
2. Attach a legible label that can stay with the item during preparation.
3. Use that ID when creating the item record and associating its photos.
4. Add a clear title and distinguishing details so a person can verify the item.
5. Record the current location in its own field or consistent location workflow.

When a teammate sees an identifier in a show list or export, they should be able to find the same identifier in the catalog and on the physical item. Check how your chosen export carries the ID before using it in a live workflow.

Check duplicates before importing

Search your existing catalog before introducing a new sequence. For a spreadsheet cleanup, sort by ID and investigate repeated values. Do not delete duplicate rows until you know whether they represent duplicate records, different items, or an intentional quantity convention.

Keep a short note describing who assigns IDs and how the next number is chosen. Avoid two teammates independently assigning the same range. Keep old IDs attached to sold-item history so a future return can be identified.

Test ten items, then expand

Ask a teammate to retrieve ten items using only their records. Reverse the test by handing them physical items and asking for the records. Fix unreadable labels, ambiguous locations, and photo mismatches before expanding the system.

ItemIQ includes SKU and item-photo workflows; see actual product screens. Follow the inventory management guide for status checks and the live-sale checklist for show-day handoffs.