Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / I get this error on my discount coupon at checkout:'This coupon is not available yet'

I get this error on my discount coupon at checkout:'This coupon is not available yet'

Locked

Started by whhammond on 12 Sep 2010, 4:12 PM · Views: 2,879

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
12 Sep 2010, 4:12 PM
#1
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

I get this error on my discount coupon at checkout:'This coupon is not available yet'

I'm using v1.3.9f.
I get this error on my discount coupon at checkout:'This coupon is not available yet'.
If I look up the code it indicates its valid from 09/10/2010.
What did I do wrong?

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

12 Sep 2010, 7:47 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

What are all of the settings on the Discount Coupon?

Is the Status active (green dot) or Inactive (red dot) ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

12 Sep 2010, 8:00 PM
#3
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Its says 'Y' for the status in Coupon Admin.
I've set up no restrictions.

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

12 Sep 2010, 8:11 PM
#4
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

This is the info displayed:

Coupon Name :: 10% off $100 or more
Coupon Amount :: 10.0000%
Start Date :: 09/12/2010
End Date :: 09/11/2011
Uses per Coupon :: 1
Uses per Customer :: 1
Valid Product List :: --none--
Valid Categories List :: --none--
Date Created :: 09/12/2010
Date Modified :: 09/12/2010

Coupon Zone Restriction: :: 0

Of course I've no idea why it says 'none' for Valid Product List.
I followed the tutorial: How do I offer coupons for my customers to redeem? (https://www.zen-cart.com/tutorials/index.php?article=336)

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

12 Sep 2010, 9:04 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

If you look at the menu bar in your admin, what is the date and time of your server?

NOTE: The NONE settings on:

Valid Product List :: --none--
Valid Categories List :: --none--
means you have no restrictions on the Products or Categories ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

12 Sep 2010, 9:05 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Could you go to phpMyAdmin and browse the table:
coupons

and see what the exact date/time is on it ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

13 Sep 2010, 4:15 AM
#7
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Ajeh:

If you look at the menu bar in your admin, what is the date and time of your server?

NOTE: The NONE settings on:

means you have no restrictions on the Products or Categories ...
I thought thst what it meant, but wasn't sure

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

14 Sep 2010, 4:07 AM
#8
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Ajeh:

Could you go to phpMyAdmin and browse the table:
coupons

and see what the exact date/time is on it ...

OK. I've tried this.
The date was correct.
I tried to change it, which was successful.
However, it still says its not available yet.

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

14 Sep 2010, 4:23 AM
#9
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

I'm just gonna use mySQL to change the date to tomorrow and see if that works.

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

15 Sep 2010, 12:49 PM
#10
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Well, the date was correct in phpMyAdmin (as well as in my store admin area).
So I changed the availability date and allowed an extra day before it started and for some reason my coupon code still comes back as invalid at checkout.

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

15 Sep 2010, 12:58 PM
#11
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

Has no one else experienced this?
So far my installation has given me no errors; my store has run just fine for over a month.
I'm not that skilled at programming or coding, but I'm pretty sure I haven't done anything wrong so far.
This is the only 'real' problem I've had.
Would it matter that I typed in my own coupon code in the admin coupon creation, instead of allowing for a generated code to be used?

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

15 Sep 2010, 1:27 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

On the dates that you see in phpMyAdmin, could you copy and paste them here?

Was this an upgrade to v1.3.9 ...

If you already removed them, do you recall if they had a time set on them?

Make a test coupon with no date ... does it work?

Make a test coupon with today's date ... does it work?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

15 Sep 2010, 2:06 PM
#13
whhammond avatar

whhammond

New Zenner

Join Date:
Sep 2010
Location:
Indiana
Posts:
9
Plugin Contributions:
0

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

WOW! I feel like a total idiot.
Upon creating a new coupon I realized something I had misinterpreted before:

Uses per Coupon: (The maximum number of times the coupon can be used, leave blank if you want no limit.)

Uses per Customer: (Number of times a user can use the coupon, leave blank for no limit.

I had BOTH set to '1' before. So appearantly I had only allowed ONE coupon by ONE customer; instead of one PER customer!

I apologize for taking up your time with this issue. And, I greatly appreciate all your help.
I only wish this wasn't here for everyone else to see...
Talk about embarrassing!
:blush:

William Hammond;WH Hammond OnLine Sales
"Anyone who has never made a mistake has never tried anything new." -Albert Einstein

15 Sep 2010, 2:09 PM
#14
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: I get this error on my discount coupon at checkout:'This coupon is not available yet'

You are most welcome ... thanks for pointing out your error in configuration ...

I made the assumption that you wanted that and could not recreate the problem with those settings ... :lamo:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!