搜索订单 - 蔬东坡开放平台API

请求参数

Query 参数

appid

string

必需

由服务端分配唯一标示appid

timestamp

integer

当前时间戳

必需

示例值:

sign

string

签名参数(32位)

必需

示例值:

notice

string

可选

site_id

string

站点

可选

page

integer

页码

必需

page_size

integer

每页大小

必需

user_id

integer

用户ID

可选

user_code

string

可选

用户编码（13.8.0 及以上版本支持）

sale_id

integer

可选

业务员ID （12.6.0 及以上版本支持）

delivery_date

string

可选

发货日期，如:"2019-05-01"

start_create_time

string

可选

订单创建时间，搜索起始时间，不传默认展示最近7天的数据，最大支持3个月

end_create_time

string

可选

订单创建时间，搜索截止时间，不传默认展示最近7天的数据，最大支持3个月

start_delivery_time

string

可选

开始发货时间，13.8.0及以上版本支持

end_delivery_time

string

可选

结束发货时间，13.8.0及以上版本支持

order_no

string

订单编号

可选

order_id

integer

订单id

可选

status

integer

可选

订单状态,100:待审核,200:待支付,300:待发货,400:待收货,500:已送达,600:已完成,700:关闭

source

integer

可选

订单来源 1 后台 2 微信 3 PC商城 4 商城app 5 分拣APP 6 供应商H5 7 小程序 8 供应商PC 9 开放API 11 支付宝服务号 12 配送APP 13 PC集团 14 支付回调 15 集采平台

user_search

string

订单编号搜索

可选

user_style

string

可选

start_delivery_date

string

可选

系统版本>=15.7.0支持。发货日期区间搜索，开始区间，最大支持3个月，包含当天

示例值:

2019-05-01

end_delivery_date

string

可选

系统版本>=15.7.0支持。发货日期区间搜索，结束区间，最大支持3个月，包含当天

示例值:

2019-06-01

line_id

string

可选

系统版本>=15.8.0支持线路id

driver_id

string

可选

系统版本>=15.8.0支持司机id

is_confirm_delivery

string

可选

系统版本>=15.8.0支持配送状态 Y 已送达 N 未送达

示例代码

Shell

JavaScript

Java

Swift

Go

PHP

Python

HTTP

C

C#

Objective-C

Ruby

OCaml

Dart

R

curl --location -g --request GET 'https://scm.sdongpo.com/cc_thirdparty/openApi/order/query?appid=&timestamp=&sign=&notice&site_id&page&page_size&user_id&user_code&sale_id&delivery_date=&start_create_time&end_create_time&start_delivery_time&end_delivery_time&order_no&order_id&status&source&user_search&user_style&start_delivery_date=2019-05-01&end_delivery_date=2019-06-01&line_id&driver_id&is_confirm_delivery'

返回响应

🟢200成功

application/json

Body

status

integer

必需

data

object

必需

list

array [object {42}]

必需

pageParams

object

必需

message

string | null

必需

示例

{
  "status": 1,
  "data": {
    "list": [
      {
        "order_id": "2271",
        "order_no": "DD24112600004",
        "remark": "",
        "delivery_date": "2024-11-27",
        "receive_name": "钱大妈",
        "account": "15500000000",
        "receive_tel": "15500000000",
        "user_name": "钱大妈客户",
        "user_id": "241",
        "user_code": "204",
        "address_detail": "湖南省长沙市芙蓉区定王台街道中国银行(长沙平和堂支行)湖南平和堂商务楼",
        "dec_price": "0",
        "dec_remark": "",
        "total_price": "130.3200",
        "out_store": "1",
        "actual_total_price": "130.3200",
        "create_time": "2024-11-26 20:25:13",
        "delivery_time_id": "0",
        "status": "600",
        "freight_price": "0.00",
        "pay_price": "0.00",
        "pay_way_text": "货到付款",
        "pay_way": "0",
        "user_return": "0",
        "return_price": "0.0000",
        "return_num": "0",
        "source": "1",
        "source_txt": "后台",
        "delivery_time": "2024-11-26 20:26:00",
        "close_time": null,
        "shop_id": "94",
        "storage_id": "1001",
        "bill_price": "43.52",
        "group_id": "3",
        "sale_id": "0",
        "sale_name": "",
        "site_id": "6",
        "tag_ids": "",
        "update_time": "2024-11-26 20:27:20",
        "version": "4",
        "operate_account": "shudongpo",
        "operate_name": "系统管理员",
        "commodity_list": [
          {
            "id": "4876",
            "parent_id": "396",
            "unit": "包",
            "commodity_code": "JJJ1683",
            "commodity_id": "397",
            "commodity_name": "鸡枞菌1斤",
            "num": "3.00",
            "actual_num": "3.00",
            "convert_amount": "3.00",
            "commodity_tag_text": "",
            "summary": "净重1斤 浮动±0.1",
            "remark": "AAA",
            "unit_price": "2.00",
            "sub_total_price": "6.00",
            "is_price_type": "4",
            "unit_num": "1.00",
            "unit_convert": "N",
            "status": "Y",
            "in_price": "9.0000",
            "original_unit_price": "2.00",
            "protocol_org_price": "3.33",
            "protocol_discount": "60.00",
            "return_amount": "0.00",
            "recv_amount": "3.00",
            "order_delivery_date": "2024-11-27",
            "tax_rate": "0",
            "provider_supervisor": "5",
            "provider_supervisor_code": "caigou_liu_01",
            "provider_supervisor_name": "采购liu",
            "price": "2.00",
            "unit_sell": "包",
            "tax_money": "0.00",
            "none_tax_sub_total_price": "6.00",
            "none_tax_actual_price": "2.00",
            "category_id2": "103",
            "logo": "http://base-image.sdongpo.com/base_1530/upload_pic/909_com_thumb_20240903133803002bcfb766d6a0bbceb86.png",
            "barcode": "",
            "brand": "",
            "is_sorting": "1",
            "is_loading": "0",
            "oc_purchase_in_no": "",
            "order_commodity_tag": "",
            "order_commodity_tag_text": "",
            "order_commodity_tag_code": "",
            "print_index": 0
          }
        ]
      }
    ],
    "pageParams": {
      "page": "1",
      "total_page": 733,
      "page_size": "1",
      "count": "733"
    }
  },
  "message": null
}

🟢200请求失败