Search Orders
Function
To search orders with specific conditions.
利用特殊條件搜尋訂單列表。
URL
GET <<api_domain>>/v1/orders/search
Request parameters
| Parameter | Type | Description | Example |
|---|---|---|---|
| previous_id | String | 前一分頁的最後一筆訂單 ID，用於拿取下一分頁資料 拿取第一頁訂單時，可以不用帶此參數 | previous_id=6466f658328ad9616db2984e |
| per_page | Integer | Numbers of Orders per page 每頁顯示 n 筆資料 (Default: 24, Max: 999) - *If there're many orders, it's suggested to set per_page number to 50 如果訂單眾多，建議per_page至多設定50 | ruby per_page=10 |
| page | Integer | Page 頁數（第n頁） (Default: 1) 當使用 Parameter previous_id 時，可以移除 Parameter page | ruby page=1 |
| query | String | Support query order fields 支援搜尋以下欄位 product_name ordernumber customerid customername customerphone customeremail deliveryaddress.recipient_name deliverydata.recipient_name deliverydata.recipient_phone deliverydata.tracking_number promotion_id item_id | ruby query=郭美玉 |
| shipped_before | DateTime | Filter orders by those shipped before specific time. 取得 shipped_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby shipped_before=2018-01-01 00:00:00 |
| shipped_after | DateTime | Filter orders by those shipped after specific time. 取得 shipped_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby shipped_after=2018-01-01 00:00:00 |
| arrived_before | DateTime | Filter orders by those arrived before specific time. 取得 arrived_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby arrived_before=2018-01-01 00:00:00 |
| arrived_after | DateTime | Filter orders by those arrived after specific time. 取得 arrived_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby arrived_after=2018-01-01 00:00:00 |
| collected_before | DateTime | Filter orders by those collected before specific time. 取得 collected_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby collected_before=2018-01-01 00:00:00 |
| collected_after | DateTime | Filter orders by those collected after specific time. 取得 collected_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby collected_after=2018-01-01 00:00:00 |
| returned_before | DateTime | Filter orders by those returned before specific time. 取得 returned_at 小於指定時間的訂單(包含指定時間) - should use UTC timeNote: Will only show returned status updated after 2019-06-01 在2019/06/01之後產生的退貨狀態才能被搜尋出來 | ruby returned_before=2018-01-01 00:00:00 |
| returned_after | DateTime | Filter orders by those returned after specific time. 取得 returned_at 大於指定時間的訂單(包含指定時間) - should use UTC timeNote: Will only show returned status updated after 2019-06-01 在2019/06/01之後產生的退貨狀態才能被搜尋出來 | ruby returned_after=2018-01-01 00:00:00 |
| cancelled_before | DateTime | Filter orders by those cancelled before specific time. 取得 cancelled_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby cancelled_before=2018-01-01 00:00:00 |
| cancelled_after | DateTime | Filter orders by those cancelled after specific time. 取得 cancelled_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby cancelled_after=2018-01-01 00:00:00 |
| paid_before | DateTime | Filter orders by those paid before specific time. 取得 paid_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby paid_before=2018-01-01 00:00:00 |
| paid_after | DateTime | Filter orders by those paid after specific time. 取得 paid_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby paid_after=2018-01-01 00:00:00 |
| updated_before | DateTime | Filter orders by those updated before specific time. 取得 updated_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby updated_before=2018-01-01 00:00:00 |
| updated_after | DateTime | Filter orders by those updated after specific time. 取得 updated_at 大於指定時間的訂單(包含指定時間) - *should use UTC time Note: 當 order_delivery 資料更新時，並不會更新 order 本身的 updated_at，因此用這個參數會撈不出例如過去一小時送貨狀態有更新的訂單 (此情境建議訂閱 order_delivery/update webhook) | ruby updated_after=2018-01-01 00:00:00 |
| status | String | Order Status 訂單狀態 - Status allow pending 處理中 confirmed 已確認 completed 已完成 cancelled 已取消 | ruby status=pending status=confirmed status=completed status=cancelled |
| statuses | Array | Order Statuses 搜尋多筆訂單狀態 - Status allow pending 處理中 confirmed 已確認 completed 已完成 cancelled 已取消 | statuses[]=confirmed&statuses[]=completed |
| payment_id | String | Payment Method ID 付款方式ID | ruby payment_id=5de89078e11e3f001bf6ee76 |
| payment_status | String | Payment Status 付款狀態 - Payment status allows pending 未付款(包含 temp 暫存狀態) failed 付款失敗 expired 超過付款時間 completed 已付款 refunding 退款中 refunded 已退款 partially_refunded 已部分退款 | ruby payment_status=pending payment_status=failed payment_status=expired payment_status=completed payment_status=refunding payment_status=refunded payment_status=partially_refunded |
| delivery_address | Order DeliveryAddress | Information of Delivery 收件人基本資訊 | Please check the link on the left |
| delivery_option_id | String | Delivery Option ID 物流方式ID | ruby delivery_option_id=5df83d7322e73b0033167c99 |
| delivery_option_type | String | Delivery Type 送貨類型 - Delivery Type allows post 宅配 pickup 自取 custom 自定 store_pickup 店配 | ruby delivery_option_type=post |
| delivery_status | String | Delivery Status 物流狀態 - Delivery status allows pending 備貨中 shipping 發貨中 shipped 已發貨 arrived 已到達 collected 已取貨 returned 已退貨 returning 退貨中 | ruby delivery_status=pending delivery_status=shipping delivery_status=shipped delivery_status=arrived delivery_status=collected delivery_status=returned delivery_status=returning |
| delivery_statuses | Array | Delivery Status 搜尋多筆物流狀態 - Delivery status allows pending 備貨中 shipping 發貨中 shipped 已發貨 arrived 已到達 collected 已取貨 returned 已退貨 returning 退貨中 | delivery_statuses[]=shipped&delivery_statuses[]=arrived |
| affiliate_data (第三方夥伴適用) | Hash | Keys allow to search: affiliate_source(String)訂單來源 | |
| created_before | DateTime | Filter orders by those created before specific time. 取得 created_at 小於指定時間的訂單(包含指定時間) - *should use UTC time | ruby created_after=2018-01-01 00:00:00 |
| created_after | DateTime | Filter orders by those created after specific time. 取得 created_at 大於指定時間的訂單(包含指定時間) - *should use UTC time | ruby created_after=2018-01-01 00:00:00 |
| created_by | String | pos, visible_channels, shop, admin | |
| order_number | String | 訂單號碼 (order_number, merchant_order_number) | order_number=20230801081640482 |
| customer_id | String | 顧客 ID | customer_id=6466f657328ad9616db29844 |
| customer_email | String | 顧客電郵 | [email protected] |
| name | String | 顧客、收件人名稱 (customer_name, delivery_address.recipient_name, delivery_data.recipient_name) | name=郭美玉 |
| phone_number | String | 電話號碼 (customer_phone, delivery_data.recipient_phone) | phone_number=0900123000 |
| delivery_data_tracking_number | String | 配送資料追蹤編號 | delivery_data_tracking_number=A0123456789 |
| promotion_id | String | 促銷活動 ID | promotion_id=6466f658328ad9616db2984f |
| item_id | String | 訂單項目 ID | item_id=6466f658328ad9616db2984e |
| delivery_data | Hash | Keys allow to search: scheduled_delivery_date_before(DateTime)在此到貨日期之前 scheduled_delivery_date_after(DateTime)在此到貨日期之後 | delivery_data[scheduled_delivery_date_before]=2024-09-24T00:00:00.000Z |
Note
Please note the following pagination limitations when using this API:
- The request will fail if
page*per_pageexceeds 10,000.- Example: If
per_page= 50, the maximum value forpageshould be 200. Exceeding this value will result in an error.使用此 API 時，請注意以下分頁限制：
- 當
page*per_page大於 10,000 時，請求將會失敗。- 範例：如果
per_page= 50，page最大值應為 200，超過此值請求將會失敗。
Request example
curl -X GET \
'<<api_domain>>/v1/orders/search?status=pending&page=1&per_page=100&payment_status=completed&delivery_status=pending&affiliate_data[affiliate_source]=source&payment_id=5a79605ce388090d10000011&delivery_option_id=5a7ab4a7e38809548f000003' \
-H 'Accept: application/json' \
-H 'Authorization: Bearar access_token'
Response fields
| Field | Type | Description | Example |
|---|---|---|---|
| items | Orders | Order Information 訂單資訊 | Please check the link on the left |
| pagination | Pagination | Pagination 頁面資訊 | Please check the link on the left |
Response Example
JSON sample
{
"items": [
{
"id": "5f450eace388093f603a3b95",
"order_number": "20200825131420941",
"status": "pending",
"order_remarks": "",
"order_payment": {
"payment_method_id": "5f360b7ee388097ed68f1491",
"payment_type": "two_checkout",
"name_translations": {
"en": "Credit Card",
"zh-hant": "信用卡"
},
"status": "pending",
"payment_fee": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"paid_at": null,
"updated_at": "2020-08-25T13:14:21.121+00:00",
"created_at": "2020-08-25T13:14:20.616+00:00",
"payment_data": {},
"last_four_digits": ""
},
"order_delivery": {
"delivery_option_id": "5eaf957fe3880941178912fa",
"platform": "custom",
"status": "pending",
"delivery_status": "pending",
"name_translations": {
"en": "",
"zh-hant": "郵寄"
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"shipped_at": null,
"arrived_at": null,
"collected_at": null,
"returned_at": null,
"remark": null,
"request_accepted_at": null,
"request_authorized_at": null,
"request_submitted_at": null,
"requested_fmt_at": null,
"require_expired_upload": false,
"require_storeclosed_upload": false,
"return_order_id": null,
"store_closed_at": null,
"storeclosed_upload_at": null
},
"delivery_address": {
"country_code": "SG",
"country": "Singapore",
"city": null,
"state": null,
"postcode": null,
"address_1": null,
"address_2": null,
"recipient_name": "Grant Fong",
"recipient_phone": "93863839",
"remarks": null
},
"delivery_data": {
"hk_sfplus_home_region": null,
"location_code": null,
"location_name": null,
"name_translations": null,
"store_address": null,
"url": null,
"tracking_number": "",
"scheduled_delivery_date": null,
"time_slot_key": null,
"time_slot_translations": {}
},
"customer_id": "5f450eaa01afcd3b6e5c5b74",
"customer_name": "Grant Fong",
"customer_email": "[email protected]",
"customer_phone": "93863839",
"customer_info": {},
"currency_iso": "TWD",
"subtotal": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"order_discount": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"user_credit": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total_tax_fee": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"invoice": {
"tax_id": "",
"mailing_address": "",
"invoice_type": "",
"buyer_name": "",
"carrier_type": "",
"carrier_number": "",
"n_p_o_b_a_n": "",
"invoice_tax_type": "",
"invoice_number": "",
"invoice_status": "",
"invoice_date": null,
"invoice_cancelled_at": null
},
"subtotal_items": [
{
"id": "5f450eace388093f603a3b98",
"item_type": "Product",
"item_data": {
"cart_item_id": "5f450e7ee388093f603a3b82",
"promotion_id": null,
"parent_item_ids": [],
"triggering_item_id": "",
"order_promotion_items": {
"order_discounted_price": "5f450eace388093f603a3b94"
},
"order_discounted_price": {
"cents": 13.0,
"currency_iso": "TWD"
},
"has_exclude_promotion_tag": false,
"variation_data": {
"_id": "5f3f8653e388096adcb65c4d",
"barcode_type": "Code 128",
"cost": {
"cents": 5.0,
"currency_iso": "TWD"
},
"created_at": "2020-08-21T08:31:15.929Z",
"feed_variations": null,
"fields": [
{
"name_translations": {
"en": "green",
"zh-hant": ""
}
},
{
"name_translations": {
"en": "c1",
"zh-hant": ""
}
}
],
"fields_translations": {
"en": [
"green",
"c1"
],
"zh-hant": [
"",
""
]
},
"gtin": null,
"key": "5f3f8653001e1200133a84a7",
"location_id": null,
"max_order_quantity": 10,
"media_id": null,
"member_price": {
"cents": 0.0,
"currency_iso": "TWD"
},
"mpn": null,
"price": {
"cents": 30.0,
"currency_iso": "TWD"
},
"price_sale": {
"cents": 13.0,
"currency_iso": "TWD"
},
"quantity": 1,
"root_product_variation_id": null,
"sku": "2dd235",
"stock_ids": null,
"unlimited_quantity": null,
"updated_at": "2020-08-25T03:14:47.888Z",
"variant_option_ids": [
"5f3f8653e388096adcb65c51",
"5f3f8653e388096adcb65c52"
],
"wapos_id": null,
"weight": 23.0,
"media_hash": {}
}
},
"item_id": "5f3a5188e38809a2d1388bdd",
"item_variation_id": "5f3f8653e388096adcb65c4d",
"item_variation_key": "5f3f8653001e1200133a84a7",
"item_price": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"price": {
"cents": 30000,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$30,000",
"dollars": 30000.0
},
"cost": {
"cents": 609,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$609",
"dollars": 609.0
},
"ref_data": null,
"media": {
"images": {
"favicon_small": {
"width": 16.0,
"height": 16.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon_small.png?1597657477"
},
"favicon": {
"width": 32.0,
"height": 32.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon.png?1597657477"
},
"favicon_large": {
"width": 64.0,
"height": 64.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon_large.png?1597657477"
},
"transparent_thumb": {
"width": 200.0,
"height": 200.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_thumb.png?1597657477"
},
"transparent_large": {
"width": 500.0,
"height": 156.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_large.png?1597657477"
},
"transparent_xlarge": {
"width": 1000.0,
"height": 313.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_xlarge.png?1597657477"
},
"original": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"thumb": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"source": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"transparent_medium": {
"width": 250.0,
"height": 78.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_medium.png?1597657477"
}
},
"_id": "5f3a5185e38809a2d1388bda",
"alt_translations": {}
},
"title_translations": {
"en": "Shopline.co",
"zh-hant": "商線科技"
},
"fields_translations": {
"en": [
"green",
"c1"
],
"zh-hant": [
"",
""
]
},
"sku": "2dd235",
"is_preorder": false,
"quantity": 1,
"total": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"order_discounted_price": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"discounted_price": null,
"created_by": "openapi"
}
],
"promotion_items": [
{
"id": "5f450eace388093f603a3b94",
"discountable_amount": null,
"discounted_amount": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"subtotal_after": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"promotion": {
"_id": "5f438530e38809448f8e88ab",
"addon_product_id": null,
"banner_media_ids": [],
"codes": [],
"created_at": "2020-08-24T09:15:28.894+00:00",
"description_translations": {},
"discount_amount": {
"cents": 23,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$23",
"dollars": 23.0
},
"discount_on": "order",
"discount_percentage": null,
"discount_type": "amount",
"discountable_category_ids": [],
"discountable_product_ids": [],
"discountable_quantity": null,
"discounted_point": null,
"discounted_price": null,
"end_at": null,
"extended_promotion_id": null,
"for_affiliate_campaign": false,
"is_accumulated": false,
"max_use_count": null,
"membership_tier_id": null,
"merchant_id": "5e8c5b7a2c389a006ad21050",
"min_price_type": "after_discount",
"multiple_code": false,
"requires_membership": false,
"seo_description_translations": {},
"seo_keywords": null,
"seo_title_translations": {},
"start_at": "2020-08-24T09:00:00.000+00:00",
"status": "active",
"term_translations": {},
"title_translations": {
"en": "Test 3",
"zh-hant": "Test 3"
},
"updated_at": "2020-08-24T09:15:28.894+00:00",
"use_count": 2,
"user_max_use_count": 0,
"id": "5f438530e38809448f8e88ab"
},
"updated_at": "2020-08-25T13:14:20.531+00:00",
"created_at": "2020-08-25T13:14:20.526+00:00"
}
],
"custom_data": [],
"custom_discount_items": [],
"affiliate_data": {},
"ref_order_id": "",
"ref_customer_id": "",
"channel": {},
"parent_order_id": "",
"child_order_ids": [],
"split_at": null,
"confirmed_at": null,
"created_by": "shop",
"updated_at": "2020-08-25T13:14:33.151+00:00",
"created_at": "2020-08-25T13:14:20.384+00:00",
"skip_fulfillment": false,
"utm_data": {},
"ga_tracked": true,
"order_comments": [],
"order_notes": []
},
{
"id": "5f43f05de388093f603a3ac0",
"order_number": "20200824165245716",
"status": "pending",
"order_remarks": "",
"order_payment": {
"payment_method_id": "5f351e78e388099b08d1a3f7",
"payment_type": "two_checkout",
"name_translations": {
"en": "Credit Card (via 2Checkout)",
"zh-hant": "信用卡 (經由2Checkout)"
},
"status": "completed",
"payment_fee": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"paid_at": "2020-08-24T16:53:56.925+00:00",
"updated_at": "2020-08-24T16:53:56.925+00:00",
"created_at": "2020-08-24T16:52:45.705+00:00",
"payment_data": {
"create_payment": {
"subCode": "",
"subMsg": "",
"resp": {
"orderId": "20200825005246830990241370000",
"appOrderId": "20200824165245716",
"chOrderId": "99920200824165245716",
"amount": "500.0",
"payData": {
"merchantCode": "250405304072",
"riskLevel": "0",
"channelPayUrl": "https://test-portal-xpay.yy.com/channel/TwoCheckout/Card/999/YlRzdXdjVjZHQTdTS2dyQXJWQmEzWWRrUmloM0JWeXd0dkxUVGZ1QTZhUk9UZlREY05HMHVtZkxzL0dRK3lSTFluc055RkFoZHVaL3ZUZkpNemdack96NGdJL1RZZ1JrRE40RFFnenZjWG5jaFRmRUd2eGNaYm5ISCs1VllZNkk=",
"riskResult": {
"enable": "true",
"result": {
"checkSuccess": "true",
"pass": "true",
"expectRiskLevel": "80",
"riskLevel": "0",
"detail": "{\"appId\":\"shopline_recharge\",\"assocAcctType\":255.0,\"persona_risk_mask\":\"0\",\"phone\":\"\",\"risk_level\":0.0,\"termType\":0.0,\"timestamp\":1.598287967238E12,\"traceId\":\"1297939924594503680\",\"uid\":\"5edddd9201afcd24a0f86606\"}"
}
},
"publicKey": "77620313-EAA5-4EB9-B484-E108C8F87ADE"
},
"attach": "",
"statusCode": "PAYING",
"statusMsg": "2checkout paying.",
"chDealTime": "",
"chDealId": "",
"paymentOrderId": "20200825005246830990241370000",
"merchantOrderId": "20200824165245716"
},
"success": "true",
"code": "10000",
"msg": "成功"
},
"notify_response": {
"appId": "999",
"signType": "RSA2",
"timestamp": "20200825005356",
"sign": "UhYsUizoDb7kM5L0XUGBNNkmJKhpCfVnlLxLhvMFV44msY9qWXy34ZGotmZfMzFyxCFeK2pgSN6T5MyCkk7+ofcj4BKWHw8RkkFp51bFjtARvD1Bsj8uHNA7TTeC1ZGNJRzDNydnyHMYgdCHiVgxWxX+fohnN6zQZh5S4bvM7hw=",
"bizContent": "{\"paymentOrderId\":\"20200825005246830990241370000\",\"merchantOrderId\":\"20200824165245716\",\"orderId\":\"20200825005246830990241370000\",\"appOrderId\":\"20200824165245716\",\"chOrderId\":\"99920200824165245716\",\"amount\":500.00,\"currency\":\"TWD\",\"payData\":{\"merchantCode\":\"250405304072\",\"riskLevel\":0.0,\"channelPayUrl\":\"https://test-portal-xpay.yy.com/channel/TwoCheckout/Card/999/YlRzdXdjVjZHQTdTS2dyQXJWQmEzWWRrUmloM0JWeXd0dkxUVGZ1QTZhUk9UZlREY05HMHVtZkxzL0dRK3lSTFluc055RkFoZHVaL3ZUZkpNemdack96NGdJL1RZZ1JrRE40RFFnenZjWG5jaFRmRUd2eGNaYm5ISCs1VllZNkk=\",\"publicKey\":\"77620313-EAA5-4EB9-B484-E108C8F87ADE\",\"payTokenData\":{\"last4\":\"1111\",\"bin\":\"4111\",\"card_type\":\"visa\"},\"chId\":\"TwoCheckout\",\"payMethod\":\"Card\",\"userId\":\"5edddd9201afcd24a0f86606\"},\"statusCode\":\"SUCCESS\",\"statusMsg\":\"pay success.\",\"chDealTime\":\"20200825005328\",\"chDealId\":\"131004268\",\"orderType\":\"\",\"prodId\":\"5f3a5188e38809a2d1388bdd\"}",
"controller": "order_payments",
"action": "notify",
"payment_gateway": "two_checkout",
"id": "5f43f05de388093f603a3ac6"
}
},
"last_four_digits": ""
},
"order_delivery": {
"delivery_option_id": "5eaf957fe3880941178912fa",
"platform": "custom",
"status": "pending",
"delivery_status": "pending",
"name_translations": {
"en": "",
"zh-hant": "郵寄"
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"shipped_at": null,
"arrived_at": null,
"collected_at": null,
"returned_at": null,
"remark": null,
"request_accepted_at": null,
"request_authorized_at": null,
"request_submitted_at": null,
"requested_fmt_at": null,
"require_expired_upload": false,
"require_storeclosed_upload": false,
"return_order_id": null,
"store_closed_at": null,
"storeclosed_upload_at": null
},
"delivery_address": {
"country_code": "HK",
"country": "Hong Kong",
"city": null,
"state": null,
"postcode": null,
"address_1": null,
"address_2": null,
"recipient_name": "Customer 1",
"recipient_phone": "99912345",
"remarks": null
},
"delivery_data": {
"hk_sfplus_home_region": null,
"location_code": null,
"location_name": null,
"name_translations": null,
"store_address": null,
"url": null,
"tracking_number": "",
"scheduled_delivery_date": null,
"time_slot_key": null,
"time_slot_translations": {}
},
"customer_id": "5edddd9201afcd24a0f86606",
"customer_name": "Customer 1",
"customer_email": "[email protected]",
"customer_phone": "99912345",
"customer_info": {},
"currency_iso": "TWD",
"subtotal": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"order_discount": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"user_credit": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total_tax_fee": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"total": {
"cents": 500,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$500",
"dollars": 500.0
},
"invoice": {
"tax_id": "",
"mailing_address": "",
"invoice_type": "",
"buyer_name": "",
"carrier_type": "",
"carrier_number": "",
"n_p_o_b_a_n": "",
"invoice_tax_type": "",
"invoice_number": "",
"invoice_status": "",
"invoice_date": null,
"invoice_cancelled_at": null
},
"subtotal_items": [
{
"id": "5f43f05de388093f603a3ac3",
"item_type": "Product",
"item_data": {
"cart_item_id": "5f43eb28e38809b5cbcc630a",
"promotion_id": null,
"parent_item_ids": [],
"triggering_item_id": "",
"order_promotion_items": {
"order_discounted_price": "5f43f05de388093f603a3abf"
},
"order_discounted_price": {
"cents": 13.0,
"currency_iso": "TWD"
},
"has_exclude_promotion_tag": false,
"variation_data": {
"_id": "5f3f8653e388096adcb65c4d",
"barcode_type": "Code 128",
"cost": {
"cents": 5.0,
"currency_iso": "TWD"
},
"created_at": "2020-08-21T08:31:15.929Z",
"feed_variations": null,
"fields": [
{
"name_translations": {
"en": "green",
"zh-hant": ""
}
},
{
"name_translations": {
"en": "c1",
"zh-hant": ""
}
}
],
"fields_translations": {
"en": [
"green",
"c1"
],
"zh-hant": [
"",
""
]
},
"gtin": null,
"key": "5f3f8653001e1200133a84a7",
"location_id": null,
"max_order_quantity": 10,
"media_id": null,
"member_price": {
"cents": 0.0,
"currency_iso": "TWD"
},
"mpn": null,
"price": {
"cents": 24.0,
"currency_iso": "TWD"
},
"price_sale": {
"cents": 13.0,
"currency_iso": "TWD"
},
"quantity": 1,
"root_product_variation_id": null,
"sku": "2dd235",
"stock_ids": null,
"unlimited_quantity": null,
"updated_at": "2020-08-24T07:59:36.764Z",
"variant_option_ids": [
"5f3f8653e388096adcb65c51",
"5f3f8653e388096adcb65c52"
],
"wapos_id": null,
"weight": 23.0,
"media_hash": {}
}
},
"item_id": "5f3a5188e38809a2d1388bdd",
"item_variation_id": "5f3f8653e388096adcb65c4d",
"item_variation_key": "5f3f8653001e1200133a84a7",
"item_price": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"price": {
"cents": 1000,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$1,000",
"dollars": 1000.0
},
"cost": {
"cents": 609,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$609",
"dollars": 609.0
},
"ref_data": null,
"media": {
"images": {
"favicon_small": {
"width": 16.0,
"height": 16.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon_small.png?1597657477"
},
"favicon": {
"width": 32.0,
"height": 32.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon.png?1597657477"
},
"favicon_large": {
"width": 64.0,
"height": 64.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/favicon_large.png?1597657477"
},
"transparent_thumb": {
"width": 200.0,
"height": 200.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_thumb.png?1597657477"
},
"transparent_large": {
"width": 500.0,
"height": 156.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_large.png?1597657477"
},
"transparent_xlarge": {
"width": 1000.0,
"height": 313.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_xlarge.png?1597657477"
},
"original": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"thumb": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"source": {
"width": 1600.0,
"height": 500.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/image_clips/5f3a5185e38809a2d1388bda/original.png?1597657477"
},
"transparent_medium": {
"width": 250.0,
"height": 78.0,
"url": "https://img-shoplineapp-com.s3.amazonaws.com/media/second_clips/5f3a5185e38809a2d1388bda/transparent_medium.png?1597657477"
}
},
"_id": "5f3a5185e38809a2d1388bda",
"alt_translations": {}
},
"title_translations": {
"en": "Shopline.co",
"zh-hant": "商線科技"
},
"fields_translations": {
"en": [
"green",
"c1"
],
"zh-hant": [
"",
""
]
},
"sku": "2dd235",
"is_preorder": false,
"quantity": 1,
"total": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"order_discounted_price": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"discounted_price": null,
"created_by": "openapi"
}
],
"promotion_items": [
{
"id": "5f43f05de388093f603a3abf",
"discountable_amount": null,
"discounted_amount": {
"cents": 13,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$13",
"dollars": 13.0
},
"subtotal_after": {
"cents": 0,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "",
"dollars": 0.0
},
"promotion": {
"_id": "5f438530e38809448f8e88ab",
"addon_product_id": null,
"banner_media_ids": [],
"codes": [],
"created_at": "2020-08-24T09:15:28.894+00:00",
"description_translations": {},
"discount_amount": {
"cents": 23,
"currency_symbol": "NT$",
"currency_iso": "TWD",
"label": "NT$23",
"dollars": 23.0
},
"discount_on": "order",
"discount_percentage": null,
"discount_type": "amount",
"discountable_category_ids": [],
"discountable_product_ids": [],
"discountable_quantity": null,
"discounted_point": null,
"discounted_price": null,
"end_at": null,
"extended_promotion_id": null,
"for_affiliate_campaign": false,
"is_accumulated": false,
"max_use_count": null,
"membership_tier_id": null,
"merchant_id": "5e8c5b7a2c389a006ad21050",
"min_price_type": "after_discount",
"multiple_code": false,
"requires_membership": false,
"seo_description_translations": {},
"seo_keywords": null,
"seo_title_translations": {},
"start_at": "2020-08-24T09:00:00.000+00:00",
"status": "active",
"term_translations": {},
"title_translations": {
"en": "Test 3",
"zh-hant": "Test 3"
},
"updated_at": "2020-08-24T09:15:28.894+00:00",
"use_count": 2,
"user_max_use_count": 0,
"id": "5f438530e38809448f8e88ab"
},
"updated_at": "2020-08-24T16:52:45.616+00:00",
"created_at": "2020-08-24T16:52:45.610+00:00"
}
],
"custom_data": [],
"custom_discount_items": [],
"affiliate_data": {},
"ref_order_id": "",
"ref_customer_id": "",
"channel": {},
"parent_order_id": "",
"child_order_ids": [],
"split_at": null,
"confirmed_at": null,
"created_by": "shop",
"updated_at": "2020-08-24T16:53:07.591+00:00",
"created_at": "2020-08-24T16:52:45.499+00:00",
"skip_fulfillment": false,
"utm_data": {},
"ga_tracked": true,
"order_comments": [],
"order_notes": []
}
],
"pagination": {
"current_page": 1,
"per_page": 2,
"total_pages": 84,
"total_count": 168
}
}
Updated 10 days ago