API
查询总库存(含DOI)
更新时间: 2023-04-12 15:06:00 访问次数:19055

接口说明

通过本接口用户可以查询指定海外仓的所有商品最近7天 、15天、30天的库存情况,以及ROI数据。

DOI 全英文拼写是(Days of Inventory),DOI计算方式=近30天日均库存数/近30天日均销售数量(以一国一仓为统计单位,即按照客户在同一国家使用的所有仓库库存记录统计)

  • DOI值越小 周转率越高
  • DOI值越大 周转率越差低

查询退货商品时,将按照退货RM码关联的SKU进行返回。比如:RM1和RM2都关联SKU01,则返回SKU01,库存2

接口名称

queryProductInventoryList4Page

请求说明

请求内容 说明
URL https://openapi.winit.com.cn/openapi/service
接口测试 https://sandboxopenapi.winit.com.cn/openapi/service
验证方法 Token,md5
格式 json
字符编码 UTF-8
http请求方式 http
请求数限制 默认每分钟200,有需要可申请加大。
接口版本version 1.0

请求入参

名称 类型 必填 说明 示例
DOITier String() N DOI层级: 1:30以下 2:30-60 3:60-90 4:90以上 1
inventoryType String(10) Y 库存类型:Country:国家,Warehouse:仓库 Country
isActive String(1) N 商品是否有效,Y/N Y
pageNum Integer(10) Y 页码 1
pageSize Integer(10) Y 每页显示数量 100
productCode String(510) N 商品编码 SKU1
name String(255) N 商品名称 MM
warehouseId String() Y 仓库ID,点击查询仓库ID 1000008
warehouseCode String() N 仓库Code,点击查询仓库Code DE0001
startTime String(20) N 库存变更开始时间
开始和结束时间跨度不能超过24小时
2020-01-01 00:00:0
endTime String(20) N 库存变更结束时间
开始和结束时间跨度不能超过24小时
2020-01-01 00:00:0

请求示例

  1. {
  2. "action": "queryProductInventoryList4Page",
  3. "app_key": "rebecca",
  4. "client_id":"ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2",
  5. "client_sign":"CC3F32A4D985B8176E22525F6ABD7FA1",
  6. "data": {
  7. "categoryID": "",
  8. "DOITier": "",
  9. "inventoryType": "Country",
  10. "isActive":"Y",
  11. "pageNum": "1",
  12. "pageSize": "100",
  13. "productCode": "",
  14. "name": "",
  15. "specification": "",
  16. "warehouseId": "",
  17. "warehouseCode": "DE0001"
  18. },
  19. "format": "json",
  20. "language": "zh_CN",
  21. "platform": "OWNERERP",
  22. "sign": "8AB9BE71E5C0C9DBC5471327250B8A2C",
  23. "sign_method": "md5",
  24. "timestamp": "2015-06-16 00:19:26",
  25. "version": "1.0"
  26. }

返回出参

名称 类型 必填 说明 示例
version String() Y 版本号
productCode String() Y 商品编码
specification String() Y 商品规格
description String() Y 商品描述,已停用
name String() Y 商品中文名字
eName String() Y 商品英文名字
specification String() N 规格
warehouseName String() Y 仓库名称
warehouseCode String() Y 仓库code
verageSalesQty String() Y 近30天平均销量
averageSalesQty7 String() Y 近7天平均销量
averageSalesQty15 String() Y 近15天平均销量
averageStockQty String() Y 近30天平均库存
averageStockQty7 String() Y 近7天平均库存
averageStockQty15 String() Y 近15天平均库存
qtyHisOut String() Y 历史出库
qtyHisIn String() Y 历史入库
DOI String() Y DOI
DOIAll String() Y 全部的DOI
avgSales String() Y 平均销量
isReturnInventory String() Y 是否退货库存
qtyOrdered String() Y 在途库存
qtyReserved String() Y 待出库
待出库=出库订单占用+冻结库存+丢失确认中
inStockQty String() Y 在库总库存
在库总库存=可用+待发+丢失确认中+冻结+待销毁+失效VAT冻结+禁止出库
qtyAvailable String() Y 可用
qtyWaitOut String() Y 待发:出库订单对应的商品出库数量(排除销毁出库数量),以及调拨单或库存调整单商品出库数量
qtyLostConfirming String() Y 丢失确认中
qtyFrozen String() Y 冻结
qtyDestruction String() Y 待销毁数量
prohibitFrozenQty String() Y 失效VAT冻结
isprohibitoutbound String() Y 是否禁止出库
prohibitUsableQty String() Y 禁止库存数量
preSaleWaitOutQty String() Y 预售待发:预售出库单占用库存
需开通相关预售订单权限

