How to obtain Picker & Packer data from API

Hi,

Within ShipHero API, how do we grab data on how many units a user Picked and/or Packed per day. Specifically, trying to pull data around the following:

Picking

  1. Items Picked
  2. Orders Picked
  3. Unique Items Picked

Packing

  1. Labels Printed
  2. Items Packed
  3. Unique Items Packed
  4. Barcodes Scanned
  5. Errors Made
  6. Items Counted
  7. SKUs Counted

This information is available in ShipHero by looking up each user by day but looking for a way to extract into our BI Tool.

Thanks,

There are two queries you can use: picks_per_day and packs_per_day. I think you can get everything you’re looking for there except for the errors made.

1 Like

Hey @TBaxter,

Thanks for reaching out!

I believe you can get almost everything except the errors made, items counted and sku’s counted.

There will have to be some manual calculations done for: Items Picked, Orders Picked, Unique Items Picked, and Labels Printed

An example of a packs_per_day query would be something like this:

{
  packs_per_day(date_from: "2022-09-01", date_to: "2022-10-04") {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          legacy_id
          order_id
          total_items
          unique_items
          barcodes_scanned
          shipment {
            completed
            shipping_labels {
              id
              legacy_id
            }
            line_items(first:3) {
              edges {
                node {
                  id
                  quantity
                  line_item{
                    sku
                    quantity_shipped
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}

An example of the picks_per_day query is:

{
  picks_per_day(date_from: "2022-10-01", date_to: "2022-10-04") {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          picked_quantity
          pick_type
          sku
          order{
            id
          }
        }
      }
    }
  }
}

Please let me know if you have any questions or concerns!

Best,
RayanP