业务需求
需求描述

需求背景：CA站点政策要求，带磁产品必须在产品描述中明确 13岁以下儿童不能使用，需要针对历史和增量数据做调整


需求实现：

1、增量数据，针对CA站点的SKU，满足以下任意一个条件，在刊登时需要在描述中增加提醒，放在Description的最后一段话


a、物流属性：

弱磁（查验）

弱磁

强磁


b.中文名称关键词：带有“磁”

c.英文名称关键词：带有 “Magnets" 或 “Magnet"

d主类目：

Home & Kitchen(家居、厨具、家装)>>Kitchen & Dining(厨房和餐厅)>>Kitchen Utensils & Gadgets(厨用小工具)>>Kitchen Accessories(厨房用具)>>Refrigerator Magnets(冰箱磁铁)

（类目ID：1055398,1063498,284507,289754,16439891,3737161）



2、历史数据

针对附件中的SKU，筛查CA的在线listing进行资料刷新，在原资料的基础上增加文案提醒。筛选条件

a、listing在线

b、近30天ASIN+市场维度无销量



提醒文案（刊登时从其中任选一个）

This product is not suitable for children aged 13 and below. 

Children under 13 years old should not use this product.

 This item is inappropriate for kids 13 years of age or younger.

 The use of this product is not recommended for children under 13. 

This product is intended for individuals over the age of 13. 

Kids who are 13 or younger are advised not to use this product. 

This product is unsuitable for anyone 13 years old or younger. 

Children below the age of 13 should avoid using this product. 

This product is not designed for children under 13 years of age. 

The use of this product is restricted to those over 13 years old.

 This product is not safe for children aged 13 and under. 

Children who are 13 or younger are not allowed to use this product.

 This product is not appropriate for use by children under 13. 

The use of this product is prohibited for children under 13 years old.

 This product is not meant for children who are 13 or younger.

 Children under the age of 13 are not permitted to use this product. 

This product is unsuitable for use by anyone under 13 years of age. 

The use of this product is not suitable for children under 13. 

This product is not recommended for children who are 13 or younger. 

Children aged 13 and below should not use this product.

