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

查询亚马逊源报表 - 所有订单

POST/erp/sc/data/mws_report/allOrders
Factory
{
  "operation": {
    "method": "POST",
    "path": "/erp/sc/data/mws_report/allOrders"
  },
  "protocol": "HTTPS",
  "host": "https://openapi.lingxing.com",
  "rateLimit": {
    "tokenBucketCapacity": 10,
    "text": ""
  },
  "requestExample": {
    "sid": 109,
    "date_type": 1,
    "start_date": "2020-04-01",
    "end_date": "2024-08-05",
    "offset": 0,
    "length": 1000
  },
  "responseExample": {
    "code": 0,
    "message": "success",
    "error_details": [],
    "request_id": "F79152AD-CBC0-846C-DA15-54D7BFC5C835",
    "response_time": "2021-04-19 18:33:51",
    "data": [
      {
        "amazon_order_id": "111-01111-6646648",
        "merchant_order_id": "111-011110-6646648",
        "last_updated_time": 1602964702,
        "purchase_date": "2020-10-17T00:31:51+00:00",
        "purchase_date_locale": "2020-10-16",
        "purchase_date_local": "2020-10-16 17:31:51",
        "shipment_date": "2020-10-17T12:58:15-07:00",
        "order_status": "Shipped",
        "fulfillment_channel": "Amazon",
        "sales_channel": "Amazon.com",
        "order_channel": "",
        "url": "",
        "ship_service_level": "Expedited",
        "sku": "T1-1111-59G8",
        "asin": "B0711113",
        "product_name": "P",
        "item_status": "Shipped",
        "quantity": 1,
        "currency": "USD",
        "item_price": "7.99",
        "item_tax": "0.82",
        "shipping_price": "",
        "shipping_tax": "",
        "gift_wrap_price": "",
        "gift_wrap_tax": "",
        "item_promotion_discount": "",
        "ship_promotion_discount": "",
        "promotion_ids": "",
        "pid": 1,
        "local_sku": "视觉111",
        "local_name": "00.100",
        "sid": 1
      }
    ],
    "total": 2260
  }
}

Request Parameters

No.FieldNameTypeDefaultRequiredDescription
1sid店铺idinteger—Required店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
2date_type时间查询类型integer—Optional时间查询类型:【默认1】 1 下单日期 2 亚马逊订单更新时间
3start_date亚马逊当地下单时间string—Required亚马逊当地下单时间,左闭区间,格式:Y-m-d
4end_date亚马逊当地下单时间string—Required亚马逊当地下单时间,右开区间,格式:Y-m-d
5offset分页偏移量integer—Optional分页偏移量,默认0
6length分页长度integer—Optional分页长度,默认1000

Response Parameters

No.FieldNameTypeDefaultRequiredDescription
1code状态码integer0Required状态码,0 成功
2message消息提示stringsuccessRequired消息提示
3error_details错误信息array<any>—Required错误信息
4request_id请求链路idstring2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4Required请求链路id
5response_time响应时间string2020-05-18 11:23:47Required响应时间
6data响应数据array<object>—Required响应数据
6.1amazon_order_id亚马逊订单号string028-0316583-1645130Required亚马逊订单号
6.2merchant_order_id卖家为订单提供的唯一编号string028-0316583-1645130Required卖家为订单提供的唯一编号
6.3last_updated_time订单最近更新时间string—Required订单最近更新时间
6.4purchase_date下单日期-格式化当地时间(当地时间string2018-11-04T07:58:08+00:00Required下单日期-格式化当地时间(当地时间, 时区)
6.5purchase_date_locale下单日期-对应亚马逊当地日期(不建议使用)string2018-11-04Required下单日期-对应亚马逊当地日期(不建议使用)
6.6purchase_date_local下单日期-店铺当地时间string2018-11-04 08:58:08Required下单日期-店铺当地时间
6.7shipment_date发货时间-UTC时间string2018-11-04 08:58:08Required发货时间-UTC时间
6.8order_status订单的当前状态stringShippedRequired订单的当前状态
6.9fulfillment_channel订单的配送方式stringAmazonRequired订单的配送方式: Amazon 亚马逊配送 (AFN) Merchant 卖家自行配送 (MFN)
6.10sales_channel下单渠道stringAmazon.deRequired下单渠道
6.11order_channelCBA/WBA 订单下单的子渠道string—RequiredCBA/WBA 订单下单的子渠道
6.12url链接string—Required链接
6.13ship_service_level配送服务类型stringStandardRequired配送服务类型
6.14skuskustringDA189076B1RequiredMSKU
6.15asinasinstringB078W791QLDRequiredASIN
6.16product_name品名stringDrehteller Cake Decorating TurntableRequired品名
6.17item_status该商品在订单内的当前状态stringShippedRequired该商品在订单内的当前状态
6.18quantity此商品的购买数量number1Required此商品的购买数量
6.19currency币种stringEURRequired币种
6.20item_price买家为商品支付的金额string13.99Required买家为商品支付的金额
6.21item_tax买家为商品税支付的金额string—Required买家为商品税支付的金额
6.22shipping_price买家支付的运费金额string1.0Required买家支付的运费金额
6.23shipping_tax买家为运费税支付的金额string—Required买家为运费税支付的金额
6.24gift_wrap_price买家为礼品包装支付的金额string—Required买家为礼品包装支付的金额
6.25gift_wrap_tax买家为礼品包装税支付的金额string—Required买家为礼品包装税支付的金额
6.26item_promotion_discount应用于订单商品的所有促销折扣的总和string—Required应用于订单商品的所有促销折扣的总和
6.27ship_promotion_discount应用于配送的促销折扣string1.0Required应用于配送的促销折扣
6.28promotion_ids应用于此订单商品的所有商品促销的列表stringDE Core Free Shipping 2018/04/24 20-00-00Required应用于此订单商品的所有商品促销的列表
6.29pid本地产品idinteger212Required本地产品id
6.30local_sku本地产品SKUstringSun002-FBA63Required本地产品SKU
6.31local_name本地产品品名string—Required本地产品品名
6.32sid店铺idinteger3Required店铺id
7total总数integer1Required总数

The 查询亚马逊源报表 - 所有订单 API (/erp/sc/data/mws_report/allOrders) 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.