业务需求
需求描述

需求背景:排查刊登错误数据时发现亚马逊会通过一个错误提醒刊登类目不准确,核查确实存在类目错误的情况,需要导出这份数据,让上架部进行校验,并用于后续的多站点映射数据


需求实现:

1.遍历所有末节点,获取模版信息中的product_type保存到一个临时表

2.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)

【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to COSTUME_EYEWEAR. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.


3.通过刊登SKU获取主类目,再获取多站点的映射类目

4.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径

验收标准
价值描述
提升类目映射准确度
历史记录  
  1. 2024-01-26 10:41:13, 由 戴宝山 创建。
  2. 2024-01-26 10:41:23, 由 戴宝山 编辑。
    修改了 所属计划,旧值为 "",新值为 "586"。
    修改了 所处阶段,旧值为 "wait",新值为 "planned"。
  3. 2024-01-26 10:46:12, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "1",新值为 "2"。
    修改了 需求描述,区别为:
    004- 1.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)
    004+ 1.遍历所有末节点,获取模版信息中的product_type保存到一个临时表
    005- 【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to COSTUME_EYEWEAR. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.
    005+ 2.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)
    006-
    006+ 【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to COSTUME_EYEWEAR. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.
    007- 2.通过刊登SKU获取主类目,再获取多站点的映射类目
    007+
    008- 3.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径
    008+ 3.通过刊登SKU获取主类目,再获取多站点的映射类目
    009+ 4.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径
    004- <p>1.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)</p>
    004+ <p>1.遍历所有末节点,获取模版信息中的product_type保存到一个临时表</p>
    005- <p>【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to <span style="color:#E53333;">COSTUME_EYEWEAR</span>. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.</p>
    005+ <p>2.导出近3个月errorcode包含18367的数据,从错误msg里面解析出建议的product_type(标红部分),并通过product_type反查出该站点的有效类目(必须是末节点,如果有多个取第一个)</p>
    006- <p><br /></p>
    006+ <p>【Warning】Having the most applicable product type for a product enhances both the seller and customer experiences; therefore, we have amended the product_type of your submission from DECORATIVE_CUTOUT to <span style="color:#E53333;">COSTUME_EYEWEAR</span>. To remove the warning attached to your product, simply accept our suggested Product Type and resubmit the SKU. Alternatively, if the original Product Type you selected is correct, you may change the SKU attributes, such as title, product description, and bullet points, so that your product more clearly matches that original Product Type. If you feel both the Product Type you had selected and the original SKU attributes are correct, please contact seller support.. To remove the warning attached to your product, simply accept our suggested product type and resubmit the SKU. Alternatively, if the original product type you selected is correct, you can change the SKU attributes such as title, product description and bullet points, so that your product matches the original product type more closely. If you feel both the product type you had selected and the original SKU attributes are correct, please contact Seller Support/Selling Partner Support.</p>
    007- <p>2.通过刊登SKU获取主类目,再获取多站点的映射类目</p>
    007+ <p><br /></p>
    008- <p>3.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径</p>
    008+ <p>3.通过刊登SKU获取主类目,再获取多站点的映射类目</p>
    009+ <p>4.最终数据按照主类目+站点维度去重,导出数据,导出字段包括:主类目、站点、映射类目全路径、映射类目ID全路径、亚马逊推荐类目全路径,亚马逊推荐类目ID全路径</p>
  4. 2024-01-29 15:47:29, 由 徐盛松 记录评审结果,结果为 确认通过。
    修改了 评审时间,旧值为 "0000-00-00",新值为 "2024-01-29"。
    修改了 指派给 ,旧值为 "laoxu",新值为 "daibaoshan"。
    修改了 当前状态,旧值为 "draft",新值为 "active"。
    修改了 由谁评审,旧值为 "",新值为 "laoxu"。
  5. 2024-01-29 16:01:01, 由 戴宝山 编辑。
    修改了 指派给,旧值为 "daibaoshan",新值为 "luoyoujun"。
  6. 2024-01-30 12:28:09, 由 商雷 关联到迭代 智能中心-智能刊登迭代 。
  7. 2024-02-27 11:10:21, 由 商雷 指派给 陈丽婷。
    修改了 指派给,旧值为 "luoyoujun",新值为 "chenliting"。
    分支提测
  8. 2024-02-27 16:03:56, 由 陈丽婷 指派给 程宽。
    修改了 指派给,旧值为 "chenliting",新值为 "chengkuan"。
  9. 2024-03-01 18:45:19, 由 刘霞 编辑。
    修改了 关键词,旧值为 "",新值为 "战略2024年3月5日"。
  10. 2024-03-05 17:27:31, 由 程宽 指派给 商雷。
    修改了 指派给,旧值为 "chengkuan",新值为 "shanglei"。
    测试通过
  11. 2024-03-05 18:14:11, 由 商雷 指派给 程宽。
    修改了 指派给,旧值为 "shanglei",新值为 "chengkuan"。
    主干提测
  12. 2024-03-05 18:53:03, 由 程宽 指派给 商雷。
    修改了 指派给,旧值为 "chengkuan",新值为 "shanglei"。
    测试通过
  13. 2024-03-05 19:28:34, 由 商雷 指派给 程宽。
    修改了 指派给,旧值为 "shanglei",新值为 "chengkuan"。
    已上线
  14. 2024-03-06 15:42:01, 由 程宽 添加备注。


  15. 2024-03-06 15:42:08, 由 程宽 指派给 戴宝山。
    修改了 指派给,旧值为 "chengkuan",新值为 "daibaoshan"。
  16. 2024-03-12 16:33:45, 由 刘霞 编辑。
    修改了 成本 ,旧值为 "4000",新值为 "2750"。
    修改了 ROI ,旧值为 "0.25",新值为 "0.36"。
    修改了 预计工时,旧值为 "16",新值为 "11"。
  17. 2024-03-22 16:49:00, 由 戴宝山 关闭,原因为 已完成 。
    修改了 关闭原因,旧值为 "",新值为 "done"。
    修改了 当前状态,旧值为 "active",新值为 "closed"。
    修改了 指派给 ,旧值为 "daibaoshan",新值为 "closed"。
    修改了 所处阶段,旧值为 "tested",新值为 "closed"。
    修改了 关闭日期,旧值为 "0000-00-00 00:00:00",新值为 "2024-03-22 16:49:00"。
    修改了 由谁关闭,旧值为 "",新值为 "daibaoshan"。
迭代版本
提报业务部门
提报人员 戴宝山
需求来源 产品自主提报需求
所属项目 智能中心-需求池
所属模块 战略独立项目   智能刊登
所属计划
业务价值 中心战略层
开发组 财务开发组
受益业务部门 亚马逊平台运营中心
验收人员 黄丽萍
业务目标类型 其他
中心业务目标 其他
业务价值
每月价值量 1000
每月节省人数 0
优先级 P1
价值类型 长期价值
预计工时 11
成本 5500
ROI 1.09
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间
更新点
是否高危
评分
当前状态 已关闭
所处阶段 已关闭
关键词 战略2024年3月5日
评审次数 一次
计划上线
上线时间 2024-01-31
计划验收时间 2024-01-31
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给
由谁创建 戴宝山 于 2024-01-26 10:41:13
指派给 Closed 于 2024-03-22 16:49:00
由谁评审 徐盛松
评审时间 2024-01-29
由谁关闭 戴宝山 于 2024-03-22 16:49:00
关闭原因 已完成
最后修改 戴宝山 于 2024-03-22 16:49:00