API
库存流水查询
更新时间： 2021-01-27 17:26:18 访问次数：3666
接口说明
本接口支持卖家查询库存流水，通过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，有需要可申请加大。 |
请求入参
<
tr>
| 名称 | 类型 | 必填 | 说明 | 示例 |
|---|---|---|---|---|
| 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 |
| startDate |
Y | 起始日期 | 2020-12-01 |
|
| endDate | Y | 截止日期 | 2020-01-01 | |
| 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": "19AFB1EDAB70909345AF736BF1B6FCDF",
"sign_method": "md5",
"platform": "OWNERERP",
"timestamp": "2015-06-16 00:19:26",
"version": "1.0",
"client_sign": "603AB31C90EC9F4C02A3CD07A754AF5A"
}
返回出参
| 名称 | 类型 | 必填 | 说明 | 示例 |
|---|---|---|---|---|
| 名称 | 类型 | 说明 | 示例 | |
| skuCode | String(120) | 商品编码 | ||
| merchandiseSerno | String(100) | 商品条码 | ||
| specification | String(255) | 规格 | ||
| warehouseCode | varchar(50) | 仓库编码 | ||
| customerName | varchar(20) | 客户名称 | ||
| docType | varchar(30) | 订单类型 | ||
| docNo | varchar(100) | 订单号 | ||
| cnName | String(255) | 中文名称 | ||
| name | String(255) | 英文名称 | ||
| startQty | INT | 期初数量 | ||
| endQty | INT | 期末数量 | ||
| changeQty | INT | 变动数量 | ||
| changeDate | DATE | 变动日期 | ||
| remark | varchar(200) | 备注 | ||
| provideChannel | String(255) | 供应渠道 | ||
| salesChannel | String(255) | 销售渠道 | ||
| merchandiseGrade | String(255) | 商品等级 | ||
| serviceType | String(255) | 库存类型 | ||
| unit | String(255) | 库存单位 |
错误的返回结果：错误码，错误信息
返回示例
{
"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",
"serviceType": "2C",
"unit": null,
"batchInfoVo": null
}
]
}
}
