任务描述
暂无
需求描述

1、顶部请选择销售人员,过滤掉已离职的人员
2、增加系统SKU看板按钮
点击弹出系统SKU看板

1、功能按钮
添加系统SKU:点击添加系统SKU,弹出添加SKU弹窗,防止一些SKU没有统计出来,手动添加的系统SKU,来源于系统SKU开发管理
剔除系统SKU:点击剔除系统SKU,弹出剔除SKU弹窗,剔除一些统计出来的SKU,手动添加的系统SKU,(因为统计进来的SKU会包含已转到其他部门,有品不在销售,因为系统没有这个操作,他们都是线下统计的,所以需要加一个剔除功能)
通知设置:点击通知设置,弹出通知设置弹窗,用于通知设置
消息记录:点击消息记录,弹出消息记录弹窗,用于查看通知消息记录
2、顶部信息展示
1、首先要确定有品SKU的范围(我的listing已经匹配的系统SKU和产品开发管理中添加人员或者开发人员是深圳智汇创想网络科技有限公司》智汇有品事业部品牌》产品部下的人员的系统SKU)
2、剔除包材和配件
在线SKU数量:虎鲸listing在线状态的 SKU数
有库存sku数量:
本地仓:可用库存大于0,
海外仓:(可用库存+运输中)大于0
FBA库存:(可售+FBA在途)大于0
在售sku数量:(FBA可用库存+在途)大于0

重要老品在售SKU数量:产品属性是重要老品的SKU且(FBA可用库存+在途)大于0

清库产品在售SKU数量:产品属性是清库产品的SKU且(FBA可用库存+在途)大于0

年度新品在售SKU数量:产品属性是年度新品的SKU且(FBA可用库存+在途)大于0


未配对渠道SKU的SKU数量:属于有品部门的系统SKU,但没有在我的listing存在的系统SKU

3、搜索功能
产品状态:下拉可多选,默认为空(在线SKU数量、有库存sku数量、在售sku数量、重要老品在售SKU数量、清库产品在售SKU数量、年度新品在售SKU数量、未配对渠道SKU的SKU数量)

系统SKU:可根据系统SKU和产品名称搜索,产品名称的批量查询只支持精确查询

点击导出数量:数据下载到下载中心

导出字段:

数据列表:剔除功能,点击剔除,弹出是否剔除该系统SKU,点击确定后,该SKU就不属于有品的,以后不在统计出来
点击取消,不做任何变动

