Reward Points Module for ZC v13x

@Curlydan - I found some files in the 'upgrade' section that didn't seem to be in the full installation section, try uploading the upgrade as well as making sure you have uploaded all the folders in 'full installation', including 'includes'. The bit you're asking about refers to the database you use. If you have specified during the creation of your zen cart shop that your database has prefixes for the tables eg 'curlydan' so that instead of 'customer_addresses" your DB has the table 'curlydan_customer_addresses', then you have to deal with that. Sounds like you didn't use prefixes, so it won't be that. Try uploading everything like I did, making sure you have changed the names of the 'custom' folders to the name for your template. It will all magically appear. Did for me, anyway.

Suggestion - it would be brilliant if someone could think of a way to make it so that there was a product or two on the site that you could only buy using Reward Points instead of cash. Really give people a thing to build towards other than the slightly impersonal-feeling discounts etc. No idea how that would be done but it would be great if someone knew. :cool:

I haven't used this mod in a long time, so correct me if I am wrong, but wasn't there already a section where you could specify what products / categories to include / exclude?

Heresy Miniatures:

Suggestion - it would be brilliant if someone could think of a way to make it so that there was a product or two on the site that you could only buy using Reward Points instead of cash. Really give people a thing to build towards other than the slightly impersonal-feeling discounts etc. No idea how that would be done but it would be great if someone knew. :cool:

Design75 is right you can limit to what categories or products you want to use Reward Points on, but you can not use just Reward Points to checkout.

If you just want a Reward Point shopping cart you will need custom coding.

To do this You will need to consider investing in custom coding to get the desired functionality. This is totally doable, but it is not a small piece of work BTW..

Hi CountryCharm,

I'm using your module, but there is one thing I want to check.
I want to build a point system where every $10 they spend gives them 1 point which equates to $1. They can use there points at anytime.

So I don't see in the admin has option to set $10 for 1 point.
Can you clarify ? many thanks.

Regards.

skywalker826:

Hi CountryCharm,

I'm using your module, but there is one thing I want to check.
I want to build a point system where every $10 they spend gives them 1 point which equates to $1. They can use there points at anytime.

So I don't see in the admin has option to set $10 for 1 point.
Can you clarify ? many thanks.

Regards.
I just replied to your PM on how to do this.

By the way it's not my module I just updated it to work with the latest Zen Cart.

I guess I should share this this just in case anyone else has the same question.

This is how you would set it up.

Under admin/configuration/Reward Points Configuration set the Reward Point Rounding to 0.5

Under admin/catalog/Reward Points Set Global Reward Point ratio to: 0.1000

Under admin/catalog/Group Reward Redeem Enter global points ratio to: 1.0000

Now for every $10.00 a customer spends he/she will receive a point worth $1.00

countrycharm:

I just replied to your PM on how to do this.

By the way it's not my module I just updated it to work with the latest Zen Cart.

I guess I should share this this just in case anyone else has the same question.

This is how you would set it up.

Under admin/configuration/Reward Points Configuration set the Reward Point Rounding to 0.5

Under admin/catalog/Reward Points Set Global Reward Point ratio to: 0.1000

Under admin/catalog/Group Reward Redeem Enter global points ratio to: 1.0000

Now for every $10.00 a customer spends he/she will receive a point worth $1.00

Hi,

The global points ratio must set to 0.1, not 1, otherwise, I will get 10 point for $10
Secondly, after set:

Under admin/configuration/Reward Points Configuration set the Reward Point Rounding to 0.5

Under admin/catalog/Reward Points Set Global Reward Point ratio to: 0.1000

Under admin/customer/Group Reward Redeem Enter global points ratio to: 0.1000

I get 1 point for $10, but the admin/customer/Reward Points:
I see:

Reward Points Earned: 1
Value of Earned: $0.10

The "Value of Earned" is not right. It should be $1.00, not $0.10. May I know which setting affect the value of earned ?

Thanks.

skywalker826:

Hi,

The global points ratio must set to 0.1, not 1, otherwise, I will get 10 point for $10
Secondly, after set:

Under admin/configuration/Reward Points Configuration set the Reward Point Rounding to 0.5

