Accidentally deletes zones

[maihac]

Hello,

While setting up shipping rates, I accidentally deleted a few zones. Will it create problems after I re added the deleted zones just by typing their names?

As since I did that, the shipping rate hasn't showed correctly for different countries

Could you help me please? I just upgraded to the latest version of 1.7

Thanks alot,

Hac

[tdr170]

This is probably due to the way zones are applied, Prestashop uses the ID of the zone not the name, so for instance Europe is ID 1 but if you delete it and re-add is will be ID 9 so what you would need to do is either install another clean version in a subdirectory then copy pa_zone and ps_zone_shop and use those to repair your DB. or re-assign the all countries/states in the zone you deleted to the new one you created.

I have a test 1.7.2.2 I could provide you with the zone DB entries then just use the sql feature of the DB to overwrite the tables and correct back to original.

Also always make a backup of the DB and shop files before editing back or front office this will allow you to correct any mistakes you might make.

I backup my complete shop files then if I edit any files I back those up overwriting the original so all files are up to date.

If you want the DB tables let me know I will make a zip and upload them, if you need help with applying these to the DB I can istruct you on how to do it.

[maihac]

Hello,

Thank you so much for your reply.

So if I change the ID number which correspond to its initial order, would it work? Can we add new countries in this Zone area? Because I live in France and in the shipping setting, there's no France for setting up its rate. 

What is DB?

My version is 1.7.2.3 

If you could help me, that would be great as I'm not a developer

[tdr170]

DB is Data Base this is what you created in mysql in order to install Prestashop. Yes you can setup your own zones and al=pply the shipping to that zone and should work OK.

Changing the ID to the new ID of the zone you created for the initial order should work.