Skip to content

Importing customers

Updated:

Read a customer list from CSV or Excel, with a check per row and a duplicate check, under Sales → Customers.

Open Import customers in Fiatto
In this article

If you are moving from another package, read in the customer list in one go. Under Sales → Customers, click Import (/dashboard/relaties/importeren). Fiatto checks every row first; only then do you import. Importing requires write access to customers and sales.

Steps

  1. Click Download template for a CSV with the right column headers, or use the export of your previous package: Fiatto also recognises English headers and the headers of Exact and AFAS. Only a column with the customer's name is required.
  2. Choose your file under File (CSV, XLSX or XLS, up to 5,000 rows) and click Check file.
  3. Read the result: Recognised columns shows which column becomes which field, Rows with an error names the problem per row (for example an invalid IBAN or email address), New customers what will be created and Duplicates (will be skipped) the rows with the same Chamber of Commerce number, VAT number, IBAN or debtor number as an existing customer or an earlier row. Fix errors in your file and check again.
  4. Click Import {n} customers (with the number of new customers). Fiatto reads the file again, creates the customers in batches of 500 and reports how many were created and how many duplicates were skipped.

Tips

  • If a cell starts with =, +, - or @, Fiatto removes that character so no formula ends up on the customer record; phone numbers and numbers are left alone.
  • New customers are screened against the sanctions lists, right away or overnight.
  • If the import stops halfway, the message says up to which row customers were created. Remove those rows from your file before you import the rest again.
  • If customers still look like duplicates after an import, a notice above the customer list links to the duplicate groups in Master data, where you merge them. See also managing customers.
Was this article helpful?
View all articles in this topic

Find another answer

A task, feature or short question is enough.