获取订单列表
根据条件检索满足要求的订单列表，支持下单时间和更新时间排序
一、请求参数
请求URL:
公共参数
| 参数名称 | 参数类型 | 是否必须 | 示例值 | 参数描述 |
|---|---|---|---|---|
| appid | String | 是 | 合作伙伴AppId | |
| timestamp | String | 是 | 1657525936 | 当前Unix时间戳，秒 |
| seller_nick | String | 是 | oms38173182 | 抖店的账号，对应蜂巢授权返回doudianseller字段 |
| sign | String | 是 |
业务参数
| 参数名称 | 参数类型 | 是否必须 | 示例值 | 参数描述 |
|---|---|---|---|---|
| product | String | 否 | 3473196049974326153 | 商品，number型代表商品ID，其它代表商品名称 |
| b_type | Int64 | 否 | 2 | 【下单端】 0、站外 1、火山 2、抖音 3、头条 4、西瓜 5、微信 6、值点app 7、头条lite 8、懂车帝 9、皮皮虾 11、抖音极速版 12、TikTok 13、musically 14、穿山甲 15、火山极速版 16、服务市场 26、番茄小说 27、UG教育营销电商平台 28、Jumanji 29、电商SDK |
| after_sale_status_desc | String | 否 | refund_success | 售后状态：all-全部，in_aftersale-售后中，refund-退款中，refund_success-退款成功，refund_fail-退款失败，exchange_success-换货成功 aftersale_close-售后关闭 |
| tracking_no | String | 否 | 435435 | 物流单号 |
| presell_type | Int64 | 否 | 1 | 预售类型：1 全款预售 |
| order_type | Int64 | 否 | 1 | 【订单类型】 0、普通订单 2、虚拟商品订单 4、电子券（poi核销） 5、三方核销 |
| create_time_start | Int64 | 否 | 1617355413 | 下单时间：开始，秒级时间戳 |
| create_time_end | Int64 | 否 | 1617355413 | 下单时间：截止，秒级时间戳 |
| abnormal_order | Int64 | 否 | 1 | 异常订单，1-异常取消，2-风控审核中 |
| trade_type | Int64 | 否 | 1 | 【交易类型】 0、普通 1、拼团 2、定金预售 3、订金找贷 4、拍卖 5、0元单 6、回收 7、寄卖 10、样品 |
| + combine_status | List | 否 | - | 状态组合查询，直接输入状态码（只支持一个元素） |
| —- order_status | String | 否 | 1 | 订单状态，”,”分隔多个状态 。 1 待确认/待支付-订单创建完毕;105-已支付; 2-备货中； 101-部分发货; 3-已发货（全部发货）;4- 已取消;5 已完成（已收货）; |
| —- main_status | String | 否 | 103 | 主流程状态，”,”分隔多个状态。1 ：待确认/待支付（订单创建完毕）103： 部分支付， 105 已支付 ， 2 ：备货中，101： 部分发货，3： 已发货（全部发货），4： 已取消，5： 已完成（已收货），21： 发货前退款完结，22： 发货后退款完结，39： 收货后退款完结 |
| update_time_start | Int64 | 否 | 1617355413 | 更新时间：开始 |
| update_time_end | Int64 | 否 | 1617355413 | 更新时间：截止 |
| size | Int64 | 是 | 20 | 单页大小，限制100以内 |
| page | Int64 | 是 | 0 | 页码，0页开始 |
| order_by | String | 否 | create_time | 排序条件(create_time 订单创建时间；update_time 订单更新时间；默认create_time；) |
| order_asc | Bool | 否 | false | 排序类型，小到大或大到小，默认大到小 |
二、请求示例代码
Java
@Test public void GetOrderList() throws Exception { Map<String, Object> data = new HashMap<String, Object>(); data.put("appid", Config.AppId); Long timestamp = System.currentTimeMillis() / 1000; data.put("timestamp", timestamp.toString()); data.put("seller_nick", Config.DDSellerNick); long start = System.currentTimeMillis() / 1000 - 3600 * 24 * 7 ; long end = System.currentTimeMillis() / 1000; data.put("create_time_start", String.valueOf(start)); data.put("create_time_end", String.valueOf(end));// data.put("combine_status", "[{\"main_status\":\"1,2,3\",\"order_status\":\"1,2,3\"}]");// data.put("combine_status", "[{\"order_status\":\"3,5\"}]");// data.put("combine_status", "[{\"order_status\":\"3\"}]"); data.put("is_searchable", true); data.put("page", "0"); data.put("size", "10"); data.put("sign", Sign(data,Config.AppSecret)); // 调用服务API String resp = doHttpRequest(Config.DDTradeListUrl, data); System.out.println(resp); }三、返回结果
{ "code": 0, "message": "ok", "data": { "page": 0, "total": 11, "size": 10, "shop_order_list": [ { "shop_id": 2726558, "shop_name": "下巴服饰网店", "open_id": "", "open_address_id": "#aMZjXO9QJ5g12E9qDm+ab3CCSeYaceQR0lzzkLZ5M227Ii/0clehXUZblxXiulhUgDuyi7nkX9o29dgKyoqvfHmwePwhQ8Ac3gLyc9f221S2yjCDja0oidr3PZst+5rc2rVpMgUUrfY5", "order_id": "4953687499635908148", "order_level": 2, "biz": 2, "biz_desc": "小店", "order_type": 0, "order_type_desc": "普通订单", "trade_type": 0, "trade_type_desc": "普通", "order_status": 3, "order_status_desc": "已发货", "main_status": 3, "main_status_desc": "已全部发货", "pay_time": 1657465335, "order_expire_time": 1800, "finish_time": 0, "create_time": 1657465325, "update_time": 1657510688, "cancel_reason": "", "buyer_words": "", "seller_words": "", "b_type": 2, "b_type_desc": "抖音", "sub_b_type": 3, "sub_b_type_desc": "H5", "app_id": 1128, "pay_type": 2, "channel_payment_no": "2022071022001490091452151340", "order_amount": 35000, "pay_amount": 35000, "post_amount": 0, "post_insurance_amount": 0, "modify_amount": 0, "modify_post_amount": 0, "promotion_amount": 0, "promotion_shop_amount": 0, "promotion_platform_amount": 0, "shop_cost_amount": 0, "platform_cost_amount": 0, "promotion_talent_amount": 0, "promotion_pay_amount": 0, "post_tel": "13*******48", "post_receiver": "石*华", "post_addr": { "province": { "name": "重庆市", "id": "50" }, "city": { "name": "重庆市", "id": "500000" }, "town": { "name": "江北区", "id": "500105" }, "street": { "name": "观音桥街道", "id": "500105006" }, "detail": "拓展大厦多贝尔酒店" }, "exp_ship_time": 1657638135, "ship_time": 1657510688, "logistics_info": [ { "tracking_no": "SF1154705663665", "company": "shunfeng", "ship_time": 1657510688, "delivery_id": "7118954192512893220", "company_name": "顺丰速运", "product_info": [ { "product_name": "JINXIABA/金下巴金下巴170克140支双面全棉t恤衫", "price": 35000, "outer_sku_id": "", "sku_id": 1730949977135116, "sku_specs": [ { "name": "款式", "value": "白色" }, { "name": "尺码", "value": "52（136-152）斤" } ], "product_count": 1, "product_id": 3418638597652387519, "sku_order_id": "4953687499635908148", "product_id_str": "3418638597652387519" } ] } ], "sku_order_list": [ { "order_id": "4953687499635908148", "parent_order_id": "4953687499635908148", "order_level": 3, "biz": 2, "biz_desc": "小店", "order_type": 0, "order_type_desc": "普通订单", "trade_type": 0, "trade_type_desc": "普通", "order_status": 3, "order_status_desc": "已发货", "main_status": 3, "main_status_desc": "已全部发货", "pay_time": 1657465335, "order_expire_time": 1800, "finish_time": 0, "create_time": 1657465325, "update_time": 1657510688, "cancel_reason": "", "b_type": 2, "b_type_desc": "抖音", "sub_b_type": 3, "sub_b_type_desc": "H5", "send_pay": 0, "send_pay_desc": "-", "author_id": 2695642396502808, "author_name": "金下巴定制", "theme_type": "1", "theme_type_desc": "直播间", "app_id": 1128, "room_id": 0, "content_id": "7117459857967533345", "video_id": "7117459857967533345", "origin_id": "7117459857967533345_3418638597652387519", "cid": 0, "c_biz": 8, "c_biz_desc": "小店自卖", "page_id": 0, "pay_type": 2, "channel_payment_no": "2022071022001490091452151340", "order_amount": 35000, "pay_amount": 35000, "post_insurance_amount": 0, "modify_amount": 0, "modify_post_amount": 0, "promotion_amount": 0, "promotion_shop_amount": 0, "promotion_platform_amount": 0, "shop_cost_amount": 0, "platform_cost_amount": 0, "promotion_talent_amount": 0, "promotion_pay_amount": 0, "code": "", "exp_ship_time": 1657638135, "ship_time": 1657510688, "logistics_receipt_time": 0, "confirm_receipt_time": 0, "goods_type": 0, "product_id": 3418638597652387519, "sku_id": 1730949977135116, "spec": [ { "name": "款式", "value": "白色" }, { "name": "尺码", "value": "52（136-152）斤" } ], "first_cid": 20009, "second_cid": 20172, "third_cid": 0, "fourth_cid": 0, "out_sku_id": "", "supplier_id": "", "out_product_id": "0", "warehouse_ids": [], "out_warehouse_ids": [], "inventory_type": "", "inventory_type_desc": "", "reduce_stock_type": 1, "reduce_stock_type_desc": "下单减库存", "origin_amount": 35000, "has_tax": false, "item_num": 1, "sum_amount": 35000, "source_platform": "", "product_pic": "https://p3-aio.ecombdimg.com/obj/ecom-shop-material/v1_jhlMqaP_70933813272312547920558_30ad87f06bbdb8f942936b7e3e0942e1_sx_1172931_www828-828", "is_comment": 0, "product_name": "JINXIABA/金下巴金下巴170克140支双面全棉t恤衫", "inventory_list": [ { "warehouse_id": "", "out_warehouse_id": "", "inventory_type": 1, "inventory_type_desc": "普通库存", "count": 1, "warehouse_type": 0 } ], "post_amount": 0, "pre_sale_type": 0, "after_sale_info": { "after_sale_status": 0, "after_sale_type": 0, "refund_status": 0 }, "promotion_redpack_amount": 0, "promotion_redpack_platform_amount": 0, "promotion_redpack_talent_amount": 0, "receive_type": 0, "need_serial_number": false, "ad_env_type": "", "sku_order_tag_ui": [ { "key": "buy_at_ease", "text": "安心购", "hover_text": "", "tag_type": "", "help_doc": "https://school.jinritemai.com/doudian/web/article/114834", "sort": 0, "extra": "" }, { "key": "pay_for_bad_label", "text": "坏损包退", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/aHKK3UGTKEHB", "sort": 0, "extra": "" }, { "key": "supply_7day_return_label", "text": "7天", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/101835?from=shop_article", "sort": 0, "extra": "" }, { "key": "cert_insurance_label", "text": "正品保障", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/113754?rank=0\u0026fromPage=search_result\u0026searchInfo=7784423912345834344%3A0%3A0\u0026query=%E6%AD%A3%E5%93%81%E4%BF%9D%E9%9A%9C", "sort": 0, "extra": "" }, { "key": "c_biz_self_sell", "text": "小店自卖", "hover_text": "达人通过「我的店铺」、或通过链接添加人店一体店铺商品（无官方店铺情况下，添加渠道号店铺商品也算）到橱窗、视频、直播，产生的订单为自卖订单", "tag_type": "grey", "help_doc": "", "sort": 0, "extra": "" } ], "product_id_str": "3418638597652387519", "appointment_ship_time": 0, "room_id_str": "0", "given_product_type": "", "master_sku_order_id": "", "card_voucher": { "valid_days": 0, "valid_start": 0, "valid_end": 0 }, "bundle_sku_info": [], "account_list": { "account_info": null }, "sku_customization_info": [], "author_cost_amount": 0, "only_platform_cost_amount": 0 } ], "seller_remark_stars": 0, "order_phase_list": [], "doudian_open_id": "1@#jGJ0S3pH0W50TbLg8sAixB6ZYef8gJMTjljWC1ojzQY5SdrsRScUR2CaQ9Eu5pdF9iZLaRAH", "serial_number_list": [], "promotion_redpack_amount": 0, "promotion_redpack_platform_amount": 0, "promotion_redpack_talent_amount": 0, "user_id_info": null, "appointment_ship_time": 0, "d_car_shop_biz_data": { "poi_id": "", "poi_name": "", "poi_addr": "", "poi_tel": "", "coupon_right": null, "poi_pname": "", "poi_city_name": "", "poi_adname": "" }, "shop_order_tag_ui": [], "total_promotion_amount": 0, "post_origin_amount": 0, "post_promotion_amount": 0, "user_tag_ui": [ { "key": "user_profile_buy_frequency", "text": "高频购买" }, { "key": "user_profile_shop_customer_type", "text": "店铺新客" } ], "author_cost_amount": 0, "only_platform_cost_amount": 0 }, { "shop_id": 2726558, "shop_name": "下巴服饰网店", "open_id": "", "order_id": "4953319395199250169", "order_level": 2, "biz": 2, "biz_desc": "小店", "order_type": 0, "order_type_desc": "普通订单", "trade_type": 0, "trade_type_desc": "普通", "order_status": 3, "order_status_desc": "已发货", "main_status": 3, "main_status_desc": "已全部发货", "pay_time": 1657379620, "order_expire_time": 1800, "finish_time": 0, "create_time": 1657379610, "update_time": 1657432535, "cancel_reason": "", "buyer_words": "", "seller_words": "", "b_type": 2, "b_type_desc": "抖音", "sub_b_type": 3, "sub_b_type_desc": "H5", "app_id": 1128, "pay_type": 1, "channel_payment_no": "4307001112202207096363445459", "order_amount": 35000, "pay_amount": 35000, "post_amount": 0, "post_insurance_amount": 0, "modify_amount": 0, "modify_post_amount": 0, "promotion_amount": 0, "promotion_shop_amount": 0, "promotion_platform_amount": 0, "shop_cost_amount": 0, "platform_cost_amount": 0, "promotion_talent_amount": 0, "promotion_pay_amount": 0, "post_tel": "13*******70",
"post_receiver": "陈*强",
"post_addr": { "province": { "name": "广东省", "id": "44" }, "city": { "name": "河源市", "id": "441600" }, "town": { "name": "源城区", "id": "441602" }, "street": { "name": "东埔街道", "id": "441602003" }, "detail": "明鸿路万绿桃源*期"
}, "exp_ship_time": 1657552420, "ship_time": 1657432534, "logistics_info": [ { "tracking_no": "YT6614337268297", "company": "yuantong", "ship_time": 1657432534, "delivery_id": "7118618523932393759", "company_name": "圆通快递", "product_info": [ { "product_name": "JINXIABA/金下巴金下巴170克140支双面全棉t恤衫", "price": 35000, "outer_sku_id": "", "sku_id": 1730949974633500, "sku_specs": [ { "name": "款式", "value": "黑色" }, { "name": "尺码", "value": "48（100-120）斤" } ], "product_count": 1, "product_id": 3418638597652387519, "sku_order_id": "4953319395199250169", "product_id_str": "3418638597652387519" } ] } ], "sku_order_list": [ { "order_id": "4953319395199250169", "parent_order_id": "4953319395199250169", "order_level": 3, "biz": 2, "biz_desc": "小店", "order_type": 0, "order_type_desc": "普通订单", "trade_type": 0, "trade_type_desc": "普通", "order_status": 3, "order_status_desc": "已发货", "main_status": 3, "main_status_desc": "已全部发货", "pay_time": 1657379620, "order_expire_time": 1800, "finish_time": 0, "create_time": 1657379610, "update_time": 1657432534, "cancel_reason": "", "b_type": 2, "b_type_desc": "抖音", "sub_b_type": 3, "sub_b_type_desc": "H5", "send_pay": 0, "send_pay_desc": "-", "author_id": 2695642396502808, "author_name": "金下巴定制", "theme_type": "0", "theme_type_desc": "-", "app_id": 1128, "room_id": 0, "content_id": "7094205032354106663", "video_id": "7094205032354106663", "origin_id": "7094205032354106663_3418638597652387519", "cid": 0, "c_biz": 8, "c_biz_desc": "小店自卖", "page_id": 0, "pay_type": 1, "channel_payment_no": "4307001112202207096363445459", "order_amount": 35000, "pay_amount": 35000, "post_insurance_amount": 0, "modify_amount": 0, "modify_post_amount": 0, "promotion_amount": 0, "promotion_shop_amount": 0, "promotion_platform_amount": 0, "shop_cost_amount": 0, "platform_cost_amount": 0, "promotion_talent_amount": 0, "promotion_pay_amount": 0, "code": "", "exp_ship_time": 1657552420, "ship_time": 1657432534, "logistics_receipt_time": 0, "confirm_receipt_time": 0, "goods_type": 0, "product_id": 3418638597652387519, "sku_id": 1730949974633500, "spec": [ { "name": "款式", "value": "黑色" }, { "name": "尺码", "value": "48（100-120）斤" } ], "first_cid": 20009, "second_cid": 20172, "third_cid": 0, "fourth_cid": 0, "out_sku_id": "", "supplier_id": "", "out_product_id": "0", "warehouse_ids": [], "out_warehouse_ids": [], "inventory_type": "", "inventory_type_desc": "", "reduce_stock_type": 1, "reduce_stock_type_desc": "下单减库存", "origin_amount": 35000, "has_tax": false, "item_num": 1, "sum_amount": 35000, "source_platform": "", "product_pic": "https://p9-aio.ecombdimg.com/obj/ecom-shop-material/v1_jhlMqaP_70933814210537556820558_fc7b882208133261a6f2e8e7ffd8fba5_sx_1175756_www828-828", "is_comment": 0, "product_name": "JINXIABA/金下巴金下巴170克140支双面全棉t恤衫", "inventory_list": [ { "warehouse_id": "", "out_warehouse_id": "", "inventory_type": 1, "inventory_type_desc": "普通库存", "count": 1, "warehouse_type": 0 } ], "post_amount": 0, "pre_sale_type": 0, "after_sale_info": { "after_sale_status": 0, "after_sale_type": 0, "refund_status": 0 }, "promotion_redpack_amount": 0, "promotion_redpack_platform_amount": 0, "promotion_redpack_talent_amount": 0, "receive_type": 0, "need_serial_number": false, "ad_env_type": "", "sku_order_tag_ui": [ { "key": "buy_at_ease", "text": "安心购", "hover_text": "", "tag_type": "", "help_doc": "https://school.jinritemai.com/doudian/web/article/114834", "sort": 0, "extra": "" }, { "key": "pay_for_bad_label", "text": "坏损包退", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/aHKK3UGTKEHB", "sort": 0, "extra": "" }, { "key": "supply_7day_return_label", "text": "7天", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/101835?from=shop_article", "sort": 0, "extra": "" }, { "key": "cert_insurance_label", "text": "正品保障", "hover_text": "", "tag_type": "khaki", "help_doc": "https://school.jinritemai.com/doudian/web/article/113754?rank=0\u0026fromPage=search_result\u0026searchInfo=7784423912345834344%3A0%3A0\u0026query=%E6%AD%A3%E5%93%81%E4%BF%9D%E9%9A%9C", "sort": 0, "extra": "" }, { "key": "c_biz_self_sell", "text": "小店自卖", "hover_text": "达人通过「我的店铺」、或通过链接添加人店一体店铺商品（无官方店铺情况下，添加渠道号店铺商品也算）到橱窗、视频、直播，产生的订单为自卖订单", "tag_type": "grey", "help_doc": "", "sort": 0, "extra": "" } ], "product_id_str": "3418638597652387519", "appointment_ship_time": 0, "room_id_str": "0", "given_product_type": "", "master_sku_order_id": "", "card_voucher": { "valid_days": 0, "valid_start": 0, "valid_end": 0 }, "bundle_sku_info": [], "account_list": { "account_info": null }, "sku_customization_info": [], "author_cost_amount": 0, "only_platform_cost_amount": 0 } ], "seller_remark_stars": 0, "order_phase_list": [], "doudian_open_id": "1@#xyW+FHIfnJnu7JgsdbsHS+AohU7OItPKk3PJLi9WOGzfE+hOBmyfZg2hTEF432X4w/KNClO+", "serial_number_list": [], "promotion_redpack_amount": 0, "promotion_redpack_platform_amount": 0, "promotion_redpack_talent_amount": 0, "user_id_info": null, "appointment_ship_time": 0, "d_car_shop_biz_data": { "poi_id": "", "poi_name": "", "poi_addr": "", "poi_tel": "", "coupon_right": null, "poi_pname": "", "poi_city_name": "", "poi_adname": "" }, "shop_order_tag_ui": [], "total_promotion_amount": 0, "post_origin_amount": 0, "post_promotion_amount": 0, "user_tag_ui": [ { "key": "user_profile_buy_frequency", "text": "服务优先" }, { "key": "user_profile_shop_customer_type", "text": "店铺老客" } ], "author_cost_amount": 0, "only_platform_cost_amount": 0 }
] }, "trace_id": ""}说明： code为0表示成功，非0为失败，message会包含失败原因。 data字段包含订单列表的数据，返回订单的字段说明参见订单列表字段文档