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!
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!
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?
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
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!
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 :)