Discount Coupon Configuration Errors

[lruskauff]

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)

[RixStix]

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.

[lruskauff]

Go back in then and try selecting a few countries.

[RixStix]

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.

[Ajeh]

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 ...

[RixStix]

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.

[Ajeh]

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

[RixStix]

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

[Ajeh]

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

[RixStix]

Thank you