UK zones (paypal compatible) 1.0

Hi, this is my first posting so please be gentle with me. I am new to eCommerce and I have spent the last couple of weeks installing and setting up Zen Cart v1.3.7. It has loads of useful features and I must admit I am having some fun trying to get it all working.

I have found most of the information I need by scouring the forum, but there is one that I have not be able to resolve. I have installed the UK zone (paypay compatible) 1.0 module from the downloads section, by sucking it into MySQL through a button that was marked something like 'insert text into database'. It seemed to go in OK but the UK zones do not show up - I still only get the default ones that came with the v1.3.7 main download as standard.

Has anyone else had this problem? Maybe there is something else I need to do to make it work?

(Thanks for a great programme guys!)

When you installed Zen Cart did you specify a database table prefix, like zen_ ?

If so, you will need to edit the sql file accordingly - wherever it has

INSERT INTO zones

should be

INSERT INTO zen_zones

or whatever prefix you specified. If you don't remember, it will be in /includes/configure.php - look for DB_PREFIX

Many thanks for your quick response.

No, I don't have a prefix (and I checked includes/configure.php to make sure) - its just 'zones'.

I've done some more investigation:

• the Zones pulldown in Locations/Taxes from admin panel contains 189 zones
• the UK counties file that I imported contains 90 lines
• MySQL zones has 279 rows!So it looks like it is in MySQL OK, but for some reason it isn't showing up in the admin Zones section.

Any further ideas would be most welcome.

Thanks again.

What do you have defined under Locations/Taxes-Zone Definitions?

I have just one definition: Country is 'United Kingdom', Zones is 'All Zones'.

I set this one up a few days ago (it was after 'installing' the UK zones module). The only option in the Zones pull-down menu is 'All Zones'.

And if you go to Locations/Taxes-Zones, and find one of the entries that was added i.e. one of the 90 Counties, and edit it, what entries does it have?

Ah, that's the problem: Locations/Taxes - Zones only shows the original 189 that came with v1.3.7.

After installing the UK zones 1.0 my database now has 279 rows (ie the original 189 plus the new 90). But only the original 189 are displayed in Locations/Taxes - Zones, I can't see the new 90 anywhere.

(many thanks for your time and assistance with this - it is greatly appreciated)

Hmm, a bit of inspection of the database table with phpMyAdmin may be in order. It could be something as simple as the fact that they lack a country code.
Also worth checking the Countries in Locations/Taxes, and double check that the United Kingdom ISO codes are GB and GBR, NOT UK.

Once you get them visible, be sure to set your shop zone in Configuration - My Store or Config-Shipping (One or the other) or moe misery will surely follow

Aha, thank you, now I am starting to get somewhere.

I managed to find my way into the MySQL table and the new 90 rows (that should have been the UK counties) are empty: the zone_country_id is 0 for all of them and the zone_code and zone_name fields are all blank.

I edited the first blank row to country id = 222, zone code = Avon, zone name = Avon and magic, they appear in the Location/Taxes pull-down.

I could do this manually for all of them, using the data from the UK zones 1.0 text file, but I can't help thinking there must be an easier way.

Do you know of any easier way of loading the information into the blank rows?

It's called the SQL update table command I believe, but that is not going to help you if they are blank/all zeros. i.e. you have nothing to update.

If you are feeling brave (after doing a database backup!) you could delete the zero country code entries

DELETE from zones WHERE zone_country_id = '0';

but I would strongly suggest a better course of action would be

1. Backup database.
2. Run the Counties patch again, and view the database to see if it has 'stuck' this time. If you ran it from Admin last time, perhaps use phpMyAdmin this time?
3. Backup the database.
4. Consider deleting the zero value rows as above.

Looking at the SQL file, the only comment I can make is that the quotes round 'zones' are not necessary. i.e.

INSERT INTO zones
vs
INSERT INTO zones

Not sure that it makes any difference, but everything else there looks fine.

Great, many thanks for the advice.

Just a very quick question - I'm sure it has a simple answer but I can't seem to find it anywhere - how do you backup the database?

Go to Downloads at the top of the page, Admin Tools, and get the backup MySQL plugin.
Unzip and copy it into your store - keeping the same folder structure obviously. It adds 3 files into 3 different folders in /admin/includes and you will find it under Tools in Admin when you next login to your store Admin under Database Backup-MySQL.
it gives you the option of backing up to the Admin/backups folder or direct to your machine.
On many systems you need to select the SKIP Lock option, or you get errors.

Rgds

Brilliant, thank you very much for all your help, I am extremely grateful. Have a nice weekend.

I have now sucessfully installed the UK zones and I have been looking at the counties it contains.

Some counties are missing: Bristol, Tyne & Wear, Swansea immediately spring to mind.

I downloaded and checked the other UK counties files and they are the same. So maybe its me!?!

Can anyone tell me if I have missed a trick somewhere?

You strike at the very heart of major political squabbles Neaty. Someone, somewhere decided that counties were a relic of our shameful history and must be abolished. But no one listend, as people like counties. In the ensuing battle, there was much realigning and renaming, and since officially, they don't exist, no agreement as to what is, and what isn't.
If you download the 'Big Royal Mail' contribution, and look in the Docs folder, Philip has a fairly good summation of the state of play in the ukzr.pdf file.

Thanks Chuckl, you're a star. That file has all the info in it that I need.

Now I will create a UK counties list with everything in it, including Jersey, Guernsey, Alderney, Sarn and Herm.

Sorted at last :clap: