Reward Points Module for ZC v13x

[hem]

This script will delete all empty multiples on the config menu just copy and paste it to SQL patch. However if you use a table prefix you will need to set `configuration_group_id` to `YOUR_PREFIX_configuration_group_id`

#NEXT_X_ROWS_AS_ONE_COMMAND:2
DELETE FROM `configuration_group` WHERE NOT IN (
SELECT `configuration_group_id` FROM `configuration` WHERE 1); 

Apropos to this, I've submitted a bug report regarding this (http://www.zen-cart.com/forum/showthread.php?t=123631). If you copy the attached file to admin/ then this script will run fine.

[batterygenie]

First of all, Andrew, I want to thank you for one great mod...this is exactly what we were looking for. I think we are going to keep this as it exists for now, but I've been reading posts about people submitting wishlists for future updates and I'd like to throw a few of my own on the pile.

1) The ability to add points globally to all existing customers or to a group of customers...though for now I can do this through MySQL.

2) A Next button in the Customer Admin section or a way to advance easily to the next group of customers...for now I've set my default to 400 so I can see them all in a specific letter.

3) A way to send customers a promotional email with a code that would allow them to add or double points in their account by signing in. Also, it would be nice to have the reward points listed in the email that goes out to customers when they make a purchase.

4) A way to attach points for creating a new account, maybe in lieu of the point above.

5) How to track customers that have redeemed points...other than going in through the SQL and pulling that...not so important though...probably can create my own report for that but I'm just so lazy.

I know you've got a lot on your plate already, but I figure if you don't ask, there's nothing gained.

Again, just want you to know your hard work is certainly appreciated by many.

[hem]

First of all, Andrew, I want to thank you for one great mod...this is exactly what we were looking for. I think we are going to keep this as it exists for now, but I've been reading posts about people submitting wishlists for future updates and I'd like to throw a few of my own on the pile.

1) The ability to add points globally to all existing customers or to a group of customers...though for now I can do this through MySQL.

2) A Next button in the Customer Admin section or a way to advance easily to the next group of customers...for now I've set my default to 400 so I can see them all in a specific letter.

3) A way to send customers a promotional email with a code that would allow them to add or double points in their account by signing in. Also, it would be nice to have the reward points listed in the email that goes out to customers when they make a purchase.

4) A way to attach points for creating a new account, maybe in lieu of the point above.

5) How to track customers that have redeemed points...other than going in through the SQL and pulling that...not so important though...probably can create my own report for that but I'm just so lazy.

I know you've got a lot on your plate already, but I figure if you don't ask, there's nothing gained.

Again, just want you to know your hard work is certainly appreciated by many.

Thanks for the support.

1. This would be easy to add and I could just use the existing Customers RP panel.

2. I'm trying to come up with a decent way to navigate through large number of customers- The 'Prev/Next' and 'Goto Page ?' never really appealed to me because it doesn't allow me to go directly to the page I want. What I'm aiming for is after you select the first letter, you get given options to refine further- I.e if you click on 'A' you are then presented with buttons labelled 'Aa-Af', 'Ag-Am','An-As', 'At-Az'. This would be a lot easier with AJAX.

3. Emails is on my list of things to look at.

4. New Account Reward Points was added in version 1.22.

5. There was an idea to add a Reward Points History but it got scrapped because it could potentially be quite a large table for very little gain. I'll look into SQL extracts of the Order table though.

Thanks again for your support. It's good to get the feedback.

[Mike_Dean]

Thanks for the support.


4. New Account Reward Points was added in version 1.22.


Thanks again for your support. It's good to get the feedback.

I can only see V1.21a in the downloads section. Is this the 1.22 that you refer to ?

[hem]

I can only see V1.21a in the downloads section. Is this the 1.22 that you refer to ?

I've uploaded v1.23 to the contributions but it takes a little while to list them. However you can always get the latest version from: http://www.omnicia.com/www/Zencart%2...s%20Module.zip

[batterygenie]

Thanks for the update, Andrew...if there's any way we can help grease the wheels of progress please let us know...we'd be happy to support you and help you pay a few bills maybe.

[hem]

Thanks for the update, Andrew...if there's any way we can help grease the wheels of progress please let us know...we'd be happy to support you and help you pay a few bills maybe.

Thanks for the offer- the wheels don't need greasing just yet- but that may change- we have an emergency budget under way right now here in Ireland.

[datvtran]

I've uploaded v1.23 to the contributions but it takes a little while to list them. However you can always get the latest version from: http://www.omnicia.com/www/Zencart%2...s%20Module.zip

Hi.

Apparently that link doesn't seem to work.

Would you be able to repost it again.

thank you,
Dat

[hem]

Hi.

Apparently that link doesn't seem to work.

Would you be able to repost it again.

thank you,
Dat

Try this:

http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

[datvtran]

Try this:

http://www.omnicia.com/Zencart%20Rew...s%20Module.zip

Hi hem ,

Thank you,
Dat