Set Up a SKU System in an Afternoon for Home Based Resellers

A SKU system is a single, consistent internal code paired with disciplined routines that stop oversells and make picking fast. The fix starts the same way for every reseller: standardise your SKU format and pick one inventory of record, whether that is a dedicated tool, a spreadsheet, or a crosslisting app.

Most resellers do not need barcodes from GS1 or complicated software to get this right. They need a format they will actually stick to, a storage system that matches it, and a habit of checking stock before it drifts. HMRC also now expects platforms to report seller income in some cases, so good records pay off twice: once in fewer lost sales, once at tax time.

---

TL;DR:

• Use a fixed, readable SKU format of about 12 to 16 characters, keep marketplace IDs separate, and never reuse a code after an item sells.
• For multichannel sales, use live stock updates, reserve inventory as soon as orders arrive, and automatically delist one off items after a sale.
• Count fast selling items weekly and other stock monthly, set reorder points using lead time and average daily sales, and log every adjustment.
• UK platforms may report seller income to HMRC; keep sale dates, prices, item costs, and purchase receipts, and check whether income above £1,000 requires Self Assessment.

---

2. A compact setup checklist you can follow today

You do not need a weekend to fix your stock system. Work through this in order and most of it is done in an afternoon.

1. Pick your SKU template. Decide on segments (category, attribute, sequence number) and write the rule down so you never improvise.
2. Label your storage. Give every bin, rail, or shelf a location code and attach it to the matching SKU.
3. Choose a scanning method. A smartphone camera works for most small operations; a dedicated scanner suits higher volumes.
4. Import your SKUs into a cloud tool. Start with a small batch of 20 to 50 items rather than your whole stockroom.
5. Set reorder points and a count schedule. Decide which items need restocking triggers and how often you will check them.
6. Map every marketplace. Confirm your internal SKU appears consistently (or is mapped) across each platform you sell on.

A few habits make this stick:

• Write your SKU rule somewhere permanent, not just in your head.
• Never reuse a SKU once an item has sold, even for an identical restock.
• Review your mapping each time you add a new sales channel.

Once this is running, the system mostly maintains itself. The work is in getting the first batch consistent.

3. How to design a scalable SKU format

A good SKU is readable by a human, not just a database. Shopify’s SKU guidance recommends keeping segments in a fixed order, avoiding special characters, and treating the SKU as an internal identifier that is separate from the manufacturer’s barcode or marketplace ID.

A practical rule set looks like this:

• Use letters and numbers only, no slashes, spaces, or symbols.
• Keep each segment a fixed length so SKUs line up visually and sort predictably.
• Order segments from broad to specific: category, then attribute, then a unique number.
• Cap total length at around 12 to 16 characters so it fits comfortably in marketplace fields and barcode generators.

Here are copyable examples for three common reseller categories:

Category	Template	Example
Clothing	BRAND-TYPE-SIZE-###	ZARA-DRS-M
Electronics	CAT-MODEL-COND-###	PHN-IP12-REF
Collectibles	CAT-ERA-VARIANT-###	TOY-RARE

If you sell across several storage sites, add a short location prefix at the start, such as WH1- for a spare room or GAR- for a garage unit. Shopify’s guidance also notes that SKUs should stay independent of marketplace identifiers like ASINs or EANs, so you can map your own codes consistently even when a platform assigns its own ID behind the scenes.

Pro Tip: Pick a format you could still read correctly after six months away from the business. If you have to guess what a segment means, it is too clever.

Consistency matters more than cleverness. A messy mix of formats is the single biggest reason resellers end up retyping stock lists by hand later.

4. Labelling and storage: map SKUs to real locations and reduce picking errors

A SKU only saves time if it leads you straight to the shelf. Every bin, box, or garment rail needs a unique location code that your inventory system links to the SKU, not just a vague description like “top shelf”.

For clothing, a hanging rail with labelled sections (by brand, size run, or SKU range) beats piling items into tubs, since you can see and pull stock without unpacking. Small items such as jewellery or electronics accessories do better in labelled trays or divided boxes, where each compartment gets its own location code.

In a small space, a few tactics go a long way:

• Use vertical racking to multiply floor space without expanding your footprint.
• Label hanging rails by section so a new helper could find stock without asking you.
• Keep a small “overflow” shelf for fast movers near your packing station.
• Tag returned or quarantined items with a temporary code so they do not get picked by mistake.

