View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

setting up different shipping cost depending on dimensional weight and zones

Thread began 1/08/2010 4:10 am by teethirty | Last modified 1/14/2010 5:50 pm by teethirty | 1217 views | 6 replies

Eric Mittman

You are on the rite track, the table for the cities and zones looks good. There is a problem with the way the weight classes and zones table is setup though. Rather than have columns for 1, 2, 3 with the prices in them you should instead have the columns like this:

weight_class, zone, price

The table will hold the same amount of info but it will have a unique record for each weight class and zone combination. When the rule is created you will have some custom code on your confirm page that will do the following:

The first thing you do is filter a recordset on the user entered city and store the zone for that city in a session variable. Next you will calculate your dimensional weight and store that result in a session variable. Finally you will have another recordset that will search your new weight_zones table that will be filtered on the zone and dimensional weight stored in the session variables. This will give you the shipping cost that you can store in a session variable.

The final part will be to create a shipping charge rule that will apply a flat rate shipping based on the value of this shipping cost session variable.

There is another part of this that needs to be addressed also, is this weight based on a per line item basis, or do you multiply based on the quantity. If you multiply based on the quantity then you should add a new calculated column to your cart for total dimensions. This will multiply the dimensions column you added by the quantity to give you a total dimensions for that item.

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...