Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

I just installed and points are NOT being added to the customers account. My site is live on my server but not "live" to the public as of yet. I had 2 different testers try using both payment options and it didn't work :( My site is www.bellaornamenti.com Thank you

So doing some testing and found myself having to explain this to my client:

Quote:

---

Advanced mode: Set the order status items that will trigger a transfer of the reward points between pending and earned. Points are transfered when the status changes between the "Pending" and "Earned". Status items set to "Ignore" will have no effect if the Order Status changes to it.

---

Honestly this is truly as clear as mud.. I changed it on my client's shop to read:

Quote:

---

Advanced mode: Allows you to select the order status that will trigger a transfer of reward points from pending to earned. Points are transferred when the status changes between status items set to "Pending" and status items set to "Earned". Status items set to "Ignore" will have no effect on Order Status changes to it.

---

Wanted to share in case someone wants to make a similar change.. (or understand better what this means..:smile:)

There's no pagination on this page, and at the bottom of the page there's this text:
"No Customer (or invalid customer) selected. No action performed!"

Not sure what triggers that warning/error.. but there is no pagination or even sorting.. Yes I can search for the customer I am looking for, but some pagination and the ability to sort by first or last name would be a nice navigational touch..

Has anyone done this and if so would ya be willing to share what ya did..

Quote:

---

Originally Posted by samisoaps

I just installed and points are NOT being added to the customers account. My site is live on my server but not "live" to the public as of yet. I had 2 different testers try using both payment options and it didn't work :( My site is www.bellaornamenti.com Thank you

---

Points are added when the order status changes..

Quote:

---

Originally Posted by DivaVocals

Points are added when the order status changes..

---

I've changed the order status and it still didn't update the customers account. I've disabled it for now since I need to get a soft launch on the site this week.

Quote:

---

Originally Posted by samisoaps

I've changed the order status and it still didn't update the customers account. I've disabled it for now since I need to get a soft launch on the site this week.

---

You are going to need to post ALL of your settings to get the RIGHT answer..

Quote:

---

Originally Posted by DivaVocals

There's no pagination on this page, and at the bottom of the page there's this text:
"No Customer (or invalid customer) selected. No action performed!"

Not sure what triggers that warning/error.. but there is no pagination or even sorting.. Yes I can search for the customer I am looking for, but some pagination and the ability to sort by first or last name would be a nice navigational touch..

Has anyone done this and if so would ya be willing to share what ya did..

---

Diva put up a image of what you are seeing under customers/reward points. There should see a index across the top where you can search by A to Z

Quote:

---

Originally Posted by countrycharm

Diva put up a image of what you are seeing under customers/reward points. There should see a index across the top where you can search by A to Z

---

and I DO see that.. But clicking on any letter doesn't show the full results for the letter clicked.. For example I clicked "J" to look for Johnson, and the list is truncated before I can even get to that part of the J's.. This is is where pagination would help, and so would sorting since what I would expect to see is the names arranged first by last name, and then by first name.. It truly is NOT a good user experience, and I'm surprised no one's grumbled about this before..

Quote:

---

Originally Posted by DivaVocals

and I DO see that.. But clicking on any letter doesn't show the full results for the letter clicked.. For example I clicked "J" to look for Johnson, and the list is truncated before I can even get to that part of the J's.. This is is where pagination would help, and so would sorting since what I would expect to see is the names arranged first by last name, and then by first name.. It truly is NOT a good user experience, and I'm surprised no one's grumbled about this before..

---

I will look into getting this done. You have a good suggestion in how it should work, and I totally agree with you.
I will post back in a few days.

Hi,
Thank you for the great Mod.
I have just updated my ZC 1.3.9.h to 1.5.4 and the reward points are working fine. Except I have errors in my store/logs/ and wondered if anybody had any insight or have received similar errors?

[25-Feb-2015 16:45:03 America/New_York] 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 '''
AND ((prp.scope_id=p.products_id AND prp.scope='2')
OR (p.products_i' 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='-1''
AND p2c.products_id='-1''
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; ==> (as called by) /home/xx/xx/store/includes/functions/extra_functions/reward_points_functions.php on line 62 <== in /home/xx/xx/store/includes/classes/db/mysql/query_factory.php on line 155

Any help would be much appreciated.