Inventory guidance for ecommerce sellers points out that standardising a format and rolling it out across every location immediately saves far more time than fixing mismatched codes later. That applies just as much to physical storage as it does to the SKU string itself: a location scheme you set up properly on day one rarely needs rebuilding.

Returns deserve their own short routine. Scan the item back in, confirm the SKU still matches your records, and either return it to its normal location or move it to a clearly marked quarantine shelf until you decide whether it is resellable.

5. Choosing scanning methods and software features that actually solve SKU problems

Barcode scanning removes the single biggest source of manual error: typing. Guidance for ecommerce sellers suggests starting with smartphone camera scanning and cloud software as a cost-effective entry point, then moving to dedicated scanners or RFID only once volume justifies the cost.

When you are comparing software, insist on these features rather than being swayed by extras:

1. Real-time stock sync across every channel you sell on, not a scheduled batch update.
2. One inventory of record that every other system reads from, rather than several spreadsheets that drift apart.
3. Multichannel SKU mapping, so one internal code reliably links to listings on each marketplace.
4. Mobile access, so you can check or adjust stock from the stockroom, not just a desktop.
5. CSV import and export, so you are never locked into one tool’s format.

Xero’s inventory guidance adds a UK-specific point worth checking before you commit to a tool: confirm which stock valuation method it uses by default. FIFO (first in, first out) or AVCO (average cost) both work for UK reporting, but some imported systems default to LIFO, which is not appropriate for UK tax purposes.

Pro Tip: Before buying anything, test the free tier or trial with a batch of real SKUs from your own stock, not the demo data the vendor provides.

A minimal, workable starter stack is smartphone scanning, printed barcode labels, and a cloud inventory tool with CSV import. You can build on that later; you rarely need to rip it out.

6. How to stop oversells: practical multichannel sync and SKU discipline

Oversells happen when two channels believe they both still have the same item. Industry guidance on ecommerce inventory identifies manual spreadsheets as the most common cause once a seller lists on more than one marketplace, simply because nobody updates every sheet at the same moment.

The fix has two parts: process and technology.

• Use exactly the same SKU for the same item on every channel, mapping to each marketplace’s own identifier where needed.
• Favour tools that update stock through a live connection rather than a scheduled import, since a scheduled sync can leave a gap where an item looks available on two platforms at once.
• Reserve stock the moment an order comes in, rather than waiting for payment confirmation to update your records.
• Auto-delist single, one-off items the moment they sell, rather than relying on a manual check at the end of the day.
• Test any new sync setup on a small batch before trusting it with your full catalogue.

Guidance on ecommerce inventory practice is blunt about the trade-off: real-time, API-based updates are the most reliable way to prevent oversells, and scheduled synchronisation is only acceptable for low-volume sellers willing to accept the timing risk.

Before trusting a new system with your full catalogue, run a deliberate test: list 10 items across your channels, simulate two sales happening at once on different platforms, and confirm the stock count updates everywhere within minutes rather than hours. If it does not, you have found the gap before a real customer does. For sellers managing orders across several storefronts, a dedicated order management system can handle this reconciliation automatically rather than leaving it to manual checks.

7. Daily and weekly routines: cycle counts, reorder points and slow-mover handling

Set a count schedule based on how fast stock moves rather than where it sits. Guidance on inventory fundamentals recommends tiering counts by SKU velocity: your fastest-selling lines get checked weekly, everything else monthly.

1. Count fast movers weekly. Pick a fixed day, scan each SKU, and reconcile any mismatch immediately.
2. Count the remainder monthly. A slower rotation is enough once an item is not shifting daily.
3. Calculate reorder points. Use lead time multiplied by average daily sales, plus a small safety stock buffer, to decide when to restock.
4. Flag slow movers early. If a line has not sold in your usual turnover window, decide between a clearance price or returning it to a supplier.
5. Log every adjustment. Record the date, the SKU, and a reason code (sold, damaged, returned, miscounted) so you have an audit trail if numbers do not add up later.

This routine takes minutes once it is habitual, and it is the difference between catching a discrepancy early and discovering it when a customer complains.

8. What sellers must know about platform reporting and tax basics

Gov, updated 31 July 2024, confirms that from January 2024 platforms may need to collect seller details and report income to HMRC. Reporting alone does not mean tax is automatically owed, but it does mean your own records need to match what a platform might disclose.

