Skip to content

Import sales

All plansOwner / ManagerAccountantUpdated 15 Nov 2026

What you'll do: bring sales from another system or a spreadsheet into Hala. Each group of rows becomes one invoice, and each import is kept as a batch you can revert.

Before you start:

  • Your role needs sell.create.
  • The products must already exist in Hala (matched by Product name or Product SKU), and so must any tax or unit you name in the file.
  • A file can have at most 5,000 rows. Split bigger files.

Open Import Sales

  1. Open Inventory & Products → Import → Import Sales.

  2. Press Download Template if you don't have a file yet, and fill it in. The Importable Fields table on the page explains each column. The important ones:

    • Customer phone number or Customer email: one of them is required;
    • Product name or Product SKU: one of them is required;
    • Quantity and Unit price: required;
    • Invoice no., Sale date (keep the date format shown), Product unit, Item tax, Item discount, Item description, Order total: optional.
    1 Download Template · 2 File · 3 Upload & Review · 4 Importable Fields
  3. Choose your file (XLS, XLSX or CSV (MAX. 10MB)) and press Upload & Review.

  4. On Preview Imported Sales:

    • Group Sale Line By: the column that tells which rows belong to the same invoice (usually the invoice number);
    • Business Location: the branch the sales belong to;
    • under each column of your file, pick the field in Map To, or Skip to ignore it.
    1 Group Sale Line By · 2 Business Location · 3 Map To · 4 Import SalesTODO
  5. Press Import Sales. When it works you see Sales imported successfully. and the batch appears under Import History.

  1. On the Import Sales page, find the batch in Import History (Import Batch, Import Time, Created By, Invoices).

  2. Press Revert Import and confirm. This will delete all sales associated with this batch. You see Import reverted successfully.

Was this page helpful?