Shipping price based on total price

I want to base the shipping cost on total price sans tax.
Using eCart 4.52 I successfully created the first rule for a shipping cost of $6.95 for a cart value of $50.00 or less.
I than created a rule for a shipping cost of $8.95 for cart values greater than $50.00 and less than $100 which is ignored.
I've attached 2 screen shots of the parameters for those rules.

intuhorses

Thanks
Mick

PS Now when I view cart using the "View Cart" link at the top of the page cart.php I get
"PAGE NOT FOUND

We cannot locate the page you're looking for. Please check the address and make sure all letters are lowercased with no spaces. You may also move to a different page by using the links in the menu bar above."

If I simply hit the reload icon in the address bar (Safari) I'm taken to the cart.

I made some changes to the second rule (50to100) that seem to work. I've attached a screenshot.

Your comments as to whether I've approached this correctly (never done this before) would be appreciated.

The problem of the cart not displaying via the view cart link is extant.

Mick

I've managed to create all the rules for standard shipping prices. And they seem to work.
Now I need to create some exceptions for certain products; the artwork we sell and products that are drop shipped.

I am at a loss as to how to proceed.
Help please.

Yours
Mick

PS would eCart 5 over any substantive advantage for what I'm doing here?

see this thread for details:
showthread.php?t=12439

Jason

Confusion abounds.
Looked over the link, attempted to follow along but got very lost along the way.
need more please.

Regarding what I have done.
Does it look ok to you?
And would eCart 5 make this any easier?

Mick

Yes, what you have done so far looks fine to add shipping based on the total price, but will need to be modified in order to exclude items from the shipping.


in order to exclude items from the shipping cost, you need a new column to mark which item should be included and which items that should not be included.

in the thread I linked to, you create a new column named freeShip.

Items that should not be included in the shipping cost will be given a value of 1 in the add to cart button, items that should be included in the shipping cost are given a value of 0.

you then need to use the subtotal of items where freeship has a value of 0 in the shipping cost calculation.


which specific part of this are you having trouble with?

without knowing where you are getting lost, all i can really do is reiterate the description of the process. If you let me know which part of this does not make sense i can do a better job of addressing the cause of the confusion.

No, eCart 5 will not simplify this, it will be done exactly the same way in EC5 as in EC4 (or even EC1, 2 and 3).

"in the thread I linked to, you create a new column named freeShip.

Items that should not be included in the shipping cost will be given a value of 1 in the add to cart button, items that should be included in the shipping cost are given a value of 0."

In my case there are 2 classes of items that are different.
Fine Art Prints which is category ID=53 would carry the same shipping but would include a variable insurance cost based on total cost.

Drop shipped items would carry a specific shipping cost.

So the new columns would be something on the order of - fineArt - and - dropShip - or somesuch. Yes?

"Items that should not be included in the shipping cost will be given a value of 1 in the add to cart button, items that should be included in the shipping cost are given a value of 0."

Does this mean that these parameters would be applied to each and every rule regarding shipping cost?

Lets start there and I'll ask more as necessary.

Mick

With more than one shipping type scenario like this, it would be better to create a column called ItemType.

you could set the item type value to be "Regular", "FineArt" or "DropShip"


each shipping rule that you create , you would need to reference the ItemType column so that it only applies to the intended item type.

you do this by using the "Number of Items With A Specific Column value" trigger

and the "Based on items with a specific column value" calculation options.

Sounds like a plan

I need urgent assistance with another problem here
showthread.php?p=108498#post108498

Mick

Still a bit confused.
My assumptions are:
1. I would create a column in the db, "ItemType" and each and every product in my db would carry this definition.
2. I would assign values to the types i.e. regular=1, fineart=2, dropship=3, wonpad=0 etc.
So in the case of WonPad the rule in the first attachment would apply.
If so, does the calculation as illustrated mean that 1 item type=0 would incur $15.50 shipping and 2 would incur $31.00 shipping etc.?
The second attachment would define shipping cost for standard items with a total cost of $50.00 or less.

If true does this also mean that 1 item type=1 @ $45.00 and 1 item type=0 would incur a shipping cost of $15.50+$6.95?

Right so far or do I have it all completely wrong?

Yours
Mick

I'd probably create calculations to get the total for each type like:

Type1Total = (([ItemType]==1)?[TotalPrice]:0)
Type2Total = (([ItemType]==1)?[TotalPrice]:0)
Type3Total = (([ItemType]==1)?[TotalPrice]:0)
Type4Total = (([ItemType]==1)?[TotalPrice]:0)

Then you could add rules based on the totals of each type individually.