Home
News
News and articles
Useful reads on warehouses, stock counts and audits.
Barcode, SKU and internal code: what each one is forA barcode is for the scanner, a SKU is for your books and an internal code ties bins to records. Mix them up and count gaps multiply. Here is how to keep them apart.
Counting several warehouses at one cut-off timeA market unit, a main warehouse and a 3PL each move goods at their own pace. Without a clear cut-off, transfers in transit get counted twice or missed altogether.
Putting marketplace and own-warehouse stock in one tableBack-office stock, ERP records and physical stock rarely agree. Put the three side by side under each SKU and oversell risks and unshelved returns show up.
Exporting a usable item list from 1C before a barcode countIf the list is missing fields, a barcode count stalls on items that cannot be matched. What to include in a 1C export, the usual format traps and what to check after.
Duplicate SKUs: how to find them and how to merge themWhen one product lives under two or three SKUs, its stock is split and a count shows shortage and surplus together. How to spot duplicates and check before merging.
How a handheld barcode count runs on the warehouse floorFrom issuing devices to scanning bins and recounting on the spot, a barcode count follows a fixed rhythm. Follow it and every scan can be traced afterwards.
All articles (40)
- Barcode, SKU and internal code: what each one is for
- Counting several warehouses at one cut-off time
- Putting marketplace and own-warehouse stock in one table
- Exporting a usable item list from 1C before a barcode count
- Duplicate SKUs: how to find them and how to merge them
- How a handheld barcode count runs on the warehouse floor
- A pallet and carton label scheme that still works next year
- What a head-office stock table needs to contain
- Counting a wholesale-market unit with tight aisles and stacks
- E-commerce returns: when does a returned item count as stock?
- Scan the bin first or the item first? Choosing a scan order
- Where to put labels and what material to use so they last
- Behind marketplace overselling: where stock data usually breaks
- Stock in transit between warehouses during a count
- Laying out a gap report so finance can read it at a glance
- Recording import batches and arrival dates in the stock table
- What to do when a barcode is damaged or will not scan
- One-dimensional barcode or QR code for warehouse use
- Managing stock when you sell via Telegram and a spreadsheet
- Who does what when several warehouses count at once
- How to measure inventory record accuracy
- Checking a container against its packing list by barcode
- Analysing count gaps with an Excel pivot table
- Cleaning raw scan data: de-duplicating, filling gaps and merging
- Naming SKUs for colour and size variants
- Bin location codes: from zone and row to level
- Using count data to rebalance stock between warehouses
- Adjusting the books after a count: find the cause first
- Keeping product names consistent in Chinese, Russian and Uzbek
- Scanner flat, offline or data lost on count day: a backup plan
- Barcode and carton checks before sending stock to a marketplace
- Labelling and counting samples in a showroom
- Value columns in a count table: cost, currency and exchange rate
- Scheduling counts for Tashkent and regional warehouses
- One shared item master for several warehouses
- Using scan data to choose which bins to recount
- A weekly stock summary for the owner: what to include
- Can you rely on the barcodes your supplier prints?
- A stock check list before a big sales promotion
- Training local warehouse staff to use handheld scanners