Store credit and reward point module

Hi,

I have running SCM in my site, everything OK. but now I need help with something.

I need to set the reward point for only one Zone (country) is this possible? or there is an option I can set which costumers have the reward program and which not? Most modules have a Zone option or a "on/off" button.
Thanks for the help!

I keep getting this error when i try and apply the reward points...

1054 Unknown column 'created_on' in 'field list'
in:
[INSERT INTO sc_customers (customers_id, amount, created_on, modified_on) VALUES ('1', '6.5', '1257068510', '1257068510') ON DUPLICATE KEY UPDATE amount = (amount + 6.5), modified_on = 1257068510;]

I just upgraded to the latest version, it seems to be working better then the old version, however it is saying this on the store

"Reward Points
Your balance is $0.00

--------------------------------------------------------------------------------

You have $49.98 in pending rewards points"

But i cant find anywhere to switch them from pending to the account.

Quote:

---

Originally Posted by Delights

I just upgraded to the latest version, it seems to be working better then the old version, however it is saying this on the store

"Reward Points
Your balance is $0.00

--------------------------------------------------------------------------------

You have $49.98 in pending rewards points"

But i cant find anywhere to switch them from pending to the account.

---

Nevermind, i just ran the con.

AnyWAnt word on the group pricing bug? Seems like many people would need this fixed?
Posted via Mobile Device

I Installed this mod.
Everything looks okay. I can add amounts in the backend.
However the credit is not showing on the cart side.

Any Suggestions on how to proceed?

The store credit won't automatically update points when my customers purchase products..... I can manually insert it... but it's hell to do so....

I am not php expert... nor zen cart expert...

Anyone... any advice for why it is not update the points automatically?

THANK YOU THANK YOU for helping!

Quote:

---

Originally Posted by numinix

Once we get around to releasing the referrals module, it will be able to be used with either the store credit or rewards module. Currently the referrals mod is being used on the Numinix website only.

---

Great idea to give points for referrals.
When will the mod be released?

Also, some more ideas for the future: points for writing reviews, points for creating an account, points for subscribing to a newsletter, etc

thx!

Quote:

---

Originally Posted by koalabids

Hi, I have seen many posts about the following problem in this thread. Obviously it is a common problem, but there is no answer to fix it. I am desperate. I added this mod as the last thing before making my site go live, and now I can't, due to the error. It is not possible to checkout at all.
The error is:
1146 Table :[DBNAME].sc_customers' doesn't exist
in:
[select amount from sc_customers where customers_id = 2

I have uninstalled all the files, and removed the appropriate tables from my database. But I am still getting the error.

I spent over a week uploading over 350 products to my website, and realising this is a database problem, I do not want to have to reload my whole zencart. I have searched this forum, google etc. looking for an answer, but cant find one.

I am desperate, please did anyone find a fix? Any help would be very appreciated.

---

so, for all other people who may be having the same problem.

I have a busy shop. So, its advice that you install modules and what when your site is not busy.

BACK UP! BACK UP your database.

Here is the FIX that worked for me:

1.if you have a good database restore point, before the installation of this mod...revert to that.
2. now your database is clean of all 5 mod files.
3. Reinstall the sql patch


its worked for me, and hopefully it does for you as well.

Good luck

Samar

I would like to exclude a product from receiving points, and also exclude that same product from being able to use points to pay for it. Is that possible without too much headache? Can someone point me in the right direction to make the code change? Ideally, there would be an "exclude" field in the admin, but I am ok with hard coding it, because it will not change.

TIA!
Sara