Lingxing
切换旧版

查询订单利润 - MSKU

POST/basicOpen/finance/mreport/OrderProfit

唯一键说明:sid+msku

接口信息

API Path请求协议请求方式令牌桶容量
/basicOpen/finance/mreport/OrderProfitHTTPSPOST1

请求参数

offsetinteger
分页偏移量,默认0
lengthinteger
分页长度,默认20,上限5000
sidsarray<any>
店铺id ,对应查询亚马逊店铺列表接口对应字段【sid】
startDatestring必填
查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s
endDatestring必填
查询时间,双闭区间,格式:Y-m-d 或 Y-m-d H:i:s
searchFieldstring
搜索值类型:
seller_sku 卖家SKU
asin ASIN
local_name 本地名称
local_sku 本地SKU
model 型号
parent_asin 父ASIN;默认 seller_sku
searchValuearray<any>
搜索的值
currencyCodestring
币种code【默认原币种】, 可选值:原币种,CNY,USD,EUR,JPY,AUD,CAD,MXN,GBP,INR,AED,SGD,SAR,BRL,SEK,PLN,TRY,HKD

请求cURL示例

curl --location 'https://openapi.lingxing.com/basicOpen/finance/mreport/OrderProfit?access_token=value&timestamp=value&sign=value&app_key=value' \
--header 'Content-Type: application/json' \
--data '{
    "offset": 0,
    "length": 20,
    "sids": [113,115],
    "startDate": "2023-02-01",
    "endDate": "2023-12-05",
    "searchField": "asin",
    "searchValue": ["B09"],
    "currencyCode": "CNY"
}'

返回结果

