Lingxing
切换旧版

查询售后订单列表

POST/erp/sc/routing/amzod/order/afterSaleList

支持查询【销售】>【售后订单】数据

API Path请求协议请求方式令牌桶容量
/erp/sc/routing/amzod/order/afterSaleListHTTPSPOST1

请求参数

sidstring
店铺id,多个使用英文逗号分隔 ,对应查询亚马逊店铺列表接口对应字段【sid】
start_datestring必填
查询时间,左闭右开,格式:Y-m-d
end_datestring必填
查询时间,左闭右开,格式:Y-m-d
date_typeinteger
查询时间类型:【默认1】
1 售后时间,对应data>>deal_time字段
2 订购时间
3 更新时间
after_typestring
售后类型,多个使用英文逗号分隔:
1 退款
2 退货
3 换货
offsetinteger
分页偏移量,默认0
lengthinteger
分页长度,默认1000
amazon_order_id_listarray<any>
亚马逊订单id列表,上限50

请求示例

{
    "sid":"6,7,19",
    "start_date":"2022-02-01",
    "end_date":"2022-03-01",
    "data_type":2,
    "after_type":"1,2",
    "offset":0,
    "length":1000
}

返回结果

Json Object

codeinteger必填
状态码,0 成功
示例 0
messagestring必填
消息提示
示例 success
error_detailsarray<any>必填
错误信息
request_idstring必填
请求链路id
示例 3EE1982B-EDC3-0531-83DF-2BEA6F080DDA
response_timestring必填
响应时间
示例 2022-12-0714:54:56
totalinteger必填
总记录数
示例 1
dataarray<object>必填
响应数据
隐藏子属性
idinteger必填
记录id,【非唯一键】
示例 12
amazon_order_idstring必填
亚马逊订单号
示例 687-0075130-7007581
sidinteger必填
店铺id
示例 1
asinstring必填
asin
示例 B0ABC50521
mskustring必填
msku
示例 MSKU52FB8CE
correlation_idinteger必填
关联id
示例 1
purchase_timestring必填
订购时间
示例 2022-05-12 20:35:18
deal_timestring必填
售后时间
【同一个订单存在多个售后订单时,需以 item_list>>after_time 为准】
示例 2022-05-12 20:35:18
gmt_modifiedstring必填
更新时间
【同一个订单存在多个售后订单时,需以 item_list>>data_update_time 为准】
示例 2022-05-12 20:35:18
interval_daysinteger必填
售后间隔天数
示例 10
is_mcf_orderinteger必填
是否为多渠道订单:
0 默认值
1 普通订单
2 多渠道订单
示例 1
seller_countrystring必填
店铺国家信息
示例 XPXC美国
delivery_typestring必填
配送方式
示例 FBA
order_total_amountstring必填
订单总金额
示例 7.99
order_total_amount_currency_codestring必填
订单总金额-货币单位
示例 $
order_total_amount_numberstring必填
订单总金额-金额
示例 2.35
total_refund_amountstring必填
退款总金额
示例 5.555555
total_refund_amount_currency_codestring必填
退款总金额-货币单位
示例 $
total_refund_amount_numberstring必填
退款总金额-金额
示例 -4.700
total_refund_coststring必填
退款总费用
示例 8.545622
total_refund_cost_currency_codestring必填
退款总金额-货币单位
示例 $
total_refund_cost_numberstring必填
退款总成本-金额
示例 0.300
after_type_tagarray<any>必填
售后类型标签
示例 ["退款","退货","换货"]
item_listarray<object>必填
商品列表
隐藏子属性
small_image_urlstring必填
商品缩略图地址
item_namestring必填
商品标题
示例 product title 07E1A4C731
local_skustring必填
本地产品sku
local_namestring必填
本地商品名称
示例 [演示数据]Sony儿童耳机
asinstring必填
asin
示例 B0ABC50521
asin_urlstring必填
asin_url
示例 https://xxxx/xxxx
mskustring必填
msku
示例 MSKU52FB8CE
after_typestring必填
售后类型
示例 退款,退货,换货
after_quantityinteger必填
售后数量
示例 2
after_reasonstring必填
售后原因
示例 5
after_timestring必填
售后时间
示例 2022-02-10 16:00:05
after_intervalstring必填
售后间隔
示例 1天
data_update_timestring必填
数据更新时间
示例 2022-02-11 11:03:05
refund_amountstring必填
退款金额
示例 -$28.0200
refund_amount_detailsarray<object>必填
退款金额详情(有退款金额才会返回详情)
隐藏子属性
typestring必填
退款金额类型
示例 ShippingCharge
amountstring必填
退款金额
示例 -$6.3800
refund_coststring必填
退款花费
示例 $10.4300
refund_cost_detailsarray<object>必填
退款花费详情(有退款花费才会返回详情)
隐藏子属性
typestring必填
退款花费类型
示例 RefundCommission
amountstring必填
退款花费
示例 -$0.6000
return_statusstring必填
退货状态
示例 Approved
inventory_attributesstring必填
库存属性
lpn_numberstring必填
LPN编号
buyers_notestring必填
买家备注
rma_order_numberstring必填
RMA单号
示例 D5LCqzJZRRMA
carriersstring必填
承运商
示例 USPS
waybill_numberstring必填
运单号
示例 9202090153540168949151
exchange_order_numberstring必填
换货订单号
示例 113-2766421-2949046
md5string必填
md5唯一值【已废弃】
示例 c416fba9801f5c59bf5f787a7ea0a641
md5_newstring必填
新md5唯一值【已废弃】,可参考两个唯一字段:item_identifier,md5_v2
示例 c416fba9801f5c59bf5f787a7ea0a642
item_identifierstring必填
唯一标识
md5_v2string必填
压缩后的唯一标识
orderDateYearinteger必填
订单数据年份
row_indexinteger必填
解析数据编号
示例 1

