Qeasy Cloud
Get Started

领星ERP 查询仓库库存明细 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
仓库 / 库存&流水 · POST · 请求参数 4 个(必填 0) · 响应参数 54 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询仓库库存明细

POST/erp/sc/routing/data/local_inventory/inventoryDetails
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/routing/data/local_inventory/inventoryDetails"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": {
    "wid": "1,578,765",
    "offset": 0,
    "length": 20,
    "sku": "Test01"
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "B6566678-9238-338C-3FD5-BBEEF01635BA",
    "response_time": "2022-09-08 15:57:49",
    "data": [
      {
        "wid": 1,
        "product_id": 10001,
        "sku": "1111",
        "seller_id": "0",
        "fnsku": "",
        "product_total": 1943,
        "product_valid_num": 681,
        "expect_valid_num": 681,
        "product_bad_num": 110,
        "product_qc_num": 519,
        "product_lock_num": 633,
        "stock_cost_total": "19430.00",
        "quantity_receive": "562",
        "expect_pending_num": 562,
        "stock_cost": "10.0000",
        "product_onway": 0,
        "transit_head_cost": "0.00",
        "average_age": 135,
        "third_inventory": [],
        "stock_age_list": [
          {
            "name": "0-15天库龄",
            "qty": 20
          },
          {
            "name": "16-30天库龄",
            "qty": 0
          },
          {
            "name": "31-90天库龄",
            "qty": 1348
          },
          {
            "name": "91天以上库龄",
            "qty": 575
          }
        ]
      }
    ],
    "total": 1
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1wid仓库idstring—Optional仓库id,多个使用英文逗号分隔
2offset分页偏移量integer—Optional分页偏移量,默认0
3length分页长度integer—Optional分页长度,默认20,上限800
4skuskustring—OptionalSKU,单个,(模糊搜索)

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstringBD36FCD8-E32E-E9E1-6BEC-06DE331C95ABRequired请求链路id
5response_time响应时间string2021-06-15 17:49:16Required响应时间
6total总数integer1Required总数
7data响应数据array<object>—Required响应数据
7.1wid仓库idinteger1771Required仓库id
7.2product_id本地产品idinteger23551Required本地产品id
7.3skuskustringsku-1RequiredSKU
7.4seller_id店铺idstring—Required店铺id
7.5fnskufnskustring—RequiredFNSKU
7.6product_totalproduct_totalinteger11Required实际库存总量【可用量+次品量+待检待上架量+锁定量】
7.7product_valid_num可用量integer11Required可用量
7.8expect_valid_num期望可用integer11Required期望可用
7.9product_bad_num次品量integer—Required次品量
7.10product_qc_num待检待上架量integer—Required待检待上架量
7.11product_lock_num锁定量integer—Required锁定量
7.12storage_distribute_numFBA发货单待配货量integer—RequiredFBA发货单待配货量
7.13stock_cost_total库存成本string11.00Required库存成本
7.14quantity_receive待到货量string1Required待到货量
7.15expect_pending_num期望待到货量integer1Required期望待到货量
7.16stock_cost单位库存成本string1.00Required单位库存成本
7.17product_onway调拨在途integer1Required调拨在途
7.18transit_head_cost调拨在途头程成本string0.01Required调拨在途头程成本
7.19average_age平均库龄integer1Required平均库龄
7.20third_inventory海外仓第三方库存信息object—Required海外仓第三方库存信息
7.20.1qty_sellable可用量integer35194Required可用量
7.20.2qty_pending待上架库存integer—Required待上架库存
7.20.3qty_reserved锁定量integer7Required锁定量
7.20.4qty_onway第三方海外仓备货在途integer—Required第三方海外仓备货在途
7.20.5third_inventory_data海外仓子产品库存明细array<object>—Required海外仓子产品库存明细
7.20.5.1name库存对比string—Required库存对比
7.20.5.2local系统integer—Required系统
7.20.5.3third第三方仓integer—Required第三方仓
7.20.5.4diff库存差异integer—Required库存差异
7.20.5.5support_box是否同步箱库存boolean—Required是否同步箱库存
7.20.5.6product_third(三方可用量-箱库存可用量 ) * 配对数量integer—Required(三方可用量-箱库存可用量 ) * 配对数量
7.20.5.7box_third箱库存可用量 * 配对数量integer—Required箱库存可用量 * 配对数量
7.20.5.8children海外仓子项库存明细列表array<object>—Required海外仓子项库存明细列表
7.20.5.8.1third_sku海外仓skustring—Required海外仓sku
7.20.5.8.2third_name海外仓sku名称string—Required海外仓sku名称
7.20.5.8.3match_num配对数量integer—Required配对数量
7.20.5.8.4third_value三方可用量integer—Required三方可用量
7.20.5.8.5third_total_value三方可用量*配对数量integer—Required三方可用量*配对数量
7.20.5.8.6product_third(三方可用量-箱库存可用量 ) * 配对数量integer—Required(三方可用量-箱库存可用量 ) * 配对数量
7.20.5.8.7box_third箱库存可用量 * 配对数量integer—Required箱库存可用量 * 配对数量
7.21stock_age_list库龄信息array<object>—Required库龄信息
7.21.1name标题string0-15天库龄Required标题
7.21.2qty数量integer1Required数量
7.22purchase_price采购单价string—Required采购单价
7.23price单位费用string—Required单位费用
7.24head_stock_price单位头程string—Required单位头程
7.25stock_price单位库存成本string—Required单位库存成本

The 查询仓库库存明细 API (/erp/sc/routing/data/local_inventory/inventoryDetails) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.