Reward Points Module for ZC v13x

[Athens Collectibles]

I assume from your reply that you do see the screen as in the picture but all columns show 0. If you don't mind, could you give me your link and I'll make a test order to see how it works. I'm no expert in this mod but, having installed and configured it very recently, I may see something in the process.

[commdiver]

Correct. I see the table you showed, but all fields are marked with a "0".

I do not have it enabled now, so as not to have a bunch of customers ask what these reward points are. I have tried multiple test orders, but nothing. It would be nice if the module's author would stick around to answer questions...

[lauriesscraps]

I have had this module installed for a while, but just now noticed that I do not see the global points redeem screen anymore under the customers tool bar. Do you know why that is and what I might do to fix that? I ran the update SQL patch and that didn't do anything but add and extra Reward points tab under configuration.

I also do not see the reward points under customer anymore.

Thank you for your help.

[Athens Collectibles]

If you are talking about the "Set Global Reward Point ratio", this is set in Catalog > Reward Points (mine is 5.0). You set the Global Points Ratio in Customers > Group Reward Redeem (I have it 0.01). What my settings mean is that a customer gets 5 points for each base currency unit spent (€, £, $ or whatever is the store's base currency) and each point is worth 1/100 of the currency unit. So, a customer spending $100 will get 500 points redeemable for $5, effectively 5% of the order deducted when the points will be used in the future.

As there are many questions around and my answers are based on personal experience, I think it would be nice if Andrew came in and clarified some points. In my case, the only issue I have is that points are not calculated when the customer pays via PayPal and this is really serious as payments via PayPal (or with a credit card processed by PayPal) are the majority. Otherwise, the module works perfectly and is exactly what I needed.

[dmagic]

in customers_reward_points.php

have 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 'REWARD_POINTS_CUSTOMER_LIMIT' at line 1
in:
[select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_group_pricing, r.pending_points, r.reward_points, gp.group_name, rm.redeem_ratio from customers as c LEFT JOIN (reward_customer_points as r) ON (r.customers_id=c.customers_id) LEFT JOIN(group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) LEFT JOIN(reward_master as rm) ON ((c.customers_group_pricing!=0 AND rm.scope=3 AND rm.scope_id=c.customers_group_pricing) OR (c.customers_group_pricing=0 AND rm.scope=0 AND rm.scope_id=0)) WHERE c.customers_lastname LIKE 'P%' ORDER BY c.customers_lastname LIMIT REWARD_POINTS_CUSTOMER_LIMIT;]
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 

[Tiffany33]

Does anyone have Rewards module is working when someone using Google checkout to process the payment,

In this post http://www.zen-cart.com/forum/showth...gle#post624735 Kenwah says it s working.

However it seems that Google checkout avoids the whole zen cart, yet if you block Google checkout from only being visible when someone is signed in , it violates Google's TOS and they can suspend your checkout account.


if so please let me know how I go about doing it? Thanks so much.

[glamourdolleyes]

Is there any setting that makes this not applicable with discount codes?

I don't want customers to be able to use the rewards and a discount code at the same time, is this possible??

[Paul...the...first]

Trying to completely uninstall this mod and have a few issues.

I have removed everything that contained reward or points from my files and ran the uninstall SQL. But I can still see Reward Points listed 3 times in admin>configuration.

How do I get rid of them?

[damiantaylor]

I'm not sure if this is a bug or my misunderstanding of how group rewards work, but I have a customer I have added to a Discount Pricing Group in Admin->Customers->Customers because I want to give them a percentage discount on everything they buy.

Now, if I go to Admin->Customers->Reward Points and edit the customer reward points, say I add a few points to their earned, the Discount Pricing Group is set to --none-- so they no longer receive their percentage discounts when they buy.

When I initially went in to the reward points screen, I could see their Discount Pricing Group name under the heading Pricing Group.
When I click to edit the customer there is a dropdown Set new Pricing Group/Redeem Ratio that only contains 1 option, which is --none-- I'm guessing that's where the problem is?

Is this a small bug or a feature I'm missing the point of?

[carley]

hey everyone - sorry if this has already been covered, i couldn't find this info on the pages i read through.

I've installed everything that came with version 1.4 of the module (from Andrews website directly). I've even had my hosting company help me, as I'm not sure what I'm doing & am learning as i go - with a lot of hiccups along the way!

When I use the diagnostics tool, I no longer have any files or folders showing in red, but i have the following showing in red in the "MySQL Database Check" section:

customers_id- field missing in reward_customer_points!!!
reward_points- field missing in reward_customer_points!!!
pending_points- field missing in reward_customer_points!!!
rewards_id- field missing in reward_status_track!!!
customers_id- field missing in reward_status_track!!!
orders_id- field missing in reward_status_track!!!
date- field missing in reward_status_track!!!
reward_points- field missing in reward_status_track!!!
status- field missing in reward_status_track!!!
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in configuration!!!

I've done all the SQL patches I can find inside the module, and so has my hosting company. I'm almost begin told to give up on the module at this point, because it seems like this issue can't be fixed!
(extra info - version 1.33a, the one for DL through zen cart, it also had the same files showing in red when i installed it, which is why i tried this version)

Could anyone help me with this? tell me how to fix it? where to get the info to fix it?
I"m no programmer, I don't really knwo what i'm doing here, so I can't figure this out on my own. I"d really appreciate anyone helping me with this that can - i'd love to be able to fix this issue & use this mod!