Reward Points Module for ZC v13x

[curt_l]

I also have Super Orders and Edit Orders installed, and wanted the Reward Points to transfer from Pending to Earned when the order is paid (Complete). I don't use batch updating, so my workaround is just when the order is updated in Super Orders, check the status and run the appropriate Reward Points function.

In super_order.php, under case 'update_order': , after this:

// OK, we have our Customer Notified Status Number, now update the Order Status History Table       
          update_status($oID, $status, $customer_notified, $comments);
// Is the Customer Notified Status Number a 1, then send the customer and E-Mail with the status update.          
          if ($customer_notified == '1') {
            email_latest_status($oID);
          }

I added this:

if(($check_status->fields['orders_status'] < 5 && $status == 5)){
          //if previous status was Pending, Shipped, or Returned AND new status is Complete/Paid
          TransferCustomerPointsFromPending($oID);
          $messageStack->add_session('Pending points transferred for Order ' . $oID , 'success');
}
if(($check_status->fields['orders_status'] == 5 && $status < 5)){
	  //if previous status was Complete Paid AND new status is Pending, Shipped, or Returned
	  //take back the points if somehow they un-pay 
	  TransferCustomerPointsToPending($oID);
	  $messageStack->add_session('Earned points transferred back to Pending for Order ' . $oID , 'success');
}

[curt_l]

Does anyone have a report already written to show Points Redeemed per customer over time? (Just looking for a way to track how much $ we're "giving away".)

Thanks all in advance!

[Coins2012]

Could someone try to answer the question below please, I already posted it few weeks ago with no response.



I would appreciate if someone could clarify this feature:

Delete Old Reward Transactions Period
Set the age (in days) to keep the reward point transactions. Outstanding reward points pending after this period will be lost. Set to 0 to keep all transactions.

Is this mean that any points that are earned will not be deleted no matter what? I setup this module using Sunrise Period of 1 so pending points become earned the next day but I like these earned points to be deleted after 30 days but looks like the system doesn't delete earned points?

[Ajeh]

v1.5 version:
http://www.zen-cart.com/downloads.php?do=file&id=704

Here is a fun scenario that makes no sense ...

Below are all of the details of how to reproduce this (I do not believe anything is missing) ...


REWARDS BUG

PROBLEM:
It is not calculating the rewards correctly when Redeeming (spending) Rewards are done at the same time Buying New Products to earn more rewards.


NOTE: Customer to NOT in a Group Pricing group

SETUP Customer:
Either set balance for customer, or buy Products and ship to get total
Balance:
PENDING: 0 $0.00
EARNED: 13000 $130.00


Make New Order $50.00 5000
Use: 3000 ($30.00 rewards)



Checkout Confirmation shows (incorrectly or misleading):
Sub-Total: $50.00
Sales Tax: $0.00
Store Pickup (Walk In): $0.00
Value of Redeemed Reward Points: -$30.00
Total: $20.00
Reward Points earned: 2000



Results Balance:
PENDING: 2000 $20.00
EARNED: 10000 $100.00

*Should be:
Balance:
PENDING: 5000 $50.00 ($50.00 or 5000 points Purchased in checkout)
EARNED: 10000 $100.00 ($30.00 or 3000 points spent in checkout)


SHIP TO TRANSFER PENDING TO EARNED:
Results Balance:
PENDING: 0 $0.00
EARNED: 12000 $120.00


*Should be:
PENDING: 0 $0.00
EARNED: 15000 $150.00

EXPECTED CALCULATIONS FROM ...
START BALANCE: 13000 $130.00
SPENT REWARDS: 3000 $30.00
NEW PURCHASE: 5000 $50.00
NEW TOTAL: 15000 $150.00



REWARDS CONFIGURATION SETTINGS DETAILS:

Modules > ot_reward_points
--------------------------
Redeem method = manual

Modules > ot_reward_points_display = on
---------------------------------------

Config > Reward Point Configuration
-----------------------------------
Reward Point Mode 0 Reward Points are fixed to the product prices
Reward Point Sidebox Display 0 Sidebox on

Reward Point Status Track Advanced Mode
Pend: []
Earn: [3 status set to trigger pending to earned]

Reward Point Sunrise Period 0 No Sunrise period
Reward Point Redeem Minimum 0 No Min
Reward Point Redeem Maximum 0 No Max
Reward Point Rounding 0.0
Max Transactions to Display in Customer Admin 25
Delete Old Reward Transactions Period 90 Pending expire after 90 days
Adjust Reward Points for Sales/Specials 1 Use price less Discount n Specials.
Allow Reward Points on Free Products 0 Free products give 0 Reward Points.
Allow Redeem of Reward Points on
Order Total or Subtotal 1 Against the full order.
Set Minimum Order Value to
Set Minimum Order Value to Redeem Points Against 0 No Min
Limit Maximum Customers on Listings 2000
Display Products Reward Points When Zero 1 Always Display
Set New Account Reward Points No points awarded for new accounts

Advanced Reward Point Calculation Rules Advanced Rules Enabled
ot_coupon = Subtract
ot_group_pricing = Subtract
ot_gv = Add


Catalog > Reward Points
-----------------------
Set Global Reward Point Ratio = 100.00


Customers > Group Reward Redeem
-------------------------------
Enter Global Points Ratio = .01


Customers > Reward Points
-------------------------
Nothing special here, all test users not in a group



So is anyone having this issue of trying to use Earned Rewards and Purchase New Order where New Reward Points should be earned at the same time and getting incorrect results, or ... does anyone see where there is some forgotten or missing setting that is resulting in this error?

[amcnaughton]

I'm trying to setup a points ONLY store (no cash, credit card, etc). The user would earn points from an external system, that would then be added to the Zencart points store programatically.

The user would go shopping in the Zencart store and can ONLY use points to purchase items. Purchasing items should not earn the user any points (as they are earned via an external system).

Can I setup/tweak this component to make it work like this?

Also, after installing the component I do not see the following:

Admin->Catalog->Reward Points
Admin->Configuration->Reward Points
Admin->Customer->Group Reward Redeem
Admin->Customer->Reward Points

What did I do wrong?

Thanks for your help!

[curt_l]

Ajeh, mine is calculating correctly.
The only differences I have are:
$1 spent = 1 point earned
1 point redeemed = $0.05 off

New points are correctly calculated from the subtotal (after redeemed points are subtracted and before tax and shipping is added).

One thing i noticed when I installed, for some reason I had to overwrite the admin files in Filezilla after my initial tests weren't working. After the overwrite it worked fine. Never happened before on other mods, but still likely my error :)