Thanks, will try it. Also, l I don't know why but now none of my https pages (customer login, checkout etc) are working. I had made a few changes to the shipping_estimator.php file, but I have reuploaded the original one, so any changes should be overwritten.

I can't login as the admin page is https, and customers can't login either.
I have an ssl certificate from comodo.

Changed the tare things, but it made no difference.
https pages are working, so that's good.

Good to hear that you have the entropy back under control!
Time to check the overall setup then. Under Locations/Taxes-Zone definitions do you have a United Kingdom Zone defined, showing as a fodler symbol, and when you open that folder, does it show as all zones, whith a dropdown list of counties?
Under Configuration-Shipping Packaging is the store Country set to United Kingdom, and does it have a store zone and postcode defined?

Zone name:
UKZR: Zone 1 Mainland UK

Zone Description
All other UK counties

it has a yellow light next to it (Zones Defined but not Taxes )

Under "edit zone" it has:
Zone Name: UKZR: Zone 1 Mainland UK

Description: All other UK counties

It has a dropdown list of counties, but some are duplicates, like Arran (Island of) appears 4 times, and most things appear twice.

I don't have the postcode for the shop, but even when I have added it, nothing changed. I can't see an option for store zone to be defined.

In my tpl_modules_shipping_estimator.php there is this code:

Those are the exact same words that display when a quantity of 4 is chosen:

TITLE_NO_SHIPPING_AVAILABLE
TEXT_NO_SHIPPING_AVAILABLE

Is this file the problem?

Many thanks for your help.

Zen Cart usually whinges mightily if you don't have a postcode defined (not that it does anything as far as I can see).
Shop location is in Configuration-My Store, items 3 & 4 I think.
If you are still seeing those constants in the output, you most probably have overrides active, i.e. multiple copies of the files. Please check /includes/languages/english for a folder with the name of the template you are using i.e. /includes/languages/english/your_template, and check it for copies of shopping_cart.php. ANy copies of the file that you find should have the following near the bottom:
// big royal mail modifcation 10-10-2006

define('TITLE_NO_SHIPPING_AVAILABLE', 'Not Available At This Time');
define('TEXT_NO_SHIPPING_AVAILABLE','<span class="alert">Sorry, we cannot calculate your shipping COUNTRY at this time.</span><br />Please contact us so that we can arrange a quote tailored especially for you.');

I tried the above, but to no avail, but profuse thanks for your suggestions.
I think the problem is in the sql thing. This is what I have for the orders_total ID:

The price for 1 is £3.50 , so can I remove some of these?

Not quite sure what you're asking..., but the Order Totals display is set in Modules-Order Totals. You can switch items on and off, and the sort order dictates in which order they appear.

Shipping module problems are usually traceable to incorrectly set up Zones or store location, not helped by the fact that it is easy to get them wrong. In earlier versions of Zen Cart a favourite trick was to use UK for the country code, when the ISO code is in fact GB. Hours of harmless fun to solve.

There is a PDF file in the Big Royal Mail docs folder called UKZR or similar, which has quite a good discussion on the subject.

It is also important not to be too restrictive on the settings when you are testing/fixing. Do not set max weights or prices that are too close to your cart price or max shipping weight. The trick is to get a 'wrong' display so the fix can be deduced from it. So set the max value to 500, and add a line like 20:20 to the shipping rates, so the problem can be isolated.

In trying to identify your 4 items problem, the only way I could get anywhere near it was by having the store location in My Store in the United States, and the customer in the UK, or not defined.

Hi,
I also noticed that my 1st class recorded large letter pricing for 190g comes out as £2.10 when it is supposed to be £1.40. I have these shipping rates:

0.1:1.18

0.25:1.40

0.5:1.68

0.75:2.12

This is because 70p is added automatically as insurance. Can I just set 0:25 to 0.70, that way when the 70p is added, the total will equal £1.40?

I've no idea where those rates are coming from?
The signed for rates have a constant defined in e.g. /includes/languages/english/modules/shipping/rm1stlargelettersf.php that simply adds 70p to the standard large letter rate.

Sorry,
I got them from modules>shipping.

Hi - I have just registered here - so go easy :blink:
I have been "playing" with the cart for a few days now - I have installed the Royal Mail Module which is great ! - except for one problem - which may have been answered elsewhere - but I cannot find it if it has !
The problem is the "mixing" of Kg and Lbs....
When entering product weights - there is no choice as to what units are used ? they are entered as Lbs ? (unless I am missing something)
However - Royal Mail shipping weights are in Kgs ? - so on the checkout - there is a mix of units...
Is there any way to set "Global" weight units that will work throughout the cart ?
Thank you - and sorry if this has been answered before - I have found "snippets" relating to it - but no really complete answer....:unsure::unsure:

