• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Shopify to Wati - Phone number formatting issue

expedigit

Member
I need some help with formatting phone numbers for WhatsApp messages. I'm using Pabbly to automate sending WhatsApp messages (Wati) after a Shopify purchase, but customers enter their phone numbers in different formats (with or without country codes).

So currently when I map the "customer default phone number" field to WhatsApp number in Wati, it doesn't always goes to the intended person (due to irregularities in phone number formatting)

Any tips on how to standardize phone numbers and add the correct country code automatically? if it was a google sheet, i'd add a formula like this to fix this:
=IF(LEN(A1)=10,"91"&A1,IF(LEFT(A1,2)="91",A1,IF(LEN(A1)=13,A1,"")))


Any help appreciated!
 

ArshilAhmad

Moderator
Staff member
Hi @expedigit,

You can try using the 'Number Formatter: Format Phone Number' action step to add a country code to the phone number.
1728153127368.png
 

expedigit

Member
If i do so, the result comes with "+" and country code, or without either. i need without "+" and with country code.
if you can see the screenshot of Wati, it'll be written "Enter a valid WhatsApp number with country code without plus (+) sign. Ex: 919039843231".

Pl shelp me navigate this issue.

1728206752520.png
1728206779928.png
 
Top