Setup and documents

How to import customers into POS from a file

How to import customers into POS from a CSV file: download the template, match the columns, check the rows and import. Suppliers use the same steps.

Short answer To import customers into POS, open Import and export under Setup, choose Customers and pick a CSV file. The file is checked first, and one wrong row refuses the whole file, so nothing is added. Basic and Professional have imports. Lite does not.

Applies to Basic, Professional

A new shop often starts with a list of customers and suppliers in a file. This guide shows how to bring that list into POS, from a CSV file, without typing every name by hand. Import is in Basic and Professional. Lite has no import. The steps are the same for customers and for suppliers, and the page is under Setup.

What you need

  • Edition: Basic or Professional. Lite has no import or export.
  • Permission: the permission to create customers, customer.create, for a customer list, or supplier.create for a supplier list.
  • File: a CSV file. To download the empty template, you also need the export permission for that list.

How do I import a customer list?

To import a customer list, open Import and export under Setup and stay on the Import tab. Choose the Customers tile, download the template or use your own file, then go through the four steps. The file is checked before anything is added.

  1. Open Import and export. Go to Setup, then Import and export. The Import tab opens.

  2. Choose the list. Choose the Customers tile. For a supplier list, choose the Suppliers tile.

  3. Choose a file. Choose Download template to get an empty file with the columns the list needs. Or choose Choose a file to pick your own CSV file.

  4. Match the columns. Each field in the template is matched to a column in your file. The next step stays off while a required field has no column.

  5. Check the rows. SellyPOS reads every row and reports the problems before anything is added. If any row has a problem, nothing is added and you are shown the rows to fix.

  6. Choose Import. The rows are added.

What happens if one row in my file is wrong?

The whole file is refused, and nothing is added. The check lists the rows to fix. Correct those rows in your file, then choose the file again. Every row is checked before anything is added.

Can I import a spreadsheet file directly?

No. Spreadsheet files cannot be imported yet. The import reads a CSV file only, so save the sheet first. In your spreadsheet program, choose File, Save As, then CSV UTF-8, and import the CSV file it saves. Products are imported from the Products page, not from this page.

Can I take a copy of my customer list out?

Yes. Under Import and export, the Export tab saves a copy of your products, customers or suppliers as a CSV file. The saved file can be loaded again later, so keep it as a copy of your list. Only those three lists can be exported.

If something is not as you expect

  • Only CSV is imported here. Spreadsheet import is not on this page, so save the sheet as CSV UTF-8 first.
  • Saved column matches and partial imports are not on this page. Each import matches its columns again, and a file is imported all at once or not at all.
  • A phone number can belong to one customer only. If you save a phone number that another customer already has, the save is refused. The holder of the number is named.
  • A customer needs only a name or a phone number. To add one customer by hand, nothing else is required.

Next

To bring in a product list instead, read how to import your products from a spreadsheet. To manage the credit each customer has, read how to manage customer credit. For the whole area, see customers and credit. For a related post, read how to move from a notebook or spreadsheet to POS software.

Pricing shows what each edition costs. Download SellyPOS to try it.

Questions people ask

How do I import my products from an Excel file?

The import shows each column of your file on its own row, with up to three examples from its first rows. Choose the product field each column imports as, or Don't import. Recognised columns are already matched. If the workbook has product details on several sheets, they are joined by their column names and read as one list. A row whose name, SKU or main barcode matches a product already in the shop is skipped, and so is a variant of a main product already in the shop. See import products from Excel.

Start selling with SellyPOS today

An installed Windows app with a modern interface, made to sell from the keyboard. It keeps selling with no internet.

Windows 10 (version 1809 or later) or Windows 11, 64-bit.