Forums / Strategies for Advertising my Online Store / eMail Marketing Custmoer List with Product Purchased

eMail Marketing Custmoer List with Product Purchased

Views: 249

Results 1 to 7 of 7
2 Oct 2018, 3:40 PM
#1
hdwrkgr avatar

hdwrkgr

New Zenner

Join Date:
Nov 2010
Posts:
25
Plugin Contributions:
0

eMail Marketing Custmoer List with Product Purchased

Harvesting data for target marketing effort hits dead-end; many attempt have been made to capture customer data to include email addresses and product(s) purchased. This information would allow me to sort for specific product type. . .say "women's work boots" and to upload my list, I am currently using MailChimp for my marketing campaigns. This would be a powerful target marketing tool; has anyone found the way and means ito accomplishing this?

Happy to be here!
Thomas
https://www.hdworkgear.com

4 Oct 2018, 12:05 AM
#2
hdwrkgr avatar

hdwrkgr

New Zenner

Join Date:
Nov 2010
Posts:
25
Plugin Contributions:
0

Re: eMail Marketing Custmoer List with Product Purchased

Correction "Not Products Purchased"

The objective would be to download "Customer Email" addresses and the "Vendor Name" this would allow for a more focused marketing approach . . . not just womens boot, but the vendor specific. The marketing campaign would be to those customers who bought, say, "John Deere" boots.

5 Oct 2018, 3:18 PM
#4
hdwrkgr avatar

hdwrkgr

New Zenner

Join Date:
Nov 2010
Posts:
25
Plugin Contributions:
0

Re: eMail Marketing Custmoer List with Product Purchased

Yes, to avoid causing any spam emails results greater than 1% or suffer the negative impact on all future email marketing campaigns where all such marketing is automatically labeled spam.

Question to the Journeymen: is it possible to download a customer list that includes manufacturer, whereupon one can clean said list for only those who "explicitly agreed to receive marketing mails."

26 Nov 2020, 5:46 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: eMail Marketing Custmoer List with Product Purchased

Yes it's possible. The data you seek is contained in various database tables, so you'd need to write your own custom database query to retrieve it.

orders table contains customer email
orders_products table contains what products were purchased, links to product id
products table contains the manufacturer id
manufacturers table contains manufacturer name

.
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.

26 Nov 2020, 6:11 PM
#6
stevemusica avatar

stevemusica

New Zenner

Join Date:
Oct 2020
Location:
Barcelona
Posts:
4
Plugin Contributions:
0

Re: eMail Marketing Custmoer List with Product Purchased

Thank you, DrByte )
I always thought that the best way to get an answer is to say something stupid with complete confidence. And then you will definitely get help.)
Today I will try to implement your advice on the client site, it sounds not difficult

26 Nov 2020, 6:36 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: eMail Marketing Custmoer List with Product Purchased

You could use the Email Address Exporter plugin as a base for providing a custom exporter that can be run from the Admin to grab a CSV of the output.

.
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.