← All help articles

Move from your old system: import customers, services, products, staff and appointments

What you can bring over

  1. Customers — incl. prepaid packages, stored value (with bonus), points, member number and level, last visit and total spent.
  2. Services & prices, products & stock (opening stock per branch), staff list and upcoming appointments.
  3. Files: CSV, Excel (.xlsx and old .xls), a Google Sheets export, or paste a table copied from Excel / Google Sheets. Templates for every list are on the upload page.

Step by step

  1. Export the list from your old POS or booking system (or Excel / Google Sheets).
  2. Open Settings → Import data (or the setup wizard step "Import from your old system") and upload the file. Choose what is in the file or let it be detected.
  3. Senvia's AI matches the columns. It only sees the column headers and about 20 sample rows; the full file is processed by Senvia's own system.
  4. Check the matching. Columns the AI is not sure about are not guessed: they are listed (e.g. "column 3 “Kod”") and set to "Don't import" — pick a field if you need them.
  • One field can be used by several columns (e.g. "Phone" and "Mobile" both → Phone, or two note columns → Notes). Nothing is greyed out; the picker notes "also used by column 4". Text fields (notes, tags, address, packages) are combined; single-value fields (name, phone, birthday …) take the first filled column of each row. Tap "Use only this column" to undo that.
  • If each row holds two customers side by side (Name / Phone / Name 2 / Phone 2), Senvia offers to split them into separate customers; problems then say e.g. "row 12 (set 2)".
  1. Press Check the data. The preview lists every problem with its row numbers (e.g. "Rows 12, 45, 88: phone number format is wrong"). Fix a row right there or skip it, then check again.
  2. Press Import. It runs in the background with progress; afterwards you see what was created, updated, skipped and failed, and can download the error report (with row numbers).

Undo, duplicates and balances

  1. Undo this import is possible for 7 days — unless records were used since (e.g. a sale, a booking or a stock change).
  2. Customers are matched by phone and e-mail: choose to skip, fill empty fields or overwrite. Services, products and staff that already exist are skipped.
  3. Packages and stored value become customer balances with the note "导入自旧系统" (imported from the old system).
  4. Your plan's limits apply: rows over the limit are listed as problems.

Signed in? Open the help assistant in the app for answers tailored to your role.