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