Reward Point Mod beta now available

NullMind:

Haha .. foudn the cupilt

Only products on SPECIAL pricing show points .. products NOT on sale do not

Bug ? :yuck:

Can't reproduce it- check out the attached images- They show the same item with Base Price, Sale Price and Special Price and the Reward Points are being calculated correctly.

hem:

Can't reproduce it- check out the attached images- They show the same item with Base Price, Sale Price and Special Price and the Reward Points are being calculated correctly.

the the pics you showed had some kind of sale (see the 185 crossed on all 3)

... hang on

Andrew

If I rever to the default reward_points_function.php the points how up, but it's basically liek turning off "Adjust Reward Points for Sales/Specials"

you can see it here how it works when Adjust Reward Points for Sales/Specials is ON

[img]http://i165.photobucket.com/albums/u75/Null-Mind/Picture6.jpg[/img]

[img]http://i165.photobucket.com/albums/u75/Null-Mind/Picture7.jpg[/img]

Ah- found it now- I was looking in the wrong place.

1.03b (bugfix version of final beta)

Renamed 'reward_point_history' table to 'reward_status_track' to better describe its job.
Added Status Syncing and removed all core code dependencies.
Fixed base price not being used correctly when Sale/Specials in use.
Fixed Global Redeem not displaying under Admin->Customers->Redeem Points
Fixed issue with Transfer All Earned to Pending not working correctly
Added calculations for Discounted/Special/Free Reward Points.

Extra instructions

This version is the core code friendly version and doesn't modify or change any other file. I'm particularly interested in any feedback from users of mods such as Quick and Easy Checkout and the like.

If you have installed a previous version of this mod and changed the order.php you will need to reload your order.php to the pre-install version. Failure to do this will give unexpected results in the reward points.

Take note of the following from the readme.txt

3. Run the appropriate sql file using Admin->Tools->Install SQL Patch

3.1 If you are installing this mod for the first time use 'new.sql'

3.2 If you are updating this mod from a previous version use 'update.sql'

3.2.1 If you use table prefixes in ZenCart you will need to manually rename 2 Reward Point Mod tables:

3.2.1.1 Rename 'yourprefix_reward_product_points' to 'yourprefix_reward_master'

3.2.1.2 Rename 'yourprefix_reward_point_history' to 'yourprefix_reward_status_track'

Sheesh, I get sick for a few days and look at all the changes :shocking:

Guess I will get busy and check things out. Thanks again Andy!

Hey PTC, hope you are okay now- Was a little under the weather myself but that was birthday-related-self-inflicted.

You use some form of Transaction Tracker mod don't you??? I would be interested in any feedback you have with this version of RP working alongside it.

hem:

Hey PTC, hope you are okay now- Was a little under the weather myself but that was birthday-related-self-inflicted.

You use some form of Transaction Tracker mod don't you??? I would be interested in any feedback you have with this version of RP working alongside it.

Yes I do. I will let you know how it goes. Installing the mod now.

NullMind:

actually, I was just looking at it, and i'm sorry, my custom cart_sidebox is all on the CSS .. so the code is the same as the default one

basically what I'd liek is to instead of just having

I'd liek the entire info that is available on

tpl_reward_points (sidebox)

The easiest would be to copy and paste the code from tpl_reward_points into your custom code. The only line you would need to change would be:

$content='<div id="'.str_replace('_', '-', $box_id . 'Content').'" class="sideBoxContent">';

add a full stop after '$content' and before the '=' so it reads:

$content.='<div id="'.str_replace('_', '-', $box_id . 'Content').'" class="sideBoxContent">';

Looks like the global redeem is working...kind of. Take a look at these two screen shots.

You can see in the admin pic (2) that the redeem value is $21.00 as it should be. However, when I go to make a purchase, it shows $0.00 on the Payment page for Value Rewards Points (pic 1). So it's showing correctly in the admin, but not on the checkout pages.

It works fine with the Ty Package tracking mod. :clap: No modifications were needed to that mod.

It does not work with the Better Together mod. I have two different things set up. One is buy one and get the other at 50% off. It's giving full redeem value for both. The other is buy one get another free. It's giving full value for both.

I have it setup in admin to give 0 for free items and to use discount price and not base.

It works fine when using Zens built in discount and sales mods, but not the Better Together or the Quantity discount mods.

Other than that It all appears to work for me. Looking very nice. :clap:

Andrew

the update.swl does not work for me

I initially got

#1050 - Table 'reward_master' already exists

so I skip that and now I get

#1060 - Duplicate column name 'redeem_ratio'

any ideas ?

NUllMind, if you updating from the last mod he posted to the thread here, then the only thing you need to run is:

RENAME TABLE `reward_point_history` TO `reward_status_track`;

I don't think he has changed or adding anything else other than that line above from 1.03 to this one. That is all I changed and it's working alright execpt for the couple things I mentioned in my post above. Just remember, that if you use an extention in you database you need to add it to the above statement.

Mine reads like this:

RENAME TABLE `zen_reward_point_history` TO `zen_reward_status_track`;

pinetreecandles:

Looks like the global redeem is working...kind of. Take a look at these two screen shots.

You can see in the admin pic (2) that the redeem value is $21.00 as it should be. However, when I go to make a purchase, it shows $0.00 on the Payment page for Value Rewards Points (pic 1). So it's showing correctly in the admin, but not on the checkout pages.

It works fine with the Ty Package tracking mod. :clap: No modifications were needed to that mod.

It does not work with the Better Together mod. I have two different things set up. One is buy one and get the other at 50% off. It's giving full redeem value for both. The other is buy one get another free. It's giving full value for both.

I have it setup in admin to give 0 for free items and to use discount price and not base.

It works fine when using Zens built in discount and sales mods, but not the Better Together or the Quantity discount mods.

Other than that It all appears to work for me. Looking very nice. :clap:

Dammit- the first issue was the Global Redeem problem we had earlier. I have updated this function.

The Better Together mod seems to run its own set of tables so they would be "invisible" to the Reward Points mod as it only runs with the core ZenCart tables.

hem:

The Better Together mod seems to run its own set of tables so they would be "invisible" to the Reward Points mod as it only runs with the core ZenCart tables.

Yeah I figured it has something to do with having different tables. It's fine for me. I will use what functionality you have put in and come up with a something that will work for me.

Okay- let's try again (no need to rerun update.sql- just rename reward_point_history to reward_status_track)

hem:

Okay- let's try again (no need to rerun update.sql- just rename reward_point_history to reward_status_track)

You the best mate, it now works with super orders, mass moving of invoices to the rewarded category works !! :clap:

Now all I have left is keeping my fingers crossed that you will be able to do the referral thing soon.:D

Once you get that done, my boss would be VERY happy...

Questions from my boss (I was pretty sure of the answers, but I wanted to verify)

1. He wants to make sure that Rewards Points cannot be used for Shipping. Is this correct?

2. When purchasing something and using Rewards Points, does the use of RP reduce the number of RP gained (i.e. if I buy a $75 item, and use rewards points to reduce the cost by $5, do I get 70 RP or 75 RP?)

Rasyr:

Now all I have left is keeping my fingers crossed that you will be able to do the referral thing soon.:D

Once you get that done, my boss would be VERY happy...

It's top of the wishlist. Once this latest version gets passed by you lot, I will post it as a full release mod and then I can start looking at the mod additions.