close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Combining shipping options

Thread began 3/29/2011 10:15 pm by david73021 | Last modified 3/30/2011 10:49 am by Jason Byrnes | 832 views | 1 replies |

david73021

Combining shipping options

Can anyone please help. I have no problem adding my shipping costs from the database i.e. a stove costs 25 to ship and a stove liner costs 14.99 and a stove fitting costs 6.99 to ship. The problem comes that due to the heavy weight each of these costs also vary so not only do the products vary due to type but also due to area.

What is the best way to combine both factors as the only way I can see to do it is by having a session value that if not set forces the client to first register so I can then use:

SELECT cost FROM shipping WHERE category = 'stoves' AND country = 'country value from registration'

In summary is there a clean way to make shipping work on two factors, different weight values in combination with different shipping areas.

Hope someone can help as my current solution is untidy.

Thank you in advance, Fully

Sign in to reply to this post

Jason ByrnesWebAssist

Since you want to calculate the shipping on the country it is being shipped to, you will need to use a database like you suggest. You don need to force registration though, the shipping country is stored in a session variable when the checkout form posts to the confirm page, so you can use the eCartCheckoutForm_shipping_country session variable in the shipping rate lookup recordset, store that shipping rate value in another session and use that session in the shipping charge.

Sign in to reply to this post

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

Content

rating

Layout

rating

Ease of use

rating

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