Shipping Weight calculated incorrectly - Not Tare Settings!

Hi there!

I have a shop almost ready to go, but then I noticed some of my products have been displaying an incorrect shipping weight.

Let me give some background.

I have a single product, but it is available in two different packages (cartons which add 3 lbs per item, and bags, which add 1 lb per item). In addition, there is a quantity discount for item counts 10-19 and another for item counts 20+.

So the way this is currently set up is:

Item 101 - Product in Qty 1-9, shipping weight 58 lbs each.
Item 102 - Product in Qty 10-19, shipping weight 56 lbs each.
Item 103 - Product in Qties of 20 or more, shipping weight 56 lbs each.

Right now, if I add item 101 to my cart, the weight calculates correctly, but if I add items 102 or 103 to my cart, the shipping weight for those items displays at 1/3rd the actual weight. So that 12 of item 102 weighs 223.999999 lbs, when it ought to weigh 672.

Where would something like this be controlled from? As far as I can tell, other than quantities and the shipping weight specific to the item, items 102 and 103 are set up just like item 101. I'm at a loss as to why this happens, but it greatly affects the shipping cost, as you can imagine, and allows the customer to select UPS shipping when really these items need to be shipped freight.

Thanks in Advance!

I don't understand.

You said you have one product which sells in two different packaging formats.
Then you talked about three products, Item 101, 102, 103, and you mixed quantities into those three products.

Can you be more specific about the scenario you have ?

Are there any attributes defined to these products?
What is the product-weight associated with these products ?

Sorry, I often overexplain and re-confuse what I'm trying to say. :wacko:

Let's just say I have three products, I'm mentioning the quantities in case it has some strange relationship to the problem.

101 (available in quantities of 1-9) weighs 58 lbs shipped.
102 (available in quantities of 10-19) weighs 56 lbs shipped.
103 (available in quantities of 20+) weighs 56 lbs shipped.

101 works fine, shipping weight calculates perfectly, but 102 and 103 calculate the shipping weight as (W x .33333333333), so I end up with strange looking, but more importantly incorrect, shipping weights as viewed in the cart.

Other than specifying their weight and pricing in the product setup, I haven't done anything special with them, such as special attributes, that I'm aware of.

Okay ... let's try this ...

In order to determine what could be causing it, I need to set up the same products in my own test store. How do I do that? I mean ... what exact steps did you follow to create these products in the first place?

• product settings on the product-entry/edit page
• quantity discount configurations
• any attribute details tied to these products
• shipping module settings
• shipping/packaging settings
• etc

Basically, what do I need to know in order to simulate this in another store?

For product "102" from above.

• product settings on the product-entry/edit page
  In Stock
  Product is... all three are "no"
  Taxable Goods
  Net Price: 178.2000
  Shipping address required
  No, Normal shipping rules
  Yes, show quantity box
  Product Quantity Minimum: 10
  Product Quantity Maximum: 19
  Product Qty Units: 1
  Min/Unit Mix: no
  Products Quantity: 1050
  Model: IP-550FB-10
  No image used
  shipping weight: 56
  Sort order 0

• quantity discount configurations
  None, the price is for the product and there are simply min/max settings applied

• any attribute details tied to these products
  None unless default

• shipping module settings
  UPS shipping (COC, domestic only), "Freight Collect" (modified storepickup setting)

• shipping/packaging settings
  Zip Code 06610
  Max shipped weight - 522
  All Tare settings: 0:0
  Display number of boxes & weight status: 0
  Order Free Shipping 0 Weight Status: 0
  Shipping Estimator Display Settings for Cart: 2

levbeck:

Display number of boxes & weight status: 0Quick question ... if you change this setting to 2, what happens ? Do the top and bottom totals match ?

NOTE: UPS cannot ship a 552 lb box ...

DrByte:

Quick question ... if you change this setting to 2, what happens ? Do the top and bottom totals match ?

No, but at least now the top is correct; the bottom is still doing the division thing.

I'm pretty sure the top value is what's being used in calculating available shipping methods, and the bottom number is just a display problem.

What version of Zen Cart are you using?

Ajeh:

NOTE: UPS cannot ship a 552 lb box ...

It's not a single 552 box, but a clarification that the other items are in bags that cannot be shipped unless using freight. Thanks, tho!

DrByte:

What version of Zen Cart are you using?

1.3.7, installed about a month ago.

Scratch the caution on Maximum Size Package ... it is USPS that will not quote over 70lb packages ... :smile:

levbeck:

No, but at least now the top is correct; the bottom is still doing the division thing.

The division is a result of the split between number of boxes required to accommodate the max-shippable-weight.

How do I deactivate that feature? When it's over a certain weight, I simply want to remove the UPS option during checkout.

Update:

The weights are calculated properly for quotation purposes.
The display in the estimator section is reflected incorrectly.

To fix the display problem, edit /includes/modules/shipping_estimator.php
in v1.3.7, go to line 235, and make the 4 changes shown:```
// altered to include Tare adjustment
// totals info
$totalsDisplay = '';
[B] $display_weight = $_SESSION['cart']->show_weight();[/B]
switch (true) {
case (SHOW_TOTALS_IN_CART == '1'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_WEIGHT . $[B]display[/B]_weight . TEXT_PRODUCT_WEIGHT_UNIT . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '2'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . ($[B]display[/B]_weight > 0 ? TEXT_TOTAL_WEIGHT . $[B]display[/B]_weight . TEXT_PRODUCT_WEIGHT_UNIT : '') . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
case (SHOW_TOTALS_IN_CART == '3'):
$totalsDisplay = TEXT_TOTAL_ITEMS . $_SESSION['cart']->count_contents() . TEXT_TOTAL_AMOUNT . $currencies->format($_SESSION['cart']->show_total());
break;
}

levbeck:

When it's over a certain weight, I simply want to remove the UPS option during checkout.

What is the "certain" weight?

Brilliant! Thank you so much, that is definitely something that I would not have figured out on my own. I appreciate your attention to my issues! :clap:

I have a client who is also having problems with shipping calculation where the figures are higher than they should be according to the UPS site. In reading this thread, I see DrByte asked what version of ZC was being used...

My client is using 1.3.5 - has there been any change to the UPS/ZC "relationship" that may be cured by updating to 1.3.7.1?

Thanks.

I would try v1.3.7.1 on a test database and test directory ...

If I am not mistaken there were several things cleaned up on the shipping modules since v1.3.5, not to mention all of the bugs and security issues fixed since then ...

I would also recommend going through the all of the Modules for Payment, Shipping and Order Totals and writting down the settings then hitting REMOVE, INSTALL and Reconfigure them again to obtain the newest changes to the code ...

Hi Dr Byte,

I was having a similar problem with the shipping estimator and your mod fixed it from displaying incorrectly. My only problem now is that is shows 3 boxes which I think is affecting my shipping quote.

Total Items: 1 Weight: 100gms Amount: $69.95 Dims: 10.00x10.00x1 Boxes: 3

I dont know where or how it is getting the 3 boxes from???

Can you help?

Many many thanks
Cheers,
Neil