Qeasy Cloud
Get Started

领星ERP 库存报表 - FBA - 新版 - 汇总 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
统计 · POST · 请求参数 5 个(必填 5) · 响应参数 97 个 · 限流令牌桶容量 10
Updated At
2026-11-21

库存报表 - FBA - 新版 - 汇总

POST/cost/center/openApi/fba/gather/query
Factory
{
  "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
    }
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1offset分页偏移量integer—Required分页偏移量,默认0
2length分页长度integer—Required分页长度,默认为15
3seller_id亚马逊店铺idarray<any>—Required亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】
4start_date统计起始月份string—Required统计起始月份,格式:Y-m
5end_date统计结束月份string—Required统计结束月份,格式:Y-m

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2msg提示信息string操作成功Required提示信息
3traceId请求链路idstringc3e060d3-aeed-4ef5-abe8-22258b1e2836.1673410807850Required请求链路id
4data响应数据object—Required响应数据
4.1current当前所在页integer1Required当前所在页
4.2size单页数据行数integer1Required单页数据行数
4.3total总数integer222Required总数
4.4end_date统计结束月份string2022-08-31Required统计结束月份,格式:Y-m-d
4.5start_date统计开始月份string2022-08-31Required统计开始月份,格式:Y-m-d
4.6amount_type计价类型integer1Required计价类型:0 成本计价,1 固定值计价
4.7day_interval时间区间相隔天数integer31Required时间区间相隔天数
4.8row_datarow_dataarray<object>—Required
4.8.1adjustments_count成本调整-数量integer—Required成本调整-数量
4.8.2adjustments_logistic_amount成本调整-物流成本number0Required成本调整-物流成本 (精度:2位小数)
4.8.3adjustments_other_amount成本调整-其他成本number0Required成本调整-其他成本 (精度:2位小数)
4.8.4adjustments_total_amount成本调整-总成本number0Required成本调整-总成本
4.8.5asinasinstringB07NL8PKF2Requiredasin
4.8.6bid品牌idinteger—Required品牌id
4.8.7brand_name品牌名称string品牌名称1Required品牌名称
4.8.8cid分类idinteger12Required分类id
4.8.9country_code国家编码stringUSRequired国家编码
4.8.10customer_returns_count买家退货-数量integer—Required买家退货-数量
4.8.11customer_returns_logistic_amount买家退货-物流成本number0Required买家退货-物流成本 (精度:2位小数)
4.8.12customer_returns_other_amount买家退货-其他成本number0Required买家退货-其他成本 (精度:2位小数)
4.8.13customer_returns_total_amount买家退货-总成本number0Required买家退货-总成本 (精度:2位小数)
4.8.14damaged_count残损-数量integer—Required残损-数量
4.8.15damaged_logistic_amount残损-物流成本number0Required残损-物流成本 (精度:2位小数)
4.8.16damaged_other_amount残损-其他成本number0Required残损-其他成本 (精度:2位小数)
4.8.17damaged_total_amount残损-总成本number0Required残损-总成本 (精度:2位小数)
4.8.18difference_count库存差异-数量integer—Required库存差异-数量
4.8.19difference_logistic_amount库存差异-物流成本number4.55Required库存差异-物流成本 (精度:2位小数)
4.8.20difference_other_amount库存差异-其他成本number1.33Required库存差异-其他成本 (精度:2位小数)
4.8.21difference_total_amount库存差异-总成本number0Required库存差异-总成本 (精度:2位小数)
4.8.22disposed_count丢弃-数量integer—Required丢弃-数量
4.8.23disposed_logistic_amount丢弃-物流成本number0Required丢弃-物流成本 (精度:2位小数)
4.8.24disposed_other_amount丢弃-其他成本number0Required丢弃-其他成本 (精度:2位小数)
4.8.25disposed_total_amount丢弃-总成本number0Required丢弃-总成本 (精度:2位小数)
4.8.26disposition库存属性stringallRequired库存属性: sellable 可售 unsellable 不可售 all 全部
4.8.27end_count期末库存-数量integer1Required期末库存-数量
4.8.28end_logistic_amount期末库存-物流成本number0Required期末库存-物流成本 (精度:2位小数)
4.8.29end_on_way_count期末在途-数量integer—Required期末在途-数量
4.8.30end_on_way_logistic_amount期末在途-物流成本number0Required期末在途-物流成本 (精度:2位小数)
4.8.31end_on_way_other_amount期末在途-其他成本number0Required期末在途-其他成本 (精度:2位小数)
4.8.32end_on_way_total_amount期末在途-总成本number0Required期末在途-总成本 (精度:2位小数)
4.8.33end_other_amount期末库存-其他成本number0Required期末库存-其他成本 (精度:2位小数)
4.8.34end_total_amount期末库存-总成本number0Required期末库存-总成本 (精度:2位小数)
4.8.35fnskufnskustringX0023DBLEHRequiredfnsku
4.8.36found_count已找到-数量integer—Required已找到-数量
4.8.37found_logistic_amount已找到-物流成本number0Required已找到-物流成本 (精度:2位小数)
4.8.38found_other_amount已找到-其他成本number0Required已找到-其他成本 (精度:2位小数)
4.8.39found_total_amount已找到-总成本number0Required已找到-总成本 (精度:2位小数)
4.8.40inventory_turnover_days库存周转天数number0Required库存周转天数 (精度:2位小数)
4.8.41inventory_turnover_rate库存周转率number0Required库存周转率 (精度:2位小数)
4.8.42moving_pin_rate动销率number—Required动销率 (精度:2位小数)
4.8.43local_name本地产品名称string本地产品名称12Required本地产品名称
4.8.44local_sku本地产品Skustring7501XH1856Required本地产品Sku
4.8.45lost_count丢失-数量integer—Required丢失-数量
4.8.46lost_logistic_amount丢失-物流成本number0Required丢失-物流成本 (精度:2位小数)
4.8.47lost_other_amount丢失-其他成本number0Required丢失-其他成本 (精度:2位小数)
4.8.48lost_total_amount丢失-总成本number0Required丢失-总成本 (精度:2位小数)
4.8.49mid站点idinteger4Required站点id
4.8.50mskumskustring7501XH1856Requiredmsku
4.8.51other_events_count其他-数量integer—Required其他-数量
4.8.52other_events_logistic_amount其他-物流成本number0Required其他-物流成本 (精度:2位小数)
4.8.53other_events_other_amount其他-其他成本number0Required其他-其他成本 (精度:2位小数)
4.8.54other_events_total_amount其他-总成本number0Required其他-总成本 (精度:2位小数)
4.8.55parent_asin父AsinstringB07NL8PKF2Required父Asin
4.8.56parent_node是否父节点stringtrueRequired是否父节点
4.8.57product_category_name产品分类名string产品分类名1Required产品分类名
4.8.58product_id产品idinteger2Required产品id
4.8.59receipts_count货物补货-数量integer—Required货物补货-数量
4.8.60receipts_logistic_amount货物补货-物流成本number0Required货物补货-物流成本 (精度:2位小数)
4.8.61receipts_other_amount货物补货-其他成本number0Required货物补货-其他成本 (精度:2位小数)
4.8.62receipts_total_amount货物补货-总成本number0Required货物补货-总成本 (精度:2位小数)
4.8.63shipments_count订单发货-数量integer—Required订单发货-数量
4.8.64shipments_logistic_amount订单发货-物流成本number0Required订单发货-物流成本 (精度:2位小数)
4.8.65shipments_other_amount订单发货-其他成本number0Required订单发货-其他成本 (精度:2位小数)
4.8.66shipments_total_amount订单发货-总成本number0Required订单发货-总成本 (精度:2位小数)
4.8.67sid店铺idinteger3Required店铺id
4.8.68seller_id亚马逊店铺idstringxxxxxxxxxxxxxxxxRequired亚马逊店铺id
4.8.69start_count期初库存-数量integer—Required期初库存-数量
4.8.70start_logistic_amount期初库存-物流成本number0Required期初库存-物流成本 (精度:2位小数)
4.8.71start_other_amount期初库存-其他成本number0Required期初库存-其他成本 (精度:2位小数)
4.8.72start_total_amount期初库存-总成本number0Required期初库存-总成本 (精度:2位小数)
4.8.73stock_to_use_rate存销比number0Required存销比 (精度:2位小数)
4.8.74valuation_method计价方法integer1Required计价方法: 1-先进先出 2-移动加权 3-月末加权
4.8.75vendor_returns_count库存移除-数量integer—Required库存移除-数量
4.8.76vendor_returns_logistic_amount库存移除-物流成本number0Required库存移除-物流成本
4.8.77vendor_returns_other_amount库存移除-其他成本number0Required库存移除-其他成本
4.8.78vendor_returns_total_amount库存移除-总成本number0Required库存移除-总成本
4.8.79whse_transfers_logistic_amount库房转运-物流成本number0Required库房转运-物流成本 (精度:2位小数)
4.8.80whse_transfers_other_amount库房转运-其他成本number0Required库房转运-其他成本 (精度:2位小数)
4.8.81whse_transfers_total_amount库房转运-总成本number0Required库房转运-总成本 (精度:2位小数)
4.8.82whse_transfers_count库房转运-数量integer—Required库房转运-数量
4.8.83wid系统仓库idinteger123Required系统仓库id
4.8.84ware_house_name仓库名称string仓库名称213Required仓库名称
4.8.85child_data返回字段与上级row_data一致array<any>&nbsp;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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.