库存流水查询
更新时间: 2023-08-18 15:42:52 访问次数:7000
接口说明
本接口支持卖家查询库存流水,通过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 |
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 | 商品等级 | |
serviceType | String(255) | Y | 库存类型 | |
unit | String(255) | Y | 库存单位 | |
provideChannel | String(255) | Y | 供应渠道 | |
salesChannel | String(255) | Y | 销售渠道 |
返回示例
{
"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
}
]
}
}