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

Shipping price based on total price

Thread began 8/22/2011 3:26 pm by mick106153 | Last modified 8/29/2011 3:04 pm by Ray Borduin | 1735 views | 9 replies |

mick106153

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

Sign in to reply to this post

mick106153

Exceptions to the rules

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

mick106153

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

mick106153

"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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mick106153

Sounds like a plan

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

Mick

Sign in to reply to this post

mick106153

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
loading

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