查询库存流水
更新时间: 2025-07-18 11:07:03 访问次数:8976
接口说明
本接口支持卖家查询库存流水,通过winit商品编码、仓库编码、订单类型查询具体的商品的库存流水
接口名称
winit.inventory.pageInvInouts
请求说明
| 请求内容 | 说明 |
|---|---|
| URL | https://openapi.winit.com.cn/openapi/service |
| 接口测试 | https://sandboxopenapi.winit.com.cn/openapi/service |
| 验证方法 | Token,md5 |
| 格式 | json |
| 字符编码 | UTF-8 |
| http请求方式 | http |
| 请求数限制 | 默认每分钟1000,1000有需要可申请加大。 |
请求入参
| 名称 | 类型 | 必填 | 说明 | 示例 |
|---|---|---|---|---|
| skuCode | String(120) | Y | 商品编码 | auto_sku22 |
| specification | varchar(255) | N | 商品规格 | 1000008 |
| warehouseCode | varchar(50) | Y | 仓库编码 | DE0001 |
| docType | varchar(30) | N | 订单类型 入库:INBOUND 出库:OUTBOUND 调整:ADJUSTMENT 调拨出库:ALLOCATION_OUT 调拨入库:ALLOCATION_IN 退货入库:INBOUND_RETURN 直发入库:INBOUND_OVERSEAS |
INBOUND |
| docNo | String(30) | N | 单据号 支持:Winit入库单号、出库单号、退货单号、调整单号、增值单号等 注意:非必传,支持不入参其他信息仅按单据号查询;当不按单据号查时,其他必填字段需传值 |
W000003345 |
| startDate | String() | Y | 起始日期 | 2020-12-01 |
| endDate | String() | Y | 截止日期 日期范围最大支持31天 |
2020-01-01 |
| pageVo | Object | Y | 页码,以下为pageVo的子节点 | |
| - pageNo | Integer(10) | Y | 页码 | |
| - pageSize | Integer(10) | Y | 每页显示数量 |
请求示例
{"action": "winit.inventory.pageInvInouts","app_key": "rebecca","client_id": "ODJKMDU1YZCTYJQ5YY00ZWZLLTK5N2QTOWY4MZI5OGMWNDG2","data": {"skuCode": "auto_sku22","specification": "","warehouseCode": "US0001","docType": "INBOUND","startDate": "2020-05-01","endDate": "2020-05-08","pageVo": {"pageNo": "1","pageSize": "10"}},"format": "json","language": "zh_CN","sign": "500BF5382C3928E94008DF5149BB396B","sign_method": "md5","platform": "OWNERERP","timestamp": "2015-06-16 00:19:26","version": "1.0","client_sign": "2680F6DC6FC4791758548F2246C956B7"}
返回出参
返回参数说明:正确的返回编码code:0及结果data,错误的返回错误码及错误信息msg。
| 名称 | 类型 | 必传 | 说明 | 示例 |
|---|---|---|---|---|
| skuCode | String(120) | Y | 商品编码 | |
| merchandiseSerno | String(100) | Y | 商品条码 | |
| specification | String(255) | Y | 规格 | |
| warehouseCode | varchar(50) | Y | 仓库编码 | |
| docType | varchar(30) | Y | 订单类型 | |
| docNo | varchar(100) | Y | 订单号 | |
| cnName | String(255) | Y | 中文名称 | |
| name | String(255) | Y | 英文名称 | |
| startQty | INT | Y | 期初数量 | |
| endQty | INT | Y | 期末数量 | |
| changeQty | INT | Y | 变动数量 | |
| changeDate | DATE | Y | 变动日期 | |
| remark | varchar(200) | Y | 备注 | |
| merchandiseGrade | String(255) | Y | 商品等级 | |
| uuid | String(255) | Y | UUID 数据唯一ID |
返回示例
{"code": "0","msg": "操作成功","data": {"pageParams": {"pageNo": 1,"pageSize": 10,"totalCount": 2},"list": [{"skuCode": "auto_sku22","merchandiseSerno": "M010000000001674549","specification": "","warehouseCode": "US0001","customerName": null,"docType": "INBOUND","docNo": "WI9900012414","cnName": "api自动化商品002","name": "auto_sku22","startQty": 768,"endQty": 770,"changeQty": 2,"changeDate": "2020-05-06 16:26:43","remark": "标准入库","provideChannel": null,"salesChannel": null,"merchandiseGrade": "GOOD","serviceType": "2C","unit": null,"batchInfoVo": null},{"skuCode": "auto_sku22","merchandiseSerno": "M010000000001674549","specification": "","warehouseCode": "US0001","customerName": null,"docType": "INBOUND","docNo": "WI9900012426","cnName": "api自动化商品002","name": "auto_sku22","startQty": 770,"endQty": 772,"changeQty": 2,"changeDate": "2020-05-06 16:27:37","remark": "国内直发入库","provideChannel": null,"salesChannel": null,"merchandiseGrade": "GOOD","uuid": "0020011asxdfa1",}]}}
