How do I GET lot-level inventory data via the V2 API? I can see lot IDs and expiry dates in the UI, but GET /v2/inventory only returns aggregated totals.
I would love to know what is available via your lot tracking feature via API. I've read https://help.shipstation.com/hc/en-us/articles/36761854507931-Inventory-Lot-Tracking and it doesn't mention anything about inventory integrations via an API endpoint for these fields.
- We are a paid Platinum member, so I realize this lot and expiry date tracking isn't available on all plans - but if we're paying for it, and have inventory API enabled - I would hope this data is available somewhere w/in /inventory
For example, querying - shows nothing about the batch, expiry date, and only returns:
- sku
- on_hand
- available
- average_cost
# URL:
GET https://api.shipstation.com/v2/inventory?sku=MY-SKU&group_by=location
# -----------------------------------
# Headers:
# - API-Key: Your ShipStation V2 API key
# - Content-Type: application/json
# -----------------------------------
# Response:
{
"inventory": [
{
"sku": "MY-SKU",
"on_hand": 124,
"available": 124,
"average_cost": {
"currency": "usd",
"amount": 0.0000
},
"inventory_location_id": "MY_LOCATIONID_1"
},
{
"sku": "MY-SKU",
"on_hand": 96,
"available": 96,
"average_cost": {
"currency": "usd",
"amount": 0.0000
},
"inventory_location_id": "MY_LOCATIONID_2"
},...
Without the ability to extract this data via the API - or at minimum use it as an filterable allocation action in an automation rule ... i.e allocate product by expiry date (FIFO) - I don't see how this added "tracking" is useful? I really want to use it for our operations, but with these open questions, that is proving difficult.
I'm able to POST to /inventory and set the lot and expiry when creating a new product, but I want to be able to retrieve this data to sync with my external system.
I plan to email API support about this question as well and will update the post based on what I find out, but also wanted to post here if there are others that could benefit from this feature, know how to query this data w/in the existing documentation, or could also like/comment on this to get the feature request on SS's radar.
