Forums / General Questions / Can I access total order weight?

Can I access total order weight?

Locked

Views: 523

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
30 Jan 2013, 1:19 AM
#1
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Can I access total order weight?

When I process orders I need to know what the orders total weight is.
Is this kept in the database as a specific entry?

If so, how do I access it?

I need to export this to a shipping program so that USPS postage will be calculated correctly

30 Jan 2013, 1:55 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Can I access total order weight?

Whay are you not using the usps plugin??

Weight is summed up in the order details

Zen-Venom Get Bitten

30 Jan 2013, 1:45 PM
#3
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,116
Plugin Contributions:
56

Re: Can I access total order weight?

Hmm, it looks like the order's total weight is not kept in the database (interestingly, attribute weights are) so unless you have your USPS shipping method set to "Display weight" there's no record of the order's total weight once the order has been placed.

30 Jan 2013, 3:06 PM
#4
split63 avatar

split63

Totally Zenned

Join Date:
May 2010
Location:
Texas
Posts:
513
Plugin Contributions:
0

Re: Can I access total order weight?

lat9:

Hmm, it looks like the order's total weight is not kept in the database (interestingly, attribute weights are) so unless you have your USPS shipping method set to "Display weight" there's no record of the order's total weight once the order has been placed.
We do display the weight. It is visible at the shopping cart page. We need to access this weight when we are performing order fulfillment. However, tt does not appear that this weight is kept in the database.

30 Jan 2013, 3:22 PM
#5
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,116
Plugin Contributions:
56

Re: Can I access total order weight?

If you've got USPS to display the weight, the value (albeit in text) is stored in the **title **field of the orders_total table, where the orders_id is the order's ID and the **class **field is set to 'ot_shipping'. You'd have to parse the value out, but it's at least there.

31 Jan 2013, 12:50 AM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I access total order weight?

Please see other post with a solution on this issue of storing an Order Weight for later use:
http://www.zen-cart.com/showthread.php?92657-Display-Total-weight-in-Admin-orders

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!