codeinteger必填
状态码,0:成功
messagestring必填
消息提示
error_detailsarray<any>必填
数据校验失败时的错误详情
request_idstring必填
请求链路id
response_timestring必填
响应时间
totalinteger必填
总数
dataarray<object>必填
数据
隐藏子属性
modelstring必填
型号,取内部 model 数组的第一个值;未返回或无值时为空字符串
示例 MODEL-001
currency_codestring必填
币种
currency_iconstring必填
币种符号
gross_profitstring必填
毛利润
gross_marginstring必填
毛利率
avg_gross_profitstring必填
平均毛利润
volumenumber必填
销量
replacement_quantitynumber必填
补换货量
multi_channel_volumenumber必填
多渠道销量
ad_sales_amountstring必填
广告销售额
ad_volumenumber必填
广告销量
amountstring必填
销售额
tax_amountstring必填
含税销售额
refund_amountstring必填
退款金额
refund_amount_ratestring必填
退款率
shipping_coststring必填
买家运费
promotion_discountstring必填
促销折扣
return_quantitynumber必填
退货量
return_ratestring必填
退货率
selling_feestring必填
平台费
fulfillment_feestring必填
fba发货费(包含亚马逊物流客户退货费)
other_order_feestring必填
其他订单费用
spendstring必填
花费
ads_sb_coststring必填
sb花费
ads_sbv_coststring必填
sbv花费
ads_sd_coststring必填
sd花费
ads_sp_coststring必填
sp花费
purchase_costsstring必填
采购成本
avg_purchase_costsstring必填
采购均价
logistics_costsstring必填
头程成本
avg_logistics_costsstring必填
头程均价
other_costsstring必填
其他成本
avg_other_costsstring必填
其他均价
total_costsstring必填
合计成本
price_listarray<object>必填
商品基础信息
隐藏子属性
principal_uidsstring必填
local_skustring必填
sku
item_namestring必填
标题
cate_titlestring必填
local_namestring必填
sidstring必填
is_deletestring必填
brand_titlestring必填
volumenumber必填
small_main_image_urlstring必填
site_urlstring必填
parent_asinstring必填
seller_skustring必填
asinstring必填
statusstring必填
is_parentboolean必填
是否有子项
small_image_urlstring必填
图片链接
parent_asinsarray<any>必填
父asin
local_infosarray<object>必填
本地商品信息
隐藏子属性
local_skustring必填
local_namestring必填
asinsarray<object>必填
asin
隐藏子属性
asin_urlstring必填
asinstring必填
sidsarray<any>必填
店铺id,在msku维度数组中只有一条数据
item_namestring必填
品名
categoriesarray<any>必填
分类
seller_store_countriesarray<object>必填
国家
隐藏子属性
countrystring必填
namestring必填
brandsarray<any>必填
品牌
refund_quantitystring必填
退款量
principal_namesstring必填
listing负责人
ad_sales_amount_spnumber必填
sp广告销售额
ad_sales_amount_sdnumber必填
sd广告销售额
ad_sales_amount_sbnumber必填
sb广告销售额
ad_sales_amount_sbvnumber必填
sbv广告销售额
ad_volume_spinteger必填
sp广告销量
ad_volume_sdinteger必填
sd广告销量
ad_volume_sbinteger必填
sb广告销量
ad_volume_sbvinteger必填
sbv广告销量
afn_volumeinteger必填
fba销量
mfn_volumeinteger必填
fbm销量
afn_amountnumber必填
fba销售额
mfn_amountnumber必填
fbm销售额
pm_discountnumber必填
价格折扣
sp_discountnumber必填
配送折扣
net_gross_marginstring必填
净毛利率
avg_volumenumber必填
平均日销
net_amountstring必填
净销售额
avg_net_amountstring必填
平均售价
selling_fee_ratestring必填
平台费占比
fulfillment_fee_ratestring必填
FBA发货费占比
spend_ratestring必填
广告费率
total_stock_feestring必填
仓储费
total_stock_fee_ratestring必填
仓储费占比
promotion_feestring必填
推广费
shared_fba_international_inbound_feestring必填
FBA国际物流运费
adjustments_feestring必填
调整费
selling_other_feestring必填
平台其他费
inventory_creditstring必填
FBA库存赔偿
shared_fba_inbound_convenience_feestring必填
入库配置费
cost_of_points_grantedstring必填
积分收入
shared_cost_of_advertisingstring必填
差异分摊
total_other_grantedstring必填
其它收入
shared_fba_liquidation_proceedsstring必填
清算收入
shared_fba_liquidation_proceeds_adjustmentsstring必填
清算调整
shared_amazon_shipping_reimbursementstring必填
亚马逊运费赔偿
shared_safe_t_reimbursementstring必填
Safe-T索赔
shared_netco_transactionstring必填
Netco交易
shared_reimbursementsstring必填
赔偿收入
shared_clawbacksstring必填
追索收入
shared_commingling_vat_incomestring必填
混合VAT收入
gift_wrap_creditsstring必填
包装收入
a_to_z_guarantee_claimsstring必填
买家交易保障索赔额
shared_othersstring必填
其他
fba_storage_feestring必填
月仓储费
shared_fba_storage_feestring必填
月仓储费差异
long_term_storage_feestring必填
长期仓储费
shared_long_term_storage_feestring必填
长期仓储费差异
shared_storage_renewal_billingstring必填
库存续订费
shared_fba_disposal_feestring必填
FBA销毁费
shared_fba_removal_feestring必填
FBA移除费
shared_fba_inbound_transportation_program_feestring必填
入仓手续费
shared_labeling_feestring必填
标签费
shared_polybagging_feestring必填
塑料包装费
shared_bubblewrap_feestring必填
泡沫包装费
shared_taping_feestring必填
胶带费
shared_awd_processing_feestring必填
AWD处理费
shared_awd_transportation_feestring必填
AWD运输费
shared_awd_storage_feestring必填
AWD仓储费
shared_star_storage_feestring必填
卫星仓仓储费
shared_fba_customer_return_feestring必填
FBA退回卖家费
shared_fba_inbound_defect_feestring必填
入库缺陷费
shared_fba_overage_feestring必填
超量仓储费
shared_amazon_partnered_carrier_shipment_feestring必填
合作承运费
shared_item_fee_adjustmentstring必填
库存调整费用
shared_other_fba_inventory_feesstring必填
其他仓储费
fba_fulfillment_feestring必填
fba(对应订单列表FBA发货费)
shared_fba_transaction_customer_return_feestring必填
亚马逊物流客户退货费
off_site_promotion_feestring必填
站外推广费

返回成功示例

{
    "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": ""
        }
    ]
}