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.

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.

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.

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.

hem:

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 ?

Mike_Dean:

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%20Reward%20Points%20Module.zip

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.

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.

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.

hem:

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%20Reward%20Points%20Module.zip

Hi.

Apparently that link doesn't seem to work.

Would you be able to repost it again.

thank you,
Dat

datvtran:

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%20Reward%20Points%20Module.zip

hem:

Try this:

http://www.omnicia.com/Zencart%20Reward%20Points%20Module.zip

Hi hem ,

Thank you,
Dat

Hi Hem,

where would I place the rpd.php and rpd.xml to?

Thank you,
Dat

datvtran:

Hi Hem,

where would I place the rpd.php and rpd.xml to?

Thank you,
Dat

Copy it to the root folder of your store and then run it by entering "www.yourstore.com/rpd.php" into your browser.

Hi Hem,

Thanks for the quick reply, I wasn't to sure to place it in the admin or the include folder.

Thank you,
Dat

Hi,

Also I was wondering what does the rpd.php do?

Thank you,
Dat

datvtran:

Hi,

Also I was wondering what does the rpd.php do?

Thank you,
Dat

It's a diagnostic program which tells you if you've copied over all the files correctly (and installed the MySQL patch)

Hello, looking forward to get this one working :)
Have installed but have a few issues I'm unsure off can anyone advise if this is how it should be or shed any incite on whats wrong if not?

Reward points is showing 3 times under configaration in admin. Only the third one has a list of settings the first two are entitled reward point when you click on them but the page its showing is empty.

Reward Points" sidebox which displays points in cart and points earned is showing fine but
Shopping Cart with Rewards' sidebox is not showing on site even though I have switched it on in Admin->Tools->Layout Box Controller, shouldnt I be seeing something here? When I check back in admin it is switched back to off sometimes also. Can anyone shed any light on whats wrong here please?

Can nayone show me a sample site with this working on please?

Thanks

Hem,
Thanks for a great Mod, this is one of the features we were looking forward to add to our store. I do have a question. Is there a possibility of creating an incremental point system. For example if a person has:

200 points = $5 off (2.5% off)
500 = $20 (4% off)
1000 = $50 (5% off)
2000 = $125 (best deal at 7.5% off)

This would be a great feature, if it's not already available. If it is, can you help me to set it up.

Hi Hem,

Nice! Works great as is! But similar to babyface, I have a couple of questions.

1. Is is possible to have the reward points = %off rather than $off?

2. If so, is it possible to set limits:
   1000 points = 5% off
   2500 points = 10% off
   5000 points = 15% off (max limit)

Thanks!

tiaz:

Hello, looking forward to get this one working :)
Have installed but have a few issues I'm unsure off can anyone advise if this is how it should be or shed any incite on whats wrong if not?

Reward points is showing 3 times under configaration in admin. Only the third one has a list of settings the first two are entitled reward point when you click on them but the page its showing is empty.

Reward Points" sidebox which displays points in cart and points earned is showing fine but
Shopping Cart with Rewards' sidebox is not showing on site even though I have switched it on in Admin->Tools->Layout Box Controller, shouldnt I be seeing something here? When I check back in admin it is switched back to off sometimes also. Can anyone shed any light on whats wrong here please?

Can nayone show me a sample site with this working on please?

Thanks

Can anyone advise on this please?
Thanks

tiaz:

Can anyone advise on this please?
Thanks

See http://www.zen-cart.com/forum/showpost.php?p=706671&postcount=840 and further posts.