Summary
Want to bring your Shopify customers into Wati so you can message them on WhatsApp? This guide explains two easy methods to import your Shopify contacts into Wati — using a batch upload for many contacts at once or adding them manually one by one. Follow these simple steps to get started.
Instructions
Methods to Import Contacts from Shopify to Wati
There are two ways to import your Shopify customer contacts into Wati:
Method 1: Batch Upload using a template file (best for importing many contacts at once)
Method 2: Manual Update (best for adding a few contacts)
Method 1 - Import Contacts Using Batch Upload
This method is useful if you want to import multiple contacts from Shopify at the same time.
Steps to Import Contacts in Bulk:
Export your customer list from Shopify:
Go to your Shopify admin.
Navigate to the Customers page.
Export your customer list as a file.
Log in to your Wati account.
Click on the Contacts tab from the left-hand menu.
Download the sample Excel template provided by Wati.
Fill in the Excel sheet:
Add the customer names.
Add the phone numbers with the correct country code.
For example, Hong Kong (HK) phone numbers should start with
852. So, enter the number like85212345678.
Leave other fields blank if you don't need to update them right now — you can update attributes later.
Upload your completed Excel file:
Click the Import button in Wati.
Select your file and upload it.
That's it! Wati will process your file and import the contacts.
Method 2 - Add Contacts Manually
This method is ideal if you only need to add a few contacts.
Steps to Add a Contact Manually:
In your Wati account, go to the Contacts page.
Click on the Add Contact + button.
Fill in the contact details:
Enter the customer's name.
Enter the phone number with the country code.
For example, a Hong Kong number should be entered as
85212345678.
Tick the checkboxes for:
Allow Broadcast
Allow SMS
Click Save.
Your contact will now be added to your Wati account and ready for messaging.
Frequently Asked Questions (FAQs)
General Questions
1. What are the different methods to import contacts from Shopify to Wati?
→ You can import contacts in two ways:
Batch upload using an Excel template (best for importing many contacts at once).
Manual update by adding individual contacts directly in Wati.
Batch Upload Method
2. Where can I get the sample Excel template for importing contacts?
→ After logging into your Wati account, go to the Contacts tab and download the sample Excel sheet provided.
3. What details do I need to fill in the Excel sheet?
→ You need to enter the customer's name and phone number. Ensure the phone number includes the correct country code (e.g., Hong Kong numbers should start with 852).
4. Can I leave some fields blank in the Excel sheet?
→ Yes, you can leave non-mandatory fields blank. You can update those details later in Wati.
5. How do I upload the completed Excel file?
→ In the Contacts tab of your Wati account, click the Import button and upload your completed Excel sheet.
Manual Contact Addition
6. How do I manually add a contact in Wati?
→ Go to the Contacts page in your Wati account, click Add Contact +, enter the customer's name and phone number (with country code), tick Allow Broadcast and Allow SMS, then click Save.
Phone Number Format
7. How should I format phone numbers when importing?
→ Always include the country code before the phone number. For example, a Hong Kong number should be entered as 85212345678.