店配作業 #
待出貨訂單查詢V3 #
- 訂單查詢相關API提供不同版本以滿足不同的資訊需求，目前最新為 V3 版本，具備所有點數折抵資訊。以下為各版本說明：
版本說明 #
| 版本 | Header 設定 | 差異說明 |
|---|---|---|
| V1 | 無需額外設定 | 提供基本訂單出貨資訊 |
| V2 | "api-version": "2" |
增加賣場活動折抵、折價卷、購物金、超贈點、福利金等資訊 |
| V3 | "api-version": "3" |
在 V2 的基礎上新增 OPENPOINT 點數折抵資訊 |
Headers 範例
{
"api-token": "Supplier_XXXX",
"api-supplierid": "XXXX",
"content-type": "application/json",
"accept": "application/json",
"api-version": "3"
}
Endpoint URL: https://tw.scm.yahooapis.com/scmapi/api/StoreDelivery/GetPreparingOrders
HTTP Method: POST
Request Body #
TransferDateStart #
轉單日 (起)。
資料型態: dateTime
必填: 是
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
TransferDateEnd #
轉單日 (迄)。
資料型態: dateTime
必填: 是
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-25T23:59:59
Request/Response Sample #
POST /scmapi/api/StoreDelivery/GetPreparingOrders
{
"TransferDateStart": "2025-03-28T17:30:00",
"TransferDateEnd": "2025-03-28T17:40:55"
}
{
"OrderCount": 7,
"Orders": [
{
"OrderInfo": {
"ExternOrderkey": 504773150,
"OrderCode": "RM2503280001140",
"TransferDate": "2025-03-28T17:36:14.51",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6926236,
"Name": "[供應商宅店配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455364,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 380,
"RetailPrice": 399,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 10
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773165,
"OrderCode": "RM2503280001170",
"TransferDate": "2025-03-28T17:36:21.107",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6910530,
"Name": "[供應商宅配運費]測試賣場2",
"Attribute": "",
"ItemPageId": 3451709,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 398,
"RetailPrice": 398,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773171,
"OrderCode": "RM2503280001177",
"TransferDate": "2025-03-28T17:36:22.28",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(全家)",
"Name": "全家工業三店",
"Id": "F006966"
},
"Products": [
{
"Id": 6926236,
"Name": "[供應商宅店配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455364,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 380,
"RetailPrice": 399,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773202,
"OrderCode": "RM2503280001218",
"TransferDate": "2025-03-28T17:36:27.88",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6926236,
"Name": "[供應商宅店配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455364,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 380,
"RetailPrice": 399,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773207,
"OrderCode": "RM2503280001227",
"TransferDate": "2025-03-28T17:36:29.223",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6926270,
"Name": "[供應商宅配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455369,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 429,
"RetailPrice": 699,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773207,
"OrderCode": "RM2503280001228",
"TransferDate": "2025-03-28T17:36:29.38",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6926236,
"Name": "[供應商宅店配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455364,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 380,
"RetailPrice": 399,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
},
{
"OrderInfo": {
"ExternOrderkey": 504773215,
"OrderCode": "RM2503280001239",
"TransferDate": "2025-03-28T17:36:30.927",
"OrderType": "一般賣場",
"ExpectedShippingDate": "2025-03-31T23:59:00",
"LastShippingDate": "2025-03-31T23:59:00",
"Note": "",
"ShippingDate": "0001-01-01T00:00:00",
"DeliveryDate": "0001-01-01T00:00:00"
},
"ReceiverInfo": {
"Name": "王大頭",
"Mobile": "0979123456"
},
"StoreInfo": {
"Type": "超商付款取貨(7-11)",
"Name": "原中門市",
"Id": "833077"
},
"Products": [
{
"Id": 6926236,
"Name": "[供應商宅店配運費]測試賣場",
"Attribute": "",
"ItemPageId": 3455364,
"SupplierNo": "",
"Type": "一般商品",
"Qty": 1,
"Cost": 50,
"Subtotal": 50,
"ProductPrice": 380,
"RetailPrice": 399,
"CouponActivityCode": "",
"CouponAmount": 0,
"ActivityCode": "",
"ActivityAmount": 0,
"RedeemAmout": 0,
"RewardAmount": 0,
"WelfareAmount": 0,
"OpenPointAmount": 0
}
]
}
]
}
Response Elements #
若操作成功，API 會回傳 HTTP 200 response。並以 JSON 格式回傳完整的待出貨清單。
OrderCount #
資料筆數。
資料型態: Integer
Orders #
顯示待出貨清單的內容。Orders 的結構分別說明如下：
- OrderInfo：訂單相關資訊
- ReceiverInfo：收件人相關資訊
- StoreInfo：超商相關資訊
- Products：商品相關資訊
資料型態: Object Array
OrderInfo #
顯示訂單相關資訊的內容。OrderInfo 的結構分別說明如下：
- ExternOrderkey：購物車序號
- OrderCode：訂單編號
- TransferDate：轉單日期
- OrderType：賣場類型
- ExpectedShippingDate：應出貨日
- LastShippingDate：最晚出貨日
- Note：訂單備註
- ShippingDate：出貨確認日
- DeliveryDate：物流商配達日
資料型態: Object
ExternOrderkey #
購物車序號。
資料型態: Integer
OrderCode #
訂單編號。
資料型態: String
TransferDate #
轉單日期。
資料型態: dateTime
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
OrderType #
賣場類型。
資料型態: String
ExpectedShippingDate #
應出貨日。
資料型態: dateTime
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
LastShippingDate #
最晚出貨日。
資料型態: dateTime
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
Note #
訂單備註。
資料型態: String
ShippingDate #
出貨確認日。
資料型態: dateTime
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
DeliveryDate #
物流商配達日。
資料型態: dateTime
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
ReceiverInfo #
顯示收件人相關資訊的內容。ReceiverInfo 的結構分別說明如下：
- Name：收件人姓名
- Mobile：收件人手機
資料型態: Object
Name #
收件人姓名。
資料型態: String
Mobile #
收件人手機。
資料型態: String
StoreInfo #
顯示超商相關資訊的內容。StoreInfo 的結構分別說明如下：
- Type：超商類型
- Name：取貨門市
- Id：門市代號
資料型態: Object
Type #
超商類型。
資料型態: String
Name #
取貨門市。
資料型態: String
Id #
門市代號。
資料型態: String
Products #
顯示商品相關資訊的內容。Products 的結構分別說明如下：
- Id：商品編號
- Name：商品名稱
- Attribute：商品屬性
- ItemPageId：賣場編號
- SupplierNo：供應商料號
- Type：商品類別
- Qty：商品數量
- Cost：商品成本
- Subtotal：商品成本小計
- ProductPrice：商品售價
- RetailPrice：商品建議售價
- CouponActivityCode：折價券活動代號
- CouponAmount：折價券活動折抵金額
- ActivityCode：促銷折價活動代號
- ActivityAmount：促銷折價活動折抵金額
- RedeemAmout：消費者YAHOO購物金折抵金額
- RewardAmount：消費者YAHOO超贈點折抵金額
- WelfareAmount：消費者YAHOO福利金折抵金額
- OpenPointAmount：消費者OpenPoint折抵金額
資料型態: Object
Id #
商品編號。
資料型態: Integer
Name #
商品名稱。
資料型態: String
Attribute #
商品屬性。
資料型態: String
ItemPageId #
賣場編號。
資料型態: Integer
SupplierNo #
供應商料號。
資料型態: String
Type #
商品類別。
資料型態: String
Qty #
商品數量。
資料型態: Integer
Cost #
商品成本。
資料型態: Integer
Subtotal #
商品成本小計。
資料型態: Integer
ProductPrice #
商品售價。
資料型態: Integer
RetailPrice #
商品建議售價。
資料型態: Integer
CouponActivityCode #
折價券活動代號。
資料型態: String
CouponAmount #
折價券活動折抵金額。
資料型態: Integer
ActivityCode #
促銷折價活動代號。
資料型態: String
ActivityAmount #
促銷折價活動折抵金額。
資料型態: Integer
RedeemAmout #
消費者YAHOO購物金折抵金額。
資料型態: Integer
RewardAmount #
消費者YAHOO超贈點折抵金額。
資料型態: Integer
WelfareAmount #
消費者YAHOO福利金折抵金額 (現況已無該折抵金額活動)。
資料型態: Integer
OpenPointAmount #
消費者OpenPoint折抵金額。
資料型態: Integer