Lingxing
切换旧版

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

POST/cost/center/openApi/fba/gather/query

接口信息

API Path请求协议请求方式令牌桶容量
/cost/center/openApi/fba/gather/queryHTTPSPOST10

请求参数

offsetinteger必填
分页偏移量，默认0
lengthinteger必填
分页长度，默认为15
seller_idarray<any>必填
亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】
start_datestring必填
统计起始月份，格式：Y-m
end_datestring必填
统计结束月份，格式：Y-m

请求示例

{
    "offset": 0,
    "length": 15,
    "seller_id": [
        "AQ7DSXSNF6NDP",
        "AJGRSY3EK14NJ"
    ],
    "start_date": "2022-01",
    "end_date": "2024-08"
}

返回结果

Json Object

codeinteger必填
状态码，0 成功
示例 0
msgstring必填
提示信息
示例 操作成功
traceIdstring必填
请求链路id
示例 c3e060d3-aeed-4ef5-abe8-22258b1e2836.1673410807850
dataobject必填
响应数据
隐藏子属性
currentinteger必填
当前所在页
示例 1
sizeinteger必填
单页数据行数
示例 1
totalinteger必填
总数
示例 222
end_datestring必填
统计结束月份，格式：Y-m-d
示例 2022-08-31
start_datestring必填
统计开始月份，格式：Y-m-d
示例 2022-08-31
amount_typeinteger必填
计价类型：0 成本计价，1 固定值计价
示例 1
day_intervalinteger必填
时间区间相隔天数
示例 31
row_dataarray<object>必填
隐藏子属性
adjustments_countinteger必填
成本调整-数量
adjustments_logistic_amountnumber必填
成本调整-物流成本
(精度：2位小数)
示例 0
adjustments_other_amountnumber必填
成本调整-其他成本
(精度：2位小数)
示例 0
adjustments_total_amountnumber必填
成本调整-总成本
示例 0
asinstring必填
asin
示例 B07NL8PKF2
bidinteger必填
品牌id
brand_namestring必填
品牌名称
示例 品牌名称1
cidinteger必填
分类id
示例 12
country_codestring必填
国家编码
示例 US
customer_returns_countinteger必填
买家退货-数量
customer_returns_logistic_amountnumber必填
买家退货-物流成本
(精度：2位小数)
示例 0
customer_returns_other_amountnumber必填
买家退货-其他成本
(精度：2位小数)
示例 0
customer_returns_total_amountnumber必填
买家退货-总成本
(精度：2位小数)
示例 0
damaged_countinteger必填
残损-数量
damaged_logistic_amountnumber必填
残损-物流成本
(精度：2位小数)
示例 0
damaged_other_amountnumber必填
残损-其他成本
(精度：2位小数)
示例 0
damaged_total_amountnumber必填
残损-总成本
(精度：2位小数)
示例 0
difference_countinteger必填
库存差异-数量
difference_logistic_amountnumber必填
库存差异-物流成本
(精度：2位小数)
示例 4.55
difference_other_amountnumber必填
库存差异-其他成本
(精度：2位小数)
示例 1.33
difference_total_amountnumber必填
库存差异-总成本
(精度：2位小数)
示例 0
disposed_countinteger必填
丢弃-数量
disposed_logistic_amountnumber必填
丢弃-物流成本
(精度：2位小数)
示例 0
disposed_other_amountnumber必填
丢弃-其他成本
(精度：2位小数)
示例 0
disposed_total_amountnumber必填
丢弃-总成本
(精度：2位小数)
示例 0
dispositionstring必填
库存属性：
sellable 可售
unsellable 不可售
all 全部
示例 all
end_countinteger必填
期末库存-数量
示例 1
end_logistic_amountnumber必填
期末库存-物流成本
(精度：2位小数)
示例 0
end_on_way_countinteger必填
期末在途-数量
end_on_way_logistic_amountnumber必填
期末在途-物流成本
(精度：2位小数)
示例 0
end_on_way_other_amountnumber必填
期末在途-其他成本
(精度：2位小数)
示例 0
end_on_way_total_amountnumber必填
期末在途-总成本
(精度：2位小数)
示例 0
end_other_amountnumber必填
期末库存-其他成本
(精度：2位小数)
示例 0
end_total_amountnumber必填
期末库存-总成本
(精度：2位小数)
示例 0
fnskustring必填
fnsku
示例 X0023DBLEH
found_countinteger必填
已找到-数量
found_logistic_amountnumber必填
已找到-物流成本
(精度：2位小数)
示例 0
found_other_amountnumber必填
已找到-其他成本
(精度：2位小数)
示例 0
found_total_amountnumber必填
已找到-总成本
(精度：2位小数)
示例 0
inventory_turnover_daysnumber必填
库存周转天数
(精度：2位小数)
示例 0
inventory_turnover_ratenumber必填
库存周转率
(精度：2位小数)
示例 0
moving_pin_ratenumber必填
动销率
(精度：2位小数)
local_namestring必填
本地产品名称
示例 本地产品名称12
local_skustring必填
本地产品Sku
示例 7501XH1856
lost_countinteger必填
丢失-数量
lost_logistic_amountnumber必填
丢失-物流成本
(精度：2位小数)
示例 0
lost_other_amountnumber必填
丢失-其他成本
(精度：2位小数)
示例 0
lost_total_amountnumber必填
丢失-总成本
(精度：2位小数)
示例 0
midinteger必填
站点id
示例 4
mskustring必填
msku
示例 7501XH1856
other_events_countinteger必填
其他-数量
other_events_logistic_amountnumber必填
其他-物流成本
(精度：2位小数)
示例 0
other_events_other_amountnumber必填
其他-其他成本
(精度：2位小数)
示例 0
other_events_total_amountnumber必填
其他-总成本
(精度：2位小数)
示例 0
parent_asinstring必填
父Asin
示例 B07NL8PKF2
parent_nodestring必填
是否父节点
示例 true
product_category_namestring必填
产品分类名
示例 产品分类名1
product_idinteger必填
产品id
示例 2
receipts_countinteger必填
货物补货-数量
receipts_logistic_amountnumber必填
货物补货-物流成本
(精度：2位小数)
示例 0
receipts_other_amountnumber必填
货物补货-其他成本
(精度：2位小数)
示例 0
receipts_total_amountnumber必填
货物补货-总成本
(精度：2位小数)
示例 0
shipments_countinteger必填
订单发货-数量
shipments_logistic_amountnumber必填
订单发货-物流成本
(精度：2位小数)
示例 0
shipments_other_amountnumber必填
订单发货-其他成本
(精度：2位小数)
示例 0
shipments_total_amountnumber必填
订单发货-总成本
(精度：2位小数)
示例 0
sidinteger必填
店铺id
示例 3
seller_idstring必填
亚马逊店铺id
示例 xxxxxxxxxxxxxxxx
start_countinteger必填
期初库存-数量
start_logistic_amountnumber必填
期初库存-物流成本
(精度：2位小数)
示例 0
start_other_amountnumber必填
期初库存-其他成本
(精度：2位小数)
示例 0
start_total_amountnumber必填
期初库存-总成本
(精度：2位小数)
示例 0
stock_to_use_ratenumber必填
存销比
(精度：2位小数)
示例 0
valuation_methodinteger必填
计价方法:
1-先进先出
2-移动加权
3-月末加权
示例 1
vendor_returns_countinteger必填
库存移除-数量
vendor_returns_logistic_amountnumber必填
库存移除-物流成本
示例 0
vendor_returns_other_amountnumber必填
库存移除-其他成本
示例 0
vendor_returns_total_amountnumber必填
库存移除-总成本
示例 0
whse_transfers_logistic_amountnumber必填
库房转运-物流成本
(精度：2位小数)
示例 0
whse_transfers_other_amountnumber必填
库房转运-其他成本
(精度：2位小数)
示例 0
whse_transfers_total_amountnumber必填
库房转运-总成本
(精度：2位小数)
示例 0
whse_transfers_countinteger必填
库房转运-数量
widinteger必填
系统仓库id
示例 123
ware_house_namestring必填
仓库名称
示例 仓库名称213
child_dataarray<any>必填
返回字段与上级row_data一致
示例 &nbsp;

返回成功示例

{
    "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
    }
}