Reward Points Module for ZC v13x

yes... I have that issue too

Asgoroth:

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.

That problem has been identified and is part of the v1.21a mod fixes. You can get the mod from here:

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

mipavluk:

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...

Install the latest version of this mod, it should sort out most of your problems:

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

hem:

That problem has been identified and is part of the v1.21a mod fixes. You can get the mod from here:

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

V1.21a is the version that I upgraded to.

Asgoroth:

V1.21a is the version that I upgraded to.

Give me a URL and I'll take a look.

hem:

Give me a URL and I'll take a look.

Here is an item that has a correct reward points: http://www.pettents.org/cart/index.php?main_page=product_info&cPath=43_61&products_id=1023

Here is a -1 listing: http://www.pettents.org/cart/index.php?main_page=product_info&cPath=78&products_id=1660

Asgoroth:

Here is an item that has a correct reward points: http://www.pettents.org/cart/index.php?main_page=product_info&cPath=43_61&products_id=1023

Here is a -1 listing: http://www.pettents.org/cart/index.php?main_page=product_info&cPath=78&products_id=1660

Okay- I think I've got it- The round down is causing the -1. Let me update the relevant function and I'll post an update in the morning.

hem:

Okay- I think I've got it- The round down is causing the -1. Let me update the relevant function and I'll post an update in the morning.

Thank you sir.

Asgoroth:

Thank you sir.

Sorry- it's taking a little longer than I hoped.

ok, I need help to start to understand things

(1)

today, a customer make a purchase and in her invoice say:

Reward Points Earned: 3

Where I can see this, to take a look in how many points she have acumulated from several orders?

in Customers/Reward Points?

in which column? Pending? or Earned?

Because right now... that customers have: 0 pending and 0 earned

(2)

If I decide, manually, give point to my customers from their old orders... where I need do this?

Please if somebody can help me...

I would like to be able to give new customers some reward points upon new account creation.

Suggestions on where I make add some code to do this?

Thanks,
W

mipavluk:

ok, I need help to start to understand things

(1)

today, a customer make a purchase and in her invoice say:

Reward Points Earned: 3

Where I can see this, to take a look in how many points she have acumulated from several orders?

in Customers/Reward Points?

in which column? Pending? or Earned?

Because right now... that customers have: 0 pending and 0 earned

What method did they use to pay for the order? Right now all methods except Paypal IPN work with the Reward Point mod.

mipavluk:

(2)

If I decide, manually, give point to my customers from their old orders... where I need do this?

Please if somebody can help me...

Go to Admin->Customers->Reward Points and click on the customer. You can add more points from that interface.

english_1969:

I would like to be able to give new customers some reward points upon new account creation.

Suggestions on where I make add some code to do this?

Thanks,
W

Edit YOUR_TEMPLATE/templates/tpl_create_account_success_default.php and add the code after:

<div id="createAcctSuccessMainContent" class="content"><?php echo TEXT_ACCOUNT_CREATED; ?></div>

This will do it:

<?php
if(isset($RewardPoints) && GetCustomersRewardPoints($_SESSION['customer_id'])==0)
 $RewardPoints->AddRewardPoints($_SESSION['customer_id'],1000);
?>

Note this will only add points if the customer has not already got any- Which should be a no brainer as this is a new account- However it stops the user from refreshing the Account Success page and continually adding more points to their account.

yes, I'm using paypal.... but what about if I give the points manually? I can do it one time per day... or per week... then they will be change by products again right?

hem:

Go to Admin->Customers->Reward Points and click on the customer. You can add more points from that interface.

Great! I go there.... click on a customer.

Set new Pricing Group/Redeem Ratio: -none-
There is not another option, only -none-

Add or Subtract Points
which one?

• Add extra points to Earned
  or
• Add extra points to Pending

when some points are Earned?

when some points are Pending?

I'm very confused at that point... when are earned and when are pending?

mipavluk:

yes, I'm using paypal.... but what about if I give the points manually? I can do it one time per day... or per week... then they will be change by products again right?

Great! I go there.... click on a customer.

Set new Pricing Group/Redeem Ratio: -none-
There is not another option, only -none-

Add or Subtract Points
which one?

• Add extra points to Earned
  or
• Add extra points to Pending

when some points are Earned?

when some points are Pending?

I'm very confused at that point... when are earned and when are pending?

Add Extra Points to Earned.

Points remain pending while you process the order. Usually once the order is processes then the points move to Earned and the customer can redeem them. This is to stop behavior such as a customer ordering an expensive item, then using the points on a different order and then cancelling the first order.

Hello,

Is this mod compatible with Paypal Express? Coz im getting the following error and as far as I can remember, this is the only reward points program I have installed.

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 'AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricin' at line 5
in:
[SELECT redeem_ratio FROM reward_master prp, customers as c LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]

And im using version 1.10a. What is the latest version?

Thx

hem:

Edit YOUR_TEMPLATE/templates/tpl_create_account_success_default.php and add the code after:

Dear Andrew,

I've installed the reward points module for my store but i face the problem for product attributes.
Below is the scenario:
Product A has 6 color but it does not use price by attributes. The product price is $15.90 originally. Then I apply a discount to it and the price become $11.90.
I've on the setting "Adjust Reward Points for Sales/Specials" but it still give 16 points for the product.

Hope you can help.

Thanks

Berserker:

Hello,

Is this mod compatible with Paypal Express? Coz im getting the following error and as far as I can remember, this is the only reward points program I have installed.

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 'AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricin' at line 5
in:
[SELECT redeem_ratio FROM reward_master prp, customers as c LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]

And im using version 1.10a. What is the latest version?

Thx

The latest version is v1.21a. You might want to check your MySQL version too. This mod needs at least v4.2 (though it does seem to work with v4.1).

yuki.npwong:

Dear Andrew,

I've installed the reward points module for my store but i face the problem for product attributes.
Below is the scenario:
Product A has 6 color but it does not use price by attributes. The product price is $15.90 originally. Then I apply a discount to it and the price become $11.90.
I've on the setting "Adjust Reward Points for Sales/Specials" but it still give 16 points for the product.

Hope you can help.

Thanks

Can you give me a URL and I'll have a look.