Search records by tote ID/barcode

Hello,

We are working on implementing a shipping platform for a ShipHero user, and it has been requested that we load data in using the tote ID/barcode, since they are picking the orders in SH and there is no current paperwork being generated that a user can use to load the order by (all the shipper has is their tote). Is there a way to query the tote_history API to retrieve records that match the barcode on the tote? I’ve tried the following request, however I am not getting any data:

{“query”:“query tote_history ($sort: String, $before: String, $after: String, $first: Int, $last: Int, $tote_name: String, $tote_id: String, $date_from: ISODateTime, $date_to: ISODateTime, $analyze: Boolean) {\n tote_history (tote_name: $tote_name, tote_id: $tote_id, date_from: $date_from, date_to: $date_to, analyze: $analyze) {\n request_id\n complexity\n data (sort: $sort, before: $before, after: $after, first: $first, last: $last) {\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n }\n edges {\n node {\n tote_name\n tote_id\n action\n created_at\n }\n cursor\n }\n }\n }\n}”,“variables”:{
“sort”: “”,
“before”: “”,
“after”: “”,
“first”: 0,
“last”: 0,
“tote_name”: “”,
“tote_id”: “”,
“date_from”: “8-30-2021”,
“date_to”: “9-1-2021”,
“analyze”: true
}}

1 Like

Hi @bbeuerlein,
Welcome!
I am not 100% sure I understand. Are you wanting to get a list of the orders in a tote?

We need to call an order data taking the tote as a reference, is for shipping label processing purposes through API, since we don’t have the order number printed anywhere the only barcode available is the tote one. So that we need to correlate the data from the tote number

1 Like

This will get the tote pick from the order line item history. Will this help?

query{
  order(id:"<order id here>"){
    request_id
    complexity
    data{
      order_history{
            order{
          line_items{
            edges{
              node{
                tote_picks{
                  tote_id
                }
              }
            }
          }
        }
      }
    }
  }
}

Unfortunately not, we actually need the inverse (to get the order from the tote itself). So something like:

query{
  totes(id:"<tote id/barcode here>"){
    request_id
    complexity
    data{
            order{
                 id
                 ...
              }
         }
     }
}

We are essentially needing this because the user does not know what the order is when they are shipping the box; all they have is the tote id/barcode. In SH today, the user can scan this tote barcode and SH pulls in the necessary information to allow the user to ship the order.

Let me know if you need anything further on this.

2 Likes

Thank you for the clarification, I will look into it.

Checking in… any update on this topic?

I have it in for a feature request, apologies for the update delay. I do not have any new information. I will refresh this when I get more feedback.

Hi @bbeuerlein
You can access this information in the UI here: https://app.shiphero.com/dashboard/totes and in the bottom of the page, put in the tote and it will tell you all the orders that are in the tote. In order to go ahead with the request, I would need a use case for having this in the API.
What would be the use case for not using the UI?

Hi Theresa,

I’m not the original poster, but a use case for us is that we have users that aren’t always in a place where they can stop and go to the UI to look it up, but they have Slack on their tablets, so we wanted to build it into a slack bot so that they could request a tote ID (our user facing ID, like “Green-42”, not the internal ShipHero tote ID) and have it give them a list of what’s in it.

1 Like

Thank you! I will post any new updates.