API
查询出库单(列表)
更新时间: 2020-12-09 21:11:02 访问次数:12253
接口说明
卖家或第三方通过该接口可查询出库单。
请求说明
URL | https://openapi.winit.com.cn/openapi/service |
接口测试 | https://sandboxopenapi.winit.com.cn/openapi/service |
接口名称 | queryOutboundOrderList |
验证方法 | Token,md5 |
格式 | json |
字符编码 | UTF-8 |
http请求方式 | http |
请求数限制 | 默认每分钟1000,有需要可申请加大。 |
请求入参
名称 | 类型 | 必填 | 说明 | 示例 |
---|---|---|---|---|
warehouseId | String() | N | 海外仓仓库Id | |
outboundOrderNum | String() | N | 海外仓出库单号 | |
sellerOrderNo |
String() | N | 卖家订单号(自定义) | |
trackingNo | String() | N | 快递单号 | |
receiverName | String() | N | 收件人姓名 | |
bookingOperator | String() | N | winit客户名称 | |
productValue | String() | N | 产品编码 | |
productName | String() | N | 产品名称 | |
productSku | String() | N | 商品SKU | |
shareOrderType | String() | N | 是否共享订单(已停用)
0:不包含共享信息 1:包含共享信息 2:共享方 3:被共享方 [默认为0] |
|
dateOrderedStartDate | String(10) | Y | yyyy-MM-dd 出库单提交时间 | |
dateOrderedEndDate | String(10) | Y | yyyy-MM-dd 出库单提交时间 | |
status | String() | N | 订单状态编码,详见出库单状态列表
“status”不填写的时候,默认不包含VO(已作废)的订单,如需查询“已作废”的订单,请入参status="VO” |
|
pageSize | integer | Y | 每页显示数量 | |
pageNum | integer | Y | 页码,默认1 |
请求示例
{ "action": "queryOutboundOrderList", "app_key": "rebecca", "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2", "client_sign": "B9DE8A08181811889837EB365E4FD933", "data": { "dateOrderedStartDate": "2018-06-15", "dateOrderedEndDate": "2029-06-20", "pageSize": "10", "pageNum": "1" }, "format": "json", "language": "zh_CN", "platform": "OWNERERP", "sign": "AF335602C0257273694DC97E7559ECDF", "sign_method": "md5", "timestamp": "", "version": "1.0" }
返回出参
名称 | 类型 | 必填 | 说明 | 示例 |
---|---|---|---|---|
exwarehouseId | String() | Y | 出库单ID | |
ontimeStatus | String() | Y | 准时派送(服务时间、完成时间) | |
storageOntime | String() | Y | 服务时间(天) | |
serviceStandardTime | String() | Y | 标准时间(天) | |
serviceCompleteTime | String() | Y | 完成时间(天) | |
sku | String() | Y | 商品编码SKU | LCD-IP5-01@@1@@M010000000000062792@@ |
itemqty | Integer | Y | 单品数量 | |
weight | Numeric(10,2) | Y | 重量(kg) | |
countryName | String() | Y | 国家 | US |
documentNo | String() | Y | 海外仓出库单号 | |
eBaySellerID | String() | Y | eBaySellerID | |
status | String() | Y | 订单状态编码 | |
sellerOrderNo | String() | Y | 卖家订单号 | |
statusName | String() | Y | 出库单状态中文名 | 出库确认中 |
warehouseId | String() | Y | 仓库ID | |
warehouseName | String() | Y | 仓库名 | USWC Warehouse |
deliverywayId | String() | Y | 发货方式ID | |
deliverywayName | String() | Y | 发货方式 | AU Post eParcel |
trackingNo | String() | Y | 快递单号 | |
name | String() | Y | 收件人姓名 | |
bpName | String() | Y | 下单人 | 1000136 |
dateOrdered | Date | Y | 下单时间 | 2015-06-23 15:16:49 |
dateFinish | Date | Y | 出库时间 | |
isShareOrder | String() | Y | 是否为代销出库单 | |
cBpartnerId | String() | Y | 业务伙伴 | |
cFromBpartnerId | String() | Y | 共享方ID | |
cToBpartnerId | String() | Y | 代销商ID | |
isError | String() | Y | Y:成功,N:失败 | |
postal | String() | Y | 邮编 | |
isEBayOrder | String() | Y | 是否ebay订单 | |
totalCost | String | N | 订单总费用 包含增值服务费用 |
|
VASFeeCost | String | N | 总增值服务费用 | |
包裹列表packageList | ||||
weight | Number | Y | 包裹重量Kg | |
packageNum | String() | Y | 包裹编号 | |
status | String() | Y | 包裹状态编码
一个订单一个包裹的情况下跟出库单状态编码相同 一个订单多个包裹的情况下,则有可能包裹状态跟出库单状态不相同 |
|
serviceCompleteTime | String() | Y | 订单处理完成时间(天) | |
serviceStandardTime | String() | Y | 订单处理标准时间(天) | |
itemqty | Integer | Y | 包裹中商品数量 | |
ontimeStatus | String() | Y | 准时派送(服务时间、完成时间) |
|
trackingNos | Array | Y | 包裹跟踪号 | |
sku | String | Y | 商品编码 |
返回示例
{ "code": "0", "msg": "操作成功", "data": { "currentPageSize": 10, "total": 257, "currentPageNum": 1, "list": [{ "winitTrackingNo": null, "sellerOrderNo": "PowerSellerABC1234", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1000020, "dateFinish": null, "warehouseName": "AU Warehouse", "warehouseCode": "EWD", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000004020", "winit_trackingno": null, "eBaySellerID": "PowerSellerABC124", "dateOrdered": "2019-08-23 15:48:51", "statusName": "出库确认", "deliverywayName": "AU Post - Parcel Post eParcel (Standard 2-6 Business Days)", "currency": "AUD", "is_ebay_plus": "N", "isRepeat": "N", "sku": "LCD-IP4-01@@1@@M010000000000062788@@", "serviceCompletionDay": null, "isEBayOrder": "Y", "estimateFees": 7.41, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 402, "weight": null, "estimateVolume": 7.56E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": null, "weight": null, "serviceStandardTime": 0, "sku": "LCD-IP4-01*1", "packageNum": "WO0000004020A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.01, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000001, "trackingNo": "", "name": "mingbao", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810100", "postal": "3153", "countryName": "澳大利亚", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "SYO15101467953", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1000111, "dateFinish": null, "warehouseName": "USWC Warehouse", "warehouseCode": "US0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003951", "winit_trackingno": null, "eBaySellerID": "vollter-store", "dateOrdered": "2019-08-23 11:17:06", "statusName": "出库确认", "deliverywayName": "UPS - Ground (Standard 1-5 Business Days)-USWC", "currency": "USD", "is_ebay_plus": "N", "isRepeat": "N", "sku": "LCD-IP5-01@@1@@M010000000000062792@@", "serviceCompletionDay": null, "isEBayOrder": "Y", "estimateFees": 12.71, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 395, "weight": null, "estimateVolume": 0.010648, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": ["1Z68223Y0335397680"], "weight": null, "serviceStandardTime": 0, "sku": "LCD-IP5-01*1", "packageNum": "WO0000003951A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.022, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000008, "trackingNo": "1Z68223Y0335397680", "name": "Carrie Shaw", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810595", "postal": "23462-2847", "countryName": "美国", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1010519, "dateFinish": null, "warehouseName": "USWC Warehouse", "warehouseCode": "US0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003737", "winit_trackingno": null, "eBaySellerID": "", "dateOrdered": "2019-08-19 14:34:21", "statusName": "出库确认", "deliverywayName": "UPS - Ground (Standard 1-5 Business Days)-Sign-USWC", "currency": "USD", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku_001@@1@@M010000000000905686@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 15.71, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 373, "weight": null, "estimateVolume": 5.0E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": ["1Z68223Y0327469742"], "weight": null, "serviceStandardTime": 0, "sku": "auto_sku_001*1", "packageNum": "WO0000003737A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.2, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000008, "trackingNo": "1Z68223Y0327469742", "name": "sky", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810598", "postal": "91436-3631", "countryName": "美国", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "252727722489-1495123873511", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1000254, "dateFinish": "2019-08-19 14:21:25", "warehouseName": "USWC Warehouse", "warehouseCode": "US0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003724", "winit_trackingno": null, "eBaySellerID": null, "dateOrdered": "2019-08-19 14:19:44", "statusName": "派送中", "deliverywayName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC", "currency": "USD", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku22@@1@@M010000000001674549@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 8.16, "itemqty": 1, "sellerWeight": null, "exwarehouseId": 372, "weight": 0.025, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": ["9205590181411202658989"], "weight": 0.025, "serviceStandardTime": 0, "sku": "auto_sku22*1", "packageNum": "WO0000003724A", "status": "DLI" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.025, "volume": 4.5E-4, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000008, "trackingNo": "9205590181411202658989", "name": "shane bellingham", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810757", "postal": "91436-3631", "countryName": "美国", "cBpartnerId": 1000019, "status": "DLI" }, { "winitTrackingNo": null, "sellerOrderNo": "252727722489-1495123873511", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1000254, "dateFinish": "2019-08-12 13:06:46", "warehouseName": "USWC Warehouse", "warehouseCode": "US0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003531", "winit_trackingno": null, "eBaySellerID": null, "dateOrdered": "2019-08-12 13:03:47", "statusName": "派送中", "deliverywayName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC", "currency": "USD", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku22@@1@@M010000000001674549@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 8.16, "itemqty": 1, "sellerWeight": null, "exwarehouseId": 353, "weight": 0.025, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": ["9205590181411202658988"], "weight": 0.025, "serviceStandardTime": 0, "sku": "auto_sku22*1", "packageNum": "WO0000003531A", "status": "DLI" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.025, "volume": 4.5E-4, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000008, "trackingNo": "9205590181411202658988", "name": "shane bellingham", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810757", "postal": "91436-3631", "countryName": "美国", "cBpartnerId": 1000019, "status": "DLI" }, { "winitTrackingNo": null, "sellerOrderNo": "252727722489-1495123873511", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1000254, "dateFinish": "2019-08-12 12:12:03", "warehouseName": "USWC Warehouse", "warehouseCode": "US0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003526", "winit_trackingno": null, "eBaySellerID": null, "dateOrdered": "2019-08-12 12:09:35", "statusName": "派送中", "deliverywayName": "USPS - Priority Mail (Express 2-3 Business Days)-USWC", "currency": "USD", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku22@@1@@M010000000001674549@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 8.16, "itemqty": 1, "sellerWeight": null, "exwarehouseId": 352, "weight": 0.025, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": ["9205590181411202658987"], "weight": 0.025, "serviceStandardTime": 0, "sku": "auto_sku22*1", "packageNum": "WO0000003526A", "status": "DLI" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.025, "volume": 4.5E-4, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000008, "trackingNo": "9205590181411202658987", "name": "shane bellingham", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810757", "postal": "91436-3631", "countryName": "美国", "cBpartnerId": 1000019, "status": "DLI" }, { "winitTrackingNo": null, "sellerOrderNo": "testforScrapService", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 2000974, "dateFinish": null, "warehouseName": "AU Warehouse", "warehouseCode": "EWD", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003510", "winit_trackingno": null, "eBaySellerID": null, "dateOrdered": "2019-08-09 15:23:46", "statusName": "出库确认", "deliverywayName": "Scrap Service(销毁服务)", "currency": "AUD", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku_001@@1@@M010000000000905686@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 0.24, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 351, "weight": null, "estimateVolume": 5.0E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": null, "weight": null, "serviceStandardTime": 0, "sku": "auto_sku_001*1", "packageNum": "WO0000003510A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.2, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000001, "trackingNo": "", "name": null, "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF830859", "postal": null, "countryName": "澳大利亚", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "testforpaketservice", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1010308, "dateFinish": null, "warehouseName": "DE Warehouse", "warehouseCode": "DE0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003505", "winit_trackingno": null, "eBaySellerID": "", "dateOrdered": "2019-08-09 14:44:37", "statusName": "出库确认", "deliverywayName": "DHL - Domestic Paket (Standard 1-3 Business Days)", "currency": "EUR", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku_005@@1@@M010000000000905690@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 3.52, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 350, "weight": null, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": null, "weight": null, "serviceStandardTime": 0, "sku": "auto_sku_005*1", "packageNum": "WO0000003505A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.1, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000089, "trackingNo": "", "name": "test", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810556", "postal": "45701", "countryName": "德国", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "testforpaketservice", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1010308, "dateFinish": null, "warehouseName": "DE Warehouse", "warehouseCode": "DE0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003476", "winit_trackingno": null, "eBaySellerID": "", "dateOrdered": "2019-08-09 13:57:41", "statusName": "出库确认", "deliverywayName": "DHL - Domestic Paket (Standard 1-3 Business Days)", "currency": "EUR", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku_005@@1@@M010000000000905690@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 3.52, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 347, "weight": null, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": null, "weight": null, "serviceStandardTime": 0, "sku": "auto_sku_005*1", "packageNum": "WO0000003476A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.1, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000089, "trackingNo": "", "name": "test", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810556", "postal": "45701", "countryName": "德国", "cBpartnerId": 1000019, "status": "CF" }, { "winitTrackingNo": null, "sellerOrderNo": "testforpaketservice", "serviceNormDay": null, "cFromBpartnerId": 0, "deliverywayId": 1010308, "dateFinish": null, "warehouseName": "DE Warehouse", "warehouseCode": "DE0001", "isAddressError": "", "isShareOrder": "N", "documentNo": "WO0000003466", "winit_trackingno": null, "eBaySellerID": "", "dateOrdered": "2019-08-08 22:03:24", "statusName": "出库确认", "deliverywayName": "DHL - Domestic Paket (Standard 1-3 Business Days)", "currency": "EUR", "is_ebay_plus": null, "isRepeat": "Y", "sku": "auto_sku_005@@1@@M010000000000905690@@", "serviceCompletionDay": null, "isEBayOrder": "N", "estimateFees": 3.52, "itemqty": 0, "sellerWeight": null, "exwarehouseId": 346, "weight": null, "estimateVolume": 4.5E-4, "packageList": [{ "itemqty": 1, "serviceCompleteTime": 0, "ontimeStatus": null, "trackingNos": null, "weight": null, "serviceStandardTime": 0, "sku": "auto_sku_005*1", "packageNum": "WO0000003466A", "status": "CF" }], "storageOntime": null, "errorMsg": "", "estimateWeight": 0.1, "volume": null, "ontimeStatus": null, "serviceCompleteTime": null, "bpName": "万邑通质量保证部测试账号1-TEST", "ontimeTrack": null, "warehouseId": 1000089, "trackingNo": "", "name": "test", "cToBpartnerId": 0, "serviceStandardTime": null, "finishedTime": null, "winitProductCode": "OSF810556", "postal": "45701", "countryName": "德国", "cBpartnerId": 1000019, "status": "CF" } ] } }
关键词