已停用字段:qtySellHisOut历史代销量、qtySw存储仓库存、qtyShareStorage共享库存

返回示例

  1. {
  2. "code": 0,
  3. "msg": "操作成功",
  4. "data": {
  5. "page": {
  6. "TotalRows": 95,
  7. "NumRows": 100,
  8. "StartRow": 1
  9. },
  10. "list": [
  11. {
  12. "qtyAvailable": "0",
  13. "description": null,
  14. "qtyFrozen": 0,
  15. "warehouseName": "DE Warehouse",
  16. "warehouseCode": "DE0001",
  17. "qtyDestruction": 0,
  18. "averageStockQty7": "",
  19. "prohibitFrozenQty": "0",
  20. "qtySellHisOut": 0,
  21. "qtySw": "0",
  22. "averageSalesQty7": "",
  23. "qtyLostConfirming": 0,
  24. "qtyHisIn": "0",
  25. "qtyHisOut": "0",
  26. "qtyWaitOut": "0",
  27. "preSaleWaitOutQty": "0",
  28. "DOI": "",
  29. "productId": "HDMI 2M White数据线白色",
  30. "eName": "cable",
  31. "averageStockQty15": "",
  32. "qtyShareStorage": 0,
  33. "DOIAll": "",
  34. "specification": "数据线白色",
  35. "averageSalesQty15": "",
  36. "avgSales": 0,
  37. "averageSalesQty": "",
  38. "version": "20170818204339558",
  39. "inStockQty": "0",
  40. "prohibitUsableQty": 0,
  41. "isReturnInventory": "N",
  42. "productCode": "HDMI 2M White",
  43. "qtyReserved": "0",
  44. "warehouseId": "1000089",
  45. "qtyOrdered": "0",
  46. "name": "数据线HDMI白色",
  47. "isprohibitoutbound": "N",
  48. "averageStockQty": ""
  49. },
  50. {
  51. "qtyAvailable": "0",
  52. "description": null,
  53. "qtyFrozen": 0,
  54. "warehouseName": "DE Warehouse",
  55. "warehouseCode": "DE0001",
  56. "qtyDestruction": 0,
  57. "averageStockQty7": "",
  58. "prohibitFrozenQty": "0",
  59. "qtySellHisOut": 0,
  60. "qtySw": "0",
  61. "averageSalesQty7": "",
  62. "qtyLostConfirming": 0,
  63. "qtyHisIn": "0",
  64. "qtyHisOut": "0",
  65. "qtyWaitOut": "0",
  66. "preSaleWaitOutQty": "0",
  67. "DOI": "",
  68. "productId": "SKU1",
  69. "eName": "BB",
  70. "averageStockQty15": "",
  71. "qtyShareStorage": 0,
  72. "DOIAll": "",
  73. "specification": null,
  74. "averageSalesQty15": "",
  75. "avgSales": 0,
  76. "averageSalesQty": "",
  77. "version": "1489807176227",
  78. "inStockQty": "0",
  79. "prohibitUsableQty": 0,
  80. "isReturnInventory": "N",
  81. "productCode": "SKU1",
  82. "qtyReserved": "0",
  83. "warehouseId": "1000089",
  84. "qtyOrdered": "0",
  85. "name": "MM",
  86. "isprohibitoutbound": "N",
  87. "averageStockQty": ""
  88. }
  89. ]
  90. }
  91. }