DLGuard
fully integrated with the major payment systems
Paypal
Clickbank
2checkout
Authorize.Net
Click2Sell
1ShoppingCart
LinkPoint
AlertPay
eBay
PayDotCom
Mal's e-commerce
PagSeguro
CCBill
CommerceGate
DigiResults
FastSpring
JVZoo
MultiSafePay
WorldPay
Plimus
WSO Pro
Paypal Digital Goods
RevenueWire
SWReg
     

MySQL Query for Exporting Emails of Refunded Customers

 
Post new topic   Reply to topic    DLGuard Forum Forum Index -> Member's Tips and Tricks!
View previous topic :: View next topic  
Author Message
BlueSquares



Joined: 11 Jul 2008
Posts: 12

PostPosted: Wed May 19, 2010 3:18 pm    Post subject: MySQL Query for Exporting Emails of Refunded Customers Reply with quote

I personally send out updated versions of my Wordpress PPC Theme to all my customers.

Thing is...I don't want refunded customers to get the updates.

So I developed this very simple query to pull all the emails of refunded customers so I can remove them from my GetResponse Product Update mailing list.

Code:

SELECT `email`
FROM `customers`
WHERE date LIKE (
'%refunded%'
)


Just paste in the above code in PHPMyAdmin's "SQL" tab. Then click "export" at the bottom of the results page and select your export options on the next page. I usually leave the default, check CSV and submit.

Unfortunately, I don't see a way for GetResponse to remove them in bulk. Suck-a-roni.
_________________
PHP Link Cloaker | Wordpress Salesletter Theme
Back to top
View user's profile Send private message Visit poster's website
admin
Site Admin


Joined: 31 Jul 2005
Posts: 9393
Location: Australia

PostPosted: Wed May 19, 2010 11:15 pm    Post subject: Reply with quote

Nicely done!

I'm going to move this to the Members Tips and Tricks - I'll leave a shadow topic here too.

Thanks for sharing!

cheers
Sam
_________________
Sam Stephens
DLGuard: www.dlguard.com
GuardHQ: www.guardhq.com
-------
Keep up to date with DLGuard and other GuardHQ products: www.guardhq.com/newsletter.php
www.twitter.com/DLGuard
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    DLGuard Forum Forum Index -> Member's Tips and Tricks! All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group