Reward Point Mod beta now available

Rasyr:

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?

Yes- the points are only redeemed against the purchase, not any "additions".

Rasyr:

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?)

No- you still gain full RP- for the same reason that you cannot redeem against shipping- The RP is against the raw order.

NullMind:

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

That's good to hear- thanks for the feedback NM.

hem:

Yes- the points are only redeemed against the purchase, not any "additions".

No- you still gain full RP- for the same reason that you cannot redeem against shipping- The RP is against the raw order.

To clarify this further is you look at the default reward against redeem (at 1:100) in the scenario you propose the customer would use 500 reward points to bring the price down by $5 but would only earn 5 points difference in the order (worth 5 cents) so not really something I would worry about coding in the near future.

Just wanted to be clear -- remember, I gots to report to de boss... ;)

Rasyr:

Just wanted to be clear -- remember, I gots to report to de boss... ;)

Boss! Boss! De Plane, de plane.

[sorry- channelling Hervé Villechaize]

hem:

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

Hello,

Is this the latest version?

Thx

got a request

on the user CP, can it be made so they see the amoutn of points they have PLUS the value of it, liek they get on the checkou page

at this moment just shows the total amount of points, not it's value

hehe... got another request for the future features...

New Member award -- i.e. a new member joins and he gets xx points. (kinda like the new member coupon or GC). ;D

uploaded the files and can't get into admin now....this is the error...

oh!! that brings up a question, before I attempt to install.

How does this interact with table prefixes? For example, if all of my store tables use the prefix "zen_" before the tables, will the new tables have that prefix? Will the code be looking for the tables to have that prefix?

Crzipilot:

uploaded the files and can't get into admin now....this is the error...

<DIV class=systemError>1146 Table 'villscom_zencart.reward_status_track' doesn't exist in: [SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date

That sounds like you need to run the sql code -- if you cannot do it from Admin, do you have access to an interface of some sort for the DB like PHPMyAdmin?

Strange, it's fixed now. yes it was looking for the sql to be run it seems, though, it wouldn't let me log into admin. All I had done was copy the files over into zencart. Anyways, I got the sql to run, and everything is normal now....

Andrew, nice work!

I am back to my office today and find you already updated your project.
I test it on local and all working, very nice!! :clap:

The only problem was I got an error message in the IE staus when I click the "Customer Reward Points Admin" page. it's show:
line:18
error:'null' is not a project
website :http://127.0.0.1/138a/admin/customers_reward_points.php

This page is still working, just list all customers there. no matter they have pending points or not.

I set Max Transactions to Display in Customer Admin = 20,
so in the "Customer Reward Points Admin", should be only display 20 "pending" customer per page?
But I got all customers showed in that page. if i have 1000+ customer, that will be a long list.

I think maybe that error make this page not working properly.
Someone can confirm this point? or just I have this problem?

again, thank you very much.

another point:

In the check out, the "Value of Redeemed Reward Points" should be "subtraction sign", if can be red, that's better.

otherwise, customer will confusing.
I attach a picture here.

One Bug:
Before checking out, there is 100points in the cart, after paying via Paypal, the order is made successful, but there is nothing in the pending point. that means pay via paypal won't get the points.

anyone have such problem?

Crzipilot:

uploaded the files and can't get into admin now....this is the error...

<DIV class=systemError>1146 Table 'villscom_zencart.reward_status_track' doesn't exist in: [SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.date

Read the instructions in the readme.txt regarding the renaming of the reward_points_history table.

Rasyr:

oh!! that brings up a question, before I attempt to install.

How does this interact with table prefixes? For example, if all of my store tables use the prefix "zen_" before the tables, will the new tables have that prefix? Will the code be looking for the tables to have that prefix?

Yes, RP uses the same prefixes for it's tables as the rest of ZenCart.

fiji:

One Bug:
Before checking out, there is 100points in the cart, after paying via Paypal, the order is made successful, but there is nothing in the pending point. that means pay via paypal won't get the points.

anyone have such problem?

Does the customer receive an email informing them of the order?

NullMind:

got a request

on the user CP, can it be made so they see the amoutn of points they have PLUS the value of it, liek they get on the checkou page

at this moment just shows the total amount of points, not it's value

Added to wishlist

Rasyr:

hehe... got another request for the future features...

New Member award -- i.e. a new member joins and he gets xx points. (kinda like the new member coupon or GC). ;D

Added to wishlist