Hi,
I am an online seller , accepting payments through paypal .
I need a solution having a system to automatically email buyers their tracking number with ease.
The webserver used to send the emails should be in white list meaning it will not go into SPAM/JUNK mails by standard emails provider.
Requirement:
Please open the attachment [login to view URL] workbook -> ORDERS2010b sheet (which is my orders tracking excel).
Look in to column E (Seller Account) ,column F(Item) ,column G (Buyer Name) , Column H + Column I + Column J (Buyer Full Address), Column M (Buyer Email) , Column Q (Tracking Number)
The system should be able to process the rows of orders I have selected and automatically send emails to buyers using predefined messages accordingly.
Note : There are 3 different Tracking Number Type :
1> Hong Kong Post (Tracking number Ends with HK)
2> Singapore Post (Tracking number Ends with SG)
#) EMS China (Tracking number Ends with EMS)
_____________________________________________________________________
Standard Email Message:
To: "Column M"
Subject: Tracking number for your order "Column F" ( Seller: "Column E)
Dear "Column G",
Thank you for your purchase . We have shipped your item and the tracking number is as below:
Tracking Number : "Column Q"
Tracking Website : "According to Condition Con1 Below"
Con1 Condition=
If country is United States
Tracking Website is
[login to view URL]
else
Other Countries
Look in to Column Q and see if what is the Ending Code for the Tracking Number (HK OR SG OR CN)
IF HK
Tracking Website =
[login to view URL]
IF SG
Tracking Website=
[login to view URL]
IF CN
Tracking Website=
[login to view URL]
Thank you for purchasing with us.
We have got the tracking number of your item from our dropshipper. Item has been shipped on but it seems to
take slightly longer in custom clearance from dropshipper location . It is on the way to you.
NORMAL DURATION:
("Duration" "According to Condition Con2" Below) weeks delivery time usually after date of item shipped.
If Column J= Unites States , United Kingdom ,Canada
Duration =2-3
Else =3-6
We offer 100% CUSTOMER SATISFACTION for all products
At any time when you receive it and you are not satisfied you can contact us for a claim
Sorry for any delays.
Kindly hold on till delivery.
Thank you.
_____________________________________________________________________