/erp/sc/routing/data/local_inventory/inventoryBinDetails{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/data/local_inventory/inventoryBinDetails"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"wid": "1,5,18",
"bin_type_list": "5",
"offset": 0,
"length": 20
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "A884D2C7-186A-2810-072A-7A0123093BBA",
"response_time": "2024-07-31 15:08:33",
"data": [
{
"wid": 1,
"product_id": 10001,
"sku": "ceshi001",
"seller_id": "0",
"fnsku": "",
"product_total": 55889,
"product_valid_num": 0,
"product_bad_num": 0,
"product_qc_num": 3322,
"product_lock_num": 52567,
"good_lock_num": 52566,
"bad_lock_num": 1,
"stock_cost_total": "4214317.76",
"quantity_receive": "10005050",
"stock_cost": "75.4051",
"product_onway": 187,
"transit_head_cost": "0.00",
"average_age": 610,
"third_inventory": [],
"stock_age_list": [
{
"name": "0-15天库龄",
"qty": 0
},
{
"name": "16-45天库龄",
"qty": 119
},
{
"name": "61-120天库龄",
"qty": 14
},
{
"name": "121-150天库龄",
"qty": 1128
},
{
"name": "151-180天库龄",
"qty": 1
},
{
"name": "181-210天库龄",
"qty": 131
},
{
"name": "366天以上库龄",
"qty": 54111
}
],
"available_inventory_box_qty": "5256.6"
}
],
"total": 12093
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | wid | 仓库id | string | — | Optional | 仓库id,多个仓库用英文逗号分隔,默认所有仓库 |
| 2 | bin_type_list | 仓位类型 | string | — | Optional | 仓位类型,多个类型用英文逗号分隔: 1 待检暂存 2 可用暂存 3 次品暂存 4 拣货暂存 5 可用 6 次品 |
| 3 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 4 | length | 分页长度 | integer | — | Optional | 分页长度,默认20 ,上限500 |
| 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 | BDE02505-821E-2757-5938-650A21A6875B | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2021-07-16 11:01:34 | Required | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 6.1 | wid | 仓库id | integer | 1771 | Required | 仓库id |
| 6.2 | wh_name | 仓库名称 | string | — | Required | 仓库名称 |
| 6.3 | whb_id | 仓位id | integer | — | Required | 仓位id |
| 6.4 | whb_name | 仓位名称 | string | — | Required | 仓位名称 |
| 6.5 | whb_type | 仓位类型 | string | — | Required | 仓位类型 |
| 6.6 | whb_type_name | 仓位类型名称 | string | — | Required | 仓位类型名称 |
| 6.7 | product_id | 商品id | integer | 23551 | Required | 商品id |
| 6.8 | sku | sku | string | 导入大写PNG | Required | SKU |
| 6.9 | seller_id | 店铺id | string | — | Required | 店铺id |
| 6.10 | fnsku | fnsku | string | — | Required | FNSKU |
| 6.11 | total | 总量 | integer | 11 | Required | 总量 |
| 6.12 | lockNum | 锁定量 | integer | — | Required | 锁定量 |
| 6.13 | validNum | 未锁定量 | string | — | Required | 未锁定量 |
| 6.14 | third_inventory | 海外仓第三方库存信息 | object | — | Required | 海外仓第三方库存信息 |
| 6.14.1 | qty_sellable | 可用量 | integer | 35194 | Required | 可用量 |
| 6.14.2 | qty_pending | 待上架库存 | integer | — | Required | 待上架库存 |
| 6.14.3 | qty_reserved | 锁定量 | integer | 7 | Required | 锁定量 |
| 6.14.4 | qty_onway | 备货在途 | integer | — | Required | 备货在途 |
| 7 | total | 总条数 | integer | 1 | Required | 总条数 |
The 查询仓位库存明细 API (/erp/sc/routing/data/local_inventory/inventoryBinDetails) 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.