Skip to content

Inventory ​

Inventory is your blanks: every SKU with its on-hand, reserved and available counts, its reorder settings and its supplier cost. Every change to a count is a row in an append-only movement ledger, which is what makes a count explainable later.

Where It Lives ​

PageWhat it's for
Records, then InventoryEvery SKU with its counts, reorder bar and status
New SKU and EditThe SKU's style, colour, size, reorder point and reorder quantity
Adjust stock on a rowChange a count with a reason
Print labelsBarcoded shelf labels for the selected SKUs
Catalogue importLoad a supplier's range from CSV. See 6. Catalogue and SKUs

The SKU List ​

The inventory list with on hand, reserved, available, reorder bar and statusSKUs with their counts and reorder status.

ColumnMeaning
CodeThe SKU, generated as BRAND-STYLE-COLOUR-SIZE
Style, Colour, SizeWhat it is, with the colour swatch
On handPhysically in the building
ReservedHeld for orders that have not yet entered production
AvailableOn hand less reserved
Supplier costWhat you pay, used for cost snapshots and margin
Supplier stockWhat your supplier holds. A live supplier sync is planned; until it ships this column stays empty
ReorderA bar of available against the reorder point
StatusHealthy, Low (available at or under the reorder point) or Reorder now (nothing available)

Filter by Style, Low stock only or active status. A workspace with no SKUs yet shows Import catalogue from CSV in place of the table.

How Stock Moves on Its Own ​

EventEffect on the SKU
A quote is acceptedThe quantity is reserved
An order is cancelledWhat the order still held is released
A proof is approvedThe reservation is hardened. No count changes; the ledger records it
An order enters In production for the first timeThe quantity is consumed: on hand goes down, and only what the order held comes off reserved
A purchase order delivery is receivedOn hand goes up by what arrived
A return is marked receivedEach stocked item is credited back to on hand
A cycle count is closedEach counted variance is posted as its own adjustment

Every one of these writes a ledger row with the reason and the document it relates to. On hand is the sum of its movements.

Production is never blocked by the count

When a job enters production and the shelf is short, on hand goes negative, a shortfall row is written and the activity feed names the SKU, the order and the units short. The job proceeds. Receive the delivery that brought the garments in, or adjust the count with a reason, so the shelf reads true again. See When a job is short of stock.

Adjusting Stock ​

Editing a SKU, with on hand read-only and the reorder settingsThe SKU form. On hand cannot be typed here; the Adjust stock action on the list changes it.

  1. On Records, then Inventory, find the SKU and click Adjust stock on its row.
  2. Enter the Adjustment: a positive number adds stock, a negative number removes it.
  3. Type the Reason, for example "damaged carton", "samples taken" or "misprints written off".
  4. Click Submit. The notification reads "Stock adjusted by" with the delta and the SKU code, and a ledger row carries the reason.

An adjustment that would take on hand below zero is refused with the SKU's current count. For a recount of a whole rack use a cycle count, which posts every variance for you.

Editing a SKU ​

Edit on a row opens the SKU: Code (leave blank to regenerate it from brand, style, colour and size), Style, Colourway and Size, the read-only On hand and Reserved, Reorder point, Reorder quantity and Is active. The style and colourway selects can create a new style, brand or colourway in place. An inactive SKU is left out of low stock counts and cycle counts.

Reorder Points ​

The reorder point is what turns the list into a purchasing system. A SKU whose available count is at or under its reorder point is Low; one with nothing available is Reorder now. Both appear in the dashboard's Stock alerts tile and under Low stock only, and Suggest from low stock in Purchase orders drafts an order for them. How to set sensible points is in 6. Catalogue and SKUs.

The dashboard's Inventory forecast catches the other case: a SKU that is about to run out from the last thirty days of consumption but has not yet crossed its reorder point.

Shelf Labels ​

Printable SKU shelf labels with barcodesOne Code 128 label per SKU, ready to print.

  1. Tick the SKUs in the list.
  2. Open the bulk actions menu and choose Print labels. A printable sheet opens at /workspace/skus/labels with one barcode label per SKU.

Labelled shelves make cycle counts and receiving faster, because the scan page reads them: a scanned shelf label during an open count records one unit, and outside a count shows the SKU's stock with a link to adjust it.

The production scan page showing a SKU's stock after a shelf label scanScanning a shelf label outside a count shows on hand, reserved and available.

Who Can Do What ​

Owners, managers and the production role adjust stock and edit SKUs. Sales, designers and viewers can read the list and print labels. Roles are set in Team and permissions.

Printer's Friend - software for apparel print shops