/cost/center/ods/summary/query{
"operation": {
"method": "POST",
"path": "/cost/center/ods/summary/query"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"sellerIds": [
"AN05PRUL7R796"
],
"queryType": 1,
"startDate": "2024-04",
"endDate": "2024-06",
"fnskus": [
"B085M7NH7S"
],
"asins": [
"B097MP26YP"
],
"mskus": [
"DA19037B1"
],
"disposition": "01",
"location": "GB",
"offset": 0,
"length": 20
},
"responseExample": {
"code": 1,
"msg": "操作成功",
"data": {
"records": [
{
"sellerId": "xxxxxxxxxxxxxxxx",
"date": "2022-02",
"fnsku": "X001HIDE4V",
"asin": "B07YV8XB48",
"msku": "1W-NDCE-8XGK-A",
"title": "File Zipper Bags for School Office Household Travel Supplies (5 Colors)",
"disposition": "01",
"dispositionDesc": "SELLABLE",
"startingWarehouseBalance": 0,
"inTransitBetweenWarehouses": 0,
"receipts": 180,
"customerShipments": -101,
"customerReturns": 0,
"vendorReturns": 0,
"warehouseTransferInOrOut": 0,
"found": 0,
"lost": 0,
"damaged": 0,
"disposed": 0,
"otherEvents": 0,
"endingWareHouseBalance": 79,
"unKnownEvents": 0,
"location": "GB"
}
],
"total": 95,
"size": 5,
"current": 1,
"orders": [],
"optimizeCountSql": true,
"hitCount": false,
"countId": null,
"maxLimit": null,
"searchCount": true,
"pages": 19
},
"traceId": "7f7b2fd3-2831-495b-99db-6776438b6f8d.1663229370783",
"success": true
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sellerIds | 亚马逊店铺id | array<any> | — | Required | 亚马逊店铺id |
| 2 | queryType | 查询维度 | integer | — | Required | 查询维度:1 按月,2 按天 |
| 3 | startDate | 统计起始日期 | string | — | Required | 统计起始日期:月维度:Y-m ,天维度:Y-m-d,闭区间 |
| 4 | endDate | 统计结束日期 | string | — | Required | 统计结束日期:月维度:Y-m ,天维度:Y-m-d,闭区间 |
| 5 | fnskus | fnsku列表 | array<any> | — | Optional | fnsku列表 |
| 6 | asins | asin列表 | array<any> | — | Optional | asin列表 |
| 7 | mskus | msku列表 | array<any> | — | Optional | msku列表 |
| 8 | disposition | 库存属性 | string | — | Optional | 库存属性:01 SELLABLE,02 UNSELLABLE,03 ALL |
| 9 | locations | 国家编码列表 | array<any> | — | Optional | 国家编码列表 |
| 10 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 11 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限1000 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | — | Required | 状态码,1 成功 |
| 2 | msg | 响应信息 | string | — | Required | 响应信息 |
| 3 | success | 操作是否成功 | boolean | — | Required | 操作是否成功 |
| 4 | traceId | 请求链路Id | string | — | Required | 请求链路Id |
| 5 | data | 汇总数据 | object | — | Required | 汇总数据 |
| 5.1 | total | 总记录条数 | number | — | Required | 总记录条数 |
| 5.2 | size | 每个数据页大小 | number | — | Required | 每个数据页大小 |
| 5.3 | current | 当前所在数据页 | number | — | Required | 当前所在数据页 |
| 5.4 | records | 汇总数据列表 | array<object> | — | Required | 汇总数据列表 |
| 5.4.1 | sellerId | 店铺Id | string | — | Required | 店铺Id |
| 5.4.2 | date | 数据日期 | string | 月维度:"2022-01",天维度:"2022-01-01" | Required | 数据日期 |
| 5.4.3 | fnsku | fnsku | string | — | Required | fnsku |
| 5.4.4 | msku | msku | string | — | Required | msku |
| 5.4.5 | title | 标题 | string | — | Optional | 标题 |
| 5.4.6 | disposition | 库存属性 | string | "01" | Required | 库存属性 |
| 5.4.7 | dispositionDesc | 库存属性描述 | string | "SELLABLE" | Required | 库存属性描述 |
| 5.4.8 | startingWarehouseBalance | 期初库存 | number | — | Required | 期初库存 |
| 5.4.9 | inTransitBetweenWarehouses | 调拨在途 | number | — | Required | 调拨在途 |
| 5.4.10 | receipts | 签收 | number | — | Required | 签收 |
| 5.4.11 | customerShipments | 销售出库 | number | — | Required | 销售出库 |
| 5.4.12 | customerReturns | 销售退货 | number | — | Required | 销售退货 |
| 5.4.13 | vendorReturns | 移除 | number | — | Required | 移除 |
| 5.4.14 | warehouseTransferInOrOut | 调拨出入库 | number | — | Required | 调拨出入库 |
| 5.4.15 | found | 找回 | number | — | Required | 找回 |
| 5.4.16 | lost | 丢失 | number | — | Required | 丢失 |
| 5.4.17 | damaged | 损毁 | number | — | Required | 损毁 |
| 5.4.18 | disposed | 弃置 | number | — | Required | 弃置 |
| 5.4.19 | otherEvents | 其他 | number | — | Required | 其他 |
| 5.4.20 | endingWareHouseBalance | 期末库存 | number | — | Required | 期末库存 |
| 5.4.21 | unKnownEvents | 未知 | number | — | Required | 未知 |
| 5.4.22 | location | 国家编码 | string | "GB" | Required | 国家编码 |
The 查询库存分类账summary数据 API (/cost/center/ods/summary/query) 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.