Two birds with one stone -

Wadi73, the Large letter signed-for rates should normally be the same as the Large letter rates when viewed in Admin-Shipping, as the cost of the additional service is added separately, so yes, you can edit them to be the same.

Vinyl Signs, As long as we are talking about a 'Unit of Weight/Mass' then you simply need to edit /admin/includes/languages/english.php and /includes/languages/english.php, and change every instance of lbs to Kgs.
This would imply that you have entered any product weights in Kgs. but they are displaying as lbs. If however you have carefully converted them, then it's undo conversion time.

Chuckl:

This would imply that you have entered any product weights in Kgs. but they are displaying as lbs.
Not sure I fully understand :blink:
When I enter product weight - I don't get the option of entering lbs or kgs - am I to assume that after I replace every instance of lbs to Kgs in those two files - then the cart will assume that "ALL" weights (anywhere in the cart) are in fact quoted in kgs ? and integrate with the Royal Mail "kg" calculations ?
Chuckl:

If however you have carefully converted them, then it's undo conversion time.
Again - Not sure I fully understand :blink:
Is there a way to "convert" the units ? - I don't think I have done anything like that ! :unsure:

Chuckl:

Wadi73, the Large letter signed-for rates should normally be the same as the Large letter rates when viewed in Admin-Shipping, as the cost of the additional service is added separately, so yes, you can edit them to be the same.

Thanks a lot Chukl, will do so.

Vinyl Signs, you are correct. When you enter a weight you do not get a choice of units, because there aren't really any. You decide elsewhere whether the numbers you entered should have lbs. or kgs. or grams or whatever after them. Zencart makes no attempt whatsoever to reconcile weights between measurement systems.
If, when you entered a product weight as you 'saw it on the pack' - 0.5 somethings that I will decide later are kgs. then you are fine. if you carefully converted it to lbs., you'll have to re-enter the weights.

Chuckl:

Vinyl Signs, you are correct. When you enter a weight you do not get a choice of units, because there aren't really any. You decide elsewhere whether the numbers you entered should have lbs. or kgs. or grams or whatever after them. Zencart makes no attempt whatsoever to reconcile weights between measurement systems.
If, when you entered a product weight as you 'saw it on the pack' - 0.5 somethings that I will decide later are kgs. then you are fine. if you carefully converted it to lbs., you'll have to re-enter the weights.
Thanks for that - I thought that there may have been some sort of "conversion" process built in somewhere - but obviously not !
As long as you have kgs programmed "throughout" - the pricing from the RM will still be accurate - as the "prices" are "per" whatever unit you have set in your system ?
Thanks again - still have a lot to learn :huh::huh:
(Sure I will need to return later - when I find the next problem ! :laugh:)

I removed some of the values in the order_id table, but now I need them back.

I basically need the one that says order_total (3rd one down), but it needs to be 3.50

International Royal Mail options cause errors

I'm 3/4 finished setting up new 1.3.7 store for a client and Ive come across a strange problem when enabling any of the international options in the Big Royal Mail module.

Whenever i enable any of the following options, the site will work fine for the first page impression but subsequent impresions simply displays a page with a mysql error message or the page whith only so much of the markup turning up.

Royal Mail Airsure® "Small Packet"
Royal Mail Airsure® "Small Packet"
Royal Mail International Signed For®
Royal Mail International Signed For®
Royal Mail Airmail "Small Packet"

Working fine
[img=http://img228.imageshack.us/img228/4738/internationalworkinglf9.th.png]

The causing an error
[img=http://img243.imageshack.us/img243/9904/internationbrokeaq4.th.png]

Its like the script stops the constants being read.

Any ideas?

This is a limitation of the standard cache_data column size in all versions (AFAIK) of zen up to and including zen v1.3.7.

See post 299 (in this thread, above) for an explanation.

See also the bug report here:

http://www.zen-cart.com/forum/showthread.php?t=56436http://www.zen-cart.com/forum/showthread.php?t=56436

The fix is to run this SQL statement on your database via phpMyadmin:

# change cache tracking size
TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;

Or to change to file-based caching in your configure.php files.

Pixxi:

This is a limitation of the standard cache_data column size in all versions (AFAIK) of zen up to and including zen v1.3.7.

See post 299 (in this thread, above) for an explanation.

See also the bug report here:

http://www.zen-cart.com/forum/showthread.php?t=56436http://www.zen-cart.com/forum/showthread.php?t=56436

The fix is to run this SQL statement on your database via phpMyadmin:

change cache tracking size

TRUNCATE TABLE db_cache;
ALTER TABLE db_cache CHANGE cache_data cache_data mediumblob;

> 
> Or to change to file-based caching in your configure.php files.



100% fixed. Many thanks Pixxi :)