/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": []
}
}| 序号 | 字段 | 名称 | 类型 | 默认值 | 必填 | 描述 |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | integer | — | 必填 | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | date_type | 日期搜索维度 | integer | — | 可选 | 日期搜索维度:【默认1】 1 下单日期 2 配送日期 |
| 3 | start_date | 开始日期 | string | — | 必填 | 开始日期,左闭区间,Y-m-d格式 |
| 4 | end_date | 结束日期 | string | — | 必填 | 结束日期,右开区间,Y-m-d格式 |
| 5 | offset | 分页偏移量 | integer | — | 可选 | 分页偏移量,默认0 |
| 6 | length | 分页长度 | integer | — | 可选 | 分页长度,默认1000 |
| 序号 | 字段 | 名称 | 类型 | 默认值 | 必填 | 描述 |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | 必填 | 状态码, 0 成功 |
| 2 | message | 消息提示 | string | success | 必填 | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | 必填 | 错误信息 |
| 4 | request_id | 请求链路id | string | 69F77F67-F288-B0C8-F453-C653E4D0FA93 | 必填 | 请求链路id |
| 5 | response_time | 响应时间 | string | 2021-05-14 18:08:36 | 必填 | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | 必填 | 响应数据 |
| 6.1 | amazon_order_id | 订单号 | string | 112-4166816-7798631 | 必填 | 订单号 |
| 6.2 | shipment_id | 配送ID | string | DHySD0zRY | 必填 | 配送ID |
| 6.3 | shipment_item_id | 配送子ID | string | D6ddjDd1R | 必填 | 配送子ID |
| 6.4 | amazon_order_item_id | 订单子项ID | string | 37909714721266 | 必填 | 订单子项ID |
| 6.5 | purchase_date | 下单日期 | string | 2018-11-04T23:57:08+00:00 | 必填 | 下单日期 |
| 6.6 | payments_date | 支付日期 | string | 2018-11-05T08:06:34+00:00 | 必填 | 支付日期 |
| 6.7 | shipment_date | 配送日期(零时区) | string | 2018-11-05T08:06:37+00:00 | 必填 | 配送日期(零时区) |
| 6.8 | reporting_date | 报表日期 | string | 2018-11-05T09:06:42+00:00 | 必填 | 报表日期 |
| 6.9 | estimated_arrival_date | 预计送达日期 | string | 2018-11-07T04:00:00+00:00 | 必填 | 预计送达日期 |
| 6.10 | sku | sku | string | NP-10US-24Y8 | 必填 | SKU |
| 6.11 | product_name | 品名 | string | Bicycle Saddle Dual Suspension Shock Absorbing | 必填 | 品名 |
| 6.12 | quantity_shipped | 数量 | number | 1 | 必填 | 数量 |
| 6.13 | currency | 币种 | string | USD | 必填 | 币种 |
| 6.14 | item_price | 商品金额 | string | 17.92 | 必填 | 商品金额 |
| 6.15 | item_tax | 商品税 | string | 0.00 | 必填 | 商品税 |
| 6.16 | shipping_price | 运费金额 | string | 0.00 | 必填 | 运费金额 |
| 6.17 | shipping_tax | 运费税 | string | 0.00 | 必填 | 运费税 |
| 6.18 | gift_wrap_price | 礼品包装费 | string | 0.00 | 必填 | 礼品包装费 |
| 6.19 | gift_wrap_tax | 礼品包装税 | string | 0.00 | 必填 | 礼品包装税 |
| 6.20 | ship_service_level | 配送级别 | string | Expedited | 必填 | 配送级别 |
| 6.21 | item_promotion_discount | 订单商品促销折扣 | string | 0.00 | 必填 | 订单商品促销折扣 |
| 6.22 | ship_promotion_discount | 配送的促销折扣 | string | 0.00 | 必填 | 配送的促销折扣 |
| 6.23 | carrier | 运输方 | string | USPS | 必填 | 运输方 |
| 6.24 | tracking_number | 快递号 | string | 9361289677090259988439 | 必填 | 快递号 |
| 6.25 | fulfillment_channel | 配送方式 | string | AFN | 必填 | 配送方式: 亚马逊配送 (AFN) 卖家自行配送 (MFN) |
| 6.26 | points_granted | 亚马逊授予买家的积分 | string | | 必填 | 亚马逊授予买家的积分 |
领星ERP的接口:查询亚马逊源报表 - FBA订单(/erp/sc/data/mws_report/fbaOrders),由轻易云数据集成平台 API 资产管理模块整理收纳,并随领星ERP版本更新同步更新。