返回成功示例

{
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "680C4F7A-D8F1-32B1-E078-BAEBE6230B85",
    "response_time": "2023-02-18 17:12:37",
    "data": [
        {
            "id": 33,
	        "asin": "B09MT9BKAD",
            "msku": "Pink_Head_Rope_12",
            "amazon_order_id": "113-9870855-8214638",
            "sid": 101,
            "purchase_time": "2023-02-07 23:41:08",
            "deal_time": "2023-02-16 23:50:50",
            "gmt_modified": "2023-02-17 11:36:17",
            "correlation_id": 3,
            "interval_days": 10,
            "is_mcf_order": 1,
            "seller_country": "8p-US 美国",
            "delivery_type": "FBM",
            "order_total_amount": "$2.35",
            "order_total_amount_currency_code": "$",
            "order_total_amount_number": "2.35",
            "total_refund_amount": "-$4.700",
            "total_refund_amount_currency_code": "$",
            "total_refund_amount__number": "-4.700",
            "total_refund_cost": "$0.300",
            "total_refund_cost_currency_code": "$",
            "total_refund_cost_number": "0.300",
            "after_type_tag": [
                "退款",
                "退货"
            ],
            "item_list": [
                {
                    "small_image_url": "https://xxxx/xxx.jpg",
                    "item_name": "Love Pearl Bottom Hair Circle",
                    "local_sku": "auto010",
                    "local_name": "自动010",
                    "asin": "B09MT9BKAD",
                    "asin_url": "https://www.amazon.com/dp/B09MT9BKAD",
                    "msku": "Pink_Head_Rope_12",
                    "after_type": "退货",
                    "after_time": "2023-02-17 00:00:00",
                    "data_update_time": "2023-02-17 16:54:14",
                    "after_interval": "10天",
                    "refund_amount": "",
                    "refund_cost": "",
                    "refund_currency_icon": "",
                    "after_quantity": 1,
                    "after_reason": "CR-ORDERED_WRONG_ITEM",
                    "return_status": "Approved",
                    "inventory_attributes": "",
                    "lpn_number": "",
                    "buyers_note": "自动化备注",
                    "rma_order_number": "D5LCqzJZRRMA",
                    "carriers": "USPS",
                    "waybill_number": "9202090153540168949151",
                    "exchange_order_number": "",
                    "md5": "e3e9ca874381650df28121eb1c74d8a9",
                    "md5_new": "e3e9ca874381650df28121eb1c74d8a1"
                },
                {
                    "small_image_url": "https://xxxx/xxx.jpg",
                    "item_name": "Love Pearl Bottom Hair Circle",
                    "local_sku": "auto010",
                    "local_name": "自动010",
                    "asin": "",
                    "asin_url": "",
                    "msku": "Pink_Head_Rope_12",
                    "fid": "1PBCVYGW03FZY",
                    "after_type": "退款",
                    "after_time": "2023-02-16 23:50:50",
                    "data_update_time": "2023-02-17 11:36:17",
                    "after_interval": "10天",
                    "refund_amount": "-$4.700",
                    "refund_amount_details": [
                        {
                            "type": "Goodwill",
                            "amount": "-$2.350"
                        },
                        {
                            "type": "Principal",
                            "amount": "-$2.000"
                        },
                        {
                            "type": "ShippingCharge",
                            "amount": "-$0.350"
                        }
                    ],
                    "refund_cost": "$0.300",
                    "refund_cost_details": [
                        {
                            "type": "Commission",
                            "amount": "$0.260"
                        },
                        {
                            "type": "ShippingHB",
                            "amount": "$0.040"
                        }
                    ],
                    "after_quantity": 1,
                    "after_reason": "",
                    "return_status": "",
                    "inventory_attributes": "",
                    "lpn_number": "",
                    "buyers_note": "",
                    "rma_order_number": "",
                    "carriers": "",
                    "waybill_number": "",
                    "exchange_order_number": "",
                    "md5": "a3f4403419630bb77076eac32bd6277c",
                    "md5_new": "a3f4403419630bb77076eac32bd6276c",
                    "row_index": 1
                }
            ]
        }
    ],
    "total": 1
}