Coupons no longer working.

[Peter Homann]

Linda,

I checked all the settings and all appeared OK. So I tried adding the coupon_zone_restriction field. I copied the field definition from a test database.

The end result is that it appears to work.

I'm a bit concerned and feel like I should backup what is there and try to load it into a fresh database. I'll have to wait until I'm bold enough.

thanks for all your help.

Peter.

[Usahog]

Linda,

I checked all the settings and all appeared OK. So I tried adding the coupon_zone_restriction field. I copied the field definition from a test database.

The end result is that it appears to work.

I'm a bit concerned and feel like I should backup what is there and try to load it into a fresh database. I'll have to wait until I'm bold enough.

thanks for all your help.

Peter.

I have the exact same problem and I have did all the steps in this topic except adding as Peter did above. Can someone please tell me where to add the coupon_zone_restriction field? Also, where can I get the field to add?

Thanks,
Russ

[Ajeh]

First ... backup your database and then run:

/zc_install

and click the Database Upgrade ...

Are any of the checkboxes checked?

[Usahog]

No boxes are checked and I ran the zc_install. I checked the 1.36 to 1.37 and did the database upgrade. It stated that nothing was done because all the files were already there?

Usahog

[Ajeh]

Having assured that you have the Database backed up ...

Check in phpMyAdmin the table for:
coupons

do you have the field:
coupon_zone_restriction

If not, if not using prefixes on your database, you can run these statements in your SQL area of phpMyAdmin ...

# Updating coupon-related tables
ALTER TABLE coupons ADD coupon_zone_restriction INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE coupons CHANGE coupon_minimum_order coupon_minimum_order DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';
ALTER TABLE coupons CHANGE coupon_amount coupon_amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';
ALTER TABLE coupon_gv_customer CHANGE amount amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000';
ALTER TABLE coupon_gv_queue CHANGE amount amount DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000'; 

If you do have prefixes, you can run the above in the Tools ... Install SQL Patches ...

[Ajeh]

Also, from what version did you upgrade and how?

[Usahog]

Ajeh,

I ran the statements in the SQL and it fixed it.

Thank you so much.

Now for another question. I have another question. Were is my referrals?

When I place a test order it does not give me an option to use if I was referred by someone?

I have never had this on any of my Zencart versions, but I see different ones referring to it.

Thanks,

Hog

[Ajeh]

It would be helpful to keep questions on their own topics ... but since I am here ...

The Coupon Referral is set in the Configuration ... Customer Details ...

Customers Referral Status
Customers Referral Code is created from
0= Off
1= 1st Discount Coupon Code used
2= Customer can add during create account or edit if blank

NOTE: Once the Customers Referral Code has been set it can only be changed in the Admin Customer

When the referral is used, you can observe the sales made by customers in the Reports ... Customers Referral Report ...

Note: nothing will appear in the dropdown for:
Select a Referral/Coupon Code

until someone has claimed the coupon redeem code (referral code)

[Usahog]

Thank you very much for the information. You have been a great help!!

Hog