验收标准
暂无
历史记录  
  1. 2023-06-07 18:22:35, 由 许瑞丰 创建。
  2. 2023-06-07 18:24:05, 由 李忠红 指派给 张明磊。
    修改了 指派给,旧值为 "lizhonghong",新值为 "zhangminglei"。
  3. 2023-06-14 15:34:33, 由 张明磊 启动。
    修改了 实际开始,旧值为 "0000-00-00 00:00:00",新值为 "2023-06-14 15:34:32"。
    修改了 任务状态,旧值为 "wait",新值为 "doing"。
  4. 2023-06-16 11:47:04, 由 张明磊 添加备注。

    添加或剔除SKU 0-添加 1-移除

    http://localhost:56002/instant/Product/ModifyProductSkus

    {
        "input": {
            "Items": [
                "7685854"
            ],
            "Type": 0
        },
        "language": "zh_cn"

    }


  5. 2023-06-16 11:53:41, 由 张明磊 添加备注。

    获取sku数据列表SearchType-0系统SKU,1-产品名称

    排序字段{ "localGoodNum", "processingNum", "overseaGoodNum", "overseaTransitNum", "fbaGoodNum", "fbaTransitNum" }

    http://localhost:56002/instant/Product/Search

    {
        "current": 1,
        "pageSize": 20,
        "orderBy": {
            "field": "localGoodNum",
            "order": 1
        },
        "input": {
            "SearchTest": [
            ],
            "SearchType": "1"
        },
        "language": "zh_cn"
    }

    回参

    {
        "data": {
            "list": [
                {
                    "sku": "1854300",
                    "brand": "TINKSKY",
                    "title": "TINKSKY 挂钩衣架 4钩 黑色 3个每套",
                    "imageUrl": "https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/1854300/2019-03-20/0c7e54e66198492eb57305108025155f/9506eaa7-ae94-42a1-8213-6c71a324a7c7.jpg",
                    "typeName": "在售SKU",
                    "localStockList": [
                        {
                            "warehouseName": "中国东莞1号仓库",
                            "quantity": [
                                0,
                                6988
                            ]
                        }
                    ],
                    "overseaStockList": [],
                    "fbaTransitNum": 0,
                    "fbaStockList": [
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                2,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                1543,
                                0
                            ]
                        }
                    ],
                    "orderSources": [
                        {
                            "oderSourceName": "Amazon-Z01119-US",
                            "channelPlatformStatus": 0
                        }
                    ]
                },
                {
                    "sku": "1854300",
                    "brand": "TINKSKY",
                    "title": "TINKSKY 挂钩衣架 4钩 黑色 3个每套",
                    "imageUrl": "https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/1854300/2019-03-20/0c7e54e66198492eb57305108025155f/9506eaa7-ae94-42a1-8213-6c71a324a7c7.jpg",
                    "typeName": "有库存SKU",
                    "localStockList": [
                        {
                            "warehouseName": "中国东莞1号仓库",
                            "quantity": [
                                0,
                                6988
                            ]
                        }
                    ],
                    "overseaStockList": [],
                    "fbaTransitNum": 0,
                    "fbaStockList": [
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                2,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                1543,
                                0
                            ]
                        }
                    ],
                    "orderSources": [
                        {
                            "oderSourceName": "Amazon-Z01119-US",
                            "channelPlatformStatus": 0
                        }
                    ]
                },
                {
                    "sku": "1854300",
                    "brand": "TINKSKY",
                    "title": "TINKSKY 挂钩衣架 4钩 黑色 3个每套",
                    "imageUrl": "https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/1854300/2019-03-20/0c7e54e66198492eb57305108025155f/9506eaa7-ae94-42a1-8213-6c71a324a7c7.jpg",
                    "typeName": "在线SKU",
                    "localStockList": [
                        {
                            "warehouseName": "中国东莞1号仓库",
                            "quantity": [
                                0,
                                6988
                            ]
                        }
                    ],
                    "overseaStockList": [],
                    "fbaTransitNum": 0,
                    "fbaStockList": [
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                2,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01119-US)",
                            "quantity": [
                                1543,
                                0
                            ]
                        }
                    ],
                    "orderSources": [
                        {
                            "oderSourceName": "Amazon-Z01119-US",
                            "channelPlatformStatus": 0
                        }
                    ]
                },
                {
                    "sku": "15453363",
                    "brand": "COSLUS",
                    "title": "Coslus可视耳镜 黑色",
                    "imageUrl": "https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/ProductImages/15453363/2022/10/26/a20f6e0681f54aa1b9c99dd6b0cf445e/b35f6539-9708-4cc0-ccd8-4182dde01832.jpg",
                    "typeName": "有库存SKU",
                    "localStockList": [
                        {
                            "warehouseName": "中国东莞3号仓库(退税仓)",
                            "quantity": [
                                0,
                                3920
                            ]
                        }
                    ],
                    "overseaStockList": [
                        {
                            "warehouseName": "易可达澳洲仓",
                            "quantity": [
                                0,
                                28
                            ]
                        }
                    ],
                    "fbaTransitNum": 6924,
                    "fbaStockList": [
                        {
                            "warehouseName": null,
                            "quantity": [
                                0,
                                1320
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-US)",
                            "quantity": [
                                252,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01513-US)",
                            "quantity": [
                                2685,
                                4484
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-US)",
                            "quantity": [
                                2074,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01537-UK)",
                            "quantity": [
                                1038,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-UK)",
                            "quantity": [
                                135,
                                1120
                            ]
                        }
                    ],
                    "orderSources": [
                        {
                            "oderSourceName": "Amazon-Z01513-US",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01537-UK",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-UK",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-DE",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-US",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01813-UK",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01813-DE",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01813-IT",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01813-US",
                            "channelPlatformStatus": 0
                        }
                    ]
                },
                {
                    "sku": "15453363",
                    "brand": "COSLUS",
                    "title": "Coslus可视耳镜 黑色",
                    "imageUrl": "https://irobotbox-hd1.oss-cn-hangzhou.aliyuncs.com/1/ProductImages/15453363/2022/10/26/a20f6e0681f54aa1b9c99dd6b0cf445e/b35f6539-9708-4cc0-ccd8-4182dde01832.jpg",
                    "typeName": "在线SKU",
                    "localStockList": [
                        {
                            "warehouseName": "中国东莞3号仓库(退税仓)",
                            "quantity": [
                                0,
                                3920
                            ]
                        }
                    ],
                    "overseaStockList": [
                        {
                            "warehouseName": "易可达澳洲仓",
                            "quantity": [
                                0,
                                28
                            ]
                        }
                    ],
                    "fbaTransitNum": 6924,
                    "fbaStockList": [
                        {
                            "warehouseName": null,
                            "quantity": [
                                0,
                                1320
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-US)",
                            "quantity": [
                                252,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01513-US)",
                            "quantity": [
                                2685,
                                4484
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-US)",
                            "quantity": [
                                2074,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01537-UK)",
                            "quantity": [
                                1038,
                                0
                            ]
                        },
                        {
                            "warehouseName": "亚马逊FBA仓库(Amazon-Z01761-UK)",
                            "quantity": [
                                135,
                                1120
                            ]
                        }
                    ],
                    "orderSources": [
                        {
                            "oderSourceName": "Amazon-Z01513-US",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01537-UK",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-UK",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-DE",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01761-US",
                            "channelPlatformStatus": 0
                        },
                        {
                            "oderSourceName": "Amazon-Z01813-UK",
                            "channelPlatformStatus": 0
       
  6. 2023-06-16 11:54:52, 由 张明磊 完成。
    修改了 总计消耗,旧值为 "0",新值为 "8"。
    修改了 指派给 ,旧值为 "zhangminglei",新值为 "xuruifeng"。
    修改了 实际完成,旧值为 "",新值为 "2023-06-16 11:54:47"。
    修改了 任务状态,旧值为 "doing",新值为 "done"。
    修改了 预计剩余,旧值为 "8",新值为 "0"。
    修改了 由谁完成,旧值为 "",新值为 "zhangminglei"。
  7. 2023-10-31 14:55:55, 由 周杰 关闭。
    修改了 任务状态,旧值为 "done",新值为 "closed"。
    修改了 指派给 ,旧值为 "xuruifeng",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "zhoujie"。
    修改了 关闭时间,旧值为 "0000-00-00 00:00:00",新值为 "2023-10-31 14:55:55"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
所属迭代 虎鲸-亚马逊运营
所属模块 /
相关需求 虎鲸-我的listing:增加一个系统SKU看板
指派给 Closed 于 2023-10-31 14:55:55
任务类型 后端
任务标签 初始
开发组 多平台开发组
任务状态 已关闭
进度 100%
优先级 P2
关键词
抄送给
由谁创建 许瑞丰 于 2023-06-07 18:22:35
由谁完成 张明磊 于 2023-06-16 11:54:47
由谁取消 暂无
由谁关闭 周杰 于 2023-10-31 14:55:55
关闭原因 已完成
最后编辑 周杰 于 2023-10-31 14:55:55
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 8工时
总计消耗 8工时
预计剩余 0工时
预计开始 2023-06-07
实际开始 2023-06-14
截止日期 2023-06-20