Square inventory management for a small brand

A coffee roaster sells a 12-ounce bag at the market stall on Saturday and a wholesale case out of the back room on Monday. Square inventory management is the work of making both sales subtract from the same count, and of noticing when one of them did not.

This guide covers how Square tracks stock, how to set low stock alerts, how to count across locations, and what to do when the number is wrong. If you also sell elsewhere, the same count has to serve every channel. The wider picture is in the operator's playbook for consumer packaged goods (CPG) brands.

How does Square track inventory?

Square keeps a stock count for each item variation at each location, reduces it when a sale is rung up, and raises it when you receive stock or make a manual adjustment. Square inventory tracking is per item, so the count is only as good as the item setup and the receipts you record.

In the items library, give each variation its own SKU: the 8-ounce bag and the 12-ounce bag are two variations, not one item. Turn on stock tracking for each, and enter a starting count taken from the shelf. Without a unique SKU per variation, reports blur two products into one.

Sales rung up in the Square app and orders from Square Online subtract from the same count, which is the point of keeping everything inside Square. The sale that does not is the wholesale case handed over the back-room counter and written up later: ring it up, or record a stock adjustment with the reason, on the same day. A count that is right at the register and wrong in the stockroom is the most common shape of Square drift.

How do you set up Square low stock alerts?

Set an alert threshold on each tracked item so Square flags it when the count falls to that number. Choose the threshold as the units you sell during the supplier's lead time plus a buffer. One threshold copied across every item alerts too late on fast sellers and too early on slow ones.

The rule is weekly sales times lead time in weeks, plus a buffer. A bag selling 30 a week with a two-week lead time needs 60 units to cover the wait, so an alert at 75 leaves a 15-unit buffer.

Square's alert is a daily email, not a block on the sale, so it needs a reader: one person who opens it, checks that the lead time still holds, and places the order. Revisit the thresholds every quarter. A bag that moved from 30 a week to 50 after a wholesale account landed has an alert set for the old brand, and the first sign is a stall with no 12-ounce bags on a Saturday.

How does Square inventory management work across locations?

Treat each location as its own count. Count one location at a time, enter the counted quantity in Square rather than adding and subtracting, and record the move when stock travels between locations. A unit that left the stockroom for the stall should leave one count and enter the other on the same day.

Where your Square plan has stock transfers, use them; otherwise adjust both counts and note the reason. Receiving stock cleanly is its own habit: the receipt goes in as stock received, with the quantity counted at the door rather than the quantity on the invoice.

The stall is the test case. Stock that leaves the stockroom on Friday afternoon is still in the stockroom count until someone records the move, so for a day the stockroom shows units it does not have and the stall shows none it does. Record the transfer before the van leaves, count what comes back on Sunday, and the two locations stay honest. A stockist's shelf is not a location at all; those units left your count when the case was sold.

What do you do when Square's count is wrong?

Find the pattern before correcting the number. Count the item, write the gap, and check recent returns, comps, damaged goods and unreceived deliveries. A gap that keeps returning on one item is a process fault, and fixing the number alone just resets the clock until it drifts again.

Keep a short log with item, expected, counted and the likely cause. After a month the log shows whether the trouble is one habit, such as comped drinks never entered, or scattered counting error.

Correct the number with a stock adjustment and a reason, never by typing over the quantity, because the adjustment history is where next month's pattern is read. Comps and damage have their own reasons in Square; use them, since a drink given away and recorded as a re-count hides the habit you are trying to find. When the same item is short three months running, inventory shrinkage separates the four causes that can sit behind one number.