Lingxing
切换旧版

库存报表 - FBA - 历史报表 - 汇总 - 明细

POST/erp/sc/routing/fba/fbaStockReport/getList

接口信息

API Path请求协议请求方式令牌桶容量
/erp/sc/routing/fba/fbaStockReport/getListHTTPSPOST1

请求参数

start_monthstring
开始月份，默认当前月份
end_monthstring
截至月份，默认当前月份
seller_idstring
亚马逊店铺id ,对应查询亚马逊店铺列表接口对应字段【seller_id】
dimentioninteger
数据维度：
1 汇总
2 明细【默认值】
offsetinteger
分页偏移量【dimention=2 明细维度生效】，默认0
lengthinteger
分页长度【dimention=2 明细维度生效】，默认20，上限5000
attributeinteger
可售状态：【dimention=2 明细维度生效】
0 不可售
1 可售
2 全部【默认值】

请求示例

{
    "start_month": "2023-08",
    "end_month": "2024-07",
    "seller_id": "A1R1A0FMFL8",
    "dimention": 1,
    "offset": 0,
    "length": 20,
    "attribute": 2
}

返回结果 - 明细维度

Json Object

参数名说明必填类型示例
code状态码，0 成功是[int]0
message消息提示是[string]success
error_details错误信息是[array]
request_id请求链路id是[string]8D680B8B-3C6F-3E16-F055-73DC70EAD977
response_time响应时间是[string]2020-05-18 11:23:47
data数据是[array]
data>>ware_house_name仓库名称是[string]仓库1
data>>asinASIN是[string]xxxxx
data>>skuSKU是[string]xxxxxxx
data>>fnskuFNSKU是[string]xxxxxx
data>>sku_name品名是[string]xxxxxx
data>>brand_name品牌名称是[string]xxxxxxx
data>>category_name1一级类目-名称是[string]xxx
data>>category_name2二级类目-名称是[string]xxxx
data>>category_name3三级类目-名称是[string]xxxxx
data>>is_saleable库存属性：
全部
可售
不可售		是[string]全部
data>>global_tags_strlisting标签是[string]xxxx
data>>seller_skuMSKU是[string]mskuxxxx
data>>person负责人是[string]xxxx
data>>year_month月份是[string]202206-202301
data>>first_stock_num期初库存(数量)是[int]
data>>first_stock_data期初库存(总成本)是[string]0.00
data>>first_stock_data_1期初库存(商品成本）是[string]0.00
data>>first_stock_data_2期初库存(头程成本)是[string]0.00
data>>shipment_num货件补货(数量)是[int]
data>>shipment_data货件补货(总成本)是[string]0.00
data>>shipment_data_1货件补货(商品成本)是[string]0.00
data>>shipment_data_2货件补货(头程成本)是[string]0.00
data>>order_num订单发货(数量)是[int]
data>>order_data订单发货(总成本)是[string]0.00
data>>order_data_1订单发货(商品成本)是[string]0.00
data>>order_data_2订单发货(头程成本)是[string]0.00
data>>refund_num买家退货(数量)是[int]
data>>refund_data买家退货(总成本)是[string]0.00
data>>refund_data_1买家退货(商品成本)是[string]0.00
data>>refund_data_2买家退货(头程成本)是[string]0.00
data>>adjust_num库存调整(数量)是[int]
data>>adjust_data库存调整(总成本)是[string]0.00
data>>adjust_data_1库存调整(商品成本)是[string]0.00
data>>adjust_data_2库存调整(头程成本)是[string]0.00
data>>stock_move_num库存移除(数量)是[int]
data>>stock_move_data库存移除(总成本)是[string]0.00
data>>stock_move_data_1库存移除(商品成本)是[string]0.00
data>>stock_move_data_2库存移除(头程成本)是[string]0.00
data>>stock_diff_num库存差异(数量)是[int]
data>>stock_diff_data库存差异(总成本)是[string]0.00
data>>stock_diff_data_1库存差异(商品成本)是[string]0.00
data>>stock_diff_data_2库存差异(头程成本)是[string]0.00
data>>end_stock_num期末库存(数量)是[int]
data>>end_stock_data期末库存(总成本)是[string]0.00
data>>end_stock_data_1期末库存(商品成本)是[string]0.00
data>>end_stock_data_2期末库存(头程成本)是[string]0.00
data>>end_shipping_num期末在途(数量)是[string]
data>>end_shipping_data期末在途(总成本)是[string]0.00
data>>end_shipping_data_1期末在途(商品成本)是[string]0.00
data>>end_shipping_data_2期末在途(头程成本)是[string]0.00
data>>cycle_rate库存周转率(成本)是[number]0.00
data>>cycle_rate_num库存周转率(数量)是[int]
data>>cycle_day库存周转天数(成本)是[int]
data>>cycle_day_num库存周转天数(数量)是[int]
data>>stock_use_rate存销比(成本)是[number]
data>>stock_use_num存销比(数量)是[int]
message错误消息是[string]
request_id请求链路id是[string]
response_time响应时间是[string]
total查询总数是[int]1

返回结果 - 汇总维度

Json Object

参数名说明必填类型示例
code状态码，0 成功是[int]0
message消息提示是[string]success
error_details错误信息是[array]
request_id请求链路id是[string]8D680B8B-3C6F-3E16-F055-73DC70EAD977
response_time响应时间是[string]2020-05-18 11:23:47
data数据是[array]
data>>ware_house_name仓库名称是[string]仓库1
data>>year_month月份是[string]202206-202301
data>>first_stock_num期初库存(数量)是[int]
data>>first_stock_data期初库存(总成本)是[string]0.00
data>>first_stock_data_1期初库存(商品成本）是[string]0.00
data>>first_stock_data_2期初库存(头程成本)是[string]0.00
data>>shipment_num货件补货(数量)是[int]
data>>shipment_data货件补货(总成本)是[string]0.00
data>>shipment_data_1货件补货(商品成本)是[string]0.00
data>>shipment_data_2货件补货(头程成本)是[string]0.00
data>>order_num订单发货(数量)是[int]
data>>order_data订单发货(总成本)是[string]0.00
data>>order_data_1订单发货(商品成本)是[string]0.00
data>>order_data_2订单发货(头程成本)是[string]0.00
data>>refund_num买家退货(数量)是[int]
data>>refund_data买家退货(总成本)是[string]0.00
data>>refund_data_1买家退货(商品成本)是[string]0.00
data>>refund_data_2买家退货(头程成本)是[string]0.00
data>>adjust_num库存调整(数量)是[int]
data>>adjust_data库存调整(总成本)是[string]0.00
data>>adjust_data_1库存调整(商品成本)是[string]0.00
data>>adjust_data_2库存调整(头程成本)是[string]0.00
data>>stock_move_num库存移除(数量)是[int]
data>>stock_move_data库存移除(总成本)是[string]0.00
data>>stock_move_data_1库存移除(商品成本)是[string]0.00
data>>stock_move_data_2库存移除(头程成本)是[string]0.00
data>>stock_diff_num库存差异(数量)是[int]
data>>stock_diff_data库存差异(总成本)是[string]0.00
data>>stock_diff_data_1库存差异(商品成本)是[string]0.00
data>>stock_diff_data_2库存差异(头程成本)是[string]0.00
data>>end_stock_num期末库存(数量)是[int]
data>>end_stock_data期末库存(总成本)是[string]0.00
data>>end_stock_data_1期末库存(商品成本)是[string]0.00
data>>end_stock_data_2期末库存(头程成本)是[string]0.00
data>>end_shipping_num期末在途(数量)是[string]
data>>end_shipping_data期末在途(总成本)是[string]0.00
data>>end_shipping_data_1期末在途(商品成本)是[string]0.00
data>>end_shipping_data_2期末在途(头程成本)是[string]0.00
data>>cycle_rate库存周转率(成本)是[number]0.00
data>>cycle_rate_num库存周转率(数量)是[int]
data>>cycle_day库存周转天数(成本)是[int]
data>>cycle_day_num库存周转天数(数量)是[int]
data>>stock_use_rate存销比(成本)是[number]
data>>stock_use_num存销比(数量)是[int]
data>>shelf_sale_rate动销率是[number]
message错误消息是[string]
request_id请求链路id是[string]
response_time响应时间是[string]
total查询总数是[int]1

返回成功示例

#明细
{
    "code": 0,
    "message": "success",
    "request_id": "557581a380f4447b959d4adf777dfa09",
    "response_time": "2022-12-21 18:45:50"
    "total": 2071,
    "data": [
        {
            "seller_sku": "MSKU0D9001E2",
            "asin": "",
            "fnsku": "",
            "sku": null,
            "sku_name": null,
            "ware_house_name": "8P-SPEED",
            "year_month": "202104-202112",
            "category_name1": "",
            "category_name2": "",
            "category_name3": "",
            "brand_name": "",
            "person": "",
            "is_saleable": "全部",
            "global_tags_str": "",
            "first_stock_num": 0,
            "first_stock_data": "0.00",
            "first_stock_data_1": "0.00",
            "first_stock_data_2": "0.00",
            "shipment_num": 0,
            "shipment_data": "0.00",
            "shipment_data_1": "0.00",
            "shipment_data_2": "0.00",
            "order_num": 0,
            "order_data": "0.00",
            "order_data_1": "0.00",
            "order_data_2": "0.00",
            "refund_num": 0,
            "refund_data": "0.00",
            "refund_data_1": "0.00",
            "refund_data_2": "0.00",
            "adjust_num": 0,
            "adjust_data": "0.00",
            "adjust_data_1": "0.00",
            "adjust_data_2": "0.00",
            "stock_move_num": 0,
            "stock_move_data": "0.00",
            "stock_move_data_1": "0.00",
            "stock_move_data_2": "0.00",
            "stock_diff_num": 0,
            "stock_diff_data": "0.00",
            "stock_diff_data_1": "0.00",
            "stock_diff_data_2": "0.00",
            "end_stock_num": 0,
            "end_stock_data": "0.00",
            "end_stock_data_1": "0.00",
            "end_stock_data_2": "0.00",
            "end_shipping_num": 0,
            "end_shipping_data": "0.00",
            "end_shipping_data_1": "0.00",
            "end_shipping_data_2": "0.00",
            "cycle_rate": 0,
            "cycle_rate_num": 0,
            "cycle_day": 0,
            "cycle_day_num": 0,
            "stock_use_rate": 0,
            "stock_use_num": 0
        }
    ]
}


#汇总
{
    "code": 0,
    "message": "success",
    "request_id": "557581a380f4447b959d4adf777dfa09",
    "response_time": "2022-12-21 18:44:54"
    "total": 12,
    "data": [
        {
            "ware_house_name": "8P-SPEED",
            "year_month": "202104-202112",
            "first_stock_num": 0,
            "first_stock_data": "0.00",
            "first_stock_data_1": "0.00",
            "first_stock_data_2": "0.00",
            "shipment_num": 0,
            "shipment_data": "0.00",
            "shipment_data_1": "0.00",
            "shipment_data_2": "0.00",
            "order_num": 0,
            "order_data": "0.00",
            "order_data_1": "0.00",
            "order_data_2": "0.00",
            "refund_num": 0,
            "refund_data": "0.00",
            "refund_data_1": "0.00",
            "refund_data_2": "0.00",
            "adjust_num": 0,
            "adjust_data": "0.00",
            "adjust_data_1": "0.00",
            "adjust_data_2": "0.00",
            "stock_move_num": 0,
            "stock_move_data": "0.00",
            "stock_move_data_1": "0.00",
            "stock_move_data_2": "0.00",
            "stock_diff_num": 0,
            "stock_diff_data": "0.00",
            "stock_diff_data_1": "0.00",
            "stock_diff_data_2": "0.00",
            "end_stock_num": 0,
            "end_stock_data": "0.00",
            "end_stock_data_1": "0.00",
            "end_stock_data_2": "0.00",
            "end_shipping_num": 0,
            "end_shipping_data": "0.00",
            "end_shipping_data_1": "0.00",
            "end_shipping_data_2": "0.00",
            "cycle_rate": 0,
            "cycle_rate_num": 0,
            "cycle_day": 0,
            "cycle_day_num": 0,
            "stock_use_rate": 0,
            "stock_use_num": 0,
            "shelf_sale_rate": 0
        }
    ]
}

返回失败示例

{
    "code": 500,
    "message": "系统错误",
    "data": null,
    "total": 0,
    "request_id": "557581a380f4447b959d4adf777dfa09",
    "response_time": "2022-12-21 18:44:54"
}