/bd/profit/report/open/report/order/list{
"operation": {
"method": "POST",
"path": "/bd/profit/report/open/report/order/list"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 10,
"text": ""
},
"requestExample": {
"offset": 0,
"length": 20,
"sids": [
136
],
"search_date_field": "fund_transfer_datetime_locale",
"start_date": "2023-01-21",
"end_date": "2024-07-20",
"search_field": "order_id",
"search_value": [
""
],
"currency_code": "CNY",
"account_type": "Standard",
"settlement_status": [
"Closed"
],
"fund_transfer_status": [
"Succeeded",
"Unknown"
],
"event_source": [
"ServiceFee",
"DebtRecovery"
],
"description": [
"Subscription",
"RecoveryAmount"
]
},
"responseExample": {
"code": 0,
"message": "操作成功",
"error_details": [],
"request_id": "14316922-d968-49dc-af7f-ac3aa4e29d09.1682560729730",
"response_time": "2023-04-27 09:58:50",
"total": 11345,
"data": [
{
"id": "4289099",
"sid": "8",
"country": "英国",
"fid": "",
"description": "PaidServicesFee",
"msku": "",
"asin": "",
"fulfillment": "",
"principal": 0,
"commission": 0,
"tax": 0,
"other": 0,
"store_name": "JHM Official-01",
"country_code": "UK",
"posted_datetime_locale": "2023-03-02 05:05:29",
"currency_code": "CNY",
"currency_icon": "¥",
"order_id": "AMPSBilling_48155952912_1_2023_01_01",
"event_source": "ServiceFee",
"account_type": "Standard",
"parent_asin": "",
"local_name": "",
"local_sku": "",
"settlement_status": "",
"fund_transfer_status": "",
"fund_transfer_datetime_locale": "",
"shipment_datetime_locale": "",
"small_image_url": "",
"cost_quantity": 0,
"product_sales_quantity": 0,
"shipping_charge": 0,
"promotional_rebates": 0,
"shipping_chargeback": 0,
"gift_wrap": 0,
"giftwrap_chargeback": 0,
"fba_per_unit_fulfillment_fee": 0,
"refund_commission": 0,
"shipping_tax": 0,
"sales_tax_withheld": 0,
"marketplace_facilitator_vat_principal": 0,
"marketplace_facilitator_vat_shipping": 0,
"giftWrap_tax": 0,
"promotion_discount_tax": 0,
"shipping_discount_tax": 0,
"restocking_fee": 0,
"other_transaction_fees_total": -17483.7,
"other_transaction_fees_detail": "{\"PaidServicesFee\":-17483.70}",
"settlement_total": -17483.7,
"purchase_costs_total": 0,
"logistics_costs_total": 0,
"other_costs_total": 0,
"gross_profit": -17483.7
}
]
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Optional | 分页长度,上限10000 |
| 3 | mids | 站点id | array<any> | — | Optional | 站点id |
| 4 | sids | 店铺id | array<any> | — | Optional | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 5 | search_date_field | 时间类型 | string | — | Required | 时间类型: posted_date_locale 结算时间 fund_transfer_datetime_locale 转账时间 shipment_datetime_locale 发货时间 |
| 6 | start_date | 开始时间 | string | — | Required | 开始时间 |
| 7 | end_date | 结束时间 | string | — | Required | 结束时间 |
| 8 | search_field | 搜索值类型 | string | — | Optional | 搜索值类型: 亚马逊订单号:order_id MSKU:seller_sku Asin:asin 父asin:parent_asin SKU:local_sku 品名:local_name |
| 9 | search_value | 搜索的值 | array<any> | — | Optional | 搜索的值 |
| 10 | currency_code | 币种code | string | — | Optional | 币种code |
| 11 | account_type | 报告类型 | string | — | Optional | 报告类型: Standard Invoiced Electronic COD PayWithAmazon |
| 12 | settlement_status | 结算状态 | array<any> | — | Optional | 结算状态: 待结算:["Open", "Pending"] 已结算:["Closed"] |
| 13 | fund_transfer_status | 转账状态 | array<any> | — | Optional | 转账状态: 已转帐 Succeeded 转帐中 Processing 失败 Failed 未知 Unknown |
| 14 | event_source | 来源 | array<any> | — | Optional | 来源: SellerDealPayment ServiceFee Adjustment Refund SellerReviewEnrollmentPayment RemovalShipmentAdjustment ProductAdsPayment Shipment DebtRecovery Liquidations Adjustments Retrocharge RemovalShipment |
| 15 | description | 描述 | array<any> | — | Optional | 描述 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码,0 成功 |
| 2 | message | 消息提示 | string | 操作成功 | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 14316922-d968-49dc-af7f-ac3aa4e29d09.1682560729730 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2023-04-27 09:58:50 | Required | 响应时间 |
| 6 | total | 总数 | integer | 11345 | Required | 总数 |
| 7 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 7.1 | id | 记录id【非唯一值】 | string | 97860842859265346195179669414178955639632303349797920144362032035134467346451 | Required | 记录id【非唯一值】,唯一键参考 |
| 7.2 | sid | 店铺id | integer | 8 | Required | 店铺id |
| 7.3 | store_name | 店铺名 | string | JHL Official-01 | Required | 店铺名 |
| 7.4 | country_code | 国家编码 | string | UK | Required | 国家编码 |
| 7.5 | country | 国家 | string | 英国 | Required | 国家 |
| 7.6 | fid | 结算编号 | string | ABC | Required | 结算编号 |
| 7.7 | description | 描述 | string | PaidServicesFee,PointsAdjusted | Required | 描述,返回该行对应描述的拼接字符串 【枚举见附加说明】 |
| 7.8 | msku | msku | string | JX-MPNS-QJZP | Required | MSKU |
| 7.9 | asin | asin | string | B07H2PWQR2 | Required | asin |
| 7.10 | fulfillment | 订单类型 | string | FBA | Required | 订单类型:FBA、FBM、'' |
| 7.11 | principal | 销售额 | number | 0 | Required | 销售额 |
| 7.12 | commission | 平台费 | number | 0 | Required | 平台费 |
| 7.13 | tax | 销售税额 | number | 0 | Required | 销售税额 |
| 7.14 | other | 平台收入中其他收入的其他费用 | number | 0 | Required | 平台收入中其他收入的其他费用 |
| 7.15 | posted_datetime_locale | 结算时间 | string | 2023-03-02 05:05:29 | Required | 结算时间 |
| 7.16 | currency_code | 选择转化后币种 | string | CNY | Required | 选择转化后币种 |
| 7.17 | currency_icon | 选择转化后对应的币符 | string | ¥ | Required | 选择转化后对应的币符 |
| 7.18 | order_id | 订单号 | string | AMPSBilling_48155952912_3_2023_01_01 | Required | 订单号 |
| 7.19 | event_source | 来源 | string | ServiceFee | Required | 来源 |
| 7.20 | account_type | 报告类型 | string | Standard | Required | 报告类型 |
| 7.21 | parent_asin | 父asin | string | B07H2PWQR2 | Required | 父asin |
| 7.22 | local_name | 品名 | string | local_name | Required | 品名 |
| 7.23 | local_sku | local_sku | string | local_sku | Required | sku |
| 7.24 | settlement_status | 结算状态 | array<any> | ["Closed"] | Required | 结算状态 |
| 7.25 | fund_transfer_status | 转账状态 | array<any> | ["Succeeded"] | Required | 转账状态 |
| 7.26 | fund_transfer_datetime_locale | 转账时间 | string | 2023-03-02 05:05:29 | Required | 转账时间 |
| 7.27 | shipment_datetime_locale | 发货时间 | string | 2023-03-02 05:05:29 | Required | 发货时间 |
| 7.28 | small_image_url | 图片 | string | https://www.amazon.com/dp/B07H2PWQR2 | Required | 图片 |
| 7.29 | cost_quantity | 成本数量 | number | 0 | Required | 成本数量 |
| 7.30 | product_sales_quantity | 订单数量 | number | 0 | Required | 订单数量 |
| 7.31 | shipping_charge | 买家运费 | number | 0 | Required | 买家运费 |
| 7.32 | promotional_rebates | 促销折扣 | number | 0 | Required | 促销折扣 |
| 7.33 | shipping_chargeback | 运费拒付 | number | 0 | Required | 运费拒付 |
| 7.34 | gift_wrap | 礼品包装 | number | 0 | Required | 礼品包装 |
| 7.35 | giftwrap_chargeback | 礼品包装拒付 | number | 0 | Required | 礼品包装拒付 |
| 7.36 | fba_per_unit_fulfillment_fee | FBA费 | number | 0 | Required | FBA费 |
| 7.37 | refund_commission | 交易费用退款额 | number | 0 | Required | 交易费用退款额 |
| 7.38 | shipping_tax | 运费税 | number | 0 | Required | 运费税 |
| 7.39 | sales_tax_withheld | 市场税 | number | 0 | Required | 市场税 |
| 7.40 | marketplace_facilitator_vat_principal | 市场税-销售额 | number | 0 | Required | 市场税-销售额 |
| 7.41 | marketplace_facilitator_vat_shipping | 市场税-买家运费 | number | 0 | Required | 市场税-买家运费 |
| 7.42 | giftWrap_tax | 礼物包装税 | number | 0 | Required | 礼物包装税 |
| 7.43 | promotion_discount_tax | 促销折扣税 | number | 0 | Required | 促销折扣税 |
| 7.44 | shipping_discount_tax | 运费折扣税 | number | 0 | Required | 运费折扣税 |
| 7.45 | restocking_fee | 补货费 | number | 0 | Required | 补货费 |
| 7.46 | other_transaction_fees_total | 其他交易费总计 | number | -17483.7 | Required | 其他交易费总计 |
| 7.47 | other_transaction_fees_detail | 其他交易费明细 | string | {"PaidServicesFee":-17483.70} | Required | 其他交易费明细,所有未识别的明细汇总 |
| 7.48 | settlement_total | 亚马逊结算小结 | number | -17483.7 | Required | 亚马逊结算小结 |
| 7.49 | purchase_costs_total | 采购成本 | number | 0 | Required | 采购成本 |
| 7.50 | logistics_costs_total | 头程成本 | number | 0 | Required | 头程成本 |
| 7.51 | other_costs_total | 其他成本 | number | 0 | Required | 其他成本 |
| 7.52 | gross_profit | 毛利润 | number | -17483.7 | Required | 毛利润 |
The 查询利润报表 - 订单 API (/bd/profit/report/open/report/order/list) 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.