Opening stock FREE PRO
Opening stock is the quantity you already have on the shelf when you start using StoreCashier (or when you add a product you did not buy through a purchase). It is the first line in every product's stock ledger. You can enter it per product and per business location, import it from a CSV file, or take it over from WooCommerce in one click.
view=import_stock) · All Products → Actions → Add or edit opening stockFour ways to enter opening stock#
| Method | Best for | Per location | Lot / expiry / serials |
|---|---|---|---|
| Per-product grid | A few products, variations | Yes | Serials (tracked products) |
| CSV import | Many products at once | Yes (Location id column) | Yes: lot, expiry and serials |
| Sync all WooCommerce products | Existing shops that already have stock in WooCommerce | Default location only | No |
| Product editor (Pro, StoreCashier tab) | New simple products | Yes | No |
Per-product opening stock grid#

- All Products → Actions → Add or edit opening stock (or the editor's "Opening stock (per location / variation)" button).
- For each row (the product, or each variation of a variable product) type the quantity under each location. Leave a cell empty to keep it unchanged; type 0 to remove the opening stock at that location.
- Check Unit Cost (Before Tax) — the cost of this stock (pre-filled from the purchase price).
- For IMEI / serial products, enter one identifier per unit in the serial box (the counter shows how many you entered).
- Click Save Opening Stock.

The help text says it well: "StoreCashier tracks per-location stock in its own ledger; the total across locations is synced to WooCommerce automatically."
- Whole-number units (e.g. Pieces) only accept whole numbers; decimals are skipped.
- Saving replaces the opening stock of that item at that location — it is not added on top. Sales, purchases and other movements are not touched.
Import opening stock from CSV#

"A header row followed by one row per product or variation. Use the variation SKU for variable products. Each row replaces the opening stock for that item at the given location."
| Column | Content | Rules |
|---|---|---|
| 1 — SKU (Required) | Product SKU, or the variation SKU | A variable parent's SKU is refused. |
| 2 — Location id (Required) | The number from the "Your business locations" table on the screen | Must exist. |
| 3 — Quantity (Required) | Opening quantity | Not negative; whole number for whole-number units. |
| 4 — Unit Cost (Before Tax) (Required) | Cost per unit | Not negative. |
| 5 — Lot Number (Optional) | Batch / lot code | Stored on the ledger row; shown on the Expiry report together with the expiry date. (The Lot report lists purchase lots.) |
| 6 — Expiry Date (Optional) | YYYY-MM-DD | Other formats are rejected. |
| 7 — IMEI / Serial numbers (Optional, separated by |) | Identifiers of the units | Only for products with tracking on. The quantity is raised to the number of identifiers when it is lower. |
Example (the same as on the screen):
SKU,Location id,Quantity,Unit Cost,Lot Number,Expiry Date,Serials
sf-1,1,50,850,LOT-A1,2027-06-30,
0002,2,120,90.50,,,
PH-128,1,2,420,,,356938035643809|356938035643817
Choose the file in CSV File * and click Import. Good rows are imported; bad rows are skipped and listed with a reason, for example: "Row 4: Product with SKU "X" not found", "Row 5: Location ID 9 does not exist", "Row 6: Quantity cannot be negative", "Row 7: Invalid expiry date format (use YYYY-MM-DD)", "Row 8: SKU "TSHIRT" is a variable product; use variation SKU instead", "Row 9: serial numbers ignored — IMEI / serial tracking is not enabled for this product".
Sync all WooCommerce products#
If your shop already had stock quantities in WooCommerce before StoreCashier, click Sync all WooCommerce products. It "links every WooCommerce product and variation (including imported or REST-created ones) to StoreCashier inventory. Items that manage stock but have no stock history yet get an Opening Stock entry equal to their current WooCommerce quantity at the default location. Safe to run any time — items that already have history are never changed." The result shows "N products synced, M opening stock entries created."
The same sync runs once automatically in the background after installing or upgrading. Products in every status (published, draft, pending, private, scheduled) are included. The opening stock is costed at the product's purchase price.
What happens behind the scenes#
- Each opening quantity is one ledger row of type Opening Stock (reference "Opening stock") for that product/variation and location. Saving again deletes the old opening row and writes the new one, so opening stock can never be counted twice.
- The location's quantity is recalculated from the ledger and the total of all locations is written to the WooCommerce stock quantity (if "WooCommerce sync qty" is on and the product manages stock).
- The unit cost is stored with the row and used for stock valuation and the Expiry report's "stock at risk" value.
- No accounting entry and no supplier balance is created. Opening stock is not a purchase. If you owe a supplier for it, record the supplier's opening balance in Contacts.
- An Activity Log entry "Opening Stock" is written.
Permissions#
Products & Stock write right (Add, Edit or Delete) and the WordPress right to edit the product.
Common mistakes#
- Using opening stock for new deliveries. Use a purchase: it keeps the supplier, cost and payment history.
- Correcting a count later with opening stock. After you have sold items, use a stock adjustment ("Stock count correction") so the history shows what happened.
- Wrong location id in the CSV. Copy the ids from the table on the Opening Stock screen.
I imported the same CSV twice. Is my stock doubled?
No. Each row replaces the opening stock of that item at that location.
Can I enter opening stock for a location I add later?
Yes. Add the location in Settings → Business Locations; it appears as a new column in the grid.