Reward Points Module for ZC v13x

Kezza:

forgot to say it passes the price less 2x the reward points onto paypal but does not affect in house payments.

Kezza

hem:

Thanks for the feedback, I am looking into this now.

hem:

Okay, I have located the problem. I'm now working on removing it.

can you please tell me what the problem was, so i can make the changes in my cart.
Thanks

Kezza

Kezza:

can you please tell me what the problem was, so i can make the changes in my cart.
Thanks

Kezza

The rp->process() was being called twice. Once as normal and secondly as part of rp->collect_posts().

Phil020782:

Hi,
I've just installed this mod for the first time, I'm using zen version 1.3.8a and the latest version of the reward point module. I'm having a few issues that I can't seem to figure out and would greatly appreciate any help.

1. I have run the diagnostics tool and all files and folders are ok but in the database section I get the following issues:

rewards_id- field missing in reward_status_track!!!
customers_id- field missing in reward_status_track!!!
orders_id- field missing in reward_status_track!!!
date- field missing in reward_status_track!!!
reward_points- field missing in reward_status_track!!!
status- field missing in reward_status_track!!!

> 
> and
> 
> ```
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

I have checked the database and the information from the sql file is in the database

2. I have set to have reward points based on subtotal but they are being calculated on total, I guess this has something to do with the issue above.

3. I have set manual redeem so that the customer can choose the amount of reward points to use but there is no option to enter the amount.

4. If a customer has enough reward points to cover the entire order value (resulting in a order total of 0.00) the checkout fails with an invalid total fault.

Any help would be greatly appriciated.

Thanks

I've figured out a work around for these problems:

1. I assume the reward_status_track issue is just because there have been no orders yet, so no information i the table?

2. I got around the subtotal issue by using the advanced rules. Points are based on order total so I set rules to add ot_subtotal and subtract ot_total this makes reward points based on subtotal.

3. still unresolved but not a critical feature

4. To eliminate the zero balance error I set the maximum redeem to 90% of the order so there ca never be a zero balance order.

hem:

The rp->process() was being called twice. Once as normal and secondly as part of rp->collect_posts().

if i comment out "$this->process()" under "collect_posts()" this should fix the issue correct?

Kezza

v1.31 now available.

Changes:

• Hardened algorithms dealing with Reward Point Redeem and how other Order Total mods are handled.
• Resolved issue whereby the Reward Point Redeem was appearing twice in the checkout on first load.
  Downloadable as always from http://www.omnicia.com/Zencart%20Reward%20Points%20Module.zip

I changed the admin folder name to something else for security reason. Does the new v1.31 work with the renamed admin folder?

I am using zencart v.1.3.9c.

Lina

lina0962:

I changed the admin folder name to something else for security reason. Does the new v1.31 work with the renamed admin folder?

I am using zencart v.1.3.9c.

Lina

Yes, just make sure you copy the files from admin/ into your renamed folder.

I upload the new v1.31 to my site. Under Admin->Configuration, there are two "Reward Points".

One is shown as configuration.php?gID=36. This one is blank.
The other is shown as configuration.php?gID=37. This one has contents.

Why is that? How can I delete the blank one? Thank you!

lina0962:

I upload the new v1.31 to my site. Under Admin->Configuration, there are two "Reward Points".

One is shown as configuration.php?gID=36. This one is blank.
The other is shown as configuration.php?gID=37. This one has contents.

Why is that? How can I delete the blank one? Thank you!

I believe this is due to the fact that the update sql really is not just an update of configuration changes. I had this problem during last update as well and had to manually delete the empty configuration from the database.

It would be nice if the update sql only contains new configuration/table options.

How to delete empty configuration in the database? In my case, does configuration.php?gID=36 mean the configuration_id is 36?
But in the database, I found configuration_id36 is "street addresses"...

lina0962:

How to delete empty configuration in the database? In my case, does configuration.php?gID=36 mean the configuration_id is 36?
But in the database, I found configuration_id36 is "street addresses"...

It's not in configuration...It's configuration group where you have duplicate

Just run remove_multiple_config_items.sql- It's in the root of the zip file.

hem:

Just run remove_multiple_config_items.sql- It's in the root of the zip file.

Is there a way to upgrade in a way that this problem actually doesn't happen? Running the current updates.sql still created the same problem.

BlessIsaacola:

Is there a way to upgrade in a way that this problem actually doesn't happen? Running the current updates.sql still created the same problem.

Problem is because it has to be designed to run under SQL Patch in Zencart Admin I can't do any basic checking. The 2 options I have is to remove the CREATE TABLEs altogether or to add the code from remove_multiple_config_items.sql to the end of the script.

I have a question about "reward points" configuration.

I want customers to redeem maximum 10% of the subtotal of a single order. So I set the maximum amount of earned points that can be redeemed against a single orderset to be 10%.

My question is can I set the minimum amount of earned points needed before they can be redeemed to be a absolute value (eg 500)? or is it has to be a percentage too?

Thanks!

hem:

Strange- I did a search in the code and it only turns up once.

When a user in NOT logged in, he sees CUSTOMER_NOT_LOGGED_IN_TAG, right? When a user have nothing in cart, he sees NO_REWARD_POINTS_IN_CART_TAG, right? Both these mesages have the same id="cartBoxEmpty", all defined in tpl_reward_points.php file (also in v1.31 of this RP mod).
So, when a user in NOT logged in and have nothing in his cart, TWO DIVs with the same ID appear, am I right?

hem:

There was a big discussion about how points should be awarded wit or without tax. It was decided that if you were awarding points by product then it was fair that the amount be the same regardless if the tax was different due to country/state rates. However if you wanted to award points on the total spend you can always set the mod to award on cart total.
We have two different taxes in our country... Never mind, I made my own workaround, but I am not alone when I need to choose whether display reward points by product WITH or WITHOUT taxes. So, if you will have some free time, I will be very grateful ;o)

imagino:

When a user in NOT logged in, he sees CUSTOMER_NOT_LOGGED_IN_TAG, right? When a user have nothing in cart, he sees NO_REWARD_POINTS_IN_CART_TAG, right? Both these mesages have the same id="cartBoxEmpty", all defined in tpl_reward_points.php file (also in v1.31 of this RP mod).
So, when a user in NOT logged in and have nothing in his cart, TWO DIVs with the same ID appear, am I right?

Do you have the shopping_cart_with_rewards and the reward_points sideboxes both switched on?

lina0962:

I have a question about "reward points" configuration.

I want customers to redeem maximum 10% of the subtotal of a single order. So I set the maximum amount of earned points that can be redeemed against a single orderset to be 10%.

My question is can I set the minimum amount of earned points needed before they can be redeemed to be a absolute value (eg 500)? or is it has to be a percentage too?

Thanks!

They are only a percentage if you add % to the end of the figure. If you just put in say "500" then that's 500 points.

imagino:

We have two different taxes in our country... Never mind, I made my own workaround, but I am not alone when I need to choose whether display reward points by product WITH or WITHOUT taxes. So, if you will have some free time, I will be very grateful ;o)

It shouldn't be too hard- I can use all the expertise I gained from writing the Inc/Ex tax mod :cool: