Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    84
    Plugin Contributions
    0

    Default Download Customer Email with Date Account Created

    Wondering if anyone knows best way to do this.

    Due to ICAN requirements on mass emails, I need to be able to identify date account created for each customer so we are not sending mass emails to customers no longer interested. We market to teenagers so after about 4 years they are no longer interested and we get spam reports.

    In the Customer record in ZenCart Admin it includes the email address and date account created.

    But how do I download this information from the database into an excel file?

    I see in the database "zen_customers" which includes the email address but not the date account created.

    And in "zen_customers_info it has Customer ID (but not the email address) but includes date account created.

    Is there a way to download the the email address and date account created together, making sure the date is matching up with the correct email address?

  2. #2
    Join Date
    Jan 2009
    Posts
    84
    Plugin Contributions
    0

    Default Download Email Address and Date Account Created

    --------------------------------------------------------------------------------
    I posted this in another section last week but didn't get a response so hoping someone will see it here.


    Wondering if anyone knows best way to do this.

    Due to ICAN requirements on mass emails, I need to be able to identify date account created for each customer so we are not sending mass emails to customers no longer interested. We market to teenagers so after about 4 years they are no longer interested and we get spam reports.

    In the Customer record in ZenCart Admin it includes the email address and date account created.

    But how do I download this information from the database into an excel file?

    I see in the database "zen_customers" which includes the email address but not the date account created.

    And in "zen_customers_info it has Customer ID (but not the email address) but includes date account created.

    Is there a way to download the the email address and date account created together, making sure the date is matching up with the correct email address?

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Download Email Address and Date Account Created

    Quote Originally Posted by nfallat View Post
    --------------------------------------------------------------------------------
    I posted this in another section last week but didn't get a response so hoping someone will see it here.
    Rather than repeating the same post AGAIN, and cluttering the forum with duplicates, it is much more appropriate to reply to your original post with additional details, as explained in the Forum Rules: http://www.zen-cart.com/forum/faq.php
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    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.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Download Customer Email with Date Account Created

    Quote Originally Posted by nfallat View Post
    But how do I download this information from the database into an excel file?

    I see in the database "zen_customers" which includes the email address but not the date account created.

    And in "zen_customers_info it has Customer ID (but not the email address) but includes date account created.

    Is there a way to download the the email address and date account created together, making sure the date is matching up with the correct email address?
    Sure. Use the Email Address Exporter addon, and customize it to include the extra data you require.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    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.

 

 

Similar Threads

  1. v151 Customer Account Created Date Rolling Forward
    By WWWD in forum General Questions
    Replies: 6
    Last Post: 28 Feb 2013, 03:00 AM
  2. Change date of orders and customer account created in admin
    By barendfaber in forum General Questions
    Replies: 2
    Last Post: 10 Nov 2011, 11:38 AM
  3. New Customer account Showed up- says created 2 months ago??
    By whatisthat456 in forum Managing Customers and Orders
    Replies: 0
    Last Post: 15 Mar 2010, 04:36 AM
  4. Account Created date showing as todays date
    By PatF in forum Managing Customers and Orders
    Replies: 10
    Last Post: 20 Nov 2008, 03:04 PM
  5. I want Date of Birth infor for customers created with PEC
    By shocker in forum PayPal Express Checkout support
    Replies: 1
    Last Post: 17 Aug 2008, 01:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR