How to Get Adjustment for inventory From Shiphero

GraphQL API
1

Hi ,

From shiphero I want to get the inventory adjustment, when in shiphero they do for like Cyle count of adjustment for inventory. How do I get this from shiphero, which GraphQL API should i used ? Can you please share

Thanks
Mangesh

2

Hi @Mangesh!
For inventory adjustments we have the following mutations:

  • inventory_add
  • inventory_replace
  • inventory_remove

And if you need to make many at once you could use the inventory_sync mutation

Let me know if that doesn’t work for what you want to achieve
Thanks in advance!
Tom

3

Hi Tom,

I tried to get the Inventory through the Inventory Update Webhook, but its not giving me the exact how much qty has been adjusted or did the cyle count. Its giving me below response

[
{
“account_id”: “49850”,
“inventory”: [
{
“webhook_type”: “INVENTORY_UPDATE”,
“sku”: “KB1-LEG-BLA-MED-COP”,
“inventory”: “37”,
“backorder_quantity”: “3”,
“virtual”: false
}
]
}
]

And I am actually looking from shiphero whenever the Inventory adjustment / Cyle count done, which API should I used for that because when I tried with the Inventory Sync GrapgQL API I am not getting any data from Shiphero for the respective warehouse.

E,g.

query {

inventory_sync_statuses(warehouse_id:“V2FyZWhvdXNlOjczNTE=”) {

request_id

complexity

data(first: 1) {

  edges {

    node {

      id

      url

      user_id

      account_id

      warehouse_id

      customer_account_id

      total_count

      status

      error

      created_at

      updated_at

    }

  }

}

}

}

Response:

{

"data": {

    "inventory_sync_statuses": {

        "request_id": "5f3ec6f69ce55eb534eba06f",

        "complexity": 2,

        "data": {

            "edges": []

        }

    }

}

}

Kindly let me know by using which Inventory Sync API should I used so that I will get the adjusted qty from Shiphero?

Thanks
Mangesh

4

Hi @Mangesh
Oh I see what you are referring to, I apologize for the confusion.

Would the inventory_change query work for you?
Something like this:

query {
  inventory_changes {
    request_id
    complexity
    data(first: 10) {
      edges {
        node {
          user_id
          account_id
          warehouse_id
          sku
          previous_on_hand
          change_in_on_hand
          reason
          cycle_counted
          location_id
          created_at
        }
      }
    }
  }
}

You can also filter this by sku, warehouse_id ,location_id, location_name, date_from, date_to

Let me know ow if this still doesn’t work
Thanks again!
Tom