Discount Coupon Configuration Errors

Totally Zenned

Join Date:: Sep 2008
Posts:: 559
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

How did you set up the zones " international". Which country was your test user in?

For category and product restrictions did you edit the? Mine both say " top " and "allow".

17 Sep 2015, 04:59

#3

Totally Zenned

Join Date:: Sep 2008
Posts:: 559
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

I wanted to say that I was verifying areas that I had to guess at, I wanted to replicate on my store. With what you said, mine works. But I didn't edit the restrictions at all. I would check that area again first.

17 Sep 2015, 05:12

#4

Totally Zenned

Join Date:: Sep 2008
Posts:: 559
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

Me again. I just logged onto your site w and got "coupon not valid for the address you have selected" . I tried Australia.

17 Sep 2015, 13:40

#5

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

lruskauff:
How did you set up the zones " international". Which country was your test user in?

It's been 6 years and several version updates since setup. Test account is setup for UK

For category and product restrictions did you edit the? Mine both say " top " and "allow".[/QUOTE]

First pass, nothing edited for restrictions since there are no restrictions to category or product. I manually entered category top/allow.

Try it again when you get a chance. I bet the error changes from yellow to red. Just added category top/allow so that instead of NONE restrictions, there are top/allow restrictions.
There is no obvious way to top/allow for products. Buttons do not appear until you select specific products.

17 Sep 2015, 14:06

#6

Oba-san

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

Re: Discount Coupon Configuration Errors

Unless you have restrictions, in the restrictions delete the Categories Top Allow ... do this correct the problem?

17 Sep 2015, 14:21

#7

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

Ajeh:
Unless you have restrictions, in the restrictions delete the Categories Top Allow ... do this correct the problem?

No. Yellow https://chainweavers.com/includes/templates/westminster_new/images/icons/warning.png The coupon code you entered is not valid for the address you have selected.

IIRC, coupon codes are not case sensitive but tried both ways.

Just remembered, last weekend when I was having PP problems due to fractions, I saw that PP appeared to be trying to calculate taxes on International and Federal zones. Thinking that might be an issue since the only taxable zone I have is State, I removed the International and USA zones and recreated them afterwards.

Possible brainfart? when I did that? I dunno. I do not remember having to manually select countries for the International zone, do I?

17 Sep 2015, 14:28

#8

Oba-san

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

Re: Discount Coupon Configuration Errors

If you want to use a Zone you have to setup the Zone Definitions that are valid for it ...

17 Sep 2015, 14:33

#9

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

Zone Name: International
Zone Description: International Shipping Zone
Zone Definition: All Countries All Zones

17 Sep 2015, 14:47

#10

Oba-san

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

Re: Discount Coupon Configuration Errors

On your Internation Zone in the DETAILS did you literally use those settings or did you build the Zone DETAILS from something like:
https://www.zen-cart.com/content.php?308-prepared-zone-definitions

where you can use the:

To create a Zone Definition for the Rest of the World, excluding the United States, you can use:

Try building a real Zone with full Details ... does this fix the problem?

17 Sep 2015, 14:50

#11

Totally Zenned

Join Date:: Sep 2008
Posts:: 559
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

So just to be clear, you hit the set ails button when setting up countries and selected "all countries". Now you have even the U.S. . You need to select countries you ship to. Logically though, it should have accepted for all, not none. Try choosing uk as a test.

(Sorry Linda, didn't see u last post. You east coasters are fast)

17 Sep 2015, 14:59

#12

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

I literally just clicked the buttons and assumed those were acceptable, default settings for a real zone.
I did not run any sql statements after deleting/recreating the zones last weekend.

It'll take a few minutes to run the sql statements after making backups. I may have done that during setup 6 years ago but it doesn't look familiar.

17 Sep 2015, 15:09

#13

Totally Zenned

Join Date:: Sep 2008
Posts:: 559
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

Go back in then and try selecting a few countries.

17 Sep 2015, 15:14

#14

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

OK,

Used the sql for Rest of the World and 50 states + DC. Edited that one discount code and things seem to function as expected.

That is going to cause a nightmare finding every instance where I have (MIGHT HAVE) currently used USA as a zone and International as a zone.
Then changing all the USA and International zones.

I noticed the zones created by the sql statements are yellow ball instead of green ball. Yellow indicates caution to me. Did I need to do something?

Can I delete the USA and International zones and RENAME the newly created "Rest of the World" to International and the newly created 50 States + DC to USA?

8am and first pot of coffee gone. Looking like a 2 pot morning.

17 Sep 2015, 15:18

#15

Oba-san

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

Re: Discount Coupon Configuration Errors

Personally, I would have used:

To create a Zone Definition for the Rest of the World, excluding the United States, you can use:

That uses:

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) 
VALUES 
(40, 'Rest of the World', 'All Countries Except United States', NULL, CURDATE());

INSERT INTO zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added) 
SELECT countries_id , 0, 40, CURDATE() 
FROM countries 
WHERE countries_iso_code_3 NOT IN ('USA');

which would have made a Zone Definition with DETAILS that included everything in the World except the US ...

Then just rename it to International when done ...

17 Sep 2015, 15:27

#16

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

That's what I was trying to say that I used:

Rest of the world excluding the USA
50 states + DC

So I can
Delete what was the existing

USA
International

Rename the newly created

50 states + DC
Rest of the World

Back to

USA
International

And then I will have a USA zone with a yellow dot, International zone with yellow dot, Idaho zone with a green dot.

17 Sep 2015, 15:56

#17

Oba-san

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

Re: Discount Coupon Configuration Errors

Yes, you can rename them once they are created and they should work as they are now defined in the Details correctly ...

17 Sep 2015, 16:51

#18

Totally Zenned

Join Date:: Aug 2009
Posts:: 2,015
Plugin Contributions:: 0

Re: Discount Coupon Configuration Errors

Thank you.

After using the proper sql statements to generate the USA and International zones which were removed a few days ago while troubleshooting PayPal's inability to proper round numbers,

The discount coupon codes which have zone restrictions appear to be functioning as expected.

Sorry to have caused extra work for you. I didn't remember using those sql statements when the cart was created a few years ago and the FAQ didn't appear in my google search. I did try to find a solution before engaging my fingers with the keyboard.

Is it safe to assume that
Valid Product List :: --none--
Valid Categories List :: --none--

means that there are no restrictions
not there are no valid products or categories

17 Sep 2015, 17:01

#19

Oba-san

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

Re: Discount Coupon Configuration Errors

When set to --none-- that means none have been set on the restrictions ...

17 Sep 2015, 17:07

#20