Store credit and reward point module

NOTE: THIS MODULE IS NO LONGER MAINTAINED

Developed from the store credit module(Kath Chapman)

This module's main features:

1. Allow store owners to add store credit to customers' accounts via admin
2. Allow customers to earn store credit at certain % of the purchase value (set in admin)
3. Allow customers to redeem those points during checkout.
4. In testing: automatically removes points when the order is canceled or refunded.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=501

OK

The instruction say put cron above store but it won't work because it looks for application_top. So I had to move it to inside the store. I ran it manually and it processed the rewards acuatlly. Currently only working with the cash values, not the points. Going to go set up my cron and do further testing. This is a live store and will PM you with address. I have had problems recently with some users and robots, coming from Zen unfortunatly, so i had to remove my address from my sig and such.

Thanks for the mod its been what I was looking for.

Suggestion: Drop the Modules Manager - Good intention and use but creates confusion and hard to back track errors and such. Just a suggestion.

gjw

Suggestion: Drop the Modules Manager - Good intention and use but creates confusion and hard to back track errors and such. Just a suggestion.

Everything has a beginning, even ZC has many bugs. This module if works correctly would not only help you but also saves us time as well. We dont want to create extra doc and spend extra time to help users running the sql patches and such. So this may be troublesome at first, but with the help of users like you we will eventually fix all the bugs and save the time in the long term.

Did some testing and got some errors. I will PM you in a few regarding.

GJW

sure, just pm me or numinix. (all module manager related errors should be directed to me though)

Bravo for this module, it is working great !

I have a question : I works perfectly with products without attribute, but when attributes are added I get stopped with this message on the process page :

http://localhost/shop/index.php?main_page=checkout_process

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 ':2da10f03e725050e43fb5d73f845f2d6 LIMIT 1' at line 1
in:
[SELECT ratio FROM sc_products_ratio WHERE products_id=39:2da10f03e725050e43fb5d73f845f2d6 LIMIT 1]

Is it normal ?

Thank you

G

Not normal, but an easy fix:

Try to update your includes/classes/store_credit.php to use this instead:

http://code.google.com/p/zencart-reward-point/source/browse/trunk/catalog/includes/classes/store_credit.php

Thank you ! it is working now, great !
:smile:

Things are really looking good.

How do you remove the refresh button on the checkout page?

Thanks
GJW

Which one? I dont think we modify the checkout page in any way. Can you please show a screenshot? Regards.

Using FEC. a refresh button appears upon checkout, which is not need. See image attachment.
Thank You

GJW

stampsville:

Using FEC. a refresh button appears upon checkout, which is not need. See image attachment.
Thank You

GJW

What version of FEC are you using? There is no refresh button on my test site...

I absolutely love the mod and the idea of store credit. I think I have an error message, can you please tell me what it refers to. Thank you

1146 Table 'bigfoot_zc2.zen_sc_customers' doesn't exist
in:
[select count(*) as total from zen_customers c left join zen_sc_customers sc on c.customers_id= sc.customers_id ]
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.

arcanesanctuary:

I absolutely love the mod and the idea of store credit. I think I have an error message, can you please tell me what it refers to. Thank you

1146 Table 'bigfoot_zc2.zen_sc_customers' doesn't exist
in:
[select count(*) as total from zen_customers c left join zen_sc_customers sc on c.customers_id= sc.customers_id ]
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.

If this means anything, I don't have any customers yet.

Hi Yellow,
Thanks for the reply. I am currently using 2.13(?) version and did do a quick test with 2.14 and it DID remove the refresh button. Unfortunately I have a custom stacked FEC and have to look into the structure of the two version which seem to have dramatically changed. Not using modules? Not sure on this since I only did a quick test. Thank you for the correct direction in the matter and will update any if need be.

Thanks again
GJW

The original had the two template types in one file with stacked at the top and split on the bottom. You should be able to just copy and paste your changes into the new appropriately named file.

Ok ,will look at it. On a separate note
has anyone looked into the sale price credit conversion if a item is on sale? Or will the above fix for attributes work under that?

And finally on the far end of the subject. Is there any possibility of restricting to certain Top Categories or dissallow one top category?

Thanks
GJW

Where do you get the error?
Did you install the patchs via admin->tools->module manager?

arcanesanctuary:

If this means anything, I don't have any customers yet.

I have released new versions for both module manager and point reward module.

This should fix all the database patch errors.

http://code.google.com/p/zencart-module-manager/downloads/list
http://code.google.com/p/zencart-reward-point/downloads/list

I uploaded the shared class files, the module manager, and v3.01b. But when "installing new module", I got an error relating to not finding table zen_sc_customer. I tried uploading v3.01c files and now I get the error

1017 Can't find file: './[DBNAME]/zen_SC_CUSTOMER.frm' (errno: 2)
in:
[RENAME TABLE zen_SC_CUSTOMER TO zen_SC_CUSTOMERS;]
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.

where [DBNAME] is my database.

The module shows under "list all modules" and now I have access under Modules -> Order Total.

Is that error an issue?