Reward Points Module for ZC v13x

If you're struggling with edit orders corrupting order reward points, I've made some changes to my edit_orders.php and attached it for download.

Be aware that I have removed the add comment/notify customer section from my edit orders and made some other small style changes so don't just overwrite your current one with this new one!
If you just want to apply my changes to your version, scan the source for ot_reward_points_display and you'll see what I've done.

The change I have made also allows you to manually amend the reward points stored against the order.
Changing the reward points here does not effect the number of points the customer has earned. It only effects the number stored against the order in the order_totals table.
You'll still have to manually change the rewards the customer has earned if that's what you want to do.

Oops! It seems I've been a little hasty :blush:
I forgot to deal with redeemed reward points.....it's fixed in this version......

I've just debugged a site that was having problems with the edit_orders mod. It appears that edit_orders does not update the last_modified field in the order table when changes are made to an order- This is the trigger that my mod uses to see if points move from pending to awarded. I'll have a chat with the developer and see if we can get this sorted.

I have this mod installed, and have the New Account Rewards Points set to award 100 points to pending. So according to the instructions, those 100 points should be released after the customer has placed their first order, correct? I have tested it, and when I update the order status to delivered, the points from that specific order are released, but the 100 points that were put in pending for the new account just stay in pending. Shouldn't those be automatically released once the first order is set to delivered?

Thanks!

Danielle:

I have this mod installed, and have the New Account Rewards Points set to award 100 points to pending. So according to the instructions, those 100 points should be released after the customer has placed their first order, correct? I have tested it, and when I update the order status to delivered, the points from that specific order are released, but the 100 points that were put in pending for the new account just stay in pending. Shouldn't those be automatically released once the first order is set to delivered?

Thanks!

Are you using Edit Orders by any chance?

No, but I am using Super Orders. Would that make a difference?

Danielle:

No, but I am using Super Orders. Would that make a difference?

Possibly- I think Super Orders uses some of the Edit Order codebase (I might be wrong). I've found an issue with Edit Orders that makes it incompatible with the RP mod. I'm currently working on a new version of Edit Orders to solve this.

hem:

Possibly- I think Super Orders uses some of the Edit Order codebase (I might be wrong). I've found an issue with Edit Orders that makes it incompatible with the RP mod. I'm currently working on a new version of Edit Orders to solve this.

any news on the edit orders front?

Kezza:

any news on the edit orders front?

Things have got very busy over the last couple of weeks. Hopefully I'll get to it at the weekend.

Hi how can I see the log of all points transactions for each customer?

Is there a table or something to set my rewards?

I want to allow 1 point per ever dollar spent
I want each point to be worth ten cents ($.10)

Where do I set this up? Or what settings to I need to find to set them up.

As LisaVB. I too want to reward point per dollar. 1dollar=1point. I want to generate a gift card for 500points. Once gift card is generated, points should be deducted and customer has to come in person to store to collect the gift. He/She brings his GiftCardId or printed gift card. So that admin can logs into admin panel and checks the gift card Id and give customer a gift.:frusty:

PHP People - I need some help. I have Reward Points 140 installed. On the checkout_payment page, it displays in a DIV:

Reward Points-
You may click to redeem any collected Reward Points. Your redeemed points will be applied to the total and reflected in your cart after you click continue.

Current Reward Points:582 points earned ($582.00)

Value of Redeemed Reward Points:$194.00 (194)
Redeem Reward Points:

I need to remove the display of the value of the points ($582.00) in the top line, and the "Value of Redeemed Reward Points:$194.00 " line completely as well as the "Redeem Reward Points:" line with either the checkbox or the field completely.

All redeeming of points will be done a different way. I don't care about the math of points valuing, as long as it is hidden. I need to either remove ALL the lines except Current Reward Points (without the value) or remove this DIV entirely from the Checkout_payment page. When I try to comment out parts of ot_reward_points.php, it crashes the checkout process.

Any guidance would be appreciated.

LisaVB:

Is there a table or something to set my rewards?

I want to allow 1 point per ever dollar spent
I want each point to be worth ten cents ($.10)

Where do I set this up? Or what settings to I need to find to set them up.

Go to your Zen Cart Admin then
Catalog menu
Reward Points
and set the "Global Reward Point Ratio" to 10.0000

That should give you 10% of every dollar spent as Reward Points and 1 point = 1 cent. So for every dollar spent, the customer should get 10 Reward Points / 10 cents in value.

This should give the same same value you want, and is the way I use it.

If you really want each point to equal 10c then someone else may be able to help.

Paul

sai1983:

I want to generate a gift card for 500points...

Not sure if this mod can do that.

Personally I would probably look at using Zen Cart's own Gift Voucher mod that comes with the cart.

I need all Reward Points to be posted automatically as Earned, without having order status changes, etc.
We will redeem the points off-line in a different manner. Using the Advanced/Order Status in the Admin doesn't change anything. All points still go to Pending and I must manually change them to Earned in Admin/Customers/Reward Points.

I have messed with some of the functions, but only succeeded in crashing it. Is there a place where a few lines of code will put all points in the cart automatically to Earned?

any word on the edit orders working with rewards points?

First of all... MERRY CHRISTMAS EVERYONE!! :cheers:
this is the first time I have posted. I think I have the right forum... I apologise if it is not.
I am using Reward Point full suite 1.33a
:frusty: :wacko: :frusty: :wacko:
All database tables have prefix zen_<tablename>
I have a number of other mods installed - but this is the first one to generated the level of issues I have encountered.
Modifications I made to the Original install readme instructions:

1. modified CUSTOM folder name to "tvzen_jellyfish" in line with the template I am using.
2. Changed table creation and table referances in new.sql to have "zen_" prefix "zen_configuration", "zen_configuration_group" and the three reward tables, master, customer points & status track eg "zen_reward_master"
3. Modified 2 files "reward_points_filenames.php" located in "zc_admin\includes\extra_datafiles" and "includes\extra_datafiles" - Lines 6-9 added "zen_" to the table names after "DB_PREFIX ." eg "define('TABLE_REWARD_MASTER', DB_PREFIX . 'zen_reward_master');"
   Outcome:

• Configuration -> Reward Points works!
• Customers -> Reward Points throws an error
  

  1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_customer_points'
  in:
  [UPDATE zen_zen.reward_customer_points cp, zen_zen.reward_status_track rp SET cp.pending_points=cp.pending_points-IFNULL((SELECT SUM(rp.reward_points) FROM zen_zen.reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status='0' AND rp.dateIf 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.
  

• Customers -> Group Reward Redeem throws an error
  

  1142 SELECT command denied to user 'admin_zc1'@'localhost' for table 'reward_master'
  in:
  [SELECT * FROM zen_zen.reward_master WHERE scope='0' AND scope_id='0';]
  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.
  

  
  The Group reward redeem error occurs within the ZEN Cart Admin construct, while the Reward Point error is a completely formless whitescreen within the browser.
  The thing I find strange about the errors is the reference to zen_zen.reward_master.
  The database name is not zen_zen, it is similar to database_zc and I don't know where it is getting this from. Plus... it is not referring to to the prefix => zen_reward_master... I think this may be from DB_PREFIX (but I don't know where this is defined.)
  If anyone can offer some words of assistance... I would be most apprecaitive!!:hug::hug:

Oh my!!
I found it!!
Developers ToolKit showed me where DB_PREFIX was defined!! yay!
Then I realised that the files "reward_points_filenames.php" should not have been edited at all!!
My frustration is over! :) yay!

Kezza:

any word on the edit orders working with rewards points?

It works with the latest version but I don't know if that has been released yet.