DELETE FROM rotacionproducto WHERE bodegaid = 2 AND codperiodo = '122024';
INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('60713','2','122024','1','-6','1830600')
				,('64365','2','122024','37','-61','1584100')
				,('60583','2','122024','1','-4','841456')
				,('60594','2','122024','1','-6','721248')
				,('60584','2','122024','1','-6','601040')
				,('64659','2','122024','1','-3','500000')
				,('40451','2','122024','2','0','341000')
				,('38142','2','122024','2','0','193900')
				,('32830','2','122024','1','0','168300')
				,('43290','2','122024','0.03999999910593033','1.080000076442957','149500')
				,('39793','2','122024','1','13','143500')
				,('50908','2','122024','1','0','128700')
				,('64854','2','122024','3','-6','120000')
				,('65130','2','122024','2','0','109900')
				,('46090','2','122024','0.2500000074505806','0','102500')
				,('55304','2','122024','0.30000000447034836','222.00000022351742','90000')
				,('60323','2','122024','1','0','84600')
				,('38541','2','122024','0.13333334028720856','39.93333311925335','82500')
				,('41855','2','122024','1.4000000059604645','-0.999999980598659','80200')
				,('52284','2','122024','1','183','79500')
				,('53955','2','122024','3','0','75500')
				,('23552','2','122024','1','2','75300')
				,('61329','2','122024','1','187','74500')
				,('38852','2','122024','0.20000000298023224','44.999999955296516','74500')
				,('61330','2','122024','1','208','74500')
				,('31775','2','122024','0.10000000149011612','22.99999970198175','73700')
				,('33629','2','122024','0.10000000149011612','122.00000002235174','72000')
				,('51396','2','122024','1','1','71600')
				,('33743','2','122024','0.0833333358168602','9.999999977648258','69900')
				,('46895','2','122024','0.03333333507180214','23.000033885173536','66600')
				,('22214','2','122024','1','72','66000')
				,('58898','2','122024','0.2666666805744171','36.46666658918059','64500')
				,('29762','2','122024','0.03999999910593033','13.000000000894069','63900')
				,('40253','2','122024','0.1666666716337204','87.8333666592161','63400')
				,('41135','2','122024','1','1','62000')
				,('28581','2','122024','1','0','61800')
				,('65129','2','122024','20','0','61500')
				,('38791','2','122024','4','0','60100')
				,('22880','2','122024','0.2799999937415123','29.92000009119613','60100')
				,('40116','2','122024','1','0','60000')
				,('45764','2','122024','0.1250000037252903','0','55200')
				,('25985','2','122024','0.1599999964237213','2.960000030696392','50000')
				,('56817','2','122024','0.30000000447034836','0','49000')
				,('55810','2','122024','0.2222222238779068','0','48900')
				,('55323','2','122024','2','0','48500')
				,('49747','2','122024','0.40000002086162567','1.0333334021270275','48000')
				,('56914','2','122024','1','16','47000')
				,('56535','2','122024','0.30000000447034836','318.1000000163913','47000')
				,('65278','2','122024','1','0','47000')
				,('28153','2','122024','1','62','45000')
					,('50642','2','122024','1','0','45000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('65509','2','122024','1','0','44900')
				,('54035','2','122024','1','42','44800')
				,('49164','2','122024','1','4','41400')
				,('53385','2','122024','1','28','38900')
				,('64050','2','122024','2','0','38000')
				,('33760','2','122024','2','0','38000')
				,('27359','2','122024','2','0','37900')
				,('54895','2','122024','1','10','37500')
				,('65505','2','122024','1','0','37500')
				,('52340','2','122024','1','0','36800')
				,('30328','2','122024','1','0','36500')
				,('48336','2','122024','1','2','35900')
				,('64976','2','122024','1','0','35000')
				,('48941','2','122024','1','221','35000')
				,('31190','2','122024','0.20000000298023224','330.7999983951435','35000')
				,('28024','2','122024','1','28','34700')
				,('54476','2','122024','0.3333333432674408','104.99999997019768','34500')
				,('46776','2','122024','0.7500000074505806','5.000000022351742','34200')
				,('45887','2','122024','3','40','33600')
				,('61815','2','122024','1','0','33000')
				,('46200','2','122024','0.5000000149011612','10.916633154519445','32500')
				,('33173','2','122024','1','126','32100')
				,('46791','2','122024','1','1','32000')
				,('25902','2','122024','1','0','32000')
				,('40104','2','122024','1','0','32000')
				,('24406','2','122024','1','0','32000')
				,('43743','2','122024','1','2','31000')
				,('51697','2','122024','1','59','30500')
				,('60289','2','122024','1','-1','30000')
				,('56887','2','122024','1','0','29900')
				,('30280','2','122024','1','155','29500')
				,('40049','2','122024','1','0','29100')
				,('42934','2','122024','2','151','28500')
				,('58051','2','122024','0.10000000149011612','3.000000022351742','28000')
				,('53683','2','122024','1','11','28000')
				,('54720','2','122024','2','4','28000')
				,('56015','2','122024','1','0','26500')
				,('40230','2','122024','2','0','26500')
				,('39987','2','122024','1','20','26400')
				,('56184','2','122024','1','0','26000')
				,('23185','2','122024','1','0','25900')
				,('63963','2','122024','2','0','25800')
				,('30610','2','122024','1','0','25500')
				,('30694','2','122024','1','0','24500')
				,('43129','2','122024','0.5','0','24500')
				,('27805','2','122024','2','106','24500')
				,('65508','2','122024','1','0','24200')
				,('45856','2','122024','1','64','24000')
				,('32885','2','122024','1','65','23900')
				,('32908','2','122024','1','-1','23900')
					,('56176','2','122024','1','165','23800');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('23202','2','122024','1','28','23400')
				,('28134','2','122024','1','41','23300')
				,('47452','2','122024','2','12','22600')
				,('23704','2','122024','0.800000011920929','0.3999999016523361','22500')
				,('43967','2','122024','1','10','22000')
				,('50792','2','122024','1','2','22000')
				,('43964','2','122024','1','12','21900')
				,('28176','2','122024','1','0','21800')
				,('60768','2','122024','0.4000000059604645','0','21700')
				,('33107','2','122024','1','2','21700')
				,('33104','2','122024','1','0','21700')
				,('55892','2','122024','2','9','21500')
				,('40254','2','122024','1','182','20600')
				,('24838','2','122024','1','0','20500')
				,('34503','2','122024','1','0','20000')
				,('34506','2','122024','1','25','20000')
				,('64803','2','122024','2','0','19900')
				,('42931','2','122024','1','229','19700')
				,('56068','2','122024','1','1','19500')
				,('62658','2','122024','1','14','19500')
				,('62312','2','122024','1','0','19400')
				,('40547','2','122024','1','1195','19200')
				,('23303','2','122024','1','62','19000')
				,('65513','2','122024','7','1','18800')
				,('64730','2','122024','3','41','18500')
				,('62091','2','122024','2','8','18500')
				,('60205','2','122024','1','10','18300')
				,('24441','2','122024','1','64','18300')
				,('40074','2','122024','1','6','18300')
				,('43631','2','122024','1','0','18000')
				,('27988','2','122024','1','39','17900')
				,('52380','2','122024','1','0','17900')
				,('22873','2','122024','1','238','17200')
				,('39151','2','122024','2','244','17100')
				,('52165','2','122024','1','129','16900')
				,('64724','2','122024','1','0','16500')
				,('58105','2','122024','1','56','16500')
				,('28021','2','122024','2','5','16400')
				,('28038','2','122024','1','29','16400')
				,('26534','2','122024','1.3333333730697632','166.99999991059303','16100')
				,('40002','2','122024','1','63','15800')
				,('48127','2','122024','7','12','15700')
				,('43203','2','122024','1','5','15500')
				,('49898','2','122024','20','-1','15500')
				,('24473','2','122024','2','0','15500')
				,('26308','2','122024','1','0','15500')
				,('54219','2','122024','2','9','15300')
				,('56014','2','122024','1','19','15300')
				,('47121','2','122024','1','112','14900')
				,('60938','2','122024','1','0','14900')
					,('56561','2','122024','1','14','14900');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('43991','2','122024','1','0','14700')
				,('39820','2','122024','1','134','14500')
				,('43398','2','122024','1','183','14500')
				,('57775','2','122024','3','0','14500')
				,('23201','2','122024','1','38','14100')
				,('51483','2','122024','2','94','14000')
				,('41154','2','122024','1','102','14000')
				,('31061','2','122024','1','121','13900')
				,('28686','2','122024','1','0','13500')
				,('56067','2','122024','3','2','13100')
				,('43131','2','122024','1','0','13000')
				,('60600','2','122024','1','2','13000')
				,('47102','2','122024','1','0','13000')
				,('25916','2','122024','1','0','12900')
				,('31223','2','122024','3','175','12900')
				,('55329','2','122024','2','489','12700')
				,('32241','2','122024','2','0','12500')
				,('53897','2','122024','1','98','12500')
				,('27387','2','122024','1','257','12500')
				,('26042','2','122024','1','49','12300')
				,('33174','2','122024','2','195','12100')
				,('60556','2','122024','1','39','12000')
				,('27847','2','122024','1','0','12000')
				,('62114','2','122024','1','0','12000')
				,('59469','2','122024','1','20','11900')
				,('52096','2','122024','1','17','11900')
				,('60560','2','122024','1','0','11900')
				,('28031','2','122024','2','32','11800')
				,('28004','2','122024','2','2','11600')
				,('31764','2','122024','1','0','11500')
				,('59612','2','122024','1','0','11500')
				,('25936','2','122024','1','233','11400')
				,('46903','2','122024','2','-1','11000')
				,('62120','2','122024','1','5','10900')
				,('62130','2','122024','1','1','10900')
				,('31632','2','122024','1','1346','10900')
				,('65506','2','122024','2','-4','10900')
				,('42395','2','122024','1','12','10900')
				,('46788','2','122024','1','4','10700')
				,('59694','2','122024','2','0','10700')
				,('31314','2','122024','2','437','10500')
				,('55332','2','122024','4','310','10500')
				,('24342','2','122024','1','2','10400')
				,('58647','2','122024','1','78','10400')
				,('44177','2','122024','2','6','10300')
				,('24460','2','122024','1','0','10200')
				,('22843','2','122024','1','172','10200')
				,('27985','2','122024','1','158','10100')
				,('45904','2','122024','3','-6','10000')
				,('52477','2','122024','1','138','10000')
					,('31177','2','122024','1','129','10000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('53469','2','122024','2','39','10000')
				,('65307','2','122024','1','0','9900')
				,('56917','2','122024','1','0','9900')
				,('22275','2','122024','2','10','9600')
				,('39977','2','122024','4','42.00000011920929','9500')
				,('27765','2','122024','1','479','9400')
				,('42402','2','122024','1','47','9200')
				,('53366','2','122024','2','1','9100')
				,('33225','2','122024','2','0','9100')
				,('55564','2','122024','2','0','9000')
				,('54196','2','122024','2','12','9000')
				,('56907','2','122024','1','0','9000')
				,('40158','2','122024','1','0','8600')
				,('31300','2','122024','3','680','8500')
				,('24361','2','122024','1','0','8500')
				,('55558','2','122024','2','0','8500')
				,('50004','2','122024','1','1','8300')
				,('52238','2','122024','1','1','8300')
				,('52600','2','122024','1','0','8100')
				,('46744','2','122024','1','0','8000')
				,('55331','2','122024','1','562','8000')
				,('55330','2','122024','2','397','8000')
				,('46808','2','122024','1','14','8000')
				,('44379','2','122024','4','24','8000')
				,('24467','2','122024','5','42','8000')
				,('54112','2','122024','1','89','7600')
				,('55567','2','122024','1','0','7600')
				,('61478','2','122024','1','0','7500')
				,('34241','2','122024','1','0','7100')
				,('29743','2','122024','1','0','7000')
				,('58609','2','122024','1','66','7000')
				,('58162','2','122024','1','0','7000')
				,('50903','2','122024','2','3','6900')
				,('43836','2','122024','1','55','6700')
				,('55176','2','122024','1','-1','6700')
				,('55527','2','122024','1','0','6600')
				,('48362','2','122024','1','-3','6400')
				,('62094','2','122024','1','7','6400')
				,('48626','2','122024','1','821','6300')
				,('30214','2','122024','2','176','6100')
				,('61231','2','122024','1','6','6000')
				,('39985','2','122024','1','0','5900')
				,('33960','2','122024','3','0','5900')
				,('27763','2','122024','1','448','5900')
				,('49943','2','122024','3','13','5900')
				,('27809','2','122024','1','90','5700')
				,('24465','2','122024','10','757','5300')
				,('52324','2','122024','3','1','5200')
				,('27760','2','122024','1','201','5200')
				,('52311','2','122024','6','-1','5200')
					,('52613','2','122024','2','0','5200');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('33561','2','122024','1','55','5100')
				,('61819','2','122024','1','0','5000')
				,('40129','2','122024','4','30','5000')
				,('40145','2','122024','6','305','5000')
				,('28082','2','122024','1','52','4900')
				,('49397','2','122024','1','274','4700')
				,('48361','2','122024','4','484','4700')
				,('56006','2','122024','4','145','4700')
				,('40301','2','122024','1','541','4600')
				,('25501','2','122024','3','-5','4600')
				,('48567','2','122024','2','0','4500')
				,('65244','2','122024','1','0','4500')
				,('53264','2','122024','4','47','4500')
				,('52775','2','122024','4','114','4500')
				,('52774','2','122024','1','0','4500')
				,('26149','2','122024','1','644','4500')
				,('56125','2','122024','2','0','4400')
				,('60774','2','122024','3','39','4300')
				,('56066','2','122024','1','140','4200')
				,('50940','2','122024','1','88','4200')
				,('39525','2','122024','1','0','4000.36')
				,('52255','2','122024','1','2','4000')
				,('56054','2','122024','3','103','4000')
				,('62092','2','122024','1','108','4000')
				,('45305','2','122024','1','433','4000')
				,('55624','2','122024','1','1102','4000')
				,('63957','2','122024','1','1302','3999.99')
				,('51004','2','122024','3','90','3900')
				,('27762','2','122024','1','315','3800')
				,('42929','2','122024','1','24','3800')
				,('27041','2','122024','3','0','3600')
				,('47117','2','122024','3','0','3500')
				,('54335','2','122024','2','414','3500')
				,('40148','2','122024','1','56','3300')
				,('31162','2','122024','1','101','3100')
				,('50107','2','122024','1','346','3000')
				,('27772','2','122024','1','237','2900')
				,('54241','2','122024','20','0','2800')
				,('42770','2','122024','2','0','2700')
				,('52184','2','122024','14','981','2600')
				,('30195','2','122024','1','189','2500')
				,('40279','2','122024','1','189','2400')
				,('38309','2','122024','5','55','2200')
				,('38319','2','122024','3','0','2100')
				,('53095','2','122024','2','907','2000')
				,('40350','2','122024','2','-10','2000')
				,('51908','2','122024','3','47','2000')
				,('62082','2','122024','2','0','2000')
				,('62093','2','122024','3','0','1500')
				,('47497','2','122024','1','124','1500')
					,('32623','2','122024','3','417','1300');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('24519','2','122024','3','-1','1300')
				,('38407','2','122024','4','0','1200')
				,('49212','2','122024','5','289','1100')
				,('33316','2','122024','1','49','800')
				,('60547','2','122024','1','4053','500')
				,('46100','2','122024','8','6711','500')
				,('58481','2','122024','9','2291','500')
				,('63649','2','122024','4','90','500')
				,('61025','2','122024','1','126','300')
				,('44347','2','122024','2','-588199','300')
				,('41226','2','122024','41398','-456953','235.36')
				,('65231','2','122024','382.010009765625','-382.010009765625','100')
				,('40609','2','122024','20','-19','100')
				,('49226','2','122024','31','-599','0');
/* TOTAL LINEAS : 320 */