/erp/sc/routing/finance/ProfitState/profitMsku{
"operation": {
"method": "POST",
"path": "/erp/sc/routing/finance/ProfitState/profitMsku"
},
"protocol": "HTTPS",
"host": "https://openapi.lingxing.com",
"rateLimit": {
"tokenBucketCapacity": 1,
"text": ""
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | offset | 分页偏移量 | integer | — | Required | 分页偏移量,默认0 |
| 2 | length | 分页长度 | integer | — | Required | 分页长度,默认20 |
| 3 | currency_type | 币种 | integer | — | Required | 币种 : 1 CNY 2 USD 3 EUR 4 JPY 5 AUD 6 CAD 7 MXN 8 GBP 9 INR 10 AED 11 SGD 12 SAR 13 BRL 14 SEK 15 PLN 16 TRY |
| 4 | sids | 店铺id | string | — | Required | 店铺id,多个使用英文逗号分隔 ,对应查询亚马逊店铺列表接口对应字段【sid】 |
| 5 | month | 月份 | string | — | Required | 月份 |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | code | 状态码 | integer | 0 | Required | 状态码, 0 成功 |
| 2 | message | 消息提示 | string | success | Required | 消息提示 |
| 3 | error_details | 错误信息 | array<any> | — | Required | 错误信息 |
| 4 | request_id | 请求链路id | string | 8D680B8B-3C6F-3E16-F055-73DC70EAD977 | Required | 请求链路id |
| 5 | response_time | 响应时间 | string | 2020-05-18 11:23:47 | Required | 响应时间 |
| 6 | total | 总数 | integer | 2 | Required | 总数 |
| 7 | fifo_type | 类型 | integer | 1 | Required | 类型:0 固定值,1 先进先出 |
| 8 | is_closing_data | 是否结账数据 | integer | 0 | Required | 是否结账数据:0否,1是 |
| 9 | data | 响应数据 | array<object> | — | Required | 响应数据 |
| 9.1 | date | 请求时间 | string | 2021-07-07 18:01:58 | Required | 请求时间 |
| 9.2 | date_locale | 年月 | string | 2021-05 | Required | 年月 |
| 9.3 | other_fee_goods | 商品其他费 | number | 1.55 | Required | 商品其他费 |
| 9.4 | other_fee_seller | 店铺其他费 | number | 0.19 | Required | 店铺其他费 |
| 9.5 | sid | 店铺id | integer | 1 | Required | 店铺id |
| 9.6 | msku | MSKU值 | string | JX-MPNS-QNHN | Required | MSKU值 |
| 9.7 | asin | asin | string | B07H2PWWWW | Required | ASIN |
| 9.8 | currency_code | 原币种 | string | USD | Required | 原币种,如:USD |
| 9.9 | sales_total | 销售额 | number | — | Required | 销售额 |
| 9.10 | refund | 销售退款 | number | — | Required | 销售退款 |
| 9.11 | sales_total_amz_fba | FBA销售额 | number | — | Required | FBA销售额 |
| 9.12 | sales_total_amz_fbm | FBM销售额 | number | — | Required | FBM销售额 |
| 9.13 | ads_total_sales_amount | 广告销售额 | number | — | Required | 广告销售额 |
| 9.14 | sales_total_quantity | 销量 | string | — | Required | 销量 |
| 9.15 | sales_total_amz_fba_quantity | FBA销量 | string | — | Required | FBA销量 |
| 9.16 | sales_total_amz_fbm_quantity | FBM销量 | string | — | Required | FBM销量 |
| 9.17 | ads_sd_order_quantity | SD广告销量 | string | — | Required | SD广告销量 |
| 9.18 | ads_quantity | 广告销量 | string | — | Required | 广告销量 |
| 9.19 | reship_quantity | 亚马逊补发量 | string | — | Required | 亚马逊补发量 |
| 9.20 | ads_order_quantity | SP广告销量 | string | — | Required | SP广告销量 |
| 9.21 | income_fba_fee | FBA买家运费 | number | — | Required | FBA买家运费 |
| 9.22 | income_fba_amz_fee | 亚马逊FBA发货费 | number | — | Required | 亚马逊FBA发货费 |
| 9.23 | shared_report_inventory_difference_fee | 仓储费差异分摊 | number | — | Required | 仓储费差异分摊 |
| 9.24 | income_fba_mc_fee | 多渠道订单运费 | number | — | Required | 多渠道订单运费 |
| 9.25 | income_fbm_amz_fee | FBM买家运费 | number | — | Required | FBM买家运费 |
| 9.26 | promotion | 促销折扣 | number | — | Required | 促销折扣 |
| 9.27 | adjustment_total | FBA库存赔偿 | number | — | Required | FBA库存赔偿 |
| 9.28 | adjustment | 库存调整补偿金额 | number | — | Required | 库存调整补偿金额 |
| 9.29 | shared_income_adjustment | 费用分摊 | number | — | Required | 费用分摊 |
| 9.30 | liquidations | 清算 | string | 0.0000000000 | Required | 清算 |
| 9.31 | fba_adjustment_quantity | FBA库存赔偿量 | string | — | Required | FBA库存赔偿量 |
| 9.32 | adjustment_quantity | MSKU库存赔偿量 | string | — | Required | MSKU库存赔偿量 |
| 9.33 | refund_quantity | 退款量 | string | — | Required | 退款量 |
| 9.34 | refund_quantity_rate | 退货率 | string | 0% | Required | 退货率 |
| 9.35 | return_total_sellable_quantity | 退货量 | string | — | Required | 退货量 |
| 9.36 | return_sellable_quantity | 退货可售 | string | — | Required | 退货可售 |
| 9.37 | return_unsellable_quantity | 退货不可售 | string | — | Required | 退货不可售 |
| 9.38 | refund_rate | 退款率 | string | 0% | Required | 退款率 |
| 9.39 | expense_fba_fee | 售出订单 | number | — | Required | 售出订单 |
| 9.40 | selling_fee_order_fba | 售出订单平台费 | number | — | Required | 售出订单平台费 |
| 9.41 | expence_fba_amz_fee | 售出订单FBA发货费 | number | — | Required | 售出订单FBA发货费 |
| 9.42 | order_other_fee_order | 售出订单其他费 | number | — | Required | 售出订单其他费 |
| 9.43 | expence_fbm_amz_fee | 售出订单FBM发货费 | number | — | Required | 售出订单FBM发货费 |
| 9.44 | expense_fba_mc_fee | 多渠道FBA发货费 | number | — | Required | 多渠道FBA发货费 |
| 9.45 | return_order | 退款订单 | number | — | Required | 退款订单 |
| 9.46 | selling_fee_refund | 退款订单平台费 | number | — | Required | 退款订单平台费 |
| 9.47 | expence_fba_fee_refund | 退款订单发货费 | number | — | Required | 退款订单发货费 |
| 9.48 | order_other_fee_refund | 退款订单其他费 | number | — | Required | 退款订单其他费 |
| 9.49 | ads_total_fee | 广告费 | number | — | Required | 广告费 |
| 9.50 | ads_fee | SP广告费 | number | — | Required | SP广告费 |
| 9.51 | ads_sbv_fee | SBV广告费分摊 | number | — | Required | SBV广告费分摊 |
| 9.52 | ads_sd_fee | SD广告费 | number | — | Required | SD广告费 |
| 9.53 | ads_sb_fee | SB广告费分摊 | number | — | Required | SB广告费分摊 |
| 9.54 | shared_ads_fee | 广告费差异分摊 | number | — | Required | 广告费差异分摊 |
| 9.55 | total_coupon | 优惠券总和 | number | — | Required | 优惠券总和 |
| 9.56 | total_ld | 秒杀费总和 | number | — | Required | 秒杀费总和 |
| 9.57 | early_reviewer_program_fee | 早期评论者计划 | number | — | Required | 早期评论者计划 |
| 9.58 | total_promotion_fee | 推广费 | number | — | Required | 推广费 |
| 9.59 | fba_inventory_fee | FBA仓储费 | number | — | Required | FBA仓储费 |
| 9.60 | month_storage_inventory_fee | 月仓储费 | number | — | Required | 月仓储费 |
| 9.61 | longterm_storage_inventory_fee | 长期仓储费 | number | — | Required | 长期仓储费 |
| 9.62 | fba_other_inventory_fee | FBA其他仓储服务费 | number | — | Required | FBA其他仓储服务费 |
| 9.63 | disposal_quantity | 销毁量 | string | — | Required | 销毁量 |
| 9.64 | disposal_fee | 销毁费 | number | — | Required | 销毁费 |
| 9.65 | removal_quantity | 移除量 | string | — | Required | 移除量 |
| 9.66 | removal_fee | 移除费 | number | — | Required | 移除费 |
| 9.67 | service_subscription_fee | 订阅费 | number | — | Required | 订阅费 |
| 9.68 | customer_return_fee | 退货入仓费 | number | — | Required | 退货入仓费 |
| 9.69 | fba_amazon_partnered_carrier_shipment_fee | 合作承运费 | number | — | Required | 合作承运费 |
| 9.70 | fba_inventory_placement_service_fee | 合仓费 | number | — | Required | 合仓费 |
| 9.71 | shared_amz_inventory_fee | FBA仓储服务其他费分摊 | number | — | Required | FBA仓储服务其他费分摊 |
| 9.72 | amz_adjustment_total | 库存调整费 | number | — | Required | 库存调整费 |
| 9.73 | amz_adjustment | 库存调整费 | number | — | Required | 库存调整费 |
| 9.74 | shared_expence_adjustment | 其他调整费分摊 | number | — | Required | 其他调整费分摊 |
| 9.75 | selling_other_fee | 平台其他费 | number | — | Required | 平台其他费 |
| 9.76 | platform_other_fee | 其他费分摊 | number | — | Required | 其他费分摊 |
| 9.77 | sale_tax | 销售税 | number | — | Required | 销售税 |
| 9.78 | total_cg_price | 采购成本 | number | — | Required | 采购成本 |
| 9.79 | total_cg_transport_costs | 头程费用 | number | — | Required | 头程费用 |
| 9.80 | custom_order_fee | 测评费 | number | — | Required | 测评费 |
| 9.81 | gross_profit | 毛利润 | number | 1.74 | Required | 毛利润 |
| 9.82 | profit_rate | 毛利率 | string | 0% | Required | 毛利率 |
| 9.83 | shipping_label_fee_order | 售出订单运输标签费 | number | — | Required | 售出订单运输标签费 |
| 9.84 | transaction_inventory_storage_overage_fee | 超量仓储费 | number | — | Required | 超量仓储费 |
| 9.85 | fba_international_freight_fee | FBA物流国际货运费 | number | — | Required | FBA物流国际货运费 |
| 9.86 | hidden_tax_fee | 隐藏税 | number | — | Required | 隐藏税 |
| 9.87 | product_sales_tax | 商品销售税 | number | — | Required | 商品销售税 |
| 9.88 | shipping_credits_tax | 运费税 | number | — | Required | 运费税 |
| 9.89 | gift_wrap_credits_tax | 礼品包装税 | number | — | Required | 礼品包装税 |
| 9.90 | promotional_rebates_tax | 促销折扣税 | number | — | Required | 促销折扣税 |
| 9.91 | tax_marketplace | 市场税 | number | — | Required | 市场税 |
| 9.92 | low_value_goods_tax | 低价值税 | number | — | Required | 低价值税 |
| 9.93 | tax_collection_withholding_total | 亚马逊代收代扣 | number | — | Required | 亚马逊代收代扣 |
| 9.94 | income_tax_withheld | 预扣所得税 | number | — | Required | 预扣所得税 |
| 9.95 | cash_on_delivery | 货到付款(COD) | number | — | Required | 货到付款(COD) |
| 9.96 | tcs_cgst | 印度站税费 | number | — | Required | 印度站税费 |
| 9.97 | tcs_sgst | 印度站税费 | number | — | Required | 印度站税费 |
| 9.98 | tcs_igst | 印度站税费 | number | — | Required | 印度站税费 |
| 9.99 | small_image_url | 缩略图 | string | — | Required | 缩略图 |
| 9.100 | asin_url | ASIN链接 | string | https://www.amazon.com/dp/B07H2PWWWW | Required | ASIN链接 |
| 9.101 | category_text | 分类名 | string | — | Required | 分类名 |
| 9.102 | product_brand_text | 品牌名 | string | — | Required | 品牌名 |
| 9.103 | item_name | 品名 | string | Pencil Case with 2 Compartments | Required | 品名 |
| 9.104 | local_sku | 本地SKU | string | 1596786 | Required | 本地SKU |
| 9.105 | local_name | 本地商品名 | string | =C135+A135 | Required | 本地商品名 |
| 9.106 | asin_name | 负责人 | string | — | Required | 负责人 |
| 9.107 | seller_name | 店铺名 | string | PM-MX-MX | Required | 店铺名 |
| 9.108 | marketplace | 国家 | string | 美国 | Required | 国家 |
| 9.109 | icon | 货币符号 | string | $ | Required | 货币符号 |
| 9.110 | other_fee_goods_detail | 商品其他费详情 | array<object> | — | Required | 商品其他费详情 |
| 9.110.1 | sid | 店铺id | string | 1 | Required | 店铺id |
| 9.110.2 | other_fee_type_id | 费用类型ID | number | 1087 | Required | 费用类型ID |
| 9.110.3 | name | 费用名称 | string | 555 | Required | 费用名称 |
| 9.110.4 | other_fee | 金额 | number | 1.55 | Required | 金额 |
| 9.111 | other_fee_seller_detail | 店铺其他费详情 | array<object> | — | Required | 店铺其他费详情 |
| 9.111.1 | sid | 店铺id | string | 1 | Required | 店铺id |
| 9.111.2 | other_fee_type_id | 费用类型ID | number | 1096 | Required | 费用类型ID |
| 9.111.3 | name | 费用名称 | string | 其他费1 | Required | 费用名称 |
| 9.111.4 | other_fee | 金额 | number | 0.12 | Required | 金额 |
The 查询利润报表(旧) - MSKU API (/erp/sc/routing/finance/ProfitState/profitMsku) 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.