API
查询出库单(列表)
更新时间: 2020-12-09 21:11:02 访问次数:16719

接口说明

卖家或第三方通过该接口可查询出库单。

接口名称

queryOutboundOrderList

请求说明

请求内容 说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟1000,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
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

已停用字段:
shareOrderType是否共享订单(已停用) 0:不包含共享信息 1:包含共享信息 2:共享方 3:被共享方 [默认为0]

请求示例

  1. {
  2. "action": "queryOutboundOrderList",
  3. "app_key": "rebecca",
  4. "client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5. "client_sign": "B9DE8A08181811889837EB365E4FD933",
  6. "data": {
  7. "dateOrderedStartDate": "2018-06-15",
  8. "dateOrderedEndDate": "2029-06-20",
  9. "pageSize": "10",
  10. "pageNum": "1"
  11. },
  12. "format": "json",
  13. "language": "zh_CN",
  14. "platform": "OWNERERP",
  15. "sign": "AF335602C0257273694DC97E7559ECDF",
  16. "sign_method": "md5",
  17. "timestamp": "",
  18. "version": "1.0"
  19. }

返回出参

返回参数说明:正确的返回编码code:0及结果data,错误的返回错误码及错误信息msg。

名称 类型 必传 说明 示例
exwarehouseId String() Y 出库单ID -
documentNo String() Y 海外仓出库单号
sellerOrderNo String() Y 卖家订单号
status 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 快递单号
countryName String() Y 国家 US
postal String() Y 邮编
name String() Y 收件人姓名
ontimeStatus String() Y 准时派送(服务时间、完成时间)
sku String() Y 商品编码SKU LCD-IP5-01
itemqty Integer Y 单品数量
weight Numeric(10,2) Y 重量(kg)
isEBayOrder String() Y 是否ebay订单
eBaySellerID String() Y eBaySellerID
storageOntime String() Y 服务时间(天)
serviceStandardTime String() Y 标准时间(天)
serviceCompleteTime 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:失败 -
totalCost String N 订单总费用
包含增值服务费用
VASFeeCost String N 总增值服务费用
packageList Array Y 包裹列表
–|packageNum String() Y 包裹编号
–|status String() Y 包裹状态编码
一个订单一个包裹的情况下跟出库单状态编码相同
一个订单多个包裹的情况下,则有可能包裹状态跟出库单状态不相同

–|weight Number Y 包裹重量Kg
–|trackingNos Array Y 包裹跟踪号
–|sku String Y 商品编码
–|itemqty Integer Y 包裹中商品数量
–|serviceCompleteTime String() Y 订单处理完成时间(天)
–|serviceStandardTime String() Y 订单处理标准时间(天)
–|ontimeStatus String() Y 准时派送(服务时间、完成时间)

