Import Customers

You can create a customer/wholesaler account by importing their information. This is helpful when you need to create accounts for your wholesalers without doing it manually.

Step 1: Head to Import Customers

From Customer management, choose Registration forms > Registration management, hit the Import button

Step 2: Import file

• First, please choose a registration form that you want to use

• Second, it is optional for you to download the sample file to see which columns and their title should be included in the file

• Third, add the file from your device. Customer file data should follow the instructions below:

Import file instructions

1. The file type must be .csv or .xlsx

2. first_name is your customer's first name

3. last_name is your customer's last name

4. email should be unique and should not exist in the system. The email format is [e-mail]

5. tag: tags given to this customer account

   • It should be less than 40 characters (according to Shopify's requirement)

   • You can add multiple tags, and separate them by a comma (",")

6. tax_exempt: fill in whether you want to charge tax on this account or not

   • yes: If you want to

   • no: If you do not want

7. phone should be in the format of E.164 standard

   • It should contain your country phone code (i.e: +1 for USA)

   • It should not exist on the Shopify database

8. company is your customer company info (i.e company's name)

9. address is your customer's address.

10. city is your customer's city

11. country_code is the international code of your customer's country (i.e: VN is the country code of Viet Nam)

    • Refer to this document to get the country code
12. state_code: fill in your customer's state/province/emirate/region/governorate

    • Refer to this document to get the state code
13. zip is your customer's zip code

14. apartment is your customer's apartment info

15. vat validation: fill in your customer's valid EU VAT ID

16. uk validation: fill in your customer's valid UK VAT ID

17. us_ein_validation: fill in your customer's valid US EIN ID

18. abn_validation fill in your customer's valid ABN ID

19. gst_validation fill in your customer's valid GST ID

20. subscribe_to_our_newsletter fill in whether this customer account would subscribe to your newsletter or not

    • yes: If it would

    • no: If it would not

21. dropdown_selection(s): fill in the value of the option that you've set

22. multiple_checkbox: fill in the value (s) of the option(s) that you've set, and separate them with the slash symbol ("/")

23. text_field fill in any the customer's data according to your form setup

24. text_area fill in any the customer's data according to your form setup

The Password field was remove from the imported customer data

• Validate VAT:

  • Tick if you'd like to validate all VAT IDs filled in the file

  • Untick if you only need to collect your customers' VAT ID without validating it.

If you need further assistance, please feel free to reach us at [e-mail] or Live Chat.