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?

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?

nfallat:

---

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

nfallat:

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.