Set Shipping Costs By Zone

Ive been looking for a while now on how to do this.
I need to set shipping costs by weight.

But I need to add multiple options for vaious countries, I have added these to the database in the following format.

I added a zone ID to the Country table, then added a new table and created zone prices.
Eg.
Zone 1 100grams = £10.95
Zone 1 200grams = £15.95
and so on.

The same for all the other zones (6 zones in total) The relavant countries will be linked with the correct zone.

What I need to do is know how to set this up for the checkout, but this also needs to be managed from the admin area so has to come from the MYSQL database so the clients can update this as prices change.

Hope this makes sense to someone, technical details of the site are PHP and MYSQL.

Please ask if anything needs explaining to understand this or advise on simple ways to do this, alternatively is there an ecart manual that describes advanced shipping modules the getting started guide is very basic.

Jamie Jackson
2J design

On the confirm page, add a recordset that is filtered by the zone and weight to return the correct charge.

Then set a session variable from that recordset result.

You can create a shipping rule to charge the amount stored in the session variable as the shipping charge.

ok, would this show on the checkout summary page?
Also i dont think ive set a session varible before from a recordset is this easy to do?

Really you could add it and/or show it on any page you want.