DELETE FROM rotacionproducto WHERE bodegaid = 2 AND codperiodo = '012025';
INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('60713','2','012025','1','-7','1830600')
				,('65385','2','012025','1','-1','871200')
				,('60583','2','012025','1','-5','841456')
				,('60594','2','012025','1','-7','721248')
				,('60584','2','012025','1','-7','601040')
				,('64942','2','012025','1','-29','456790')
				,('64659','2','012025','59','-61','415264')
				,('43180','2','012025','0.0625','0','172800')
				,('46626','2','012025','0.03333333507180214','0','151500')
				,('43290','2','012025','0.07999999821186066','47','149500')
				,('57221','2','012025','1','2','149000')
				,('26533','2','012025','0.11999999731779099','58.00000009685755','122000')
				,('25457','2','012025','1','10','119500')
				,('64012','2','012025','1','0','119400')
				,('47540','2','012025','1','0','111800')
				,('46090','2','012025','0.2500000074505806','84.70833332464099','102500')
				,('49217','2','012025','3','0','99900')
				,('48112','2','012025','1','17','98500')
				,('31759','2','012025','0.10000000149011612','192.00000017186005','94000')
				,('49448','2','012025','1','22','92700')
				,('33310','2','012025','3','3','92100')
				,('25533','2','012025','1','80','91700')
				,('42051','2','012025','1','0','89900')
				,('44302','2','012025','0.10000000149011612','0.8999999836087227','86900')
				,('25456','2','012025','1','12','85500')
				,('62704','2','012025','1','10','84000')
				,('38541','2','012025','0.06666667014360428','12.866666441659163','82500')
				,('50923','2','012025','1','51','80000')
				,('54483','2','012025','1','112','79500')
				,('33555','2','012025','0.10000000149011612','135','76700')
				,('31775','2','012025','0.10000000149011612','52.99999972433349','73700')
				,('41144','2','012025','1','70','72500.03')
				,('61384','2','012025','0.27272728085517883','89','69100')
				,('55995','2','012025','0.5000000149011612','301.4999334307547','68000')
				,('25597','2','012025','1','3','68000')
				,('33334','2','012025','0.0416666679084301','55.91666655366586','63500')
				,('25785','2','012025','0.1250000037252903','101.9999671665341','63500')
				,('40253','2','012025','0.1666666716337204','166.91670000993412','63400')
				,('65129','2','012025','3','0','61500')
				,('22880','2','012025','0.23999999463558197','40.00000006705625','60100')
				,('64933','2','012025','0.0833333358168602','104.99999997764826','60000')
				,('50913','2','012025','1','242','59400')
				,('43264','2','012025','1','0','58600')
				,('56799','2','012025','1','12','57500')
				,('65349','2','012025','1','0','56900')
				,('45764','2','012025','0.0416666679084301','0','55200')
				,('28499','2','012025','1','0','54500')
				,('64116','2','012025','1','2','54000')
				,('25460','2','012025','1','14','53000')
				,('56535','2','012025','0.5000000074505806','744.1000000610948','52500')
					,('58572','2','012025','0.10000000149011612','0','52500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('49253','2','012025','0.0833333358168602','61.91666666418314','52500')
				,('31060','2','012025','0.2083333395421505','0.0416666604578495','52500')
				,('58101','2','012025','3','442','51200')
				,('25985','2','012025','0.03999999910593033','0','50000')
				,('62081','2','012025','6','531','49500')
				,('58109','2','012025','1','99','48800')
				,('49747','2','012025','0.06666667014360428','1.9666667670552256','48000')
				,('23505','2','012025','1','0','48000')
				,('37243','2','012025','1','42','47500')
				,('55738','2','012025','2','212','47100')
				,('58292','2','012025','1','238','47000')
				,('56910','2','012025','1','-1','45200')
				,('62769','2','012025','1','0','45000')
				,('54035','2','012025','1','93','44800')
				,('47936','2','012025','1','0','41200')
				,('30310','2','012025','1','0','41000')
				,('51671','2','012025','1','0','40500')
				,('56915','2','012025','2','0','40000')
				,('55307','2','012025','2','143','39600')
				,('38596','2','012025','1','7','39000')
				,('62528','2','012025','10','747','39000')
				,('23565','2','012025','0.5','693','37800')
				,('23804','2','012025','1','17','36500')
				,('48643','2','012025','1','458.99999999006593','36000')
				,('43221','2','012025','3','300','35700')
				,('31190','2','012025','0.20000000298023224','336.9999983832226','35000')
				,('28040','2','012025','1','4','34700')
				,('28024','2','012025','1','16','34700')
				,('54769','2','012025','1','13','34500')
				,('46776','2','012025','1','351','34200')
				,('26094','2','012025','1','13','33500')
				,('42837','2','012025','1','3','33300')
				,('46200','2','012025','0.9166666939854622','341.999969811252','32500')
				,('31078','2','012025','1','136','32000')
				,('29828','2','012025','1','0','30700')
				,('65311','2','012025','1','-1','30000')
				,('63593','2','012025','1','0','30000')
				,('45886','2','012025','0.5','342','30000')
				,('56887','2','012025','1','300','29900')
				,('23598','2','012025','1','0','29800')
				,('33276','2','012025','3','150','29500')
				,('31136','2','012025','1','300','29000')
				,('27603','2','012025','5','255','28900')
				,('57318','2','012025','3','82','28000')
				,('53684','2','012025','2','0','28000')
				,('62762','2','012025','2','43','28000')
				,('55878','2','012025','1','0','27500')
				,('43329','2','012025','2','91','27000')
				,('54380','2','012025','8','0','26500')
				,('57267','2','012025','2','99','26200')
					,('56184','2','012025','1','0','26000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('45871','2','012025','1','92','25800')
				,('34046','2','012025','1','12','25600')
				,('31151','2','012025','0.9000000059604645','898.7999999970198','25000')
				,('46328','2','012025','1','370','25000')
				,('48680','2','012025','1','0','24300')
				,('64097','2','012025','1','0','24200')
				,('56176','2','012025','1','108','23800')
				,('57266','2','012025','3','82','23600')
				,('53093','2','012025','1','66','22800')
				,('38668','2','012025','1','411','22700')
				,('44318','2','012025','1','75','22600')
				,('63778','2','012025','1','789','22500')
				,('49673','2','012025','1','260.99999982119016','22500')
				,('49544','2','012025','1','0','22500')
				,('23704','2','012025','0.6000000089406967','61','22500')
				,('31502','2','012025','0.6000000238418579','674.3999999463558','22500')
				,('50686','2','012025','1','3','22000')
				,('52823','2','012025','1','-1','22000')
				,('38459','2','012025','2','0','21900')
				,('43229','2','012025','1','218','21700')
				,('23550','2','012025','1','307','21500')
				,('24837','2','012025','1','6','20000')
				,('62091','2','012025','1','0','19900')
				,('38462','2','012025','2','3','19900')
				,('31133','2','012025','1','565','19900')
				,('54137','2','012025','3','40','19800')
				,('23597','2','012025','4','173','19800')
				,('56068','2','012025','1','83','19700')
				,('40547','2','012025','1','2259','19200')
				,('53897','2','012025','1','0','19000')
				,('51477','2','012025','1','0','19000')
				,('57295','2','012025','1','0','19000')
				,('31316','2','012025','1','401','18900')
				,('65513','2','012025','1','0','18800')
				,('41713','2','012025','1','0','18500')
				,('57148','2','012025','1','0','18500')
				,('39044','2','012025','1','476','18500')
				,('64730','2','012025','5','11','18500')
				,('43549','2','012025','1','227','18500')
				,('60205','2','012025','2','0','18300')
				,('23590','2','012025','1','65','18000')
				,('46169','2','012025','1','223','17900')
				,('26238','2','012025','2','278','17800')
				,('53989','2','012025','1','0','17400')
				,('28038','2','012025','1','51','16400')
				,('33866','2','012025','2','15','16300')
				,('53453','2','012025','5','0','16200')
				,('49922','2','012025','1','11','16200')
				,('64769','2','012025','10','-5','16100')
				,('48722','2','012025','1','24','16000')
					,('28143','2','012025','1','6','15700');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('24473','2','012025','1','176','15500')
				,('49898','2','012025','1','238','15500')
				,('53527','2','012025','1','118','15300')
				,('56014','2','012025','1','17','15300')
				,('41252','2','012025','1','38','15000')
				,('64354','2','012025','1','0','15000')
				,('59756','2','012025','1','0','15000')
				,('47121','2','012025','1','611','14900')
				,('27249','2','012025','1','3','14800')
				,('40264','2','012025','11','1','14700')
				,('31061','2','012025','2','191','14600')
				,('31758','2','012025','1','0','14500')
				,('48523','2','012025','0.5','1','14500')
				,('24273','2','012025','2','236','14500')
				,('26563','2','012025','1','1','14200')
				,('26551','2','012025','1','16','14200')
				,('57222','2','012025','1','260','13500')
				,('33273','2','012025','1','1104','13400')
				,('51643','2','012025','1','41','13200')
				,('56067','2','012025','1','0','13100')
				,('55329','2','012025','2','412','12700')
				,('59893','2','012025','1','0','12600')
				,('40346','2','012025','1','0','12500')
				,('27387','2','012025','1','0','12500')
				,('33749','2','012025','1','286','12500')
				,('27866','2','012025','1','0','12100')
				,('45904','2','012025','1','0','12000')
				,('28062','2','012025','2','33','11900')
				,('59312','2','012025','1','87','11900')
				,('48587','2','012025','1','390','11900')
				,('59469','2','012025','1','0','11900')
				,('41737','2','012025','1','220','11800')
				,('28031','2','012025','1','160','11800')
				,('40348','2','012025','1','27','11200')
				,('63745','2','012025','1.3333333432674408','105.99999997019768','11000')
				,('60314','2','012025','5','186','10700')
				,('46788','2','012025','4','279','10700')
				,('55332','2','012025','14','162','10500')
				,('27985','2','012025','1','91','10100')
				,('54066','2','012025','1','206','10100')
				,('53469','2','012025','2','0','10000')
				,('62109','2','012025','1','0','10000')
				,('44839','2','012025','1','289','9900')
				,('52920','2','012025','1','432','9900')
				,('42902','2','012025','1','118','9800')
				,('40265','2','012025','5','1','9700')
				,('22278','2','012025','1','24','9600')
				,('57203','2','012025','2','70','9500')
				,('52291','2','012025','4','0','9100')
				,('53366','2','012025','1','0','9100')
					,('47204','2','012025','12','1404','9000');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('65333','2','012025','1','971','8700')
				,('65334','2','012025','1','900','8700')
				,('40158','2','012025','1','202','8600')
				,('31300','2','012025','1','591','8500')
				,('55211','2','012025','1','307','8500')
				,('29857','2','012025','1','374','8200')
				,('46744','2','012025','4','190','8000')
				,('55331','2','012025','2','447','8000')
				,('24467','2','012025','2','98','8000')
				,('44379','2','012025','1','130','8000')
				,('46808','2','012025','1','0','8000')
				,('42930','2','012025','1','116','7900')
				,('44092','2','012025','2','72','7000')
				,('50903','2','012025','1','0','6900')
				,('31562','2','012025','1','1174','6900')
				,('43836','2','012025','1','119','6700')
				,('48626','2','012025','2','853','6500')
				,('62095','2','012025','1','31','6400')
				,('40798','2','012025','1','0','6400')
				,('54134','2','012025','1','286','6200')
				,('54346','2','012025','1','42','6100')
				,('32600','2','012025','10','274','6100')
				,('27763','2','012025','1','23','5900')
				,('36528','2','012025','1','0','5800')
				,('27809','2','012025','1','0','5700')
				,('54113','2','012025','2','58','5700')
				,('24370','2','012025','1','159','5500')
				,('27760','2','012025','1','130','5500')
				,('24465','2','012025','20','440','5300')
				,('51568','2','012025','4','0','5117')
				,('33561','2','012025','3','114','5100')
				,('28086','2','012025','1','24','5000')
				,('40145','2','012025','1','943','5000')
				,('40129','2','012025','1','359','5000')
				,('44951','2','012025','2','748','4800')
				,('48361','2','012025','5','622','4700')
				,('25884','2','012025','1','0','4700')
				,('49397','2','012025','4','98','4700')
				,('40301','2','012025','3','51','4600')
				,('25501','2','012025','1','-5','4600')
				,('56282','2','012025','2','2','4600')
				,('52775','2','012025','3','0','4500')
				,('60774','2','012025','1','78','4300')
				,('50940','2','012025','1','0','4200')
				,('62092','2','012025','2','0','4000')
				,('43316','2','012025','1','561','4000')
				,('43765','2','012025','1','19','4000')
				,('51004','2','012025','2','0','3900')
				,('54210','2','012025','1','245','3700')
				,('47372','2','012025','1','173','3700')
					,('54335','2','012025','26','257','3500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('44961','2','012025','2','2','3500')
				,('47117','2','012025','1','1620','3500')
				,('40282','2','012025','5','9','3400')
				,('31162','2','012025','1','37','3100')
				,('54241','2','012025','1','0','2800')
				,('52184','2','012025','84','23','2600')
				,('61820','2','012025','1','0','2500')
				,('59542','2','012025','2','0','2400')
				,('51649','2','012025','5','501','2400')
				,('24463','2','012025','1','1023','2400')
				,('38309','2','012025','1','75','2200')
				,('48019','2','012025','175','52','2200')
				,('38319','2','012025','1','0','2100')
				,('42905','2','012025','2','788','2000')
				,('53095','2','012025','1','652','2000')
				,('51908','2','012025','1','-1','2000')
				,('58909','2','012025','117','16','2000')
				,('42561','2','012025','1','60','1900')
				,('32623','2','012025','1','1128','1300')
				,('38407','2','012025','1','0','1200')
				,('49212','2','012025','23','0','1100')
				,('58629','2','012025','2','18002','1000')
				,('33316','2','012025','2','0','800')
				,('63651','2','012025','23','1777','800')
				,('46100','2','012025','2','4911','500')
				,('60547','2','012025','1','3252','500')
				,('63649','2','012025','90','0','500')
				,('58667','2','012025','100','4600','500')
				,('41226','2','012025','38255','-495208','247.59')
				,('65231','2','012025','189','-571.010009765625','100');
/* TOTAL LINEAS : 285 */