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