[Old] Royal Mail Modules

[bouncingltd]

The latest version with JSR's modifications and an improvement to the UK courier shipping module has been submitted and should shortly be available from the downloads section, but as normal it is also released here:

http://bouncing.org/big_royalmail_v2.1.zip

Thank you for spotting that JSR and this thread has temporarily stopped sending me notifications of new messages, so thanks Pixxi, I did exactly the same as you.

[pcmt]

I'd like to congratulate the author and other contributors for this excellent module. I'm in the UK and wanted a regional split to reflect courier rates. This does it. A big thanks.

One thing I've noticed, though (on a test site), is that when someone registers, the drop down menu lists shows each county twice, and I think I see why in the optional county install sql file. All the UK counties are entered, and then entered again for the regional splits.

Is there a particular reason for this? Is there a way I can take out those duplications? (Arran actually appears four times in the drop down).

Patrick

[bouncingltd]

Ahh, now the problem with that is that maybe the instructions weren't totally clear, you should only have installed the SQL if you didn't already have any of the regions defined, so at some point you must have. Now you'd have to remove them all which is a bit tricky, what I can probably do is write a SQL patch to uninstall all of the zones my sql puts in and any duplicates, and then you can re-install the patch if necessary.

I'll be back later.

[pcmt]

Thanks for that. But I didn't have any of those zones defined previously. I think it's the optional sql file that comes with Big Royal Mail - it inserts each county once for the Region (eg Wales) and then once again for the whole UK.

Patrick

[bouncingltd]

Is there a particular reason for this? Is there a way I can take out those duplications? (Arran actually appears four times in the drop down).

Patrick

Hmm, well if Arran appears fours times it's not from my sql because I only have it in there twice, unless it's been processed twice by zen-cart when it was installed. now I have "Bute (islands of Arran and Bute)" in my zones file five times, yet it never appears because they are not linked to a valid county (I did a lot of installing while testing this and this is on my live server of all things). What I suggest is that you do this:

select * from ZONES where locate('Arran', zone_name);

this will give you some countries_id so then you go:

select * from countries where countries_id in (311, 293, 320, 329, 302);

to check if the countries are valid, the select on box on my live server actually doesn't display Arran in anything other than United Kingdom, because I've cocked up and forgotten to put it into Scotland. This is when I am not logged in, at http://Lenscaps.eu when one is logged in, it takes one's address so doesn't do the estimate thing, although if I specify different address it doesn't give me a drop down at all. Though it does reject if I put in Middx as a county and then offers me a drop down, once again with no duplicates. I suspect that something went wrong when the SQL patch was installed more than anything.

[pcmt]

I think the duplicate entries in the registration counties drop down are because the sql file in the Big Royal Mail download inserts the counties both as UK counties and as UK Regions counties (can't see anywhere why Arran should appear 4 times).

(BTW I installed Big Royal Mail on a brand new Zen Cart install today, and none of those counties would have been present).

Is there a need for both UK counties and UK Regions counties? Can the UK counties be deleted from the database, leaving only the Regions counties?

Thanks for the sql tips - a bit beyond me though.

Patrick

[bouncingltd]

The set up for the xones works like this. Select "United Kingdom" and attach the regions to it in case the user chooses that they live there rather than in England, Scotland etc.... then Select England and attach the English regions, Select scotland and attach the scottish regions. So they need to be attached twice, once to the UK as a whole, once to the subset of regions. I strongly suspect that your SQL file was processed twice by zen cart for some unknown reason. I suspect this because you said that you have the regions twice in the select box, but Arran four times, and since it's only twice in my sql.... Put an item in your cart, select England and click update. You should have "Avon, Bedfordshire, Berkshire" in the "state" drop down list, if they appear more than once then the sql file was processed twice, if you have non-English counties then the file has gone wrong someone where and attached the regions to the wrong zones.

[pcmt]

Thanks for that. My sql command (in phpMyAdmin) must have run twice. In Zen Cart Admin Zones I do see the duplicates. Can I simply go through each and delete the duplicates?

Patrick

[bouncingltd]

Hmm, yes I believe so, but it's a little time consuming, you could use phpMyAdmin to speed things up. Each region should be attached to a country, as the United Kingdom is set up as country 222 by default in ZC, you could issue a statement

DELETE FROM zones WHERE zone_country_id = 222

then you need to find the country id's for Northern Ireland, Scotland, England, and Wales by

SELECT countries_id, countries_name FROM countries WHERE countries_name IN ('Northern Ireland', 'Wales', 'Scotland', 'England', 'ROI Republic of Ireland', 'Isle Of Man', 'Channel Islands');

and then issue the DELETE statement above with the country id's then issue this statement

DELETE FROM countries WHERE countries_name IN ('Northern Ireland', 'Wales', 'England', 'Scotland', 'Isle of Man', 'Channel Islands', 'Kosovo', 'Montenegro', 'Serbia');

DELETE FROM address_format
WHERE address_format = '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country' ;

this should get you back to a normal ZC default installation, you could run the install sql again. This way is cleaner in it's removal of the zones, BUT it is obviously a little more dangerous.

Sorry it's so long winded but this is a little larger than what a normal person would be involved in, and probably is in the realms of paying someone lots of money, hey that's an idea, do it and then pay me loads !