When you are migrating your store to Shopify, you definitely want to take your customers with you. You need to migrate them and invite each customer to activate their accounts. This is how you do it with Bulk Import Export with Excel app:
- Import list of customers to Shopify.
- Export those new customers from Shopify by generating Activation URLs.
- Import list of customers with their activation URLs to MailChimp (or any other mass mailing service).
- Send out e-mail campaign to new customers from MailChimp with nice invitation to activate their accounts.
It may look complicated, but trust me, when you will do it once, and understand the system, this will take you not more then 15 minutes to set up everything.
1. Import list of customers to Shopify
If you are migrating customers from your old Shopify store to new Shopify store, then you just use this same app in both stores: export from old, and import into new one.
If you migrate your customers from another platform, they still should have the capability to export customers to some file. Exported file will be different for each platform, but usually there are such fields as: email, first name, last name, phone number, company name, address, shipping address, billing address, etc.
For example, let’s take this export from some other platform:
Prepare data file for the import. App needs particular format for importing customers’ data. It can be found in the template. You need to transfer data from your export file into import file or edit exported file to mach that template.
- Columns ID, State, Accepts Marketing, Updated At, Total Spent, Total Orders, Last Order Name, Note, Verified Email, Tax Exempt, Tags, Address ID can be left blank or deleted to make things more simple.
- If you have several addresses for one customer, for example, shipping address and billing address, you should provide them in different rows. Add another row and fill in Email column with the customers email, and second (third, forth, etc.) address.
- Address Is Default shiuld be filled with TRUE, if there is more then 1 address for the customer. One of the addresses will be default.
- Created At can be filled with date_registered or todays date.
- remember to name the sheet “Customers”
- Here is example of my file:
Import customers with the app.
Yuhuuu! Customers are imported!!!
At this moment we just imported customers’ data into Shopify store. If customer would like to login, he or she does not have the password. And actually, how the customer will know about the new store? We need to notify our customers about our brand new marketplace and ask them to activate their accounts. Let’s do that!
Export list of customers from Shopify with generated Activation links.
Shopify provides the functionality to send account invite for non-active customers. Open any customer data we just imported and see Send account invite right under the customer name:
Click on Send account invite and you will get the form for email:
I filled it in with information I want to provide to the customer. Click on Review email:
Click Send notification and you will get the email with activation link. You can test this and activate account.
Clicking on Activate your account will bring you to the Activation page:
Doing like that you can send Activation email to one customer at a time. And if you have 100 or 1000, or even more customers?
We will save time and send activation emails in bulk.
We need to get Activation URLs for all customers for that.
To get this data, lets export customers customers with Bulk Import Export with Excel app. Check Activation URLs when exporting:
You will get Activation URLs in the Export file.
There are a lot of columns, but we will need only 4 of them Email, First Name, Last Name and Activation Account URL. So, I will delete all other columns:
Create the list of customers in MailChimp.
There is a service MailChimp, that allows to send notifications, campaigns, newsletters etc. to lists of customers. As we want to send Account activation emails to several customers at a time, let’s first create the list of customers.
Login (or register) into MailChimp service.
Click on Lists -> [Create List] and fill in list data. I called my list “Migrated customers”:
Of course, we will not add customers to the list manually 🙂 We will import the date from the Excel we exported from the Shopify earlier (the one with Activation URLs). Click Imports subscribers: Will import from xlsx file: There are 3 mandatory fields: Email Address, First Name, Last Name. We will need one more field: Activation URL (as we need to invite customers to activate their accounts in our new shop).
Now we need to open the exported Excel, copy all data and paste it to the MailChimp form:
Now we need to help MailChimp to understand what data about customers we want to import.
In the column names select appropriate title and press Save. Do it for Email Address, First Name and Last Name columns. For Activation URL column you need to add New column name. I will call it Activation URL.
Now we have all customers’ data imported:
We will do one more thing. Go to the Lists. Open Migrated Customers list. Click Settings -> List fields and *| MERGE |* tags
Here we will change tags for the First name field and for the Activation URL field. Set NAME and URL accordingly. Press Save Changes. We will need this when creating Activation email.
For the testing purposes I will create one more List and call it Test Customer. This list will contain only one customer with my own email. I will copy real Activation URL (from the Excel) and also add field tags as in the previous step. With this list I will test, if email is sent as I wanted it to be and if Activation URL is working correctly.
Create the campaign in MailChimp for sending Activation emails and send.
Now we need to create a New campaign in the MailChimp with what we will send the information to our customers and invite them to activate accounts. Click Campaigns -> [Create Campaign]
Choose Create an Email (as we will send the Campaign via email).
Name your campaign
Choose the list of customers – Migrated customers Fill in Campaign info:
Pay attention to the checkbox Personalize the ‘To” field. I Check it and put field tag *|NAME|* *|LNAME|* in recipient name. Remember, we added these tags earlier, when creating the list? So, now each customer will get the personalized email, with his/her First name and Last name as the recipient.
MailChimp provides a lot of templates for email campaigns. I will choose “Make an Announcement” template
There will be prepared boxes that you need to modify and deleted what you do not need. Imagine how do you want the email to look like. Do you need any images? What text will you put there and attract your customer and make him/her interested to activate account.
When you have approximate idea, click on the appropriate box and modify it.
I have added the Logo. Then I edited the box with the text.
I deleted boxes with images and all other except the button.
I edited the button as follow:
In the Web address (URL) field I put URL tag that we added, when creating the list. This button will take each customer to his/her own Account activation page, as it will take his/her particular Activation URL from the list.
Press Save and Close.
Now we can test it with test email. Go Preview and Test -> Send a test email.
Provide the email, where you want to send test and click [Send Test].
Here is mine
Looks goof to me. Activation button will not work here, as this is just a test. But I would like to test, if the button will work in the real email, so I will send this Campaign to my Test Customer list (remember, I have created one?)
I will click Next
Here I will change the list. Click on [Edit] for the List and choose Test Customer list
Click Next -> Next -> Next. And then click Send!
MailChimp will as you one again
Click Send Now!
And now wait for the email 🙂
I have got mine
Now I see there Name and Last name. And [Activate Now] button will take me to the Activate Account page
Now we should send Activation emails to the real customers.
Go Campaigns. For the New Store Account Activation campaign choose Replicate
Choose Migrated Customers list
Click Next, Next, Send.
You will be asked again if you want to send. There should be 4 subscribers (in my case). Click [Send Now].
And we are done!