Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Database driven shipping

Database driven shipping

Thread began 10/05/2010 1:15 am by Badger | Last modified 11/04/2010 6:58 am by Badger | 4203 views | 32 replies

10/20/2010 11:44 amBadger

Just for clarity - then the shipping rates table has 246 rows, one for each country? I've created that table but in doing so I'm thinking that will need a lot of work to update shipping costs.

How about 2 tables:

1. ShipCountryZones which list the 246 countries with columns for country 2 letter abbreviations and the zones as a key column

2. ShipZoneRates with the 9 rows for zones and columns for Zone Base rate, Zone Increment and Zone fuel surcharge

I would then INNER JOIN the look up recordset with the two tables, the main table being ShipCountryZones and the child table being ShipZoneRates.

Would that work?

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.