轻易云
注册体验

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

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
统计 · POST · 请求参数 5 个(必填 5) · 响应参数 97 个 · 限流令牌桶容量 10
更新日期
2026-11-21

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

POST/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
    }
  }
}

接口请求参数

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

接口响应参数

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

领星ERP的接口:库存报表 - FBA - 新版 - 汇总(/cost/center/openApi/fba/gather/query),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。