感谢您的反馈!
淘宝闪购联盟媒体推广订单明细报表查询。如果只关注佣金,看income和settle字段。业务主键:attr_type+biz_order_id
| 名称 | 类型 | 是否必须 | 示例值 | 更多限制 | 描述 |
|---|---|---|---|---|---|
| date_type | Number | 必须 | 1 |
|
时间维度,1-付款时间 2-创建时间 3-结算时间 4-更新时间 |
| settle_state | Number | 可选 | 1 | 结算状态,1-已结算 2-未结算 不传-全部状态 | |
| end_date | String | 可选 | 2021-09-14 10:00:00 | 查询截止时间,精确到时分秒 | |
| biz_unit | Number | 必须 | 1 |
|
1-CPA 2-CPS |
| page_size | Number | 必须 | 10 |
|
每页返回数据大小,默认10,最大返回50 |
| page_number | Number | 必须 | 1 |
|
页码,默认第一页 |
| start_date | String | 必须 | 2021-09-14 10:00:00 | 查询起始时间,精确到时分秒 | |
| order_state | Number | 可选 | 2 | 订单状态,0-已失效 1-已下单 2-已付款 4-已收货 不传-全部状态 | |
| flow_type | String | 可选 | 1 | 场景值,支持多场景(英文逗号分隔)查询7卡券订单,8卡券核销订单,10-媒体出资CPS红包,11-媒体出资霸王餐加码红包,26-评价有礼订单,4-零售 | |
| pid | String | 可选 | alsc_0000_1111_2222 | 推广位pid | |
| order_id | String | 可选 | 2022111xxxx | 淘宝子订单号或淘宝闪购订单号 | |
| include_used_store_id | Boolean | 可选 | false | 是否包含核销门店 | |
| order_channel | String | 可选 | taobao_shangou | 淘宝闪购-taobao_shangou |
| 名称 | 类型 | 示例值 | 描述 |
|---|---|---|---|
| result | OrderDetailReportDTO [] | [] | 所有订单list |
|
|||
| result_success | Boolean | true | 接口返回是否正确 |
| biz_error_desc | String | 入参不能为空 | 接口错误描述 |
| total_count | Number | 100 | 当前查询条件下总的记录 |
| biz_error_code | Number | 201 | 接口错误码 |
TaobaoClient client = new DefaultTaobaoClient(url, appkey, secret);
AlibabaAlscUnionKbcpxPositiveOrderGetRequest req = new AlibabaAlscUnionKbcpxPositiveOrderGetRequest();
req.setDateType(1L);
req.setSettleState(1L);
req.setEndDate("2021-09-14 10:00:00");
req.setBizUnit(1L);
req.setPageSize(10L);
req.setPageNumber(1L);
req.setStartDate("2021-09-14 10:00:00");
req.setOrderState(2L);
req.setFlowType("1");
req.setPid("alsc_0000_1111_2222");
req.setOrderId("2022111xxxx");
req.setIncludeUsedStoreId(false);
req.setOrderChannel("taobao_shangou");
AlibabaAlscUnionKbcpxPositiveOrderGetResponse rsp = client.execute(req);
System.out.println(rsp.getBody());
<alibaba_alsc_union_kbcpx_positive_order_get_response>
<result>
<order_detail_report_d_t_o>
<title>商品标题</title>
<pic_url>https://xxx</pic_url>
<shop_name>xxx店</shop_name>
<pay_amount>30.00</pay_amount>
<settle_amount>28.00</settle_amount>
<trace_time>2021-09-01 10:00:00</trace_time>
<tk_create_time>2021-09-01 10:00:00</tk_create_time>
<pay_time>2021-09-01 10:00:00</pay_time>
<receive_time>2021-09-01 10:00:00</receive_time>
<settle_time>2021-09-01 11:00:00</settle_time>
<income>28.00</income>
<settle>24.00</settle>
<item_id>123456789</item_id>
<product_num>5</product_num>
<unit_price>10.00</unit_price>
<category_name>商品类目</category_name>
<biz_order_id>123456789</biz_order_id>
<parent_order_id>123456789</parent_order_id>
<main_item_id>123456789</main_item_id>
<main_item_title>主商品名称</main_item_title>
<order_state>2</order_state>
<order_item_status_name>售中退款</order_item_status_name>
<settle_state>1</settle_state>
<full_settle_amount>28.00</full_settle_amount>
<commission_rate>10%</commission_rate>
<commission_fee>10.00</commission_fee>
<subsidy_rate>5%</subsidy_rate>
<subsidy_fee>5.00</subsidy_fee>
<income_rate>15%</income_rate>
<stratify_rate>100%</stratify_rate>
<deduct_rate>15%</deduct_rate>
<platform_commission_rate>10%</platform_commission_rate>
<platform_commission_fee>10</platform_commission_fee>
<channel_rate>0%</channel_rate>
<channel_fee>0</channel_fee>
<media_id>12345678</media_id>
<media_name>媒体名称</media_name>
<ad_zone_id>12345678</ad_zone_id>
<ad_zone_name>推广位名称</ad_zone_name>
<activity_fee>12.0</activity_fee>
<activity_service_fee>2.4</activity_service_fee>
<activity_service_rate>0.2</activity_service_rate>
<gmt_modified>2021-09-01 10:00:00</gmt_modified>
<tag>用户维权</tag>
<sid>123456</sid>
<platform_type>1</platform_type>
<activity_id>12</activity_id>
<used_store_id>EFDI12d23A</used_store_id>
<pid>alsc_xxx_xxx_xxx</pid>
<relation_order_id>203232223</relation_order_id>
<flow_type>1</flow_type>
<order_item_status>1</order_item_status>
<activity_info_remark_list>null</activity_info_remark_list>
<channel_right_id>3145</channel_right_id>
<ext_info>null</ext_info>
<order_channel>taobao_shangou</order_channel>
<attr_type>2</attr_type>
</order_detail_report_d_t_o>
</result>
<result_success>true</result_success>
<biz_error_desc>入参不能为空</biz_error_desc>
<total_count>100</total_count>
<biz_error_code>201</biz_error_code>
</alibaba_alsc_union_kbcpx_positive_order_get_response>
<error_response>
<code>50</code>
<msg>Remote service error</msg>
<sub_code>isv.invalid-parameter</sub_code>
<sub_msg>非法参数</sub_msg>
</error_response>
| 错误码 | 错误描述 | 解决方案 |
|---|