Under admin/catalog/Reward Points Set Global Reward Point ratio to: 0.1000

Under admin/customer/Group Reward Redeem Enter global points ratio to: 0.1000

I get 1 point for $10, but the admin/customer/Reward Points:
I see:

Reward Points Earned: 1
Value of Earned: $0.10

The "Value of Earned" is not right. It should be $1.00, not $0.10. May I know which setting affect the value of earned ?

Thanks.

If you set the Reward Points up like I mention, you will get the results I stated.

When I go to admin/customer/Reward Points: I get what you see in the picture down below.

I'm not sure what you did to get a "Value of Earned"
Reward Points Earned: 1
Value of Earned: $0.10

Go back and check the setting to make sure they are set up right.
The setting I have is for every $10.00 a customer spends they receive 1 Reward Point worth $1.00

Hi CountryCharm,

I'm using zencart 1.3.8a.

When you mentioned:
Under admin/catalog/Group Reward Redeem Enter global points ratio to: 1.0000

is it under:
Under admin/customer/Group Reward Redeem
or admin/catalog/Group Reward Redeem

because I only see Group Reward Redeem under admin/customer/, not admin/catalog

Thanks.

Regards,
Sky

skywalker826:

Hi CountryCharm,

I'm using zencart 1.3.8a.

When you mentioned:
Under admin/catalog/Group Reward Redeem Enter global points ratio to: 1.0000

is it under:
Under admin/customer/Group Reward Redeem
or admin/catalog/Group Reward Redeem

because I only see Group Reward Redeem under admin/customer/, not admin/catalog

Thanks.

Regards,
Sky

You are correct. Sorry about that Sky.... :)

It should have been admin/customers/Group Reward Redeem Enter global points ratio to: 1.0000

This is how you would set it up.

Under admin/configuration/Reward Points Configuration set the Reward Point Rounding to 0.5

Under admin/catalog/Reward Points Set Global Reward Point ratio to: 0.1000

Under admin/customers/Group Reward Redeem Enter global points ratio to: 1.0000

Now for every $10.00 a customer spends he/she will receive 1 point worth $1.00 each.

skywalker826:

Hi CountryCharm,

I'm using zencart 1.3.8a.

When you mentioned:
Under admin/catalog/Group Reward Redeem Enter global points ratio to: 1.0000

is it under:
Under admin/customer/Group Reward Redeem
or admin/catalog/Group Reward Redeem

because I only see Group Reward Redeem under admin/customer/, not admin/catalog

Thanks.

Regards,
Sky

Another thing I would do is upgrade your Zen Cart version 1.3.8a. to the current version of Zen Cart 1.5.1. You are running and out dated version with all kinds of Security vulnerabilities. I can not emphasize enough about the Security vulnerabilities people have by running Zen Cart v1.3.8a.

countrycharm:

Another thing I would do is upgrade your Zen Cart version 1.3.8a. to the current version of Zen Cart 1.5.1. You are running and out dated version with all kinds of Security vulnerabilities. I can not emphasize enough about the Security vulnerabilities people have by running Zen Cart v1.3.8a.

Hi Countrycharm,

thanks for reply.
I created many screenshots of my current settings. Please take a look, and see if there is anything wrong with configuration,especially in admin/configuration/reward point.
Please download the pdf from here .

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

Appreciate your kind advise. Many thanks.

Regards,
Sky

skywalker826:

Hi Countrycharm,

thanks for reply.
I created many screenshots of my current settings. Please take a look, and see if there is anything wrong with configuration,especially in admin/configuration/reward point.
Please download the pdf from here .

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

Appreciate your kind advise. Many thanks.

Regards,
Sky

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities. This will be my last response because this module has been upgraded to work on zen cart version 1.3.9h and 1.5.1. It is not supported or advise to be use on outdated version of zen carts. I hope you understand.

Try setting your admin/configurations/Reward Points like so.
The admin/customers/Group Reward Redeem has to be set to 1.0000 not 0.1000

countrycharm:

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities. This will be my last response because this module has been upgraded to work on zen cart version 1.3.9h and 1.5.1. It is not supported or advise to be use on outdated version of zen carts. I hope you understand.

