Skip to content
Nabeeh Nabeeh Help Center Open the app

Import customers

Add many new customers from an Excel file in the Import & Export Center: the template, the mobile number rules, branches and what happens to rows with errors.

Use this import to add many new customers at once. It only adds new customers: it never changes the customers already in your account.

Where to start

  • On Customers, open Customers Settings and select Bulk Customer Import, or
  • open the Import & Export Center and select Import on the Customers row.

Import shows to whoever may add customers. The import then follows the steps in Import your data: file, review, import and result.

Note: Bulk Customer Import now opens this import screen instead of the bulk import page you already know; a batch you had already started on that page stays open for 30 days so you can finish it: reach it from Customers Settings › Continue the open import batch. If a mobile number in that batch has been registered in your account since you uploaded it (through this import, for example), it is not created a second time: when you submit, the page tells you how many rows this affects and shows them in the table with the error “This mobile number is already registered in the system.” for you to correct or delete. After 30 days, or when nothing is left to finish in the batch, the page takes you to the new import screen with a message explaining why; the batch's rows are not carried over.

Fill in the template

Select Download template. The Customers sheet has the same columns as before: Customer Type, Company Name, Full Name, Mobile Prefix, Mobile Number, Gender, Is Active and Branch. Columns marked with * are needed on every row, and the drop-down lists hold the accepted values. Files made from the old template, with or without the Branch column, are read the same way.

  • Customer Type: Individual or Company. A company customer also needs a Company Name; it is ignored for an individual.
  • Mobile Prefix and Mobile Number: both are needed, for example +966 and 512345678.
  • Gender is optional; a value we don't recognise adds the customer without a gender, with a warning on the review step.
  • Is Active: Yes lets the customer sign in, No does not. An empty cell means No, and so does a value we don't recognise, with a warning on the review step; pick the right value with Edit row before you import if you meant otherwise.
  • Branch (accounts with branches): leave it empty to add the customer to the branch you choose when you upload the file, or to your current branch. A branch name adds the customer to that branch; an unknown name, or a branch you are not assigned to, stops that row only.

Note: Save the file as .xlsx. Older Excel files in the .xls format are not accepted: open yours in Excel, choose Save As and then Excel Workbook (.xlsx), and upload that file.

The mobile number

The mobile number is what the customer signs in with, so each customer needs their own. A row is excluded when:

  • its number is already registered to a user in your account (a customer or a member of your team), or
  • the same number is on an earlier row of the file (the later row is excluded).

The number is checked again at the moment the row is imported, so a customer added meanwhile from the Customers screen is never created twice. To change an existing customer, edit them on the Customers screen.

Tip: On the review step, open the row's menu (⋮) and choose Edit row to fix a number or pick the type, gender and branch from your account's values; the row is checked again with the rows that share its number.

After the import

The result lists the customers created. Select Show them in Customers to open the list on this import's customers only; Show all brings the whole list back. Download the error file to fix the remaining rows and import them again.

Export Customers in Customers Settings gives you a file for reference only: it cannot be imported back to update customers. See Export your data.

What's next