GET Inventory by Lot

[IMPORTANT] Use this Inventory endpoint if you wanted to get the data of Manufacturing Date, Expiry Date, Batch Number, Receipt Date. This endpoint might be differed from the other Get Inventory endpoint. This endpoint will show you the data by line, so for example same SKU might have different line of data since it has been received in a different dates

Specification

MethodEndpoint
GET/v3/fulfillment/inventory/stock/lot

Query Parameter

FieldData TypeDescriptionMandatory/Optional
warehouse_idStringWarehouse Code

example: WH-TGR04 (depend on merchant)
Mandatory
skusArray of StringSKU Code

example: 11287691 (depend on merchant)
Optional
pageIntegerPage NumberOptional
limitIntegerNumber of Items retrieved per PageOptional

Body Response

Sample Query Parameter

warehouse_code="WH-BAL"
sku="SKUTEST1"
skus="SKUTEST2"
skus="SKUTEST3"
page=1
limit=1

Sample Response

{
  "metadata": {
    "path": "/v1/fulfillment/inventory/stock/lot?warehouse_id=WH-TGR04&skus=0%2BTESTZEP&merchant_id=996830",
    "http_status_code": 200,
    "http_status": "OK",
    "timestamp": 1678239062
  },
  "data": {
    "inventories": [
      {
        "organization_id": "OJV_SHIPPER",
        "customer_id": "AHN",
        "warehouse_id": "WH-TGR04",
        "sku": "0+TESTZEP",
        "lot_num": "LT00010120",
        "qty": 7,
        "reserved_qty": 0,
        "hold_qty": 0,
        "available_qty": 0,
        "mfg_date": null,
        "exp_date": "",
        "batch_no": null,
        "serial_no": null,
        "barcode": null,
        "lot_att_07": null,
        "receipt_date": "2022-11-03",
        "product_condition": "N",
        "cubic": 5250,
        "gross_weight": 700,
        "net_weight": 560,
        "notes": null
      }
    ]
  },
  "pagination": {
    "current_page": 1,
    "current_elements": 1,
    "total_pages": 1,
    "total_elements": 1,
    "sort_by": null,
    "cursor_start": "3gAVrk9yZ2FuaXphdGlvbklEq09KVl9TSElQUEVSqkN1c3RvbWVySUSjQUhOq1dhcmVob3VzZUlEqFdILVRHUjA0o1NLVakwK1RFU1RaRVCmTG90TnVtqkxUMDAwMTAxMjCjUXR5y0AcAAAAAAAArFF0eUFsbG9jYXRlZMsAAAAAAAAAAKlRdHlIb2xkZWTLAAAAAAAAAACqUXR5QXZhaWxlZMsAAAAAAAAAAKdNZmdEYXRlgqZTdHJpbmegpVZhbGlkwqdFeHBEYXRlgqZTdHJpbmegpVZhbGlkw6dCYXRjaE5vgqZTdHJpbmegpVZhbGlkwqhTZXJpYWxOb4KmU3RyaW5noKVWYWxpZMKnQmFyY29kZYKmU3RyaW5noKVWYWxpZMKoTG90QXR0MDeCplN0cmluZ6ClVmFsaWTCq1JlY2VpcHREYXRlgqZTdHJpbmeqMjAyMi0xMS0wM6VWYWxpZMOwUHJvZHVjdENvbmRpdGlvboKmU3RyaW5noU6lVmFsaWTDpUN1Ymljy0C0ggAAAAAAq0dyb3NzV2VpZ2h0y0CF4AAAAAAAqU5ldFdlaWdodMtAgYAAAAAAAKVOb3Rlc4KmU3RyaW5noKVWYWxpZMI=",
    "cursor_end": "3gAVrk9yZ2FuaXphdGlvbklEq09KVl9TSElQUEVSqkN1c3RvbWVySUSjQUhOq1dhcmVob3VzZUlEqFdILVRHUjA0o1NLVakwK1RFU1RaRVCmTG90TnVtqkxUMDAwMTAxMjCjUXR5y0AcAAAAAAAArFF0eUFsbG9jYXRlZMsAAAAAAAAAAKlRdHlIb2xkZWTLAAAAAAAAAACqUXR5QXZhaWxlZMsAAAAAAAAAAKdNZmdEYXRlgqZTdHJpbmegpVZhbGlkwqdFeHBEYXRlgqZTdHJpbmegpVZhbGlkw6dCYXRjaE5vgqZTdHJpbmegpVZhbGlkwqhTZXJpYWxOb4KmU3RyaW5noKVWYWxpZMKnQmFyY29kZYKmU3RyaW5noKVWYWxpZMKoTG90QXR0MDeCplN0cmluZ6ClVmFsaWTCq1JlY2VpcHREYXRlgqZTdHJpbmeqMjAyMi0xMS0wM6VWYWxpZMOwUHJvZHVjdENvbmRpdGlvboKmU3RyaW5noU6lVmFsaWTDpUN1Ymljy0C0ggAAAAAAq0dyb3NzV2VpZ2h0y0CF4AAAAAAAqU5ldFdlaWdodMtAgYAAAAAAAKVOb3Rlc4KmU3RyaW5noKVWYWxpZMI="
  }
}