Try setting your admin/configurations/Reward Points like so.
The admin/customers/Group Reward Redeem has to be set to 1.0000 not 0.1000

Thanks so much. This fixes the issue with admin/customers/Group Reward Redeem set to 1.0000

skywalker826:

I cannot upgrade the zencart version, as I'm just responsible to install this mod for my client. He has many customizations done on this zencart version, so upgrading will be big exercise to perform

countrycharm:

Hi Sky,
I'm not trying to be mean about anything and please don't take it the wrong way.
You need to tell your client that he is putting all his customers and there information at risk using a out dated and unsupported Zen Cart version 1.3.8a with known Security vulnerabilities.

I agree with CountryCharm.. and at the risk of also sounding harsh, your client's "many customizations" is NOT a good reason to NOT upgrade his store from a version with KNOWN vulnerabilities and code that will STOP working should his webhost upgrade to PHP 5.3.x. You should AT LEAST inform him of this issue. If you cannot do the upgrade, then he should be aware of the issue so that he give some thought to seeking a resource who can.

Now before you think we're being overly hysterical about this let me give you insight into one of the many possible vulnerabilities with the 1.3.8 codebase. One which affected two client's of mine who decided to WAIT to upgrade versus upgrading when I informed them of the risks of continuing on with 1.3.8. There is a hack in which the store's PayPal settings can be HIJACKED allowing the hacker to modify the PayPal payment module to direct funds from your client's sales into the hacker's PayPal account.. On the surface this particular hack gives no appearance that anything is wrong.. Sales will continue unil your client see sales in their store and no corresponding PayPal payment.. It could take days before they notice this.. and here's the kicker.. Your client will have NO RECOURSE with PayPal to get the funds returned to them.. They then will have the unenviable task of either honoring the sales and taking a loss or telling their clients that their store was hacked and to inform the clients that they have to fight with PayPal to get their money back (which of course will RUIN their reputation)..

Now in the case of my two clients, they were BOTH lucky.. One luckily caught the hack as soon as the PayPal change was made BEFORE any sales were processed. The other didn't catch it until three sales had gone through. She decided to eat the loss and fulfill the orders.. She worked with PayPals fraud unit, but has no prayer of ever seeing her money returned.

The moral of the story: Do your due diligence, and inform your client of the vulnerable state their store is in.. If they want to then risk not upgrading to avoid paying for an upgrade, then that is on them. If the issue is that you feel that the upgrade task may be over your head, then that is a different matter altogether, and one that that you need to be honest with your client about so they can make proper decisions for their business..

Hi,

I'm using Zen Cart 1.5.1. My Reward Points system seems to work OK so thank you to an author of this great free module.
I was checking my logs directory and came across this error:

[11-Jan-2013 15:02:40 Europe/London] PHP Fatal error: 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 '463''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.produ' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
FROM reward_master prp, products p, products_to_categories p2c
WHERE p.products_id='463''
AND p2c.products_id='463''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
OR (prp.scope='0'))
ORDER BY prp.scope DESC LIMIT 1; in /home/beautyst/public_html/includes/classes/db/mysql/query_factory.php on line 120

Can anyone point in the right direction. I'm not sure where to start:no:

Kind Regards
Damian K.

damiankrzyz:

Hi,

I'm using Zen Cart 1.5.1. My Reward Points system seems to work OK so thank you to an author of this great free module.
I was checking my logs directory and came across this error:

Can anyone point in the right direction. I'm not sure where to start:no:

Kind Regards
Damian K.

I can see son double quotes here

WHERE p.products_id='463''
				AND p2c.products_id='463''

I don't think that is right

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total module

hope someone can help me :)

juneloweelyn:

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total module

hope someone can help me :)

You have to go to admin/configurations/Reward Points and set up all setting to your liking.

juneloweelyn:

i just installed but i couldnt find how to edit the redeem ratio.

I only see this in my order total module

hope someone can help me :)

countrycharm:

You have to go to admin/configurations/Reward Points and set up all setting to your liking.
Which is explained in the readme file for this module..