Stock ledger & product stock history FREE PRO
StoreCashier never just "overwrites" a stock number. Every change — opening stock, purchase, sale, return, transfer, adjustment — is written as one line in the stock ledger, per product, variation and business location. The current stock is simply the sum of those lines. The Product Stock History screen shows that ledger with a running balance, so you can always explain where a number came from.
admin.php?page=storecashier-products&view=list&action=stock_history&id=…), or "Stock history" in the Pro editor header
The Product Stock History screen#
Filters#
| Filter | What it does | Default |
|---|---|---|
| Business Location | One location, or "All locations". | All locations |
| Variation | Variable products only: pick the variation to show. | The first variation |
Summary boxes#
| Box | Lines |
|---|---|
| Quantities In | Total Purchase, Opening Stock, Total Sell Return, Stock Transfers (In) |
| Quantities Out | Total Sold, Total Stock Adjustment, Total Purchase Return, Stock Transfers (Out) |
| Totals | Current stock |
"Total Stock Adjustment" shows the size of the net adjustment (additions and subtractions together).
Movements table#
| Column | Meaning |
|---|---|
| Type | The move type (see below). |
| Quantity change | Green +N for stock in, red −N for stock out. |
| New Quantity | Running balance after this line (for the selected location filter). |
| Date | Date of the document (a back-dated purchase or transfer appears on its own date). |
| Reference No | Invoice / purchase / transfer / adjustment reference, or texts like "Opening stock", "Product editor", "WC Manual Edit", "CSV import". |
| Customer/Supplier information | The customer or supplier of that document, when there is one. |

Move types#
| Type (shown as) | Sign | Created by |
|---|---|---|
| Opening Stock | + | Opening stock grid, CSV import, "Sync all WooCommerce products", the Pro editor's opening stock, the first link of a WooCommerce product that already had a quantity. |
| Purchase | + | A purchase with status Received (not Pending / Ordered, not while waiting for approval). The line carries the landed unit cost (unit cost + share of shipping and additional expenses), the lot number and the expiry date. Quantities are in the base unit; a line bought in a larger unit notes the conversion, e.g. "2 Box (× 12) = 24 Pc(s)". |
| Purchase Return | − | A purchase return, at the purchase line's landed unit cost, lot and expiry. |
| Sell | − | POS sales; admin and online WooCommerce orders that are deducted from inventory (automatic deduction on the chosen order statuses, or the "Deduct from inventory" switch on an order); repair parts billed on a job. |
| Sell Return | + | Sell returns and WooCommerce refunds with restock; cancelled / failed / deleted orders put their stock back. |
| Stock Adjustment | ± | Stock adjustments; stock quantity edits in the Pro editor ("Product editor") or WooCommerce editor ("WC Manual Edit"); WooCommerce CSV imports that change a quantity ("CSV import"); Manufacturing (ingredients consumed, finished goods produced). |
| Transfer Out | − | Stock transfer (In transit or Completed) at the source location; fulfilled branch stock request. |
| Transfer In | + | Completed stock transfer at the destination; fulfilled branch stock request. |
How the numbers are kept right#
- One source of truth. The per-location quantity is recalculated from the ledger after every movement (a cache table holds exactly one row per product/variation/location).
- Edit = replace. When you edit a purchase, transfer or adjustment, its old ledger lines are removed and new ones written — never added twice. Deleting a document removes its lines, so stock goes back.
- WooCommerce sync. The total of all locations is pushed to the WooCommerce stock quantity, when Settings → Products & Stock → "WooCommerce sync qty" is on (default) and the product has "Manage stock" on. A product without any ledger line is never overwritten with 0.
- Changes made in WooCommerce (typing a new stock quantity, CSV import) are captured as adjustments, so the ledger and WooCommerce stay equal.
- Deleted products keep their ledger for history and reports.
- Negative stock is possible: when "Allow overselling" is on (Settings → Orders & POS) the POS can sell below zero, and a purchase return can take a location below zero. The history shows exactly when it happened.
Repair tools#
Settings → Products & Stock → Bulk Stock Tools: "Sync all quantities to WooCommerce" pushes ledger totals to WooCommerce again; "Enable / Disable Manage Stock on all products" switches stock tracking for the whole catalogue. See Settings: Products & stock.

Permissions#
Products & Stock → View. Staff limited to certain business locations only see their locations in reports.
How to investigate a wrong stock number#
- Open the product's stock history and choose the location that looks wrong.
- Read the New Quantity column from top to bottom and find the line where it went off.
- Open that document by its Reference No (purchase, order, transfer…) and correct it there — the ledger follows.
- If the shelf count simply differs, record a stock adjustment with reason "Stock count correction".
Can I delete or edit a ledger line directly?
No. Ledger lines belong to documents. Change or delete the document, or record an adjustment.
Why does WooCommerce show 36 but one location shows 24?
WooCommerce holds the total of all locations (24 + 12 = 36). Choose "All locations" in the history to see the total.