Shipment date and empty shipping labels

[heyjess]

Hi
I have three questions related to shipments data.

First, I’d like to make sure that, created_date is same as “shipment date”?

query {
	               shipments{
    		            complexity
    		            data( first: 10)  {
    			            pageInfo {
    				            hasNextPage
    				            hasPreviousPage
    				            startCursor
    				            endCursor
    			            }
    			            edges  {
    				            node {
                                  id
                                  legacy_id
                                  order_id
                                  warehouse_id
    	                            created_date
                                  ....
    				            }
    				            cursor
    			            }
    		            }
    	            }
                }

Second, date_from is filtering created_date. order_date_from is filtering order_date. right?

Last, some shipments data has no line item and no shipping labels but it has shipments_id, order_id, order_number. Are those data vaild?
I saw some of them has multiple shipping labels under one shipment_id…

[tomasw]

Hi @heyjess!

@heyjess

First, I’d like to make sure that, created_date is same as “shipment date”?

Yes, it should be the date from when the shipment was created, the same that you can see on the UI

@heyjess

Second, date_from is filtering created_date. order_date_from is filtering order_date. right?

That’s correct it should be filtering by dates (order or shipment, depending on the query)

@heyjess

Last, some shipments data has no line item and no shipping labels but it has shipments_id, order_id, order_number. Are those data vaild?
I saw some of them has multiple shipping labels under one shipment_id…

In that case, do you happen to have a request_id for this kind of response? With that might be returning that way

Thanks in advance!
Tom

[heyjess]

Thanks for your reply

One more question is you said created_date is when the shipment was created so it is shipment date. However, is there any way I can get when shipment is sent? For me, “Shipment date” makes more sense when shipment was sent, not when shipment was created

I have lots of them which don’t have any line item and shipping labels but it has shipments_id, order_id, order_number.

here are request_id:
5fdba7abc4fee13efed2f303
5fdba7cd070268ddb56b788f
5fdba80404decac0999acec1

I couldn’t find shipment_id has multiple shipping labels at the moment. When I find one, I’ll post agian

[tomasw]

Hi @heyjess!

@heyjess

I have lots of them which don’t have any line item and shipping labels but it has shipments_id, order_id, order_number.

here are request_id:
5fdba7abc4fee13efed2f303
5fdba7cd070268ddb56b788f
5fdba80404decac0999acec1

I couldn’t find shipment_id has multiple shipping labels at the moment. When I find one, I’ll post agian

I see what you mean, thanks for those IDs!

In that case, it is because a return has been created for that order, which logs a shipment as well. The way you can spot this kind of shipments is by including:

query {
  shipments(order_id: "154712656") {
    complexity
    request_id
    data(after: "YXJyYXljb25uZWN0aW9uOjA=", first: 1, sort: "created_date") {
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        node {
          id
          legacy_id
          order_id
          warehouse_id
          created_date
          order {
            rma_labels{
              shipment_id
            }
          }
          line_items(first: 10) {
            edges {
              node {
                id
                legacy_id
                line_item_id
                shipment_id
                shipping_label_id
                quantity
                line_item {
                  id
                  legacy_id
                  sku
                  quantity_shipped
                  product_name
                }
              }
            }
          }
          shipping_labels {
            id
            shipment_id
            order_id
            order_number
            status
            tracking_number
            carrier
            shipping_name
            shipping_method
            cost
            dimensions {
              weight
              height
              width
              length
            }
            profile
            warehouse
            source
          }
          order {
            id
            legacy_id
            order_number
            order_date
          }
        }
        cursor
      }
    }
  }
}

@heyjess

One more question is you said created_date is when the shipment was created so it is shipment date. However, is there any way I can get when shipment is sent? For me, “Shipment date” makes more sense when shipment was sent , not when shipment was created

In this case, they should be the same (let me know if I got that wrong), this is:

shipment created = created_date = date the order was shipped

They should match, but let me know if this is not what you are referring to

Thanks again!
Tom

[heyjess]

Thank you for the clear answer @tomasw
I’ve found that one shipment id has multiple shipping labels

“request_id”: “5febd321a928c69f2597b912”

[tomasw]

Hi @heyjess
That is correct! it is because it was shipped in two boxes actually, and each one of them has a different tracking number.

This is how it displays on the UI:

If you hover over those Shipments (on the UI) you should see what is in what package (the same information that you get from the Query).

So it is the same shipment ID but two labels, one for each Box

Let me know if that sounded confusing and I could explain better
Thanks again!
Tom

[heyjess]

Hi @tomasw Happy New Year

You’ve clarified that the records which don’t have any line items and shipping labels indicates that a return has been created for that order, which logs a shipment as well.

“request_id”: “5ff36079094a8e537899ddd5”

This is one of this kind of record. You can see two shipments records and one of them is empty line items and shipping labels.

But, I’ve noticed that there is name refunded and needs_refund in Shipments data and also Order rma_labels. And these are set to False.

As you explained, those kind of records indicates a return, doesn’t it make sense that either refunded and needs_refund should be set True?

Thank you

Jessie

[tomasw]

Hi @heyjess! Happy New Year to you as well!

For those fields:
refunded and needs_refund

They are currently not being used at all as far as I could check, so they will always return False for this purpose

Please let me know if that still doesn’t help!
Thanks again and I apologize for the delayed response

Tom

[heyjess]

Thanks for the reply!

I’m wondering that is there any direct contact email which I can reach and confirm with ShipHero data quality?

[tomasw]

Absolutely @heyjess!
You can reach us at support@shiphero.com and we can assist you with anything you need.
Thanks again!
Tom