验收标准
价值描述
降低店铺风险
历史记录  
  1. 2025-02-27 11:53:41, 由 戴宝山 创建。
  2. 2025-02-27 14:41:32, 由 戴宝山 变更。
    修改了 版本号 ，旧值为 "1"，新值为 "2"。
    修改了 需求描述，区别为：
    004- 1、增量数据，针对CA站点的SKU，满足以下任意一个条件，在刊登时需要在描述中增加提醒，放在Description的最后一段话
    004+ 1、增量数据，针对CA站点的SKU，满足以下任意一个条件，在刊登时需要在描述中增加提醒，放在Description的最后一段话
    005-
    005+
    006- a、物流属性：
    006+ a、物流属性：
    007-
    007+
    008- 弱磁（查验）
    008+ 弱磁（查验）
    009- 弱磁
    009+ 弱磁
    010- 强磁
    010+ 强磁
    011-
    011+ b.中文名称关键词：带有“磁”
    012- b.中文名称关键词：带有“磁”
    012+ c.英文名称关键词：带有 “Magnets" 或 “Magnet"
    013- c.英文名称关键词：带有 “Magnets" 或 “Magnet"
    013+ d主类目：
    014- d主类目：
    014+ Home & Kitchen(家居、厨具、家装)>>Kitchen & Dining(厨房和餐厅)>>Kitchen Utensils & Gadgets(厨用小工具)>>Kitchen Accessories(厨房用具)>>Refrigerator Magnets(冰箱磁铁)
    015- Home & Kitchen(家居、厨具、家装)>>Kitchen & Dining(厨房和餐厅)>>Kitchen Utensils & Gadgets(厨用小工具)>>Kitchen Accessories(厨房用具)>>Refrigerator Magnets(冰箱磁铁)
    015+ （类目ID：1055398,1063498,284507,289754,16439891,3737161）
    016- （类目ID：1055398,1063498,284507,289754,16439891,3737161）
    016+
    017-
    017+
    018-
    018+ 2、历史数据
    019-
    019+ 针对附件中的SKU，筛查CA的在线listing进行资料刷新，在原资料的基础上增加文案提醒。筛选条件
    020-
    020+ a、listing在线
    021- 提醒文案（刊登时从其中任选一个）
    021+ b、近30天ASIN+市场维度无销量
    022- This product is not suitable for children aged 13 and below.
    022+
    023- Children under 13 years old should not use this product.
    023+
    024- This item is inappropriate for kids 13 years of age or younger.
    024+ 提醒文案（刊登时从其中任选一个）
    025- The use of this product is not recommended for children under 13.
    025+ This product is not suitable for children aged 13 and below.
    026- This product is intended for individuals over the age of 13.
    026+ Children under 13 years old should not use this product.
    027- Kids who are 13 or younger are advised not to use this product.
    027+ This item is inappropriate for kids 13 years of age or younger.
    028- This product is unsuitable for anyone 13 years old or younger.
    028+ The use of this product is not recommended for children under 13.
    029- Children below the age of 13 should avoid using this product.
    029+ This product is intended for individuals over the age of 13.
    030- This product is not designed for children under 13 years of age.
    030+ Kids who are 13 or younger are advised not to use this product.
    031- The use of this product is restricted to those over 13 years old.
    031+ This product is unsuitable for anyone 13 years old or younger.
    032- This product is not safe for children aged 13 and under.
    032+ Children below the age of 13 should avoid using this product.
    033- Children who are 13 or younger are not allowed to use this product.
    033+ This product is not designed for children under 13 years of age.
    034- This product is not appropriate for use by children under 13.
    034+ The use of this product is restricted to those over 13 years old.
    035- The use of this product is prohibited for children under 13 years old.
    035+ This product is not safe for children aged 13 and under.
    036- This product is not meant for children who are 13 or younger.
    036+ Children who are 13 or younger are not allowed to use this product.
    037- Children under the age of 13 are not permitted to use this product.
    037+ This product is not appropriate for use by children under 13.
    038- This product is unsuitable for use by anyone under 13 years of age.
    038+ The use of this product is prohibited for children under 13 years old.
    039- The use of this product is not suitable for children under 13.
    039+ This product is not meant for children who are 13 or younger.
    040- This product is not recommended for children who are 13 or younger.
    040+ Children under the age of 13 are not permitted to use this product.
    041- Children aged 13 and below should not use this product.
    041+ This product is unsuitable for use by anyone under 13 years of age.
    042+ The use of this product is not suitable for children under 13.
    043+ This product is not recommended for children who are 13 or younger.
    044+ Children aged 13 and below should not use this product.
    004- <p>1、增量数据，针对CA站点的SKU，满足以下任意一个条件，在刊登时需要在描述中增加提醒，放在<span>Description的最后一段话</span> </p>
    004+ <p>1、<strong>增量数据</strong>，针对CA站点的SKU，满足以下任意一个条件，在刊登时需要在描述中增加提醒，放在<span>Description的最后一段话</span> </p>
    005- <p>
    005+ <p><br /></p>
    006- </p><p><span>a、物流属性：</span></p>
    006+ <p><span>a、物流属性：</span></p>
    007- <p><span>
    007+ <p><span> </span></p>
    008- </span></p><p><span>弱磁（查验）</span> </p>
    008+ <p><span>弱磁（查验）</span> </p>
    009- <p><span>弱磁</span> </p>
    009+ <p><span>弱磁</span> </p>
    010- <p><span>强磁</span> </p>
    010+ <p><span>强磁</span> </p>
    011- <br />
    011+ <br /><p><span>b.中文名称关键词：带有“磁”</span> </p>
    012- <p><span>b.中文名称关键词：带有“磁”</span> </p>
    012+ <p><span>c.英文名称关键词：带有 “Magnets" 或 “Magnet"</span> </p>
    013- <p><span>c.英文名称关键词：带有 “Magnets" 或 “Magnet"</span> </p>
    013+ <p><span>d主类目：<br /></span></p>
    014- <p><span>d主类目：<br /></span></p>
    014+ <p><span>Home &amp; Kitchen(家居、厨具、家装)&gt;&gt;Kitchen &amp; Dining(厨房和餐厅)&gt;&gt;Kitchen Utensils &amp; Gadgets(厨用小工具)&gt;&gt;Kitchen Accessories(厨房用具)&gt;&gt;Refrigerator Magnets(冰箱磁铁)<br /></span></p>
    015- <p><span>Home &amp; Kitchen(家居、厨具、家装)&gt;&gt;Kitchen &amp; Dining(厨房和餐厅)&gt;&gt;Kitchen Utensils &amp; Gadgets(厨用小工具)&gt;&gt;Kitchen Accessories(厨房用具)&gt;&gt;Refrigerator Magnets(冰箱磁铁)<br /></span></p>
    015+ <p>（类目ID：1055398,1063498,284507,289754,16439891,3737161）<span></span> </p>
    016- <p>（类目ID：1055398,1063498,284507,289754,16439891,3737161）<span></span> </p>
    016+ <p><br /></p>
    017-
    017+ <p><br /></p>
    018- <p><br /></p>
    018+ <p>2、历史数据</p>
    019- <p><br /></p>
    019+ <p>针对附件中的SKU，筛查CA的在线listing进行资料刷新，在原资料的基础上增加文案提醒。筛选条件</p>
    020- <p><br /></p>
    020+ <p>a、listing在线</p>
    021- <p>提醒文案（刊登时从其中任选一个）</p>
    021+ <p>b、近30天ASIN+市场维度无销量</p>
    022- <p><span style="color:#171A1D;">This product is not suitable for children aged 13 and below.</span></p>
    022+ <p><br /></p>
    023- <p><span style="color:#171A1D;">Children under 13 years old should not use this product.</span></p>
    023+ <p><br /></p>
    024- <p><span style="color:#171A1D;">This item is inappropriate for kids 13 years of age or younger.</span></p>
    024+ <p>提醒文案（刊登时从其中任选一个）</p>
    025- <p><span style="color:#171A1D;">The use of this product is not recommended for children under 13.</span></p>
    025+ <p><span style="color:#171A1D;">This product is not suitable for children aged 13 and below.</span></p>
    026- <p><span style="color:#171A1D;">This product is intended for individuals over the age of 13.</span></p>
    026+ <p><span style="color:#171A1D;">Children under 13 years old should not use this product.</span></p>
    027- <p><span style="color:#171A1D;">Kids who are 13 or younger are advised not to use this product.</span></p>
    027+ <p><span style="color:#171A1D;">This item is inappropriate for kids 13 years of age or younger.</span></p>
    028- <p><span style="color:#171A1D;">This product is unsuitable for anyone 13 years old or younger.</span></p>
    028+ <p><span style="color:#171A1D;">The use of this product is not recommended for children under 13.</span></p>
    029- <p><span style="color:#171A1D;">Children below the age of 13 should avoid using this product.</span></p>
    029+ <p><span style="color:#171A1D;">This product is intended for individuals over the age of 13.</span></p>
    030- <p><span style="color:#171A1D;">This product is not designed for children under 13 years of age.</span></p>
    030+ <p><span style="color:#171A1D;">Kids who are 13 or younger are advised not to use this product.</span></p>
    031- <p><span style="color:#171A1D;">The use of this product is restricted to those over 13 years old.</span></p>
    031+ <p><span style="color:#171A1D;">This product is unsuitable for anyone 13 years old or younger.</span></p>
    032- <p><span style="color:#171A1D;">This product is not safe for children aged 13 and under.</span></p>
    032+ <p><span style="color:#171A1D;">Children below the age of 13 should avoid using this product.</span></p>
    033- <p><span style="color:#171A1D;">Children who are 13 or younger are not allowed to use this product.</span></p>
    033+ <p><span style="color:#171A1D;">This product is not designed for children under 13 years of age.</span></p>
    034- <p><span style="color:#171A1D;">This product is not appropriate for use by children under 13.</span></p>
    034+ <p><span style="color:#171A1D;">The use of this product is restricted to those over 13 years old.</span></p>
    035- <p><span style="color:#171A1D;">The use of this product is prohibited for children under 13 years old.</span></p>
    035+ <p><span style="color:#171A1D;">This product is not safe for children aged 13 and under.</span></p>
    036- <p><span style="color:#171A1D;">This product is not meant for children who are 13 or younger.</span></p>
    036+ <p><span style="color:#171A1D;">Children who are 13 or younger are not allowed to use this product.</span></p>
    037- <p><span style="color:#171A1D;">Children under the age of 13 are not permitted to use this product.</span></p>
    037+ <p><span style="color:#171A1D;">This product is not appropriate for use by children under 13.</span></p>
    038- <p><span style="color:#171A1D;">This product is unsuitable for use by anyone under 13 years of age.</span></p>
    038+ <p><span style="color:#171A1D;">The use of this product is prohibited for children under 13 years old.</span></p>
    039- <p><span style="color:#171A1D;">The use of this product is not suitable for children under 13.</span></p>
    039+ <p><span style="color:#171A1D;">This product is not meant for children who are 13 or younger.</span></p>
    040- <p><span style="color:#171A1D;">This product is not recommended for children who are 13 or younger.</span></p>
    040+ <p><span style="color:#171A1D;">Children under the age of 13 are not permitted to use this product.</span></p>
    041- <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
    041+ <p><span style="color:#171A1D;">This product is unsuitable for use by anyone under 13 years of age.</span></p>
    042+ <p><span style="color:#171A1D;">The use of this product is not suitable for children under 13.</span></p>
    043+ <p><span style="color:#171A1D;">This product is not recommended for children who are 13 or younger.</span></p>
    044+ <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
  3. 2025-02-27 14:42:56, 由 戴宝山 变更。
    修改了 指派给 ，旧值为 "daibaoshan"，新值为 "laoxu"。
    修改了 版本号 ，旧值为 "2"，新值为 "3"。
    修改了 需求描述，区别为：
    022-
    022+ c、先刷纯自发货的数据，再刷FBA
    024- 提醒文案（刊登时从其中任选一个）
    024+ 需要多次刷新配合业务测试！
    025- This product is not suitable for children aged 13 and below.
    025+
    026- Children under 13 years old should not use this product.
    026+ 提醒文案（刊登时从其中任选一个）
    027- This item is inappropriate for kids 13 years of age or younger.
    027+ This product is not suitable for children aged 13 and below.
    028- The use of this product is not recommended for children under 13.
    028+ Children under 13 years old should not use this product.
    029- This product is intended for individuals over the age of 13.
    029+ This item is inappropriate for kids 13 years of age or younger.
    030- Kids who are 13 or younger are advised not to use this product.
    030+ The use of this product is not recommended for children under 13.
    031- This product is unsuitable for anyone 13 years old or younger.
    031+ This product is intended for individuals over the age of 13.
    032- Children below the age of 13 should avoid using this product.
    032+ Kids who are 13 or younger are advised not to use this product.
    033- This product is not designed for children under 13 years of age.
    033+ This product is unsuitable for anyone 13 years old or younger.
    034- The use of this product is restricted to those over 13 years old.
    034+ Children below the age of 13 should avoid using this product.
    035- This product is not safe for children aged 13 and under.
    035+ This product is not designed for children under 13 years of age.
    036- Children who are 13 or younger are not allowed to use this product.
    036+ The use of this product is restricted to those over 13 years old.
    037- This product is not appropriate for use by children under 13.
    037+ This product is not safe for children aged 13 and under.
    038- The use of this product is prohibited for children under 13 years old.
    038+ Children who are 13 or younger are not allowed to use this product.
    039- This product is not meant for children who are 13 or younger.
    039+ This product is not appropriate for use by children under 13.
    040- Children under the age of 13 are not permitted to use this product.
    040+ The use of this product is prohibited for children under 13 years old.
    041- This product is unsuitable for use by anyone under 13 years of age.
    041+ This product is not meant for children who are 13 or younger.
    042- The use of this product is not suitable for children under 13.
    042+ Children under the age of 13 are not permitted to use this product.
    043- This product is not recommended for children who are 13 or younger.
    043+ This product is unsuitable for use by anyone under 13 years of age.
    044- Children aged 13 and below should not use this product.
    044+ The use of this product is not suitable for children under 13.
    045+ This product is not recommended for children who are 13 or younger.
    046+ Children aged 13 and below should not use this product.
    022- <p><br /></p>
    022+ <p>c、先刷纯自发货的数据，再刷FBA</p>
    024- <p>提醒文案（刊登时从其中任选一个）</p>
    024+ <p>需要多次刷新配合业务测试！</p>
    025- <p><span style="color:#171A1D;">This product is not suitable for children aged 13 and below.</span></p>
    025+ <p><br /></p>
    026- <p><span style="color:#171A1D;">Children under 13 years old should not use this product.</span></p>
    026+ <p>提醒文案（刊登时从其中任选一个）</p>
    027- <p><span style="color:#171A1D;">This item is inappropriate for kids 13 years of age or younger.</span></p>
    027+ <p><span style="color:#171A1D;">This product is not suitable for children aged 13 and below.</span></p>
    028- <p><span style="color:#171A1D;">The use of this product is not recommended for children under 13.</span></p>
    028+ <p><span style="color:#171A1D;">Children under 13 years old should not use this product.</span></p>
    029- <p><span style="color:#171A1D;">This product is intended for individuals over the age of 13.</span></p>
    029+ <p><span style="color:#171A1D;">This item is inappropriate for kids 13 years of age or younger.</span></p>
    030- <p><span style="color:#171A1D;">Kids who are 13 or younger are advised not to use this product.</span></p>
    030+ <p><span style="color:#171A1D;">The use of this product is not recommended for children under 13.</span></p>
    031- <p><span style="color:#171A1D;">This product is unsuitable for anyone 13 years old or younger.</span></p>
    031+ <p><span style="color:#171A1D;">This product is intended for individuals over the age of 13.</span></p>
    032- <p><span style="color:#171A1D;">Children below the age of 13 should avoid using this product.</span></p>
    032+ <p><span style="color:#171A1D;">Kids who are 13 or younger are advised not to use this product.</span></p>
    033- <p><span style="color:#171A1D;">This product is not designed for children under 13 years of age.</span></p>
    033+ <p><span style="color:#171A1D;">This product is unsuitable for anyone 13 years old or younger.</span></p>
    034- <p><span style="color:#171A1D;">The use of this product is restricted to those over 13 years old.</span></p>
    034+ <p><span style="color:#171A1D;">Children below the age of 13 should avoid using this product.</span></p>
    035- <p><span style="color:#171A1D;">This product is not safe for children aged 13 and under.</span></p>
    035+ <p><span style="color:#171A1D;">This product is not designed for children under 13 years of age.</span></p>
    036- <p><span style="color:#171A1D;">Children who are 13 or younger are not allowed to use this product.</span></p>
    036+ <p><span style="color:#171A1D;">The use of this product is restricted to those over 13 years old.</span></p>
    037- <p><span style="color:#171A1D;">This product is not appropriate for use by children under 13.</span></p>
    037+ <p><span style="color:#171A1D;">This product is not safe for children aged 13 and under.</span></p>
    038- <p><span style="color:#171A1D;">The use of this product is prohibited for children under 13 years old.</span></p>
    038+ <p><span style="color:#171A1D;">Children who are 13 or younger are not allowed to use this product.</span></p>
    039- <p><span style="color:#171A1D;">This product is not meant for children who are 13 or younger.</span></p>
    039+ <p><span style="color:#171A1D;">This product is not appropriate for use by children under 13.</span></p>
    040- <p><span style="color:#171A1D;">Children under the age of 13 are not permitted to use this product.</span></p>
    040+ <p><span style="color:#171A1D;">The use of this product is prohibited for children under 13 years old.</span></p>
    041- <p><span style="color:#171A1D;">This product is unsuitable for use by anyone under 13 years of age.</span></p>
    041+ <p><span style="color:#171A1D;">This product is not meant for children who are 13 or younger.</span></p>
    042- <p><span style="color:#171A1D;">The use of this product is not suitable for children under 13.</span></p>
    042+ <p><span style="color:#171A1D;">Children under the age of 13 are not permitted to use this product.</span></p>
    043- <p><span style="color:#171A1D;">This product is not recommended for children who are 13 or younger.</span></p>
    043+ <p><span style="color:#171A1D;">This product is unsuitable for use by anyone under 13 years of age.</span></p>
    044- <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
    044+ <p><span style="color:#171A1D;">The use of this product is not suitable for children under 13.</span></p>
    045+ <p><span style="color:#171A1D;">This product is not recommended for children who are 13 or younger.</span></p>
    046+ <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
  4. 2025-02-27 14:48:21, 由 戴宝山 变更。
    修改了 版本号 ，旧值为 "3"，新值为 "4"。
    修改了 需求描述，区别为：
    046- Children aged 13 and below should not use this product.
    046+ Children aged 13 and below should not use this product.
    047+
    048+ 需求文档：<a href="https://alidocs.dingtalk.com/i/nodes/oP0MALyR8k7y4Br5h76ODPMp83bzYmDO?doc_type=wiki_doc">https://alidocs.dingtalk.com/i/nodes/oP0MALyR8k7y4Br5h76ODPMp83bzYmDO?doc_type=wiki_doc
    046- <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
    046+ <p><span style="color:#171A1D;">Children aged 13 and below should not use this product.</span></p>
    047+ <p><span style="color:#171A1D;"><br /></span></p>
    048+ <p>需求文档：<a href="https://alidocs.dingtalk.com/i/nodes/oP0MALyR8k7y4Br5h76ODPMp83bzYmDO?doc_type=wiki_doc">https://alidocs.dingtalk.com/i/nodes/oP0MALyR8k7y4Br5h76ODPMp83bzYmDO?doc_type=wiki_doc</a></p>
  5. 2025-03-02 12:04:15, 由 徐盛松 记录评审结果，结果为 确认通过。
    修改了 评审时间，旧值为 "0000-00-00"，新值为 "2025-03-02"。
    修改了 指派给 ，旧值为 "laoxu"，新值为 "daibaoshan"。
    修改了 当前状态，旧值为 "draft"，新值为 "active"。
    修改了 由谁评审，旧值为 ""，新值为 "laoxu"。
  6. 2025-03-03 10:52:18, 由 李亚婷 关联到迭代 智能中心-智能刊登迭代 。
  7. 2025-03-03 17:51:29, 由 戴宝山 编辑。
    修改了 指派给，旧值为 "daibaoshan"，新值为 "luoyoujun"。
  8. 2025-03-12 10:15:13, 由 梁秀丽 编辑。
    修改了 预计工时，旧值为 "16"，新值为 "18"。
    修改了 成本 ，旧值为 "8000"，新值为 "9000"。
    修改了 ROI ，旧值为 "7.50"，新值为 "6.67"。
  9. 2025-04-02 15:40:55, 由 李亚婷 编辑。
    修改了 所属计划，旧值为 ""，新值为 "1867"。
    修改了 上线时间，旧值为 "2025-03-07"，新值为 "2025-04-15"。
  10. 2025-04-03 11:59:15, 由 李亚婷 编辑。
    修改了 测试人员，旧值为 ""，新值为 "chenliting"。
  11. 2025-04-07 09:14:11, 由 罗友军 指派给 陈丽婷。
    修改了 指派给，旧值为 "luoyoujun"，新值为 "chenliting"。
    分支提测
  12. 2025-04-14 17:06:34, 由 陈丽婷 指派给 商雷。
    修改了 指派给，旧值为 "chenliting"，新值为 "shanglei"。

    分支测试通过

    刊登，只跑出来，物流属性和中文名带磁的数据，类目和英文名没跑出来，经过产品确认，此需求发灰度

  13. 2025-04-15 10:33:25, 由 商雷 指派给 陈丽婷。
    修改了 指派给，旧值为 "shanglei"，新值为 "chenliting"。
    主干提测
  14. 2025-04-15 16:41:50, 由 陈丽婷 指派给 戴宝山。
    修改了 指派给，旧值为 "chenliting"，新值为 "daibaoshan"。

    主干通过

    需要产品验收

    刊登的数据：

    "35239GS14K",

    "12BD631364O6",

    "FY849X74UM71U7SV331614P5",

    "CC3737A31USW8WM14ZS",

    "42C38HQS14H",

    "K773901149GN9S9M",

    "343WD39M2018X145",

    "14R38P7OXYNGCMMR39CAYDRMI",

    "M07W1440161MB8HGA5X",

    "J1433AEAI6NI407PR",

    "2TH14WN514XO6840OVH0L8",

    "V116413140LGDK",

    "421094R0MS",

    "IPQIV38L742M8WJ14IH",

    "HZXFS400Z9M43C8Z14RL",

    "61416RW433EWU",

    "31Q8O43IQ214O",

    "KVUC4350M14SP",

    "UJ140844ODHU",

    "2TV44B1428MAH42HIIQ",

    "57LMQQOFYKFEK7441402YC",

    "414514PXN9",

    "32M456A8WA14KZ37A0B6C",

    "SAJJVAOIXDE46LT9KW01RG14N",

    "YJ461184I64AU3"


    提交到通用队列的数据：

    db.Amazon_Common_Queue.find({"Type":34,"AddTime":{"$gt":ISODate("2025-04-15T10:30:00.000+08:00")}})

  15. 2025-04-15 18:50:43, 由 戴宝山 添加备注。
    已验收
  16. 2025-04-15 18:51:54, 由 李亚婷 添加备注。
    产品反馈，业务已验收，可上线
  17. 2025-04-15 20:26:24, 由 罗友军 编辑。
    修改了 所处阶段 ，旧值为 "testing"，新值为 "released"。
    修改了 设置阶段者，旧值为 ""，新值为 "luoyoujun"。
  18. 2025-04-15 20:26:32, 由 罗友军 指派给 陈丽婷。
    修改了 指派给，旧值为 "daibaoshan"，新值为 "chenliting"。
    已发布
  19. 2025-04-15 20:28:52, 由 罗友军 编辑。
    修改了 所处阶段 ，旧值为 "released"，新值为 "onlinetest"。
    修改了 设置阶段者，旧值为 "luoyoujun"，新值为 ""。
  20. 2025-04-15 20:29:06, 由 罗友军 添加备注。
    【灰度中】
  21. 2025-04-18 13:59:11, 由 陈丽婷 指派给 商雷。
    修改了 指派给，旧值为 "chenliting"，新值为 "shanglei"。

    灰度验证通过

    SELECT
    aa.Id,
    aa.STATUS,
    aa.SKU,
    aa.SiteCode,
    aa.OrderSourceID,
    aa.OrderSourceSKU,
    aa.AddTime,
    aa.TranslateAttributes,
    a.sku,
    a.ProductNameCN,
    a.ProductName,
    a.AccurateKeyword,
    a.AutoChooseKeyWords,
    a.SearchKeyword,
    a.WithBattery,
    c.BrowsePathByID,
    c.BrowseNodeName 
    FROM
    zhcxkj_AutoPublish_bi.Bi_Aq_AutoPublishUploadProduct AS aa
    LEFT JOIN rb_product a ON aa.sku = a.sku
    LEFT JOIN e_product_amazon_browsetree c ON a.sku = c.sku 
    WHERE

    aa.OrderSourceID IN (14524) 
    AND aa.AddTime >= '2025-04-15' 
    AND aa.AddTime <= '2025-04-17' -- a.sku  in ('1897482' )

    AND c.IsMain = 1 
    AND c.IsDelete = 0 -- 主查询中也需要这个过滤条件

    AND( a.WithBattery IN ( 390, 391, 392 ) 
    or  a.ProductNameCN LIKE '%磁%' 
    or ( a.ProductName LIKE '%Magnets%' OR a.ProductName LIKE '%Magnet%' ) 
    or c.BrowsePathByID LIKE '1055398,1063498,284507,289754,16439891,3737161%') 

    183LRTG4744AUR
    5SE5KO23CGYCNC1G1019MLCE
    YA1155MU9N14AR628
    EG909744514033DU
    I3389FNV02COF4K443WH
    EX5Y9240O5700Z
    ZE54555302N4
    IY0033XAIOBI016VTKQK
    R306AX2LQ198157F
    G0J56AG36JQ26Z06PWL4QI
    BDSM4MEUM34N0221MZCIR
    J5DMRCKDN4030862NJ378MIZ
    19P56BBTVRPN0QFV31LRF
    M02G031Y26K7N8G
    00PTCF1FY936U06IYJI3
    134088UA13B
    YSSP04PXY53H22E013F2288
    SC06DUOD977J4338LRD7
    MOBQR20BH1044314M9

  22. 2025-04-21 09:14:28, 由 罗友军 编辑。
    修改了 所处阶段 ，旧值为 "onlinetest"，新值为 "released"。
    修改了 设置阶段者，旧值为 ""，新值为 "luoyoujun"。
    生产已发版
  23. 2025-04-21 09:14:36, 由 罗友军 指派给 陈丽婷。
    修改了 指派给，旧值为 "shanglei"，新值为 "chenliting"。
  24. 2025-04-22 16:59:37, 由 李亚婷 指派给 戴宝山。
    修改了 指派给，旧值为 "chenliting"，新值为 "daibaoshan"。
    可验收
  25. 2025-04-29 15:50:51, 由 戴宝山 编辑。
    修改了 所处阶段 ，旧值为 "released"，新值为 "poaccepted"。
    修改了 设置阶段者，旧值为 "luoyoujun"，新值为 ""。
  26. 2025-04-30 10:28:40, 由 李亚婷 编辑。
    修改了 计划验收时间，旧值为 "0000-00-00"，新值为 "2025-05-07"。
    修改了 计划上线 ，旧值为 "0000-00-00"，新值为 "2025-04-15"。
    修改了 所处阶段 ，旧值为 "poaccepted"，新值为 "bepending"。
  27. 2025-05-06 13:38:18, 由 陈芹 编辑。
    修改了 所处阶段，旧值为 "业务验收中"，新值为 "业务验收中"。
    功能验收：延后验收
    验收异常原因:业务原因
    原因备注：节前无反馈
  28. 2025-05-26 11:11:59, 由 陈芹 编辑。
    修改了 所处阶段，旧值为 "业务验收中"，新值为 "业务验收通过"。
    功能验收：验收通过
    满意度：满意
    价值验收：基本达成
    原因备注：无
  29. 2025-05-26 11:19:57, 由 官荣荣 关闭，原因为 已完成 。
    修改了 由谁关闭，旧值为 ""，新值为 "guanrongrong"。
    修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2025-05-26 11:19:56"。
    修改了 指派给 ，旧值为 "daibaoshan"，新值为 "closed"。
    修改了 当前状态，旧值为 "active"，新值为 "closed"。
    修改了 所处阶段，旧值为 "verified"，新值为 "closed"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
