Reward Points Module for ZC v13x

BTW, The test order was pay via wire transfer and the order status is pending, i also changed the order status to dispatch, but haven't any reward points pending or earned.

1. I don't know why it doesn't generate points. I have the same issue when order paid by Paypal.

2. The shipping cost be eared the points becuase you had "Allow Redeem of Reward Points on Order Total or Subtotal" set to 1.

hem:

Any idea what causes the different transaction types?

christon26:

Would Paypal themselves be able to give you that information? I know for my records, every single Paypal transaction since I put in the PDT Token has been web_accept, I only sell downloadables or virtual services and I don't do tax or shipping lol

All my products are virtual product. No tax... no shipping fee. But some Paypal transactions are Web_accept others are Unique. I couldn't figure out the different between these two transaction types. :unsure:
I use Godaddy VPS and had the lastest Paypal patch.
All Web_accept transactions have reward points and but not Unique transactions.

neteasy, I had set "Allow Redeem of Reward Points on Order Total or Subtotal" to 1, but the sidebox reward points shows that '185 reward points in cart',

try 0 ...

Re: Reward Points Module- Live Release now available.
neteasy, I had set "Allow Redeem of Reward Points on Order Total or Subtotal" to 1, but the sidebox reward points shows that '185 reward points in cart',

Sorry, i said that wrong on last post.

I had set "Allow Redeem of Reward Points on Order Total or Subtotal" to 0, when i view the rest order detail in my test account, but the sidebox reward points shows that

185 reward points in cart
0 points earned
0 points pending

Beta of v1.21 now available. You can get it from here:

http://www.omnicia.com/Zencart%20Reward%20Points%20Module.zip

This update focuses mainly on the Customer Reward Point Admin area. There's a new alphabetical index added to make it quicker to navigate around customers. Plus the LIMIT on Customers displayed is now a configuration. Note this is just a "middle ground"; I still want to make the navigation a lot easier. I'm also moving it to AJAX.

Changes in v1.21:

Added Alphabetical Index to Customer Record List under configuration.
Fixed bug in Edit Reward Points under Searched for Customer
Added Max Customer Records in List LIMIT under configuration.
Extended Search under Admin -> Customer Reward Points (as per suggestion on ZenCart forums)
Added license as per new ZenCart mod rules (http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0)
Updated tpl_products_reward_points.php to $_GET the products_id.
Fixed upgrade.sql SQL patch.

FYI. The Reward Point Diagnostic Tool is still available at: http://www.omnicia.com/rpd.zip

hem:

Beta of v1.21 now available. You can get it from here:

http://www.omnicia.com/Zencart%20Reward%20Points%20Module.zip

This update focuses mainly on the Customer Reward Point Admin area. There's a new alphabetical index added to make it quicker to navigate around customers. Plus the LIMIT on Customers displayed is now a configuration. Note this is just a "middle ground"; I still want to make the navigation a lot easier. I'm also moving it to AJAX.

Changes in v1.21:

Added Alphabetical Index to Customer Record List under configuration.
Fixed bug in Edit Reward Points under Searched for Customer
Added Max Customer Records in List LIMIT under configuration.
Extended Search under Admin -> Customer Reward Points (as per suggestion on ZenCart forums)
Added license as per new ZenCart mod rules (http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0)
Updated tpl_products_reward_points.php to $_GET the products_id.
Fixed upgrade.sql SQL patch.

FYI. The Reward Point Diagnostic Tool is still available at: http://www.omnicia.com/rpd.zip

I think there is a problem with the update.sql in 1.21beta. You first line is ```
CREATE TABLE reward_master

This is the only database changes in the upgrade:

REPLACE INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

Can you please provide instruction how to update the database with the above changes?

Thanks!

BlessIsaacola:

I think there is a problem with the update.sql in 1.21beta. You first line is ```
CREATE TABLE reward_master

