How to manage inventory for your online shop

Inventory management keeps the quantity shown on your website aligned with what your business can fulfil. It covers more than counting boxes: stock arrives, gets reserved, sells, returns, is damaged or moves between locations. Each event needs to update the right record at the right time.

A small shop can begin with a simple system if everyone follows it consistently. As sales channels, products or staff increase, the cost of delayed updates becomes harder to manage. Choose a process around the movement of your stock rather than buying software before you have defined what it should do.

Understand the quantities you are managing

On-hand stock is physically present. Committed stock is already allocated to orders. Available stock is the quantity you can offer for another sale after relevant commitments and exclusions. Incoming stock is expected but has not necessarily been received and checked. A purchase order is not proof that usable goods are already on the shelf.

Record damaged, quarantined or demonstration items separately so they do not inflate availability. For variations, decide whether each size or colour needs its own count. A single quantity for “T-shirt” cannot reliably fulfil customers choosing different sizes. Clear definitions prevent staff and software from using the same label for different things.

The three common problems to solve

Overstocking ties up cash and space; understocking loses sales or creates delays. Poor tracking makes it difficult to know which one is happening until a customer complains. Manual errors become more likely when the same movement is retyped into several systems or recorded later from memory.

Look at the actual failure points. Are deliveries received before their quantities are checked? Are in-store sales missing from the website? Are returned items automatically made saleable? Fix the movement process as well as the software, otherwise an automated system will distribute inaccurate information faster.

Choose between manual, spreadsheet and connected systems

Manual records

A paper record can suit a tiny, low-volume range with one person handling all stock. It costs little and works without a complex setup. Its limitations are delayed updates, difficult searching, weak change history and poor coordination across locations. It becomes risky when several people sell the same last unit independently.

Spreadsheets

A shared spreadsheet can introduce SKUs, movement dates, quantities, supplier details and reorder flags. Use controlled columns and clear ownership rather than multiple emailed copies. Protect formulas, validate entries and keep a change history. Review access when staff leave because stock records can also contain supplier and commercial information.

Spreadsheets remain vulnerable to duplicate rows, overwriting and inconsistent timing. They do not automatically reserve stock during checkout. If you use one alongside a shop, specify who reconciles the two records and how often. Avoid presenting yesterday’s spreadsheet total as a real-time promise.

Connected inventory software

A connected system can synchronise orders, channels, warehouses and purchasing. Evaluate barcode support, variation handling, bundles, permissions, audit history and export options. Product examples to investigate include the inventory capabilities of your commerce platform and specialist systems with maintained connectors; their suitability depends on the actual workflows and plan.

Automation introduces subscription, integration and maintenance costs. Check which system is authoritative, what happens during an outage and how failed messages are recovered. Test a connector before moving the complete catalogue. A tool with many features is not automatically safer than a smaller system everyone understands.

Build a clean SKU and catalogue structure

Assign a unique SKU to each saleable item or variation. Keep the convention readable and stable; do not encode information that changes frequently, such as a supplier’s temporary shelf location. Distinguish a barcode used for scanning from the internal SKU, while documenting how the two relate.

Standardise product names, units, categories and variation attributes. Decide whether a quantity means individual pieces, packs or cases. A supplier delivering ten cases must not be recorded as ten individual items if each case contains twelve. Record the conversion in a controlled product definition rather than relying on a staff member’s memory.

Configure inventory in WooCommerce

WooCommerce’s product settings include an Inventory section under WooCommerce → Settings → Products. Enable managed stock counts where you want the platform to maintain quantities. Then check the corresponding product or variation settings. A global switch alone does not establish that every product has a correct count.

The Hold stock setting reserves stock for eligible unpaid orders in Pending payment status for a configured period; it does not apply identically to On hold orders. Choose a period that fits your payment methods and review the current documentation. A delayed-confirmation payment requires a different operational review from an immediately failed card payment.

Test the last item through checkout, an expired pending order, a failed payment, a cancellation and a refund. Observe the stock movement for each integration. Do not assume every refund should return physical stock to sale: the goods may not yet have arrived back or may be unsuitable for resale.

Connect receiving, storage and fulfilment

When goods arrive, compare the delivery with the purchase order, inspect condition and record accepted quantities. Put discrepancies into an exception process. Use consistent shelf or bin locations so pickers can find the correct variant. Scan where it reduces mistakes, but keep a process for damaged labels and unmatched items.

During fulfilment, connect the picked item to the order and mark the relevant progress once it happens. Avoid marking an order complete just to make the dashboard look tidy. For multi-channel selling, ensure the online catalogue reflects stock sold elsewhere promptly enough for your commitments.

Use alerts and reorder points sensibly

A practical reorder point considers expected demand during supplier lead time plus a buffer for uncertainty. For example, a hypothetical item selling three units a day with a seven-day replenishment lead time needs planning around twenty-one units of lead-time demand before any chosen buffer. This is a planning example, not a forecast for your business.

Review lead times, minimum order quantities, seasonality and shelf life. Low-stock alerts need an owner and an action; a warning that nobody reads will not replenish stock. Separate “reorder soon” from “unavailable now” and escalate integration failures before they corrupt a whole trading day’s quantities.

Count, rotate and handle exceptions

Use periodic full counts or cycle counts of selected stock, recording differences and investigating recurring causes. Count high-value, fast-moving or error-prone lines more often where appropriate. Pause conflicting movements during a count or reconcile them explicitly so the comparison is meaningful.

First in, first out can help rotate ordinary stock. Date-sensitive goods may need first-expiry-first-out instead, with sector-specific handling requirements. Record batches or serial numbers where your products require traceability; a generic commerce quantity field may not be sufficient.

For out-of-stock items, show an honest status and offer useful alternatives. Accept backorders only when you can manage the supply commitment and communicate changes. Keep preorder stock distinct from goods already received. Review the process after returns, stockouts and busy periods so the records become more dependable as the shop grows.

Reconcile a complete example order

Choose one ordinary product and trace a controlled order from availability through reservation, payment, picking and dispatch. Then trace a cancellation and an inspected return. Record the expected quantity after each event and compare it with the website and stock system. Include a failed connector message if the environment supports safe testing. This simple exercise exposes differences between physical stock, available stock and recorded order state before they affect a customer. Repeat it after changing a payment or inventory integration.