How to Build a SKU and Storage System for Reselling
By Trendy Lister · Updated · 6 min read
A reseller SKU should identify one inventory record, while a location code should tell you where to retrieve the item. Combining those jobs into a long descriptive code often creates extra work. Keep both values short, stable, and readable.
A basic system might assign 000427 as the SKU and B-14 as the storage location. The item can move from B-14 to shelf D without changing every marketplace listing. Only the private location field changes.
Choose a SKU rule you can maintain
Sequential numbers are hard to duplicate and quick to label. A prefix can identify a broad inventory stream when that distinction matters, such as VTG-00427 for vintage stock and CON-00116 for consignment. Avoid packing changing facts into the code.
A SKU such as NIKE-BLUE-MEDIUM-BIN4 becomes inaccurate when the item is moved, the color is corrected to navy, or the tagged size differs from your first guess. Those facts belong in separate fields where they can be updated without breaking the identifier.
Before issuing a new code, search the source record for duplicates. Never reuse a sold SKU for a different item. Old marketplace exports, return records, and buyer messages may still refer to it.
Label the physical item
Place the SKU on the item's protective bag, hang tag, or removable storage label. Do not attach an adhesive label directly to a surface it could damage. For sets, label the outer container and record the count and included pieces in the source record.
When two items look alike, add a temporary intake card to the first working photo. Confirm the item label, source row, and photo folder all show the same SKU before publishing. This catches swaps before buyers ever see the listing.
Design location codes around the room
Walk the storage area and divide it into fixed zones. Use codes such as:
- A-01 through A-20: numbered bins on shelving unit A
- H-07: seventh garment position on hanging rack H
- L-C2: locked cabinet, shelf C, compartment 2
- OS-3: oversized storage position 3
Put a large label on each physical location. A code that exists only in a spreadsheet still leaves a helper guessing which shelf counts as A. Keep walking paths clear, store heavy items low, and follow appropriate storage guidance for fragile, hazardous, temperature-sensitive, or high-value goods.
Use one-item and multi-quantity rules
One-of-one used items usually need one SKU each because condition and photos differ. Identical new stock can share a SKU when the units truly match and quantity is controlled. Do not combine two used shirts merely because they share a brand and size; their wear, measurements, and photo evidence may differ.
For multi-quantity stock, record received, available, reserved, sold, returned, and damaged quantities separately. Count the units when receiving a return before making any quantity available again.
Use marketplace fields as copies, not the master
Save the SKU in each destination's private inventory field when one is available, but keep your own source record. Poshmark's My Inventory Report guide describes its private SKU field and report. eBay's Seller Hub Reports documentation explains its reporting and bulk-management tools.
Exports help you compare marketplace records with your own, but they may represent only part of the item's history. Keep sold, archived, and returned records in your source system even when a marketplace report focuses on current listings.
Make movement a complete action
- Scan or read the item's SKU.
- Remove it from the old location.
- Place it in the new labeled location.
- Update the location field immediately.
- Confirm the record before walking away.
Do not create a temporary floor pile with the intention of updating records later. If several items must move, use a cart and finish one update at a time. A half-completed reorganization can make accurate records worse than no reorganization.
If a temporary holding area is unavoidable, give it a real location code and a strict capacity. Record every item placed there. “Photo table” or “return pile” can function as a location only when it is labeled and reconciled at the end of the work period.
Retrieve and close a sold item
Search the order by SKU, confirm the item label, and compare a distinguishing detail with the listing before packing. Change the SKU to sale pending so it cannot be republished. After sibling offers are closed, remove the location value or mark it as shipped according to your record rules.
The double-selling guide covers the marketplace side of this process. The inventory management guide explains the other fields that belong beside SKU and location.
Audit exceptions, not just totals
Each week, look for active items without locations, two active items in a one-item slot, duplicate SKUs, empty bins that still have assigned inventory, and sold items left on shelves. Check a small random sample by starting with the record and retrieving the physical item, then starting with a shelf item and finding its record.
Once the system works for a small section, extend the same rules to the rest of the room. Use the practical crosslisting guide to connect intake, storage, and publishing. When your inventory records are ready, you can create an account and continue building your marketplace workflow.