Andrew, would it be easy to have a method/button on the clients list to "recheck pending" and markt hem awarded if the pending invoices have been moved to the proper category ?
Stick it in both sibeboxes and the Redeem Reward Order Total, bung a couple of <div> wrappers around each one and then anyone can disable them through the CSS.
Hi Andrew,
RP was working ok, then for some reason I am now having an issue.
I have put points onto a customers account, but in Admin they show up as Reward Points Earned, but as you can seem, they don't show up in the Value of Earned section.
Value of Pending: $0.00
Reward Points Earned: 1000
Value of Earned: $0.00
When I go through the checkout process, its shows as:
Current Reward Points:1000 points earned
Value of Redeemed Reward Points:$0.00
Redeem Reward Points: (is un checked)
If I tick the checkbox, then continue to process the order, the order total amount does not get adjusted,
Sub-Total: $175.50
AustPost (Parcel Post - 4 days Estimated Delivery Time)): $10.50
GST: $16.90
Value of Redeemed Reward Points: -$0.00
Total: $186.00
Reward Points earned: 160
Yet, when I go back into Admin, the points have been deducted ?????
Value of Pending: $0.00
Reward Points Earned: 160
Value of Earned: $0.00
I've re-installed the mod and re-tried and its the same
Hi all,
Whatever I do , it always gets :
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 'SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET `pending_points`=`pending_points`-IFNULL((SELECT SUM(`reward_points`) FROM reward_status_track ph WHERE ph.`customers_id`=rc.`customers_id` AND ph.`status`=0 AND ph.`orders_id` NOT IN (SELECT `orders_id` FROM orders)),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.
Please help me , thx in advance.
PS: How can I uninstall the sql completely?
Last edited by walkerhxg; 24 Apr 2008 at 10:49 AM.
Bookmarks