Reward Points Module for ZC v13x

[cooledit]

http://www.zen-cart.com/index.php?ma...oducts_id=1002

Hello There
I have just installed the reward point full suite. but theres a question. how i can get the customer upgrade automaticlly to the higher pricing group level? i have tested three times. still did not find out the right solution.

Please give me some advice. thanks

[teochris]

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!

[teochris]

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?

[teochris]

[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)

[devus]

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?

[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 

Chris

[teochris]

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!

[devus]

We are also using rewards points and super orders. Maybe one of them will have to go.

[countrycharm]

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

[Beyond Dreams]

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

[DivaVocals]

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

Did you run the install SQL file?? If not, doing so will probably address most of the issues/questions you have..