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