Lingxing
切换旧版

库存报表 - FBA - 新版 - 明细

POST/cost/center/openApi/fba/detail/query

接口信息

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

请求参数

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

请求示例

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

返回结果

Json Object

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

返回成功示例

{
    "code": 0,
    "msg": "操作成功",
    "traceId": "7248e68e-e304-46b7-8ee7-4094dd57b61c.1673358502644",
    "data": {
        "row_data": [
            {
                "sid": 6,
                "mid": 1,
                "wid": 19,
                "ware_house_name": "_xinghai_direct-1美国仓",
                "parent_asin": "_b07_n_l8_p_k_f2",
                "msku": "7501_x_h1856",
                "asin": "_b07_n_l8_p_k_f2",
                "disposition": "all",
                "seller_id": "_a1_r1_a_a_b_f0_f_m_f_l8",
                "country_code": "_u_s",
                "fnsku": "_x0023_d_b_l_e_h",
                "product_id": null,
                "local_sku": "",
                "local_name": "",
                "cid": null,
                "product_category_name": "",
                "bid": null,
                "brand_name": "",
                "valuation_method": null,
                "shipments_count": 0,
                "shipments_total_amount": "0.00",
                "shipments_logistic_amount": "0.00",
                "shipments_other_amount": "0.00",
                "whse_transfers_count": 0,
                "whse_transfers_total_amount": "0.00",
                "whse_transfers_logistic_amount": "0.00",
                "whse_transfers_other_amount": "0.00",
                "disposed_count": 0,
                "disposed_total_amount": "0.00",
                "disposed_logistic_amount": "0.00",
                "disposed_other_amount": "0.00",
                "found_count": 0,
                "found_total_amount": "0.00",
                "found_logistic_amount": "0.00",
                "found_other_amount": "0.00",
                "lost_count": 0,
                "lost_total_amount": "0.00",
                "lost_logistic_amount": "0.00",
                "lost_other_amount": "0.00",
                "other_events_count": 0,
                "other_events_total_amount": "0.00",
                "other_events_logistic_amount": "0.00",
                "other_events_other_amount": "0.00",
                "receipts_count": 0,
                "receipts_total_amount": "0.00",
                "receipts_logistic_amount": "0.00",
                "receipts_other_amount": "0.00",
                "customer_returns_count": 0,
                "customer_returns_total_amount": "0.00",
                "customer_returns_logistic_amount": "0.00",
                "customer_returns_other_amount": "0.00",
                "vendor_returns_count": -1,
                "vendor_returns_total_amount": "0.00",
                "vendor_returns_logistic_amount": "0.00",
                "vendor_returns_other_amount": "0.00",
                "difference_count": 0,
                "difference_total_amount": "0.00",
                "difference_logistic_amount": "0.00",
                "difference_other_amount": "0.00",
                "start_count": 1,
                "start_total_amount": "0.00",
                "start_logistic_amount": "0.00",
                "start_other_amount": "0.00",
                "end_count": 0,
                "end_total_amount": "0.00",
                "end_logistic_amount": "0.00",
                "end_other_amount": "0.00",
                "damaged_count": 0,
                "damaged_total_amount": "0.00",
                "damaged_logistic_amount": "0.00",
                "damaged_other_amount": "0.00",
                "end_on_way_count": 0,
                "end_on_way_total_amount": "0.00",
                "end_on_way_logistic_amount": "0.00",
                "end_on_way_other_amount": "0.00",
                "parent_node": true,                
                "inventory_turnover_rate": "0.00",
                "inventory_turnover_days": "0.00",
                "stock_to_use_rate": "0.00",
                "adjustments_count": 0,
                "adjustments_total_amount": "0.00",
                "adjustments_logistic_amount": "0.00",
                "adjustments_other_amount": "0.00",
                "transferring_out_count": 0,
                "transferring_out_total_amount": "0.00",
                "transferring_out_logistic_amount": "0.00",
                "transferring_out_other_amount": "0.00",
                "child_data": [
                    {
                        "sid": 6,
                        "mid": 1,
                        "wid": 19,
                        "ware_house_name": "_xinghai_direct-1美国仓",
                        "parent_asin": "_b07_n_l8_p_k_f2",
                        "msku": "7501_x_h1856",
                        "asin": "_b07_n_l8_p_k_f2",
                        "disposition": "unsellable",
                        "seller_id": "_a1_r1_a_a_b_f0_f_m_f_l8",
                        "country_code": "_u_s",
                        "fnsku": "_x0023_d_b_l_e_h",
                        "product_id": null,
                        "local_sku": "",
                        "local_name": "",
                        "cid": null,
                        "product_category_name": "",
                        "bid": null,
                        "brand_name": "",
                        "valuation_method": null,
                        "shipments_count": 0,
                        "shipments_total_amount": "0.00",
                        "shipments_logistic_amount": "0.00",
                        "shipments_other_amount": "0.00",
                        "whse_transfers_count": 0,
                        "whse_transfers_total_amount": "0.00",
                        "whse_transfers_logistic_amount": "0.00",
                        "whse_transfers_other_amount": "0.00",
                        "disposed_count": 0,
                        "disposed_total_amount": "0.00",
                        "disposed_logistic_amount": "0.00",
                        "disposed_other_amount": "0.00",
                        "found_count": 0,
                        "found_total_amount": "0.00",
                        "found_logistic_amount": "0.00",
                        "found_other_amount": "0.00",
                        "lost_count": 0,
                        "lost_total_amount": "0.00",
                        "lost_logistic_amount": "0.00",
                        "lost_other_amount": "0.00",
                        "other_events_count": 0,
                        "other_events_total_amount": "0.00",
                        "other_events_logistic_amount": "0.00",
                        "other_events_other_amount": "0.00",
                        "receipts_count": 0,
                        "receipts_total_amount": "0.00",
                        "receipts_logistic_amount": "0.00",
                        "receipts_other_amount": "0.00",
                        "customer_returns_count": 0,
                        "customer_returns_total_amount": "0.00",
                        "customer_returns_logistic_amount": "0.00",
                        "customer_returns_other_amount": "0.00",
                        "vendor_returns_count": -1,
                        "vendor_returns_total_amount": "0.00",
                        "vendor_returns_logistic_amount": "0.00",
                        "vendor_returns_other_amount": "0.00",
                        "difference_count": 0,
                        "difference_total_amount": "0.00",
                        "difference_logistic_amount": "0.00",
                        "difference_other_amount": "0.00",
                        "start_count": 1,
                        "start_total_amount": "0.00",
                        "start_logistic_amount": "0.00",
                        "start_other_amount": "0.00",
                        "end_count": 0,
                        "end_total_amount": "0.00",
                        "end_logistic_amount": "0.00",
                        "end_other_amount": "0.00",
                        "damaged_count": 0,
                        "damaged_total_amount": "0.00",
                        "damaged_logistic_amount": "0.00",
                        "damaged_other_amount": "0.00",
                        "end_on_way_count": 0,
                        "end_on_way_total_amount": "0.00",
                        "end_on_way_logistic_amount": "0.00",
                        "end_on_way_other_amount": "0.00",
                        "parent_node": false,
                        "child_data": [],
                        "inventory_turnover_rate": "0.00",
                        "inventory_turnover_days": "0.00",
                        "stock_to_use_rate": "0.00",
                        "adjustments_count": 0,
                        "adjustments_total_amount": "0.00",
                        "adjustments_logistic_amount": "0.00",
                        "adjustments_other_amount": "0.00",
                        "transferring_out_count": 0,
                        "transferring_out_total_amount": "0.00",
                        "transferring_out_logistic_amount": "0.00",
                        "transferring_out_other_amount": "0.00",
                    }
                ]
            }
        ],
        "start_date": "2022-08-01",
        "end_date": "2022-08-31",
        "day_interval": 31,
        "total": 1,
        "size": 1,
        "current": 1,
        "amount_type": 0
    }
}