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?

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"

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.

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?

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?

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"

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.

that shouldn't matter to the shipping.