查询利润报表 - 订单
/bd/profit/report/open/report/order/list本接口即将下线【不再建议使用】，建议使用查询利润报表 - 订单维度transaction视图
接口信息
| API Path | 请求协议 | 请求方式 | 令牌桶容量 |
|---|---|---|---|
/bd/profit/report/open/report/order/list | HTTPS | POST | 10 |
请求参数
offsetintegerlengthintegermidsarray<any>sidsarray<any>search_date_fieldstring必填start_datestring必填end_datestring必填search_fieldstringsearch_valuearray<any>currency_codestringaccount_typestringsettlement_statusarray<any>fund_transfer_statusarray<any>event_sourcearray<any>descriptionarray<any>请求示例
{
"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"
]
}返回结果
Json Object
codeinteger必填messagestring必填error_detailsarray<any>必填request_idstring必填response_timestring必填totalinteger必填dataarray<object>必填隐藏子属性
idstring必填sidinteger必填store_namestring必填country_codestring必填countrystring必填fidstring必填descriptionstring必填mskustring必填asinstring必填fulfillmentstring必填principalnumber必填commissionnumber必填taxnumber必填othernumber必填posted_datetime_localestring必填currency_codestring必填currency_iconstring必填order_idstring必填event_sourcestring必填account_typestring必填parent_asinstring必填local_namestring必填local_skustring必填settlement_statusarray<any>必填fund_transfer_statusarray<any>必填fund_transfer_datetime_localestring必填shipment_datetime_localestring必填small_image_urlstring必填cost_quantitynumber必填product_sales_quantitynumber必填shipping_chargenumber必填promotional_rebatesnumber必填shipping_chargebacknumber必填gift_wrapnumber必填giftwrap_chargebacknumber必填fba_per_unit_fulfillment_feenumber必填refund_commissionnumber必填shipping_taxnumber必填sales_tax_withheldnumber必填marketplace_facilitator_vat_principalnumber必填marketplace_facilitator_vat_shippingnumber必填giftWrap_taxnumber必填promotion_discount_taxnumber必填shipping_discount_taxnumber必填restocking_feenumber必填other_transaction_fees_totalnumber必填other_transaction_fees_detailstring必填settlement_totalnumber必填purchase_costs_totalnumber必填logistics_costs_totalnumber必填other_costs_totalnumber必填gross_profitnumber必填返回成功示例
{
"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.00,
"commission": 0.00,
"tax": 0.00,
"other": 0.00,
"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.00,
"promotional_rebates": 0.00,
"shipping_chargeback": 0.00,
"gift_wrap": 0.00,
"giftwrap_chargeback": 0.00,
"fba_per_unit_fulfillment_fee": 0.00,
"refund_commission": 0.00,
"shipping_tax": 0.00,
"sales_tax_withheld": 0.00,
"marketplace_facilitator_vat_principal": 0.00,
"marketplace_facilitator_vat_shipping": 0.00,
"giftWrap_tax": 0.00,
"promotion_discount_tax": 0.00,
"shipping_discount_tax": 0.00,
"restocking_fee": 0.00,
"other_transaction_fees_total": -17483.70,
"other_transaction_fees_detail": "{\"PaidServicesFee\":-17483.70}",
"settlement_total": -17483.70,
"purchase_costs_total": 0.00,
"logistics_costs_total": 0.00,
"other_costs_total": 0.00,
"gross_profit": -17483.70
}
]
}附加说明
- description字段枚举值如下：
PointsAdjusted、TaxWithheldAdjustment、Principal、Tax、FBAPerUnitFulfillmentFee、Commission、MarketplaceFacilitatorTax-Principal、ShippingCharge、ShippingTax、ShippingChargeback、MarketplaceFacilitatorVAT-Principal、MarketplaceFacilitatorVAT-Shipping、FBALongTermStorageFee、ReserveDebit、ShippingDiscount、PromotionDiscount、MarketplaceFacilitatorTax-Shipping、FBACustomerRetrunFee、RefundCommission、ReserveCredit、FREE_REPLACEMENT_REFUND_ITEMS、WAREHOUSE_DAMAGE、CouponRedemptionFee、FBADisposalFee、FeeAmount、Revenue、CostOfPointsGranted、ShippingDiscountTax、PaymentMethodFee、CODChargeback、PromotionDiscountTax、RestockingFee、baseValue、feeAmount、GiftWrap、GiftWrapTax、GiftwrapChargeback、MarketplaceFacilitatorTax-Other、REVERSAL_REIMBURSEMENT、COMPENSATED_CLAWBACK、Subscription、FBAStorageFee、TaxAmount、VineFee、BaseTax、WAREHOUSE_LOST、RecoveryAmount、CostOfPointsReturned、TaxWithheld、NonSubscriptionFeeAdj、MarketplaceFacilitatorTax-RestockingFee、REMOVAL_ORDER_LOST、RevenueAdjustment、TaxAmountAdjustment、CSBAFee、ShippingHB、Goodwill、MiscAdjustment、FBAInboundDefectFee、FBAOverageFee、FailedDisbursement、taxValue、ReviewEnrollmentFee、FBARemovalFee、CommissionCorrection、ReturnShipping、PostageRefund_Postage、LiquidationsBrokerageFee、PaidServicesFee、WAREHOUSE_LOST_MANUAL、INCORRECT_FEES_NON_ITEMIZED
- 唯一键：
sid + posted_datetime_locale + fid + order_id + event_source + seller_sku