UK zones (paypal compatible) 1.0

[neaty]

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!)

[Chuckl]

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

[neaty]

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.

[Chuckl]

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

[neaty]

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'.

[Chuckl]

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?

[neaty]

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)

[Chuckl]

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

[neaty]

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?

[Chuckl]

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.