Printable View
Hi again,
I know I can run SQL query as follows:
SELECT *
FROM `zen_orders_total`
WHERE `class` = 'ot_reward_points'
However this shows the total points claimed for all time with no dates. For now I am removing the orders (by order number) that fall outside of the date range manually. Surely there must be an easier way....
Again any suggestions???? :blink:
I just installed Rewards Points Suite v2.5 on out Zen Cart 1.51. It appears to work as advertised except all points are pending and I want them to be awarded immediately.
Sunrise = 0
Status Track I have set to Advanced Pend: [Void] Earn: [Registered, Processing, Delivered, Manual] all others ignore.
The store is for registrations so we seldom CHANGE a status. Default is Registered. Maybe that is the problem?
Is there a way to have points go directly to AWARDED status?
Here is my config:
Attachment 15812
SpaceMonkey -
Try something like this:
SELECT *
FROM zen_orders_total ot INNER JOIN zen_orders o on ot.orders_id = o.orders_id
WHERE `class` = 'ot_reward_points'
and date_purchased > '2015-01-31'
If you just want to filter this might be better:
Select * from zen_orders_total
Where orders_id in (SELECT o.orders_id
FROM zen_orders_total ot INNER JOIN zen_orders o on ot.orders_id = o.orders_id
WHERE `class` = 'ot_reward_points'
and date_purchased > '2015-01-31')
Since there is a time in the date_purchased field the > includes all orders on that date.
Hello,
I've been using this plug-in for a few years now and it has always worked fine, until this weekend when it seems to have stopped applying any points that people are trying to use. I've made no changes to the settings or the code, no recent changes to the site at all.
Any ideas as to why this might have happened?
Thanks
Running 1.5.4
www.madrobotminiatures.com
OK, so I made some time to check the ZC logs and there are a bunch of errors, all the same thing:
Invalid argument supplied for foreach() in /home/content/88/7710088/html/zencart/includes/functions/extra_functions/reward_points_functions.php on line 314
That's about as far as I can get, any thoughts as to what could have caused this?
Step 1 is to look in that file at that line of code. I copied that section below. Line 314 is the 'foreach' line. Have you installed any other Order Total Modules recently or adjusted the advanced calculation setting? Also, what version of ZEn-Cart and this module are you using?Quote:
Originally Posted by Joe Robot
function GetRewardPointAdvancedCalculateValue()
{
$value=0;
$module_list=GetRewardPointAdvancedCalculateTable();
foreach($module_list as $module)
if($module['action']=="Subtract")
$value-=GetOrderTotalValue($module['module']);
else
$value+=GetOrderTotalValue($module['module']);
return $value;
}
I came here to ask the same thing. I have hit the same issue.Quote:
Originally Posted by osulywan
Thanks for that, I installed the latest version and everything has been sorted out.
Thank you for your response :)
I'm trying to upgrade from 2.5b to 2.5e and after running Upgrade-to-2.5e.sql I have the following error:
INSERT INTO configuration
(configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');
#1062 - Duplicate entry 'SHOW_REWARD_POINTS_PRODUCT' for key 'unq_config_key_zen'
What should I do now ?
A quick fix is to run the following SQL in the admin SQL patch page whenever you want to transfer all of them:Quote:
Originally Posted by lindasdd
UPDATE reward_customer_points SET reward_points = (reward_points+pending_points),pending_points = 0;