Reward Points Module for ZC v13x

leilanddale:

Any feedback on this?

do you have edit orders or super orders mod installed?

Kezza:

do you have edit orders or super orders mod installed?

Now I do yes. I installed it during the past week or so. Before that, no.

leilanddale:

Now I do yes. I installed it during the past week or so. Before that, no.

http://www.zen-cart.com/forum/showpost.php?p=980187&postcount=153

http://www.zen-cart.com/forum/showpost.php?p=956471&postcount=1683

Kezza:

http://www.zen-cart.com/forum/showpost.php?p=980187&postcount=153

http://www.zen-cart.com/forum/showpost.php?p=956471&postcount=1683

Thanks!

I already have the latest of both installed. We've never edited any orders as both these modules were only installed over the last 7 days or so.

So ultimately, even before I installed the two addons, it never auto updated the points.

leilanddale:

So ultimately, even before I installed the two addons, it never auto updated the points.

I'm not seeing it happen either. But I wanted the points set to earned from the start since I want it to be totally automatic. So I guess setting the order status to paid with a.net payment is the first status and there's no trigger because there's no change?

So how do you set them to earned at first?

walkerhxg:

Hi hem,

Thank you sooooo much!

BUT

I have done what you said again and again. But it still doesn't work. :frusty:

( zen-cart1.3.8+MySQL 4.0.27-log+PHP4.4.7 )

I installed the 'new.sql' and got this:

17 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
Note: 10 statements ignored. See "upgrade_exceptions" table for additional details.

I clicked "Layout Box Controller" and got :

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 'SELECT SUM(reward_points) FROM reward_status_track ph WHERE p
in:
[UPDATE reward_customer_points rc SET pending_points=pending_points-IFNULL((SELECT SUM(reward_points) FROM reward_status_track ph WHERE ph.customers_id=rc.customers_id AND ph.status=0 AND ph.orders_id NOT IN (SELECT orders_id FROM orders)),0);]
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.

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

akai0231:

Hello Hem,
I have the same problem.
Any suggestion to solve it?

TX in advanced.

From the readme.txt:

!!!WARNING!!! YOU NEED AT LEAST MySQL VERSION 4.2.0 TO RUN THIS MOD

I have read the FAQ through and am having a problem setting the redeem value for each point. I know I can go to the "group reward redeem" and create a group and set the value however it seems like every new customer will default at .01 and I am going to have to manually go in and change it.

I want it to that when anyone signs up or makes a purchase, it automatically calculates at .05 per reward point. How can I do this?

I have read through this posting and cannot seem to find it other than making a group after the fact.

Thank you.
polishpotterystore.com/shopping

I'm sorry, but I have that part down, I have already set how many points various products/categories are worth. My issue with with how much each point is redeemed for. It appears as if you can change it but only after the fact. I want to make it a default for the points to be worth 5%, or .05 each, not .01.

Hi All

Doese anyone konw if the PayPal IPN problem has been fixed?

Thanks
Davis

I still have this unanswered question.....

gonewild:

Is there a known conflict between Rewards Points and Gift Certificates?

When a customer uses a Gift Certificate to pay a part of the total and then applies Reward Points for the balance the reward points are entered as a wrong number

example...
total due is $55.17
pay with Gift Cert $51.00
pay with Reward Points $4.17

The balance should be zero but this is what happens on step 3 of checkout....

Sub-Total: $42.00
FedEx Ground (FedEx Ground® ):$9.70
CA TAX 8.25%: $3.47

Gift Certificates: -$51.00
Value of Redeemed Reward Points: -$-46.83

Total: $51.00

Reward Points earned: 48

..
When the customer realized this was not correct he went ahead and paid the wrong amount with his credit card to complete the purchase. BUT the credit card was not actually charged and the order came through as if it were paid.

How can I fix this? I'm using zc138a and rp140a
Thanks

i got it installed and everything but when i go to the admin > tools > lay out boxes controls. theirs no option for rewards program. but i do have options in the module and in the config part so i set it to display when logged in and it doesn't any ideas.
thanks

one more thing i changed the name of my admin folder would that have anything to do with it

i need help with uninstalling the rewards system.
to see the error please go to my test site
test/themeltingpotonline.net/shop and put something in your shopping cart, proceed to the checkout. on the second page (payment information) you will see the yellow warning on top of the page that 2 files are missing... i deleted the sql table related to the mod and don't have the files for the mod in the test site. why is it still warning?

here is the error i need to solve...
i don't have any rewards files in zencart (i don't want to anymore) and i deleted all tables that had rewards in it. are there still tables that hold data about the mod that need to be deleted?:frusty:

http://test.themeltingpotonline.net/pix/errormessage.jpg

I have a fresh install of Zen Cart.
I have installed this module BUT it does not display the reward points on the product listing/description.
Can you please tell me why this is happening?
Thank-you in advance.
Kind Regards Casey

I placed my previous product_info_display.php file in the current store and now it is working.
:unsure:

Casey

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

stevefriedman71:

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

Thanks for your reply.
I can't work out why this module is not working.
It will not even work in a classic custom fresh install.
I make sure I have the files installed etc.

I have checked the files against winmerge and can see where changes are etc but still nothing seems to be working.

PLEASE HELP! :frusty:

Kind Regards Casey

stevefriedman71:

You should check if the file is the same before you use the php from an older cart into a newer one. Use Winmerge to compare the original with the the file from your working (old) cart. Otherwise, you just may have "downgraded" that file. if the file number is still the same you can keep it this way with the old file just pasted in. but if the file has a higher numer you may use winmerge to make the changes and updates to the newer file.

The tpl_product_info_display.php file in the rewards points 1.33 package is missing the following code which displays the reward points on each on the product pages.

<!--bof Product Reward Points block -->
<h2 id="productRewardPoints" class="productRewardPoints">
<?php
/**
 * display the product reward points
 */
   include($template->get_template_dir('/tpl_product_reward_points.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_product_reward_points.php'); 
?>
</h2>
<!--eof Product Reward Points block -->

I got that from the older version (1.28)

I am also having a problem at the checkout and a few options in admins.

Firstly, when I click 'confirm the order', i would be expect to be taken to the payment processor to enter cc details (alertpay, paypal etc) but instead it hangs on 'Your order is being processed, please wait..' page. Thinking it might be a problem re-directing to alertpay etc I installed Check/Money order, but it was the same result.

In admin the following dont do anything either:

Configuration>Reward Points>Reward Point Status Track (clicked but no options to choose)
Configuration>Reward Points>Set New Account Reward Points (Clicked but no options to choose)
Configuration>Reward Points>Advanced Reward Point Calculation Rules (Clicked but no options to choose)

Anyway, think I will be moving back to the previous version (1.28) because I know that one works fine. There seems to be too many bugs in v1.33. Excellent module all the same.