Zen Cart Logo
Forums / General Questions / Newsletters for VIPS

Newsletters for VIPS

Locked

Views: 1,549

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
30 Nov 2006, 6:30 PM
#1
ace_of_dubs avatar

ace_of_dubs

New Zenner

Join Date:
Nov 2006
Posts:
3
Plugin Contributions:
0

Newsletters for VIPS

Howdy yall,

I am putting together my first zencart site and my client has requested an advanced feature that I am not sure is possible.

Basically they are a record label and for the majority of mailing promos, zen-cart works great out the box. Here's the rub though. They want an exclusive "VIP" mailing list to send promo items to DJs and other record companies.

Folks on the VIP list will get an email containing download links to the latest MP3s or other free downloads that regular users are charged for... this link should be set to expire at a designated time to avoid any abuse...

Is this something that is possible with zencart (without having to rip up its intestines and get my fingers all dirty) ?

:)

3 Dec 2006, 11:05 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Newsletters for VIPS

You would need to do several things:

  1. use an external method to create your special "link" that "expires". You could use an extenal hosted service to do this, or perhaps write a .htaccess rule that you could go and change later. This provides limited or no security to prevent recipients from forwarding the newsletter to others who could download similarly. But that may not be a concern in this case. An externally-hosted link service could limit clicks to one per unique ID.
    Regardless, you'll need to know this "link" in order to paste it into your newsletter.

  2. Create a VIP Customers Group in Zen Cart and manually match each VIP customer to that group.

  3. Manually hack up a new SQL query for the "query_builder" table in phpMyAdmin to pull recipients who match your VIP group.

Then create your newsletter in Zen Cart as you normally would, but when you go to "send" the newsletter, choose the VIP group from the audiences list (which will appear after doing step #3 above). Of course, be sure to include your special VIP download link somewhere in the newsletter before sending it.

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

3 Dec 2006, 3:46 PM
#3
ace_of_dubs avatar

ace_of_dubs

New Zenner

Join Date:
Nov 2006
Posts:
3
Plugin Contributions:
0

Re: Newsletters for VIPS

Wow..I had given up hope on this thread, thanks for answering!

There are a few things I dont understand though..

DrByte:

You would need to do several things:

  1. use an external method to create your special "link" that "expires". You could use an extenal hosted service to do this,
    I dont know of any services that do this, any pointers would be appreciated. I am a little surprised Zen Cart doesnt have an expire link feature. I tested out SquirrelCart the other day and while they are a little skint on features compared to ZC, they do have this one.. should I post a request for this feature?

DrByte:

Manually hack up a new SQL query for the "query_builder" table in phpMyAdmin to pull recipients who match your VIP group.

I love how easy you make that sound! Wish I had the skills to pull it off but am just starting to get my head around server-side programming.