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:
If the import status shows 'Error', you can download the error CSV file and review the errors indicated.
6. Once the import is done, you will see the new customers on the Customers page.
Update Customer Information via CSV
You can edit or update your customers' details by re-uploading an updated CSV file.
1. Export your current customer list (see Export Customer Data below) or use the CSV template.
2. Edit the customer details you want to update in the CSV file.
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 | The CSV file must match existing records by email, phone number, or Member ID. If none of these match, the system creates a new customer instead of updating the existing one. |
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. |
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?
No. The import tool does not merge or remove existing duplicate phone number or name records.
3. What happens if my CSV has duplicate rows for the same Customer ID?
The system uses Customer ID 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 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.