[Solved]Restore Countries to default

[SpyrosT]

Hi all,

Is there any way to restore the countries to their default.
I made a mistake in the zones and all Country's zones are messed.

Tnx

[rocky]

There is no option in the Back Office to do this. You'll have to do things the hard way by manually going to your database and emptying the appopriate tables and then open install/sql/db_settings_lite.sql and copy the INSERT INTO `PREFIX_country`section and any other appropriate sections and run the SQL queries on your database using phpMyAdmin to restore the default values. It looks like the relevant tables are `PREFIX_carrier_zone`, `PREFIX_country`, `PREFIX_country_lang`, `PREFIX_state`, `PREFIX_zone`. Remember to make a backup of the tables before emptying them in case something goes wrong!

[SpyrosT]

Hey rocky,

Many thanks for your reply and instuctions.
The mess is about the "zones" only, all other infos are ok.

Will this work if I only empty the zones table and reinstall it?

By the way it should e really helpful if there were some restoration functions in BO
because as you said some things need the "hard way".

[rocky]

In that case, it should only be the zone and carrier_zone tables you need to restore. They are linked by id_zone, so I think you should restore both, otherwise problems may occur with mislinked zones.

[SpyrosT]

Once again you you are right!!! TNX!!

It is now fixed!!!

Could you please also take a look here> http://www.prestashop.com/forums/viewthread/45170/

Im sure you will find the solution;)