/erp/sc/routing/data/order/fbmReturnOrderList{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/data/order/fbmReturnOrderList"
},
"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": "2E9941CD-3A26-3550-52A3-F83F4D1977F1",
"response_time": "2023-06-30 17:28:41",
"data": [
{
"id": 2,
"order_hash": "b7ec98d3d3d11092b8838ef29508aa20",
"sid": 101,
"order_id": "112-6283972-5349000",
"order_date": "2023-05-22",
"return_date": "2023-05-24",
"return_status": "Approved",
"rma_id": "DjMbMZrvRRMA",
"rma_id_provider": "Amazon",
"label_type": "AmazonPrePaidLabel",
"label_cost": "4.13",
"currency_code": "USD",
"return_carrier": "USPS",
"tracking_id": "9202090339598309314960",
"label_payer": "Customer",
"a_to_z_claim": "N",
"is_prime": "N",
"asin": "B0B4WP8XXX",
"seller_sku": "Hair-Ties-P0360",
"item_name": "YiWu HENGFU.hi Heart Pearl Black Hair Ties - High Stretch Elastic Bands for Women and Girls, Double as Jewelry and Head Rope",
"return_quantity": 1,
"return_reason": "CR-UNWANTED_ITEM(客户退货-不想要的商品)",
"in_policy": "Y",
"return_type": "C-Returns",
"resolution": "StandardRefund",
"invoice_number": "",
"return_delivery_date": "",
"order_amount": "5.83",
"order_quantity": 1,
"safet_action_reason": "",
"safet_claim_id": "",
"safet_claim_state": "",
"safet_claim_creation_time": "",
"safet_claim_reimbursement_amount": "",
"refunded_amount": "5.83",
"sync_time": 1685260468,
"remark": "自动化备注",
"tag_type_ids": [
{
"id": 60,
"tag_name": "尺码问题",
"tag_type": 2,
"tag_color": "E76A5D",
"tag_type_id": "2-60"
}
],
"local_sku": "ZDH1688113470.6414766",
"local_name": "自动化单品",
"brand_title": "",
"category_title_path": "",
"country": "美国",
"seller_name": "8p1-US",
"asin_url": "https://www.amazon.com/dp/B0B4WP8XXX",
"pic_url": "https://xxxx/a8dbce2f2.jpg"
}
],
"total": 1
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | integer | — | Required | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | start_date | 开始时间 | string | — | Required | 开始时间,左闭区间,格式:Y-m-d |
| 3 | end_date | 结束时间 | string | — | Required | 结束时间,右开区间,格式:Y-m-d |
| 4 | date_type | 时间查询类型 | integer | — | Optional | 时间查询类型:【默认1】 1 退货日期 2 下单日期 |
| 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 | 2E9941CD-3A26-3550-52A3-F83F4D1977F1 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2023-06-30 17:28:41 | Required | 响应时间 |
| 6 | total | 总数 | integer | 1 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | id | 订单id | integer | 2 | Required | 订单id |
| 7.2 | order_hash | 订单唯一hash | string | b7ec98d3d3d11092b8838ef29508aa20 | Required | 订单唯一hash |
| 7.3 | sid | 店铺id | integer | 101 | Required | 店铺id |
| 7.4 | order_id | 亚马逊订单id | string | 112-6283972-5349000 | Required | 亚马逊订单id |
| 7.5 | order_date | 订购时间 | string | 2023-05-22 | Required | 订购时间 |
| 7.6 | return_date | 退货时间 | string | 2023-05-24 | Required | 退货时间 |
| 7.7 | return_status | 退货状态 | string | Approved | Required | 退货状态 |
| 7.8 | rma_id | RMA单号 | string | DjMbMZrvRRMA | Required | RMA单号 |
| 7.9 | label_type | 标签类型 | string | AmazonPrePaidLabel | Required | 标签类型 |
| 7.10 | label_cost | 标签费用 | string | 4.13 | Required | 标签费用 |
| 7.11 | currency_code | 币种 | string | USD | Required | 币种 |
| 7.12 | return_carrier | 承运商 | string | USPS | Required | 承运商 |
| 7.13 | tracking_id | 运单号 | string | 9202090339598309314960 | Required | 运单号 |
| 7.14 | label_payer | 标签支付方 | string | Customer | Required | 标签支付方 |
| 7.15 | a_to_z_claim | "A-to-Z"标签 | string | N | Required | "A-to-Z"标签, N代表否,Y代表是 |
| 7.16 | is_prime | "Prime"标签 | string | N | Required | "Prime"标签, N代表否,Y代表是 |
| 7.17 | asin | asin | string | B0B4WP82TG | Required | asin |
| 7.18 | seller_sku | seller_sku【MSKU】 | string | Hair-Ties-P0360 | Required | seller_sku【MSKU】 |
| 7.19 | item_name | 标题 | string | YiWu HENGFU.hi Heart Pearl Black Hair Ties | Required | 标题 |
| 7.20 | return_quantity | 退货数量 | number | 1 | Required | 退货数量 |
| 7.21 | return_reason | 退货原因 | string | CR-UNWANTED_ITEM(客户退货-不想要的商品) | Required | 退货原因 |
| 7.22 | in_policy | 是否符合政策 | string | Y | Required | 是否符合政策:N代表否,Y代表是 |
| 7.23 | return_type | 退货类型 | string | C-Returns | Required | 退货类型 |
| 7.24 | resolution | 解决方法 | string | StandardRefund | Required | 解决方法 |
| 7.25 | invoice_number | 发票号码 | string | — | Required | 发票号码 |
| 7.26 | return_delivery_date | 退货送达日期 | string | — | Required | 退货送达日期 |
| 7.27 | order_amount | 订单金额 | string | 5.83 | Required | 订单金额 |
| 7.28 | order_quantity | 商品信息--原始数量 | integer | 1 | Required | 商品信息--原始数量 |
| 7.29 | safet_action_reason | Safe-T索赔原因 | string | — | Required | Safe-T索赔原因 |
| 7.30 | safet_claim_id | Saft-T索赔单号 | string | — | Required | Saft-T索赔单号 |
| 7.31 | safet_claim_state | Saft-T索赔状态 | string | — | Required | Saft-T索赔状态 |
| 7.32 | safet_claim_creation_time | Saft-T索赔时间 | string | — | Required | Saft-T索赔时间 |
| 7.33 | safet_claim_reimbursement_amount | Safe-T索赔金额 | string | — | Required | Safe-T索赔金额 |
| 7.34 | refunded_amount | 退款金额 | string | 5.83 | Required | 退款金额 |
| 7.35 | sync_time | 同步数据时间戳 | integer | 1685260468 | Required | 同步数据时间戳 |
| 7.36 | rma_id_provider | rma_id_provider | string | Amazon | Required | RMA单号提供者(amazon或者Merchant) |
| 7.37 | remark | 备注 | string | 自动化备注 | Required | 备注 |
| 7.38 | tag_type_ids | 标签信息 | array<object> | — | Required | 标签信息 |
| 7.38.1 | tag_name | 标签名称 | string | 尺码问题 | Required | 标签名称 |
| 7.38.2 | tag_color | 标签颜色 | string | E76A5D | Required | 标签颜色 |
| 7.39 | local_sku | 本地产品sku | string | ZDH1688113470.6414766 | Required | 本地产品sku |
| 7.40 | local_name | 品名 | string | 自动化单品 | Required | 品名 |
| 7.41 | brand_title | 品牌名 | string | xx | Required | 品牌名 |
| 7.42 | category_title_path | 分类 | string | xxx | Required | 分类 |
| 7.43 | country | 国家 | string | 美国 | Required | 国家 |
| 7.44 | seller_name | 店铺名 | string | 8p1-US | Required | 店铺名 |
| 7.45 | asin_url | asin地址 | string | https://www.amazon.com/dp/B0B4WP8XXX | Required | asin地址 |
| 7.46 | pic_url | 产品图片 | string | https://xxxx/a8dbce2f2.jpg | Required | 产品图片 |
The 查询亚马逊源报表 - FBM退货订单 API (/erp/sc/routing/data/order/fbmReturnOrderList) 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.