Results 1 to 6 of 6
  1. #1
    Join Date
    May 2010
    Location
    Texas
    Posts
    508
    Plugin Contributions
    0

    red flag 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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Can I access total order weight?

    Whay are you not using the usps plugin??

    Weight is summed up in the order details

  3. #3
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,957
    Plugin Contributions
    96

    Default 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.

  4. #4
    Join Date
    May 2010
    Location
    Texas
    Posts
    508
    Plugin Contributions
    0

    Default Re: Can I access total order weight?

    Quote Originally Posted by lat9 View Post
    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.

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,957
    Plugin Contributions
    96

    Default 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.

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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.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!

 

 

Similar Threads

  1. Zone Shipping Cost based on Individual item weight, not total order weight
    By pohnean in forum Built-in Shipping and Payment Modules
    Replies: 15
    Last Post: 16 Sep 2009, 09:02 AM
  2. Discount based on Total Order Weight
    By stehodges in forum Setting Up Specials and SaleMaker
    Replies: 3
    Last Post: 25 May 2009, 05:14 PM
  3. Enable Table Rate Shipping w/ Minimum Order Total OR Weight
    By fepb in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 7 Jul 2007, 06:19 AM
  4. Discount based on total weight of order
    By stehodges in forum Setting Up Specials and SaleMaker
    Replies: 4
    Last Post: 3 May 2007, 03:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg