Reward Points Module for ZC v13x

Installed RP version 133a. Same problem as all earlier versions. ZC Version 1.38a
Configuration is complete. Running rpd.php shows NO errors or missing files. All sideboxes configured correctly. When an item is selected, points show in sidebox and all during checkout. Order confirmation and archived order show correct reward point total. I can award a customer points in the Admin, and they are displayed and can be redeemed as normal.

But with a regular order, no points are written into the database. No pending, no earned. Changing status settings make no difference. Tables for storing pending or earned points in DB are empty. Only "awarded" points are there.

I think it may be that we don't use any payment method that can be confirmed at time of order. The only payment options are Purchase Orders and Off-Line Credit Cards. No Paypal or anything like that.

Got any ideas where to look?

Sailman:

Installed RP version 133a. Same problem as all earlier versions. ZC Version 1.38a
Configuration is complete. Running rpd.php shows NO errors or missing files. All sideboxes configured correctly. When an item is selected, points show in sidebox and all during checkout. Order confirmation and archived order show correct reward point total. I can award a customer points in the Admin, and they are displayed and can be redeemed as normal.

But with a regular order, no points are written into the database. No pending, no earned. Changing status settings make no difference. Tables for storing pending or earned points in DB are empty. Only "awarded" points are there.

I think it may be that we don't use any payment method that can be confirmed at time of order. The only payment options are Purchase Orders and Off-Line Credit Cards. No Paypal or anything like that.

Got any ideas where to look?

I had that exact problem and this answer by retched fixed it for me

Is the order total modules installed and set to "True" in admin?

Sailman:

Installed RP version 133a. Same problem as all earlier versions. ZC Version 1.38a
Configuration is complete. Running rpd.php shows NO errors or missing files. All sideboxes configured correctly. When an item is selected, points show in sidebox and all during checkout. Order confirmation and archived order show correct reward point total. I can award a customer points in the Admin, and they are displayed and can be redeemed as normal.

But with a regular order, no points are written into the database. No pending, no earned. Changing status settings make no difference. Tables for storing pending or earned points in DB are empty. Only "awarded" points are there.

I think it may be that we don't use any payment method that can be confirmed at time of order. The only payment options are Purchase Orders and Off-Line Credit Cards. No Paypal or anything like that.

Got any ideas where to look?

What other mods do you have installed? Specifically any order mods (Super Orders for instance)

Yes. In the Admin/Order Total Modules, Reward Points (ot_reward_points) is turned on and True. Reward Points Tiered Discount is OFF and Reward Points Earned is ON.

Hem, yes. I do have Super Orders enabled. The only other Order Total mod is Quantity Discounts (ot_big_chooser).

There is no Shipping, no taxes. We do have a single Group Discount and a Discount Coupon that will probably go away if I can get the Reward Points mod running.

It seems to work everywhere, with no error messages anywhere, but it just does not write the points in any status to the DB. Does that help?

Sailman:

Yes. In the Admin/Order Total Modules, Reward Points (ot_reward_points) is turned on and True. Reward Points Tiered Discount is OFF and Reward Points Earned is ON.

Hem, yes. I do have Super Orders enabled. The only other Order Total mod is Quantity Discounts (ot_big_chooser).

There is no Shipping, no taxes. We do have a single Group Discount and a Discount Coupon that will probably go away if I can get the Reward Points mod running.

It seems to work everywhere, with no error messages anywhere, but it just does not write the points in any status to the DB. Does that help?

The most obvious culprit is one of the mods which is using a version of orders.php that is v.1.3.7 or earlier- None of these used the observer/notifier system that was introduced in v1.3.8- Without this the Reward Points are never posted. Best thing to do would be to check your version of orders.php against the current version using WinMerge or something similar.

Sailman:

Installed RP version 133a. Same problem as all earlier versions. ZC Version 1.38a
Configuration is complete. Running rpd.php shows NO errors or missing files. All sideboxes configured correctly. When an item is selected, points show in sidebox and all during checkout. Order confirmation and archived order show correct reward point total. I can award a customer points in the Admin, and they are displayed and can be redeemed as normal.

But with a regular order, no points are written into the database. No pending, no earned. Changing status settings make no difference. Tables for storing pending or earned points in DB are empty. Only "awarded" points are there.

I think it may be that we don't use any payment method that can be confirmed at time of order. The only payment options are Purchase Orders and Off-Line Credit Cards. No Paypal or anything like that.

Got any ideas where to look?

Had the same issue but made changes in a "Setting" and issue resolved itself. BUT, I can't remember which setting(s) that I changed since RP is currently installed in my sandbox and am still in the familiarization & setup mode. It may have been related to the "Sunrise" settings but I had changed several settings and am unable to reproduce the issue again.

Issue:

Expected effect is to award double points for this product category

• Points Ratio set to 2.0 for one product category.
• Product description does show double points to be rewarded.
• When product is added to cart, sidebox only shows 1x points to be rewarded.
• After checkout, only 1x points show pending in sidebox.
• Admin change order status to delivered and only 1x points show awarded when customer checkout confirmation page is refreshed.

