Import Customer Data


Merchants can now bulk import a new user's data through SHOPLINE Admin. The system will then convert the data into basic user information.


Import Steps

Step 1. Download template for importing in bulk

Go to SHOPLINE Admin > [Customers], on the "Customer Management" page, click Import customers. 

There will be a pop-up asking you to upload a file. Click Template for importing in bulk, the enter the customer information according to the template. 




Step 2. Enter customer information


Notes for data input:

  • Fields marked with an asterisk(*) are required fields.
  • Please enter at least one of the contact information: email or mobile phone number.
  • When entering the mobile phone number, please enter the international code (e.g., +86 for China) as a reminder.
  • Field length: Check whether the fields have exceeded the limits according to the limited length of each column ("XXX field has exceeded the limits for xx characters, it can not be imported.")
    • Process for repeated data:
      • An error message will appear in the column for redundant mobile phone number/email: "Error has been recorded: A user already exists with the mobile phone number/email."
      • The system will not check on redundancy on other data fields.


Step 3. Upload and check the file

  1. File formats: supports .xlsx, .xls, and .csv formats
  2. File size: no more than 10 MB



  • After importing the file, the system will automatically convert the file data into customer data.
  • You can check all the import records in [Analysis] > [Bulk processing progress].


Import Record Inquiry

Path:  [Analytics] > [Bulk processing progress] - Type: Customers

Have more questions? Submit a request