/erp/sc/routing/data/local_inventory/inventoryDetails{
"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
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | wid | 仓库id | string | — | Optional | 仓库id,多个使用英文逗号分隔 |
| 2 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 3 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限800 |
| 4 | sku | sku | string | — | Optional | SKU,单个,(模糊搜索) |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | BD36FCD8-E32E-E9E1-6BEC-06DE331C95AB | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2021-06-15 17:49:16 | Required | 响应时间 |
| 6 | total | 总数 | integer | 1 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | wid | 仓库id | integer | 1771 | Required | 仓库id |
| 7.2 | product_id | 本地产品id | integer | 23551 | Required | 本地产品id |
| 7.3 | sku | sku | string | sku-1 | Required | SKU |
| 7.4 | seller_id | 店铺id | string | — | Required | 店铺id |
| 7.5 | fnsku | fnsku | string | — | Required | FNSKU |
| 7.6 | product_total | product_total | integer | 11 | Required | 实际库存总量【可用量+次品量+待检待上架量+锁定量】 |
| 7.7 | product_valid_num | 可用量 | integer | 11 | Required | 可用量 |
| 7.8 | expect_valid_num | 期望可用 | integer | 11 | Required | 期望可用 |
| 7.9 | product_bad_num | 次品量 | integer | — | Required | 次品量 |
| 7.10 | product_qc_num | 待检待上架量 | integer | — | Required | 待检待上架量 |
| 7.11 | product_lock_num | 锁定量 | integer | — | Required | 锁定量 |
| 7.12 | storage_distribute_num | FBA发货单待配货量 | integer | — | Required | FBA发货单待配货量 |
| 7.13 | stock_cost_total | 库存成本 | string | 11.00 | Required | 库存成本 |
| 7.14 | quantity_receive | 待到货量 | string | 1 | Required | 待到货量 |
| 7.15 | expect_pending_num | 期望待到货量 | integer | 1 | Required | 期望待到货量 |
| 7.16 | stock_cost | 单位库存成本 | string | 1.00 | Required | 单位库存成本 |
| 7.17 | product_onway | 调拨在途 | integer | 1 | Required | 调拨在途 |
| 7.18 | transit_head_cost | 调拨在途头程成本 | string | 0.01 | Required | 调拨在途头程成本 |
| 7.19 | average_age | 平均库龄 | integer | 1 | Required | 平均库龄 |
| 7.20 | third_inventory | 海外仓第三方库存信息 | object | — | Required | 海外仓第三方库存信息 |
| 7.20.1 | qty_sellable | 可用量 | integer | 35194 | Required | 可用量 |
| 7.20.2 | qty_pending | 待上架库存 | integer | — | Required | 待上架库存 |
| 7.20.3 | qty_reserved | 锁定量 | integer | 7 | Required | 锁定量 |
| 7.20.4 | qty_onway | 第三方海外仓备货在途 | integer | — | Required | 第三方海外仓备货在途 |
| 7.20.5 | third_inventory_data | 海外仓子产品库存明细 | array<object> | — | Required | 海外仓子产品库存明细 |
| 7.20.5.1 | name | 库存对比 | string | — | Required | 库存对比 |
| 7.20.5.2 | local | 系统 | integer | — | Required | 系统 |
| 7.20.5.3 | third | 第三方仓 | integer | — | Required | 第三方仓 |
| 7.20.5.4 | diff | 库存差异 | integer | — | Required | 库存差异 |
| 7.20.5.5 | support_box | 是否同步箱库存 | boolean | — | Required | 是否同步箱库存 |
| 7.20.5.6 | product_third | (三方可用量-箱库存可用量 ) * 配对数量 | integer | — | Required | (三方可用量-箱库存可用量 ) * 配对数量 |
| 7.20.5.7 | box_third | 箱库存可用量 * 配对数量 | integer | — | Required | 箱库存可用量 * 配对数量 |
| 7.20.5.8 | children | 海外仓子项库存明细列表 | array<object> | — | Required | 海外仓子项库存明细列表 |
| 7.20.5.8.1 | third_sku | 海外仓sku | string | — | Required | 海外仓sku |
| 7.20.5.8.2 | third_name | 海外仓sku名称 | string | — | Required | 海外仓sku名称 |
| 7.20.5.8.3 | match_num | 配对数量 | integer | — | Required | 配对数量 |
| 7.20.5.8.4 | third_value | 三方可用量 | integer | — | Required | 三方可用量 |
| 7.20.5.8.5 | third_total_value | 三方可用量*配对数量 | integer | — | Required | 三方可用量*配对数量 |
| 7.20.5.8.6 | product_third | (三方可用量-箱库存可用量 ) * 配对数量 | integer | — | Required | (三方可用量-箱库存可用量 ) * 配对数量 |
| 7.20.5.8.7 | box_third | 箱库存可用量 * 配对数量 | integer | — | Required | 箱库存可用量 * 配对数量 |
| 7.21 | stock_age_list | 库龄信息 | array<object> | — | Required | 库龄信息 |
| 7.21.1 | name | 标题 | string | 0-15天库龄 | Required | 标题 |
| 7.21.2 | qty | 数量 | integer | 1 | Required | 数量 |
| 7.22 | purchase_price | 采购单价 | string | — | Required | 采购单价 |
| 7.23 | price | 单位费用 | string | — | Required | 单位费用 |
| 7.24 | head_stock_price | 单位头程 | string | — | Required | 单位头程 |
| 7.25 | stock_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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.