Expected effect is to award ZERO points for products in this category.

• Points Ratio set to 0.0 for a different product category
• Product description shows 1x points to be rewarded.
• Product added to cart shows 1x points to be rewarded.
• After checkout, 1x points show pending
• After Admin status change, 1x point are actually awarded.

Did I have a brainfart and miss something?
1.3.9f

RixStix:

Issue:

Expected effect is to award double points for this product category

• Points Ratio set to 2.0 for one product category.

• Product description does show double points to be rewarded.

• When product is added to cart, sidebox only shows 1x points to be rewarded.

• After checkout, only 1x points show pending in sidebox.

• Admin change order status to delivered and only 1x points show awarded when customer checkout confirmation page is refreshed.

Expected effect is to award ZERO points for products in this category.

• Points Ratio set to 0.0 for a different product category

• Product description shows 1x points to be rewarded.

• Product added to cart shows 1x points to be rewarded.

• After checkout, 1x points show pending

• After Admin status change, 1x point are actually awarded.

Did I have a brainfart and miss something?
1.3.9f

Rick- you need to check the Reward Point Mode setting in your Reward Points config. This needs to be set to 0 for the rewards ratio to work. If you base the RP on subtotal or total the the individual ratios get ignored.

I did a search on this thread, but couldn't find the answer and there are too many pages to read through :)

It looks like there was a feature on the wishlist to have customers automatically receive reward points for referring a friend, was this feature ever implemented?

Thank you!

TNX Andrew,

My brainfart. All seems OK now.

wishlist: Point redeemable only for certain category items or categories instead of entire catalog. (don't tell me I've had another brainfart)

Danielle:

I did a search on this thread, but couldn't find the answer and there are too many pages to read through :)

It looks like there was a feature on the wishlist to have customers automatically receive reward points for referring a friend, was this feature ever implemented?

Thank you!

It's not in the mod right now but there is something in development. Watch this space.

RixStix:

TNX Andrew,

My brainfart. All seems OK now.

wishlist: Point redeemable only for certain category items or categories instead of entire catalog. (don't tell me I've had another brainfart)

No, that one is at the top of the wishlist. Fancy being a beta-tester? I should have something ready in the next week or so.

I'm using 1.3.9f

When I tried installing by applying the new.sql patch, I get this error:

Success 24 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 17 statements ignored. See "upgrade_exceptions" table for additional details.
I already tried applying uninstall.sql and remove_multiple_config_items.sql but it keeps returning that error.

The reward point config in admin panel doesn't show any options (just blank).

Any clue?

This is my server info

Apache/1.3.41 (Unix) mod_ssl/2.8.31 OpenSSL/0.9.8e PHP/5.2.10
MySQL client version: 5.0.83
PHP extension: mysqli
MySQL server version 5.0.77 protocol version 10

Justapeddler:

I'm using 1.3.9f

When I tried installing by applying the new.sql patch, I get this error:

I already tried applying uninstall.sql and remove_multiple_config_items.sql but it keeps returning that error.

The reward point config in admin panel doesn't show any options (just blank).

Any clue?

This is my server info

Have you checked your MySQL DB for the configuration items?

Hi,

Is there any news on support for Paypal IPN? It's taking me so long each day updating the points manually for paypal orders...

Thanks.

hem:

No, that one is at the top of the wishlist. Fancy being a beta-tester? I should have something ready in the next week or so.

Don't mind testing it at all. That's what this is all about.

retched:

Have you checked your MySQL DB for the configuration items?

Yes, I tried to search for %REWARD% in the configuration table but there's no entry like that. The sql patcher failed to input the reward addon configuration entries. Do I need to somehow enter those manually?

Justapeddler:

Yes, I tried to search for %REWARD% in the configuration table but there's no entry like that. The sql patcher failed to input the reward addon configuration entries. Do I need to somehow enter those manually?

I'd say try it using phpmyadmin BUT remember this caveat, you have to rename the CREATE and INSERT INTO table references to match your databases name. That is if you have a prefix you have to change:

CREATE TABLE reward_status_track (

to

CREATE TABLE thisismyprefix_reward_status_track (

Finally I resolved my issue thanks to this post: http://www.zen-cart.com/forum/showpost.php?p=846837&postcount=1807

Followed it and finally I can try this reward point addon!

Now I have a question: Is it possible to set a level in the reward point? e.g. 0-$100 orders are given 5% reward points, $100-$300 orders are given 8% and $300+ are given 10%.

Justapeddler:

Finally I resolved my issue thanks to this post: http://www.zen-cart.com/forum/showpost.php?p=846837&postcount=1807

Followed it and finally I can try this reward point addon!

Now I have a question: Is it possible to set a level in the reward point? e.g. 0-$100 orders are given 5% reward points, $100-$300 orders are given 8% and $300+ are given 10%.

No that isn't currently possible. The module will only take the entire portion of the order and either line by line calculate the reward points total OR the entire total of the order against the discount.