Sign in Sign Up Free
Language
English Français العربية Español हिन्दी বাংলা Türkçe Deutsch Português اردو

Import customers and suppliers

Bring customers and suppliers in from an Excel file: the columns, the required ones, and what stops an import.

2 min read Updated 19 Oct 2026

Names like these, in green, are pages inside your ArmPOS shop. Sign in to your shop to open them.

Moving to ArmPOS with a list of customers or suppliers? Bring them in from a spreadsheet instead of typing each one. By the end you will have imported both.

Customers

  1. Open People › Import Customers, or Import Customers on the customers list.
  2. Click Download example. It is an Excel file with the right columns. Fill it, one row per customer.
  3. Drop your file on the box, or click it to choose the file. XLSX and XLS files of up to 20 MB are taken. Remove takes it away again.
  4. Click Import now. You land on the customers list, with the new customers in it.
Import Customers: the drop box for the Excel file, the Example format table with Username, firstname, lastname, code, email, phone, tax_number, country, city, Address and opening_balance, and the Import now, Download example and Reset buttons.
The page shows the columns it reads. Download example gives you the same file to fill.

The columns:

Column Required What goes in it
username (or name) yes the name shown on sales and receipts
code yes a whole number, unique for each customer, such as 2001
firstname, lastname no
email no a valid address; no two customers may share one
phone no with the country code, such as +256
country, city, adresse (or address) no
tax_number no
opening_balance no a number: what the customer already owed you

If any row has a problem, nothing is imported. The page lists each problem by row: a missing name, a code that isn't a whole number, a code or email used twice in the file, or a code or email that is already in your shop. Fix them and import the file again.

Suppliers

The same, from People › Import Suppliers: name and code are required, then email, phone, tax_number, country, city and adresse.

Import Suppliers: the drop box, the Example format table with name, code, email, phone, tax_number, country, city and Address, and the Import now button.
Suppliers take the same file shape, without first and last names or an opening balance.

What's next

Customers.

Still stuck?

Write to us and a person answers. If you already have a shop, Ask support inside it sends us the page you're on.

Contact us

Ask your AI assistant

ChatGPT, Claude and Gemini can read every guide and walk you through it.

Set it up