Reward Points Module for ZC v13x

[CandleMan]

Quote:
Originally Posted by CandleMan View Post
If they can't do this for you, is there a way of changing the ID (Or even adding in the order number) to show decending ie the largest number first? This would then let you add manually for the most recent orders you have taken.
The code would be within the customer_reward_points.php file would it not?

You are correct with this- However there are a number of elements within this mod which also require v4.2 or greater. To make the whole mod pre v4.2 compliant would also mean a greater number of MySQL calls and the resource impact that would entail.

I understand this but for those who need to enter manually, surely it's a small change in the code of the php file to list the ID in descending order rather than ascending. (I'd have a go myself but do not understand PHP code at all....honest)

[hem]

No I haven't changed anything. Loaded straight in without any changes. I actually unzipped the files again and reloaded just in case. Sideboxes won't show up and eliminates all the ones underneath it.

Just an additional thought in my testing of it -

Is it possible to add a Reward Points section into the user account files so they can log in and look to see what they have on hand in there when they go into My Account?

And the site for this particular issue is www.justmixandbake.com

Strange- I'm able to see all the sideboxes on that site.

And the Reward Points are shown in the Account details.

[hintimates]

Strange- I'm able to see all the sideboxes on that site.

And the Reward Points are shown in the Account details.

You can see them right now because I have the Rewards Points box turned off. Let me put it on and you can see what I mean. Everything below the newsletter box will disappear.

And Rewards Points are NOT showing in user account details. If logged in, click on My Account and there is no area listing anything about Reward Points.

[hintimates]

Further looking at things, sideboxes are disappearing if logged in to the account OR if not logged in, adding items to the shopping cart. That is what causes the disappearance of the side boxes below the newsletter box.

[hem]

You can see them right now because I have the Rewards Points box turned off. Let me put it on and you can see what I mean. Everything below the newsletter box will disappear.

And Rewards Points are NOT showing in user account details. If logged in, click on My Account and there is no area listing anything about Reward Points.

That would indicate that you haven't copied over all the files for the mod. One of the account files is missing that would display the reward points. I'd expect that's the same problem with the sidebox not working either.

[hintimates]

FOUND THE SIDEBOX ISSUE! Sometimes it just takes going back over it for the 10th or 20th time. User error! Sorry!

And I resolved the My Account issue as well. Thank you! Sometimes talking about it seems to make finding things easier.

[Adds]

Hi all,

Not sure if I have missed something but I have placed an test order on my site and I have 300 points but it does not give me the option to use any points for payment?

How do I set this up?

Thanks.

[hem]

Hi all,

Not sure if I have missed something but I have placed an test order on my site and I have 300 points but it does not give me the option to use any points for payment?

How do I set this up?

Thanks.

If you go into Admin->Customers->Reward Points are the points shown as 'Pending' or 'Earned'??? It could be that the status of the order has not changed from 'Processing' so the points have not been earned yet.

[hem]

Reward Point Diagnostic here:

http://omnicia.com/rpd.zip

To use, copy both files to the root folder of your store and then go to www.your-website-address.com/rpd.php

This will highlight in red any missing files, tables and records.

[redeemer641]

I am facing an error.
The points go in pending state, but am not able to move them to earned.

Other things:
1. The Reward Point Diagnostic that "hem" gave, works perfectly. (no errors)
2. Admin > Configuration > Reward Points shows nothing...empty table
3. Admin > Customers > Reward Points, when I press "edit", it gives error 1064 as below:
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 'REWARD_POINTS_MAX_TRANSACTIONS' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id=3 AND status=0 ORDER BY date DESC LIMIT REWARD_POINTS_MAX_TRANSACTIONS;]
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.

Can someone help ?