Reward Points Module for ZC v13x

hem:

The tags can be found in includes\languages\english\extra_definitions\YOUR_CUSTOM_FOLDER\reward_points.php

The stylesheet (for changing bold and stuff) is in includes\templates\custom\css\stylesheet_reward.css

This does not work. I have played around endlessly with the style sheet and can get all of the text unbolded except for this main text that displays before customers log in.

Something else is over riding the style sheet because I deleted the style sheet and the text in the main box and under the products are still bold.

The only thing that happened when I deleted the style sheet was that I lost the colors of the text and everything was black.

Thank You Hem

When I read you solutions I knew how to fix it. Thanks Again.

I have 1.22 installed with ZC1.3.8a. I noticed that I can't apply reward points to one of my products, a digital download. All of my other products are tangible goods, and I can successfully apply reward points to them. It's just the one product, which happens to be a digital download, that I can't apply reward points to.

I've attempted to adjust every setting I can imagine, but no success. Is there another setting I'm not aware of? Do I need to change the status of any of the attributes associated with digital downloads?

CobraPlant:

I have 1.22 installed with ZC1.3.8a. I noticed that I can't apply reward points to one of my products, a digital download. All of my other products are tangible goods, and I can successfully apply reward points to them. It's just the one product, which happens to be a digital download, that I can't apply reward points to.

I've attempted to adjust every setting I can imagine, but no success. Is there another setting I'm not aware of? Do I need to change the status of any of the attributes associated with digital downloads?

I have never tested the mod with digital downloads. I will give it a look.

Hey Andrew, just as an FYI, apart from a few virtual products my entire store is digital downloads and Reward Points works successfully on all of them

@CobraPlant, how exactly do you have your download product set up?

christon26:

Hey Andrew, just as an FYI, apart from a few virtual products my entire store is digital downloads and Reward Points works successfully on all of them

@CobraPlant, how exactly do you have your download product set up?

What's interesting is that I did a test purchase with the download last night, and points showed up in my cart and all the way through the checkout process. The only place that seems to be the problem is on the product page where it doesn't show the reward points. I have my settings set to not show the reward points if the points are zero, but the download is set for a ratio of 1, I naturally assumed that the reward points malfunctioned when the product page wasn't showing any. I suppose there's a simple work around by adding the reward points to my product description, but it makes it difficult to find glitches when I have other products set to zero points and need to remain at zero.

So the main issue now is that on the product page it's not indicating that there are reward points associated with it, but the points show up when you add the download to your shopping cart. And it seems to be with only this product. I have other products (non-downloads) with reward points, and the points are showing up normally on the product page.

Here's the link to the page:
http://cobraplant.com/index.php?main_page=document_product_info&cPath=1&products_id=121

Product Settings:
Product is Virtual NO
Always Free Shipping NO
Product Quantity Box NO

Attribute Settings:
Display Only NO
Attribute/Product Free YES
Default Attribute YES
Apply Discounts YES
Include Base Price YES
Text NO

Thanks for looking into this!

CobraPlant:

What's interesting is that I did a test purchase with the download last night, and points showed up in my cart and all the way through the checkout process. The only place that seems to be the problem is on the product page where it doesn't show the reward points. I have my settings set to not show the reward points if the points are zero, but the download is set for a ratio of 1, I naturally assumed that the reward points malfunctioned when the product page wasn't showing any. I suppose there's a simple work around by adding the reward points to my product description, but it makes it difficult to find glitches when I have other products set to zero points and need to remain at zero.

So the main issue now is that on the product page it's not indicating that there are reward points associated with it, but the points show up when you add the download to your shopping cart. And it seems to be with only this product. I have other products (non-downloads) with reward points, and the points are showing up normally on the product page.

Here's the link to the page:
http://cobraplant.com/index.php?main_page=document_product_info&cPath=1&products_id=121

Product Settings:
Product is Virtual NO
Always Free Shipping NO
Product Quantity Box NO

Attribute Settings:
Display Only NO
Attribute/Product Free YES
Default Attribute YES
Apply Discounts YES
Include Base Price YES
Text NO

Thanks for looking into this!

That would be because document_product_info.php has not been updated to display the Reward Points. Unzip the attached file to \includes\templates\YOUR CUSTOM FOLDER\templates and let me know if it works.

hem:

That would be because document_product_info.php has not been updated to display the Reward Points. Unzip the attached file to \includes\templates\YOUR CUSTOM FOLDER\templates and let me know if it works.

Yes, that worked! Thanks! I thought I uploaded that file when I upgraded my site.

CobraPlant:

Yes, that worked! Thanks! I thought I uploaded that file when I upgraded my site.

I doubt it as I've only just created it...

Hi Andrew

I'm still not able to work with the mod...

Sorry, english is not my main language... and I really don't know what to do...

in your last reply, you refer me to a zip, but I install the mod with that zip... and is not work...

after all, I notice that I can asign my customers the points manually... ok... no problem... but... when I go to:

Customers/Reward Points

