/basicOpen/finance/mreport/OrderProfit{
"operation": {
"method": "POST",
"path": "/basicOpen/finance/mreport/OrderProfit"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
},
"requestExample": "curl --location 'https://openapi.lingxing.com/basicOpen/finance/mreport/OrderProfit?access_token=value×tamp=value&sign=value&app_key=value' \\\n--header 'Content-Type: application/json' \\\n--data '{\n \"offset\": 0,\n \"length\": 20,\n \"sids\": [113,115],\n \"startDate\": \"2023-02-01\",\n \"endDate\": \"2023-12-05\",\n \"searchField\": \"asin\",\n \"searchValue\": [\"B09\"],\n \"currencyCode\": \"CNY\"\n}'",
"responseExample": {
"code": 0,
"message": "success",
"error_details": [],
"request_id": "574FB0B8-FD6E-8D29-91FD-295B55CF5398",
"response_time": "2024-07-31 14:41:25",
"data": [
{
"model": "MODEL-001",
"currency_code": "USD",
"currency_icon": "$",
"gross_profit": "0.00",
"gross_margin": "0.0000",
"avg_gross_profit": "0.00",
"volume": 0,
"replacement_quantity": 0,
"multi_channel_volume": 0,
"ad_sales_amount": "0.00",
"ad_volume": 0,
"amount": "0.00",
"afn_amount": "",
"mfn_amount": "",
"tax_amount": "0.00",
"refund_amount": "0.00",
"refund_amount_rate": "0.00",
"shipping_cost": "0.00",
"promotion_discount": "0.00",
"pm_discount": "",
"sp_discount": "",
"return_quantity": 0,
"return_rate": "0.0000",
"selling_fee": "0.00",
"fulfillment_fee": "0.00",
"other_order_fee": "0.00",
"spend": "0.00",
"ads_sb_cost": "0.00",
"ads_sbv_cost": "0.00",
"ads_sd_cost": "0.00",
"ads_sp_cost": "0.00",
"purchase_costs": "0.00",
"avg_purchase_costs": "0.00",
"logistics_costs": "0.00",
"avg_logistics_costs": "0.00",
"other_costs": "0.00",
"avg_other_costs": "0.00",
"total_costs": "0.00",
"price_list": [
{
"principal_uids": "10529123",
"local_sku": "4990a126a7b36350f4916c8f642fa811",
"item_name": "lingxing amazon product title A8442DB",
"cate_title": "分类5",
"local_name": "64fea5cf204b8d40d9b174d12d799a03",
"sid": "2",
"is_delete": "1",
"brand_title": "",
"volume": 0,
"small_main_image_url": "",
"site_url": "",
"parent_asin": "BFF23E679B",
"seller_sku": "5ebabc80e8d38aec1ee098fdc6bf99f9",
"asin": "BFF23E679B",
"status": "0"
}
],
"is_parent": false,
"small_image_url": "",
"parent_asins": [
"BFF23E679B"
],
"local_infos": [
{
"local_sku": "4990a126a7b36350f4916c8f642fa811",
"local_name": "64fea5cf204b8d40d9b174d12d799a03"
}
],
"asins": [
{
"asin_url": "",
"asin": "BFF23E679B"
}
],
"sids": [
"2"
],
"item_name": "",
"categories": [
"分类5"
],
"seller_store_countries": [
{
"country": "美国",
"name": ""
}
],
"brands": [],
"refund_quantity": "",
"principal_names": "",
"ad_sales_amount_sp": "",
"ad_sales_amount_sd": "",
"ad_sales_amount_sb": "",
"ad_sales_amount_sbv": "",
"ad_volume_sp": "",
"ad_volume_sd": "",
"ad_volume_sb": "",
"ad_volume_sbv": "",
"afn_volume": "",
"mfn_volume": ""
}
]
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Optional | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Optional | 分页长度,默认20,上限5000 |
| 3 | sids | 店铺id | array<any> | — | Optional | 店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 4 | startDate | 查询时间 | string | — | Required | 查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s |
| 5 | endDate | 查询时间 | string | — | Required | 查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s |
| 6 | searchField | 搜索值类型 | string | — | Optional | 搜索值类型: seller_sku 卖家SKU asin ASIN local_name 本地名称 local_sku 本地SKU model 型号 parent_asin 父ASIN;默认 seller_sku |
| 7 | searchValue | 搜索的值 | array<any> | — | Optional | 搜索的值 |
| 8 | currencyCode | 币种code【默认原币种】 | string | — | Optional | 币种code【默认原币种】, 可选值:原币种,CNY,USD,EUR,JPY,AUD,CAD,MXN,GBP,INR,AED,SGD,SAR,BRL,SEK,PLN,TRY,HKD |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | — | Required | 状态码,0:成功 |
| 2 | message | 消息提示 | string | — | Required | 消息提示 |
| 3 | error_details | 数据校验失败时的错误详情 | array<any> | — | Required | 数据校验失败时的错误详情 |
| 4 | request_id | 请求链路id | string | — | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | — | Required | 响应时间 |
| 6 | total | 总数 | integer | — | Required | 总数 |
| 7 | data | 数据 | array<object> | — | Required | 数据 |
| 7.1 | model | 型号 | string | MODEL-001 | Required | 型号,取内部 model 数组的第一个值;未返回或无值时为空字符串 |
| 7.2 | currency_code | 币种 | string | — | Required | 币种 |
| 7.3 | currency_icon | 币种符号 | string | — | Required | 币种符号 |
| 7.4 | gross_profit | 毛利润 | string | — | Required | 毛利润 |
| 7.5 | gross_margin | 毛利率 | string | — | Required | 毛利率 |
| 7.6 | avg_gross_profit | 平均毛利润 | string | — | Required | 平均毛利润 |
| 7.7 | volume | 销量 | number | — | Required | 销量 |
| 7.8 | replacement_quantity | 补换货量 | number | — | Required | 补换货量 |
| 7.9 | multi_channel_volume | 多渠道销量 | number | — | Required | 多渠道销量 |
| 7.10 | ad_sales_amount | 广告销售额 | string | — | Required | 广告销售额 |
| 7.11 | ad_volume | 广告销量 | number | — | Required | 广告销量 |
| 7.12 | amount | 销售额 | string | — | Required | 销售额 |
| 7.13 | tax_amount | 含税销售额 | string | — | Required | 含税销售额 |
| 7.14 | refund_amount | 退款金额 | string | — | Required | 退款金额 |
| 7.15 | refund_amount_rate | 退款率 | string | — | Required | 退款率 |
| 7.16 | shipping_cost | 买家运费 | string | — | Required | 买家运费 |
| 7.17 | promotion_discount | 促销折扣 | string | — | Required | 促销折扣 |
| 7.18 | return_quantity | 退货量 | number | — | Required | 退货量 |
| 7.19 | return_rate | 退货率 | string | — | Required | 退货率 |
| 7.20 | selling_fee | 平台费 | string | — | Required | 平台费 |
| 7.21 | fulfillment_fee | fba发货费(包含亚马逊物流客户退货费) | string | — | Required | fba发货费(包含亚马逊物流客户退货费) |
| 7.22 | other_order_fee | 其他订单费用 | string | — | Required | 其他订单费用 |
| 7.23 | spend | 花费 | string | — | Required | 花费 |
| 7.24 | ads_sb_cost | sb花费 | string | — | Required | sb花费 |
| 7.25 | ads_sbv_cost | sbv花费 | string | — | Required | sbv花费 |
| 7.26 | ads_sd_cost | sd花费 | string | — | Required | sd花费 |
| 7.27 | ads_sp_cost | sp花费 | string | — | Required | sp花费 |
| 7.28 | purchase_costs | 采购成本 | string | — | Required | 采购成本 |
| 7.29 | avg_purchase_costs | 采购均价 | string | — | Required | 采购均价 |
| 7.30 | logistics_costs | 头程成本 | string | — | Required | 头程成本 |
| 7.31 | avg_logistics_costs | 头程均价 | string | — | Required | 头程均价 |
| 7.32 | other_costs | 其他成本 | string | — | Required | 其他成本 |
| 7.33 | avg_other_costs | 其他均价 | string | — | Required | 其他均价 |
| 7.34 | total_costs | 合计成本 | string | — | Required | 合计成本 |
| 7.35 | price_list | 商品基础信息 | array<object> | — | Required | 商品基础信息 |
| 7.35.1 | principal_uids | principal_uids | string | — | Required | |
| 7.35.2 | local_sku | local_sku | string | — | Required | sku |
| 7.35.3 | item_name | 标题 | string | — | Required | 标题 |
| 7.35.4 | cate_title | cate_title | string | — | Required | |
| 7.35.5 | local_name | local_name | string | — | Required | |
| 7.35.6 | sid | sid | string | — | Required | |
| 7.35.7 | is_delete | is_delete | string | — | Required | |
| 7.35.8 | brand_title | brand_title | string | — | Required | |
| 7.35.9 | volume | volume | number | — | Required | |
| 7.35.10 | small_main_image_url | small_main_image_url | string | — | Required | |
| 7.35.11 | site_url | site_url | string | — | Required | |
| 7.35.12 | parent_asin | parent_asin | string | — | Required | |
| 7.35.13 | seller_sku | seller_sku | string | — | Required | |
| 7.35.14 | asin | asin | string | — | Required | |
| 7.35.15 | status | status | string | — | Required | |
| 7.36 | is_parent | 是否有子项 | boolean | — | Required | 是否有子项 |
| 7.37 | small_image_url | 图片链接 | string | — | Required | 图片链接 |
| 7.38 | parent_asins | 父asin | array<any> | — | Required | 父asin |
| 7.39 | local_infos | 本地商品信息 | array<object> | — | Required | 本地商品信息 |
| 7.39.1 | local_sku | local_sku | string | — | Required | |
| 7.39.2 | local_name | local_name | string | — | Required | |
| 7.40 | asins | asins | array<object> | — | Required | asin |
| 7.40.1 | asin_url | asin_url | string | — | Required | |
| 7.40.2 | asin | asin | string | — | Required | |
| 7.41 | sids | 店铺id | array<any> | — | Required | 店铺id,在msku维度数组中只有一条数据 |
| 7.42 | item_name | 品名 | string | — | Required | 品名 |
| 7.43 | categories | 分类 | array<any> | — | Required | 分类 |
| 7.44 | seller_store_countries | 国家 | array<object> | — | Required | 国家 |
| 7.44.1 | country | country | string | — | Required | |
| 7.44.2 | name | name | string | — | Required | |
| 7.45 | brands | 品牌 | array<any> | — | Required | 品牌 |
| 7.46 | refund_quantity | 退款量 | string | — | Required | 退款量 |
| 7.47 | principal_names | listing负责人 | string | — | Required | listing负责人 |
| 7.48 | ad_sales_amount_sp | sp广告销售额 | number | — | Required | sp广告销售额 |
| 7.49 | ad_sales_amount_sd | sd广告销售额 | number | — | Required | sd广告销售额 |
| 7.50 | ad_sales_amount_sb | sb广告销售额 | number | — | Required | sb广告销售额 |
| 7.51 | ad_sales_amount_sbv | sbv广告销售额 | number | — | Required | sbv广告销售额 |
| 7.52 | ad_volume_sp | sp广告销量 | integer | — | Required | sp广告销量 |
| 7.53 | ad_volume_sd | sd广告销量 | integer | — | Required | sd广告销量 |
| 7.54 | ad_volume_sb | sb广告销量 | integer | — | Required | sb广告销量 |
| 7.55 | ad_volume_sbv | sbv广告销量 | integer | — | Required | sbv广告销量 |
| 7.56 | afn_volume | fba销量 | integer | — | Required | fba销量 |
| 7.57 | mfn_volume | fbm销量 | integer | — | Required | fbm销量 |
| 7.58 | afn_amount | fba销售额 | number | — | Required | fba销售额 |
| 7.59 | mfn_amount | fbm销售额 | number | — | Required | fbm销售额 |
| 7.60 | pm_discount | 价格折扣 | number | — | Required | 价格折扣 |
| 7.61 | sp_discount | 配送折扣 | number | — | Required | 配送折扣 |
| 7.62 | net_gross_margin | 净毛利率 | string | — | Required | 净毛利率 |
| 7.63 | avg_volume | 平均日销 | number | — | Required | 平均日销 |
| 7.64 | net_amount | 净销售额 | string | — | Required | 净销售额 |
| 7.65 | avg_net_amount | 平均售价 | string | — | Required | 平均售价 |
| 7.66 | selling_fee_rate | 平台费占比 | string | — | Required | 平台费占比 |
| 7.67 | fulfillment_fee_rate | FBA发货费占比 | string | — | Required | FBA发货费占比 |
| 7.68 | spend_rate | 广告费率 | string | — | Required | 广告费率 |
| 7.69 | total_stock_fee | 仓储费 | string | — | Required | 仓储费 |
| 7.70 | total_stock_fee_rate | 仓储费占比 | string | — | Required | 仓储费占比 |
| 7.71 | promotion_fee | 推广费 | string | — | Required | 推广费 |
| 7.72 | shared_fba_international_inbound_fee | FBA国际物流运费 | string | — | Required | FBA国际物流运费 |
| 7.73 | adjustments_fee | 调整费 | string | — | Required | 调整费 |
| 7.74 | selling_other_fee | 平台其他费 | string | — | Required | 平台其他费 |
| 7.75 | inventory_credit | FBA库存赔偿 | string | — | Required | FBA库存赔偿 |
| 7.76 | shared_fba_inbound_convenience_fee | 入库配置费 | string | — | Required | 入库配置费 |
| 7.77 | cost_of_points_granted | 积分收入 | string | — | Required | 积分收入 |
| 7.78 | shared_cost_of_advertising | 差异分摊 | string | — | Required | 差异分摊 |
| 7.79 | total_other_granted | 其它收入 | string | — | Required | 其它收入 |
| 7.80 | shared_fba_liquidation_proceeds | 清算收入 | string | — | Required | 清算收入 |
| 7.81 | shared_fba_liquidation_proceeds_adjustments | 清算调整 | string | — | Required | 清算调整 |
| 7.82 | shared_amazon_shipping_reimbursement | 亚马逊运费赔偿 | string | — | Required | 亚马逊运费赔偿 |
| 7.83 | shared_safe_t_reimbursement | Safe-T索赔 | string | — | Required | Safe-T索赔 |
| 7.84 | shared_netco_transaction | Netco交易 | string | — | Required | Netco交易 |
| 7.85 | shared_reimbursements | 赔偿收入 | string | — | Required | 赔偿收入 |
| 7.86 | shared_clawbacks | 追索收入 | string | — | Required | 追索收入 |
| 7.87 | shared_commingling_vat_income | 混合VAT收入 | string | — | Required | 混合VAT收入 |
| 7.88 | gift_wrap_credits | 包装收入 | string | — | Required | 包装收入 |
| 7.89 | a_to_z_guarantee_claims | 买家交易保障索赔额 | string | — | Required | 买家交易保障索赔额 |
| 7.90 | shared_others | 其他 | string | — | Required | 其他 |
| 7.91 | fba_storage_fee | 月仓储费 | string | — | Required | 月仓储费 |
| 7.92 | shared_fba_storage_fee | 月仓储费差异 | string | — | Required | 月仓储费差异 |
| 7.93 | long_term_storage_fee | 长期仓储费 | string | — | Required | 长期仓储费 |
| 7.94 | shared_long_term_storage_fee | 长期仓储费差异 | string | — | Required | 长期仓储费差异 |
| 7.95 | shared_storage_renewal_billing | 库存续订费 | string | — | Required | 库存续订费 |
| 7.96 | shared_fba_disposal_fee | FBA销毁费 | string | — | Required | FBA销毁费 |
| 7.97 | shared_fba_removal_fee | FBA移除费 | string | — | Required | FBA移除费 |
| 7.98 | shared_fba_inbound_transportation_program_fee | 入仓手续费 | string | — | Required | 入仓手续费 |
| 7.99 | shared_labeling_fee | 标签费 | string | — | Required | 标签费 |
| 7.100 | shared_polybagging_fee | 塑料包装费 | string | — | Required | 塑料包装费 |
| 7.101 | shared_bubblewrap_fee | 泡沫包装费 | string | — | Required | 泡沫包装费 |
| 7.102 | shared_taping_fee | 胶带费 | string | — | Required | 胶带费 |
| 7.103 | shared_awd_processing_fee | AWD处理费 | string | — | Required | AWD处理费 |
| 7.104 | shared_awd_transportation_fee | AWD运输费 | string | — | Required | AWD运输费 |
| 7.105 | shared_awd_storage_fee | AWD仓储费 | string | — | Required | AWD仓储费 |
| 7.106 | shared_star_storage_fee | 卫星仓仓储费 | string | — | Required | 卫星仓仓储费 |
| 7.107 | shared_fba_customer_return_fee | FBA退回卖家费 | string | — | Required | FBA退回卖家费 |
| 7.108 | shared_fba_inbound_defect_fee | 入库缺陷费 | string | — | Required | 入库缺陷费 |
| 7.109 | shared_fba_overage_fee | 超量仓储费 | string | — | Required | 超量仓储费 |
| 7.110 | shared_amazon_partnered_carrier_shipment_fee | 合作承运费 | string | — | Required | 合作承运费 |
| 7.111 | shared_item_fee_adjustment | 库存调整费用 | string | — | Required | 库存调整费用 |
| 7.112 | shared_other_fba_inventory_fees | 其他仓储费 | string | — | Required | 其他仓储费 |
| 7.113 | fba_fulfillment_fee | fba(对应订单列表FBA发货费) | string | — | Required | fba(对应订单列表FBA发货费) |
| 7.114 | shared_fba_transaction_customer_return_fee | 亚马逊物流客户退货费 | string | — | Required | 亚马逊物流客户退货费 |
| 7.115 | off_site_promotion_fee | 站外推广费 | string | — | Required | 站外推广费 |
The 查询订单利润 - MSKU API (/basicOpen/finance/mreport/OrderProfit) 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.