← All guides

Inventory

Stock counts that add up: cycle counts, full counts and shrinkage

Plan counts that fit around selling, record adjustments with the right reasons, find where stock goes missing, and import a count from CSV.

Woman counting stock with a clipboard beside shelves of labelled boxes
Photo by Tima Miroshnichenko on Pexels

1. Why the number drifts

Even with tracking switched on, the figure in your admin slowly separates from the shelf. A pick from the wrong bin, a damaged unit thrown away without a note, a return put back without restocking, a sample handed to a photographer — each one is small, and together they add up.

Counting is how you pull the two back together. The aim is not a perfect number once a year; it is a number you can trust every week.

2. Full counts versus cycle counts

A full count checks every item at a location in one go. It gives a clean baseline, but it usually means pausing fulfilment and works best in a quiet period, at year end, or before a migration.

A cycle count checks a small slice of the catalog on a rolling schedule — one shelf, one category, or one supplier’s products per session. Nothing stops, and every item is counted several times a year.

Most growing stores do one full count to set the baseline, then switch to cycle counts.

3. Count your most important items most often

Not every SKU deserves the same attention. A simple rule is to count fast sellers and high-value items most often, and slow, cheap items least.

ShopWise’s ABC analysis by product report (Analytics → Reports, Inventory category) ranks products by their contribution to sales, which makes a sensible starting list for your A items.

4. Run a clean count

Most counting mistakes come from counting while stock is moving.

  1. Pick the location and the slice of products you will count today.
  2. Fulfil or set aside open orders for those items first, so committed units are not miscounted.
  3. Count blind: write down what is on the shelf before you look at the system figure.
  4. Recount any line that differs, ideally with a second person.
  5. On Products → Inventory, select the location, open the variant’s Available figure, choose Set to, enter the counted quantity, and pick the Count reason.
  6. Note anything unusual — damaged packaging, mislabelled bins — while it is fresh.

5. Import a large count from CSV

For a full count, typing each quantity is slow. Export from the Inventory page for the location you are counting, fill in the On hand (new) column in a spreadsheet, and import the file back.

Rows match on SKU first, then on Handle plus option values. Only rows with an On hand (new) value are applied, and they apply to the location selected when you import. Review the Matched, Unmatched and Will change counts in the preview before you confirm.

6. Choose adjustment reasons that tell a story

Reasons are what turn a count into information. Use Count for count corrections, Damaged for units that cannot be sold, Theft or loss for units that are simply gone, Received for deliveries you are not recording through a purchase order, and Return restock for returns going back on the shelf.

Avoid parking everything under Correction or Other. You cannot fix a pattern you cannot see.

7. Track and reduce shrinkage

Shrinkage is stock you paid for but can no longer sell: damage, loss, theft, admin errors, and supplier short-shipments. Review your adjustment history for the variants that move most often under Damaged or Theft or loss.

Common fixes are unglamorous: better inner packaging from suppliers, a fixed home for every SKU, receiving deliveries against a purchase order rather than by eye, and a second person on high-value counts.

Tips and tricks

  • Count at the same time of day, before the day’s packing starts.
  • Label shelves with SKU as well as product name so pickers and counters see the same code.
  • Keep the same person off counting the stock they also pick, where your team size allows.
  • Put a recurring count on the calendar — counts that are not scheduled tend not to happen.
  • Export the Inventory on hand and value report at the same point each month and compare the totals — it shows today's stock value only.

Checklist

  • Baseline full count completed per location
  • Cycle-count schedule agreed (A/B/C)
  • Counts entered with Set to and the Count reason
  • Damaged and lost stock recorded with their own reasons
  • CSV preview checked before every import
  • Monthly review of adjustment history

Explore the Lulu platform, compare packages, or ask the team about your setup.

Put your next step into motion.