Quick steps

  1. Export your customer list and your price list from your old system or spreadsheet, and save each one as a CSV file.
  2. Open Sales › Contacts, click Import, choose your customer file and check how its columns are matched.
  3. Click Check rows, fix any row shown in red in your spreadsheet if you need it, then import the customers.
  4. Open your price list's draft, import your items and prices the same way, then Preview and Publish the price list.
  5. Take your first order with an imported customer and item.

Before You Start

  • You need a CSV file with a heading row, up to 5,000 customers or 500 items in one file. From Excel, choose File › Save As › CSV UTF-8. From Google Sheets, download the sheet as CSV.
  • Not sure what the file should look like? In the import window, click Download a sample file.
  • The import brings in customers, items and prices. Past orders, balances, points and store credit don't come over: keep your old system's records for those.
  • To import customers you need to be able to add and edit customers. To import prices you need access to Price Lists in Settings.
  • The customer Import button shows when all your shops share one customer list. If each shop keeps its own customers (⚙️ Settings › Records, Who can find a new contact set to Only the shop that added them), add customers at each shop instead.

Step 1: Import Your Customers

  1. In the Console, open Sales › Contacts.
  2. Click Import at the top right of the list, beside Add Contact. The Import customers window opens.
  3. Choose your CSV file. Each row becomes a customer with their name, phone, email, address and notes.
  4. Check the matched columns. EasyBiz matches each column by its heading, for example "Mobile" to Phone. If a match is wrong, pick another field from its list, or Don't import for a column you don't need.
  5. Click Check rows. Each row shows Ready, Skip or Fix:
    • Fix (in red): the row needs a name, and a phone number or an email, or a phone number or email doesn't look right.
    • Skip: the phone or email is already on a customer, or on an earlier line of the same file, so nobody is added twice.
  6. If you have more than one shop, choose Where these customers registered.
  7. Click the import button, for example Import 1,226 customers. Keep the window open until it finishes: it shows how many customers were added and skipped.

Rows in red are left out. Fix them in your spreadsheet and import the same file again later: rows already imported are skipped then. More detail: Your Customer List: Find, Filter and Export Contacts.


Step 2: Import Your Items and Prices

Your items and prices go into your price list's draft, so nothing changes at your counter or online until you publish it.

  1. Click the ⚙️ Settings icon, then Price Lists under Catalog & Pricing.
  2. Click the ⋮ menu on your price list's row, then Draft new version, or Edit draft version if a draft is already open.
  3. Click Import at the top right and choose your items file. Each row is one item: its name, and if you have them its category, unit and code, with one price column for each service, for example "Dry Clean" and "Wash & Iron". Write a price like 3.50 or $3.50. A blank price cell leaves that price as it is.
  4. Check the matched columns, click Check rows, then click the import button, for example Import 85 items. A new item is added to your products and to this draft, in the category from the file. An item already in the price list takes the prices from the file, as long as the file gives it the same unit or leaves the unit blank.
  5. Check the prices in the draft, click Preview, then Publish.

Prices that depend on a choice or on the quantity are set in the draft after the import. More detail: Manage Price List Versions.


Step 3: Take Your First Order

At your counter, start an order, search for an imported customer by name or phone, add an imported item and check its price. If both are right, your move is done.


Example: CleanFast Laundry Moves From Its Old POS

CleanFast Laundry exports 1,240 customers and 85 items from its old POS. The customer file's check shows 1,226 ready, 10 skipped because the same phone number is on two lines, and 4 to fix with no phone or email. CleanFast imports the 1,226, then fixes the 4 in the spreadsheet and imports the file again: only those 4 are added. The 85 items go into the Laundry price list draft, and the owner publishes it after checking Shirt at $4.00 for Wash & Iron.


FAQs

What happens if I import the same customer file twice?

Nobody is added twice. A customer whose phone or email is already in EasyBiz is skipped.

What happens if I import the same items file twice?

Items already in the price list keep one entry each, and the prices in the file replace their old prices in the draft. Nothing changes at the counter until you publish.

The import stopped halfway. What do I do?

Import the same file again. Rows already saved are skipped, and the rest are added.

Can I import an Excel file?

Save it as CSV first. In Excel, choose File › Save As › CSV UTF-8, then choose that file.

Do my customers' past orders and balances come over?

No. The import brings in customers, items and prices only.