sharpy20 Posted July 21, 2009 Share Posted July 21, 2009 Hi, I'm a newbie here just finding my feet, I hope to set up 3 eStores and I'm playing around with PrestaShop.I love to easy to navigate back office and was impressed how quickly I could get started.However,I only want to sell within the UK, so...,I have removed all other currencies -- easyI have removed all zones apart from Europe -- easyI have removed all states -- easyNo I do know how to disable the countriesShipping ---> Countries ----> Enable/DisableHowever there are 244 countries in the list. I only want 1.Do I have to tick 243 different countries (remember I want 3 eStores) Does that leave me with 729 boxes to click, I don't think my mouse and I can take it. -----Long-windedSo question is, any pros know a quick way. Remember I'm a well meaning newbie, simple=goodThank you in advanceMike Link to comment Share on other sites More sharing options...
Paul C Posted July 21, 2009 Share Posted July 21, 2009 I would strongly suggest you disable the countries rather than delete them. Deleting stuff isn't a great idea ;-) in phpmyadmin: UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE 'GB' Not that the above assumes that your table prefix is "ps_". I'm sure you'll figure it out!Remember to set your default country tooPaul 1 Link to comment Share on other sites More sharing options...
sharpy20 Posted July 21, 2009 Author Share Posted July 21, 2009 Brill that's just what my mouse and I were after.Regards Mike Link to comment Share on other sites More sharing options...
booblebab Posted September 8, 2009 Share Posted September 8, 2009 wow thanks! thats really useful! Link to comment Share on other sites More sharing options...
Hank Posted September 22, 2009 Share Posted September 22, 2009 Thanks, I disabled most on my test site by clicking each one. It seemed to take forever, it would be better if it was a check box with a submit at the bottom. Link to comment Share on other sites More sharing options...
supersesam Posted November 6, 2009 Share Posted November 6, 2009 Thanks - saved me 1 hour, many bucks and OCD-feelings ;-) Link to comment Share on other sites More sharing options...
Alex75 Posted December 9, 2009 Share Posted December 9, 2009 Thanks a lot, saved me a headache as well!Could anyone please help me with query to have 2 countries: US and CAThank you in advance. Link to comment Share on other sites More sharing options...
deepee Posted January 16, 2010 Share Posted January 16, 2010 Big time saver. Thanks! Link to comment Share on other sites More sharing options...
cammo Posted January 16, 2010 Share Posted January 16, 2010 Yes, this would have been handy.. I guess I'm not the only one that had to go through that BIG list and uncheck all those boxes! I only wanted 1 country! Link to comment Share on other sites More sharing options...
mooshi Posted January 23, 2010 Share Posted January 23, 2010 Thank you! that's a great time saver Link to comment Share on other sites More sharing options...
gucciba Posted January 24, 2010 Share Posted January 24, 2010 i deleted all stuff from db and now site suxx somehow.Anyway to get these back? Link to comment Share on other sites More sharing options...
vidicious Posted January 30, 2010 Share Posted January 30, 2010 great tip Link to comment Share on other sites More sharing options...
MartiL Posted March 27, 2010 Share Posted March 27, 2010 Thank you! That was a great timesafer!I was just about ready to spend my afternoon clicking & clicking & clicking ... Now it took me about 30 seconds Link to comment Share on other sites More sharing options...
archproject Posted June 8, 2010 Share Posted June 8, 2010 Great share .... thanks alotYeeeaaaaaa with this post I am a club member now har har har har har har Link to comment Share on other sites More sharing options...
joshsherm Posted June 13, 2010 Share Posted June 13, 2010 Could someone tell me where i put this code into phpmyadmin to disable all countried UPDATE ps_country SET active=0 WHERE iso_code NOT LIKE 'GB' In SQL Tab? Link to comment Share on other sites More sharing options...
rocky Posted June 14, 2010 Share Posted June 14, 2010 Correct. Paste the code in the field on the SQL tab. Remember to change "ps_" to your database prefix if it is different. Link to comment Share on other sites More sharing options...
Jeet Kune Do Posted October 27, 2010 Share Posted October 27, 2010 You saved my life! Thank you! Link to comment Share on other sites More sharing options...
Jackdomain Posted February 2, 2011 Share Posted February 2, 2011 wow thanks!!first shop I deactivate all manual. I'm creating a new shop and when I saw the list again I said NOOO jejeThis time I search for an answer before do.As someone said a checkbox option will be great Link to comment Share on other sites More sharing options...
Patolio Posted March 6, 2011 Share Posted March 6, 2011 GREAT! Saved me a bunch of time! Link to comment Share on other sites More sharing options...
Dave L Posted March 7, 2011 Share Posted March 7, 2011 Fantastic.I was leaving that boring laborious task until last for obvious reasons. It must have took all of a minute.Brilliant tip.Thanks. Link to comment Share on other sites More sharing options...
KleanBBS Posted April 14, 2011 Share Posted April 14, 2011 Hello everyone!!Im having a problem maybe a blonde moment hehe..but is there something i have to plug in with this? Beside copy and paste?#1054 - Unknown column '‘GB’' in 'where clause'This is what is got when i plugged it in. Im trying to just use central america as the country of my choice.Thanks Link to comment Share on other sites More sharing options...
s33m0n Posted April 23, 2011 Share Posted April 23, 2011 put the text for example UK between these too ( ' ' )I also copied it from this forum but it didnt work for me so I manualy type 'UK' and paste it instead of ‘UK’and it did work Link to comment Share on other sites More sharing options...
Luca S. Posted April 23, 2011 Share Posted April 23, 2011 how to back to old configuration ehehe?? Link to comment Share on other sites More sharing options...
KleanBBS Posted April 23, 2011 Share Posted April 23, 2011 @S33M0n Thanks a bunch it worked now, i dont know why anyone didnt clarify it a little bit better with what to plug in. Being a newbie all the help i can get is much appreciated!!! THANKS Link to comment Share on other sites More sharing options...
s33m0n Posted April 23, 2011 Share Posted April 23, 2011 @chicbella: no problem, you're welcome[spam-filter] Link to comment Share on other sites More sharing options...
imix4u Posted June 27, 2011 Share Posted June 27, 2011 Being a Newbie Im hoping someone can walk me through this step by step.. Thanks for your help Link to comment Share on other sites More sharing options...
resa55 Posted August 6, 2011 Share Posted August 6, 2011 Thanks Paul C! If you want to ship to a handful countries (in this example Germany, Denmark, Sweden, Norway and Finland) you can do it like this, by first disabling all countries, and then enabling the ones you want to ship to: First: UPDATE ps_country SET active=0 WHERE 1 Then: UPDATE ps_country SET active=1 WHERE (iso_code LIKE 'DK' OR iso_code LIKE 'DE' OR iso_code LIKE 'SE' OR iso_code LIKE 'NO' OR iso_code LIKE 'FI') 1 Link to comment Share on other sites More sharing options...
hrac5552 Posted December 25, 2011 Share Posted December 25, 2011 Thanks Paul C! If you want to ship to a handful countries (in this example Germany, Denmark, Sweden, Norway and Finland) you can do it like this, by first disabling all countries, and then enabling the ones you want to ship to: First: UPDATE ps_country SET active=0 WHERE 1 Then: UPDATE ps_country SET active=1 WHERE (iso_code LIKE 'DK' OR iso_code LIKE 'DE' OR iso_code LIKE 'SE' OR iso_code LIKE 'NO' OR iso_code LIKE 'FI') Hi , I dit it like you write , but nothing happened . Why ? Thank you Link to comment Share on other sites More sharing options...
ksv Posted November 20, 2014 Share Posted November 20, 2014 (edited) Sorry wrong post! Edited November 20, 2014 by ksv (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now