> 
> This is the only database changes in the upgrade:
> ```
REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

Can you please provide instruction how to update the database with the above changes?

Thanks!

The CREATE TABLE is there for completeness. Also if you upgrade from a version prior to v1.03a then it's a requirement. Unfortunately MySQL does not have a IF TABLE NOT EXIST directive. Don't worry about it, it will fail gracefully.

To just apply the single change for this version copy and paste the following into Admin->Tools->SQL Patch. Note: This applies for this release only.

SET @group_id = '';
SELECT (@group_id := `configuration_group_id`) FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Reward Points';

REPLACE INTO `configuration` 
(`configuration_id` ,`configuration_title` ,`configuration_key` ,`configuration_value` ,`configuration_description` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

First issue.
I put on a test order in my site via Wire transfer, then i get 160 points when purchase 160 dollars( one dollar earn on point), but there isn't any points appear in 'Customers - Reward Points'.

When i log in my site with the test account, there isn't any points appear in the 'Reward Points' sidebox.

Second issue
on the test order detail: it shows that 'Reward Points earned: 160', but in the 'Reward Points' sidebox, it shows that '185 reward points in cart', The total order with the shipping is 185 dollars. Why do the shipping cost be eared the points?

The Reward Points configration is

Reward Point Mode 1
Reward Point Sidebox Display 0
Reward Point Status Track Simple
Reward Point Sunrise Period 0
Reward Point Redeem Minimum 0
Reward Point Redeem Maximum 250
Reward Point Rounding 0.5
Max Transactions to Display in Customer Admin 12
Delete Old Reward Transactions Period 0
Adjust Reward Points for Sales/Specials 1
Allow Reward Points on Free Products 0
Allow Redeem of Reward Points on Order Total or Subtotal 1
Set Minimum Order Value to Redeem Points Against 0

Any help would be appreciated.

hem:

Yes, that's the issue. Regular Paypal works. Paypal IPN (like Google Checkout) however does not use the same 'path' as any of the other payment methods and so the reward point mod never gets called.

I've tried various ideas to affect a workaround but none of them have been satisfactory. At this stage I think the only way around it is to modify the core code for the Paypal IPN (and Google Checkout) payment modules.
Hi Andrew, Is this something could be fixed in the next release? Thanks :smile:

hem:

The CREATE TABLE is there for completeness. Also if you upgrade from a version prior to v1.03a then it's a requirement. Unfortunately MySQL does not have a IF TABLE NOT EXIST directive. Don't worry about it, it will fail gracefully.

To just apply the single change for this version copy and paste the following into Admin->Tools->SQL Patch. Note: This applies for this release only.

SET @group_id = '';
SELECT (@group_id := configuration_group_id) FROM configuration_group WHERE configuration_group_title LIKE 'Reward Points';

REPLACE INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Limit maximum Customers on Listings', 'REWARD_POINTS_CUSTOMER_LIMIT', '50', 'Set the maximum number of records to appear on each page under Customer Reward Point admininstration page.', @group_id, '11', NULL, now(), NULL , NULL);

Thank you so much the SQL update worked!

Hello. First up great stuff! Second.. How do i turn it off? it now shows
-1 PRODUCT_REWARD_POINT_TAG in all my products.. is there a line i can remove ?

LekeFly:

Hello. First up great stuff! Second.. How do i turn it off? it now shows
-1 PRODUCT_REWARD_POINT_TAG in all my products.. is there a line i can remove ?

Just delete includes\templates\YOUR CUSTOM FOLDER\templates\tpl_product_info_display.php

I have just installed the Easy sign up and log in mod and the checkout without account mod.
The problem I have is that the Reward points mod is now ignoring the redeem maximum of 25% I had set up.
It will now only redeem 25p.
if I change it to 50% then it redeems 50p.

I'm not using the latest release of reward points, using version 1.13a I think.

hem:

Already on the list (Reward Points- Advanced Redeem)

excause me, that mean customer can choose they wanted how many points to spend include thire own total reward points ??:oops:

thx

Andrew, I try to install the mod in my other store... and again... doesn't work...
can you take a look there please?

me again... in the fist store where I installed... and you fix my problems...
http://digiscrapsmania.com/tienda
I try to edit the points of some customers, to give them points for your old orders:
Customers/Rewards Point
but there, I don't see all my customers, only 40 and I don't have way to change to the next page... something is wrong there...

I continue here....

which is the difference between pending points and earned points?

I can't understand why in some orders give pending points and in other earned...

I have an order, where said: reward points earned: 2, but when I go to Customers/Reward Points, that customer have earned 0, pending 0

In other case, I have an order with: reward points earned: 1, but when I go to Customers/Reward Points, that customer have earned 0, pending 1

:frusty: someone who use the mod can explain me? thanks in advance...

After upgrading from v1.13 we have run into the issue of products that have a ratio of 0 display "-1 Reward Points". I have attempted to set the radio all the way down to the individual product the same results. While I could modify the code to force a 0 to be displayed in place of the -1, I feel it is better to find out where the -1 is coming from.