Qeasy Cloud
Get Started

领星ERP 查询售后订单列表 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
销售 / 平台订单 · POST · 请求参数 8 个(必填 2) · 响应参数 66 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询售后订单列表

POST/erp/sc/routing/amzod/order/afterSaleList
Factory
{
  "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
  }
}

Request Parameters

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

Response Parameters

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

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.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.