If your orders ars so light as to not need to make use of the individual weight tariffs within a shipping module then you can simply use the module and the min max order value, set your product weights to zero and bingo!
Most of my orders used to be less than 100g so all my shipping was by large letter 1st class (48p) - orders that exceeded £34 were automatically upgraded to special delivery. Things started getting complicated when the products exceeded the 25mm thickness dimension.... but that's another story!

Jonathan

Thanks Pixxi and Atomic Workshop

I've reached the conclusion that the thing to do is use the standard module and ignore the weights, much along the lines that AtomicWorkshop has suggested.

Now one further question, if I may, I have defined the four zones i.e. UK; Europe; World Zone 1; World Zone 2, and I have painstakingly added all the relevant two-letter country codes into each 'zone', set-uip a tax class, so that the zones are active.

The 'order' of those four zones (I,e, UK; Europe; World Zone 1; World Zone 2,) doesn't seem to bear any relationship to the shipping zones, which are simply numbered 1; 2; 3; and 4.

This may be a really, really, dumb question but how does the shipping zone know which shipping rate to apply?

What shipping module are you using?

Hi.

I've tried trawling through everything trying to place my problem, without great success.
My query is:

I'm using ZC 1.3.6, so I've downloaded the appropriate version of BRM (2.1.1)

• I'm responsible for a site which was already running, and can't take the time, (unless essential) to upgrade.

2 questions:

1. Is this updated with recent RM updates?

2. I'm trying to use 'Royal Mail Airmail - Small Packet'
   I've done all the uploads I think I need to, but it's regularly crashing virtually everything

Warning: Variable passed to each() is not an array or object in /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/interfa3/public_html/includes/functions/sessions.php on line 102

Warning: Cannot modify header information - headers already sent by (output started at /home/interfa3/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/interfa3/public_html/includes/init_includes/init_templates.php on line **78

**on a category page, for a start.

The implication, I think, is that I need to update mysql, or run database updates.

Any ideas?

Thanks very much in advance

AtomicWorkshop:

What shipping module are you using?
Hi

AFAIK I am not using any shipping module other than that which is included in the Zen Cart 1.3.7.1. standard installation, but I think I have answered my own question about how the country etc. is determined.

Blag,

The standard 'Table Rate' shipping module looks as though it will do all you want

Gladys_Pym:

1. If you have the latest one from the downloads section, it should be - Kelvyn updated the rates that came in force this April.

2. See post 359 above.

Thanks, Pixxi

I've looked at 359, and that's exactly what I need to do.
The question is; how?
I'v taken over the site mainly to so mods on the layout/functionality etc.
How do I

"run this SQL statement on your database via phpMyadmin"

Sorry. I'm not a complete noob, am not asking for a massive hand-holding exercise, but would appreciate a pointer as to where to start. I'm hoping I'll never need to do this again, so a simple 'how to' would be great.

Thanks, everyone.

Great software, great forum.

glad to be Glad

Gladys_Pym:

Thanks, Pixxi

I've looked at 359, and that's exactly what I need to do.
The question is; how?
I'v taken over the site mainly to so mods on the layout/functionality etc.
How do I

"run this SQL statement on your database via phpMyadmin"

Sorry. I'm not a complete noob, am not asking for a massive hand-holding exercise, but would appreciate a pointer as to where to start. I'm hoping I'll never need to do this again, so a simple 'how to' would be great.

Thanks, everyone.

Great software, great forum.

---

glad to be Glad
Gladys_Pym

It might be easier for you to run this mySQL query via your store admin.

Copy the query:

change cache tracking size

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

Now go to your store admin, and under the Tools menu you will see an entry for Install SQL Patches.

Past the copied text into the larger of the two boxes i.e the one entitled 'Enter the query to be executed:' and then press send.

After a few seconds you should see a message at the top of your screen telling you the outcome of the 'send'. If it's on a green background, you can assume that the process suceeded.

Bish, bash, bosh. Job Done.

If this fails then you would need to run the query via phpmyadmin, but I don't think that that will be necessary.

blag:

Gladys_Pym

It might be easier for you to run this mySQL query via your store admin.

Copy the query:

Now go to your store admin, and under the Tools menu you will see an entry for Install SQL Patches.

Past the copied text into the larger of the two boxes i.e the one entitled 'Enter the query to be executed:' and then press send.

After a few seconds you should see a message at the top of your screen telling you the outcome of the 'send'. If it's on a green background, you can assume that the process suceeded.

Bish, bash, bosh. Job Done.

If this fails then you would need to run the query via phpmyadmin, but I don't think that that will be necessary.
BTW I forgot to mention that you ought to backup your database first!!

Hi all,

I have just installed the big royal mail module and google checkout the latest version but the problem is that the google checkout doesnt pick up my royal mail shipping modules:( I get the not configured error and when i go to the shipping generator i get the following error:

Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 18

Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 61

apparently its a problem with the royal mail module if anyone has a modified version of the module please let me know :(

Thank you,

Hoda

Hello zenners,

Is there a quicker way of changing the things to work for grams? i have recorded all my products' wieghts as grams and thus have to change all the ratios in each of the shipping options i want to offer (which is them all so seems are plenty to change).

PECZ: Have you applied the fix to correct the bug in the Zen database?

See post 359 above.

Barricades: You'd need to either change all the rates in the Royal Mail mod to grammes, or (easier) change your product weights to kilos.

Hi Pixxi,

Thanks for the reply unfortunately I cant find in the forum any where saying to make any changes to the database. Please if you can guide me abit more is much appriciated.

Thank you,

Hoda

(Post 359 above (in this thread):

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.

You can also run the patch using admin->tools->install SQL patches.

PCEZ:

Changing the weights in english.php won't have any effect - that only changes the label (ie. 'lbs', 'kgs').

The shop doesn't know (or care) whether you're using pounds, kilos or Jaffa oranges for your weight unit - it only sees a numeric value.

At present you say you have your weights entered for each product in grammes.

For the RM modules to work as they are, you'll need to enter the weight for each of your products in kgs - eg. instead of entering '340' (grammes) you would need to enter '0.34' (or just '.34').

Sorry, my last post was meant for barricades :smile:

Pixxi:

(Post 359 above (in this thread):
You can also run the patch using admin->tools->install SQL patches.

Hi Pixxi,

I did run that patch but it still doesnt make any differnece. The royal mail module works fine with any other payment option except for google checkout apparently it needs to be modified somewhere to be compatible with google checkout.

Here is the error i get you can look again:

Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 18

Warning: Invalid argument supplied for foreach() in /var/www/virtual/pcez.co.uk/htdocs/googlecheckout/shipping_generator/multigenerator.php on line 61

and when I enable the google checkout module it says all of the shipping modules from big royal mail contribution have not been configured.

Thank you,

Hoda

Cheers guys... i've changed all my weights to kgs now. Took a wee while but prob faster than changing the modules individually.

AtomicWorkshop:

Is it possible to hide shipping options based on product size?

For example, most of my products are shipped in small Jiffy envelopes which fall within the Royal Mail 'Large Letter' size category. However, I now have products where the package needs to be shipped as a 'Packet' - is it possible to hide the Large Letter shipping option if a large product is purchased?

Thanks in advance,

Jonathan

I know this was first posted a while ago but i've read from it to the end and there is no more mention. So i was wondering if anyone had come up with a solution to this problem?