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
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
Whay are you not using the usps plugin??
Weight is summed up in the order details
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.
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.
Please see other post with a solution on this issue of storing an Order Weight for later use:
http://www.zen-cart.com/showthread.p...n-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!