Reward Points Module for ZC v13x

[snowy2007]

Is there any way, on the product info page, to make the number of reward points (ratio is set to 1 point per £1) to be equal to the product price INCLUDING tax rather than excluding?

For example :

I have a product priced at £39.99 INCLUDING Uk tax (vat) at 15% - It is showing as carrying 33 Reward Points.

EDIT: I know I can set the ratio to 1.15 but it doesn't seem like the ideal way of doing it as the calculation is then incorrect if I set the module to calculate final points via subtotal rather than via per product values.

[hem]

Is there any way, on the product info page, to make the number of reward points (ratio is set to 1 point per £1) to be equal to the product price INCLUDING tax rather than excluding?

For example :

I have a product priced at £39.99 INCLUDING Uk tax (vat) at 15% - It is showing as carrying 33 Reward Points.

Just set your ratio to 1.15.

[snowy2007]

Cheers Andrew - I have another problem if anyone can shed any light :

In the Admin/Customers/Reward Points screen I have the following two problems :

1. When I click on a letter (sorted by Last Name) it shows me 1 screen full of names but not all the names IE: If I select the letter P then the last name on the list is "Penfold" but I have lots more customers whose last name starts with P such as Pickton etc... They are not on there. SCRAP THIS ONE - I have just realised I can change the number displayed in Admin from the default of 50

2. I have set up a test customer and earned some points. When I try to click on the edit function for that customer whose surname is "Phenton" (to manually add points etc...) and I find them by entering "Phenton" in the search box I get the following 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 '%phenton%' OR c.customers_firstname LIKE '%phenton%' OR c.customers_id LIKE '%' at line 1

[hem]

Cheers Andrew - I have another problem if anyone can shed any light :

In the Admin/Customers/Reward Points screen I have the following two problems :

1. When I click on a letter (sorted by Last Name) it shows me 1 screen full of names but not all the names IE: If I select the letter P then the last name on the list is "Penfold" but I have lots more customers whose last name starts with P such as Pickton etc... They are not on there. SCRAP THIS ONE - I have just realised I can change the number displayed in Admin from the default of 50

2. I have set up a test customer and earned some points. When I try to click on the edit function for that customer whose surname is "Phenton" (to manually add points etc...) and I find them by entering "Phenton" in the search box I get the following 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 '%phenton%' OR c.customers_firstname LIKE '%phenton%' OR c.customers_id LIKE '%' at line 1

You got the first one The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.

[snowy2007]

You got the first one The second one was sorted in v1.25- so if you have v1.26 (the alpha release) this is covered.

Hi Andrew - I have V1.23a - where can I get V1.26 from and is it an easy upgrade?

[hem]

Hi Andrew - I have V1.23a - where can I get V1.26 from and is it an easy upgrade?

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

There shouldn't be any show-stoppers. The only (alpha) changes in this release is a new Reward Point Discount add-on which is not installed by default.

[Eris]

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.

[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

[hem]

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?

[snowy2007]

RE my previous post : If I select the "Phenton" customer from the list generated by clicking "P" at the top then the error doesn't occur - only when I have searched for the customer.

Another one :) When a product is priced at £1 it carries one point - Is there any way for the module to display this as 1 reward point rather than 1 reward points (IE: Plural)