Most individuals can earn up to £1,000 in trading income each tax year before needing to declare it. Beyond that, registering for Self Assessment is likely required.

Keep these basics tied to your inventory records, not separate from them:

• Log every sale with date, price, and the SKU sold.
• Record the cost of each item so you can calculate cost of goods sold accurately.
• Keep receipts or purchase records for anything bought for resale.

For full detail on allowances and reporting thresholds, HMRC’s own guidance (sometimes referenced as HS222 for self-employment income) is the authoritative source to check against your own circumstances.

9. Practical setup: mapping your SKU system into a crosslisting tool

Once your SKUs are standardised, the next step is getting them to behave the same way everywhere you sell. We offer a tool to let you list an item once on Vinted, eBay, Wallapop, todocoleccion, Shopify, WooCommerce, and PrestaShop, then keep stock in sync so a sale on one channel removes the listing from the rest automatically.

A simple rollout checklist:

• Import your existing SKU list as a batch rather than entering items one by one.
• Map each SKU field to the matching listing field on every channel you use.
• Enable stock sync and confirm it updates across channels, not just within one.
• Run a pilot with 10 to 20 SKUs before committing your full catalogue.
• Follow with a cycle count to confirm the synced numbers match your physical stock.

Pro Tip: If you are running more than one storage location, finish your pilot batch before splitting stock across sites, so you know the sync works before you add complexity.

Scale up to dedicated scanners or split warehouses only once volume genuinely demands it.

10. Author perspective: trade-offs and pragmatic priorities

Most small resellers overbuild before they underbuild. A spreadsheet with consistent SKUs beats an expensive system with sloppy codes, every time. The real trap is leaving channel mapping “for later”: by the time stock has grown, untangling mismatched SKUs across five marketplaces takes far longer than setting them up right the first time. Start small, pilot on a handful of SKUs, and only add hardware once your process has proven itself.

- Luis

How the tool helps you keep SKUs in sync

A consistent SKU format only solves half the problem if you are still updating five marketplaces by hand. The tool lets you list an item once on Vinted, eBay, Wallapop, todocoleccion, Shopify, WooCommerce, and PrestaShop, and when it sells on one channel, it removes it from the rest so the same SKU never gets sold twice. Listings also auto-relist on Vinted and Wallapop, and Vinted and Wallapop messages land in one inbox, with AI drafting titles and descriptions to save you time on each listing.

See current plans on our pricing page or explore the full feature set on our product page.

FAQ

What is the best inventory software for resellers?

There is no single best option; the right choice depends on how many channels you sell on and how much stock you hold. Look for real-time sync, one inventory of record, multichannel mapping, and mobile access rather than judging software on price alone, as inventory guidance for ecommerce recommends. A dedicated inventory management guide can help you compare feature sets in more depth.

Is reselling legal in the UK?

Yes, reselling goods is legal. What matters is reporting income correctly: platforms may report your seller details and income to HMRC under current digital platform rules, and you are responsible for declaring income above the trading allowance.

How do resellers organise inventory?

Most organise stock with a consistent internal SKU, a matching physical location code, and a single system that acts as the source of truth for stock levels. Cycle counts, reorder points, and clear labelling on bins, rails, or trays keep the system accurate as stock moves.

What is the best app for reselling products?

This depends on which marketplaces you use and whether you need crosslisting, AI-assisted listings, or message management. We built Ruit specifically for sellers listing across Vinted, eBay, Wallapop, todocoleccion, Shopify, WooCommerce, and PrestaShop, with automatic relisting on Vinted and Wallapop and a single inbox for messages from those two platforms.

Do I need a GS1 barcode to sell as a small reseller?

Not usually, unless you are selling your own branded packaged goods into larger retail channels. GS1 UK’s guidance explains that genuine GTINs are issued only through GS1 membership and are required by major marketplaces for certain product categories, but most resellers of second-hand items can rely on their own internal SKU system instead.

Sources

• Gov
• GTIN booklet, GS1 UK
• What is a stock keeping unit (SKU)?, Shopify UK
• Inventory management for ecommerce, Ogden Fulfilment
• Inventory management system guide, Xero UK

Recommended

• Reseller tools: How to Start a Resell Business the Smart Way
• OMS Software for Resellers: Sync Stock and Orders
• Inventory Management with Barcode Scanning: A 2026 Guide
• What can I buy and resell to make money