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

Method

Endpoint

GET

/v3/fulfillment/inventory/stock/lot

Query Parameter

Field

Data Type

Description

Mandatory/Optional

warehouse_id

String

Warehouse Code

example: WH-TGR04 (depend on merchant)

Mandatory

skus

Array of String

SKU Code

example: 11287691 (depend on merchant)

Optional

page

Integer

Page Number

Optional

limit

Integer

Number of Items retrieved per Page

Optional

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="
  }
}