Display Total weight in Admin/orders

[rhodesengr]

Is there a way to display the total weight of an order on the admin/order page? I do get weight total for some shipping methods and not for others. If the order uses USPS, then I do get a weight total next to the shipping cost. The Fedex module does not display the weight, just the cost. So it seems the weight total is fed to the order page from the shipping module and is module dependent. The shopping cart tracks the total weight plus tare weight. It would be nice to get this to display in the orders. Thanks.

I am using ZC 1.3.7

Mark
www.essential-stuff-store.com

[cpowell1]

Did anyone ever figure out how to do this? If calculating the order weight is too complicated to do from the admin interface, I'd be happy to add a field to the orders table and save the weight when the order is saved. I'm just not sure where the best place to do this is.

(And the site is live, so I don't want to have to do too much random experimenting if I can help it. :-)

[Ajeh]

I would add a new field to the orders table as:
shipping_weight_total decimal(14,5)

hint: it will match future updates ...

[cpowell1]

Thanks for the hint!

You don't happen to know off the top of your head where the order is saved, do you, and if the weight is available at that time? I followed the process up to where it starts using the weight in the shopping cart, then the "I've had enough of this!" kicked in and I gave up.

[coryinit]

I've added the field to the orders table, as you suggested, but I'm unsure where in all the files to find/modify the SQL insert statement to put this in the orders table after a successful checkout. Can anyone please point me in the right direction.

[Ajeh]

Look in the orders.php class and see where the tables are updated with each order for:
orders
orders_products
orders_products_attributes