"NOT IN('USA');" would become "NOT IN('USA', 'CAN');"
Or alternatively consider using the plugin for restricting available countries.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Which one works best with Zen 1.5.1?
This plugin you mention will restrict same countries from appearing in the customer registration area as well?
Last edited by Kevin205; 28 Mar 2013 at 06:59 AM.
Using Zen Cart 1.5.1
Per Doctor's recommendation, I used selectable_countries_v101
It eliminates the unwanted countries, while registering as well.
It works great. Thank you.
Last edited by Kevin205; 28 Mar 2013 at 07:35 AM.
Using Zen Cart 1.5.1
Hello fellow Zenners,
When I first launched my store, we only shipped within the USA so I ran the code that was suggested earlier in this thread:
Now, I would like to start shipping to Canada. How do I add Canada back to my list of countries?DELETE from countries WHERE countries_iso_code_3 NOT IN('USA');
Any help is greatly appreciated. Thanks for your time!
Code:INSERT INTO countries VALUES (38,'Canada','CA','CAN','2');
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Bookmarks