返回示例

  1. {
  2. "code": "0",
  3. "msg": "操作成功",
  4. "data": {
  5. "currentPageSize": 10,
  6. "total": 257,
  7. "currentPageNum": 1,
  8. "list": [
  9. {
  10. "winitTrackingNo": null,
  11. "sellerOrderNo": "PowerSellerABC1234",
  12. "serviceNormDay": null,
  13. "cFromBpartnerId": 0,
  14. "deliverywayId": 1000020,
  15. "dateFinish": null,
  16. "warehouseName": "AU Warehouse",
  17. "warehouseCode": "EWD",
  18. "isAddressError": "",
  19. "isShareOrder": "N",
  20. "documentNo": "WO0000004020",
  21. "winit_trackingno": null,
  22. "eBaySellerID": "PowerSellerABC124",
  23. "dateOrdered": "2019-08-23 15:48:51",
  24. "statusName": "出库确认",
  25. "deliverywayName": "AU Post - Parcel Post eParcel (Standard 2-6 Business Days)",
  26. "currency": "AUD",
  27. "is_ebay_plus": "N",
  28. "isRepeat": "N",
  29. "sku": "LCD-IP4-01@@1@@M010000000000062788@@",
  30. "serviceCompletionDay": null,
  31. "isEBayOrder": "Y",
  32. "estimateFees": 7.41,
  33. "itemqty": 0,
  34. "sellerWeight": null,
  35. "exwarehouseId": 402,
  36. "weight": null,
  37. "estimateVolume": 7.56E-4,
  38. "packageList": [{
  39. "itemqty": 1,
  40. "serviceCompleteTime": 0,
  41. "ontimeStatus": null,
  42. "trackingNos": null,
  43. "weight": null,
  44. "serviceStandardTime": 0,
  45. "sku": "LCD-IP4-01*1",
  46. "packageNum": "WO0000004020A",
  47. "status": "CF"
  48. }],
  49. "storageOntime": null,
  50. "errorMsg": "",
  51. "estimateWeight": 0.01,
  52. "volume": null,
  53. "ontimeStatus": null,
  54. "serviceCompleteTime": null,
  55. "bpName": "万邑通质量保证部测试账号1-TEST",
  56. "ontimeTrack": null,
  57. "warehouseId": 1000001,
  58. "trackingNo": "",
  59. "name": "mingbao",
  60. "cToBpartnerId": 0,
  61. "serviceStandardTime": null,
  62. "finishedTime": null,
  63. "winitProductCode": "OSF810100",
  64. "postal": "3153",
  65. "countryName": "澳大利亚",
  66. "cBpartnerId": 1000019,
  67. "status": "CF"
  68. },
  69. {
  70. "winitTrackingNo": null,
  71. "sellerOrderNo": "testforpaketservice",
  72. "serviceNormDay": null,
  73. "cFromBpartnerId": 0,
  74. "deliverywayId": 1010308,
  75. "dateFinish": null,
  76. "warehouseName": "DE Warehouse",
  77. "warehouseCode": "DE0001",
  78. "isAddressError": "",
  79. "isShareOrder": "N",
  80. "documentNo": "WO0000003466",
  81. "winit_trackingno": null,
  82. "eBaySellerID": "",
  83. "dateOrdered": "2019-08-08 22:03:24",
  84. "statusName": "出库确认",
  85. "deliverywayName": "DHL - Domestic Paket (Standard 1-3 Business Days)",
  86. "currency": "EUR",
  87. "is_ebay_plus": null,
  88. "isRepeat": "Y",
  89. "sku": "auto_sku_005@@1@@M010000000000905690@@",
  90. "serviceCompletionDay": null,
  91. "isEBayOrder": "N",
  92. "estimateFees": 3.52,
  93. "itemqty": 0,
  94. "sellerWeight": null,
  95. "exwarehouseId": 346,
  96. "weight": null,
  97. "estimateVolume": 4.5E-4,
  98. "packageList": [{
  99. "itemqty": 1,
  100. "serviceCompleteTime": 0,
  101. "ontimeStatus": null,
  102. "trackingNos": null,
  103. "weight": null,
  104. "serviceStandardTime": 0,
  105. "sku": "auto_sku_005*1",
  106. "packageNum": "WO0000003466A",
  107. "status": "CF"
  108. }],
  109. "storageOntime": null,
  110. "errorMsg": "",
  111. "estimateWeight": 0.1,
  112. "volume": null,
  113. "ontimeStatus": null,
  114. "serviceCompleteTime": null,
  115. "bpName": "万邑通质量保证部测试账号1-TEST",
  116. "ontimeTrack": null,
  117. "warehouseId": 1000089,
  118. "trackingNo": "",
  119. "name": "test",
  120. "cToBpartnerId": 0,
  121. "serviceStandardTime": null,
  122. "finishedTime": null,
  123. "winitProductCode": "OSF810556",
  124. "postal": "45701",
  125. "countryName": "德国",
  126. "cBpartnerId": 1000019,
  127. "status": "CF"
  128. }
  129. ]
  130. }
  131. }