v1
latestOpenAPI 3.0.02026-07-26318168886.7 KBSearch Orders
To search orders with specific conditions.<br>利用特殊條件搜尋訂單列表。
Query parameters
Page<br>頁數(第n頁)<br>(Default: 1)
Numbers of Orders per page<br>每頁顯示 n 筆資料<br> (Default: 24, Max: 999)<br>-<br> *If there're many orders, it's suggested to set per_page number to 50<br> 如果訂單眾多,建議per_page至多設定50
訂單號碼 (order_number, merchant_order_number)
顧客 ID
顧客電郵
顧客、收件人名稱 (customer_name, delivery_address.recipient_name, delivery_data.recipient_name)
電話號碼 (customer_phone, delivery_data.recipient_phone)
配送資料追蹤編號
促銷活動 ID
訂單項目 ID
To fetch data for the next page, include the ID of the last order from the previous page. <br> 用於拿取下一分頁資料,請帶入前一分頁的最後一筆訂單 ID <br><br> When fetching orders for the first page, this parameter is not required. <br> 拿取第一頁訂單時,可以不用帶此參數
Support query order fields<br>支援搜尋以下欄位<br> product_name<br> order_number<br> customer_id<br> customer_name<br> customer_phone<br> customer_email<br> delivery_address.recipient_name<br> delivery_data.recipient_name<br> delivery_data.recipient_phone<br> delivery_data.tracking_number<br> promotion_id<br> item_id*
Targeted search fields<br>搜尋欄位<br> Default to 'default'<br> Values allow<br> <br><b>default</b><br> Support query order fields<br>支援搜尋以下欄位<br> product_name<br> order_number<br> customer_id<br> customer_name<br> customer_phone<br> customer_email<br> delivery_address.recipient_name<br> delivery_data.recipient_name<br> delivery_data.recipient_phone<br> delivery_data.tracking_number<br> promotion_id<br> item_id*<br> <br><b>phone_number</b><br> Support query order fields<br>支援搜尋以下欄位<br> customer_phone<br> delivery_data.recipient_phone<br> <br><b>order_number</b><br> Support query order fields<br>支援搜尋以下欄位<br> order_number<br> merchant_order_number<br> <br><b>customize_customer_info</b><br> Support query order fields<br>支援搜尋以下欄位<br> customer_info.value<br> <br><b>social_user_name</b><br> Support query order fields<br>支援搜尋以下欄位<br> social_user_name<br>
Filter orders by those shipped before specific time.<br> 取得 shipped_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those shipped after specific time.<br> 取得 shipped_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those arrived before specific time.<br> 取得 arrived_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those arrived after specific time.<br> 取得 arrived_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those collected before specific time.<br> 取得 collected_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those collected after specific time.<br> 取得 collected_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those returned before specific time.<br> 取得 returned_at 小於指定時間的訂單(包含指定時間)<br>-<br>should use UTC time<br><br> Note: Will only show returned status updated after 2019-06-01<br> 在2019/06/01之後產生的退貨狀態才能被搜尋出來
Filter orders by those returned after specific time.<br> 取得 returned_at 大於指定時間的訂單(包含指定時間)<br>-<br>should use UTC time<br><br> Note: Will only show returned status updated after 2019-06-01<br>在2019/06/01之後產生的退貨狀態才能被搜尋出來
Filter orders by those cancelled before specific time.<br> 取得 cancelled_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those cancelled after specific time.<br> 取得 cancelled_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those paid before specific time.<br> 取得 paid_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those paid after specific time.<br> 取得 paid_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those updated before specific time.<br> 取得 updated_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those updated after specific time.<br> 取得 updated_at 大於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Status<br>訂單狀態<br>-<br>Status allow<br> pending 處理中<br>removed 已刪除<br> confirmed 已確認<br>completed 已完成<br> cancelled 已取消
Statuses<br>多個訂單狀態<br>-<br>Status allow<br> pending 處理中<br>removed 已刪除<br> confirmed 已確認<br>completed 已完成<br> cancelled 已取消
Payment Method ID<br>付款方式ID
Payment Status<br>付款狀態<br>-<br>Payment status allows<br>pending 未付款(包含 temp 暫存狀態)<br> failed 付款失敗<br>expired 超過付款時間<br> completed 已付款<br>refunding 退款中<br> refunded 已退款<br>partially refunded 已部分退款
Delivery Option ID<br>物流方式ID
Delivery Status<br>物流狀態 <br>-<br> Delivery status allows<br> pending 備貨中<br> shipping 發貨中<br> shipped 已發貨<br> arrived 已到達<br> collected 已取貨<br> returned 已退貨<br> * returning 退貨中
Delivery Statuses<br>多個物流狀態 <br>-<br> Delivery status allows<br> pending 備貨中<br> shipping 發貨中<br> shipped 已發貨<br> arrived 已到達<br> collected 已取貨<br> returned 已退貨<br> returning 退貨中
Keys allow to search:<br>* affiliate_source(String)訂單來源<br>(第三方夥伴適用)
Filter orders by those updated before specific time.<br> 取得 created_at 小於指定時間的訂單(包含指定時間)<br>-<br> *should use UTC time
Filter orders by those created after specific time.<br> 取得 created_at 大於指定時間的訂單(包含指定時間)<br>-<br>*should use UTC time
Filter orders by those created by specific channel.<br> 取得特定由渠道建立的訂單
Order responses items by created time in ascending/descending order.<br> 訂單按訂單創造日期順序或倒序排序。<br> If sort_by is passed, Order the record by the sort_by value in asc/desc order.<br> 如果傳入sort_by,則按照sort_by的參數順序或倒序排序。
Sort responses items by created_at or total.<br> 訂單按訂單創造日期或商品總價排序。 If order_by is not passed, by default showing records in descending order.<br> 如果沒有傳入order_by, 則按倒序排序。
Provide additional attributes in the response<br>結果添加哪些參數
Response
OK