I only can see my first 40 customers... I can't go to the next page, and if I make a search I get an 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 status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM zen_reward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
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.

ok, you said run the update.sql
I try... and get this message:

23 statements processed.

ERROR: Cannot create table reward_master because it already exists

ERROR: Cannot create table reward_master because it already exists

ERROR: Cannot create table reward_customer_points because it already exists

ERROR: Cannot create table reward_status_track because it already exists

ERROR: Cannot create table reward_status_track because it already exists

ERROR: Cannot create table reward_status_track because it already exists

ERROR: Cannot create table reward_status_track because it already exists

Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

and the problem with the search and try to edit it... continue...
can you please help me?

I really want this mod working properly...

thanks in advance...

I've installed this mod and it seems to work okay when I test it. If I make a dummy purchase the points appear as pending and then change to earned when I mark the product as delivered.

When a real customer makes a purchase however, no points are credited to them and I have to do this manually.

Very puzzling, any idea why this is happening please?

The way my reward program works is that the points are pending until I actually make a change in the status of the order. ie. Shipped etc. Then the program deposits the points into the cutomer earned status.

Also, there is a setting in the Admin>Reward Points>

Reward Point Sunrise Period - Set to 1

If you set this to 1, all pending points are automatically deposited into customer account after 1 day. I find this helpful especially if I do not ship for 2 or 3 days.

Hope this helps.

The problem is that the reward points don't even appear as 'pending' when a customer makes a purchase. Eveything else seems okay - the points are noted on the order confirmation but they just don't appear in admin.

I've realised that the problem occurs with the Nochex and Paypal modules. If I make a test purchase using a cheque/check option, the points do appear, but not with the other two options.

Hi,

I posted this question earlier in a new thread of my own but I got no replies because I think I was supposed to put it in the support thread, so I'm posting it in this support thread now.

Please help.

I added the reward points full suite module and I'm getting an error message when I go to the reward points configuration.

This is the message:

Warning: call_user_func(UseRewardPointStateFunction) [function.call-user-func]: First argument is expected to be a valid callback in /home/content/t/h/3/th3who/html/shop/myadmin/includes/functions/general.php on line 1544

Can somebody please help me figure out a solution to this error. I'm sure it's something simple but I am new to this stuff and have no idea what to do.

Thanks in advance for your help,

Jordn

HI,

I installed the latest reward points module but i seem to get this problem on the customers/ reward points section:

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 'A%' 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 fields.

no customers appear in this section.

my site is running Database: MySQL 5.0.67-community-log
PHP Version: 5.2.6 (Zend: 2.2.0)

I run the update.sql but no luck.
any suggestions?

thanks

Hi,

I installed the Reward Points module, and when I turn it on in the Order Total configuration, I get the following error:

1062 Duplicate entry 'SEO_URLS_VERSION' for key 2
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Seo Url's Installed Version', 'SEO_URLS_VERSION', '3.0.0-beta1', '', '60', '0', now())]

I do have the SEO URLS installed, so I'm guessing it's a conflict with that. I've gotten a similar error with another module, which I just decided not to use, but I cannot recall what that was.

Also, when I turn on my Sideboxes (right side), they don't display, AND nothing below them displays either...

Anyone know how to cure these errors, so that I can use this module?

Thanks.

rcrosier:

Hi,

I installed the Reward Points module, and when I turn it on in the Order Total configuration, I get the following error:

1062 Duplicate entry 'SEO_URLS_VERSION' for key 2
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Seo Url's Installed Version', 'SEO_URLS_VERSION', '3.0.0-beta1', '', '60', '0', now())]

I do have the SEO URLS installed, so I'm guessing it's a conflict with that. I've gotten a similar error with another module, which I just decided not to use, but I cannot recall what that was.

Also, when I turn on my Sideboxes (right side), they don't display, AND nothing below them displays either...

Anyone know how to cure these errors, so that I can use this module?

Thanks.

That's not the Reward Points Mod, that's a problem with the SEO mod. 'SEO_URLS_VERSION' is not a RP field,

hem:

That's not the Reward Points Mod, that's a problem with the SEO mod. 'SEO_URLS_VERSION' is not a RP field,

Thanks, I'm aware that "SEO_URLS..." is not a RP field, but looking to see if anyone has solved this, or knows what's causing it.

I have many add-ons installed with SEO URLs, but this is one of the few that does not work with it. I was hoping to find someone who knew how to fix it.

Since my post, I have installed the "Store Credit and Rewards" module, which seems to work fine with the Ultimate SEO URL's.

rcrosier:

Thanks, I'm aware that "SEO_URLS..." is not a RP field, but looking to see if anyone has solved this, or knows what's causing it.

I have many add-ons installed with SEO URLs, but this is one of the few that does not work with it. I was hoping to find someone who knew how to fix it.

Since my post, I have installed the "Store Credit and Rewards" module, which seems to work fine with the Ultimate SEO URL's.

There is nothing in RP which conflicts with Ultimate SEO- Have you tried asking in that thread?