In this guide, we’ll cover the following topics:
Benefits of the customer import tool
How to use the customer import tool
Starting an import
Mapping your data
Distinguishing data types
How to import subgroups
Using the tool to update existing customer data
Frequently asked questions
Upload thousands of records
Maintain accurate, up-to-date customer records with minimum effort. Choose your import file, map your data with intuitive dropdown bars, and begin importing. The customer import tool can be used to import 10,000 customer data entries without disrupting back office processes.
Update all customer records at once
Say goodbye to item-by-item updates. The customer import tool can be used to make changes to all customers at once, or to update records of smaller customer groups. Erply updates mapping options based on your dataset to keep your records highly accurate.
Custom uploads for a flexible upload process
Because Erply allows you to upload your own files, you can easily choose between updating all customers, or simply making changes to smaller customer segments.
Add any column to your spreadsheet, then map it to an appropriate data field within the import tool. Upload templates are flexible, allowing you to freely map your data regardless of column order.
Be sure to use our customer import template.
Don’t see a field that you need? Add a column to your spreadsheet and map the data in the importer. As long as the data field exists within Erply, you can add it to your spreadsheet.
In the back office, navigate to the Customers module and select Import customers.
Customers can be imported in the back office as a .xlsx or a .csv file. In order for your data to upload properly, you must select if you have a header row.
Click Upload and Start Mapping to begin your customer import.
Erply may predict where each data column should be mapped. Blank fields will need to be manually mapped.
Double-check that all data columns pre-filled by Erply are correctly mapped. If you need to change where a column is mapped, click the column’s header.
Select Confirm Mapping to finalize your data mapping.
Customer information: Used to set up customer-specific information such as name, point balance, etc.
Address information: Used to set up location-based information for a customer, such as their shipping address.
Contact information: Used for customers that are businesses or for companies that have individual contacts outside of the primary contact.
Although your data can be mapped into any column, we recommend choosing values that most accurately represent your data’s values.
In your import template, you always want to list the intended subgroup in the customer group column.
Using the following subgroup structure as an example:
West coast customers → LevelUp Rewards → PC-only
West coast customers → LevelUp Rewards → Xbox-only
West coast customers → Non-loyalty member
An example import template would look like this:
(not included in template)
|001||Billy Armstrong||West coast customers||Will be imported into the main West coast customers group.|
|002||Geralt Rivia||LevelUp Rewards||Will be imported into the LevelUp Rewards subgroup under the main West coast customers group.|
|003||Marc Brutus||Non-loyalty member||Will be imported into the Non-loyalty member subgroup under the main West coast customers group.|
|004||Luna Lovegood||PC-Only||Will be imported under the PC-Only subgroup under the LevelUp Rewards subgroup under the main West coast customers group.|
If you want to update existing customer data in bulk, scroll down to the option Match Existing Customers By.
We recommend selecting Customer ID as all customers are assigned a unique ID.
Erply will only display fields which have been assigned to a specific column. Follow the above steps to update your customer data in bulk.
I received an error saying “the field that is used to match the customer with existing users is empty.”
Erply sends this alert if it detects empty data in a column that’s selected for mapping. You can cancel the import and edit your file, or start the import regardless of the blank data.
Why isn’t my file importing?
The two most common import errors are improper formatting or bad data. Be sure to check over your data for blank columns and ensure that all columns are mapped correctly.
If a .xlsx file will not work, try saving the file as a .csv instead. This will strip away any formatting that Erply’s customer importer tool may be unable to read.
Is there a maximum amount of data I can import?
Erply’s customer import tool can handle approximately 10,000 records within an hour. While we do not have a dedicated upper limit, larger files have more potential for error and can tie up your API calls for longer periods of time.
We recommend larger imports should be started after hours, to allow ample time for the upload to complete.
What is the best way to match data when updating customers?
We recommend, if possible, to use the internal customer ID in Erply. The internal customer ID guarantees to be unique to each record and ensures accuracy.
A full list of identifiers that can be used to identify customers:
National ID no. / Reg. Code
How do I find the customer ID in Erply?
The customer ID is generated automatically by Erply, and can be found on any customer card. You can pull a report in the back office to view all customer IDs, if necessary.