DELETE FROM rotacionproducto WHERE bodegaid = 742 AND codperiodo = '062023';
INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('61323','742','062023','0.33333333333333','1.66666666666667','140000')
				,('51646','742','062023','0.111111111111112','1.888888888888888','126000')
				,('22870','742','062023','0.04','0.96','100000')
				,('31759','742','062023','0.1','1.833333333333334','89400')
				,('37241','742','062023','0.055555555555556','1.944444444444444','84000')
				,('33555','742','062023','0.2','4.700000000000001','70000')
				,('41855','742','062023','0.8','10.200000000000006','67000')
				,('38410','742','062023','1','1','64000')
				,('29762','742','062023','0.04','0.9199999999999999','62500')
				,('54483','742','062023','0.33333333333333','1.66666666666667','62000')
				,('61384','742','062023','0.136363636363636','1.636363636363638','61600')
				,('40253','742','062023','0.083333333333333','2.583333333333335','61600')
				,('46895','742','062023','0.066666666666667','1.866666666666667','60400')
				,('22880','742','062023','0.04','1.92','52000')
				,('50766','742','062023','1','0','46000')
				,('30328','742','062023','1','1','31600')
				,('23577','742','062023','0.5','1.5','30000')
				,('54418','742','062023','1','0','29900')
				,('46200','742','062023','0.25','3.9166666666666585','28800')
				,('45395','742','062023','1','1','28000')
				,('33638','742','062023','0.083333333333333','1.7500000000000009','27600')
				,('46328','742','062023','0.04','3.96','25000')
				,('45567','742','062023','0.5','1.25','24000')
				,('54481','742','062023','2','2','23000')
				,('32886','742','062023','1','1','21500')
				,('31151','742','062023','0.30000000000000004','3.7000000000000015','20000')
				,('49673','742','062023','0.33333333333333','3.66666666666667','20000')
				,('29858','742','062023','1','9','14900')
				,('58552','742','062023','1','1','14000')
				,('45885','742','062023','1','9','14000')
				,('51777','742','062023','2','0','14000')
				,('39041','742','062023','1','3','13600')
				,('31314','742','062023','1','3','10500')
				,('55608','742','062023','1','8','10000')
				,('54776','742','062023','1','0','9100')
				,('22275','742','062023','1','10','8200')
				,('47204','742','062023','1','11','8000')
				,('33981','742','062023','1','32','8000')
				,('59849','742','062023','2','10','8000')
				,('47205','742','062023','3','30','8000')
				,('47206','742','062023','1','21','8000')
				,('24310','742','062023','1','0','7400')
				,('60551','742','062023','1','2','7300')
				,('41860','742','062023','1','-1','7000')
				,('23570','742','062023','1','3','6000')
				,('48626','742','062023','1','3','5500')
				,('49419','742','062023','1','7','4400')
				,('24370','742','062023','0.5','5','4400')
				,('27763','742','062023','1','2','4000')
				,('43316','742','062023','1','5','3900')
					,('22832','742','062023','3','-5','3500');

INSERT IGNORE INTO rotacionproducto(productoid, bodegaid, codperiodo, salidas , existencia , precio) VALUES ('49250','742','062023','1','-1','3000')
				,('24463','742','062023','1','10','2400')
				,('56937','742','062023','1','-3','2100')
				,('48019','742','062023','8','107','2000')
				,('59924','742','062023','3.5','-3.5','1000')
				,('44348','742','062023','1','-1','1000')
				,('44347','742','062023','9','3967','100')
				,('49226','742','062023','31','-36','0');
/* TOTAL LINEAS : 59 */