/erp/sc/routing/amzod/order/afterSaleList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/amzod/order/afterSaleList"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"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
},
"responseExample": {
"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
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | string | — | Optional | 店铺id,多个使用英文逗号分隔 ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | start_date | 查询时间 | string | — | Required | 查询时间,左闭右开,格式:Y-m-d |
| 3 | end_date | 查询时间 | string | — | Required | 查询时间,左闭右开,格式:Y-m-d |
| 4 | date_type | 查询时间类型 | integer | — | Optional | 查询时间类型:【默认1】 1 售后时间,对应data>>deal_time字段 2 订购时间 3 更新时间 |
| 5 | after_type | 售后类型 | string | — | Optional | 售后类型,多个使用英文逗号分隔: 1 退款 2 退货 3 换货 |
| 6 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 7 | length | 分页长度 | integer | — | Optional | 分页长度,默认1000 |
| 8 | amazon_order_id_list | 亚马逊订单id列表 | array<any> | — | Optional | 亚马逊订单id列表,上限50 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 3EE1982B-EDC3-0531-83DF-2BEA6F080DDA | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2022-12-0714:54:56 | Required | 响应时间 |
| 6 | total | 总记录数 | integer | 1 | Required | 总记录数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | id | 记录id | integer | 12 | Required | 记录id,【非唯一键】 |
| 7.2 | amazon_order_id | 亚马逊订单号 | string | 687-0075130-7007581 | Required | 亚马逊订单号 |
| 7.3 | sid | 店铺id | integer | 1 | Required | 店铺id |
| 7.4 | asin | asin | string | B0ABC50521 | Required | asin |
| 7.5 | msku | msku | string | MSKU52FB8CE | Required | msku |
| 7.6 | correlation_id | 关联id | integer | 1 | Required | 关联id |
| 7.7 | purchase_time | 订购时间 | string | 2022-05-12 20:35:18 | Required | 订购时间 |
| 7.8 | deal_time | 售后时间 | string | 2022-05-12 20:35:18 | Required | 售后时间 【同一个订单存在多个售后订单时,需以 item_list>>after_time 为准】 |
| 7.9 | gmt_modified | 更新时间 | string | 2022-05-12 20:35:18 | Required | 更新时间 【同一个订单存在多个售后订单时,需以 item_list>>data_update_time 为准】 |
| 7.10 | interval_days | 售后间隔天数 | integer | 10 | Required | 售后间隔天数 |
| 7.11 | is_mcf_order | 是否为多渠道订单 | integer | 1 | Required | 是否为多渠道订单: 0 默认值 1 普通订单 2 多渠道订单 |
| 7.12 | seller_country | 店铺国家信息 | string | XPXC美国 | Required | 店铺国家信息 |
| 7.13 | delivery_type | 配送方式 | string | FBA | Required | 配送方式 |
| 7.14 | order_total_amount | 订单总金额 | string | 7.99 | Required | 订单总金额 |
| 7.15 | order_total_amount_currency_code | 订单总金额-货币单位 | string | $ | Required | 订单总金额-货币单位 |
| 7.16 | order_total_amount_number | 订单总金额-金额 | string | 2.35 | Required | 订单总金额-金额 |
| 7.17 | total_refund_amount | 退款总金额 | string | 5.555555 | Required | 退款总金额 |
| 7.18 | total_refund_amount_currency_code | 退款总金额-货币单位 | string | $ | Required | 退款总金额-货币单位 |
| 7.19 | total_refund_amount_number | 退款总金额-金额 | string | -4.700 | Required | 退款总金额-金额 |
| 7.20 | total_refund_cost | 退款总费用 | string | 8.545622 | Required | 退款总费用 |
| 7.21 | total_refund_cost_currency_code | 退款总金额-货币单位 | string | $ | Required | 退款总金额-货币单位 |
| 7.22 | total_refund_cost_number | 退款总成本-金额 | string | 0.300 | Required | 退款总成本-金额 |
| 7.23 | after_type_tag | 售后类型标签 | array<any> | ["退款","退货","换货"] | Required | 售后类型标签 |
| 7.24 | item_list | 商品列表 | array<object> | — | Required | 商品列表 |
| 7.24.1 | small_image_url | 商品缩略图地址 | string | — | Required | 商品缩略图地址 |
| 7.24.2 | item_name | 商品标题 | string | product title 07E1A4C731 | Required | 商品标题 |
| 7.24.3 | local_sku | 本地产品sku | string | — | Required | 本地产品sku |
| 7.24.4 | local_name | 本地商品名称 | string | [演示数据]Sony儿童耳机 | Required | 本地商品名称 |
| 7.24.5 | asin | asin | string | B0ABC50521 | Required | asin |
| 7.24.6 | asin_url | asin_url | string | https://xxxx/xxxx | Required | asin_url |
| 7.24.7 | msku | msku | string | MSKU52FB8CE | Required | msku |
| 7.24.8 | after_type | 售后类型 | string | 退款,退货,换货 | Required | 售后类型 |
| 7.24.9 | after_quantity | 售后数量 | integer | 2 | Required | 售后数量 |
| 7.24.10 | after_reason | 售后原因 | string | 5 | Required | 售后原因 |
| 7.24.11 | after_time | 售后时间 | string | 2022-02-10 16:00:05 | Required | 售后时间 |
| 7.24.12 | after_interval | 售后间隔 | string | 1天 | Required | 售后间隔 |
| 7.24.13 | data_update_time | 数据更新时间 | string | 2022-02-11 11:03:05 | Required | 数据更新时间 |
| 7.24.14 | refund_amount | 退款金额 | string | -$28.0200 | Required | 退款金额 |
| 7.24.15 | refund_amount_details | 退款金额详情(有退款金额才会返回详情) | array<object> | — | Required | 退款金额详情(有退款金额才会返回详情) |
| 7.24.15.1 | type | 退款金额类型 | string | ShippingCharge | Required | 退款金额类型 |
| 7.24.15.2 | amount | 退款金额 | string | -$6.3800 | Required | 退款金额 |
| 7.24.16 | refund_cost | 退款花费 | string | $10.4300 | Required | 退款花费 |
| 7.24.17 | refund_cost_details | 退款花费详情(有退款花费才会返回详情) | array<object> | — | Required | 退款花费详情(有退款花费才会返回详情) |
| 7.24.17.1 | type | 退款花费类型 | string | RefundCommission | Required | 退款花费类型 |
| 7.24.17.2 | amount | 退款花费 | string | -$0.6000 | Required | 退款花费 |
| 7.24.18 | return_status | 退货状态 | string | Approved | Required | 退货状态 |
| 7.24.19 | inventory_attributes | 库存属性 | string | — | Required | 库存属性 |
| 7.24.20 | lpn_number | LPN编号 | string | — | Required | LPN编号 |
| 7.24.21 | buyers_note | 买家备注 | string | — | Required | 买家备注 |
| 7.24.22 | rma_order_number | RMA单号 | string | D5LCqzJZRRMA | Required | RMA单号 |
| 7.24.23 | carriers | 承运商 | string | USPS | Required | 承运商 |
| 7.24.24 | waybill_number | 运单号 | string | 9202090153540168949151 | Required | 运单号 |
| 7.24.25 | exchange_order_number | 换货订单号 | string | 113-2766421-2949046 | Required | 换货订单号 |
| 7.24.26 | md5 | md5唯一值【已废弃】 | string | c416fba9801f5c59bf5f787a7ea0a641 | Required | md5唯一值【已废弃】 |
| 7.24.27 | md5_new | 新md5唯一值【已废弃】 | string | c416fba9801f5c59bf5f787a7ea0a642 | Required | 新md5唯一值【已废弃】,可参考两个唯一字段:item_identifier,md5_v2 |
| 7.24.28 | item_identifier | 唯一标识 | string | — | Required | 唯一标识 |
| 7.24.29 | md5_v2 | 压缩后的唯一标识 | string | — | Required | 压缩后的唯一标识 |
| 7.24.30 | orderDateYear | 订单数据年份 | integer | — | Required | 订单数据年份 |
| 7.24.31 | row_index | 解析数据编号 | integer | 1 | Required | 解析数据编号 |
The 查询售后订单列表 API (/erp/sc/routing/amzod/order/afterSaleList) of 领星ERP is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 领星ERP version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.