How do I get lot_name & lot_expiration from PO Item Receipt

GraphQL API
1

Hi,

How do i get the items “lot_name” & “lot_expiration” information from Shiphero in PO Item receipt webhook or Query.

Please let me know

Thanks
Mangesh

2

Hi @Mangesh
You can see the example at https://developer.shiphero.com/webhooks#shipment-update-webhook how the Shipment Update Webhook will send the Lot information
We don’t have it available through a Query at the moment, but I could make a Feature Request for this to be added if you need it
Thanks in advance!
Tom

3

Hi Tom,

Sorry But I am looking Lot Number information from PO_Update Webhook? Can you please let me know on this PO_Update webhook, Do I get the Lot Number information.

Thanks
Mangesh

4

Hi @Mangesh
I apologize for my misunderstanding. Our PO Update webhook do not have the Lot information on it.
I will make a Feature Request for this to see if it could be added.
I will let you know if it gets approved.
Thanks again!
Tom

5

Hi Tom,

Through PO Update Webhook, if the Lot Number information we will not get, then can we get through any other Query API? can you please suggest

Because this is more important in terms of the business process. as they have lot numbers SKU and we need to ultimately receive those from Shiphero against Purchase Order.

Looking forward to your reply,

Thanks
Mangesh

6

Hi @Mangesh!
Would the expiration_lots query work for you? Something like this:

query {
  expiration_lots(sku: "1122334463") {
    request_id
    complexity
    data {
      edges {
        node {
          id
          legacy_id
          account_id
          po_id
          name
          sku
          created_at
          updated_at
          expires_at
          received_at
        }
      }
    }
  }
}

This should return you the lots for that SKU
Let me know if this won’t work for you
Thanks again!
Tom

7

Hi Tom,

This above query will not work for the lot number, as the lot numbers information should be coming while receiving the Item Receipt against the Purchase order in Shiphero and its a dynamic, so that’s why its should come by using the PO Update webhook like the Shipment Update webhook has.

Please check and confirm

Thanks
Mangesh

8

Thanks for confirming that @Mangesh!
In that case, I would wait on the Shipment Update webhook feature request.
I also made a request for this to be added to the purchase orders query & mutations on the Public API.
I will update as soon as a I have a response about those requests.
Thanks again!
Tom

9

Hi @Mangesh
I have been told by our engineering team that we won’t be able to work on this at the moment.
Adding these fields and requirements on the Public API or the webhooks will mean a large project that we are not able to tackle at the moment.
The request will be kept as pending for when our engineering team has the resources to work on this (I will try to resubmit by the beginning of 2021), but for the moment our Public API will not support Lots and Expiration through the different Queries or Mutations.
Thanks again for the patience and I apologize for the inconvenience
Tom

10

Hello, is there a work around for this?

11

Hi @veraioele
Not through the Public API, to manage Lot & Expirations the app must be used for now

12

All - I was able to successfully return lot information receive on a purchase order by using 2 separate requests. Follow the process below:

  1. Execute the Purchase Order Query

    query {
    purchase_order(po_number: “<PO_NUMBER>”) {
    request_id
    complexity
    data {
    id
    po_number
    account_id
    warehouse_id
    created_at
    po_date
    date_closed
    packing_note
    fulfillment_status
    po_note
    locking
    locked_by_user_id
    line_items(first: 1) {
    edges {
    node {
    id
    legacy_id
    po_id
    account_id
    warehouse_id
    vendor_id
    po_number
    sku
    barcode
    vendor_sku
    product_id
    variant_id
    quantity
    quantity_received
    quantity_rejected
    price
    product_name
    option_title
    expected_weight_in_lbs
    fulfillment_status
    sell_ahead
    note
    partner_line_item_id
    updated_at
    created_at
    }
    }
    }
    }
    }
    }

  2. Pass the po_id into the ExpirationLots Query
    query {
    expiration_lots(po_id: “<PO_ID>”) {
    request_id
    complexity
    data {
    edges {
    node {
    id
    legacy_id
    account_id
    po_id
    name
    sku
    created_at
    updated_at
    expires_at
    received_at
    }
    }
    }
    }
    }

This will return all lots (with expiration dates) that were received on a specific purchase order.

1 Like