/erp/sc/data/mws_report/refundOrders{
"operation": {
"method": "POST",
"path": "/erp/sc/data/mws_report/refundOrders"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"sid": 109,
"date_type": 1,
"start_date": "2020-01-01",
"end_date": "2024-08-05",
"offset": 0,
"length": 1000
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "3387708D-4BB5-BB28-F8CE-18EE2A3D591F",
"response_time": "2023-06-30 17:30:02",
"data": [
{
"sid": 101,
"order_id": "133666",
"product_name": "SUPER J Cell Phone Armband Running Armband for Iphone Samsung Sports Phone Holder Waterproof",
"sku": "JJ001",
"asin": "B0BB9XV7CW",
"fnsku": "B0BB9XV7CW",
"quantity": 1,
"return_date": "2023-06-04T19:57:09+01:00",
"return_date_locale": "2023-06-04",
"purchase_date": "2023-08-13T07:20:35Z",
"purchase_date_locale": "2023-08-13",
"fulfillment_center_id": "AUS3",
"detailed_disposition": "SELLABLE",
"reason": "UNDELIVERABLE_UNKNOWN",
"status": "Unit returned to inventory",
"license_plate_number": "LPNT010424593",
"customer_comments": "",
"gmt_modified": "2023-06-08 09:48:10",
"local_sku": "10369333",
"remark": "备注",
"tag": [
{
"tag_name": "尺码问题",
"tag_color": "E76A5D"
}
]
}
],
"total": 1
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | integer | — | Required | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | date_type | 时间查询类型【默认1】 | 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 | 2C1A1C68-395F-C1A0-5639-9AF0A5BE08A4 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | Required | 响应时间 |
| 6 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 6.1 | sid | 店铺id | integer | 3 | Required | 店铺id |
| 6.2 | order_id | 订单号 | string | 028-0034384-7536302 | Required | 订单号 |
| 6.3 | local_sku | 本地产品sku | string | 456487456 | Required | 本地产品sku |
| 6.4 | product_name | 品名 | string | 6 Zoll Mikrofon Popschutz Studio Mikrofon | Required | 品名 |
| 6.5 | sku | sku | string | DA190379B1 | Required | MSKU |
| 6.6 | asin | asin | string | B06XPGK9SHL | Required | ASIN |
| 6.7 | fnsku | fnsku | string | X000NYD9RDX | Required | FNSKU |
| 6.8 | quantity | 数量 | integer | 1 | Required | 数量 |
| 6.9 | return_date | 退货时间【UTC时间】 | string | 2019-01-17T02:28:18+00:00 | Required | 退货时间【UTC时间】 |
| 6.10 | return_date_locale | 退货时间【站点时间】 | string | 2020-06-04 | Required | 退货时间【站点时间】 |
| 6.11 | purchase_date | 订购时间【UTC时间】 | string | 2019-01-17T02:28:18+00:00 | Required | 订购时间【UTC时间】 |
| 6.12 | purchase_date_locale | 订购时间【站点时间】 | string | 2020-06-04 | Required | 订购时间【站点时间】 |
| 6.13 | gmt_modified | 更新时间 | string | 2023-06-08 09:48:10 | Required | 更新时间 |
| 6.14 | fulfillment_center_id | 存储库存的运营中心 | string | BTS2 | Required | 存储库存的运营中心 |
| 6.15 | detailed_disposition | 商品状态属性 | string | SELLABLE | Required | 商品状态属性 |
| 6.16 | reason | 退回原因 | string | NO_REASON_GIVEN | Required | 退回原因 |
| 6.17 | status | 状态 | string | Unit returned to inventory | Required | 状态 |
| 6.18 | license_plate_number | 唯一序列号 | string | LPNHE298128253 | Required | 唯一序列号 |
| 6.19 | customer_comments | 买家评论 | string | | Required | 买家评论 |
| 6.20 | remark | 备注 | string | 备注 | Required | 备注 |
| 6.21 | tag | 标签信息 | array<object> | — | Required | 标签信息 |
| 6.21.1 | tag_name | 标签名称 | string | 尺码问题 | Required | 标签名称 |
| 6.21.2 | tag_color | 标签颜色 | string | E76A5D | Required | 标签颜色 |
The 查询亚马逊源报表 - FBA退货订单 API (/erp/sc/data/mws_report/refundOrders) 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.