Reward Point Mod beta now available

Hello,

Is version 1.01a the latest version? That is the most latest I can see on Zen Cart downloads. Also, is this new version the one that doesn't overwrite orders.php?

Thx

Wishlist Addition.....

Teirs -- being able to setup teirs so that those who use the site more frequently earn more points (or redeem them at a higher value, etc..

I know that this would likely require the addition of a number of fields, such as one that tracks the total points ever earned, as well as multiples of the ratios for determining the ratios (and perhaps a "teir name" field, so we can have Silver and Gold Members hehe).

If you cannot tell, I am extremely excited about this module :thumbsup: :thumbsup: :thumbsup:

Berserker:

Hello,

Is version 1.01a the latest version? That is the most latest I can see on Zen Cart downloads. Also, is this new version the one that doesn't overwrite orders.php?

Thx

Berserker, I do not think that that is the latest version (it was the first one I looked at and Andrew has posted several updates in here since ).

Also a quick check at the contents of the zip file for it shows that it contains the orders.php file, so I would presume it is one of the versions that overwrites that file.

Like you, I am also waiting on our **wonderful **Zen team to upload the final version of the module.

Rasyr:

Berserker, I do not think that that is the latest version (it was the first one I looked at and Andrew has posted several updates in here since ).

Also a quick check at the contents of the zip file for it shows that it contains the orders.php file, so I would presume it is one of the versions that overwrites that file.

Like you, I am also waiting on our **wonderful **Zen team to upload the final version of the module.

Thanks! Can't wait for it :)

Andrew -- If I install the last beta that you posted in here, when the full version is posted, all I should have to do is overwrite the files, correct?

(my boss is impatient...) hehe

does anybody know of an easy way to update ALL my customers to give them 1000 rp all at once?

OKay -- I have a couple of problems

1. I have no item for Rewards Points listed under Admin|Configuration|Rewards Points (this last bit isn't there).

2. When I go to Customers|Reward Points and try to edit a customer, I am getting the following error:

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 'REWARD_POINTS_MAX_TRANSACTIONS' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM shop_reward_status_track WHERE customers_id=51 AND status=0 ORDER BY date DESC LIMIT REWARD_POINTS_MAX_TRANSACTIONS;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

3. when I ran the New.sql code, it did not give the tables the prefix that I use for my store. I had to go in and rename the tables to add in the store prefix.

Note: this was the last beta update that you posted in the thread here

Rasyr:

Wishlist Addition.....

Teirs -- being able to setup teirs so that those who use the site more frequently earn more points (or redeem them at a higher value, etc..

I know that this would likely require the addition of a number of fields, such as one that tracks the total points ever earned, as well as multiples of the ratios for determining the ratios (and perhaps a "teir name" field, so we can have Silver and Gold Members hehe).

If you cannot tell, I am extremely excited about this module :thumbsup: :thumbsup: :thumbsup:

I do something like this now. Simply use the Reward Point Admin to create groups and give that group a higher redeem ratio than the other groups. It just means I have to add the customers to the groups I want them in. It's not automated, but it works.

Rasyr:

Andrew -- If I install the last beta that you posted in here, when the full version is posted, all I should have to do is overwrite the files, correct?

(my boss is impatient...) hehe

Since it doesn't touch any core files all you should have to do is overwrite the old files, unless you have made a modification to any of them. Then of course you would have to merge your changes.

Rasyr:

OKay -- I have a couple of problems

1. I have no item for Rewards Points listed under Admin|Configuration|Rewards Points (this last bit isn't there).

2. When I go to Customers|Reward Points and try to edit a customer, I am getting the following error:

3. when I ran the New.sql code, it did not give the tables the prefix that I use for my store. I had to go in and rename the tables to add in the store prefix.

Note: this was the last beta update that you posted in the thread here

If your not doing this on a live site, then you might find it easier to remove the tables and entries from the database for the mod. Then run the SQL file for a new install. If that is not an option, make sure all the tables are created and named properly, compare the sql file to what you have in your database under configuration Group and Configuration and make sure the fields are there. Then make sure all the files have been uploaded.

If your store uses an extention, like yours does, so does mine, then you have to add it.

okay, got it all working....

the sql file also does NOT deal with any store prefixes at all, so when I ran it, none of the configuration settings got ran

once I changed it to include the prefix, it installed and I can set options now

pinetreecandles:

Since it doesn't touch any core files all you should have to do is overwrite the old files, unless you have made a modification to any of them. Then of course you would have to merge your changes.

This is is my first time installing, and it was with a no overwrite of orders.php version. So, unless the full release makes DB changes to this last beta file, I am not making any changes (had enough problems getting it working with my store cause of the table prefixes....

Downloaded the latest from the downloads section and installed. Ran a few tests and didn't come across any issues! :clap: I use Paypal and 2checkout for payments. I will have to test those on a live site since I can't get either to work right on my local site.

If I come across any issues with either payment option I will post it.

Nice job andy and thanks a bunch for your time and effort on this :clap:

pinetreecandles:

Downloaded the latest from the downloads section and installed. Ran a few tests and didn't come across any issues! :clap: I use Paypal and 2checkout for payments. I will have to test those on a live site since I can't get either to work right on my local site.

If I come across any issues with either payment option I will post it.

Nice job andy and thanks a bunch for your time and effort on this :clap:

Did they give it a new link?? I am still seeing it as version 1.01a from Feb 28th.

Also, the last Beta seems to be discounting shipping as well as the subtotal.

See the attached image
http://www.wizlair.net/RP01.gif

they did give it an all new entry

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=1002

I still have a problem -- in the order totals modules section, I am not seeing where to set the redeem value (I manually set it in the DB cause of my earlier table problems), but it isn't showing up in Admin

And it is still showing up and deducting from shipping AND subtotal both (we don't want Reward Points to be usable for shipping!!)

Rasyr:

I still have a problem -- in the order totals modules section, I am not seeing where to set the redeem value (I manually set it in the DB cause of my earlier table problems), but it isn't showing up in Admin

And it is still showing up and deducting from shipping AND subtotal both (we don't want Reward Points to be usable for shipping!!)

The Global redeem value is set in admin>customers>Group Reward Redeem. You can also set redeem values based on groups you create.

When you say it discounts shipping do you mean when a customers redeems some points it takes it from shipping as well as the subtotal? So things are discounted twice?

You may have to change around your order total sort to have shipping applied after your discounts. Shipping shouldn't be affected then if that is the case.

Rasyr:

okay, got it all working....

the sql file also does NOT deal with any store prefixes at all, so when I ran it, none of the configuration settings got ran

once I changed it to include the prefix, it installed and I can set options now

You need to run it under Tools->Install SQL Patch. That way ZenCart will handle the prefixes correctly.

pinetreecandles:

You may have to change around your order total sort to have shipping applied after your discounts. Shipping shouldn't be affected then if that is the case.

PTC hit the nail on the head.

Hello,

Is the folder named "reward" supposed to be uploaded or just the admin and includes?

Thx