三方作業 #
退貨單查詢 #
查詢退貨訂單資訊，結果Cache 10分鐘。
Endpoint URL: https://tw.scm.yahooapis.com/scmapi/api/ThirdPartyDelivery/GetReturnOrders
HTTP Method: POST
Request Body #
ReturnStatus #
退貨單狀態。
資料型態: String
必填: 是
說明:
- All:全部
- NonClose:未結案
- Close:已結案
- Cancel:取消
DateType #
日期條件。
資料型態: String
必填: 是
說明:
- ReturnCreateDate:退貨單建立日
- ReturnCloseDate:退貨單結案日
StartDate #
起始日期。
資料型態: dateTime
必填: 是
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-25T23:59:59
EndDate #
迄止日期。
資料型態: dateTime
必填: 是
說明: 時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-25T23:59:59
Request/Response Sample #
POST /scmapi/api/ThirdPartyDelivery/GetReturnOrders
{
"ReturnStatus": "All",
"DateType": "ReturnCreateDate",
"StartDate": "2024-04-24T09:30:00",
"EndDate": "2024-05-30T10:21:00"
}
{
"ReturnOrdersCount": 15,
"ReturnOrders": [
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400008R",
"ReturnSerialNumber": "1967242",
"ReturnCreateDate": "2024-04-24T09:43:01.17",
"ReturnCloseDate": "2024-04-24T09:46:04",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6804909,
"ProductName": "贈品",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400007R",
"ReturnSerialNumber": "1967241",
"ReturnCreateDate": "2024-04-24T09:43:01.093",
"ReturnCloseDate": "2024-04-24T09:46:04",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6804909,
"ProductName": "贈品",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400006R",
"ReturnSerialNumber": "1967240",
"ReturnCreateDate": "2024-04-24T09:43:01.013",
"ReturnCloseDate": "2024-04-24T09:46:04",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6804909,
"ProductName": "贈品",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400005R",
"ReturnSerialNumber": "1967239",
"ReturnCreateDate": "2024-04-24T09:43:00.933",
"ReturnCloseDate": "2024-04-24T09:46:02",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6497187,
"ProductName": "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400004R",
"ReturnSerialNumber": "1967238",
"ReturnCreateDate": "2024-04-24T09:43:00.783",
"ReturnCloseDate": "2024-04-24T09:46:03",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6497187,
"ProductName": "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400003R",
"ReturnSerialNumber": "1967237",
"ReturnCreateDate": "2024-04-24T09:43:00.707",
"ReturnCloseDate": "2024-04-24T09:46:03",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6497187,
"ProductName": "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400002R",
"ReturnSerialNumber": "1967236",
"ReturnCreateDate": "2024-04-24T09:43:00.253",
"ReturnCloseDate": "2024-04-24T09:46:03",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6497187,
"ProductName": "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400001R",
"ReturnSerialNumber": "1967235",
"ReturnCreateDate": "2024-04-24T09:42:59.96",
"ReturnCloseDate": "2024-04-24T09:46:00",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6497187,
"ProductName": "1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400010R",
"ReturnSerialNumber": "1967244",
"ReturnCreateDate": "2024-04-24T09:43:01.47",
"ReturnCloseDate": "2024-04-24T09:46:05",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6804909,
"ProductName": "贈品",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2405060000128",
"ReturnCode": "2024050600001R",
"ReturnSerialNumber": "1967245",
"ReturnCreateDate": "2024-05-06T12:07:56.03",
"ReturnCloseDate": "1900-01-01T00:00:00",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "1014073454",
"ReturnCause": "與網頁說明不同",
"ReturnCauseNote": "測試",
"Note": ""
},
"Receiver": {
"ReceiverName": "張煜志",
"Address": "(324)桃園市平鎮區中正路199號",
"Phone": "09-79102257",
"Mobile": "0979102257"
},
"Product": {
"Id": 6565582,
"ProductName": "WALLE測試賣場2020031201",
"Attribute": "",
"SupplierNo": "",
"Type": "",
"Qty": 1,
"Cost": 510,
"SubTotal": 510
}
},
{
"OrderInfo": {
"OrderCode": "RM2404240000580",
"ReturnCode": "2024042400009R",
"ReturnSerialNumber": "1967243",
"ReturnCreateDate": "2024-04-24T09:43:01.263",
"ReturnCloseDate": "2024-04-24T09:46:05",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "112345679165",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "非北北基",
"Address": "(351)苗栗縣頭份鎮非北北基一段50號",
"Phone": "0900111222",
"Mobile": "0900111222"
},
"Product": {
"Id": 6804909,
"ProductName": "贈品",
"Attribute": "",
"SupplierNo": "",
"Type": "9721",
"Qty": 1,
"Cost": 0,
"SubTotal": 0
}
},
{
"OrderInfo": {
"OrderCode": "RM2405020000159",
"ReturnCode": "2024050700004R",
"ReturnSerialNumber": "1967249",
"ReturnCreateDate": "2024-05-07T14:55:44.88",
"ReturnCloseDate": "2024-05-07T15:00:52",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "",
"Address": null,
"Phone": "",
"Mobile": ""
},
"Product": {
"Id": 6700841,
"ProductName": "物流服務費",
"Attribute": "",
"SupplierNo": "",
"Type": "pca_55254",
"Qty": 1,
"Cost": 600,
"SubTotal": 600
}
},
{
"OrderInfo": {
"OrderCode": "RM2405020000159",
"ReturnCode": "2024050700003R",
"ReturnSerialNumber": "1967248",
"ReturnCreateDate": "2024-05-07T14:55:44.797",
"ReturnCloseDate": "2024-05-07T15:00:54",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "",
"Address": null,
"Phone": "",
"Mobile": ""
},
"Product": {
"Id": 6700841,
"ProductName": "物流服務費",
"Attribute": "",
"SupplierNo": "",
"Type": "pca_55254",
"Qty": 1,
"Cost": 600,
"SubTotal": 600
}
},
{
"OrderInfo": {
"OrderCode": "RM2405020000159",
"ReturnCode": "2024050700002R",
"ReturnSerialNumber": "1967247",
"ReturnCreateDate": "2024-05-07T14:55:44.433",
"ReturnCloseDate": "2024-05-07T15:00:54",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "",
"Address": null,
"Phone": "",
"Mobile": ""
},
"Product": {
"Id": 6700841,
"ProductName": "物流服務費",
"Attribute": "",
"SupplierNo": "",
"Type": "pca_55254",
"Qty": 1,
"Cost": 600,
"SubTotal": 600
}
},
{
"OrderInfo": {
"OrderCode": "RM2405020000159",
"ReturnCode": "2024050700005R",
"ReturnSerialNumber": "1967250",
"ReturnCreateDate": "2024-05-07T14:55:44.963",
"ReturnCloseDate": "2024-05-07T15:00:54",
"ReturnCancelDate": "1900-01-01T00:00:00",
"ReturnShpcode": "",
"ReturnCause": "瑕疵/故障",
"ReturnCauseNote": "",
"Note": ""
},
"Receiver": {
"ReceiverName": "",
"Address": null,
"Phone": "",
"Mobile": ""
},
"Product": {
"Id": 6700841,
"ProductName": "物流服務費",
"Attribute": "",
"SupplierNo": "",
"Type": "pca_55254",
"Qty": 1,
"Cost": 600,
"SubTotal": 600
}
}
]
}
Response Elements #
若操作成功，API 會回傳 HTTP 200 response。並以 JSON 格式回傳完整的已退貨清單。
ReturnOrdersCount #
資料筆數。
資料型態: Integer
ReturnOrders #
顯示已退貨清單的內容。ReturnOrders 的結構分別說明如下：
- OrderInfo：訂單相關資訊
- Receiver：取件人相關資訊
- Product：商品相關資訊
資料型態: Object Array
OrderInfo #
顯示退貨單相關資訊的內容。OrderInfo 的結構分別說明如下：
- OrderCode：訂單編號
- ReturnCode：退貨單編號
- ReturnSerialNumber：退貨單序號
- ReturnCreateDate：退貨單成立日期
- ReturnCloseDate：退貨單結案日期
- ReturnCancelDate：退貨單取消日期
- ReturnShpcode：退貨單託運單號
- ReturnCause：退貨原因
- ReturnCauseNote：退貨原因備註
- Note：取貨備註
資料型態: Object
OrderCode #
訂單編號。
資料型態: String
ReturnCode #
退貨單編號。
資料型態: String
ReturnSerialNumber #
退貨單序號。
資料型態: String
ReturnCreateDate #
退貨單成立日期。
資料型態：dateTime
說明：時間格式為
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
ReturnCloseDate #
退貨單結案日期。
資料型態：dateTime
說明：若退貨單未結案則顯示1900-01-01T00:00:00
時間格式：
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
ReturnCancelDate #
退貨單取消日期。
資料型態: dateTime
說明: 若退貨單未取消則顯示1900-01-01T00:00:00
時間格式：
- yyyy-mm-ddThh:mm:ss
- ex. 2024-01-20T00:00:00
ReturnShpcode #
退貨單託運單號。
資料型態: String
ReturnCause #
退貨原因。
資料型態: String
說明：對應於API退貨原因查詢
- “1”: “瑕疵/故障”
- “7”: “價格比別家貴”
- “14”: “不需要或重複購買”
- “25”: “重訂(改買別款.改付款等)”
- “26”: “品質不好(質感.性能等)”
- “27”: “與網頁說明不同”
- “28”: “寄錯/缺件”
- “29”: “購物中心同商品降價”
- “32”: “不明件-代收又驗退”
- “41”: “已過優惠期間”
- “42”: “預約/訂位不易”
- “43”: “評價不佳/使用經驗不好”
- “44”: “序號使用問題”
- “45”: “O2O店家關店”
- “51”: “材質不喜歡”
- “52”: “穿起來太大”
- “53”: “穿起來太小”
- “54”: “圖片與實物有落差”
- “55”: “網頁說明不夠完整”
- “90”: “其他”
- “-1”: “拒收”
ReturnCauseNote #
退貨原因備註。
資料型態: String
Note #
取貨備註。
資料型態: String
Receiver #
顯示取件人相關資訊的內容。Receiver 的結構分別說明如下：
- ReceiverName：取件人姓名
- Address：取件人地址
- Phone：取件人電話
- Mobile：取件人手機
資料型態: Object
ReceiverName #
取件人姓名。
資料型態: String
Address #
取件人地址。
資料型態: String
Phone #
取件人電話。
資料型態: String
Mobile #
取件人手機。
資料型態: String
Product #
顯示商品相關資訊的內容。Product 的結構分別說明如下：
- Id：商品編號
- ProductName：商品名稱
- Attribute：商品屬性
- SupplierNo：供應商料號
- Type：行銷活動活動代碼
- Qty：商品數量
- Cost：商品成本
- SubTotal：商品成本小計
資料型態: Object
Id #
商品編號。
資料型態: Integer
ProductName #
商品名稱。
資料型態: String
Attribute #
商品屬性。
資料型態: String
SupplierNo #
供應商料號。
資料型態: String
Type #
行銷活動活動代碼。
資料型態: String
Qty #
商品數量。
資料型態: Integer
Cost #
商品成本。
資料型態: Integer
SubTotal #
商品成本小計。
資料型態: Integer