5 replies to this topic

[workuseonly04]

Sorry if I'm starting too many different topics. Trying to be active here, hopefully more people will be active and come here.

Anyway, our shipping charges are based on order total but we do have some items that are oversized and must have their own individual shipping charges. The problem is, that the oversized items are counted towards the order total as well as their individual charge, making the total shipping charge incorrect.

Does anyone know if there is a way to exclude products with their own shipping charge from the order total?

Cheers

[malaize]

Hi workuseonly04,

We have a similar setup where we charge shipping based on the dollar amount ordered for most of the items we sell. ex.

$10-$99 $5.95 shipping
$$100-$200 $6.95 shipping
etc.

Here is how our setup works.

Customer calls to place an order. We enter the items into MOM that the customer wants to buy. If 1 of the items is a large item that we charge actual shipping for we look up the cost to ship that item in our UPS rates book or go to USPS's website to calculate shipping. We then figure what the cost of the other small items is. If the small items cost totals less than $99 then we charge $5.95 plus the actual cost of the shipping for the large item. So say the large item costs $15.00 to ship. We then manually enter $20.95 into the shipping field. This all sounds like a lot of work that would tick off a customer, but it really doesn't take long at all. Our phone people are very good at it. I hope that makes sense. Sorry if it is confusing.


malaize

[workuseonly04]

We actually have the exact same setup. And you're right, it isn't difficult and doesn't take up much time. But if you want to automate processing of internet orders, it can't be done if you have to manually change the shipping charges.

[workuseonly04]

Hi workuseonly04,

We have a similar setup where we charge shipping based on the dollar amount ordered for most of the items we sell. ex.

$10-$99 $5.95 shipping
$$100-$200 $6.95 shipping
etc.

Here is how our setup works.

Customer calls to place an order. We enter the items into MOM that the customer wants to buy. If 1 of the items is a large item that we charge actual shipping for we look up the cost to ship that item in our UPS rates book or go to USPS's website to calculate shipping. We then figure what the cost of the other small items is. If the small items cost totals less than $99 then we charge $5.95 plus the actual cost of the shipping for the large item. So say the large item costs $15.00 to ship. We then manually enter $20.95 into the shipping field. This all sounds like a lot of work that would tick off a customer, but it really doesn't take long at all. Our phone people are very good at it. I hope that makes sense. Sorry if it is confusing.
malaize

Did you ever find a work around for this problem? It's 2 years later and we're still doing it the same way.

[malaize]

Did you ever find a work around for this problem? It's 2 years later and we're still doing it the same way.

Hi workuseonly04,

Sorry I didn't see your response months ago. lol We are still operating the exact same way in regards to how the table based shipping and exact shipping charges work. Unfortunately when a large item is ordered along with the smaller items that use the table based shipping, the larger item's price is still counting towards the basket total and then the shipping charge.

cheers,

[nickhncs]

Hi workuseonly04,

We have a similar setup where we charge shipping based on the dollar amount ordered for most of the items we sell. ex.

$10-$99 $5.95 shipping
$$100-$200 $6.95 shipping
etc.

Here is how our setup works.

Customer calls to place an order. We enter the items into MOM that the customer wants to buy. If 1 of the items is a large item that we charge actual shipping for we look up the cost to ship that item in our UPS rates book or go to USPS's website to calculate shipping. We then figure what the cost of the other small items is. If the small items cost totals less than $99 then we charge $5.95 plus the actual cost of the shipping for the large item. So say the large item costs $15.00 to ship. We then manually enter $20.95 into the shipping field. This all sounds like a lot of work that would tick off a customer, but it really doesn't take long at all. Our phone people are very good at it. I hope that makes sense. Sorry if it is confusing.


malaize

Hi, I want to try this, but I just have a question, how do you calculate the price the if you don't know the package's Dimensions, like I am selling clothing, if a customer order 30 shoes with 10 t-shirt, and want to know the shipping charge for the order with shoe boxes, and without shoe boxes? Also, where do you get the UPS rates book? Can you upload it? Thanks.