Deleting the rest of the countries from the list

[pcaspian]

Hi
Actually i Ship products only to my country and i dont want the rest of the countries to be displayed.since there are a lot of countries,is there an easier way to delete the rest of the countries from the list except mine?

[Ajeh]

What if Grandma wants to buy from the US and send to Tiny Tim, now living in your country on scholarship at school?

You might be better off setting up a Zone for your Country and adding it to your Shipping Module(s) ...

This will give the customer a message that you do not ship to their address ... which, you could customize more to give details of where you do ship ...

[pcaspian]

i am new to zen.
but i am pretty sure that the targeted grandma lives in India and NObody outside my country will need to access the site as it my client's business is already setup to work just here(India) and we only accept cash/cheque payments as of now

[Kim]

Under those circumstances you will be fine to delete any countires you do not need.

[pcaspian]

ok that would be 238 countries on a modem connection

[Steven300]

Back up DB first

DELETE from countries WHERE countries_iso_code_3 NOT IN ('IND');