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 · 请求参数 13 个(必填 0) · 响应参数 84 个 · 限流令牌桶容量 1
Updated At
2026-11-21

统计 - 查询退货分析

POST/basicOpen/salesAnalysis/returnOrder/analysisLists
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/salesAnalysis/returnOrder/analysisLists"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/salesAnalysis/returnOrder/analysisLists?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"endDate\": \"2024-11-12\",\n    \"length\": 20,\n    \"offset\": 0,\n    \"startDate\": \"2024-11-01\",\n    \"asinType\": \"msku\",\n    \"dateType\": 0,\n    \"mids\": [1,2,3],\n    \"principalUid\": [1234567890,9876543210],\n    \"searchField\": \"msku\",\n    \"searchValue\": [\"TEST-SKU-001\",\"TEST-SKU-002\"],\n    \"sortField\": \"curReturnGoodsCount\",\n    \"sortType\": \"DESC\",\n    \"storeId\": [123456789012345]\n}'",
  "responseExample": {
    "code": 0,
    "data": {
      "records": [
        {
          "asinsList": [
            {
              "asin": "B08XYZ123AB",
              "asinUrl": ""
            }
          ],
          "curReturnGoodsCount": 30,
          "curReturnGoodsCountDistribution": {
            "fbaQuantity": 25,
            "fbmQuantity": 5
          },
          "curReturnGoodsItems": 20,
          "curReturnGoodsItemsDistribution": {
            "fbaQuantity": 15,
            "fbmQuantity": 5
          },
          "curReturnGoodsVolumeRatio": "5.00%",
          "curVolume": 600,
          "eventDate": "2024-06-10",
          "fnskuInfoList": [
            {
              "fnsku": "X001ABC123",
              "msku": "TEST-MSKU-001"
            }
          ],
          "infoDTOList": [
            {
              "asin": "B08XYZ123AB",
              "asinUrl": "",
              "bid": 9876543210,
              "brandTitle": "MyBrand",
              "categoryTitle": "服装",
              "cid": "12345",
              "country": "US",
              "fnsku": "X001ABC123",
              "fulfillmentChannel": "FBA",
              "localName": "男士圆领T恤",
              "localSku": "LOCAL-SKU-001",
              "msku": "TEST-MSKU-001",
              "sellerName": "MyAmazonStore",
              "sid": 1234567890,
              "smallImageUrl": "",
              "spu": "SPU-2024-001",
              "spuName": "夏季T恤系列"
            }
          ],
          "isParent": "1",
          "localSkuInfoList": [
            {
              "localName": "男士圆领T恤",
              "localSku": "LOCAL-SKU-001"
            }
          ],
          "mostCommonReturnReasonBucket": "产品质量问题",
          "msku": "TEST-MSKU-001",
          "ncxCount": 7,
          "ncxRate": "3.50%",
          "orderCount": 200,
          "parentAsinsList": "[\"B08XYZABC1\",\"B09ABCXYZ2\"]",
          "pcxHealth": "Good",
          "preReturnGoodsCount": 25,
          "preReturnGoodsItems": 15,
          "preReturnGoodsVolumeRatio": "5.00%",
          "preVolume": 500,
          "returnBadge": "高退货率",
          "returnGoodsCountRatio": "20.00%",
          "returnGoodsVolumeRatioDiff": "1.50%",
          "selFnskuSkuInfoList": [
            {
              "country": "US",
              "fnsku": "X001ABC123",
              "localName": "男士圆领T恤",
              "localSku": "LOCAL-SKU-001",
              "msku": "TEST-MSKU-001",
              "sellerName": "MyAmazonStore",
              "sid": 1234567890
            }
          ],
          "selfnskuInfoList": [
            {
              "country": "US",
              "fnsku": "X001ABC123",
              "msku": "TEST-MSKU-001",
              "sellerName": "MyAmazonStore",
              "sid": 1234567890
            }
          ],
          "sellerInfoList": [
            {
              "country": "US",
              "sellerName": "MyAmazonStore",
              "sid": 1234567890
            }
          ],
          "sid": 1234567890,
          "spuInfoList": [
            {
              "spu": "SPU-2024-001",
              "spuName": "夏季T恤系列"
            }
          ]
        }
      ],
      "total": 100
    },
    "error_details": [],
    "message": "value",
    "request_id": "value",
    "response_time": "value",
    "total": 0
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1endDate结束日期string—Optional结束日期,格式:yyyy-MM-dd,与startDate配合使用,最多支持366天范围
2length分页长度integer—Optional分页长度,每页数据条数
3offset分页偏移量integer—Optional分页偏移量,当前页码
4startDate开始日期string—Optional开始日期,格式:yyyy-MM-dd,与endDate配合使用,最多支持366天范围
5asinType维度类型string—Optional维度类型,枚举值:msku, asin, parentAsin, sku, spu(注意:不支持sid、country、category、band)
6dateType时间类型integer—Optional时间类型,枚举值:0-退货时间, 1-下单时间
7mids国家ID列表(mid)array<any>—Optional国家ID列表(mid)
8principalUid负责人ID列表array<any>—Optional负责人ID列表
9searchField搜索字段类型string—Optional搜索字段类型,枚举值:msku-MSKU, asin-ASIN, parentAsin-父ASIN, localSku-SKU, localName-品名, spu-SPU, spuName-款名
10searchValue搜索值列表array<any>—Optional搜索值列表,与searchField配合使用
11sortField排序字段string—Optional排序字段,枚举值:curReturnGoodsCount-退货量, returnGoodsCountRatio-退货量环比, curVolume-销量, curReturnGoodsVolumeRatio-退货率, returnGoodsVolumeRatioDiff-退货率环比差异
12sortType排序类型string—Optional排序类型,枚举值:ASC-升序, DESC-降序
13storeId店铺ID列表array<any>—Optional店铺ID列表

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code响应码integer—Required响应码
2data返回数据object—Required返回数据
2.1records退货分析记录列表array<object>—Required退货分析记录列表
2.1.1asinsListASIN列表array<object>—RequiredASIN列表
2.1.1.1asinasinstringB08XYZ123ABRequiredASIN,亚马逊标准识别号
2.1.1.2asinUrlASIN商品详情页URL地址string—RequiredASIN商品详情页URL地址
2.1.2curReturnGoodsCount当期退货量integer30Required当期退货量
2.1.3curReturnGoodsCountDistribution当期退货量分布明细(FBA/FBM)object—Required当期退货量分布明细(FBA/FBM)
2.1.3.1fbaQuantityFBA退货数量integer25RequiredFBA退货数量
2.1.3.2fbmQuantityFBM退货数量integer5RequiredFBM退货数量
2.1.4curReturnGoodsItems当期退货订单数integer20Required当期退货订单数
2.1.5curReturnGoodsItemsDistribution当期退货订单数分布明细(FBA/FBM)object—Required当期退货订单数分布明细(FBA/FBM)
2.1.5.1fbaQuantityFBA退货订单数integer15RequiredFBA退货订单数
2.1.5.2fbmQuantityFBM退货订单数integer5RequiredFBM退货订单数
2.1.6curReturnGoodsVolumeRatio当期退货率string5.00%Required当期退货率
2.1.7curVolume当期销量integer600Required当期销量
2.1.8eventDate买家之声-后台更新时间string2024-06-10Optional买家之声-后台更新时间,格式:yyyy-MM-dd,仅MSKU维度有此字段
2.1.9fnskuInfoListFNSKU信息列表array<object>—RequiredFNSKU信息列表
2.1.9.1fnskufnskustringX001ABC123RequiredFNSKU,亚马逊物流SKU
2.1.9.2mskumskustringTEST-MSKU-001RequiredMSKU,卖家SKU
2.1.10infoDTOList综合信息列表(包含商品、店铺、分类等详细信息)array<object>—Required综合信息列表(包含商品、店铺、分类等详细信息)
2.1.10.1asinasinstringB08XYZ123ABRequiredASIN,亚马逊标准识别号
2.1.10.2asinUrlASIN商品详情页URL地址string3RequiredASIN商品详情页URL地址
2.1.10.3bid品牌IDinteger9876543210Required品牌ID
2.1.10.4brandTitle品牌标题stringMyBrandRequired品牌标题
2.1.10.5categoryTitle商品分类标题string服装Required商品分类标题
2.1.10.6cid分类IDstring12345Required分类ID
2.1.10.7country国家代码stringUSRequired国家代码
2.1.10.8fnskufnskustringX001ABC123RequiredFNSKU,亚马逊物流SKU
2.1.10.9fulfillmentChannel配送渠道stringFBARequired配送渠道,枚举值:FBA-亚马逊配送, FBM-卖家自配送
2.1.10.10localName本地商品名称string男士圆领T恤Required本地商品名称,品名
2.1.10.11localSku本地SKUstringLOCAL-SKU-001Required本地SKU
2.1.10.12mskumskustringTEST-MSKU-001RequiredMSKU,卖家SKU
2.1.10.13sellerName店铺名称stringMyAmazonStoreRequired店铺名称
2.1.10.14sid店铺IDinteger1234567890Required店铺ID
2.1.10.15smallImageUrl商品小图片URL地址stringgRequired商品小图片URL地址
2.1.10.16spuSPU编码stringSPU-2024-001RequiredSPU编码
2.1.10.17spuNameSPU名称string夏季T恤系列RequiredSPU名称,款名
2.1.11isParent是否为父ASINstring1Required是否为父ASIN
2.1.12localSkuInfoList本地SKU信息列表array<object>—Required本地SKU信息列表
2.1.12.1localName本地商品名称string男士圆领T恤Required本地商品名称,品名
2.1.12.2localSku本地SKUstringLOCAL-SKU-001Required本地SKU
2.1.13mostCommonReturnReasonBucket买家之声-Top NCX Reasonstring产品质量问题Optional买家之声-Top NCX Reason,最常见的不满意原因,仅MSKU维度有此字段
2.1.14mskumskustringTEST-MSKU-001RequiredMSKU,卖家SKU
2.1.15ncxCount买家之声-不满意订单数integer7Optional买家之声-不满意订单数,仅MSKU/ASIN/父ASIN维度有此字段
2.1.16ncxRate买家之声-不满意率string3.50%Optional买家之声-不满意率,百分比格式,仅MSKU/ASIN/父ASIN维度有此字段
2.1.17orderCount买家之声-订单总数integer200Optional买家之声-订单总数,仅MSKU/ASIN/父ASIN维度有此字段
2.1.18parentAsinsList父ASIN列表array<any>["B08XYZABC1","B09ABCXYZ2"]Required父ASIN列表
2.1.19pcxHealth买家之声-满意度状况stringGoodOptional买家之声-满意度状况,枚举值:Good-良好, Fair-一般, Poor-差,仅MSKU维度有此字段
2.1.20preReturnGoodsCount上期退货量integer25Required上期退货量
2.1.21preReturnGoodsItems上期退货订单数integer15Required上期退货订单数
2.1.22preReturnGoodsVolumeRatio上期退货率string5.00%Required上期退货率
2.1.23preVolume上期销量integer500Required上期销量
2.1.24returnBadge退货标记string高退货率Optional退货标记,仅MSKU/ASIN/父ASIN维度有此字段
2.1.25returnGoodsCountRatio退货量环比string20.00%Required退货量环比,相对于上期的增长率
2.1.26returnGoodsVolumeRatioDiff退货率环比差异string1.50%Required退货率环比差异,当期退货率与上期退货率的差值
2.1.27selFnskuSkuInfoList店铺FNSKU+SKU综合信息列表array<object>—Required店铺FNSKU+SKU综合信息列表
2.1.27.1country国家代码stringUSRequired国家代码
2.1.27.2fnskufnskustringX001ABC123RequiredFNSKU,亚马逊物流SKU
2.1.27.3localName本地商品名称string男士圆领T恤Required本地商品名称,品名
2.1.27.4localSku本地SKUstringLOCAL-SKU-001Required本地SKU
2.1.27.5mskumskustringTEST-MSKU-001RequiredMSKU,卖家SKU
2.1.27.6sellerName店铺名称stringMyAmazonStoreRequired店铺名称
2.1.27.7sid店铺IDinteger1234567890Required店铺ID
2.1.28selfnskuInfoList店铺FNSKU信息列表array<object>—Required店铺FNSKU信息列表
2.1.28.1country国家代码stringUSRequired国家代码
2.1.28.2fnskufnskustringX001ABC123RequiredFNSKU,亚马逊物流SKU
2.1.28.3mskumskustringTEST-MSKU-001RequiredMSKU,卖家SKU
2.1.28.4sellerName店铺名称stringMyAmazonStoreRequired店铺名称
2.1.28.5sid店铺IDinteger1234567890Required店铺ID
2.1.29sellerInfoList店铺信息列表array<object>—Required店铺信息列表
2.1.29.1country国家代码stringUSRequired国家代码
2.1.29.2sellerName店铺名称stringMyAmazonStoreRequired店铺名称
2.1.29.3sid店铺IDinteger1234567890Required店铺ID
2.1.30sid店铺IDinteger1234567890Required店铺ID
2.1.31spuInfoListSPU信息列表array<object>—RequiredSPU信息列表
2.1.31.1spuSPU编码stringSPU-2024-001RequiredSPU编码
2.1.31.2spuNameSPU名称string夏季T恤系列RequiredSPU名称,款名
2.2total总记录数integer100Required总记录数
3error_details错误详情array<any>—Required错误详情
4message提示信息string—Required提示信息
5request_id请求idstring—Required请求id
6response_time响应时间string—Required响应时间
7total总记录数integer—Required总记录数

The 统计 - 查询退货分析 API (/basicOpen/salesAnalysis/returnOrder/analysisLists) 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.