I have chosen from the configuration - reward points - Reward Point Status Track - select mode - advanced - all my order statuses (i have more than 50) as pending except one that i call order completed - however all the tests i did and even if i change the order status to order completed - the customer does not earn the points they are still pending all the time - BUT i have noticed that sometimes some customers (the percentage is 1 to 20) earn the points after i change the status of their order to completed!
I even updated the reward points to the latest version for my 1.3.9h zen cart this did not fix the problem.
I have also tried all order statuses as ignored except the default one that puts point to pending and the order completed status that is supposed to put the points to earned.
I can manually change the points from pending to earned for my customers.
I have a test server with this addon installed if someone can help me then please tell me so and i will give all the access details!
Last edited by teochris; 24 Mar 2013 at 12:18 PM.
Between the update.sql and the new.sql the only difference is the following line
UPDATE `configuration_group` SET `sort_order` = LAST_INSERT_ID() WHERE `configuration_group_id` = LAST_INSERT_ID();
what exactly this line mean - do i have to run the update patch or i may run only the above line if needed?
I just found what is happening - I have super orders addon installed and if i change the status of the order from the super_orders.php?page=1&oID=3911&action=edit page then the reward points just ignore it! But if i change the order status from edit_orders.php?page=1&oID=3911&action=edit then everything works properly!
Can someone tell me what i have to add or change for the super_orders.php to work properly?
Last edited by teochris; 24 Mar 2013 at 12:38 PM.
[24-Mar-2013 20:49:50] PHP Warning: Invalid argument supplied for foreach() in /home/......./public_html/includes/functions/extra_functions/reward_points_functions.php on line 314
I keep seeing errors like this in the cache folder whenever a customers completes an order
I have just installed the latest version of reward points (i had 1.32a version and i upgraded to 1.33a for zen cart 1.3.9h) I just copied the new files over the old ones but i did not run any update sql patch - However i used to see this error and with the previous version)
We recently upgraded to zen-cart 1.51 (new install with ported database from old site).
Reward points is installed but doesn't seem to be working properly. Points are not getting moved from pending to earned, plus a lot of customers seem to have 200 pending points for no particular reason. No points are awarded for new accounts.
I am seeing this error in the logs which seems to be related. The products_id field is not formatted correctly.
Any ideas as to the cause?
ChrisPHP Code:
[25-Mar-2013 12:21:19 Europe/London] PHP Fatal error: 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 '1215"''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.pro' at line 3 :: SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute
FROM reward_master prp, products p, products_to_categories p2c
WHERE p.products_id='1215"''
AND p2c.products_id='1215"''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1')
OR (prp.scope='0'))
ORDER BY prp.scope DESC LIMIT 1; in <site>/includes/classes/db/mysql/query_factory.php on line 120
In my previous posts i stated that i have a problem with reward points and super orders, and that i am also facing a problem with /home/......./public_html/includes/functions/extra_functions/reward_points_functions.php on line 314 which appears in my cache folder.
If a programmer can help me with these problems then i am willing to pay him or donate him - whatever!
We are also using rewards points and super orders. Maybe one of them will have to go.
I don't use Super Orders but you can try what curt_l did and see if that works for you.
http://www.zen-cart.com/showthread.p...65#post1143265
Is your site Upgraded to the current version 1.5.4 Yet?
zencart-upgrades-website-installation
Hi,
I installed this plugin and placed all files in the corresponding folders on my server... However, I have a few issues....
I don't have the following on my admin page
admin-catalog-reward points is not in my menu
admin-configuration-reward points is not in my menu
admin-customer-group reward redeem is not in my list
I also need to know where to change the point values, it seems it is automatically giving 1 point per dollar. I also need to know how i can go in and add points to existing customers who earned them before the module was installed.
Also this is a minor change but I want to change the colors of the font for the reward listings. And I want to change the name to dream dollars. Any help with these issues would be greatly appreciated. TY TY TY -victoria
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.
Bookmarks