业务需求
需求描述

需求背景：过滤部分不需要刷新的数据


需求实现：

1、过滤人工有修复亮点的数据

从接口获取http://showdoc.zhcxkj.com/web/#/88/5413，开始时间从2024年7月23号开始，将数据存储一个表中，保存asin+站点
修复亮点缺失问题时，以asin+站点过滤该表的数据，该表的数据不重新上传亮点


2、过滤下架的数据

3、过滤母体

验收标准
价值描述
修复错误数据
历史记录  
  1. 2024-08-02 18:40:49, 由 戴宝山 创建。
  2. 2024-08-02 18:40:59, 由 戴宝山 编辑。
    修改了 所属计划，旧值为 ""，新值为 "586"。
    修改了 成本 ，旧值为 "6000"，新值为 "3000"。
    修改了 ROI ，旧值为 "0.02"，新值为 "0.03"。
    修改了 所处阶段，旧值为 "wait"，新值为 "planned"。
  3. 2024-08-05 15:51:46, 由 戴宝山 变更。
    修改了 版本号 ，旧值为 "1"，新值为 "2"。
    修改了 需求描述，区别为：
    007- 2、过滤下架的数据
    007+ 2、过滤下架的数据
    008+ 3、过滤母体
    007- <p>2、过滤下架的数据</p>
    007+ <p>2、过滤下架的数据</p>
    008+ <p>3、过滤母体</p>
  4. 2024-08-05 16:53:07, 由 梁秀丽 编辑。
    修改了 关键词，旧值为 ""，新值为 "战略2024年8月5日"。
  5. 2024-08-06 09:45:40, 由 徐盛松 记录评审结果，结果为 确认通过。
    修改了 评审时间，旧值为 "0000-00-00"，新值为 "2024-08-06"。
    修改了 指派给 ，旧值为 "laoxu"，新值为 "liangxiuli"。
    修改了 当前状态，旧值为 "draft"，新值为 "active"。
    修改了 由谁评审，旧值为 ""，新值为 "laoxu"。
  6. 2024-08-06 13:37:31, 由 罗友军 关联到迭代 智能中心-智能刊登迭代 。
  7. 2024-08-06 14:49:28, 由 戴宝山 指派给 罗友军。
    修改了 指派给，旧值为 "liangxiuli"，新值为 "luoyoujun"。
  8. 2024-08-08 15:49:17, 由 罗友军 指派给 陈丽婷。
    修改了 指派给，旧值为 "luoyoujun"，新值为 "chenliting"。
    已上线
  9. 2024-08-12 11:41:35, 由 陈丽婷 指派给 戴宝山。
    修改了 指派给，旧值为 "chenliting"，新值为 "daibaoshan"。

    修复亮点的数据：

    "3347L03CI5", "GRP21914173LJ", "42602J6DI19JJS1CT", "LECO327F1523D8FXQ", "TU021304N255GLDD8",  "G230022FPT9AXJPCWY", "NH3V1H482322V0FPHDGRJN", "48AZ2VFPT1JD00593BNMP94", "223YSL646MJ12A6O2GFIZS",  "LT2S5I081946DQ72ZJ5IIG", "SX1T5357JAY6034R8S", "4E27E41V5D19A", "A33344120YO8GL", "12GS1199T7R",  "KY421451ZY775", "Z04V0N0D0NK6KC50M417Q0", "KDIV3L723WB36A58SBFN19YL1", "RE5E2236505BU",  "1139414K7GXQB4LIE1MUNM", "31X0928Z140", "DQ2E727JXC57SY14759Y", "5KY46Q13IZ2UF43TXPM",  "2XYVU26754N18Y14LU", "I27OG4W11Z11KNAEBI846", "AKJPTL19WFXSF54IHPQ309DD", "LN33HIC39D14Q9",  "02X47SISB14WD", "P15O015G22WG6GJ", "I5G204EY11810G6M1J19EK", "511R13109281L5M0", "41154P14XD",  "QMN2P3X109140WQN1A5SG", "YPQ7Z22834160PF", "0JD083Q8RBMY11GY05GW0", "000023CWHBT", "A8LF9S10Y523009WNWR",  "24XN415DU5B0473IA", "0D16V401G39JK8A39FT1BB4T", "Y6F32353XR07AW4", "30VBQA07AJRX2O02T",  "HH04098OFFWTO30JEG9XZ", "L46ZNZR52F09OT", "TUV646G0593I9U", "T8B40B130WVG09O8", "415V159336L4X",  "17U21G2145SKV06EMD", "MY321754CPYYR", "UJF23128305OOPT", "A8T24ZLZ2354147ARJAW2", "54CQ2U19KHNPGBN06E",  "EZ4BP268IB1756NEUNT5E2AD8", "11313F39IOFPGI94", "50A3915944Y0", "T4330I11QCS6", "Y580303TD9NAQ",  "ZRFGS21BNWF04OO830SZJ", "013201D24Z8", "MW3002E38Y9IPD", "G90057L56LS55ZSF4M", "85SU0ADA95XV18Z4522IW9R",  "GF0A3402ZRC079ZF7M201", "47801Y91248N02556", "05K300PAM529YEE2", "F14161544Z", "OT07TONZWP09S2LKJU123F5",  "46N77H41KQ8ZFNN11JG", "Q2218IYWPHU16Z", "UT647ICE47JZTMZO09Z8UJ", "H5PS9QHRC58210916S3",  "J14AF27554DNOMMUBQ61OE3T", "W4Z100015XQSQ6N", "26GVJDJK37164LJ", "117LVH3023WWY2Z2Z96", "DY03Q19K59CH3",  "FNOI1K5E01H53816L3ZI91DMQ", "125070VY8VA", "RU12353610Q", "533F1389YQ", "PM455114LMAKA",  "ZYO14VXULKBT0C10277E4", "B4735IH16B7", "Q9RC5AVV1JGV03621525UUKO", "O5525UL3NH4213FHZBUA", "U44704Q160O",  "X156623G0N209N", "X744OT106S2957YSB", "41MIL1PA1134BBV6V27P2HZY", "2LVDCQ1238MPSMY194Z",  "IM6KRO3412319H", "OPQ7040249N1UD0Y65HFMA3LE", "14WNO07553J7G", "24JH6AIFCT39D9MLW6075", "EQO0175729TKQ",  "1ISIM1149E1VPKY005SAL", "WCC41L0901GS26DVS", "ZTIVRFX05J900942GVK", "F1403RYE0923NVO3K",  "Z5702STICSL1ZC156XJPU0B3", "ZU36GOC41519T", "486DMIS29L5NYIN23K", "4418QEUPJ414J15UBM",  "44Z2202IY67ZC7PE", "228BZ3920M3", "Q2082T87LXCM12MQX", "QZN230L1076I4", "0L591485UAI",  "FX24S5Q53RMGHJ03DSZ6S17", "WP3444JS322LQSYJT", "P23I494915S", "O213HSK15DQHLI02EAOWXB",  "7G289QF50ON9517XAZS05U3W", "A1S223TOP36BRK19L6FC4OV", "46EOQ3122KIP54LCK12IEL9SD", "14678XT23IV8JWM",  "QS5158UHIN6LOV421OR26D", "15U1029WN2", "CY-7OFV-0S05", "07E3C2103N9ZG41DA93CL", "0GL063609VVY",  "5AV69E123S116ZOD727QME03", "21073215G09S", "F35P1557ZDWM", "F8YK24FVJ7IJMJ11036ZSM0XK",  "10RC004XB7VRR7A28S5S8", "3140052EPQOT2YRXAJGV", "C5214005W44OK", "11V527K56J6OT2", "CN124847KA4F9CW9",  "4417572752ZT193P", "J6124129P6JOV3QF", "88ZWG10OD6F9TW1206OGLGBO7", "QWES1STLE64721017YS4QY8",  "49O8007716YE8", "KOMGZ041705STGM", "1ZF1437512LNY4", "4N35ZRVNG4SLCJMW1377BP7", "471BBY17506ZD",  "33SS17DS3U41J279LO7S", "42Y9V1V36GER01O", "OO2ZUV370136TYL", "9HRBN15KV147200DM2WT",  "B345MFE13F3M548RTD15D", "57DATXJTNPO02ZI25RE9GUKS", "25259DIOI5JO0243B1Y", "T5QSWV20352QSZ560JK",  "R0416658XNFR0", "Y5139U13XA6LF", "KR5NDHCL53P7O40V009AMOM", "1722WF14QO8Z", "57AES80409304J9EK10XWN",  "T09QXEK17GF816UL", "57A170EN08MLK97N", "M3023E30F37V53W", "20S1351HHQLG85C20IT3XSY",  "00H31HRDN6Q09ANESGGE", "5409O1V176IA", "2021C0Y0LCKV1488PXXFZQ", "E4V8N220423FLH", "5C42647PF069PS",  "5589ASZFDF07J02C9WD", "JCJ3307ZO29OLXN", "OJ0956HQ9F14T", "126005IJ1HPT", "HJL35OL748OTICXXUZBE14NG",  "U09I60N2P7J6432K15Z0", "46EKQ62717BIGEA", "D00314RNR18B2PT30KH12WS", "HKY513Q6WAX1397X9P",  "4W9S22DEAN12114HERFUX", "SA46023J17G", "O1G7189M46T35SR2TJ86", "39U400LJDLVRC6M39TQDNQ",  "5718LOG4633A5EKAJQHW4I", "702141641PS92", "574P52400J44IQ03R6QV5BB", "03VIG1R17E3J03KROUR",  "DL35C215S3OE57XHF", "44N01215LUTQBX80BUYSNWN", "GK10U30MQ0NUQ922R0", "92QJG9J21KQSEHSE1396ZKDV",  "MG3716K38FWG", "C51903XRWXB20EP1", "5XT3024N556IA192", "5478G1035X", "G4453091258N2",  "L6491GP10CY0SF1034FIAWD", "A15162539T78MYN", "WGF11819ZK15YU3VJYM", "M7B44212914F", "U447P10SL51U48ZI4",  "WQ404X12G80X00XQ3", "GXB14G28552XUHJ", "Z17N23R2AJE2DA03SKMOUB4", "8U5043LBA616UE", "47711181E4H",  "6LIPPYGU245405K18NBPZD0D2", "SE2UW11A42H538R06", "N7DR747R40OC7167", "1551WO6YY52I1EO",  "55S1405HDCMJIIMWIV8WG", "CD822Y571V7OX350EWQLXR5L", "F7K6I6XZ100581N3YE", "X741F373142998H6",  "R2289V853UNIU0O05Y5R6", "FK159SQ759F45RM20", "103AY8T32P29N9R46163EQ5Z", "O607Y16J51NN35I41N2G",  "742H6W4422SR", "0BD19U230QXM11BVML", "4VRZY050527BNRC65", "HVE1575SA28MDSPEKBF0ER",  "M4Q0236D42N02YALJAGR", "JP6OTEG24013AE716WFM", "6FRVU34SN9QOA4718Y", "464WAG16044MYFFZFRL6",  "18R21NLMA58ARTN184LMNM1", "1409U08G0C", "R14577J245WU", "19E1856XQ8", "U02W7N93HQ03223O85WXE9",  "L05581V5J4F14VZD", "S119E16AB57GQMBD918ISXB", "S03139MS39LOP08", "N1D0466711J",  "BE5Q105ZH3EW47PT10J8NDMN", "R42Y24QV00D", "Z19020318ZHO5HQ", "V48B2184IG032EMQBC0N", "901898854XSM5",  "244818G7PX57BD", "6RNFMVSH17E4325513XGL", "S19L4416NFES", "7B8IT11E8O625EA7H556UG3", "225U7256GIS11S",  "603TK21012JOCR", "O3245ZNSD01B", "02XUM5Z1OQ15PTJ375OT", "UZ140FB2318V3", "4F1432296K5B01RW20",  "JH7DQIGLWC438I1287O7BI5JP", "QN5A04ISC3317FUBI", "HH088Y5B27ZT157E9BJ", "1X42JGVA59H09B",  "1860V1EMCM49BFA31CIOGVA", "ZY9W8P12T8S221118W", "2CQ740J22A17FPIU4514QCM1", "167MG2546NDE10E1F",  "ZU2Q9R23813Q3B9T07G", "2F4Z6HK72433PY1618JED0XA", "QE3117HK57TJ1RCWE", "R45W3323RH",  "SP02552HPZ0YF02XNV8W", "173KLGQB5U1261NY", "46O1723557A", "NY1755Q207R", "9QF83631EW18K", "TOO3K565916K",  "3ZJ8158788199IC6DK86", "M8ZGZL5KW9D114398Z1DVUS", "11UA22DCTIY57HNT", "1303R14EMX", "4336CSO18J",  "1KG08CA4136Z182YHYN", "R601Q11T17K4", "NT422S52G1182C8F", "ZV04U41G05760", "0800JY7PFT20WF",  "ACP4401419G", "5C45NSO1638Y8L", "C0616306YUH4TNQ17PS5VOA", "150553OGZEHFC", "9133026VNC",  "1BA15LIYYVT0W37AT9154", "K31030BMH44N7T8PRDO", "584O2LUERL0911V", "16A24GVJVHX2OYU137",  "M3802HSE168XT0ML", "615I41F3E04SKS", "P27511D16K", "U89IR3HVO04VG852V14E4D", "HJRJ29Q03EIQ0XS1696UD",  "3H49G02QK137BXTNV3VPIE", "YXH46O29S16EBOFC", "P10D54M516UN8EK", "CU2Q0049L14UIQ5LU8",  "3C14UQXRYX1427B6NZ17P", "OTM04ZGBA4616J", "3V9KND001016XK", "4154PTSUZ341614L3GH6103",  "J6V7OF57107W20AM3Q2", "Z71468CFFR9NE9QKP21OA207P", "16L539007JDV", "ES195WJ220VX620V4165D",  "OW08JOM2SFX2103V3X", "JP03UDL6XR426L8Q2196D0", "68IOM15FF4S02RF3EPK34PQR", "SPW1023455E7F",  "OIU1382XV4000EO", "B5FFNC70BXK0213204OO09TIA", "1JV02ZB10TV20GJSIRHP", "U16CU21474NVKZ",  "3P24TOBZWQ00CE233E87QUGVZ", "L18XEV51HNA493EI9054Y", "1258I5J46H56765A6JS", "N19XL2AL6UW40FPYH903YRZL",  "R50IX18U2XP24E0XW033XEV0", "LC2590SI14EF7SFDI7123R", "GG191142LA67", "RL321941O4N4VQCC",  "IX0ABFDS2808JCXYO1P0336", "E71838O0Y22VY", "5017KEI34L2B36234MF2", "D28424G18JP", "0G150NN4FGK785209I",  "JK017Y1UX07KB141NX2EGG", "27UG955A1LO05X7UC2WAK", "R0430701N8R", "15TO15OE18AC2KBPV", "224I03A3M4420T5",  "N22RW0BP4ZZU539YFPT11HZS", "47DD3K185647AACQG", "19MR4M632Z93V1QIB9180ZPE", "0225VEOT161",  "I00323U16PCGO", "319F09AU042W7WS", "41VV32217P0RMB85TE", "H4622O18EJI", "GNOKLOO74721U18KLZEY",  "5L57NU15061X9", "YRJ0573BCS2LK500QQ", "Y264C40ZL03U7GPE", "4215Z076WN", "E106MG519Q17JO8Q23ZH",  "D25W10467K", "13334212RP0U6R", "4667WN614DVJ7EEY39QUAAQC5", "DY21EYVF06ZPIMW14U1QP",  "8H317G1028JRA9WS2W", "SF139477TDKJP", "EL212T32V46FNTIU505X", "J417FH5117DIDD", "42656Y1129",  "K517L1721M6MLWT2GO7MSKG", "FE115430O9M95CU6", "1A690009IC402R45GC48KX", "37788CJ21FMPD10L5U",  "366A137716WSPL", "3372907Y076M4IO", "ELHTNS1209Q0QM6I2TH27Z4L", "48B521O1675FH", "113525IG62M1R",  "XZSBE06SSB30171D42O", "5658QXVJJIZ195X9WNW9", "604T22947883GVJ9N34", "109X1205X1JHU37LXM", "3C4474HB231",  "23MQYZHL47II06FUNNK0", "B9ZWWSE31HMP11263NF53OM", "T9K2EG445Q17237MV", "I0613347IL7", "YG5V08EBK927037",  "K206XM46R50A44FRT2X", "3574321141WB", "KJ155416JRC8", "2041401LRLDY", "S00B35NZH188RI7BYZGQ",  "6K235711UX", "1I04EPLIAKT29I1ZH11Y6", "1137594CRJF9Y2YW8S", "1N7LIB0XW165011U", "FZ063IFY1V1639199T0",  "1252806L183", "WN230SWNF2351AV78200CS", "OHXZ35HSHH34HI2Z16003OWE", "PCH0162I25FC0",  "KIC0224FA01ZWP0S0EBEN", "LG0B818PN13SI0588SCE8Y", "G5P7419X731018RAE", "M034002R57", "GV0419O27VYCT8U",  "8U77D56G021578AE7GM92", "05NLBE51RHTZ02A07O", "113I2IY2U1396F1CN", "UA9G101246FGHZ7MAI04G72X",  "5HIIDZ52605GC417I21FQ5", "2P32105LF372PXO18T8K5MR", "RE-S6D7-HJEP", "214O7GVK06WM52PLEEK",  "EI33VK1505W4V", "14MM34R692905VH8JU", "9V88SK9R46541R15S473YJOX2", "1J37BT1125GCG", "15011R49IFD",  "K0F1162O4IR17ZK4G5", "WY262891016BC2", "6RS0954B97Z9T1H042", "YIRD110Z11IH44B6GPZT", "70D75615812B9U",  "49G477VV00B", "33813111VG9", "217XFCM5628353R1NLS", "0630277A6QHJUL18RJ", "16YZ7OO401197Z4H",  "1730337V9WEQLU", "RC4851672H6U519V", "T202SIIN12D227", "U2I266C9FN504M016UE2Y6AVY", "0220B5I3B536F14F4",  "ZCC23OM0163GW2E63O", "8O15AD7NG21172", "B91G155599ZT5", "4TAOF15193270Q149EO", "26O34173SI23S9",  "KSXS0288219V", "08043B76Q26V48O", "HO501434VP8G9UY10ZR4O3O9", "D4081411HKCA7KL9OA",  "38P6K4BR0410PWBS7V47U2S", "TSPT691TL025652397EN17C", "1139084POKA785", "12BDCOGIQLWR5S0101XHW4A",  "X20KMP3116X5BIF", "618WBRUR30029ZC6", "21403257T0CT0L", "221732C058WPCT", "84417J5177J0TPX",  "TND2397L16JY", "11AOBPOLJS56273C68A", "YDD22RX15E115JUDE31K2",  "amzn.gr.LX7H18H31N5PEGCV26DBC8-O9UvXg-VG", "T315JH24EN147LDV9BHW68P", "7QVZD3537P17U0", "036331Y3VTF",  "TLP45UW1196PZ8V", "SB114034SK5", "FR-2ZG7-G4IW", "U6HDX4F1957GF584F0PP2ECQB", "9P3149932755UP1",  "08A6MFIB8WX2443DG2N5ZG", "XC2GDME20UPR2MGI18113VM", "303NALK01617AF3TALF67U", "IRHYNR1047K05KOFGKYD3FZ",  "PFZV3451115UV", "XOT1511078WV", "244223A52Y0NS", "30M47OI45J06HSVD", "18V40M1518H",  "TY9V45C25KDP18EYSM5FB1", "L2113643O0GH093GJE", "M6415QCJK00EP35177E6DV", "6109O53JT3T16J",  "JA17Q581005D7", "OX01B1068PJAXFM23EZLREK", "1514NW6Y88V8YP5D59MYC", "K97S1244F12RGHZX",  "WZ7SBL12I01C443MMHI2DEN", "162812CALBM", "7V46WMV17YV113J3WGHX", "04536WREZH21IQJR", "441378FSI0G8",  "31E10UE19VD", "OL529B4ZEN642FO18K3R9", "H3T5H3221702UPKLXKE06O", "KM40046RT810005IQ9O",  "O7Y217HF8V240UXVQN03ZUD", "2276CB19Q1BM1B", "901SR32HN5CDY63322QCOMW", "6U2658XKPH2900Z",  "03R7736L15WIS73AL", "UZJXME2E229W34SI14M7TU", "276500O15O4", "UO05L33TVEXNU1XN819ZY",  "1C2406AHJ165IS808N1Q6O", "V114351LNA", "ZIN1GTMIGL2T4358R19UT8IF", "22IL2014DRJOS",  "A42B2DAYM512MCIZBU19EI", "WS987LT4426CKJJ16JBZCUAP", "EW28OI0067717Q8", "31388555GTM2GZ97OHFU7L8",  "R150108182", "423439FIK10Q8KIIYE6K", "FXZ05UE14R9126POLJMNNTH", "30XFQ54769YI16335QN0V2MY",  "H9NRTZ2BJUL215306MNUX", "NWSOR7H412R7TC1609QYPN", "20FYW4GQTC1F1298700EX", "CJCC13BTZSDLOUS5319SY0J9U",  "WA9QV69TF8EXK46TC1090LF2W", "32QO32CZ18ML", "T0517W40U617IANOAJO91YB", "27ZV8NUW10EZ40NED04OC8",  "4214RO19BTA", "KS4ECF1I2LC1625T4A249E10X", "LO3Y543239TOWD17L", "8B39I721OX110168LNAY6S5G",  "1310573ES14IM3", "Y5WO15R0616WM1CO", "8W16TBI48ZR3J4058KICXR", "7C4047QCF16PMXFN8"
  10. 2024-08-12 13:35:31, 由 罗友军 关联到迭代 智能中心-智能选品迭代 。
  11. 2024-08-12 16:01:44, 由 戴宝山 关闭，原因为 已完成 。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
    修改了 当前状态，旧值为 "active"，新值为 "closed"。
    修改了 指派给 ，旧值为 "daibaoshan"，新值为 "closed"。
    修改了 所处阶段，旧值为 "tested"，新值为 "closed"。
    修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2024-08-12 16:01:44"。
    修改了 由谁关闭，旧值为 ""，新值为 "daibaoshan"。
  12. 2024-08-13 18:05:57, 由 梁秀丽 编辑。
    修改了 成本 ，旧值为 "3000"，新值为 "2500"。
    修改了 ROI ，旧值为 "0.03"，新值为 "0.04"。
    修改了 预计工时，旧值为 "12"，新值为 "10"。
  13. 2025-03-20 15:32:27, 由 李亚婷 编辑。
    修改了 测试人员，旧值为 ""，新值为 "chengkuan"。
返回
迭代版本
提报业务部门
提报人员 陈芹
需求来源 业务方紧急需求
所属项目 智能中心-需求池
所属模块 战略独立项目   智能刊登
所属计划
业务价值 中心战略层
开发组
受益业务部门 亚马逊平台运营中心
验收人员 陈芹
业务目标类型 其他
中心业务目标 其他
业务价值
每月价值量 100
每月节省人数 0
优先级 P1
价值类型 短期价值
预计工时 10
成本 5000
ROI 0.02
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危
评分
当前状态 已关闭
所处阶段 已关闭
关键词 战略2024年8月5日
评审次数 一次
计划上线
上线时间 2024-08-09
计划验收时间 2024-08-16
业务验收时间
满意度
价值验收
满意度分值
业务回填价值
验收达成价值
验收达成ROI
抄送给
由谁创建 戴宝山 于 2024-08-02 18:40:49
指派给 Closed 于 2024-08-12 16:01:44
由谁评审 徐盛松
评审时间 2024-08-06
由谁关闭 戴宝山 于 2024-08-12 16:01:44
关闭原因 已完成
最后修改 李亚婷 于 2025-03-20 15:32:25
相关Bug
相关用例
相关需求
细分需求