Who Is This For?
StoreHub merchants who want to import customer information in bulk using a CSV file, update existing customer records, or export their customer list from BackOffice.
Overview
This article covers how to import customers into BackOffice using a CSV file, update existing customer records via CSV re-upload, and export your full customer list. For adding customers one at a time, see this article.
Before You Begin
Access to BackOffice.
A stable internet connection.
A spreadsheet program (e.g. Microsoft Excel, Google Sheets, or Apple Numbers) to edit CSV files.
Step-by-Step Guide
Import Customer Information
1. In your BackOffice, go to 'Customers', then click 'Import CSV', then click 'Download template'.
2. Open the downloaded CSV template in your spreadsheet program and fill in the customer details according to the required fields.
3. Save the file when you are done.
4. In your BackOffice, go to 'Customers', click 'Import CSV', then click 'Select File' to choose your saved CSV file and click 'Import'.
5. You will see the import status in the table below.
Note:
BackOffice matches rows to customers using the 'Customer Id' column, not the email, phone number or Member ID. The only place to get a customer's 'Customer Id' is a file you download with 'Export to CSV'. It is not shown anywhere in BackOffice and it is not in the blank import template.
The 'Customer Id' is what identifies which customer a row updates. If a row has no 'Customer Id', BackOffice falls back to checking the phone number and will not update on it, but to decide whether the row can be created or has to be skipped.
6. Once the import is done, you will see the new customers on the Customers page.
What It Means (Breakdown of System Logic)
Scenario | What System Does | What Happens Now |
Has 'Customer Id' | Updates that customer | Existing profile is overwritten with new data. |
No 'Customer Id', phone number new | Creates the customer | System registers a brand new customer account. |
No 'Customer Id', phone number used, row identical | Nothing happens ('Completed') | Safe duplicate. System ignores it as no new info is added. |
No 'Customer Id', phone number used, row has new/different details | Row skipped (Error message) | Conflict detected. Manually add the 'Customer Id' to update or edit the existing record. |
No 'Customer Id', number is on two or more records | Row skipped (Error message) | Multi-duplicate collision. Must merge existing system records before importing. |
Update Customer Information via CSV
You can edit or update your customers' details by re-uploading an updated CSV file.
1. Click 'Export to CSV' on the Customers page to download your current customer list. Use this file, not the blank template. Do note only the export has the 'Customer Id' column that tells BackOffice which customer each row belongs to.
2. Edit the customer details you want to update in the CSV file.
Note:
Do not delete or rename the 'Customer Id' column while you are editing the file. It is what tells BackOffice which customer each row belongs to. Without it, rows for customers you already have will be skipped instead of updated.
3. Save the file and re-upload it using the same Import CSV steps above.
Note:
The updated CSV file must match the existing records by email, phone number, or Member ID so the system can identify the correct customer to update.
Export Customer Data
1. In your BackOffice, go to 'Customers'.
2. Click 'Export to CSV' to download all customer details.
3. For 10,000 records or fewer, the file will download immediately as a CSV.
4. For more than 10,000 records, a pop-up will appear notifying you that the export will be sent to your email.
Note:
The email will be sent to the BackOffice account email of the user who triggered the export.
5. Click 'Download CSV Export' in the email. The file will download in a zip folder format.
6. Extract the zip folder and open the CSV file with a spreadsheet program (e.g. Google Sheets, Numbers, or Microsoft Excel).
Fix Export Errors
If the export encounters an error, you will be notified in BackOffice and by email.
1. You will see a notification in BackOffice:
2. You will also receive an email notification:
3. Click the button in the email to retry the export.
Note:
If the export fails again, contact StoreHub Support for assistance.
Troubleshooting
Issue | Solution |
Import status shows 'Error' | Download the error CSV file from the import status table. It will indicate which rows have errors and why. Fix the errors and re-upload. |
Import did not update existing customers | Your file is probably missing the 'Customer Id' column. Export your customers with 'Export to CSV', correct the rows in that file, and import it back. Leave the 'Customer Id' column exactly as it is. |
Export button not working | Check your internet connection and try again. If the issue persists, try using a different browser or clearing your browser cache. |
Did not receive export email | Check your spam or junk folder. The email is sent to the account email of the user who triggered the export. If you still cannot find it, try the export again. |
CSV file shows garbled text | Make sure you are opening the CSV file with a spreadsheet program (Google Sheets, Excel, or Numbers). If special characters appear incorrectly, try opening with UTF-8 encoding. |
A row was skipped and says 'more than one existing customer has this phone number' | Two or more of your customers already share that number. Go to 'Customers', click 'Review duplicates', merge them, then import the row again |
A row was skipped and says 'this row differs from the existing customer with this phone number' | A customer already has that number and your row has different details. Edit that customer in BackOffice, or add their 'Customer Id' to the row and import again |
FAQs
1. Can I import just a few customers instead of my full list?
Yes. You can delete all other rows from the CSV template and import just the customers you need. The rest of your customer records will not be affected.
2. Will importing a file remove duplicate records?
The import tool itself does not merge or remove duplicates, but BackOffice now has a tool that does. Go to 'Customers' and click 'Review duplicates'. See How to Merge Duplicate Customers in BackOffice.
3. What happens if my CSV has duplicate rows for the same 'Customer Id'?
The system uses the 'Customer Id' column to match rows. If multiple rows share the same 'Customer Id', the last row in the file wins and overwrites the earlier ones. Example: if two rows have the 'Customer Id' "abc123", only the data from the last row will be saved.
4. Can I export more than 10,000 customer records?
Yes. If your customer list exceeds 10,000 records, the export will be sent to your email instead of downloading directly. Click the download link in the email to get the file.
5. Can I add customers manually instead of using a CSV?
Yes. You can add customers one at a time from BackOffice or from the POS register. See this article.
Need Help?
Contact StoreHub Support via live chat in your StoreHub app or email [email protected].
Was This Article Helpful?
Let us know below or contact support for further assistance.