What you'll do: fill one spreadsheet with the stock you have on day one and load it in a single step.
Before you start:
- Your role needs the permission to add opening stock (product.opening_stock).
- The products must already exist in Hala, each with an SKU and with Manage Stock on. Import them first with Import → Import Products if needed.
- Your branch names must match your Business Locations exactly.
Open Inventory & Products → Import → Import Opening Stock.
Press Download Template and open the file in Excel (or Google Sheets).
1 Download Template · 2 File · 3 Import Opening Stock · 4 Import Instructions Keep the first row (the headings) and fill one row per product and branch, in this column order:
# Column What to type 1 SKU (required) The SKU of the product or variation. 2 Location The business location name. Leave blank to use your first location. 3 Quantity (required) The quantity you have. 4 Unit Cost (Before Tax) (required) The purchase price of one unit, before tax. 5 Lot Number Only if you use lot numbers. 6 Expiry Date Only if you track expiry, as month/day/year, e.g. 12/31/2026.Save the file as XLS, XLSX or CSV (up to 10 MB and 5,000 rows).
Back on the page, choose the file and press Import Opening Stock. Wait until Importing... finishes.
Check a few products: open List Products and look at their stock, or open the product's Opening Stock window.