Reward Points Module for ZC v13x

Ok so I have the rewards points showing but I have 2 shopping cart side boxes and then when I go to check out I get this error

1146 Table 'imperial_zc1.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 1]

https://www.imperialgiftsnwares.com.au

NullMind:

Andrew

Not sure if I missed it, but is there a way to prevent "gift certeficates" from counting toward points ? otherwise it's a double wammy

second, I am using the latest beta, do I need to re-run upgrade.sql ?

Just set the product ratio to 0.00

Hi

Mike_Dean a few posts back posted that he had a problem at
Admin->Customer->RewardPoints. I seem to have the same one.

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(rp.reward_points) FROM zen_reward_status_track rp WHERE cp.customers_' at line 1
in:
[UPDATE zen_reward_customer_points cp, zen_reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM zen_reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf 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.

Tried to a reload of the file suggested and no luck. Redownloaded again and still no luck.

Everything was fine up to the first test sale and then this appeared in Admin

Any further suggestions?

Zen - 1.3.7
MySQL - 4.1.22

Rasyr:

And.... Paypal - Customer did not get the points that he should have had added into the Pending list (let alone the Earned).

So, the problem with Paypal customers not being awarded their points is happening with me as well.

We use Paypal IPN.

I have same problem. Paypal didn't earn points.
Now i am not the only one have paypal problem, so it's not paypal pin issue.

imperialis:

Ok so I have the rewards points showing but I have 2 shopping cart side boxes and then when I go to check out I get this error

1146 Table 'imperial_zc1.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 1]

https://www.imperialgiftsnwares.com.au

Sorry mate, that's not one of my tables- Is it possible you have Numinix's Store Credit mod installed also???

Mike_Dean:

Thanks Andrew.

Took a while but I got there..
:smile:

Was I right about the reload???

hem:

Was I right about the reload???

Pretty Much..

I ended up reloading the whole thing, took a couple of goes but it got there, just seem to be having some other issues now.

The sidebox for RP is not showing, and nothng shows up during checkout even after I have added points to an account ?

Mike_Dean:

Pretty Much..

I ended up reloading the whole thing, took a couple of goes but it got there, just seem to be having some other issues now.

The sidebox for RP is not showing, and nothng shows up during checkout even after I have added points to an account ?

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

hem:

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

Ok, thanks Andrew, will check that out shorty.. Busy packing orders at present :smile::smile::smile:

hem:

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

Theres is no option to enable the RP sidebox here ???

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

Done...

Another issue, this is what is showing next to an item

42 PRODUCT_REWARD_POINT_TAG

Obviously its the number of points this product will offer as a reward, but the text obviously should not be reading that way whould it ?

Andrew?? Any luck figuring out why Paypal IPN purchasers are not receiving their points (even just as Pending like the CC customers)?

I can live with manually approving the Reward Points for a while, but I really do need the Paypal customers to get their RPs in Pending like they are supposed to.

Thanks

Rasyr:

Andrew?? Any luck figuring out why Paypal IPN purchasers are not receiving their points (even just as Pending like the CC customers)?

I can live with manually approving the Reward Points for a while, but I really do need the Paypal customers to get their RPs in Pending like they are supposed to.

Thanks

I will have to set up a PayPal IPN Payment mod onto my test rig and then work out how to setup the sandbox so I can test it.

Mike_Dean:

Theres is no option to enable the RP sidebox here ???

Done...

Another issue, this is what is showing next to an item

42 PRODUCT_REWARD_POINT_TAG

Obviously its the number of points this product will offer as a reward, but the text obviously should not be reading that way whould it ?

That shows that at least three of the mod files have not been copied to your site- includes/modules/sideboxes/custom/reward_points.php and shopping_cart_with_reward_points.php and includes/languages/english/extra_definitions/custom/reward_points.php

I would hazard a guess that you have not copied the files correctly into your custom folders.

hi,

Just install live version of the mod and working great.

i've question, my store have one product with two different fixed prices. i set base price to 0 and automatically the lowest attributes price will be the base price but my problem is the reward points also goes to 0 if i set base price 0.

so.. how to setup the mod to read the points from attributes price. anyone can help me.

anyway, thanks to andrew for the superb mod.

Rasyr:

Andrew?? Any luck figuring out why Paypal IPN purchasers are not receiving their points (even just as Pending like the CC customers)?

I can live with manually approving the Reward Points for a while, but I really do need the Paypal customers to get their RPs in Pending like they are supposed to.

Thanks

It looks like IPN handles the order status differently. I checked out:

http://www.zen-cart.com/wiki/index.php/PayPal

Looks like I've got a bit of digging to do.

gransazer:

hi,

Just install live version of the mod and working great.

i've question, my store have one product with two different fixed prices. i set base price to 0 and automatically the lowest attributes price will be the base price but my problem is the reward points also goes to 0 if i set base price 0.

so.. how to setup the mod to read the points from attributes price. anyone can help me.

anyway, thanks to andrew for the superb mod.

Thanks for the heads up- I'll check it out in the morning.

hem:

That shows that at least three of the mod files have not been copied to your site- includes/modules/sideboxes/custom/reward_points.php and shopping_cart_with_reward_points.php and includes/languages/english/extra_definitions/custom/reward_points.php

I would hazard a guess that you have not copied the files correctly into your custom folders.

My Bad.. Forgot to rename all the custom folders... so as soon as I went hunting through the includes folder and renamed the 'custom' folders to that of my template it all came together.

Thanks for the support..... appreciated.

Mike_Dean:

My Bad.. Forgot to rename all the custom folders... so as soon as I went hunting through the includes folder and renamed the 'custom' folders to that of my template it all came together.

Thanks for the support..... appreciated.

No problems- glad you got it working...

I haven't had to time to check this out yet, but I have just noticed that since installing this mod, its knocked out my Tabbed products mod that was installed ?

Without this RP mod, the Tabbed products '(TPL) mod works OK, but with this mod, the tabs disappear ?

Has anyone else noticed this.. ?

Could be an issue with my custom folders, like I said, haven't had time to fully check, but thought I'd mention it though

Mike_Dean:

I haven't had to time to check this out yet, but I have just noticed that since installing this mod, its knocked out my Tabbed products mod that was installed ?

Without this RP mod, the Tabbed products '(TPL) mod works OK, but with this mod, the tabs disappear ?

Has anyone else noticed this.. ?

Could be an issue with my custom folders, like I said, haven't had time to fully check, but thought I'd mention it though

Mike, that's because both mods make changes to the tpl_product_info_display.php file. I've attached a version that combines both mods- extract it to includes\templates\YOUR CUSTOM FOLDER\templates\