Qeasy Cloud
Get Started
POSThttps://openapi.jushuitan.com/open/orders/single/queryaccess_token + 签名

Order Query (orders/single/query)

聚水潭 ERP 订单查询接口,按时间窗口分页拉取订单头、明细与金额信息,是订单同步、财务对账取数的核心接口(注意淘系/拼多多订单需走奇门)。

## Overview orders/single/query exposes the Jushuitan ERP order list (Orders > Order Operations > Orders) to external systems. It returns order headers, item lines, amounts and statuses incrementally by modify time, and is the standard extraction point for order sync into WMS/finance/BI. Note: this endpoint does NOT return Taobao/Tmall or Pinduoduo orders due to platform data-security rules — those must go through the Qimen custom interfaces. ### Request essentials 1. POST with Content-Type: application/json. The common parameters app_key, access_token, timestamp, charset and sign are signed together with the business parameters. 2. Business parameters: page_index (1-based), page_size (max 50), start_time/end_time (modify-time window), status and date_type. 3. On code = 0, data.orders carries so_id (online order no), order_date, shop_id, status, items (sku_id, qty, amount), freight and paid_amount; the page object gives the total for pagination. 4. page_size caps at 50 — during promotion peaks, slice windows into 15-30 minutes so a single window never exceeds the paging ceiling and drops orders. ### Reconciliation fields Focus on paid_amount, free_amount (discount), freight and refund_status; join to marketplace statements on so_id. ### Operational tips Persist the last successful end_time as the watermark only after the window has been fully paged — persisting it mid-window silently drops pages on failure. Order amounts arrive as strings in some tenants, so parse defensively. And because sensitive fields of non-Taobao platforms are partially masked, never use the buyer phone number as a join key across systems.

Code examples

curl
curl -X POST "https://openapi.jushuitan.com/open/orders/single/query" \
  -H "Content-Type: application/json" \
  -d '{"app_key":"your_app_key","access_token":"TOKEN","timestamp":1780000000,"charset":"utf-8","sign":"SIGN","page_index":1,"page_size":50,"start_time":"2026-06-01 00:00:00","end_time":"2026-06-01 00:30:00"}'

Error codes

CodeMessageMeaning
0执行成功查询成功
10无效签名签名错误,重新核对签名规则
100access_token 超时刷新 token 后重试