StoreCashierDocumentation Free 1.6.6 Pro 1.5.6 Apps 1.5.0

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.

Where: Inventory Management → Products → Opening Stock (view=import_stock) · All Products → Actions → Add or edit opening stock

Four ways to enter opening stock#

MethodBest forPer locationLot / expiry / serials
Per-product gridA few products, variationsYesSerials (tracked products)
CSV importMany products at onceYes (Location id column)Yes: lot, expiry and serials
Sync all WooCommerce productsExisting shops that already have stock in WooCommerceDefault location onlyNo
Product editor (Pro, StoreCashier tab)New simple productsYesNo

Per-product opening stock grid#

Opening stock grid for one product with a column per business location and unit cost
One row per product (or variation), one column per business location.
  1. All Products → Actions → Add or edit opening stock (or the editor's "Opening stock (per location / variation)" button).
  2. 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.
  3. Check Unit Cost (Before Tax) — the cost of this stock (pre-filled from the purchase price).
  4. For IMEI / serial products, enter one identifier per unit in the serial box (the counter shows how many you entered).
  5. Click Save Opening Stock.
Opening stock grid for a variable product with one row per variation
A variable product: each variation has its own row.

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#

Opening Stock screen with CSV upload, sync button, file format and location ids
Products → Opening Stock: CSV import, Sync all WooCommerce products, the file format and your location ids.

"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."

ColumnContentRules
1 — SKU (Required)Product SKU, or the variation SKUA variable parent's SKU is refused.
2 — Location id (Required)The number from the "Your business locations" table on the screenMust exist.
3 — Quantity (Required)Opening quantityNot negative; whole number for whole-number units.
4 — Unit Cost (Before Tax) (Required)Cost per unitNot negative.
5 — Lot Number (Optional)Batch / lot codeStored 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-DDOther formats are rejected.
7 — IMEI / Serial numbers (Optional, separated by |)Identifiers of the unitsOnly 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.