Reward Points Module for ZC v13x

https://www.mummysgems.com
there's only 1 product under the special category.
The site have not live yet, so you may do a dummy transaction.

Thanks alot

Reward Points Module - Hide message when 0 points offered

I'm using Rewards Points Module 1.21a - pretty handy - and would like to offer reward points for items in only selected categories.

I understand I can fix the RewardRation to 0 for items that are not rewarded.

How can I hide the rewards points text (on the item listing) when 0 points are available?

Is it possible to set the redeem ratio for specific items or categories?

I'm trying to enable customers to use their points towards charitable contributions - at a much higher redemption rate than if they use them for a discount (we'll subsidize the difference).

Example: If a standard .01 redemption rate gives a $5 discount on $500 in purchases, the same $500 in purchases should make $50 in charitable contributions.

Ideas?

expresso:

Reward Points Module - Hide message when 0 points offered

I'm using Rewards Points Module 1.21a - pretty handy - and would like to offer reward points for items in only selected categories.

I understand I can fix the RewardRation to 0 for items that are not rewarded.

How can I hide the rewards points text (on the item listing) when 0 points are available?

This is done for the next version. Just unzip the attached file to includes/templates/YOUR TEMPLATE FOLDER/templates.

expresso:

Is it possible to set the redeem ratio for specific items or categories?

I'm trying to enable customers to use their points towards charitable contributions - at a much higher redemption rate than if they use them for a discount (we'll subsidize the difference).

Example: If a standard .01 redemption rate gives a $5 discount on $500 in purchases, the same $500 in purchases should make $50 in charitable contributions.

Ideas?

How does the customer currently donate? It would be better to add some code to that mechanism to do the job.

yuki.npwong:

https://www.mummysgems.com
there's only 1 product under the special category.
The site have not live yet, so you may do a dummy transaction.

Thanks alot

I've checked it out and it would appear that you have not set the 'Adjust Reward Points for Sales/Specials' configuration item to '1'.

Brilliant! - this did exactly the trick - I'm looking forward to a complete implementation of this plan!

We'll be using the Reward Points Module to create an incentive for our customers to support some charities we support.

So, on behalf of the beneficiaries of these charities (and myself) -MANY THANKS! Great Work!

hem:

Sorry- it's taking a little longer than I hoped.

Have you had a chance to fix the -1 issue?

Asgoroth:

Have you had a chance to fix the -1 issue?

Yes- I'll put v1.22a up on Monday. In the meantime if you use the file attached in the pervious message you can remove the Reward Points when they are 0 (or less)

hem:

Yes- I'll put v1.22a up on Monday. In the meantime if you use the file attached in the pervious message you can remove the Reward Points when they are 0 (or less)

That is a good start. However, that appears to simply not display if they are not greater then 0. The problem looks to be much deeper, as a purchase made on an item with a negative reward displayed post negative points to the customer.

Hi guys i'm new to this site and have just installed tis module v1.21a - everythings great in admin and the store but the moment you login (cutomer) the screen goes white... i know this happens a lot in php because of '.... but i don't know where to start looking i tried to unintall the MYSQL File but this error came up...

1146 Table 'mysexy_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

hope someone can help... thanks

Asgoroth:

That is a good start. However, that appears to simply not display if they are not greater then 0. The problem looks to be much deeper, as a purchase made on an item with a negative reward displayed post negative points to the customer.

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

hem:

The new version will not return any reward points less than zero. The issue is with rounding down of values that have 0 reward points.

Outstanding. I await the release. Thank you for your efforts.

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
```I tried installing the update.sql and nada, still get the error....any ideas?

Just a not that I have made a temporary workaround by increasing the list limit to 150 to enable me to get to the customer I needed for now LOL

christon26:

Hey Andrew....I just came across a problem because it is the first time I have tried to do this LOL

I am running a contest where each entry is to be awarded some reward points, and when I do a search of the customer (that bit's fine lol) and click the Edit button from the search results I get this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

That's fixed in v1.21a

Oops....guess I should upgrade then eh? :blush: LOL

Ok, upgraded LOL and WOW, love the alphabetical listing options! Thanx for all your hard work on this awesome mod =D

buzzmonkey:

Hi guys i'm new to this site and have just installed tis module v1.21a - everythings great in admin and the store but the moment you login (cutomer) the screen goes white... i know this happens a lot in php because of '.... but i don't know where to start looking i tried to unintall the MYSQL File but this error came up...

1146 Table 'mysexy_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

> 
> hope someone can help... thanks

Did you try the diagnostic? It's here:

[http://www.omnicia.com/rpd.zip](http://www.omnicia.com/rpd.zip)

How do coupons affect reward points?

Coupons don't seem to affect the amount reward points issued. That doesn't seem right. For example, a customer just bought $5 of products, used a $5 coupon to reduce the cost to zero. That customer still earned reward points for the free products.

I want reward points reduced by the coupon amount. Can that be done?

Thanks,
David Bal
www.DJMagicCards.com