[Old] Royal Mail Modules

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

Quote:

---

Originally Posted by 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

Quote:

---

Originally Posted by 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:

Quote:

---

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

Quote:

---

Originally Posted by 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!!