Qeasy Cloud
Get Started

领星ERP 查询Walmart产品表现 API

Platform
领星ERP
Type
WebAPI
Effect
QUERY
API Version
1.0
Adapter
\Adapter\LingXing\LXQueryAdapter
Auth Mode
OTHER
Description
多平台 / 统计 · POST · 请求参数 18 个(必填 3) · 响应参数 157 个 · 限流令牌桶容量 1
Updated At
2026-11-21

查询Walmart产品表现

POST/basicOpen/platformStatistics/walmartProductAnalysis/list
Factory
{
  "operation": {
    "method": "POST",
    "path": "/basicOpen/platformStatistics/walmartProductAnalysis/list"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 1,
    "text": ""
  },
  "requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/platformStatistics/walmartProductAnalysis/list?access_token=value&timestamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n    \"sids\": [1, 2],\n    \"dimensionType\": 1,\n    \"startDate\": \"2026-01-01\",\n    \"endDate\": \"2026-01-31\",\n    \"currencyCode\": \"USD\",\n    \"sortField\": \"sales_qty\",\n    \"sortType\": \"desc\",\n    \"pageNum\": 1,\n    \"pageSize\": 20\n}'",
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "a0d54debf93140f3b58d1ed81e8e3583",
    "response_time": "2026-06-01 12:00:00",
    "data": {
      "data": [
        {
          "acos": 0.15,
          "adClicks": 500,
          "adCvr": 0.08,
          "adImpressions": 10000,
          "adOrders": 40,
          "adSales": 1200,
          "adSpend": 180,
          "adUnits": 45,
          "area": "美国",
          "avgPrice": 29.99,
          "sellerSku": "MSKU001",
          "salesQty": 250,
          "salesAmount": 2000,
          "orderQty": 200,
          "wfsAvailable": 400,
          "storeName": "MyStore",
          "sid": 1
        }
      ],
      "total": {
        "acos": 0.12,
        "adSpend": 5000,
        "adUnits": 1500,
        "adOrders": 1400,
        "adSales": 42000,
        "salesQty": 9000,
        "salesAmount": 85000,
        "orderQty": 8000,
        "wfsAvailable": 15000,
        "currencyCode": "USD",
        "currencyIcon": "$"
      }
    },
    "total": 1
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1sids店铺ID列表array<any>—Optional店铺ID列表
2siteCodes站点筛选(多选array<any>—Optional站点筛选(多选, 传原始site_code, 如10008-US); 空=全部站点
3dimensionType维度类型integer—Required维度类型:1=MSKU,2=商品ID,3=SKU,4=店铺,5=父体
4startDate查询范围开始日期string—Required查询范围开始日期
5endDate查询范围结束日期string—Required查询范围结束日期
6currencyCode币种string—Optional币种,传空则为原币种
7searchField搜索字段类型integer—Optional搜索字段类型:1=商品ID,2=MSKU,3=SKU,4=标题,5=父体,6=品名
8searchValue搜索关键词array<any>—Optional搜索关键词
9brandIds品牌IDarray<any>—Optional品牌ID
10categoryIds分类IDarray<any>—Optional分类ID
11productStatus商品状态列表array<any>—Optional商品状态列表,可用值: 0=PUBLISHED 1=READY TO PUBLISH 2=IN PROGRESS 3=UNPUBLISHED 4=STAGE 5=SYSTEM PROBLEM 12=已加入站点
12adType广告类型筛选(多选)array<any>—Optional广告类型筛选(多选): 1=SP 2=SB 3=SV 空或包含0=全部不筛选
13attributionWindow归因期窗口integer—Optional归因期窗口: 3=3天 14=14天 30=30天
14sortField排序字段string—Optional排序字段,默认sales_qty。 可用值:sales_qty、order_qty、sales_amount、wfs_available、ad_spend、ad_units、ad_orders、ad_sales
15sortType排序类型string—Optional排序类型:asc、desc,默认desc
16pageNum当前页码integer—Optional当前页码
17pageSize页大小integer—Optional页大小
18parentKey展开子行的父行标识string—Optional展开子行的父行标识

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0:成功
2message消息提示stringsuccessRequired消息提示
3error_details数据校验失败时的错误详情array<any>—Required数据校验失败时的错误详情
4request_id请求链路idstringa0d54debf93140f3b58d1ed81e8e3583Required请求链路id
5response_time响应时间string2026-06-01 12:00:00Required响应时间
6data响应数据object—Required响应数据
6.1data列表数据array<object>—Required列表数据
6.1.1acosacosnumber0.15RequiredACOS
6.1.2adClicks点击量integer500Required点击量
6.1.3adCvr广告CVRnumber0.08Required广告CVR
6.1.4adImpressions曝光量integer10000Required曝光量
6.1.5adOrders广告订单量integer40Required广告订单量
6.1.6adSales广告销售额number1200Required广告销售额
6.1.7adSpend广告花费number180Required广告花费
6.1.8adUnits广告销量integer45Required广告销量
6.1.9area站点string美国Required站点
6.1.10avgPrice销售均价number29.99Required销售均价
6.1.11avgSales14d14天日均number8.5Required14天日均
6.1.12avgSales30d30天日均number7.2Required30天日均
6.1.13avgSales7d7天日均number9.8Required7天日均
6.1.14avgVolume销量日均number8Required销量日均
6.1.15baseInfoListMSKU底层明细array<object>—RequiredMSKU底层明细
6.1.15.1area站点string美国Required站点
6.1.15.2bid品牌IDinteger1Required品牌ID
6.1.15.3bname品牌名称stringBrandARequired品牌名称
6.1.15.4cid分类IDinteger10Required分类ID
6.1.15.5cname分类名称string电子产品Required分类名称
6.1.15.6imageUrl主图URLstringhttps://img.example.com/1.jpgRequired主图URL
6.1.15.7itemUrl商品链接stringhttps://www.walmart.com/ip/123Required商品链接
6.1.15.8localSkulocalSkustringSKU001RequiredSKU
6.1.15.9platformProductId商品IDstringPROD001Required商品ID
6.1.15.10platformProductName商品标题string示例商品标题Required商品标题
6.1.15.11platformStatus状态integer0Required状态
6.1.15.12pname品名string商品ARequired品名
6.1.15.13price价格number29.99Required价格
6.1.15.14rowKey子行唯一键string12345$&#124;$1Required子行唯一键
6.1.15.15salesQtyMSKU在所选区间的总销量integer250RequiredMSKU在所选区间的总销量
6.1.15.16sellerSkuMSKU名称stringMSKU001RequiredMSKU名称
6.1.15.17sellerSkuIdMSKU IDstring12345RequiredMSKU ID
6.1.15.18sid店铺IDinteger1Required店铺ID
6.1.15.19siteCode站点原始codestring10008-USRequired站点原始code
6.1.15.20spuId父体IDstringSPU001Required父体ID
6.1.15.21storeName店铺stringMyStoreRequired店铺
6.1.16bid品牌IDinteger1Required品牌ID
6.1.17bname品牌stringBrandARequired品牌
6.1.18buyerFreight客付运费number5Required客付运费
6.1.19cid分类IDinteger10Required分类ID
6.1.20cname分类string电子产品Required分类
6.1.21cpccpcnumber0.36RequiredCPC
6.1.22ctrctrnumber0.05RequiredCTR
6.1.23currencyCode币种代码stringUSDRequired币种代码
6.1.24currencyIcon币种图标string$Required币种图标
6.1.25directSales直接销售额number800Required直接销售额
6.1.26directUnits直接销量integer30Required直接销量
6.1.27imageUrl主图URLstringhttps://img.example.com/1.jpgRequired主图URL
6.1.28itemUrl商品链接stringhttps://www.walmart.com/ip/123Required商品链接
6.1.29localAvailable本地可用integer300Required本地可用
6.1.30localSkulocalSkustringSKU001RequiredSKU
6.1.31mskuCountMSKU子行数量integer2RequiredMSKU子行数量
6.1.32nonWfsAvailable非WFS可售integer50Required非WFS可售
6.1.33orderQty订单量integer200Required订单量
6.1.34overseasAvailable海外可用integer100Required海外可用
6.1.35platformProductId商品IDstringPROD001Required商品ID
6.1.36platformProductName标题string示例商品标题Required标题
6.1.37platformStatus状态integer0Required状态
6.1.38pname品名string商品ARequired品名
6.1.39price价格number29.99Required价格
6.1.40refundAmount退款金额number50Required退款金额
6.1.41refundQty退款量integer3Required退款量
6.1.42refundRate退款率number0.015Required退款率
6.1.43roasroasnumber6.67RequiredROAS
6.1.44rowKey行唯一键stringkey001Required行唯一键
6.1.45sales14d14天销量integer120Required14天销量
6.1.46sales30d30天销量integer240Required30天销量
6.1.47sales7d7天销量integer65Required7天销量
6.1.48salesAmount销售额number2000Required销售额
6.1.49salesQty销量integer250Required销量
6.1.50salesRevenue销售收益number1500Required销售收益
6.1.51sellerSkusellerSkustringMSKU001RequiredMSKU
6.1.52sellerSkuIdMSKU IDstring12345RequiredMSKU ID
6.1.53settlementCurrencyCode结算毛利润-币种代码stringUSDRequired结算毛利润-币种代码
6.1.54settlementCurrencyIcon结算毛利润-币种图标string$Required结算毛利润-币种图标
6.1.55settlementProfit结算毛利润number480Required结算毛利润
6.1.56settlementProfitMargin结算毛利率number0.28Required结算毛利率
6.1.57sid店铺IDinteger1Required店铺ID
6.1.58siteCode站点原始codestring10008-USRequired站点原始code
6.1.59spuId父体stringSPU001Required父体
6.1.60storeName店铺stringMyStoreRequired店铺
6.1.61subRowCount子行数integer2Required子行数
6.1.62wfsAge0to33个月内库龄integer100Required3个月内库龄
6.1.63wfsAge12plus12个月以上库龄integer10Required12个月以上库龄
6.1.64wfsAge3to63-6个月内库龄integer50Required3-6个月内库龄
6.1.65wfsAge6to96-9个月内库龄integer20Required6-9个月内库龄
6.1.66wfsAge9to129-12个月内库龄integer15Required9-12个月内库龄
6.1.67wfsAvailableWFS可售integer400RequiredWFS可售
6.1.68wfsAvailableDaysWFS可售天数预估number45RequiredWFS可售天数预估
6.1.69wfsInbound标发在途integer80Required标发在途
6.1.70wfsLast30dPoUnits近30天计划入库integer200Required近30天计划入库
6.1.71wfsLast30dReceived近30天入库integer150Required近30天入库
6.1.72wfsLongTermStorageFeeWFS长期仓储费number30RequiredWFS长期仓储费
6.1.73wfsStorageFeeWFS仓储费number50RequiredWFS仓储费
6.1.74wfsTotal总库存integer600Required总库存
6.1.75wfsUnableWarehousing无法入库integer5Required无法入库
6.2total合计行数据object—Required合计行数据
6.2.1acosacosnumber0.12RequiredACOS
6.2.2adClicks点击量integer20000Required点击量
6.2.3adCvr广告CVRnumber0.07Required广告CVR
6.2.4adImpressions曝光量integer500000Required曝光量
6.2.5adOrders广告订单量integer1400Required广告订单量
6.2.6adSales广告销售额number42000Required广告销售额
6.2.7adSpend广告花费number5000Required广告花费
6.2.8adUnits广告销量integer1500Required广告销量
6.2.9avgPrice销售均价number29.99Required销售均价
6.2.10avgSales14d14天日均number300Required14天日均
6.2.11avgSales30d30天日均number280Required30天日均
6.2.12avgSales7d7天日均number320Required7天日均
6.2.13avgVolume销量日均number290Required销量日均
6.2.14buyerFreight客付运费number2000Required客付运费
6.2.15cpccpcnumber0.25RequiredCPC
6.2.16ctrctrnumber0.04RequiredCTR
6.2.17currencyCode币种代码stringUSDRequired币种代码
6.2.18currencyIcon币种图标string$Required币种图标
6.2.19directSales直接销售额number30000Required直接销售额
6.2.20directUnits直接销量integer1000Required直接销量
6.2.21localAvailable本地可用integer8000Required本地可用
6.2.22nonWfsAvailable非WFS可售integer2000Required非WFS可售
6.2.23orderQty订单量integer8000Required订单量
6.2.24overseasAvailable海外可用integer5000Required海外可用
6.2.25refundAmount退款金额number3000Required退款金额
6.2.26refundQty退款量integer150Required退款量
6.2.27refundRate退款率number0.018Required退款率
6.2.28roasroasnumber8.4RequiredROAS
6.2.29sales14d14天销量integer4200Required14天销量
6.2.30sales30d30天销量integer8500Required30天销量
6.2.31sales7d7天销量integer2200Required7天销量
6.2.32salesAmount销售额number85000Required销售额
6.2.33salesQty销量integer9000Required销量
6.2.34salesRevenue销售收益number70000Required销售收益
6.2.35settlementCurrencyCode结算毛利润-币种代码stringUSDRequired结算毛利润-币种代码
6.2.36settlementCurrencyIcon结算毛利润-币种图标string$Required结算毛利润-币种图标
6.2.37settlementProfit结算毛利润number24000Required结算毛利润
6.2.38settlementProfitMargin结算毛利率number0.27Required结算毛利率
6.2.39wfsAge0to33个月内库龄integer5000Required3个月内库龄
6.2.40wfsAge12plus12个月以上库龄integer500Required12个月以上库龄
6.2.41wfsAge3to63-6个月内库龄integer2000Required3-6个月内库龄
6.2.42wfsAge6to96-9个月内库龄integer1000Required6-9个月内库龄
6.2.43wfsAge9to129-12个月内库龄integer800Required9-12个月内库龄
6.2.44wfsAvailableWFS可售integer15000RequiredWFS可售
6.2.45wfsAvailableDaysWFS可售天数预估number42RequiredWFS可售天数预估
6.2.46wfsInbound标发在途integer3000Required标发在途
6.2.47wfsLast30dPoUnits近30天计划入库integer8000Required近30天计划入库
6.2.48wfsLast30dReceived近30天入库integer6000Required近30天入库
6.2.49wfsLongTermStorageFeeWFS长期仓储费number1500RequiredWFS长期仓储费
6.2.50wfsStorageFeeWFS仓储费number2500RequiredWFS仓储费
6.2.51wfsTotal总库存integer20000Required总库存
6.2.52wfsUnableWarehousing无法入库integer200Required无法入库
7total总数integer100Required总数

The 查询Walmart产品表现 API (/basicOpen/platformStatistics/walmartProductAnalysis/list) 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.