If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Payment Modules / Store credit and reward point module

Store credit and reward point module

Started by yellow1912 on 4 Mar 2008, 2:23 PM · Views: 71,311

Results 101 to 120 of 171
16 Apr 2009, 9:41 PM
#101
gsdcypher avatar

gsdcypher

Totally Zenned

Join Date:
Feb 2007
Posts:
816
Plugin Contributions:
0

Store credit and reward point module

Can this reward points mod be set up for the following?

  1. Is is possible to have the reward points = %off rather than $off?

  2. adjust the point value per product, per category or globally?

  3. is it possible to set levels and limits?
    1000 points = 5% off
    2500 points = 10% off
    5000 points = 15% off (max limit)

Thanks!

1 Jun 2009, 3:37 AM
#102
karazy avatar

karazy

New Zenner

Join Date:
May 2008
Posts:
58
Plugin Contributions:
0

Re: Store credit and reward point module

Just one thing I noticed about this module, it is a good module but I found a bug. This has to do with "Group Pricing". I'm the Admin and I gave myself a 25% discount when I check out everytime with the "Group Pricing" and $20 in store credit. I choose a product for 15.99 and a preferred shipping method "Parcel Post"

Before I add the store credit

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Total: $19.67

After I add the store credit by clicking the check box.

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Store Credit: -$20.00
Total: -$0.33

I think there might be a problem with this why it gave me the whole $20 than $19.67 which would of given me $0.00. This is a problem I bumped into please let me know if this is on my end or if this is a universal problem and I did update to the latest version.

This only happened with "Group Pricing" customers

2 Jun 2009, 4:55 AM
#103
ams30gts avatar

ams30gts

Zen Follower

Join Date:
Apr 2009
Location:
Los Angeles, California
Posts:
118
Plugin Contributions:
0

Re: Store credit and reward point module

having trouble with install.

followed the instructions perfectly til step 4. (where you setup configurations)

got this error in admin when trying to access the configurations

1146 Table 'XXXXX-XXX.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 6]
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.

my store is live, so hopefully can get this working by tonite

2 Jun 2009, 5:13 AM
#104
ams30gts avatar

ams30gts

Zen Follower

Join Date:
Apr 2009
Location:
Los Angeles, California
Posts:
118
Plugin Contributions:
0

Re: Store credit and reward point module

nm.

uninstalled this add-on

2 Jun 2009, 6:35 PM
#105
numinix avatar

numinix

Totally Zenned

Join Date:
Apr 2007
Location:
Vancouver, Canada
Posts:
1,571
Plugin Contributions:
60

Re: Store credit and reward point module

ams30gts:

having trouble with install.

followed the instructions perfectly til step 4. (where you setup configurations)

got this error in admin when trying to access the configurations

1146 Table 'XXXXX-XXX.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 6]
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.

my store is live, so hopefully can get this working by tonite

There should be a file called store_credit_filenames.php in includes/extra_datafiles/ which contains the table definition.

Update: I see that it has been commented out for some reason. We'll release a patch with the correction today. Anyone else experiencing this problem can quickly resolve the issue by uncommenting the definition.

5 Jul 2009, 5:12 PM
#106
slomojojo avatar

slomojojo

Zen Follower

Join Date:
Feb 2009
Posts:
142
Plugin Contributions:
0

Re: Store credit and reward point module

spikescot2005:

