Skip to content

Import opening stock

All plansOwner / ManagerStock & purchasingUpdated 15 Nov 2026

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 Import Opening Stock

  1. Open Inventory & Products → Import → Import Opening Stock.

  2. Press Download Template and open the file in Excel (or Google Sheets).

    1 Download Template · 2 File · 3 Import Opening Stock · 4 Import Instructions
  3. Keep the first row (the headings) and fill one row per product and branch, in this column order:

    #ColumnWhat to type
    1SKU (required)The SKU of the product or variation.
    2LocationThe business location name. Leave blank to use your first location.
    3Quantity (required)The quantity you have.
    4Unit Cost (Before Tax) (required)The purchase price of one unit, before tax.
    5Lot NumberOnly if you use lot numbers.
    6Expiry DateOnly if you track expiry, as month/day/year, e.g. 12/31/2026.
  4. Save the file as XLS, XLSX or CSV (up to 10 MB and 5,000 rows).

  5. Back on the page, choose the file and press Import Opening Stock. Wait until Importing... finishes.

  6. Check a few products: open List Products and look at their stock, or open the product's Opening Stock window.

Was this page helpful?