Easy way to enable all countries ?

[BlizzardUK]

I want to sell to all countries and have enabled all zones, but for some reason the majority of countries are still red X marked. I even tried Prestashop Manager to see if there was a quick way (there wasn't, from what I could see), I even tried to export (in PS Manager) and rename all to TRUE, but there was no way to import back again after the change. See attached images for what I mean (it carries on beyond what is visible in the photo all the way down to 244 countries, that is a lot of ticking).

 

I am also looking to do the same for the payment page, for some reason only the UK and a couple of other countries are ticked, meaning many hundreds of others to tick. Again see image.

 

So is there anything I can do to enable every country quickly and easily in both shipping and payment ?

 

Thanks all.

Edited February 11, 2013 by BlizzardUK (see edit history)

[gonebdg - webindoshop.com]

phpMyAdmin > search table PREFIX_country > Run sql query :

UPDATE `PREFIX_country` SET `active`=1

All country will be enable

 

phpMyAdmin > search table PREFIX_zone > Run sql query :

UPDATE `PREFIX_zone` SET `active`=1

All zone will be enable

 

For Payment countries restrictions, you just have to click payment icon/logo to select all or deselect all

 

For Shipping-Carrier Zone restrictions, you can do this :

1. Export DB table Prefix_carrier_zone as CSV file
   
2. Open the CSV file with Ms.Excel
   
3. Edit and make sure the desired id_carrier has all value for id_zone
   
4. Save CSV file
   
5. Import
   

Note:

PREFIX_ = Your Prestashop PREFIX_ Database , default = ps_

[El Patron]

or have a glass of wine and just click the red x's...

[BlizzardUK]

phpMyAdmin > search table PREFIX_country > Run sql query :

UPDATE `PREFIX_country` SET `active`=1

All country will be enable phpMyAdmin > search table PREFIX_zone > Run sql query :

UPDATE `PREFIX_zone` SET `active`=1

All zone will be enable For Payment countries restrictions, you just have to click payment icon/logo to select all or deselect all For Shipping-Carrier Zone restrictions, you can do this :

1. Export DB table Prefix_carrier_zone as CSV file
   
2. Open the CSV file with Ms.Excel
   
3. Edit and make sure the desired id_carrier has all value for id_zone
   
4. Save CSV file
   
5. Import
   

Note: PREFIX_ = Your Prestashop PREFIX_ Database , default = ps_

 

Hi, thanks for the solution but I get this error message when I try it, any idea (I have attached a screen grab of my server) ?...............

 

#1146 - Table 'db422415595.PREFIX_country' doesn't exist

Edited February 14, 2013 by BlizzardUK (see edit history)

[BlizzardUK]

the easy way? how about just clicking the red x's..and be done with it...

 

before proceeding with any of this sort of hack...make sure to export (back up) you db

 

ok so replace the PREFIX with PS, which is your db prefix...

 

Thanks. I will try that out. I know it seems like I am being lazy, but from what I can remember there are 250 countries and I think you have to click the red X and then it opens another screen you have to click on, so that is 500 times. Obviously if I have to, then I will, but I will try the solution here first. Thanks for the info and I will change the prefix, a simple error I should of noticed, ooops.

[El Patron]

yes, if it actually opens the country then you have to enable it that would be a burden...

 

but at least on 1.4... you just need to click the x..does not open the country...so if you do it that way select enabled no, ..then start clicking...probably the easiest way is to get someone else to do it for you...jajajaja

[BlizzardUK]

Wow, it works, all so simple. Thanks both of you, all 250 countries are now active by doing that SQL code Now I will try the payment tip.

Edited February 14, 2013 by BlizzardUK (see edit history)

[BlizzardUK]

Thanks again. I have clicked "like" too. You are right, I missed that smallprint, they did everything right, I made the error.

 

Also a BIG thanks on the payment tip, I had no idea you could click the payment logo and all would be selected, I would have been there for ever ticking each one as it is 4x for each country, 1000 clicks. This has been the most useful thread to me

 

Edited : Removed my last question as it is obvious to me now what it means.

Edited February 14, 2013 by BlizzardUK (see edit history)

[gonebdg - webindoshop.com]

On Prestashop v.1.5.x you don't have to do this.

There is a select box in front of country list, and there is an options to Enable/Disable All in the bottom of country list table

[BlizzardUK]

Thanks again. How easy, or how much does it cost, to upgrade to 1.5.x ? Is it a worthy upgrade ?

 

Also is there any way to find out if a theme will work first ? I have one that I think is known as "Free Red" or similar. As the name suggests, it was a free theme. Do most modules work ? I have either purchased or used (for the free ones) about 3 modules.

[Texxi]

On 13/02/2013 at 1:19 AM, El Patron said:

or have a glass of wine and just click the red x's...

 

NO, just NO. If you activate one country, the page reloads and it takes you 5-10 seconds per entry! I would need a BOTTLE of whine! Start learning to use your keyboard Sir... Tick the first box, hit Tab thrice, continue with space, again Tab thrice, space once... put it in a Keyboard macro and you're through in 30 seconds. That's faster than you can even login to phpMyAdmin which by the way is a complete pain in the ____ if you have a multishop.

I tried first with "UPDATE `ps_country` SET `active`=1" which worked flawless on the database level but did not change ANY value in my backend. How cruel.

 

 

[Presta Fabrique]

Hi

A bit late in this topic, but it keeps coming up, and still not resolved with Presta 1.7, so here's a module built by us for a client that, beside other country and zone related stuff, allows this too: Easy country and zone manager

Hope will help some owners in their onboarding process!

For questions don't hesitate to write us!

Cheers!