I have installed this today but get the following error:
**
); define('TEXT_SC_CRON_ORDERS_UPDATED', '%s order(s) updated.'); define('TEXT_SC_CRON_PRODUCTS_UPDATED', '%s product(s) updated.'); define('TEXT_SC_PRODUCTS_INFO', 'Earn up to %s in rewards points when you purchase this product!'); /* End Store Credit Order Total Module / ?>*

Also in the admin cp i get this -

**BOX_CUSTOMERS_CREDIT, 'link' => zen_href_link(FILENAME_STORE_CREDIT, '', 'NONSSL')); ?>
**

I got that too. I ran a search on every file in the download for the short opening php tag:

<?

and replaced it with this one:

<?php

Don't know if that's kosher php, but it fixed all the errors (ver 3.05).

5 Jul 2009, 6:02 PM
#107
slomojojo avatar

slomojojo

Zen Follower

Join Date:
Feb 2009
Posts:
142
Plugin Contributions:
0

Re: Store credit and reward point module

A clarification to my last post. If your using wamp on a test machine, open your PHP settings and enable "short open tag" if it's off. That should fix the errors without having to mess with any code.

1 Aug 2009, 1:25 AM
#108
shartlesville avatar

shartlesville

New Zenner

Join Date:
Jul 2009
Location:
Roswell, NM, USA
Posts:
103
Plugin Contributions:
0

Re: Store credit and reward point module

I have installed it and if I manually award points it works perfectly. However, I cannot get it to add points to previous orders.

It is showing all the customers but it is showing them without any orders. If I click on a customer the information under their names is blank as if there are no orders. :shocking:

I did run the cron file and it said 0 orders updated and 0 products updated. :no:

Is there something else I need to do or something that is missing? :oops:

Blessings,
Krisann

I donate to the Zen Team do you?
My current project: BestSewingDeals.com;

28 Oct 2009, 3:59 PM
#109
data_digger avatar

data_digger

Zen Follower

Join Date:
Jan 2009
Posts:
222
Plugin Contributions:
2

Re: Store credit and reward point module

There's bug in SQL statement in

function update_customer_credit($customers_id, $amount){
		global $db;
		$sql='INSERT INTO '.TABLE_STORE_CREDIT.' VALUES (\''.$customers_id.'\', \''.$amount.'\') ON DUPLICATE KEY UPDATE reward_points=reward_points+'.$amount.';';
		$db->Execute($sql);
		if(mysql_affected_rows($db->link) == 1)
		return true;
		return false;
	}

it should be

function update_customer_credit($customers_id, $amount){
		global $db;
		$sql='INSERT INTO '.TABLE_STORE_CREDIT.'(customers_id, amount) VALUES (\''.$customers_id.'\', \''.$amount.'\') ON DUPLICATE KEY UPDATE reward_points=reward_points+'.$amount.';';
		$db->Execute($sql);
		if(mysql_affected_rows($db->link) == 1)
		return true;
		return false;
	}

I added "(customers_id, amount)" in sql statement after TABLE_STORE_CREDIT.

29 Oct 2009, 2:04 PM
#110
swamyg1 avatar

swamyg1

Zen Follower

Join Date:
Dec 2008
Location:
San Fran
Posts:
382
Plugin Contributions:
0

Re: Store credit and reward point module

karazy:

Just one thing I noticed about this module, it is a good module but I found a bug. This has to do with "Group Pricing". I'm the Admin and I gave myself a 25% discount when I check out everytime with the "Group Pricing" and $20 in store credit. I choose a product for 15.99 and a preferred shipping method "Parcel Post"

Before I add the store credit

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Total: $19.67

After I add the store credit by clicking the check box.

Sub-Total: $15.99
Shipping USPS Parcel Post: $6.90
Friends And Family 25% Discount : -$4.00
Taxes (Ohio Only): $0.78
Store Credit: -$20.00
Total: -$0.33

I think there might be a problem with this why it gave me the whole $20 than $19.67 which would of given me $0.00. This is a problem I bumped into please let me know if this is on my end or if this is a universal problem and I did update to the latest version.

This only happened with "Group Pricing" customers

I can confirm this same problem... any idea how to fix?

30 Oct 2009, 3:12 PM
#111
salmonido77 avatar

salmonido77

New Zenner

Join Date:
Oct 2009
Posts:
17
Plugin Contributions:
0

Re: 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!

1 Nov 2009, 9:55 AM
#112
delights avatar

delights

Zen Follower

Join Date:
May 2006
Location:
Queensland, Australia
Posts:
254
Plugin Contributions:
0

Re: Store credit and reward point module

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;]

2 Nov 2009, 11:28 AM
#113
delights avatar

delights

Zen Follower

Join Date:
May 2006
Location:
Queensland, Australia
Posts:
254
Plugin Contributions:
0

Re: Store credit and reward point module

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.

2 Nov 2009, 12:16 PM
#114
delights avatar

delights

Zen Follower

Join Date:
May 2006
Location:
Queensland, Australia
Posts:
254
Plugin Contributions:
0

Re: Store credit and reward point module

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.

2 Nov 2009, 4:41 PM
#115
swamyg1 avatar

swamyg1

Zen Follower

Join Date:
Dec 2008
Location:
San Fran
Posts:
382
Plugin Contributions:
0

Re: Store credit and reward point module

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

8 Dec 2009, 6:41 PM
#116
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

Re: Store credit and reward point module

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?

9 Dec 2009, 11:37 AM
#117
happyblogger avatar

happyblogger

New Zenner

Join Date:
Dec 2009
Posts:
1
Plugin Contributions:
0

Re: Store credit and reward point module

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!

29 Dec 2009, 4:37 AM
#118
greenhat avatar

greenhat

Zen Follower

Join Date:
May 2007
Posts:
108
Plugin Contributions:
0

Re: Store credit and reward point module

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!

6 Jan 2010, 4:36 AM
#119
samar777 avatar

samar777

Zen Follower

Join Date:
Nov 2009
Location:
Chicago, IL.
Posts:
202
Plugin Contributions:
0

Re: Store credit and reward point module

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

Automation is Godliness

15 Jan 2010, 2:37 PM
#120
sarabz avatar

sarabz

New Zenner

Join Date:
Oct 2007
Posts:
14
Plugin Contributions:
0

Re: Store credit and reward point module

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