close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Shipping Calculations

Thread began 3/08/2012 12:39 am by lr_leal239405 | Last modified 3/08/2012 6:29 pm by Jason Byrnes | 645 views | 7 replies |

lr_leal239405

Shipping Calculations

I'm not sure I understand what to put in eCart object to calculate the shipping the way I want it to. I have 8 items in two columns for a total of 16 items. One column is called DVDID and the other CDID. I need to tell the shipping that if any items in the cart from either of those columns is 2 or less, the price for shipping is this much. If the items from any of those two has a quantity of 3, then it's this much, if 4, this much etc. all the way to 10. Anything above 10 is equal to this much x 1% of the total. How to do that?

Sign in to reply to this post

Jason ByrnesWebAssist

you need to have a column in the cart object to set the type of item. For example sake, lets call the column itemType.

In the add to cart button set the value of the itemType column to either CD or DVD depending on the item.

on the shipping tab, you will need to create a shipping rule for each itemType condition. for example:

2 or less DVDs
Trigger:
"Number Of Items with a specific Item Value"
If the Total number of items where "itemType" has a value of "DVD" is "<=" "2"

Calculation:
Flat Rate of "x"

the other calculations will follow the same principle, changing the itemType, quantity you are testing for, and the flat rate charge.


for the more than 10 charge, you will change the calculation slightly:
more than 10 DVDs
Trigger:
"Number Of Items with a specific Item Value"
If the Total number of items where "itemType" has a value of "DVD" is ">" "2"

Calculation:
"based on multiple of column subtotal"
Subtotal of column "TotalPrice" "times" "0.01" "plus" "x"

Sign in to reply to this post

lr_leal239405

ok, but can I say:

"Number Of Items with a specific Item Value"
If the Total number of items where "itemType" has a value of "DVD" OR "CD" is "<=" "2" ??

I added "OR 'CD'" to the above. So I want to apply the exact same shipping cost to both columns at once. But it has to be if either or is in the cart, because, of course, sometimes the orders will just be for CD and sometimes for just DVD.

Thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

no, you can add an or statement to the trigger like that.


so dvds and cds get treated the same for shipping, that wasn't clear in the original question


will there be other item types? that have different shipping rates?

or is this store only dealing with dvds and cds?

Sign in to reply to this post

lr_leal239405

Yes, there will be other items with different shipping rates that don't come from the same database. I was going to ask that as well. Will it cause conflict? Is there something I need to know?

Sign in to reply to this post

Jason ByrnesWebAssist

ok, so if cds and dvds get treated the same, then in the itemType column, set the value for both dvds and cds to the same, something like "media"

the idea is to have a common value that is used to tell the cart to apply the shipping rule.

in the shipping rule, you can then use this instead:

"Number Of Items with a specific Item Value"
If the Total number of items where "itemType" has a value of "media" is "<=" "2"

Sign in to reply to this post

lr_leal239405

Well, they get treated the same as far as shipping costs, but not pricing and descriptions of course. I'll give it a shot and see if I can get it to work.

Sign in to reply to this post

Jason ByrnesWebAssist

that shouldn't matter to the shipping.

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