迭代版本
提报业务部门 智能研发中心
提报人员 陈芹
需求来源 年度重点项目&需求
所属项目 智能中心-需求池
所属模块 战略独立项目   智能刊登
所属计划
业务价值
开发组
受益业务部门 亚马逊平台运营中心
验收人员 陈芹
业务目标类型
中心业务目标
业务价值 控制风险
每月价值量 10000
每月节省人数 0
优先级 P2
价值类型 长期价值
预计工时 18
成本 9000
ROI 6.67
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危 否
评分
当前状态 已关闭
所处阶段 已关闭
关键词
评审次数 一次
计划上线 2025-04-15
上线时间 2025-04-15
计划验收时间 2025-05-07
业务验收时间 2025-05-26 11:11:59
满意度 满意
价值验收 基本达成
满意度分值 80
业务回填价值
验收达成价值 48000.0
验收达成ROI 5.33
抄送给
由谁创建 戴宝山 于 2025-02-27 11:53:41
指派给 Closed 于 2025-07-08 19:41:37
由谁评审 徐盛松
评审时间 2025-03-02
由谁关闭 官荣荣 于 2025-05-26 11:19:56
关闭原因 已完成
最后修改 李亚婷 于 2025-07-08 19:41:37
相关Bug
相关用例
相关需求
细分需求