Reward Points Module for ZC v13x

Thank you. I am sorry I changed where it was calculating by subtotal but missed the part where it calculated individually or by order total/subtotal.

Error on the Customer Reward Points Admin page:

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 'REWARD_POINTS_CUSTOMER_LIMIT' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from zen_customers as c LEFT JOIN (zen_reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(zen_reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) ORDER BY c.customers_id, c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_LIMIT;]
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 have reward_point_full_suite_1-26a

I want to uninstall the entire thing and reinstall. Will that fix my problem? When I uninstall it doesn't get rid of everything on my db.

Hello,

I am using the most current version of this module and the most current version of Zen Cart.

I need to put the reward points earned, reward points pending, and current order reward points on a section in my header.

I am new to php, can someone help me find the exact pieces of code I would have to isolate in order to achieve this?

Thanks,

Jordin

Jordin:

Hello,

I am using the most current version of this module and the most current version of Zen Cart.

I need to put the reward points earned, reward points pending, and current order reward points on a section in my header.

I am new to php, can someone help me find the exact pieces of code I would have to isolate in order to achieve this?

Thanks,

Jordin

Whereabouts in your header- In the top "banner" of your page or one of the bars beneath it?

The install of this mod on 1.3.8a is easy to follow. When I do the sql patch thru the admin section - I get a sql error and no admin. I have installed many mods without problems. The error seems to indicate there is an error in the sql patch. I have redone several times - same error. I have a zen_ prefix in my database - don' know why I did that ages ago. Anyway, help please. Thanks

2004g35:

The install of this mod on 1.3.8a is easy to follow. When I do the sql patch thru the admin section - I get a sql error and no admin. I have installed many mods without problems. The error seems to indicate there is an error in the sql patch. I have redone several times - same error. I have a zen_ prefix in my database - don' know why I did that ages ago. Anyway, help please. Thanks

You need to extract the sqlpatch.zip file that comes with the mod. The sqlpatch.zip fixes a bug in the sqlpatch.php file. It is added as a zip because I don't like overwriting core files and the bug is minimal. The bug is reported here: http://www.zen-cart.com/forum/showthread.php?t=123631

I'm interested in offering reward points and would like to offer the customer more points (say 2p in the pound rather than 1p in the pound) when the sub-total is over a certain amount (say £25.00).

Is this possible/or advisable? Has anyone tried this? :unsure:

If so, could anyone point me in the right direction for the relevant sub-total functions that would need an amend.

Any help appreciated, and thanks in advance. :hug:

tvsupport:

I'm interested in offering reward points and would like to offer the customer more points (say 2p in the pound rather than 1p in the pound) when the sub-total is over a certain amount (say £25.00).

Is this possible/or advisable? Has anyone tried this? :unsure:

If so, could anyone point me in the right direction for the relevant sub-total functions that would need an amend.

Any help appreciated, and thanks in advance. :hug:

Under Config->Reward Points set "Set Minimum Order Value to Redeem Points Against" to 25. Then under Customers->Group Rewards Redeem set "global points ratio" to 0.02

hem:

Under Config->Reward Points set "Set Minimum Order Value to Redeem Points Against" to 25. Then under Customers->Group Rewards Redeem set "global points ratio" to 0.02
Thanks for the quick reply. I would still like to reward points under 25 pounds but less points eg 1 point per pound up to 25 pounds and 2 points thereafter. Sorry for any confusion.
Posted via Mobile Device

Just in case I caused confusion, ideally I would like to credit:

10 points for every pound if sub-total less than £25
20 points for every pound if sub-total is £25 or more

All points redeemed worth 0.01 pound.

(Idea being customers enticed to spend above £25 to gain double points per pound.)

:lookaroun

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 'SELECT orders_id FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.orders_id NOT IN (SELECT orders_id FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

tvsupport:

Just in case I caused confusion, ideally I would like to credit:

10 points for every pound if sub-total less than £25
20 points for every pound if sub-total is £25 or more

All points redeemed worth 0.01 pound.

(Idea being customers enticed to spend above £25 to gain double points per pound.)

:lookaroun

You would need to change the process function in includes/modules/order_total/ot_reward_points.php

2004g35:

I did as you instructed - replaced the sqlpatch.php and re-loaded all again. Still getting an error and then can not get back into my admin section - the store still works though.
This is the error that I am getting --

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 'SELECT orders_id FROM zen_orders) LIMIT 1' at line 1
in:
[SELECT * FROM zen_reward_status_track rs WHERE rs.orders_id NOT IN (SELECT orders_id FROM zen_orders) LIMIT 1;]
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

Thanks in advance for your help

What version of MySQL are you running?

weber:

i have the module installed but...

where is the rewards point order total which i can set each point = 1 cent ?

i have 3 module in order total, but non of them has this setting.

Under Customer->Group Reward Points. Just enter 0.03 for the Global Redeem.

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

Hi everyone,

I was wondering if it was possible to make a purchase with Reward Points only and not by credit card/paypal?

I have installed ZC v1.3.8 and the Rewards Points FS v1.2.6
and everything seems fine so far in terms of configruation.

Im testing at the moment and I made the reward points worth one dollar and gave 200 points to one of the test users to purchase an item worth 70 points.

I have input !00% as the maximum points allowed to redeem, too.

On checkout it asked me for credit card details to proceed, is there something I have missed?

Cheers
Adam

2004g35:

my php is version 5.2.11 and mysql is ver 4.0.27
Thanks for looking at this for me

Your problem is that this mod requires v4.2 of MySQL minimum. You will need to get your host to upgrade it.

kellan4459:

I have upgraded to version 1.26 but when I install and try to modify the Discount Table I can't add or delete the entries. I am searching the thread and I don't see anything on this yet so again I apologize if this has been discussed before.

I'm also having this issue where I can't delete/add the various percentages in the Discount Table.

Any assistance appreciated.

I'm running Zen Cart 1.3.8a.

Mick

Hi I installed this but when i went to Admin->Tools->Layout Box Controller nothing shows up for it any help would be awesome
Thanks