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