轻易云
注册体验

领星ERP查询售后订单列表接口

所属平台
领星ERP
类型
WebAPI
作用
QUERY
接口版本
1.0
适配器
\Adapter\LingXing\LXQueryAdapter
授权方式
OTHER
描述
销售 / 平台订单 · POST · 请求参数 8 个(必填 2) · 响应参数 66 个 · 限流令牌桶容量 1
更新日期
2026-11-21

查询售后订单列表

POST/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
  }
}

接口请求参数

序号字段名称类型默认值必填描述
1sid店铺idstring—可选店铺id,多个使用英文逗号分隔 ,对应查询亚马逊店铺列表接口对应字段【sid】
2start_date查询时间string—必填查询时间,左闭右开,格式:Y-m-d
3end_date查询时间string—必填查询时间,左闭右开,格式:Y-m-d
4date_type查询时间类型integer—可选查询时间类型:【默认1】 1 售后时间,对应data>>deal_time字段 2 订购时间 3 更新时间
5after_type售后类型string—可选售后类型,多个使用英文逗号分隔: 1 退款 2 退货 3 换货
6offset分页偏移量integer—可选分页偏移量,默认0
7length分页长度integer—可选分页长度,默认1000
8amazon_order_id_list亚马逊订单id列表array<any>—可选亚马逊订单id列表,上限50

接口响应参数

序号字段名称类型默认值必填描述
1code状态码integer0必填状态码,0 成功
2message消息提示stringsuccess必填消息提示
3error_details错误信息array<any>—必填错误信息
4request_id请求链路idstring3EE1982B-EDC3-0531-83DF-2BEA6F080DDA必填请求链路id
5response_time响应时间string2022-12-0714:54:56必填响应时间
6total总记录数integer1必填总记录数
7data响应数据array<object>—必填响应数据
7.1id记录idinteger12必填记录id,【非唯一键】
7.2amazon_order_id亚马逊订单号string687-0075130-7007581必填亚马逊订单号
7.3sid店铺idinteger1必填店铺id
7.4asinasinstringB0ABC50521必填asin
7.5mskumskustringMSKU52FB8CE必填msku
7.6correlation_id关联idinteger1必填关联id
7.7purchase_time订购时间string2022-05-12 20:35:18必填订购时间
7.8deal_time售后时间string2022-05-12 20:35:18必填售后时间 【同一个订单存在多个售后订单时,需以 item_list>>after_time 为准】
7.9gmt_modified更新时间string2022-05-12 20:35:18必填更新时间 【同一个订单存在多个售后订单时,需以 item_list>>data_update_time 为准】
7.10interval_days售后间隔天数integer10必填售后间隔天数
7.11is_mcf_order是否为多渠道订单integer1必填是否为多渠道订单: 0 默认值 1 普通订单 2 多渠道订单
7.12seller_country店铺国家信息stringXPXC美国必填店铺国家信息
7.13delivery_type配送方式stringFBA必填配送方式
7.14order_total_amount订单总金额string7.99必填订单总金额
7.15order_total_amount_currency_code订单总金额-货币单位string$必填订单总金额-货币单位
7.16order_total_amount_number订单总金额-金额string2.35必填订单总金额-金额
7.17total_refund_amount退款总金额string5.555555必填退款总金额
7.18total_refund_amount_currency_code退款总金额-货币单位string$必填退款总金额-货币单位
7.19total_refund_amount_number退款总金额-金额string-4.700必填退款总金额-金额
7.20total_refund_cost退款总费用string8.545622必填退款总费用
7.21total_refund_cost_currency_code退款总金额-货币单位string$必填退款总金额-货币单位
7.22total_refund_cost_number退款总成本-金额string0.300必填退款总成本-金额
7.23after_type_tag售后类型标签array<any>["退款","退货","换货"]必填售后类型标签
7.24item_list商品列表array<object>—必填商品列表
7.24.1small_image_url商品缩略图地址string—必填商品缩略图地址
7.24.2item_name商品标题stringproduct title 07E1A4C731必填商品标题
7.24.3local_sku本地产品skustring—必填本地产品sku
7.24.4local_name本地商品名称string[演示数据]Sony儿童耳机必填本地商品名称
7.24.5asinasinstringB0ABC50521必填asin
7.24.6asin_urlasin_urlstringhttps://xxxx/xxxx必填asin_url
7.24.7mskumskustringMSKU52FB8CE必填msku
7.24.8after_type售后类型string退款,退货,换货必填售后类型
7.24.9after_quantity售后数量integer2必填售后数量
7.24.10after_reason售后原因string5必填售后原因
7.24.11after_time售后时间string2022-02-10 16:00:05必填售后时间
7.24.12after_interval售后间隔string1天必填售后间隔
7.24.13data_update_time数据更新时间string2022-02-11 11:03:05必填数据更新时间
7.24.14refund_amount退款金额string-$28.0200必填退款金额
7.24.15refund_amount_details退款金额详情(有退款金额才会返回详情)array<object>—必填退款金额详情(有退款金额才会返回详情)
7.24.15.1type退款金额类型stringShippingCharge必填退款金额类型
7.24.15.2amount退款金额string-$6.3800必填退款金额
7.24.16refund_cost退款花费string$10.4300必填退款花费
7.24.17refund_cost_details退款花费详情(有退款花费才会返回详情)array<object>—必填退款花费详情(有退款花费才会返回详情)
7.24.17.1type退款花费类型stringRefundCommission必填退款花费类型
7.24.17.2amount退款花费string-$0.6000必填退款花费
7.24.18return_status退货状态stringApproved必填退货状态
7.24.19inventory_attributes库存属性string—必填库存属性
7.24.20lpn_numberLPN编号string—必填LPN编号
7.24.21buyers_note买家备注string—必填买家备注
7.24.22rma_order_numberRMA单号stringD5LCqzJZRRMA必填RMA单号
7.24.23carriers承运商stringUSPS必填承运商
7.24.24waybill_number运单号string9202090153540168949151必填运单号
7.24.25exchange_order_number换货订单号string113-2766421-2949046必填换货订单号
7.24.26md5md5唯一值【已废弃】stringc416fba9801f5c59bf5f787a7ea0a641必填md5唯一值【已废弃】
7.24.27md5_new新md5唯一值【已废弃】stringc416fba9801f5c59bf5f787a7ea0a642必填新md5唯一值【已废弃】,可参考两个唯一字段:item_identifier,md5_v2
7.24.28item_identifier唯一标识string—必填唯一标识
7.24.29md5_v2压缩后的唯一标识string—必填压缩后的唯一标识
7.24.30orderDateYear订单数据年份integer—必填订单数据年份
7.24.31row_index解析数据编号integer1必填解析数据编号

领星ERP的接口:查询售后订单列表(/erp/sc/routing/amzod/order/afterSaleList),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。

需要对接这个接口?

轻易云已预置该接口的适配能力,联系我们即可开始配置数据集成。