I need to export DORMANT CUSTOMER data from Send Email To Customers BUT i cant find it in PHPMyAdmin to export it. I know i can send them an email from: Send Email To Customers but i don't want to do it that way!
Any ideas
Results 1 to 5 of 5
-
17 Apr 2012, 01:16 PM #1
New Zenner
- Join Date
- Apr 2012
- Posts
- 1
- Plugin Contributions
- 0
How can i export dormant customers data (email addresses)
-
17 Apr 2012, 04:36 PM #2
Black Belt
- Join Date
- Jul 2005
- Location
- Upstate NY
- Posts
- 20,966
- Plugin Contributions
- 25
Re: How can i export dormant customers data
Sorry, I'm not enough of an expert in the database to help you. It ought to be possible to write a SQL query to retrieve customer addresses where the last order associated with the customer is "x" date or days ago.
-
17 Apr 2012, 09:35 PM #3
Sensei
- Join Date
- Jan 2004
- Posts
- 58,249
- Blog Entries
- 3
- Plugin Contributions
- 106
Re: How can i export dormant customers data
Um ... what exact data is it which you want to export? And why? What are you planning to do with that data?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
17 Apr 2012, 11:31 PM #4
Black Belt
- Join Date
- Jul 2005
- Location
- Upstate NY
- Posts
- 20,966
- Plugin Contributions
- 25
Re: How can i export dormant customers data
The OP had pm'ed me with a little more detail. He wanted to send these "dormant" customers an e-mail message without spamming all of his current customers.
-
17 Apr 2012, 11:54 PM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 58,249
- Blog Entries
- 3
- Plugin Contributions
- 106
Re: How can i export dormant customers data
1. Write a new, or adapt an existing, query in the query_builder table of the database. Best not to directly edit the existing default entries.
2. Then use the Email Address Exporter addon to pull the email addresses out for use in another system..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Reply With Quote
Similar Threads
-
Export Email addresses and country
By anita in forum All Other Contributions/AddonsReplies: 1Last Post: 29 Nov 2011, 03:47 AM -
Email Address Exporter - How can I export the email addresses of every customer?
By SpencerW in forum All Other Contributions/AddonsReplies: 4Last Post: 14 Oct 2011, 07:35 AM -
Export Email Addresses?
By neparker in forum General QuestionsReplies: 2Last Post: 1 Dec 2009, 09:28 PM -
Export Customer email addresses?
By ktessitore in forum General QuestionsReplies: 2Last Post: 6 May 2009, 01:04 AM -
Can I export my customer email addresses?
By TheHipChic in forum Templates, Stylesheets, Page LayoutReplies: 3Last Post: 17 Jul 2008, 12:41 AM
Bookmarks