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