[Prestashop] Disabling country list in one go

Default installation prestashop included all the country in the world, as for me I don’t realy need all of them to be enable which because I’m only selling items in my local country only.

This which require me to disable all 200+ entry which is a tremendous clicking task, but someone posted this in the prestashop forum which only require 1 SQL query statement to disable all of the entry beside your choosing:

UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE 'MY'

of course you need to change the ps_ to your database prefix :)

Cheers!

Posted under: Tips & Tricks

Tagged as: ,

Leave a Reply

Your email address will not be published. Required fields are marked *

hero ;) :| :x :twisted: :tido: :tensen: :swt: :spot: :sleepy: :shock: :run: :roll: :pasrah: :oops: :o :nono: :nangis: :muzik: :mrgreen: :mabuk: :lol: :kerek: :joget: :idea: :hedban: :evil: :desk: :cry: :cayo: :bored: :blur: :arrow: :amok: :P :D :?: :? :33: :32: :31: :30: :29: :28: :27: :26: :25: :24: :23 :22: :21: :20: :19: :18: :17: :16: :15: :13: :12: :11: :10: :09: :08: :07: :06: :05: :04: :03: :02: :01: :) :( :!: 8O 8)