/erp/sc/data/mws_report/transaction{
"operation": {
"method": "POST",
"path": "/erp/sc/data/mws_report/transaction"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": {
"sid": 109,
"event_date": "2020-06-07",
"offset": 0,
"length": 1000
},
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "38AA9D9A-5936-FD62-9901-C415C1951111",
"response_time": "2021-07-02 11:23:08",
"data": [
{
"sid": 103,
"is_to_b": 0,
"report_date_month": "2021-05",
"report_index": 736,
"date_str": "May 31, 2021 11:56:23 AM PDT",
"date_locale": "2021-05-31",
"date_iso": "2021-05-31T11:56:23-07:00",
"settlement_id": "142111161",
"type": 1,
"order_id": "113-1111111111111111-9121025",
"sku": "200J",
"description_str": "KOo",
"quantity": 1,
"marketplace": "amazon.com",
"fulfillment": "Amazon",
"order_city": "REDWOOD CITY",
"order_state": "CA",
"order_postal": "9401142",
"product_sales": "19.9900",
"currency": "USD",
"shipping_credits": "0.0000",
"shipping_credits_tax": "0.0000",
"gift_wrap_credits": "0.0000",
"gift_wrap_credits_tax": "0.0000",
"promotional_rebates": "-10.0000",
"promotional_rebates_tax": "0.0000",
"sales_tax_collected": "0.0000",
"marketplace_facilitator_tax": "-0.9700",
"selling_fees": "-1.5000",
"fba_fees": "-5.4200",
"other_transaction_fees": "-0.7000",
"other": "0.0000",
"total": "2.3700",
"description": "KORsy to",
"type_str": "Order"
},
{
"sid": 103,
"is_to_b": 0,
"report_date_month": "2021-05",
"report_index": 741,
"date_str": "May 31, 2021 2:00:44 PM PDT",
"date_locale": "2021-05-31",
"date_iso": "2021-05-31T14:00:44-07:00",
"settlement_id": "1426581161",
"type": 1,
"order_id": "113-111111111111-5120241",
"sku": "200J",
"description_str": "KO",
"quantity": 1,
"marketplace": "amazon.com",
"fulfillment": "Amazon",
"order_city": "HOUSTON",
"order_state": "TX",
"order_postal": "77044-6581",
"product_sales": "19.9900",
"currency": "USD",
"shipping_credits": "0.0000",
"shipping_credits_tax": "0.0000",
"gift_wrap_credits": "0.0000",
"gift_wrap_credits_tax": "0.0000",
"promotional_rebates": "0.0000",
"promotional_rebates_tax": "0.0000",
"sales_tax_collected": "0.0000",
"marketplace_facilitator_tax": "-1.4500",
"selling_fees": "-3.0000",
"fba_fees": "-5.4200",
"other_transaction_fees": "-1.4000",
"other": "0.0000",
"total": "10.1700",
"description": "11111sy to",
"type_str": "Order"
}
],
"total": 0
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | sid | 店铺id | integer | — | Required | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 2 | event_date | 报表日期 | string | — | Required | 报表日期,格式:Y-m-d【每月3日后支持查询上月数据】 |
| 3 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 4 | 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 | 1 | Required | 店铺id |
| 6.2 | is_to_b | 是否为B2B订单 | integer | 0 | Required | 是否为B2B订单:0 否【2c】,1 是 |
| 6.3 | report_date_month | client_task的月份 | string | 2019-03 | Required | client_task的月份 |
| 6.4 | report_index | 报表行索引 | integer | — | Required | 报表行索引 |
| 6.5 | date_str | 原本的日期字符串 | string | 1 Mar 2019 00:00:45 GMT+00:00 | Required | 原本的日期字符串 |
| 6.6 | date_locale | 当地日期 | string | 2019-03-01 | Required | 当地日期 |
| 6.7 | date_iso | ISO时间 | string | 2019-03-01T00:00:45+00:00 | Required | ISO时间 |
| 6.8 | settlement_id | 结算编号 | string | 11376876372 | Required | 结算编号 |
| 6.9 | type | 类型 | integer | 1 | Required | 类型: 1 ORDER 2 REFUND 3 ADJUSTMENT 4 A_TO_Z_GUARANTEE_CLAIM 5 CHARGEBACK_REFUND 6 FBA_INVENTORY_FEE 7 SERVICE_FEE 8 LIGHTNING_DEAL_FEE 9 TRANSFER 10 ORDER_RETROCHARGE 11 REFUND_RETROCHARGE 12 CHARGES_TO_CREDIT_CARD 13 FBA_CUSTOMER_RETURN_FEE 14 DEBT 15 NULL【其他类型】 16 FEE_ADJUSTMENT 17 LIQUIDATIONS 18 Shipping Services 19 Electronic Transactions 20 COD Transactions 21 Reimbursements 22 Tax Withheld 23 Liquidations Adjustments 24 PW Order Payment 25 PW Trial Shipment 26 Fulfilment Fee Refund 27 TBYB Order Payment 28 TBYB Trial Shipment |
| 6.10 | type_str | 类型说明 | string | — | Required | 类型说明 |
| 6.11 | order_id | 订单号 | string | 205-0598548-1768342 | Required | 订单号 |
| 6.12 | sku | sku | string | 4H-3NL6-GL1I | Required | SKU |
| 6.13 | description | 商品描述 | string | — | Required | 商品描述 |
| 6.14 | quantity | 商品数量 | number | 1 | Required | 商品数量 |
| 6.15 | marketplace | 销售市场 | string | amazon.co.uk | Required | 销售市场 |
| 6.16 | fulfillment | 发货方式 | string | Amazon | Required | 发货方式 |
| 6.17 | order_city | 城市 | string | MIDDLESBROUGH | Required | 城市 |
| 6.18 | order_state | 州 | string | Cleveland | Required | 州 |
| 6.19 | order_postal | 邮编 | string | TS6 9JN | Required | 邮编 |
| 6.20 | product_sales | 销售价格 | string | 12.4900 | Required | 销售价格 |
| 6.21 | product_sales_tax | 销售税 | string | — | Required | 销售税 |
| 6.22 | currency | 币种 | string | USD | Required | 币种 |
| 6.23 | shipping_credits | 运费 | string | 1.8700 | Required | 运费 |
| 6.24 | shipping_credits_tax | 运费税(荷兰 | string | — | Optional | 运费税(荷兰,瑞典,沙特,阿联酋无该税费) |
| 6.25 | gift_wrap_credits | 礼品包装费 | string | 0.0000 | Required | 礼品包装费 |
| 6.26 | gift_wrap_credits_tax | 礼品包装税(荷兰 | string | — | Optional | 礼品包装税(荷兰,瑞典,沙特,阿联酋无该税费) |
| 6.27 | promotional_rebates | 促销返点 | string | -1.8700 | Required | 促销返点 |
| 6.28 | promotional_rebates_tax | 促销返点税(荷兰 | string | — | Optional | 促销返点税(荷兰,瑞典,沙特,阿联酋无该税费) |
| 6.29 | sales_tax_collected | 销售税(仅荷兰 | string | 0.0000 | Optional | 销售税(仅荷兰,瑞典,沙特,阿联酋有该税费) |
| 6.30 | marketplace_facilitator_tax | 市场税 | string | 0.0000 | Required | 市场税 |
| 6.31 | selling_fees | 平台费(佣金) | string | -2.2500 | Required | 平台费(佣金) |
| 6.32 | fba_fees | FBA发货费 | string | -2.1700 | Required | FBA发货费 |
| 6.33 | other_transaction_fees | 其他交易费 | string | 0.0000 | Required | 其他交易费 |
| 6.34 | other | 其他费 | string | 0.0000 | Required | 其他费 |
| 6.35 | total | 总计 | string | 10.5700 | Required | 总计 |
The 查询亚马逊源报表 - 交易明细 API (/erp/sc/data/mws_report/transaction) 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.