How to obtain Picker & Packer data from API

GraphQL API
1

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,

2

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
3

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

4

We’ve been able to import some Picker and Packer data into our Looker instance but my developer is struggling to locate the following:

Picker
Warehouse ID
Warehouse
Warehouse Name
Total Orders Picked
They are also pulling in a Field titled “Number of Pickers”, which has a value per user but can’t determine what it is

Packer
User ID
User First Name
User Last Name
Labels Scanned
Items Counted
SKUS Counted
Errors Made
Warehouse
Warehouse Name

Thanks for any help

5

Hey @TBaxter,

Thanks for hanging in there!

In regards to your inquiry about the picks_per_day query:

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

Using the warehouse_id should be enough of a replacement for the Warehouse Name. Unfortunately, Total Orders picked will have to be done manually. I’m not 100% sure what field is being pulled by numbers of pickers, but we do have a picked_quantity field that can be added, which will display the number of items picked.

In regards to the packs_per_day query:

{
  packs_per_day(date_from: "2022-09-01", date_to: "2022-10-04") {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          id
          legacy_id
          user_id
          user_first_name
          user_last_name
          warehouse_id
          total_items
          barcodes_scanned
                }
              }
            }
          }
        }
      }
    }
  }
}

Unfortunately errors made doesn’t exist in any capacity in the Public API, as well as a way to specify total SKU’s counted apart from total_items

Let me know if you have any questions or concerns.

Best,
RayanP