/cost/center/openApi/fba/gather/query{
"operation": {
"method": "POST",
"path": "/cost/center/openApi/fba/gather/query"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 15,
"seller_id": [
"AQ7DSXSNF6NDP",
"AJGRSY3EK14NJ"
],
"start_date": "2022-01",
"end_date": "2024-08"
},
"responseExample": {
"code": 0,
"msg": "操作成功",
"traceId": "c3e060d3-aeed-4ef5-abe8-22258b1e2836.1673410807850",
"data": {
"row_data": [
{
"sid": 6,
"wid": 19,
"disposition": "all",
"start_count": 4558,
"start_other_amount": "0.00",
"start_logistic_amount": "0.00",
"shipments_count": -441,
"shipments_other_amount": "0.00",
"shipments_logistic_amount": "0.00",
"whse_transfers_count": 162,
"whse_transfers_other_amount": "0.00",
"whse_transfers_logistic_amount": "0.00",
"disposed_count": 0,
"disposed_other_amount": "0.00",
"disposed_logistic_amount": "0.00",
"found_count": 1,
"found_other_amount": "0.00",
"found_logistic_amount": "0.00",
"lost_count": -3,
"lost_other_amount": "0.00",
"lost_logistic_amount": "0.00",
"other_events_count": 0,
"other_events_other_amount": "0.00",
"other_events_logistic_amount": "0.00",
"receipts_count": 297,
"receipts_other_amount": "0.00",
"receipts_logistic_amount": "0.00",
"customer_returns_count": 26,
"customer_returns_other_amount": "0.00",
"customer_returns_logistic_amount": "0.00",
"vendor_returns_count": -16,
"vendor_returns_other_amount": "0.00",
"vendor_returns_logistic_amount": "0.00",
"difference_count": -2,
"difference_other_amount": "0.00",
"difference_logistic_amount": "0.00",
"end_count": 4580,
"end_other_amount": "0.00",
"end_logistic_amount": "0.00",
"damaged_count": -2,
"damaged_other_amount": "0.00",
"damaged_logistic_amount": "0.00",
"partition_index": null,
"end_on_way_count": 0,
"end_on_way_other_amount": "0.00",
"end_on_way_logistic_amount": "0.00",
"category_count": null,
"parent_node": true,
"child_data": [
{
"sid": 6,
"wid": 19,
"disposition": "sellable",
"start_count": 4519,
"start_other_amount": "0.00",
"start_logistic_amount": "0.00",
"shipments_count": -441,
"shipments_other_amount": "0.00",
"shipments_logistic_amount": "0.00",
"whse_transfers_count": 163,
"whse_transfers_other_amount": "0.00",
"whse_transfers_logistic_amount": "0.00",
"disposed_count": 0,
"disposed_other_amount": "0.00",
"disposed_logistic_amount": "0.00",
"found_count": 1,
"found_other_amount": "0.00",
"found_logistic_amount": "0.00",
"lost_count": -3,
"lost_other_amount": "0.00",
"lost_logistic_amount": "0.00",
"other_events_count": 0,
"other_events_other_amount": "0.00",
"other_events_logistic_amount": "0.00",
"receipts_count": 297,
"receipts_other_amount": "0.00",
"receipts_logistic_amount": "0.00",
"customer_returns_count": 9,
"customer_returns_other_amount": "0.00",
"customer_returns_logistic_amount": "0.00",
"vendor_returns_count": 0,
"vendor_returns_other_amount": "0.00",
"vendor_returns_logistic_amount": "0.00",
"difference_count": -2,
"difference_other_amount": "0.00",
"difference_logistic_amount": "0.00",
"end_count": 4541,
"end_other_amount": "0.00",
"end_logistic_amount": "0.00",
"damaged_count": -2,
"damaged_other_amount": "0.00",
"damaged_logistic_amount": "0.00",
"partition_index": null,
"end_on_way_count": 0,
"end_on_way_other_amount": "0.00",
"end_on_way_logistic_amount": "0.00",
"category_count": null,
"parent_node": false,
"child_data": [],
"inventory_turnover_rate": "0.10",
"inventory_turnover_days": "310.00",
"moving_pin_rate": null,
"start_total_amount": "0.00",
"shipments_total_amount": "0.00",
"whse_transfers_total_amount": "0.00",
"disposed_total_amount": "0.00",
"found_total_amount": "0.00",
"lost_total_amount": "0.00",
"other_events_total_amount": "0.00",
"receipts_total_amount": "0.00",
"customer_returns_total_amount": "0.00",
"vendor_returns_total_amount": "0.00",
"difference_total_amount": "0.00",
"end_total_amount": "0.00",
"damaged_total_amount": "0.00",
"end_on_way_total_amount": "0.00",
"stock_to_use_rate": "10.30",
"adjustments_count": 0,
"adjustments_total_amount": "0.00",
"adjustments_logistic_amount": "0.00",
"adjustments_other_amount": "0.00",
"ware_house_name": "_xinghai_direct-1美国仓"
}
],
"inventory_turnover_rate": "0.10",
"inventory_turnover_days": "310.00",
"moving_pin_rate": null,
"start_total_amount": "0.00",
"shipments_total_amount": "0.00",
"whse_transfers_total_amount": "0.00",
"disposed_total_amount": "0.00",
"found_total_amount": "0.00",
"lost_total_amount": "0.00",
"other_events_total_amount": "0.00",
"receipts_total_amount": "0.00",
"customer_returns_total_amount": "0.00",
"vendor_returns_total_amount": "0.00",
"difference_total_amount": "0.00",
"end_total_amount": "0.00",
"damaged_total_amount": "0.00",
"end_on_way_total_amount": "0.00",
"stock_to_use_rate": "10.39",
"adjustments_count": 0,
"adjustments_total_amount": "0.00",
"adjustments_logistic_amount": "0.00",
"adjustments_other_amount": "0.00",
"ware_house_name": "_xinghai_direct-1美国仓"
}
],
"start_date": "2022-01-01",
"end_date": "2022-01-31",
"day_interval": 31,
"total": 1,
"size": 200,
"current": 1,
"amount_type": 0
}
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Required | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Required | 分页长度,默认为15 |
| 3 | seller_id | 亚马逊店铺id | array<any> | — | Required | 亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】 |
| 4 | start_date | 统计起始月份 | string | — | Required | 统计起始月份,格式:Y-m |
| 5 | end_date | 统计结束月份 | string | — | Required | 统计结束月份,格式:Y-m |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | msg | 提示信息 | string | 操作成功 | Required | 提示信息 |
| 3 | traceId | 请求链路id | string | c3e060d3-aeed-4ef5-abe8-22258b1e2836.1673410807850 | Required | 请求链路id |
| 4 | data | 响应数据 | object | — | Required | 响应数据 |
| 4.1 | current | 当前所在页 | integer | 1 | Required | 当前所在页 |
| 4.2 | size | 单页数据行数 | integer | 1 | Required | 单页数据行数 |
| 4.3 | total | 总数 | integer | 222 | Required | 总数 |
| 4.4 | end_date | 统计结束月份 | string | 2022-08-31 | Required | 统计结束月份,格式:Y-m-d |
| 4.5 | start_date | 统计开始月份 | string | 2022-08-31 | Required | 统计开始月份,格式:Y-m-d |
| 4.6 | amount_type | 计价类型 | integer | 1 | Required | 计价类型:0 成本计价,1 固定值计价 |
| 4.7 | day_interval | 时间区间相隔天数 | integer | 31 | Required | 时间区间相隔天数 |
| 4.8 | row_data | row_data | array<object> | — | Required | |
| 4.8.1 | adjustments_count | 成本调整-数量 | integer | — | Required | 成本调整-数量 |
| 4.8.2 | adjustments_logistic_amount | 成本调整-物流成本 | number | 0 | Required | 成本调整-物流成本 (精度:2位小数) |
| 4.8.3 | adjustments_other_amount | 成本调整-其他成本 | number | 0 | Required | 成本调整-其他成本 (精度:2位小数) |
| 4.8.4 | adjustments_total_amount | 成本调整-总成本 | number | 0 | Required | 成本调整-总成本 |
| 4.8.5 | asin | asin | string | B07NL8PKF2 | Required | asin |
| 4.8.6 | bid | 品牌id | integer | — | Required | 品牌id |
| 4.8.7 | brand_name | 品牌名称 | string | 品牌名称1 | Required | 品牌名称 |
| 4.8.8 | cid | 分类id | integer | 12 | Required | 分类id |
| 4.8.9 | country_code | 国家编码 | string | US | Required | 国家编码 |
| 4.8.10 | customer_returns_count | 买家退货-数量 | integer | — | Required | 买家退货-数量 |
| 4.8.11 | customer_returns_logistic_amount | 买家退货-物流成本 | number | 0 | Required | 买家退货-物流成本 (精度:2位小数) |
| 4.8.12 | customer_returns_other_amount | 买家退货-其他成本 | number | 0 | Required | 买家退货-其他成本 (精度:2位小数) |
| 4.8.13 | customer_returns_total_amount | 买家退货-总成本 | number | 0 | Required | 买家退货-总成本 (精度:2位小数) |
| 4.8.14 | damaged_count | 残损-数量 | integer | — | Required | 残损-数量 |
| 4.8.15 | damaged_logistic_amount | 残损-物流成本 | number | 0 | Required | 残损-物流成本 (精度:2位小数) |
| 4.8.16 | damaged_other_amount | 残损-其他成本 | number | 0 | Required | 残损-其他成本 (精度:2位小数) |
| 4.8.17 | damaged_total_amount | 残损-总成本 | number | 0 | Required | 残损-总成本 (精度:2位小数) |
| 4.8.18 | difference_count | 库存差异-数量 | integer | — | Required | 库存差异-数量 |
| 4.8.19 | difference_logistic_amount | 库存差异-物流成本 | number | 4.55 | Required | 库存差异-物流成本 (精度:2位小数) |
| 4.8.20 | difference_other_amount | 库存差异-其他成本 | number | 1.33 | Required | 库存差异-其他成本 (精度:2位小数) |
| 4.8.21 | difference_total_amount | 库存差异-总成本 | number | 0 | Required | 库存差异-总成本 (精度:2位小数) |
| 4.8.22 | disposed_count | 丢弃-数量 | integer | — | Required | 丢弃-数量 |
| 4.8.23 | disposed_logistic_amount | 丢弃-物流成本 | number | 0 | Required | 丢弃-物流成本 (精度:2位小数) |
| 4.8.24 | disposed_other_amount | 丢弃-其他成本 | number | 0 | Required | 丢弃-其他成本 (精度:2位小数) |
| 4.8.25 | disposed_total_amount | 丢弃-总成本 | number | 0 | Required | 丢弃-总成本 (精度:2位小数) |
| 4.8.26 | disposition | 库存属性 | string | all | Required | 库存属性: sellable 可售 unsellable 不可售 all 全部 |
| 4.8.27 | end_count | 期末库存-数量 | integer | 1 | Required | 期末库存-数量 |
| 4.8.28 | end_logistic_amount | 期末库存-物流成本 | number | 0 | Required | 期末库存-物流成本 (精度:2位小数) |
| 4.8.29 | end_on_way_count | 期末在途-数量 | integer | — | Required | 期末在途-数量 |
| 4.8.30 | end_on_way_logistic_amount | 期末在途-物流成本 | number | 0 | Required | 期末在途-物流成本 (精度:2位小数) |
| 4.8.31 | end_on_way_other_amount | 期末在途-其他成本 | number | 0 | Required | 期末在途-其他成本 (精度:2位小数) |
| 4.8.32 | end_on_way_total_amount | 期末在途-总成本 | number | 0 | Required | 期末在途-总成本 (精度:2位小数) |
| 4.8.33 | end_other_amount | 期末库存-其他成本 | number | 0 | Required | 期末库存-其他成本 (精度:2位小数) |
| 4.8.34 | end_total_amount | 期末库存-总成本 | number | 0 | Required | 期末库存-总成本 (精度:2位小数) |
| 4.8.35 | fnsku | fnsku | string | X0023DBLEH | Required | fnsku |
| 4.8.36 | found_count | 已找到-数量 | integer | — | Required | 已找到-数量 |
| 4.8.37 | found_logistic_amount | 已找到-物流成本 | number | 0 | Required | 已找到-物流成本 (精度:2位小数) |
| 4.8.38 | found_other_amount | 已找到-其他成本 | number | 0 | Required | 已找到-其他成本 (精度:2位小数) |
| 4.8.39 | found_total_amount | 已找到-总成本 | number | 0 | Required | 已找到-总成本 (精度:2位小数) |
| 4.8.40 | inventory_turnover_days | 库存周转天数 | number | 0 | Required | 库存周转天数 (精度:2位小数) |
| 4.8.41 | inventory_turnover_rate | 库存周转率 | number | 0 | Required | 库存周转率 (精度:2位小数) |
| 4.8.42 | moving_pin_rate | 动销率 | number | — | Required | 动销率 (精度:2位小数) |
| 4.8.43 | local_name | 本地产品名称 | string | 本地产品名称12 | Required | 本地产品名称 |
| 4.8.44 | local_sku | 本地产品Sku | string | 7501XH1856 | Required | 本地产品Sku |
| 4.8.45 | lost_count | 丢失-数量 | integer | — | Required | 丢失-数量 |
| 4.8.46 | lost_logistic_amount | 丢失-物流成本 | number | 0 | Required | 丢失-物流成本 (精度:2位小数) |
| 4.8.47 | lost_other_amount | 丢失-其他成本 | number | 0 | Required | 丢失-其他成本 (精度:2位小数) |
| 4.8.48 | lost_total_amount | 丢失-总成本 | number | 0 | Required | 丢失-总成本 (精度:2位小数) |
| 4.8.49 | mid | 站点id | integer | 4 | Required | 站点id |
| 4.8.50 | msku | msku | string | 7501XH1856 | Required | msku |
| 4.8.51 | other_events_count | 其他-数量 | integer | — | Required | 其他-数量 |
| 4.8.52 | other_events_logistic_amount | 其他-物流成本 | number | 0 | Required | 其他-物流成本 (精度:2位小数) |
| 4.8.53 | other_events_other_amount | 其他-其他成本 | number | 0 | Required | 其他-其他成本 (精度:2位小数) |
| 4.8.54 | other_events_total_amount | 其他-总成本 | number | 0 | Required | 其他-总成本 (精度:2位小数) |
| 4.8.55 | parent_asin | 父Asin | string | B07NL8PKF2 | Required | 父Asin |
| 4.8.56 | parent_node | 是否父节点 | string | true | Required | 是否父节点 |
| 4.8.57 | product_category_name | 产品分类名 | string | 产品分类名1 | Required | 产品分类名 |
| 4.8.58 | product_id | 产品id | integer | 2 | Required | 产品id |
| 4.8.59 | receipts_count | 货物补货-数量 | integer | — | Required | 货物补货-数量 |
| 4.8.60 | receipts_logistic_amount | 货物补货-物流成本 | number | 0 | Required | 货物补货-物流成本 (精度:2位小数) |
| 4.8.61 | receipts_other_amount | 货物补货-其他成本 | number | 0 | Required | 货物补货-其他成本 (精度:2位小数) |
| 4.8.62 | receipts_total_amount | 货物补货-总成本 | number | 0 | Required | 货物补货-总成本 (精度:2位小数) |
| 4.8.63 | shipments_count | 订单发货-数量 | integer | — | Required | 订单发货-数量 |
| 4.8.64 | shipments_logistic_amount | 订单发货-物流成本 | number | 0 | Required | 订单发货-物流成本 (精度:2位小数) |
| 4.8.65 | shipments_other_amount | 订单发货-其他成本 | number | 0 | Required | 订单发货-其他成本 (精度:2位小数) |
| 4.8.66 | shipments_total_amount | 订单发货-总成本 | number | 0 | Required | 订单发货-总成本 (精度:2位小数) |
| 4.8.67 | sid | 店铺id | integer | 3 | Required | 店铺id |
| 4.8.68 | seller_id | 亚马逊店铺id | string | xxxxxxxxxxxxxxxx | Required | 亚马逊店铺id |
| 4.8.69 | start_count | 期初库存-数量 | integer | — | Required | 期初库存-数量 |
| 4.8.70 | start_logistic_amount | 期初库存-物流成本 | number | 0 | Required | 期初库存-物流成本 (精度:2位小数) |
| 4.8.71 | start_other_amount | 期初库存-其他成本 | number | 0 | Required | 期初库存-其他成本 (精度:2位小数) |
| 4.8.72 | start_total_amount | 期初库存-总成本 | number | 0 | Required | 期初库存-总成本 (精度:2位小数) |
| 4.8.73 | stock_to_use_rate | 存销比 | number | 0 | Required | 存销比 (精度:2位小数) |
| 4.8.74 | valuation_method | 计价方法 | integer | 1 | Required | 计价方法: 1-先进先出 2-移动加权 3-月末加权 |
| 4.8.75 | vendor_returns_count | 库存移除-数量 | integer | — | Required | 库存移除-数量 |
| 4.8.76 | vendor_returns_logistic_amount | 库存移除-物流成本 | number | 0 | Required | 库存移除-物流成本 |
| 4.8.77 | vendor_returns_other_amount | 库存移除-其他成本 | number | 0 | Required | 库存移除-其他成本 |
| 4.8.78 | vendor_returns_total_amount | 库存移除-总成本 | number | 0 | Required | 库存移除-总成本 |
| 4.8.79 | whse_transfers_logistic_amount | 库房转运-物流成本 | number | 0 | Required | 库房转运-物流成本 (精度:2位小数) |
| 4.8.80 | whse_transfers_other_amount | 库房转运-其他成本 | number | 0 | Required | 库房转运-其他成本 (精度:2位小数) |
| 4.8.81 | whse_transfers_total_amount | 库房转运-总成本 | number | 0 | Required | 库房转运-总成本 (精度:2位小数) |
| 4.8.82 | whse_transfers_count | 库房转运-数量 | integer | — | Required | 库房转运-数量 |
| 4.8.83 | wid | 系统仓库id | integer | 123 | Required | 系统仓库id |
| 4.8.84 | ware_house_name | 仓库名称 | string | 仓库名称213 | Required | 仓库名称 |
| 4.8.85 | child_data | 返回字段与上级row_data一致 | array<any> | | Required | 返回字段与上级row_data一致 |
The 库存报表 - FBA - 新版 - 汇总 API (/cost/center/openApi/fba/gather/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.