/erp/sc/data/mws_report/fbaOrders{
"operation": {
"method": "POST",
"path": "/erp/sc/data/mws_report/fbaOrders"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"sid": 109,
"date_type": 1,
"start_date": "2020-04-01",
"end_date": "2024-08-05",
"offset": 0,
"length": 1000
},
"responseExample": {
"code": 0,
"data": [
{
"sku": "Pink_Head_Rope",
"currency": "USD",
"carrier": "USPS",
"amazon_order_id": "112-0065094-0449862",
"shipment_id": "TBb1Gwxz1",
"shipment_item_id": "DFJVVkwbH",
"amazon_order_item_id": "67486918672938",
"purchase_date": "2022-05-09T21:59:41+00:00",
"payments_date": "2022-05-10T06:05:32+00:00",
"shipment_date": "2022-05-10T06:05:32+00:00",
"reporting_date": "2022-05-10T09:05:39+00:00",
"estimated_arrival_date": "2022-05-12T03:00:00+00:00",
"product_name": "Love Pearl Bottom Hair Circle Women's High Elastic Hair Binding Rope Jewelry Rubber Band Head Rope Pink",
"quantity_shipped": 1,
"item_price": "1.00",
"item_tax": "0.00",
"shipping_price": "0.00",
"shipping_tax": "0.00",
"gift_wrap_price": "0.00",
"gift_wrap_tax": "0.00",
"ship_service_level": "Expedited",
"item_promotion_discount": "0.00",
"ship_promotion_discount": "0.00",
"tracking_number": "9374889705011506008135",
"fulfillment_channel": "AFN",
"points_granted": "",
"hide_time": "2022-05-09 23:05:32",
"buyer_email": "fbzdtkn3vgzftkk@marketplace.amazon.com",
"buyer_name": "",
"buyer_phone_number": "",
"recipient_name": "",
"ship_address_1": "",
"ship_city": "BARNHART",
"ship_state": "MO",
"ship_postal_code": "63012",
"ship_country": "US",
"ship_phone_number": ""
}
],
"total": 9,
"message": "操作成功",
"request_id": "acb13574cdd14cd287043fadb895894e.1722930272131",
"response_time": "2024-08-06 15:44:32",
"error_details": []
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | integer | — | Required | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | date_type | 日期搜索维度 | integer | — | Optional | 日期搜索维度:【默认1】 1 下单日期 2 配送日期 |
| 3 | start_date | 开始日期 | string | — | Required | 开始日期,左闭区间,Y-m-d格式 |
| 4 | end_date | 结束日期 | string | — | Required | 结束日期,右开区间,Y-m-d格式 |
| 5 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 6 | length | 分页长度 | integer | — | Optional | 分页长度,默认1000 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码, 0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 69F77F67-F288-B0C8-F453-C653E4D0FA93 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2021-05-14 18:08:36 | Required | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 6.1 | amazon_order_id | 订单号 | string | 112-4166816-7798631 | Required | 订单号 |
| 6.2 | shipment_id | 配送ID | string | DHySD0zRY | Required | 配送ID |
| 6.3 | shipment_item_id | 配送子ID | string | D6ddjDd1R | Required | 配送子ID |
| 6.4 | amazon_order_item_id | 订单子项ID | string | 37909714721266 | Required | 订单子项ID |
| 6.5 | purchase_date | 下单日期 | string | 2018-11-04T23:57:08+00:00 | Required | 下单日期 |
| 6.6 | payments_date | 支付日期 | string | 2018-11-05T08:06:34+00:00 | Required | 支付日期 |
| 6.7 | shipment_date | 配送日期(零时区) | string | 2018-11-05T08:06:37+00:00 | Required | 配送日期(零时区) |
| 6.8 | reporting_date | 报表日期 | string | 2018-11-05T09:06:42+00:00 | Required | 报表日期 |
| 6.9 | estimated_arrival_date | 预计送达日期 | string | 2018-11-07T04:00:00+00:00 | Required | 预计送达日期 |
| 6.10 | sku | sku | string | NP-10US-24Y8 | Required | SKU |
| 6.11 | product_name | 品名 | string | Bicycle Saddle Dual Suspension Shock Absorbing | Required | 品名 |
| 6.12 | quantity_shipped | 数量 | number | 1 | Required | 数量 |
| 6.13 | currency | 币种 | string | USD | Required | 币种 |
| 6.14 | item_price | 商品金额 | string | 17.92 | Required | 商品金额 |
| 6.15 | item_tax | 商品税 | string | 0.00 | Required | 商品税 |
| 6.16 | shipping_price | 运费金额 | string | 0.00 | Required | 运费金额 |
| 6.17 | shipping_tax | 运费税 | string | 0.00 | Required | 运费税 |
| 6.18 | gift_wrap_price | 礼品包装费 | string | 0.00 | Required | 礼品包装费 |
| 6.19 | gift_wrap_tax | 礼品包装税 | string | 0.00 | Required | 礼品包装税 |
| 6.20 | ship_service_level | 配送级别 | string | Expedited | Required | 配送级别 |
| 6.21 | item_promotion_discount | 订单商品促销折扣 | string | 0.00 | Required | 订单商品促销折扣 |
| 6.22 | ship_promotion_discount | 配送的促销折扣 | string | 0.00 | Required | 配送的促销折扣 |
| 6.23 | carrier | 运输方 | string | USPS | Required | 运输方 |
| 6.24 | tracking_number | 快递号 | string | 9361289677090259988439 | Required | 快递号 |
| 6.25 | fulfillment_channel | 配送方式 | string | AFN | Required | 配送方式: 亚马逊配送 (AFN) 卖家自行配送 (MFN) |
| 6.26 | points_granted | 亚马逊授予买家的积分 | string | | Required | 亚马逊授予买家的积分 |
The 查询亚马逊源报表 - FBA订单 API (/erp/sc/data/mws_report/fbaOrders) 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.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.