业务需求
需求描述

需求背景:针对这两个站点做单独的刊登实验


需求实现:


需求中使用到的业务表:

SKU店铺表:amazon_sku_ordersource_base

SKU关键词表:amazon_sku_keyword_base,`KeywordTyp '关键词类型 0 ST可用 1 标题可用',

SKU竞品表:amazon_sku_external_base

数据库:选品正式库 zhcxkj_advertise


1、根据SKU+店铺表,取SKU+店铺进行指定刊登

2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列

3、刊登资料组装

标题:

规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调

a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:


\ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n

b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:

\nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n


规则二、

从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求

标题根据表里面标示取不同的规则,1对应规则1,2对应规则2,上传队列中分别标记为 UKDE01和UKDE02


关键词:

从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求


亮点:

亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词


描述:

描述逻辑不变。



价格:

取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;


验收标准
价值描述
提升销量
附件
历史记录  
  1. 2024-07-03 10:47:18, 由 戴宝山 创建。
  2. 2024-07-04 10:35:09, 由 戴宝山 编辑。
    修改了 所属计划,旧值为 "",新值为 "586"。
    修改了 成本 ,旧值为 "12000",新值为 "6000"。
    修改了 ROI ,旧值为 "0.01",新值为 "0.02"。
    修改了 所处阶段,旧值为 "wait",新值为 "planned"。
  3. 2024-07-15 14:03:32, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "1",新值为 "2"。
    修改了 需求描述,区别为:
    004- 1、根据附件中的SKU进行刊登,筛选UK和DE站点账号组启用,店铺启用,类目匹配的数据进行刊登
    004+ 1、根据附件中的SKU+店铺进行刊登
    010-
    010+
    011-
    011+
    012- \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n
    012+ \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n
    013- b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:
    013+ b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:
    014-
    014+
    015-
    015+
    016- \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n
    016+ \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n
    017-
    017+
    018-
    018+
    019-
    019+
    020-
    020+ 规则二、
    021-
    021+ 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    022- 规则二、
    022+ 标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02
    023- 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    023+
    024- 标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02
    024+ 关键词:
    025-
    025+ 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    026- 关键词:
    026+
    027- 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    027+ 亮点:
    028-
    028+ 亮点与目前逻辑一致,只是关键词改成取附件的关键词
    029- 亮点:
    029+
    030- 亮点与目前逻辑一致,只是关键词改成取附件的关键词
    030+ 描述:
    031-
    031+ 描述逻辑不变。
    032- 描述逻辑不变。
    032+
    033-
    033+
    034+ 价格:
    035+ 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    036+
    004- <p>1、根据附件中的SKU进行刊登,筛选UK和DE站点账号组启用,店铺启用,类目匹配的数据进行刊登</p>
    004+ <p>1、根据附件中的SKU+店铺进行刊登</p>
    010- <p>
    010+ <p><br /></p>
    011- </p><div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    011+ <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    012- <p><span style="color:#0451a5;">\ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n</span></p>
    012+ <p><span style="color:#0451a5;">\ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n</span></p>
    013- <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">b、调整<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;">system<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">提问,</span></span></span></span>去掉标点控制的提醒,改成要求只输出标题,例如美国站:</span></span></span></span></span></p>
    013+ <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">b、调整<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;">system<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">提问,</span></span></span></span>去掉标点控制的提醒,改成要求只输出标题,例如美国站:</span></span></span></span></span></p>
    014- <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;">
    014+ <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;"> </span></span></span></span></span></p>
    015- </span></span></span></span></span></p><div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    015+ <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    016- <div><span style="color:#0451a5;">\nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n</span></div>
    016+ <div><span style="color:#0451a5;">\nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n</span></div>
    017- </div>
    017+ </div>
    018-
    018+ </div>
    019- </div>
    019+ <p><br /></p>
    020-
    020+ <p>规则二、</p>
    021- <p><br /></p>
    021+ <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    022- <p>规则二、</p>
    022+ <p>标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02</p>
    023- <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    023+ <p><br /></p>
    024- <p>标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02</p>
    024+ <p>关键词:</p>
    025- <p><br /></p>
    025+ <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    026- <p>关键词:</p>
    026+ <p><br /></p>
    027- <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    027+ <p>亮点:</p>
    028- <p><br /></p>
    028+ <p>亮点与目前逻辑一致,只是关键词改成取附件的关键词</p>
    029- <p>亮点:</p>
    029+ <p><br /></p>
    030- <p>亮点与目前逻辑一致,只是关键词改成取附件的关键词</p>
    030+ <p>描述:</p>
    031- <p><br /></p>
    031+ <p>描述逻辑不变。</p>
    032- <p>描述逻辑不变。</p>
    032+ <p><br /></p>
    033- <p><br /></p>
    033+ <p>
    034+ </p><p>价格:</p>
    035+ 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    036+ <p><br /></p>
  4. 2024-07-15 14:34:17, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "2",新值为 "3"。
    修改了 需求描述,区别为:
    004- 1、根据附件中的SKU+店铺进行刊登
    004+ 1、根据SKU+店铺表,取SKU+店铺进行指定刊登
    009- a、在user传参中,增加SKU的中文标题,建议的标题和关键词从附件中获取,例如:
    009+ a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:
    021- 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    021+ 从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求
    025- 从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求
    025+ 从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求
    028- 亮点与目前逻辑一致,只是关键词改成取附件的关键词
    028+ 亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词
    033-
    033+
    034- 价格:
    034+ 价格:
    004- <p>1、根据附件中的SKU+店铺进行刊登</p>
    004+ <p>1、根据SKU+店铺表,取SKU+店铺进行指定刊登</p>
    009- <p>a、在user传参中,增加SKU的中文标题,建议的标题和关键词从附件中获取,例如:</p>
    009+ <p>a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:</p>
    021- <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    021+ <p>从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求</p>
    025- <p>从附件中的关键词选择对应站点的词进行随机组合,直到长度达到要求</p>
    025+ <p>从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求</p>
    028- <p>亮点与目前逻辑一致,只是关键词改成取附件的关键词</p>
    028+ <p>亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词</p>
    033- <p>
    033+ <p><br /></p>
    034- </p><p>价格:</p>
    034+ <p>价格:</p>
  5. 2024-07-16 09:12:24, 由 戴宝山 变更。
    修改了 指派给,旧值为 "daibaoshan",新值为 "laoxu"。
  6. 2024-07-16 10:36:21, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "3",新值为 "4"。
    修改了 需求描述,区别为:
    004- 1、根据SKU+店铺表,取SKU+店铺进行指定刊登
    004+
    005- 2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列
    005+ 需求中使用到的业务表:
    006- 3、刊登资料组装
    006+ SKU店铺表:amazon_sku_ordersource_base
    007- 标题:
    007+ SKU关键词表:amazon_sku_keyword_base
    008- 规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调
    008+ SKU竞品表:amazon_sku_external_base
    009- a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:
    009+ 数据库:选品正式库 zhcxkj_advertise
    011-
    011+ 1、根据SKU+店铺表,取SKU+店铺进行指定刊登
    012- \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n
    012+ 2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列
    013- b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:
    013+ 3、刊登资料组装
    014-
    014+ 标题:
    015-
    015+ 规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调
    016- \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n
    016+ a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:
    017-
    017+
    018-
    018+
    019-
    019+ \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n
    020- 规则二、
    020+ b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:
    021- 从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求
    021+
    022- 标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02
    022+
    023-
    023+ \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n
    024- 关键词:
    024+
    025- 从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求
    025+
    027- 亮点:
    027+ 规则二、
    028- 亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词
    028+ 从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求
    029-
    029+ 标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02
    030- 描述:
    030+
    031- 描述逻辑不变。
    031+ 关键词:
    032-
    032+ 从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求
    034- 价格:
    034+ 亮点:
    035- 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    035+ 亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词
    036-
    036+
    037+ 描述:
    038+ 描述逻辑不变。
    039+
    040+
    041+ 价格:
    042+ 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    043+
    004- <p>1、根据SKU+店铺表,取SKU+店铺进行指定刊登</p>
    004+ <p><br /></p>
    005- <p>2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列</p>
    005+ <p>需求中使用到的业务表:</p>
    006- <p>3、刊登资料组装</p>
    006+ <p>SKU店铺表:amazon_sku_ordersource_base</p>
    007- <p>标题:</p>
    007+ <p>SKU关键词表:amazon_sku_keyword_base</p>
    008- <p>规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调</p>
    008+ <p>SKU竞品表:amazon_sku_external_base</p>
    009- <p>a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:</p>
    009+ <p>数据库:选品正式库 zhcxkj_advertise</p>
    011- <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    011+ <p>1、根据SKU+店铺表,取SKU+店铺进行指定刊登</p>
    012- <p><span style="color:#0451a5;">\ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n</span></p>
    012+ <p>2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列</p>
    013- <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">b、调整<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;">system<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">提问,</span></span></span></span>去掉标点控制的提醒,改成要求只输出标题,例如美国站:</span></span></span></span></span></p>
    013+ <p>3、刊登资料组装</p>
    014- <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;"> </span></span></span></span></span></p>
    014+ <p>标题:</p>
    015- <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    015+ <p>规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调</p>
    016- <div><span style="color:#0451a5;">\nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n</span></div>
    016+ <p>a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:</p>
    017- </div>
    017+ <p><br /></p>
    018- </div>
    018+ <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    019- <p><br /></p>
    019+ <p><span style="color:#0451a5;">\ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n</span></p>
    020- <p>规则二、</p>
    020+ <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">b、调整<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;">system<span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;">提问,</span></span></span></span>去掉标点控制的提醒,改成要求只输出标题,例如美国站:</span></span></span></span></span></p>
    021- <p>从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求</p>
    021+ <p><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#000000;font-family:SimSun;"><span style="color:#0451a5;"> </span></span></span></span></span></p>
    022- <p>标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02</p>
    022+ <div style="color:#000000;background-color:#ffffff;font-family:IBMPlexMono, 'Courier New', monospace, Consolas, 'Courier New', monospace;font-weight:normal;font-size:12px;">
    023- <p><br /></p>
    023+ <div><span style="color:#0451a5;">\nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n</span></div>
    024- <p>关键词:</p>
    024+ </div>
    025- <p>从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求</p>
    025+ </div>
    027- <p>亮点:</p>
    027+ <p>规则二、</p>
    028- <p>亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词</p>
    028+ <p>从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求</p>
    029- <p><br /></p>
    029+ <p>标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02</p>
    030- <p>描述:</p>
    030+ <p><br /></p>
    031- <p>描述逻辑不变。</p>
    031+ <p>关键词:</p>
    032- <p><br /></p>
    032+ <p>从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求</p>
    034- <p>价格:</p>
    034+ <p>亮点:</p>
    035- 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    035+ <p>亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词</p>
    036- <p><br /></p>
    036+ <p><br /></p>
    037+ <p>描述:</p>
    038+ <p>描述逻辑不变。</p>
    039+ <p><br /></p>
    040+ <p><br /></p>
    041+ <p>价格:</p>
    042+ 取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;
    043+ <p><br /></p>
  7. 2024-07-16 10:36:58, 由 戴宝山 变更。
    修改了 需求描述,旧值为 "

    需求背景:针对这两个站点做单独的刊登实验


    需求实现:


    需求中使用到的业务表:

    SKU店铺表:amazon_sku_ordersource_base

    SKU关键词表:amazon_sku_keyword_base

    SKU竞品表:amazon_sku_external_base

    数据库:选品正式库 zhcxkj_advertise


    1、根据SKU+店铺表,取SKU+店铺进行指定刊登

    2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列

    3、刊登资料组装

    标题:

    规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调

    a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:


    \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n

    b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:

    \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n


    规则二、

    从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求

    标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02


    关键词:

    从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求


    亮点:

    亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词


    描述:

    描述逻辑不变。



    价格:

    取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;


    ",新值为 "

    需求背景:针对这两个站点做单独的刊登实验


    需求实现:


    需求中使用到的业务表:

    SKU店铺表:amazon_sku_ordersource_base

    SKU关键词表:amazon_sku_keyword_base

    SKU竞品表:amazon_sku_external_base

    数据库:选品正式库 zhcxkj_advertise


    1、根据SKU+店铺表,取SKU+店铺进行指定刊登

    2、需要按照刊登过滤条件进行过滤,过滤完成后直接导入到刊登队列

    3、刊登资料组装

    标题:

    规则一:与多铺标题规则类似,使用GPT进行提问,提问方式做微调

    a、在user传参中,增加SKU的中文标题,建议的标题和关键词从SKU竞品表取标题,关键词从SKU+关键词表获取,例如:


    \ntitle of our product:\n浴缸下水器配件防反味排水器线控浴缸下水器高品质铜塑复合黑色连体二头自动清洁池下水管(中心距53公分)\n\ncompetitors' titles\nStopShroom STBLU232 Universal Stopper Plug Cover for Bathtub, Bathroom and Kitchen Drains, Aqua\nStopShroom Ultimate Universal Stopper Plug for Bathtub, Bathroom, and Kitchen Sink Drains (White)\n1 1 1 34 Stainless Bathtub Anti clogging Bathroom\nWasserrhythm Pop up Basin Waste Matte Black Slotted for Bathroom SInks with Overflow Click Clack Sprung Plug 1/4 BSPP UK Standard\nBathroom Sink Stopper Universal, Bathtub Pop Up Filter Bullet Core Push Type Basin Drain Plug for 1.08-1.77 Drain Hole Without Overflow with Hair Catcher Anti Clogging Basket\n\nkeywords:\nbath drain unblocker\nbath sink drain stopper\ndrain plug bathroom sink\nplug hole unblocker bathroom\nshower drain unblocker\n

    b、调整system提问,去掉标点控制的提醒,改成要求只输出标题,例如美国站:

    \nI am an amazon seller, amazon regulations product title similarity can not be more than 70%, I will give you 1 Chinese title of our product, and 2-5 competitors' titles, and occasionally will give you some keywords, you need to output a new title that meets the following requirements\n1.Write based on the competitor's title style, but cannot have more than 70% duplication with any of the given titles\n2. Cannot exceed 180 characters, Cannot be less than 140 characters, Cannot truncate the word\n3. The size, specification, colour and other information in the title should be based on the information of our product\n4. Cannot contain non-English and the sentence is smooth to meet the U.S. local search habits\n5. The keywords I have given may not be very relevant to the product, irrelevant keywords should not be included in the title, if they are relevant they need to be included in the title\nNote: Only the title should be output, do not include other characters.\n


    规则二、

    从SKU关键词表选择对应站点的标题关键词词进行随机组合,直到长度达到要求

    标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02


    关键词:

    从SKU关键词表中的st关键词字段选择对应站点的词进行随机组合,直到长度达到要求


    亮点:

    亮点与目前逻辑一致,只是关键词改成取SKU关键词表中的标题关键词


    描述:

    描述逻辑不变。



    价格:

    取竞品价格中最低的价格*98%,如果价格低于底限,则使用底限价格;


    "。
    修改了 版本号 ,旧值为 "4",新值为 "5"。
    上传了附件 ChatGPT4.0标题测试_模板.xlsx
  8. 2024-07-16 10:41:21, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "5",新值为 "6"。
    修改了 需求描述,区别为:
    029- 标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02
    029+ 标题根据表里面标示取不同的规则,1对应规则1,2对应规则2,上传队列中分别标记为 UKDE01和UKDE02
    029- <p>标题从以上两个规则中随机选择一个,分别标记为 UKDE01和UKDE02</p>
    029+ <p>标题根据表里面标示取不同的规则,1对应规则1,2对应规则2,上传队列中分别标记为 UKDE01和UKDE02</p>
  9. 2024-07-16 10:51:20, 由 戴宝山 变更。
    修改了 版本号 ,旧值为 "6",新值为 "7"。
    修改了 需求描述,区别为:
    007- SKU关键词表:amazon_sku_keyword_base
    007+ SKU关键词表:amazon_sku_keyword_base,`KeywordTyp '关键词类型 0 ST可用 1 标题可用',
    007- <p>SKU关键词表:amazon_sku_keyword_base</p>
    007+ <p>SKU关键词表:amazon_sku_keyword_base,`KeywordTyp '关键词类型 0 ST可用 1 标题可用',</p>
  10. 2024-07-18 19:49:44, 由 徐盛松 记录评审结果,结果为 确认通过。
    修改了 评审时间,旧值为 "0000-00-00",新值为 "2024-07-18"。
    修改了 指派给 ,旧值为 "laoxu",新值为 "daibaoshan"。
    修改了 当前状态,旧值为 "draft",新值为 "active"。
    修改了 由谁评审,旧值为 "",新值为 "laoxu"。
  11. 2024-07-18 20:11:18, 由 戴宝山 指派给 罗友军。
    修改了 指派给,旧值为 "daibaoshan",新值为 "luoyoujun"。
  12. 2024-07-22 09:36:13, 由 罗友军 关联到迭代 智能中心-智能刊登迭代 。
  13. 2024-07-24 10:15:04, 由 罗友军 指派给 陈丽婷。
    修改了 指派给,旧值为 "luoyoujun",新值为 "chenliting"。
    分支提测
  14. 2024-07-25 10:22:16, 由 陈丽婷 指派给 罗友军。
    修改了 指派给,旧值为 "chenliting",新值为 "luoyoujun"。
    分支通过
  15. 2024-07-25 10:27:03, 由 梁秀丽 编辑。
    修改了 关键词,旧值为 "",新值为 "战略2024年7月25日"。
  16. 2024-07-25 10:57:30, 由 罗友军 指派给 陈丽婷。
    修改了 指派给,旧值为 "luoyoujun",新值为 "chenliting"。
    主干提测
  17. 2024-07-25 19:52:20, 由 陈丽婷 指派给 罗友军。
    修改了 指派给,旧值为 "chenliting",新值为 "luoyoujun"。

    主干测试通过

    线上服务先不要开,业务验收通过后再开

  18. 2024-07-26 09:30:11, 由 罗友军 指派给 陈丽婷。
    修改了 指派给,旧值为 "luoyoujun",新值为 "chenliting"。
    已上线
  19. 2024-07-30 17:29:43, 由 梁秀丽 编辑。
    修改了 成本 ,旧值为 "6000",新值为 "7000"。
    修改了 ROI ,旧值为 "0.02",新值为 "0.01"。
    修改了 预计工时,旧值为 "24",新值为 "28"。
  20. 2024-08-05 14:30:33, 由 陈丽婷 指派给 戴宝山。
    修改了 指派给,旧值为 "chenliting",新值为 "daibaoshan"。

    标题规则是UKDE02的数据

    15902578 431W08IJ4190 GB
    15902578 309L20LK11G190 GB
    15902578 V7N1676O55T10R15GV GB
    15902578 L09LV3516W6W64QDI59 GB
    15902578 W10299H169I GB
    15902578 G57K4I1521ES19DC434Y042 GB
    15902578 511099DF8QPCS71Y GB
    15902578 09PPXU52OPCN6PVQA16VTTQV GB
    15902578 2101416KBRO GB
    15902578 Y3TQ2PZ1614U8E0008ZU9 GB
    15902578 0VS30019QWIQ1HHOO16P5XD8V GB

  21. 2024-08-06 09:38:53, 由 戴宝山 关闭,原因为 已完成 。
    修改了 关闭原因,旧值为 "",新值为 "done"。
    修改了 当前状态,旧值为 "active",新值为 "closed"。
    修改了 指派给 ,旧值为 "daibaoshan",新值为 "closed"。
    修改了 所处阶段,旧值为 "tested",新值为 "closed"。
    修改了 关闭日期,旧值为 "0000-00-00 00:00:00",新值为 "2024-08-06 09:38:53"。
    修改了 由谁关闭,旧值为 "",新值为 "daibaoshan"。
迭代版本
提报业务部门
提报人员 刘昊林
需求来源 年度重点项目&需求
所属项目 智能中心-需求池
所属模块 战略独立项目   智能刊登
所属计划
业务价值 中心战略层
开发组
受益业务部门 智能研发中心
验收人员 刘昊林
业务目标类型 其他
中心业务目标 其他
业务价值
每月价值量 100
每月节省人数 0
优先级 P1
价值类型 短期价值
预计工时 28
成本 14000
ROI 0.01
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危
评分
当前状态 已关闭
所处阶段 已关闭
关键词 战略2024年7月25日
评审次数 一次
计划上线
上线时间 2024-07-19
计划验收时间 2024-07-26
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给
由谁创建 戴宝山 于 2024-07-03 10:47:18
指派给 Closed 于 2024-08-06 09:38:53
由谁评审 徐盛松
评审时间 2024-07-18
由谁关闭 戴宝山 于 2024-08-06 09:38:53
关闭原因 已完成
最后修改 戴宝山 于 2024-08-06 09:38:53