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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

International Shipping Rules setup

Thread began 2/07/2013 10:18 am by Christopher West | Last modified 2/08/2013 11:34 am by Christopher West | 572 views | 3 replies

Christopher WestCommunity Expert

Hi Jason, I am still a little stuck on the recordset query, so just need an example to work on if thats possible. also if I am creating this recordset query to load in the correct shipping value based on country zone, delivery type and total cart weight then what would I need to put in for the ecart shipping rules (since I wouldnt need to use the ecart shipping rules weights as this is already determined in the recordset query right?

so just to recap I need to know how to create a recordset query based on the CountryLocationZone, ShippingOptionsType & ecart Total cart weight.

Also in the table for shippinglocation I have added an extra field called "ShippingCode" that will pass the country code to paypal (eg GB, US, FR etc).

and currently on my checkout page I have used a simple recordset to load all values of shippinglocation table to show all counties for the customer to select and a second recordset to load all values of shipping options so that UK customers can select which delivery type they want. it would also be nice to only display shipping options if a customer selects UK fromt he dropdown menu.

But first would like to get the recordsets sorted first.

Ived included the checkout.php files * a copy of the shipping tables in the database for reference. it be great if you could let me know how to construct the recordset to query what i need from the 3 tables. plus what shipping rules i need to create in the ecart object?

Regards

Chris

Attached Files
checkout.zip
shippingtables.txt

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