DROP TABLE IF EXISTS `products`;
            CREATE TABLE `products` (
            `productid` varchar(250) NOT NULL,
            `prodname` varchar(250) DEFAULT NULL,
            `supplierid` varchar(250) DEFAULT NULL,
            `unitprice` varchar(250) DEFAULT NULL,
            `discounts` varchar(250) DEFAULT NULL,
            `misccode` varchar(250) DEFAULT NULL,
            `ProductType` varchar(250) DEFAULT NULL,
            PRIMARY KEY (`productid`)
          );insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001','ABBOTT LABORATORIES','1','0.00','5.00','','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001001','ARTIFEN 50MG TAB','NULL','297.95','5.00','ART50T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001002','ARTIFEN INJECTION','NULL','86.00','5.00','ARTINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001003','HYTRIN TAB 2MG','NULL','375.74','5.00','HYT2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001004','HYTRIN TAB 5MG','NULL','901.77','5.00','HYT5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001005','SURBEX-Z TAB LARGE','NULL','142.80','5.00','SURZ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001006','COLOFAC TAB 135MG','NULL','175.06','0.00','COL135','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001007','ENOXABID TAB 400MG','NULL','604.25','5.00','EXO400','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001008','GANATON TAB','NULL','127.50','5.00','GAN50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001009','GANATON-OD TAB','NULL','280.50','5.00','GANOD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001010','PRAMET-FA TAB','NULL','129.63','5.00','PMTFA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001011','DUPHASTON TAB 10MG','NULL','365.50','0.00','DUPH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001012','IBERET FOLIC 500 LARGE','NULL','96.90','5.00','IBF500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001013','IBERET SYP 500','NULL','41.65','5.00','IBSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001014','ARINAC FORTE TAB','NULL','340.34','5.00','ARNFORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001015','ARINAC PLAIN TAB','NULL','194.48','5.00','ARPLA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001016','ARINAC SYP','NULL','33.15','5.00','ARSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001017','KLARICID TAB 250MG','NULL','304.83','5.00','KL250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001018','KLARICID TAB 500MG','NULL','551.25','5.00','KL500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001019','KLARICID-XL TAB','NULL','212.50','5.00','KLXL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001020','KLARICID I.V INJ','NULL','136.00','5.00','KLIV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001021','SERC TABS 16MG','NULL','376.29','0.00','SR16','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001022','SERC TAB 8MG','NULL','216.27','0.00','SR8','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001023','EPIVAL TAB 250MG','NULL','347.96','5.00','EP250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001024','EPIVAL TAB 500MG','NULL','606.90','5.00','EP500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001025','EPIVAL CR 500 TAB','NULL','535.18','5.00','EPCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001026','EPIVAL I.V INJ','NULL','69.70','5.00','EPIV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001027','EPIVAL SYRUP','NULL','54.21','5.00','EPSP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001028','FLEXIN 250MG TAB','NULL','94.34','5.00','FLX250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001029','FLEXIN 500MG','NULL','169.01','5.00','FLX500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001030','SPARAXIN TAB 100MG','NULL','501.13','5.00','SPRX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001031','BECEFOL TAB SMALL','NULL','59.50','5.00','BECF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001032','BRUFEN TAB 400MG','NULL','340.00','5.00','BF400','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001033','BRUFEN TAB 600MG','NULL','91.80','5.00','BF600','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001034','BRUFEN PLUS TAB','NULL','76.50','5.00','BFPLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001035','BRUFEN CREAM','NULL','32.56','5.00','BFCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001036','URIXIN TABS','NULL','761.70','5.00','URX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001037','RONDEC-C SYRUP','NULL','36.55','5.00','RONDC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001038','BRUFEN SUSP','NULL','30.60','5.00','BFSP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001039','FROBEN TAB 100MG','NULL','158.10','5.00','FRB100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001040','FROBEN GEL','NULL','72.93','5.00','FRBGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001041','VIDAYLIN PLAIN SYP','NULL','42.50','5.00','VIDPL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001042','VIDAYIN DROPS','NULL','22.10','5.00','VIDDRPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001043','VIDAYLIN-L SYP','NULL','90.95','5.00','VID-L','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001044','VIDAYLIN-M SYP','NULL','45.90','5.00','VIDM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001045','VIDAYLIN-T TAB','NULL','79.90','5.00','VIDT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001046','ABOCAIN SPINAL INJ','NULL','194.48','5.00','ABOSP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001047','ARTELAX INJ','NULL','439.35','5.00','ARTINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001048','ARTELAX INJ','NULL','849.64','5.00','ARTINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001049','DOBUTAMINE HCL INJ','NULL','328.68','5.00','DOBU','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001050','LUCRIN INJ DEPOT','NULL','8089.62','5.00','LUC3.75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001051','VANCOMYCIN INJ 1GM','NULL','1131.97','5.00','VAN1','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001052','VANCOMYCIN INJ 500MG','NULL','631.86','5.00','VANCO500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001053','ERYBRON GRANULES','NULL','35.96','0.00','ERYGR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001054','ERYBRON TABS','NULL','547.05','0.00','ERYTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001055','TRONOLANE CREAM','NULL','28.80','5.00','TROCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001056','ERYDERM LOTION','NULL','21.11','0.00','ERYD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001057','ERYTHROCIN TAB 250MG','NULL','267.75','0.00','ERY250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001058','ERYTHROCIN TAB 500MG','NULL','469.82','0.00','ERY500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001059','ERYTHROCIN SYP','NULL','31.39','0.00','ERYSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001060','FROBEN SR CAPS','NULL','480.34','5.00','FROSR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001061','BEJECTAL INJ (INF PACK)','NULL','27.20','5.00','BEJINF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001062','BEJECTAL-T INJ','NULL','34.85','5.00','BEJT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001063','BEVIDOX TAB SMALL','NULL','42.50','5.00','BEVSM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001064','BEVIDOX TABLET MEDIUM','NULL','80.75','5.00','BEVMED','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001065','BEVIDOX TAB LARGE','NULL','133.45','5.00','BEVLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001066','BREMAX 1MG TAB','NULL','112.72','5.00','BRE1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001067','BREMAX 2MG TAB','NULL','212.91','5.00','BRE2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001068','BREMAX SYRUP','NULL','25.04','5.00','BRESYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001069','BRUFEN TAB 200MG','NULL','365.50','5.00','BR200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001070','CECON DROPS','NULL','18.70','5.00','CECDRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001071','CECON-500 TAB CHEWABLE','NULL','59.50','5.00','CECCHEW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001072','CREMAFFIN SYP','NULL','28.90','5.00','CREM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001073','COFCOL ELIXIR SYP SMALL','NULL','22.10','5.00','COFSMAL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001074','COFCOL ELIXIR SYP LARGE','NULL','46.75','5.00','COFCLARG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001075','COFCOL TABLET','NULL','425.00','5.00','COFCTA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001076','DAYALETS TABS','NULL','70.55','5.00','DAYLTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001077','DAYCOR SYP','NULL','56.10','5.00','DAYC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001078','DIJEX MP MIXED FRUIT SYP','NULL','28.90','5.00','DIJMF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001079','DIJEX MP SYP','NULL','28.90','5.00','DIJMP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001080','ENTAMIZOLE SS TABS','NULL','62.90','5.00','ENTSS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001081','ERYTHROCON DROPS','NULL','17.22','0.00','ERYDRPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001082','FAVERIN TABS 50MG','NULL','970.00','0.00','FAV50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001083','FAVERIN TABS 100MG','NULL','321.62','0.00','FAV10010','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001084','FAVERIN TAB 100MG','NULL','960.73','0.00','FAV10030','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001085','FEMOSTON 2/10MG TABS','NULL','563.99','5.00','FEMOS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001086','FROBEN TAB 50MG','NULL','120.48','5.00','FRO50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001087','HYTRIN TAB 1MG','NULL','187.87','5.00','HYT1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001088','IBERET DROPS','NULL','12.52','5.00','IBTDRPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001089','IBERET-500 LARGE TAB','NULL','94.35','5.00','IBLRTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001090','LOFTYL TABS 300MG','NULL','545.79','5.00','LOFT300','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001091','LOFTYL INJ 5ML','NULL','41.81','5.00','LOFTINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001092','MUCOLATOR TAB 200MG','NULL','272.72','5.00','MUC200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001093','NEOPHAGE TAB 500GM','NULL','47.29','5.00','NEO500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001094','NICOR SYP','NULL','56.10','5.00','NICSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001095','OPTILETS-M NEW','NULL','45.90','5.00','OPTM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001096','PROTHIADEN TAB25MG','NULL','80.16','5.00','PRO25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001097','PROTHIADEN TAB 75MG','NULL','58.61','5.00','PRO75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001098','PROTIUM TAB','NULL','734.16','5.00','PROT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001099','SURBEX SYP','NULL','39.95','5.00','SURB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001100','TEVETEN TAB 600MG','NULL','994.50','0.00','TEVE600','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001101','THEOGRAD TAB','NULL','169.89','5.00','THEO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001102','TRIVIDOX INJ','NULL','242.25','5.00','TRIV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001103','DUPHALAC SYP 240MG','NULL','238.54','0.00','DUPH240','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001104','ENTAMIZOLE DS TABS','NULL','62.90','5.00','ENTDS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001105','ENTAMIZOLE SYP','NULL','44.20','5.00','ENTSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001106','KLARICID GRANULES','NULL','267.37','5.00','KLAGRA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001107','SILLIVER TAB LARGE','NULL','152.93','5.00','SILLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001108','SILLIVER SUSP','NULL','64.60','5.00','SILLSUSP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001109','MOKSI TABLETS','NULL','403.75','5.00','MOKSI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001110','ATRALAX INJ','NULL','439.35','6.00','ATRLX2.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001111','ATRALAX INJ','NULL','849.64','5.00','ATRLX5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001112','PENTOTHAL SODIUM INJ','NULL','1445.00','5.00','PNTHL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001113','DUPHALAC SYP 120ML','NULL','126.34','0.00','DUPH120','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001114','SERC 24MG','NULL','394.40','0.00','SRC24','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001115','BRUFEN DS SYP','NULL','51.00','2.00','BRF DS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001116','EPIVAL LARGE SYP','NULL','102.85','2.00','EPI LRG SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('001117','LUCRIN DEPOT 11.25MG','NULL','21000.00','0.00','LCRN DPT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002','ATCO LABORTORIES','2','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002001','A FANTRINE -BD TABS','NULL','249.90','5.00','AFNTBD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002002','A FANTRINE D-S TAB','NULL','209.95','5.00','AFANDS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002003','A FANTRINE SMALL SYP','NULL','72.25','5.00','AFNTSMSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002004','A FANTRINE SYP','NULL','124.95','5.00','AFANLSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002005','A FANTRINE TAB','NULL','209.96','5.00','AFANTTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002006','BETADERM-N 15G CREAM','NULL','28.90','5.00','BETN15CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002007','BETADERM-N 15G OINT','NULL','28.90','5.00','BETN15OINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002008','BETADERM-N 5G CREAM','NULL','12.78','5.00','BET5GCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002009','BETADERM-N 5G OINT','NULL','12.78','5.00','BETN5GOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002010','BRONKOL SOLUTION','NULL','26.35','5.00','BRNKLSOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002011','BRONKOL SYP','NULL','20.40','5.00','BRNKLSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002012','COMBINOL-E SYP','NULL','30.60','5.00','COMBE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002013','PRICKLY BAR','NULL','54.00','5.00','PRKBR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002014','SOLO 10MG TAB','NULL','214.20','5.00','SOLO10MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002015','XYLOR 10MG TAB','NULL','102.00','5.00','XYLR10MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002016','COMBINOL JUNIOR SYP','NULL','25.50','5.00','COMBJUN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002017','MICRONEMA B/L SMALL','NULL','20.33','5.00','MICBLSM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002018','MINIRIN 0.1MG TAB','NULL','2032.32','0.00','MIN0.1','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002019','MINIRIN 0.2MG TAB','NULL','3306.16','0.00','MIN0.2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002020','MINIRIN NASAL SPRAY','NULL','1668.63','5.00','MINNSSPRY','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002021','OSMOLOR BANANA','NULL','119.00','5.00','OSMBAN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002022','SMECTA POWDER','NULL','357.00','5.00','SMCTAPDR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002023','SOLO 4MG SACHET','NULL','154.70','5.00','SOLO4MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002024','SOLO 5MG TAB','NULL','166.60','5.00','SOLO5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002025','VOMILUX SYP','NULL','29.75','5.00','VMLXSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002026','XYLOR SYP','NULL','34.00','5.00','XYLRSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002027','ZINCAT-OD SYP','NULL','51.00','5.00','ZINCOD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002028','GLYPRESSIN 1MG INJ','NULL','1691.50','5.00','GLYS1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002029','LEVERON 3MIU INJ','NULL','625.00','5.00','LEV3MIU','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002030','LEVERON 5MIU INJ','NULL','1530.00','5.00','LEV5MIU','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002031','PENTASA 500MG TAB','NULL','1878.50','0.00','PENT500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002032','SILCHOL TAB','NULL','154.70','5.00','SILTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002033','VIREX 400MG CAP(FREE)','NULL','0.10','5.00','VIREX400','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002034','ASCARD 75MG TAB','NULL','28.05','5.00','ASC75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002035','ASCARD 150MG TAB','NULL','37.40','5.00','ASC150','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002036','ASCARD 300MG TAB','NULL','44.20','5.00','ASC300','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002037','ASCARD PLUS TAB','NULL','102.00','5.00','ASCPLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002038','LAME10MG TAB','NULL','212.50','5.00','LAME10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002039','LAME 5MG TAB','NULL','110.50','5.00','LAME5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002040','LAMORETIC TAB','NULL','331.50','5.00','LAMTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002041','VASTOR-AM 10MG TAB','NULL','119.00','5.00','VASTRAM10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002042','VASTOR AM 5MG TAB','NULL','102.00','5.00','VSTRAM5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002043','ATCOGREL 10MG TAB','NULL','166.60','5.00','AGR 10.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002044','ATCOGREL 5MG TAB','NULL','100.30','5.00','AGR 5.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002045','DEPONIT-10 PLS','NULL','637.50','0.00','DEP 10.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002046','DEPONIT 5 PLS','NULL','382.50','0.00','DEP 5.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002047','ELANTAN-20 TAB','NULL','163.12','5.00','ELN 20.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002048','ELANTAN-40 TAB','NULL','262.04','5.00','ELN 40.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002049','ELANTAN LONG CAP','NULL','424.15','5.00','ELN LG.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002050','ISOKET I-V10MG INJ','NULL','1233.20','5.00','ISO IV.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002051','ISOKET RETARD TAB','NULL','142.75','5.00','ISO RT.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002052','MEROL 1MG INJ','NULL','161.50','5.00','MER IV.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002053','ROVATOR 10MG TAB','NULL','149.55','5.00','ROV 10.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002054','ROVATOR 20MG TAB','NULL','246.50','5.00','ROV 20.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002055','ROVATOR 5MG TAB','NULL','89.25','5.00','ROV 5.','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002056','CARDNIT 2.6MG TAB','NULL','133.45','5.00','CARD2.6','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002057','CARDNIT 6.4MG TAB','NULL','157.25','5.00','CRDNT6.4','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002058','DIOPLUS 5/80 TAB','NULL','191.25','5.00','DPLUS580','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002059','DIOPLUS 5/160 TAB','NULL','306.00','5.00','DPLS5160','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002060','DIOPLUS 10/160 TAB','NULL','331.50','5.00','DPLUS10160','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002061','MEROL 25MG TAB','NULL','40.80','5.00','MRL25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002062','MEROL 50MG TAB','NULL','68.00','5.00','MRL50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002063','MEROL 100MG TAB','NULL','119.00','5.00','MRL100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002064','TRIMEZ 20MG TAB','NULL','113.82','5.00','TRMZ20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002065','ACDERMIN GEL','NULL','148.75','5.00','ACDGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002066','ADAPCO BAR','NULL','76.50','5.00','ADPCBAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002067','ATCOGEN 0.1% CREAM','NULL','12.75','5.00','ATC0.1CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002068','BETADERM 0.1% LOTION','NULL','63.75','5.00','BT0.1LOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002069','BETADERM N.M CREAM','NULL','42.50','5.00','BTDNMCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002070','BETAGENIC NEW CREAM','NULL','34.00','5.00','BTGNCCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002071','HIRUDAID SMALL GEL','NULL','110.50','5.00','HRDSMGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002072','HIRUDIOD SMALL CREAM','NULL','110.50','5.00','HRDSMCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002073','SCABION 60ML LOTION','NULL','64.82','5.00','SCB60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002074','SCABION CREAM','NULL','32.27','5.00','SCBCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002075','ZINCAT 20MG TAB','NULL','42.50','5.00','ZINCT20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002076','BETAXOL 5ML DRPS','NULL','93.50','5.00','BTXL5MLDPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002077','BRACIN EYE DROPS','NULL','76.50','5.00','BRCN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002078','BRACIN OINTMENT','NULL','66.30','5.00','BRCNOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002079','BRACIN-D DROPS','NULL','93.50','5.00','BRCND','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002080','BRIMO-T DROPS','NULL','276.25','5.00','BRMT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002081','DICLON EYE  DROPS','NULL','51.00','5.00','DCLN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002082','EYECROM DROPS','NULL','73.10','5.00','EYECROM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002083','EYFOREX DROPS','NULL','62.05','5.00','EYFRX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002084','FLUROZINE DROPS','NULL','42.50','5.00','FLRZ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002085','GLANTRIN DROPS','NULL','425.00','5.00','GLTRN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002086','N-CRON DROPS','NULL','148.75','5.00','NCRON','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002087','OXCIN DROPS','NULL','140.25','5.00','OXCN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002088','OXCIN-D DROPS','NULL','148.75','5.00','OXCN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002089','PLYTROL','NULL','49.30','5.00','PLYTRL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002090','PROBITA-N DROPS','NULL','22.70','5.00','PRBTA-N','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002091','PROLOX EYE DROPS','NULL','89.25','5.00','PRLX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002092','VISOL GEL','NULL','105.40','5.00','VISG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002093','AMLOD TAB','NULL','110.87','5.00','AMLD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002094','ATCOFLOX 250MG TAB','NULL','85.00','5.00','ATCFLX250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002095','ATCOFLOX 500 TAB','NULL','153.00','5.00','ATCFLX500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002096','CAPACE 12.5MG TAB','NULL','52.30','5.00','CAP12.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002097','CAPACE 25MG TAB','NULL','73.44','5.00','CAP25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002098','CATEN 100MG TAB','NULL','47.74','5.00','CAT100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002099','CATEN 25MG TAB','NULL','19.00','5.00','CAT25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002100','CATEN 50MG TAB','NULL','28.05','5.00','CAT50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002101','MICRONEMA B/L LARGE','NULL','25.22','5.00','MICLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002102','PENFEN INJ','NULL','53.52','5.00','PENINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002103','PENFEN 50MG TAB','NULL','43.24','5.00','PEN50MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002104','RHINOFF 200MG TAB','NULL','158.95','5.00','RHIN200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002105','RHINOFF SYP','NULL','16.16','5.00','RHINSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002106','RHINOFF-FORTE 400MG','NULL','277.95','5.00','RHINFORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002107','VASTOR 10MG TAB','NULL','85.00','5.00','VAST10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002108','VASTOR 20MG TAB','NULL','153.00','5.00','VAST20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002109','CLOBERDERM PLAIN LOTION','NULL','32.30','5.00','CLOBLOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002110','CLOBEDERM-S LOTION','NULL','34.00','5.00','CLOBSLOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002111','CLOBEDERM NN OINTMENT','NULL','14.75','5.00','CLOBNNOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002112','CONAZ LOTION','NULL','136.00','5.00','CNZLOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002113','CONAZ TAB','NULL','144.50','5.00','CNZTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002114','HYDERQUIN 2% CREAM','NULL','34.00','5.00','HYD2CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002115','HYDERQUIN 4% CREAM','NULL','42.50','5.00','HYD4CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002116','IVERMITE 6MG TAB','NULL','85.00','5.00','IVRM6','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002117','MELAS 15GM CREAM','NULL','100.30','5.00','MLS15GM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002118','MELAS H CREAM','NULL','110.50','5.00','MLSH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002119','MELAS OINTMENT','NULL','100.30','5.00','MELASOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002120','SCABFREE CREAM','NULL','38.25','5.00','SCBFRECR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002121','SCAB FREE LOTION','NULL','66.30','5.00','SCBLOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002122','SKIN-A 0.5% CREAM','NULL','41.65','5.00','SKINA0.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002123','ATCO NATE 35MG TAB','NULL','290.70','5.00','ATNAT35','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002124','ATCONATE 150MG TAB','NULL','340.00','5.00','ATCNATE150','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002125','DIAROXX CAP','NULL','170.00','5.00','DIRXX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002126','ECOROX 40MG CAP','NULL','160.65','5.00','ECO40','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002127','EUMYTIC 10MG TAB','NULL','85.00','5.00','EUMY10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002128','EUMYTIC 5MG TAB','NULL','51.00','5.00','EUM5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002130','NILEM 15MG TAB','NULL','79.05','5.00','NIL15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002131','NILEM 7.5MG','NULL','45.90','5.00','NIL7.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002132','SYNGAB 50MG CAP','NULL','142.80','5.00','SYNG50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002133','VOMILUX TAB','NULL','182.75','5.00','VOMTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002134','ATCOL 10MG TAB','NULL','116.45','5.00','ATC10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002135','ATCOL 20MG TAB','NULL','233.75','5.00','ATC20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002136','ATCOPLEX SYP','NULL','24.04','5.00','ATCPLX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002137','AZIDE 80MG TAB','NULL','68.00','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002138','BRONKOL 2MG TAB','NULL','34.00','5.00','BRNK2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002139','BRONKOL 4MG TAB','NULL','42.50','5.00','BRNKL4MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002140','BUNARFIN TAB','NULL','290.31','5.00','BNRFN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002141','BUNORFIN INJ','NULL','170.00','5.00','BNRFNINJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002142','CHLORMAX DROPS','NULL','29.75','5.00','CHLRMAXDPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002143','CHOLESCOR TABLET','NULL','204.00','5.00','CHOLSCOR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002144','COAGURIN 1MG TAB','NULL','161.50','5.00','CGRN1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002145','COAGURIN 2.5MG TAB','NULL','306.00','5.00','COGRN2.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002146','COAGURIN 5MG TABLET','NULL','488.75','5.00','COGRN5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002147','COMBINOL D SYRUP','NULL','36.55','5.00','COMBD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002148','DEPLUG TAB','NULL','106.25','5.00','DPLG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002149','DEPRAPRAM 20MG TAB','NULL','120.00','5.00','DPRM20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002150','DIAZOL SYRUP','NULL','17.69','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002151','DOXYN 50MG TAB','NULL','72.25','5.00','DXYN50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002152','ENACE 5MG TAB','NULL','50.15','5.00','ENCE5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002153','ENACE 5MG TAB','NULL','30.60','5.00','ENCE5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002154','EXTOR 5/80 TAB','NULL','0.10','5.00','EXTR580','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002155','GEMPRIDE 1MG TAB','NULL','51.00','5.00','GMPRDE1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002156','GEMPRIDE 2MG TAB','NULL','85.00','5.00','GEMP2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002157','GEMPRIDE 3MG TABLET','NULL','136.00','5.00','GEMP3MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002158','GEMPRIDE 4MG TAB','NULL','153.00','5.00','GEMP4MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002159','LO PLUS TABLET','NULL','158.95','5.00','LOPLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002160','LOSTRESS 25MG TAB','NULL','85.00','5.00','LOST25MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002161','LOSTRESS 50MG TAB','NULL','153.00','5.00','LOST50MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002162','MERIZOLE GEL','NULL','57.80','5.00','MRZLGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002163','PANTROLOC TAB','NULL','204.00','5.00','PANTRLCTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002164','PLEXID 120MG TAB','NULL','68.00','5.00','PLXD120','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002165','PLEXID 180MG TAB','NULL','102.00','5.00','PLXD180','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002166','PLEXID 60MG TAB','NULL','42.50','5.00','PLXD60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002167','POLYTRACIN CREAM','NULL','25.50','5.00','POLYTRCNCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002168','PRESAMIDE EYE DROPS','NULL','34.00','5.00','PRSMDEEYE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002169','PRIMOX PLAIN SYP','NULL','11.55','5.00','PRMX PLN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002170','PRIMOX DS SYP','NULL','17.55','5.00','PRMXDS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002171','PRIMOX DS TAB','NULL','215.05','5.00','PRMXDSTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002172','RUMAFEN GEL','NULL','35.29','5.00','RUMFGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002173','RUMAFEN SYP','NULL','15.13','5.00','RUMFSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002174','TENZIL 1MG TAB','NULL','48.15','5.00','TENZIL1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002175','SPREGAL SPRAY','NULL','658.75','5.00','SPRGLSPR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002176','TENZIL 2MG TAB','NULL','59.97','5.00','TENZ2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002177','TIMENTIN DROPS','NULL','61.20','5.00','TMTNDPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002178','ZEBID 20MG TAB','NULL','42.50','5.00','ZEBID20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002179','ZEBID 40MG TAB','NULL','76.50','5.00','ZEBID40','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002180','ZINCAT DRY SYP','NULL','38.00','5.00','ZINCDRY','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002181','CAZILA TABLET','NULL','340.00','5.00','CAZTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002182','FOROSI 2MG TAB','NULL','83.30','5.00','FORO2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002183','FOROSI 4MG TAB','NULL','142.80','5.00','FORO4MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002184','GEMPID 600MG TAB','NULL','141.74','5.00','GEMP600','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002185','PIOTONE 15MG TAB','NULL','68.00','5.00','PIOT15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002186','PIOTONE 30MG TAB','NULL','119.00','5.00','PIOT30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002187','PIOTONE 45MG TABLET','NULL','170.00','5.00','PIOT45','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002188','PIOTONE GEM 2MG TAB','NULL','142.80','5.00','PIOGEM2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002189','PIOTONE GEM 4MG TAB','NULL','168.30','5.00','PIOGEM4','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002190','PIOTONE PLUS 500 TAB','NULL','83.30','5.00','PIOPLUS500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002191','PIOTONE PLUS 850 TAB','NULL','85.00','5.00','PIOPLUS850','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002192','ACSOLVE 1% LOTION','NULL','127.50','5.00','ACSO LOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002193','BETADERM PLAIN CREAM','NULL','25.50','5.00','BET CR.15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002194','BETADERM PLAIN  OINTMENT','NULL','25.50','5.00','BET O.15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002195','BETADERM-P SMALL CREAM','NULL','10.70','5.00','BET CR.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002196','BETADERM-P SMALL OINT','NULL','10.70','5.00','BET O.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002197','BETAGENIC OINT MENT','NULL','34.00','5.00','BETAGOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002198','BETASALIC OINTMENT','NULL','42.50','5.00','BETASAOINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002199','CLOBEDERM CREAM','NULL','22.95','5.00','CLOBEDCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002200','CLOBEDERM EMOLIENT','NULL','13.00','5.00','CLOBEMO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002201','CLOBEDERM OINTMENT','NULL','13.00','5.00','CLO.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002202','HYDERQUIN PLUS CREAM','NULL','85.00','5.00','HYDERQPL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002203','OIL ATCO BAR','NULL','76.50','5.00','OILATCO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002204','ANXIT TAB','NULL','76.50','5.00','ANXIT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002205','ECOROX 20MG CAP','NULL','117.30','5.00','ECOR20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002206','MESULID 100 TAB','NULL','63.75','0.00','MESU100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002207','MOVELAT CREAM','NULL','229.50','0.00','MOVELCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002208','MOVELAT GEL','NULL','229.50','0.00','MOVELGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002209','NAPADOC TAB','NULL','75.65','5.00','NAPAD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002210','OSSTIUM SACHET','NULL','357.00','5.00','OSSTM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002211','SONETA 2MG TAB','NULL','68.00','5.00','SONE2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002212','SYNGAB 100MG CAP','NULL','214.20','5.00','SYNGAB100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002213','SYNGAB 200MG CAP','NULL','357.85','5.00','SYNGAB200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002214','TANAKAN TAB','NULL','280.50','0.00','TANAKAN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002215','ATCOPRAM 10MG TAB','NULL','166.60','5.00','ATCOPR10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002216','ATCOPRAM 20MG TAB','NULL','273.70','5.00','ATCOPR20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002217','CLONEXA 1MG TAB','NULL','59.50','5.00','CLONEX1','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002218','CLONEXA 2MG TAB','NULL','102.00','5.00','CLONEXA2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002219','CLONEXA 3MG TAB','NULL','153.00','5.00','CLONEXA 3','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002220','DONECEPT 5MG TAB','NULL','114.75','5.00','DENCEPT05','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002221','DONECEPT 10MG TAB','NULL','159.80','5.00','DONCPT10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002222','OXCYM DR 30MG CAPS','NULL','187.00','5.00','OXYMDR30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002223','OXCYM  DR 60MG TAB','NULL','340.00','5.00','OXCM60DR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002224','WELLBEN SR 150MG TAB','NULL','127.50','5.00','WELLBSR150','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002225','WELLBEN SR 75MG TAB','NULL','85.00','5.00','WELLBSR75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002226','XMG 0.25MG TAB','NULL','113.05','5.00','XMG25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002227','XMG 1MG TAB','NULL','142.80','5.00','XMG1','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002228','XMG 2MG TAB','NULL','202.30','5.00','XMG2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002229','EPIGRAN 5ML INJ','NULL','1275.00','5.00','EPIG5ML','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002230','NEUTROFIL 30MIU INJ','NULL','2805.00','5.00','NEYTFL30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002231','NORSALINE NASAL DROPS','NULL','23.80','5.00','NORSDRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002232','PHENOBARB 130ML 1ML','NULL','170.00','5.00','PHENO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002233','SYNE PHRINE 10MG INJ','NULL','170.00','5.00','SYNE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002234','CASAN TAB','NULL','127.50','5.00','CASAN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002235','PHYTO SOYA 35MG CAP','NULL','1530.00','5.00','PHYTO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002236','POLY GYNAX VIG TAB','NULL','255.00','0.00','POLYGY','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002237','PROSOTEC 100MG TAB','NULL','51.00','5.00','PRO100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002238','PROSOTEC 200MG TAB','NULL','85.00','5.00','PROS200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002239','ADAPCO CREAM','NULL','119.00','5.00','ADOCR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002240','ADAPCO GEL','NULL','119.00','5.00','ADAPGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002241','ATCO-E BAR','NULL','76.50','5.00','ATCOE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002242','CLOBEDERM LARGE OINT','NULL','38.25','5.00','CLO.15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002243','DOXYN CAP','NULL','212.50','5.00','DOXYN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002244','HEALIT OINTMENT','NULL','37.83','5.00','HEALIT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002245','TERBI BAR','NULL','76.50','5.00','TERBI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002246','TERBIDERM 10GM CREAM','NULL','127.50','5.00','TRBID10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002247','TERBIDERM 125MG TAB','NULL','233.75','5.00','TERB125','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002248','TERBIDERM FORTE TABLET','NULL','357.00','5.00','TERBFORTE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002249','OSMOLOR ORANGE ORS','NULL','119.00','5.00','OSMO ORNG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002250','ACSOLVE GEL','NULL','85.00','0.00','ACSO GEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002251','VIGLIP 50MG ATB','NULL','590.75','5.00','VGLIP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002252','SUMOXEN 85/500MG TAB','NULL','161.50','0.00','SUMX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002253','ACNES CREAMY WASH','NULL','225.00','5.00','ACN WSH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002254','SKIN AQUA CLEAR WHITE','NULL','463.50','5.00','SKI AQUA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002255','DEGOURIC 40MG TAB','NULL','221.00','5.00','DEGO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002256','SCABION FORTE LOTION','NULL','64.82','5.00','SC FRT L','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002257','URIGUARD 40MG TAB','NULL','221.00','5.00','URIG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002258','WINOLAP 0.1% SOLUTION','NULL','144.50','2.00','WNLP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002259','WINOLAP 0.2% SOLUTION','NULL','120.70','2.00','WNLP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002260','VIGLIP-M 50MG/1000MG','NULL','285.60','0.00','VGP-M 1000','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002261','VIGLIP-M 50MG/850MG','NULL','285.60','0.00','VGP-M 850','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('002262','ATCAM 8MG TAB','NULL','110.50','5.00','ATCM8','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003','CHIESI PHARMA','3','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003001','ATEM NEBULISER SOLUTUION','NULL','255.00','5.00','ATMNEBSOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003002','ATIMOS INHALER','NULL','493.00','5.00','ATMSINH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003003','BAMIFIX TAB','NULL','307.62','5.00','BMFX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003004','BREXIN TAB','NULL','225.44','5.00','BRXNTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003005','CLENIL 250MG','NULL','315.83','5.00','CL 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003006','CLENIL AEROSOL','NULL','250.49','5.00','CL AR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003007','CLENIL COMP SPRAY','NULL','195.81','5.00','CL CMP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003008','CLENIL COMP AEROSOL','NULL','286.42','5.00','CL CMP AR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003009','CLENIL JET 250MG','NULL','347.42','5.00','CL JET','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003010','CLIPPER 5MG TAB','NULL','548.25','5.00','CLPR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003011','ESOTONE 20MG TAB','NULL','140.25','5.00','ESO 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003012','ESOTONE 40MG','NULL','212.50','5.00','ESO 40','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003013','FACTIM 320MG TAB','NULL','595.00','5.00','FCTM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003014','FOSTER','NULL','765.00','5.00','FSTR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003015','LIOMETACIN INJ','NULL','367.20','5.00','LIOM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003016','OPTIHALER','NULL','272.27','5.00','OPTI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003017','PROLIFEN CAP','NULL','297.67','5.00','PROL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003018','PRONTOKEF 0.5 GR INJ','NULL','167.55','5.00','PROK 0.5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003019','PRONTOKEF 1GR INJ','NULL','267.36','5.00','PROK 1GR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003020','PULMIKAST 5MG  TAB','NULL','204.00','5.00','PUL 5MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003021','PULMIKAST 10MG TAB','NULL','263.50','5.00','PUL 10MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003022','RIACEN 15 CREAM','NULL','64.77','5.00','RIAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003023','RINO CLENIL 100MG SPRAY','NULL','467.50','5.00','RINO 100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003024','RINO CLENIL 50MG SPRAY','NULL','222.12','5.00','RINO 50MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003025','TOTIFEN SYP','NULL','54.75','5.00','TOT SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003026','TRICOGEN TAB','NULL','95.17','5.00','TRI TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003027','VASOBRAL SYP','NULL','271.47','5.00','VAS SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003028','ARTIMET SYP','NULL','153.00','5.00','ARTI SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003029','ARTIMET PLAIN TAB','NULL','272.00','5.00','ARTI PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003030','ARTIMET FORTE TAB','NULL','224.40','5.00','ARTI FORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003031','ESTA 10MG TAB','NULL','153.00','5.00','EST TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003032','LEOX 250MG TAB','NULL','102.00','5.00','LEOX 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003033','LEOX 500MG TAB','NULL','195.50','5.00','LEOX 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003034','PRONTOX 1G IM INJ','NULL','204.00','5.00','P TX 1G IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003035','PRONTOX 1G IV INJ','NULL','204.00','5.00','P TX 1G IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003036','PRONTOX 250MG IM INJ','NULL','76.50','5.00','P TX 250IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003037','PRONTOX 250MG IV INJ','NULL','76.50','5.00','P TX 250IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003038','PRONTOX 500MG IM INJ','NULL','119.00','5.00','P TX 500IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003039','PRONTOX 500MG IV INJ','NULL','119.00','5.00','P TX 500IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003040','OSTEOFIX','NULL','529.78','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003041','FLUIBRON SYP','NULL','36.06','5.00','FLUB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003042','PULMIKAST 5MG TAB OLD','NULL','187.00','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('003043','RIACEN 20MG CAP','NULL','127.50','5.00','RIC CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004','FRENCH FARMA','4','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004001','DIHYDAN TAB','NULL','266.05','5.00','DHY TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004002','DYCINON TAB','NULL','117.70','5.00','DYC TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004003','ETAPHYLIN PLAIN SYP','NULL','33.62','5.00','ETA PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004004','ETAPHYLIN COUGH SYP','NULL','20.45','5.00','ETA C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('004005','DIHYDAN TAB SMALL','NULL','93.50','0.00','DI-SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005','ZAFA PHARMACEUTICAL','5','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005001','ACETOPRIL25MG TAB','NULL','55.25','5.00','ACE TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005002','COLEZAF 10MG TAB','NULL','55.25','5.00','COLE 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005003','COLEZAF 20MG TAB','NULL','85.00','5.00','COL 20 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005004','EPIZEP 0.5 MG TAB','NULL','72.25','5.00','EPI 0.5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005005','EPIZEP 2MG TAB','NULL','85.00','5.00','EPI 2 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005006','EPIZEP DROPS','NULL','81.60','5.00','EPI DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005007','FLEXITRAN 250MG INJ','NULL','389.30','5.00','FLEX 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005008','FLEXITRAN 500MG INJ','NULL','297.50','5.00','FLEX 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005009','FOLIC ACID 5MG TAB','NULL','25.50','5.00','FOLIC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005010','H2REC TAB','NULL','66.30','5.00','H2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005011','HEXIDYL 2MG TAB','NULL','17.43','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005012','IBUPROFEN 200MG STRIP TAB','NULL','365.50','5.00','IBU 200 ST','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005013','IBUPROFEN 200MG TIN TAB','NULL','365.50','5.00','IBU 200 TN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005014','IBUPROFEN 400MG STRIP TAB','NULL','340.00','5.00','IBU 400 ST','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005015','IBUPROFEN 400MG TIN TAB','NULL','340.00','5.00','IBU 400 TN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005016','LABETALOL 100MG TAB','NULL','85.00','5.00','LABE TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005017','MEFACID 250MG TIN TAB','NULL','300.90','5.00','MEFA TIN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005018','MEFACID B /P TAB','NULL','74.37','5.00','MEFA B P','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005019','NIFIDIL SG 10MG CAP','NULL','39.10','5.00','NIF SG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005020','NIFIDIL CAP','NULL','39.53','5.00','NIF CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005021','NIFIDIL XL 30MG TAB','NULL','66.17','5.00','NIF XL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005022','NIMZA 3MG TAB','NULL','25.04','5.00','NIM TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005023','LABETALOL 50MG INJ','NULL','21.25','5.00','LAB INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005024','PARA 4 KIDS SYP','NULL','21.25','5.00','PARA SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005025','PARACETAMOL B/P TAB','NULL','119.00','5.00','PARA BP TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005026','PARACETAMOL  TAB','NULL','373.62','5.00','PARA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005027','PHENIDA 10MG TAB','NULL','102.00','5.00','PHEN TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005028','PLATAGG-T TAB','NULL','68.00','5.00','PLA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005029','PROCHOLIDIN 5MG TAB','NULL','42.50','5.00','PRO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005030','VITALYSIN SYP','NULL','55.26','5.00','VIT SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005031','ZAUXIT 20MG TAB','NULL','57.80','5.00','ZAX TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005032','ZEFTROX IM 1G INJ','NULL','88.00','5.00','ZEF 1G IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005033','ZEFTROX IM 250MG INJ','NULL','36.00','5.00','ZEF 250 IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005034','ZEFTROX IM 500MG INJ','NULL','52.00','5.00','ZEF 500 IM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005035','ZEFTROX IV 1G INJ','NULL','88.00','5.00','ZEF IG IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005036','ZEFTROX IV 250MG INJ','NULL','36.00','5.00','ZEF 250 IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005037','ZEFTROX IV 500MG INJ','NULL','52.00','5.00','ZEF 500 IV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005038','ZIMES 20MG TAB','NULL','85.00','5.00','ZIM TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005039','ASTHOTIFEN 1MG TAB','NULL','40.80','5.00','ASTH TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005040','ASTHOTIFEN SYP','NULL','28.48','5.00','ASTH SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005041','BECLO-SAL INHALER','NULL','156.68','5.00','BECLO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005042','CARDACE 10MG TAB','NULL','56.10','5.00','CAR 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005043','CARDACE 5MG TAB','NULL','34.43','5.00','CAR 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005044','CARDACE H TAB','NULL','34.00','5.00','CAR H TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005045','ENOXAZAN 400MG CAP','NULL','275.40','5.00','ENOX CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005046','FLORAMAX 2MG TAB','NULL','29.75','5.00','FLO CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005047','FURATOP 15G POWDER','NULL','10.68','5.00','FUR PWD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005048','FURATOP 28G SAMLL CREAM','NULL','8.76','5.00','FUR 28 CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005049','FURATOP 40MG CREAM','NULL','12.16','5.00','FUR 40 CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005050','LOVASTAIN 20MG TAB','NULL','21.25','5.00','LOVA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005051','MONTAZA 10MG TAB','NULL','107.00','5.00','MONT 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005052','MONTAZA 5MG TAB','NULL','73.10','5.00','MONT 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005053','TROPUM INJ','NULL','212.50','5.00','TROP INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005054','XYNOSINE SPRAY','NULL','25.50','5.00','XYNO SPR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005055','XYNOSINE CHILDREN SPRAY','NULL','18.70','5.00','XYN CHI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005056','ZAFIXIME 1G INJ','NULL','55.00','5.00','ZAFI 1 INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005057','ZAFIXIME 250MG INJ','NULL','26.00','5.00','ZAFI 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005058','ZAFIXIME 500MG INJ','NULL','34.00','5.00','ZAFI 500 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005059','ZAMPRA 20MG CAP','NULL','95.20','5.00','ZAMP 20 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005060','ZEFTOLIN SOLUTION','NULL','17.00','5.00','ZEF SOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005061','ZEFTOLIN SPRAY','NULL','68.00','5.00','ZEF SPR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005062','ZEFTOLIN  SYP','NULL','19.55','5.00','ZEF SYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005063','ZORAT 10MG TAB','NULL','51.00','5.00','ZOR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005064','ARLUFA TAB','NULL','272.00','5.00','ARLU TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005065','ATENOLOL TAB','NULL','55.25','5.00','ATEN TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005066','CEFORAL-3  400MG CAP','NULL','136.00','5.00','CEFO CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005067','CEFORAL-3 100MG SYP','NULL','106.25','5.00','CEFO SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005068','CLIOQUINOL HC LARGE CREAM','NULL','34.00','5.00','CLI HC LR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005069','CLIOQUINOL HC SAMLL CREAM','NULL','17.00','5.00','CLI HC SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005070','CLIOUINOL PLAIN CREAM','NULL','21.25','5.00','CLI PL CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005071','DI-UZA TAB','NULL','17.00','5.00','DI TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005072','H/CORTISONE LARGE CREAM','NULL','25.50','5.00','HC LAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005073','H/CORTISONE SAMALL CREAM','NULL','14.45','5.00','HC SMA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005074','NAPTROL 250MG TAB','NULL','58.31','5.00','NAP 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005075','NAPTROL 500MG TAB','NULL','102.85','5.00','NAP 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005076','NEOF FOLIC TAB','NULL','17.51','5.00','NEO F TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005077','OFLOBIOTIC 200MG CAP','NULL','68.00','5.00','OFLO CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005078','PICOZ DROPS','NULL','19.34','5.00','PICO DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005079','POLYZAF LARGE   OINTMENT','NULL','17.85','5.00','POL 6 GM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005080','POLYZAF SMALL OINTMENT','NULL','13.60','5.00','POL 4','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005081','SERAZYM TAB','NULL','37.83','5.00','SER TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005082','SIMVAZAF 10MG TAB','NULL','42.50','5.00','SIM 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005083','SIMVAZAF 20MG TAB','NULL','72.25','5.00','SIM 20 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005084','ZACLOVIR 5% CREAM','NULL','103.70','5.00','ZAC CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005085','ZACLOVIR 200MG TAB','NULL','275.40','5.00','ZAC TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005086','ZAFALEXIN 125MG SYP','NULL','43.35','5.00','ZAF 125 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005087','ZAFALEXIN 250MG SYP','NULL','66.90','5.00','ZAF 250 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005088','ZAFALEXIN 250MG LARGE CAP','NULL','456.71','5.00','ZAF 250 LA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005089','ZAFALEXIN 250MG SAMALL CAP','NULL','66.51','5.00','ZAF 250 SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005090','ZAFALEXIN 500MG CAP','NULL','130.05','5.00','ZAF 500 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005091','ZAFANOL  50MG TAB','NULL','34.00','5.00','ZNOL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005092','ZAFUROX 125MG SYP','NULL','102.00','5.00','ZAFU 125 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005093','ZAFUROX 250MG TAB','NULL','333.20','5.00','ZAFU 250 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005094','ZAFUROX 250MG INJ','NULL','23.32','5.00','ZAFU 250 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005095','ZAFUROX 750MG INJ','NULL','73.66','5.00','ZAFU 750 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005096','ZODIP 5MG TAB','NULL','29.75','5.00','ZOD TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005097','ADICOS 120ML  SYP','NULL','26.35','5.00','ADI 120 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005098','ADICOS 450ML SYP','NULL','35.96','5.00','ADI 450 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005099','ADICOS 60ML SYP','NULL','10.20','5.00','ADI 60 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005100','ADICOS M 60ML SYP','NULL','15.30','5.00','ADI M 60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005101','ADICOS M 120ML syp','NULL','24.65','5.00','ADI M 120','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005102','ALMAGEL  SYP','NULL','13.60','5.00','ALMA SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005103','ANGILINGUAL 0.5 TAB','NULL','11.05','5.00','ANGI TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005104','CEPHGEN 125MG SYP','NULL','59.50','5.00','CEP 125 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005105','CEPHGEN 1G INJ','NULL','38.25','5.00','CEP 1G INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005106','CEPHGEN 250MG CAP','NULL','85.00','5.00','CEP 250 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005107','CEPHGEN 250MG INJ','NULL','15.76','5.00','CEP 250 IN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005108','CEPHGEN 500 MG CAP','NULL','144.50','5.00','CEP 500 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005109','CEPHGEN 500MG INJ','NULL','29.75','5.00','CEP 500 IN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005110','CLOTRIM SOLUTION','NULL','31.79','5.00','CLO SOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005111','CLOTRIM LARGE CREAM','NULL','36.55','5.00','CLO LAR CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005112','CLOTRIM SMALL CREAM','NULL','20.23','5.00','CLO SM CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005113','CROTAN  CREAM','NULL','18.79','5.00','CRO CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005114','DEBRIDATE 100MG TAB','NULL','58.65','5.00','DEB 100 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005115','DEBRIDATE 200MG TAB','NULL','105.40','5.00','DEB 200 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005116','DEBRIDATE SYP','NULL','55.25','5.00','DEB SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005117','DICLOKALIUM 50MG TAB','NULL','56.39','5.00','DIIC K TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005118','DICLOZAF 100MG TAB','NULL','94.56','5.00','DICZ 100 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005119','DICLOZAF  GEL','NULL','40.63','5.00','DOCZ GEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005120','DICLOZAF 25MG TAB','NULL','29.38','5.00','DICZ 25 TA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005121','DICLOZAF 50MG TAB','NULL','38.56','5.00','DICZ 50 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005122','DICLOZAF 50MG TIN TAB','NULL','302.00','5.00','DICZ TIN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005123','DICLOZAF INJ','NULL','27.20','5.00','DICZ INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005124','KLEMAT SYP','NULL','23.80','5.00','KLE SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005125','KLEMAT 1MG TAB','NULL','10.37','5.00','KLE 1MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005126','KLEMAT 2MG TAB','NULL','20.74','5.00','KLE 2MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005127','LINCOZAF 600MG INJ','NULL','23.80','5.00','LINC  INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005128','MIRTAZEP15MG TAB','NULL','333.20','5.00','MIR 15 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005129','MIRTAZEP 30MG TAB','NULL','628.15','5.00','MIR 30 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005130','MVEM 21 CAP','NULL','26.24','5.00','MVEM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005131','NEO K TAB','NULL','13.76','5.00','NEO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005132','NITROSUST 2.6MG Tab','NULL','101.49','5.00','NIT 2.6','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005133','NITROSUST 6.4MG TAB','NULL','119.00','5.00','NIT 6.4','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005134','URIVOX TAB','NULL','87.55','5.00','URI TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005135','VOFLOZA 250MG TAB','NULL','40.80','5.00','VOF 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005136','VOFLOZA 500MG TAB','NULL','102.00','5.00','VOF 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005137','ZAVERA 240MG TAB','NULL','74.36','5.00','ZAV','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005138','ZINDIGI 10MG TAB','NULL','35.70','5.00','ZIN 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005139','ZINDIGI 20MG TAB','NULL','59.50','5.00','ZIN 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005140','OFLOBIOTIC EYE DROPS','NULL','63.17','5.00','OFLO DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005141','ORBA CLEAR DROPS','NULL','12.58','5.00','O CLE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005142','ORBACARPINE DROPS','NULL','28.47','5.00','O CARP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005143','ORBACHLOR DROPS','NULL','17.00','5.00','O CHLO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005144','ORBACIN DROPS','NULL','57.38','5.00','O CIN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005145','ORBAFLUOR DROPS','NULL','31.87','5.00','O FLU','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005146','ORBAMIDE 10% DROPS','NULL','11.13','5.00','O MID 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005147','ORBAMIDE 30% DROPS','NULL','14.02','5.00','O MID 30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005148','ORBANPH DROPS','NULL','25.50','5.00','O NAPH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005149','ORBATROPIN LARGE DROPS','NULL','17.21','5.00','O TRO LAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005150','ORBATROPIN SMALL DROPS','NULL','11.05','5.00','O TRO SMA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005151','ORBETAM PLAIN DROPS','NULL','19.84','5.00','O TAM PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005152','ORBETAM N DROPS','NULL','23.80','5.00','O TAM N','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005153','ORBUNOL DROPS','NULL','66.56','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005154','BUTA SILIM TAB','NULL','238.00','5.00','BUTA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005155','CODLI-AD CAP','NULL','242.25','5.00','CODLI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005156','DILTAZAF 30MG TAB','NULL','25.50','5.00','DIL 30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005157','DILTAZAF 60MG TAB','NULL','38.25','5.00','DIL 60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005158','DIZMA 4 LARGE  INJ','NULL','510.00','5.00','DIZ LR INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005159','IBU SOFT 200MG CAP','NULL','127.50','5.00','IBU S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005160','IBUQUIK 200MGCAP','NULL','25.50','5.00','IBU Q 200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005161','IBUQUIK 400MG CAP','NULL','42.50','5.00','IBU Q 400','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005162','MOLINZA 400MG TAB','NULL','289.00','5.00','MOLI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005163','ZUSELAX 100MG INJ','NULL','23.80','5.00','MUS 100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005164','ZUSELAX 500MG INJ','NULL','42.50','5.00','MUS 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005165','NEZATION INJ','NULL','150.45','5.00','NEZ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005166','RELAXTRON INJ','NULL','170.00','5.00','RELX IJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005167','VADORAL CAP','NULL','55.25','5.00','VAD CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005168','YES 2 ZINC D.S SYP','NULL','42.50','5.00','YES DS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005169','YES 2 ZINC SYP','NULL','38.25','5.00','YES P','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005170','ZAFAQUIN 300MG INJ','NULL','119.00','5.00','ZAF Q','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005171','ZAFVIL 2ML INJ','NULL','85.00','5.00','ZAF V','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005172','ZESCAP 200MG LARGE SYP','NULL','221.00','5.00','ZES 200 L','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005173','ZESCAP 200MG SMALL CAP','NULL','66.30','5.00','ZES 200 SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005174','ZESCAP 600MG LARGE CAP','NULL','310.25','5.00','ZES 600 LR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005175','ZESCAP 600 SMALL CAP','NULL','153.00','5.00','ZES 400 SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005176','ZESCAP 400MG LARGE CAP','NULL','374.00','5.00','ZES 400 LR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005177','ZESCAP 400MG SMALL CAP','NULL','112.20','5.00','ZES 400 SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005178','ZICLODIN 250MG TAB','NULL','68.00','5.00','ZIC TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005179','ZIPAZOM 1GM IVINJ','NULL','85.00','5.00','ZIP 1G','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005180','ZIPAZOM 250MG IV INJ','NULL','42.50','5.00','ZIP 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005181','ZIPAZOM 500MG IV INJ','NULL','59.50','5.00','ZIP 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005182','ZOSARTEN K 50MG TAB','NULL','51.00','5.00','ZOS K','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005183','DIZMA 4 SMALL INJ','NULL','255.00','5.00','DIZ SM INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005184','BENZIBIOTIC 12LAC INJ','NULL','18.70','5.00','BENZI 12','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005185','BENZIBIOTIC 6LAC INJ','NULL','12.75','5.00','BENZI 6','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005186','ZAMOCLAV 156.50MG SYP','NULL','42.50','5.00','ZAMO 156 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005187','ZAMOCLAV 1GM TAB','NULL','126.65','5.00','ZAMO 1G TA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005188','ZAMOCLAV 312.50 SP','NULL','92.66','5.00','ZAMO 312 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005189','ZAMOCLAV 375MG TAB','NULL','116.17','5.00','ZAMO 375 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005190','ZAMOCLAV 600 INJ','NULL','59.50','5.00','ZAMO 600 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005191','ZAMOCLAV 625MG TAB','NULL','134.30','5.00','ZAMO 625 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005192','ZAMPICILIN 1GM INJ','NULL','17.00','5.00','ZAMPI 1G I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005193','ZAMPICILIN 250MG INJ','NULL','10.63','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005194','ZAMPICILIN 500MG INJ','NULL','14.45','5.00','ZAMPI 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005195','ZAMPICILIN 125/5ML SYP','NULL','23.81','5.00','ZAMPI 125','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005196','ZAMPICILIN 500MG TAB','NULL','161.50','5.00','ZAMPI 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005197','ZAMPILOX 250MG CAP','NULL','34.00','5.00','ZAPI 250 C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005198','ZAMPILOX 250MG INJ','NULL','13.60','5.00','ZAPI 250 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005199','ZAMPILOX 250MG CAP','NULL','34.00','5.00','ZLOX 250 C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005200','ZAMPILOX 250MG INJ','NULL','13.60','5.00','ZLOX 250 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005201','ZAMPILOX 250MG SYP','NULL','31.46','5.00','ZLOX 250 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005202','ZAMPILOX 500MG CAP','NULL','35.70','5.00','ZLOX 500 C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005203','ZAMPILOX 500MG INJ','NULL','19.55','5.00','ZLOX 500 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005204','ZOXICILIN DROPS','NULL','19.55','5.00','ZOXI DR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005205','ZOXICILIN 125MG SYP','NULL','29.75','5.00','ZOXI 125 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005206','ZOXICILIN 250 MG INJ','NULL','170.00','5.00','ZOXI 250 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005207','ZOXICILIN 250MG SYP','NULL','39.95','5.00','ZOXI 250 S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005208','ZOXICILIN 250MG CAP','NULL','31.45','5.00','ZOXI 250 C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005209','ZOXICILIN 500MG INJ','NULL','21.25','5.00','ZOXI 500 I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005210','ZOXICILIN 500MG CAP','NULL','76.50','5.00','ZOXI 500 C','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005211','ZOXICILIN 1G INJ','NULL','29.75','5.00','ZOXI 1G IN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005212','ACNOT TAB','NULL','170.00','5.00','ACNOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005213','DESOFAM TAB','NULL','27.20','5.00','DESO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005214','DIGLYTA 15MG TAB','NULL','17.85','5.00','DIG 15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005215','DIGLYTA 30MG TAB','NULL','29.75','5.00','DIG 30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005216','DIGLYTA PLUS TAB','NULL','39.10','5.00','DIG PLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005217','DIROGEST 10MG TAB','NULL','127.50','5.00','DIR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005218','EMKIT 0.75MG TAB','NULL','12.75','5.00','EMK 75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005219','EMKIT D.S TAB','NULL','12.75','5.00','EMK D.S','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005220','FAMILA INJECTION','NULL','48.45','5.00','FAMI INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005221','FAMILA 28TAB','NULL','51.00','5.00','FAMI TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005222','FIRMOFOS 10MG TAB','NULL','25.50','5.00','FIR 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005223','FIRMOFOS WEEKLY TAB','NULL','136.00','5.00','FIR WEEK','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005224','GYNOFIN 50MG TAB','NULL','76.50','5.00','GYNO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005225','HYDRALAZINE HCI TAB','NULL','42.50','5.00','HYD TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005226','HYDRALAZINE INJ','NULL','21.25','5.00','HYD INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005227','HYDROXYPROGESTERONE INJ','NULL','126.66','5.00','HOP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005228','LONACORT INJ','NULL','39.11','5.00','LONA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005229','MAGNESIM LARGE  INJ','NULL','13.13','5.00','MAGI 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005230','MAGNISIM SMALL INJ','NULL','15.76','5.00','MAGNI 2','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005231','NORGYN 5MG TAB','NULL','38.25','5.00','NORG T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005232','NORIFAM 1ML INJ','NULL','34.00','5.00','NORI INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005233','S T MOM 25MCG TAB','NULL','17.85','5.00','ST 25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005234','S T MOM 200MG LARGE TAB','NULL','85.00','5.00','ST 200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005235','S T MOM SMALL TAB','NULL','25.50','5.00','ST SMA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005236','TESTENON INJ','NULL','42.50','5.00','TEST I','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005237','TIBOPAUSE 2.5MG TAB','NULL','306.00','5.00','TIB TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005238','ZACLAZIDE 80MG TAB','NULL','75.65','5.00','ZACL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005239','ZAFACAIN 1GM INJ','NULL','70.55','5.00','Z CAN 1','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005240','ZAFACAIN 500MG INJ','NULL','40.80','5.00','Z CAN 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005241','ZANSULIN NPH INJ','NULL','348.50','5.00','ZAN NPH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005242','ZANSULIN REGULAR INJ','NULL','450.50','5.00','ZAN REG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005243','ZATRANEX 250MG CAP','NULL','114.75','5.00','ZAT CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005244','ZATRANEX 250MG INJ','NULL','144.50','5.00','ZAT INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005245','AMDAQUIN 150MG TAB','NULL','238.00','5.00','AMD TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005246','AMDAQUIN SYP','NULL','11.05','5.00','AMDQ SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005247','AMIKACIN 100MG INJ','NULL','25.50','5.00','AMIK 100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005248','AMIKACIN 1GM INJ','NULL','127.50','5.00','AMIK 1G','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005249','AMIKACIN 250MG INJ','NULL','46.75','5.00','AMIK 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005250','AMIKACIN 500MG INJ','NULL','85.00','5.00','AMIK 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005251','ARTISUL ADULT TAB','NULL','89.25','5.00','ARTI AD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005252','ARTISUL CHILDREN TAB','NULL','51.00','5.00','ARTI CH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005253','ARTIZA 80MG INJ','NULL','122.40','5.00','ARTI INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005254','ASPISAFE 75MG TAB','NULL','20.40','5.00','ASPI TP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005255','BETADIP CREAM','NULL','46.75','5.00','BET CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005256','BETADIP OINTMENT','NULL','46.75','5.00','BETA OIN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005257','CP ZAF 250NG TAB','NULL','35.70','5.00','CP 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005258','CP ZAF 500MG TAB','NULL','51.00','5.00','CP 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005259','CP ZAF INJECTION','NULL','50.00','5.00','CP INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005260','DOXYCYCLIN CAP','NULL','136.61','5.00','DOXY','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005261','FAMTAZA 20MG TAB','NULL','34.00','5.00','FAM 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005262','FAMTAZA 40MG TAB','NULL','34.00','5.00','FAM 40','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005263','HYDROSOD SUC100MG INJ','NULL','62.06','5.00','HYD 100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005264','HYDROSOD SUC 250MG INJ','NULL','80.75','5.00','HYD 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005265','INFACTRON TIN TAB','NULL','140.25','5.00','INFA TN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005266','INFACTRAN  TAB','NULL','140.25','5.00','INFA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005267','KANAMYCIN 1G INJ','NULL','51.00','5.00','KANA 1G','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005268','KANMYCIN 500MG INJ','NULL','34.00','5.00','KNAN 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005269','LACTOZAF SYP','NULL','92.65','5.00','LACT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005270','LISNA 20MG TAB','NULL','127.50','5.00','LIS 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005271','LISNA 5MG TAB','NULL','46.75','5.00','LIS 5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005272','MACLARA 125MG SYP','NULL','170.00','5.00','MAC SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005273','MACLARA 250MG TAB','NULL','153.00','5.00','MAC 250 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005274','METRIDA 0.5 INJ','NULL','42.50','5.00','MET','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005275','OROXIZAF 125MG SYP','NULL','51.00','5.00','ORO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005276','SORBIMON 20MG TAB','NULL','41.99','5.00','SOR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005277','TESMIC 2.5MG TAB','NULL','85.00','5.00','TES TA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005278','TESMIC SYP','NULL','17.00','5.00','TES','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005279','ZAMLO 5MG TAB','NULL','20.40','5.00','ZAM 5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005280','ZAMLO H TAB','NULL','25.50','5.00','ZAM H','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005281','ZIPENTA 1GM INJ','NULL','102.00','5.00','ZIP 1G','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005282','ZIPENTA 250MG INJ','NULL','35.70','5.00','ZIP 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005283','ZIPENTA 500MG TAB','NULL','63.75','5.00','ZIP 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005284','ZANSULIN  70.30 INJ','NULL','348.50','0.00','ZNSLN70.30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005285','PARA 6+ SUSP','NULL','29.75','5.00','PARA 6','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005286','ZIMES 40MG CAP','NULL','110.50','0.00','ZIM 40','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005287','YES 2 ZINC LIQUID SYP','NULL','42.50','0.00','Y2 LIQ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005288','LEVOZAF 2.5MG/5ML SYP','NULL','29.75','5.00','LEVO Z','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005289','H2REC 50MG/2ML INJ','NULL','51.00','5.00','H2 INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005290','SODAZAF SACHETS','NULL','115.60','5.00','SODA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005291','ZAMPICILLINE CAP 500MG','NULL','348.50','5.00','ZAMP500CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('005292','ZAMPICILLINE CAP 250MG','NULL','178.50','5.00','ZAMP250CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006','OPAL LABORATORIES','6','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006001','ALUPHAGEL SYP','NULL','33.92','5.00','ALPH SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006002','ALUPHAGEL TAB','NULL','23.80','5.00','ALPH TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006003','ANAPRIN 150MG TAB','NULL','32.71','5.00','ANA 150','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006004','ANAPRIN 300MG TAB','NULL','53.04','5.00','ANA 300','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006005','ANAPRIN 75MG TAB','NULL','25.50','5.00','ANA 75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006006','ASMASAL TAB','NULL','17.68','5.00','ASM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006007','DOLOGIN SYP','NULL','17.00','5.00','DOLO PL SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006008','DOLOGIN D.S SYP','NULL','25.50','5.00','DOLO DS SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006009','DOLOGIN D.S TAB','NULL','283.90','0.00','DOLO DS TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006010','DOLOGIN PLAIN TAB','NULL','100.31','3.00','DOLO PL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006011','FEROPAL CAP','NULL','46.75','5.00','FER CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006012','NIFT 125 SUSP','NULL','59.50','5.00','NF 125 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006013','NIFT 250MG SUSP','NULL','89.25','5.00','NF 250 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006014','NIFT 250MG TAB','NULL','85.00','5.00','NF 250 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006015','NIFT 500MG TAB','NULL','144.50','5.00','NF 500 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006016','OEZI SYP','NULL','38.25','5.00','OZ SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006017','OEZI OD SYP','NULL','59.50','5.00','OZ OD SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006018','OEZI TAB','NULL','127.50','5.00','OZ TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006019','OPOZOL SYP','NULL','27.20','5.00','OPO SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006020','PRAMEASE 10MG TAB','NULL','153.00','5.00','PRA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006021','URODONAL SYP','NULL','127.50','5.00','URO SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006022','KOOLOX SYP','NULL','30.60','5.00','KOOL SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006023','LEVO F 250MG TAB','NULL','102.00','5.00','LEV 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006024','LEVO F 500MG TAB','NULL','161.50','5.00','LEV 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006025','MALTHER D.S PLUS TAB','NULL','255.00','5.00','MLA DS PLS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006026','MALTHER D.S TAB','NULL','208.26','5.00','MLA DS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006027','MALTHER SMALL SYP','NULL','68.00','5.00','MLA 30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006028','MALTHER LARGE SYP','NULL','114.50','5.00','MAL 60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006029','MALTHER PLAIN TAB','NULL','212.50','5.00','MAL PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006030','SINEASE 10MG TAB','NULL','51.01','5.00','SIN TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006031','SINEASE LARGE SYP','NULL','44.20','5.00','SIN 60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006032','SINEASE SMALL SYP','NULL','22.10','5.00','SIN 30','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006033','Z MAC SYP','NULL','102.00','5.00','Z M SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006034','Z MAC 250MG CAP','NULL','153.00','5.00','Z M CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006035','ZYGEST SYP','NULL','55.25','5.00','ZYG SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006036','ASTHEVIN 10MG TAB','NULL','195.50','5.00','AS 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006037','ASTHEVIN 5MG TAB','NULL','106.25','5.00','AS 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006038','DURAMOX 400MG TAB','NULL','313.65','5.00','DUR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006039','FEX HEAL 120MG TAB','NULL','97.75','5.00','FEX 120 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006040','FEX HEAL 60 TAB','NULL','46.75','5.00','FEX 60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006041','MACNAZ ORAL LARGE GEL','NULL','81.60','5.00','MAC 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006042','MACNAZ ORAL SAMALL GEL','NULL','45.90','5.00','MAC 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006043','MECOPACE 500MG TAB','NULL','97.41','5.00','MECO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006044','PANTACTA 40MG TAB','NULL','174.27','5.00','PAN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006045','VOLVEZ SYP','NULL','119.00','5.00','VOL SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006046','VOLVEZ 100MG TAB','NULL','187.01','5.00','VOL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006047','ZINEASE 100MG TAB','NULL','102.00','5.00','ZINA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006048','ALUPHAGEL LARGE SYP','NULL','56.95','5.00','ALP SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006049','PRO-F GEL','NULL','68.00','5.00','PRO G','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006050','PRO-F TAB','NULL','144.50','5.00','PRO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006051','RHINEX ADULT SYP','NULL','77.78','5.00','RH AD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006052','RHINEX CHILD SYP','NULL','42.08','5.00','RH CH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('006053','RHINEX P SYP','NULL','46.33','5.00','RH P','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007','SCHAZOO ZAKA','9','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007001','BONE CARE -C TAB','NULL','127.50','5.00','BON C TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007002','BONE CARE TAB','NULL','114.75','5.00','BON PL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007003','CYCLOSEN LARGE CAP','NULL','1836.00','5.00','CYC L CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007004','CYCLOSEN SMALL CAP','NULL','594.15','5.00','CYC S CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007005','ETHOMID 250MG TAB','NULL','405.32','5.00','ETH TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007006','FEROZAK TAB','NULL','113.25','5.00','FERO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007007','MOXIZAK 400MG TAB','NULL','276.25','5.00','MOXI Z TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007008','ORTHONATE 70MG TAB','NULL','306.00','5.00','ORT TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007009','PANCID 100MG TAB','NULL','114.54','5.00','PAN TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007010','PIRODEX 20MG TAB','NULL','148.76','5.00','PIR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007011','PYRAZID 500 TAB','NULL','114.54','5.00','PYRA TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007012','RIFA 4 + TAB','NULL','930.75','5.00','RFA 4 P TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007013','RFIA 4 TAB','NULL','472.35','5.00','RIF 4 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007014','RIFAPIN 450MG CAP','NULL','553.31','5.00','RIFAP CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007015','QUSPAR 100MG TAB','NULL','255.00','5.00','QUSP TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007016','RIFAPIN INH 150MG TAB','NULL','223.25','5.00','RIFA 150 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007017','RIFAPIN INH 300MG TAB','NULL','546.55','5.00','RIFA 300 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007018','RIFAPIN 450MG TAB','NULL','830.45','5.00','RIFA 450 T','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007019','RIFAPIN H JUNIOR SACHET','NULL','129.20','5.00','RIFP H J','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007020','RIFAPIN H SYP','NULL','45.90','0.00','RIFA H SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007021','RIFATOL TAB','NULL','534.44','5.00','RTOL  TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007022','RIFAZOL + TAB','NULL','332.35','5.00','R ZOL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007023','RIFAZOL JUNIOR SACHET','NULL','152.15','5.00','RIF J SAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007024','RIFAZOL PEDIATRIC TAB','NULL','353.60','5.00','RIFA PED','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007025','SCHAZOBEUTAL H TAB','NULL','241.40','5.00','SCHZ H TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007026','SCHAZOBEUTAL 400MG TAB','NULL','147.48','5.00','SCHZ 400TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007027','ZEXUM 20MG TAB','NULL','102.85','5.00','ZEXU 20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007028','ZEXUM 40MG TAB','NULL','171.71','5.00','ZEXU 40MG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007029','CARTEX 16MG TAB','NULL','255.00','5.00','CAR 16 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007030','CARTEX 8MG TAB','NULL','136.00','5.00','CAR 8 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007031','CARTEX H 16MG TAB','NULL','272.00','5.00','CAR H 16','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007032','DOGREL 75 MG TAB','NULL','142.80','5.00','DOGR 75 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007033','GEMIZAK 320MG TAB','NULL','357.00','5.00','GEM 320 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007034','GLEMEX 1MG TAB','NULL','51.00','5.00','GLE 1 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007035','GLEMEX 2MG TAB','NULL','85.00','5.00','GL 2 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007036','GLEMEX 3MG TAB','NULL','148.74','5.00','GL 3 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007037','GLEMEX 4MG TAB','NULL','187.00','5.00','GL 4 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007038','LIPIDIN 10MG TAB','NULL','119.00','5.00','LIP 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007039','LIPIDIN 20MG TAB','NULL','153.00','5.00','LIP 20 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007040','LIPIDIN 40MG TAB','NULL','272.00','5.00','LIP 40 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007041','LIPIDIN 80MG TAB','NULL','442.00','5.00','LIP 80 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007042','LODIPIN 10MG TAB','NULL','100.30','5.00','LOD 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007043','LODIPIN 5MG TAB','NULL','54.40','5.00','LOD 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007044','LOTENSE 25MG TAB','NULL','93.50','5.00','LOT 25 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007045','LOTENSE 50NG TAB','NULL','191.25','5.00','LOT 50 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007046','LOTENSE H TAB','NULL','255.00','5.00','LOT H TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007047','PIOFIT 30MG TAB','NULL','153.00','5.00','PIO 30 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007048','PIOFIT 45MG TAB','NULL','204.00','5.00','PIO 45 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007049','PIOFIT PLUS 15/500 TAB','NULL','113.05','5.00','PIO 500 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007050','PIOFIT PLUS 15/850 TAB','NULL','115.60','5.00','PIO 850 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007051','TRIM FAST 10MG TAB','NULL','297.50','5.00','TRIM 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007052','TRIM FAST 15MG TAB','NULL','416.50','5.00','TRIM 15 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007053','ZETAB 10MG TAB','NULL','102.00','5.00','ZET 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007054','ZAETAB PLUS TAB','NULL','229.50','5.00','ZET P TAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007055','BAMTEL 10MG TAB','NULL','191.25','5.00','BAM 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007056','BAMTEL 20MG TAB','NULL','306.00','5.00','BAM 20 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007057','CIPROL 250MG TAB','NULL','75.31','5.00','CIP 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007058','CIPROL 500MG TAB','NULL','114.59','5.00','CIP 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007059','HESTIN 10MG TAB','NULL','85.00','5.00','HES 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007060','MALFAN D.S TAB','NULL','204.00','5.00','MAL DS TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007061','MALFAN 20MG TAB','NULL','204.00','5.00','MAL 20 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007062','NASARIN SPRAY','NULL','250.75','5.00','NAS SPR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007063','RESPIMAX 125MG SYP','NULL','189.55','5.00','RES 125 SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007064','RESPIMAX 250MG TAB','NULL','136.00','5.00','RES 250 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007065','RESPIMAX 500MG TAB','NULL','255.00','5.00','RES 500 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007066','SONTEL 10MG TAB','NULL','569.50','5.00','SONT 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007067','SONTEL 4MG SACHET','NULL','142.80','5.00','SONT 4 SAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007068','SONTEL 4MG TAB','NULL','102.00','5.00','SONT 4 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007069','SONTEL 5MG TAB','NULL','331.50','5.00','SONT 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007070','TROPIZOL 40MG TAB','NULL','233.75','5.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007071','VENTAIR SYP','NULL','20.40','5.00','VENT SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007072','VENTAIR TAB','NULL','102.00','5.00','VENT TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007073','ZOPROL CAP','NULL','114.75','5.00','ZOP CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007074','RIFAPIN H SYP NEW','NULL','57.80','5.00','RIF NEW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007075','ZETAB PLUS TAB','NULL','212.50','0.00','ZTB PLS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('007076','RIFAZOL JUNIOR NEW SACHET','NULL','190.40','5.00','RIFA J NE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008','SCHAZOO PHARMA','10','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008001','ACE-BEX CAP','NULL','101.15','5.00','A BEX CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008002','COMATE DROPS','NULL','80.75','5.00','COM DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008003','CURALL -A DROPS','NULL','31.45','5.00','CURL DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008004','CURINE DROPS','NULL','68.00','5.00','CURN DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008005','DELTA FAST 5MG TAB','NULL','59.50','5.00','DELTA 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008006','DELTA FAST SYP','NULL','55.25','5.00','DELTA SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008007','DICLOMIN DROPS','NULL','47.73','5.00','DICLO DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008008','FLORAM PLAIN DROPS','NULL','43.82','5.00','FLO PL DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008009','FLORAM N DROPS','NULL','43.82','5.00','FLO N DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008010','GATICIN DROPS','NULL','68.00','5.00','GATI DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008011','GENTA PRED DROPS','NULL','29.75','5.00','GENTA DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008012','GLAZOL T DROPS','NULL','391.00','5.00','GL T DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008013','I -FRESH DROPS','NULL','34.00','5.00','I FR DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008014','KETOT DROPS','NULL','106.25','5.00','KET DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008015','LATEP DROPS','NULL','331.50','5.00','LAT DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008016','LEQUIX DROPS','NULL','97.75','5.00','LEQ DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008017','MOXICIN DROPS','NULL','127.50','5.00','MOXI DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008018','NATACIN DROPS','NULL','127.50','5.00','NAT DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008019','OFLEXER DROPS','NULL','75.40','5.00','OF DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008020','PRED + DROPS','NULL','42.93','5.00','PRE P DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008021','PREDNISYNTH  DROPS','NULL','33.15','5.00','PRED DROPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008022','SCHAZOOMYCETIN DROPS','NULL','22.31','5.00','SCH DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008023','TIMOSOL DROPS','NULL','77.61','5.00','TIM DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008024','TOBRA DROPS','NULL','63.75','5.00','TOB DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('008025','TOBRA D DROPS','NULL','80.75','5.00','TOB DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009','EPLA LABS','8','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009001','ACEARTIN 50MG TAB','NULL','170.00','5.00','ACR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009002','ANXOLITE TAB','NULL','76.51','5.00','ANXO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009003','CO-ACEARTIN TAB','NULL','195.50','5.00','CO ACR TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009004','CYNODOX SF SYP','NULL','58.66','5.00','CYNO SF SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009005','DEPRAM 10MG TAB','NULL','204.00','5.00','DEP TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009006','DEPROX CAP','NULL','52.10','5.00','DPRX CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009007','EPLACARD 100MG TAB','NULL','42.50','5.00','EP CRD 100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009008','EPLACARD 50MG TAB','NULL','63.75','5.00','EP CRD 50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009009','EPLAZYM CAP','NULL','56.96','5.00','EP ZYM CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009010','EPLAZYM SYP','NULL','52.71','5.00','EP ZYM SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009011','GLIGAURD 1MG TAB','NULL','51.00','5.00','GLG 1 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009012','GLIGAURD 2MG TAB','NULL','85.00','5.00','GLG 2 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009013','HISTAMOL-D SYP','NULL','61.97','5.00','HIS D SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009014','MECOL INJ','NULL','276.25','5.00','MECO INJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009015','MECOL TAB','NULL','93.50','5.00','MECO TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009016','PRESCARD 5MG TAB','NULL','85.00','5.00','PRES TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009017','PROSDURA 2MG TAB','NULL','212.50','5.00','PROS 2 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009018','RELAXIPAM 2MG TAB','NULL','49.03','5.00','RELX 2 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009019','RELAXIPAM 5MG TAB','NULL','105.06','5.00','RLEX 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009020','RHEPROX 250MG TAB','NULL','71.40','5.00','R PROX TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009021','BACIMEIX 10GM OINT','NULL','46.76','5.00','BC MIX 10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009022','BACIMIX 15GM TAB','NULL','58.65','5.00','B MIX 15','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009023','BACIMIX POWDER','NULL','29.75','5.00','B MIX PWDR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009024','CEFYLE ESF SYP','NULL','29.33','5.00','CEF ESF SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009025','CIPAMOX 125MG LARGE SYP','NULL','42.50','5.00','CIP 125 LA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009026','CIPAMOX 125MG SP','NULL','27.75','5.00','CIP 125 SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009027','CIPAMOX 250MG CAP','NULL','53.00','5.00','CIP 250 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009028','CIPAMOX 500MG CAP','NULL','63.75','5.00','CIP 500 CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009029','CIPAMOX FORTE SYP','NULL','57.80','5.00','CIP FRT SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009030','CURODERM LARGE CERAM','NULL','140.25','5.00','CURO LRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009031','CURODERM SAMALL CREAM','NULL','46.75','5.00','CURO SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009032','CURODERM H LARGE CREAM','NULL','178.50','5.00','CURO H LRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009033','CURODERM H SMALL','NULL','59.54','5.00','CURO H SM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009034','CYNODOX C TAB','NULL','91.80','5.00','CYN TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009035','EPLACHERY SYP','NULL','43.44','5.00','EP CHER','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009036','MYCONIT CREAM','NULL','55.26','5.00','MYC PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009037','MYCONIT H CREAM','NULL','59.51','5.00','MYCO H','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009038','RIBAZID 200MG CAP','NULL','252.45','5.00','RIBA CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009039','RIBAZID SYP','NULL','78.80','5.00','RIBA SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009040','RIBAZID CREAM','NULL','112.06','5.00','RIBA CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009041','ASMAKAST 10MG TAB','NULL','214.20','5.00','ASM 10 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009042','CANALAC SYP','NULL','206.08','5.00','CAN SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009043','CEFYLE P SYP','NULL','40.78','5.00','CEF P SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009044','CYNODOX C SYP','NULL','56.03','5.00','CYNO C SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009045','EPLALEV 250MG TAB','NULL','92.23','5.00','E LEV 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009046','EPLALEV 500MG TAB','NULL','157.25','5.00','E LEV 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009047','FLAREN 50MG TAB','NULL','54.60','5.00','FLA 50 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009048','FLAREN GEL','NULL','63.67','5.00','FLA GEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009049','MCURE 40/240 TAB','NULL','212.50','5.00','MCU TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009050','OMPEC 20MG CAP','NULL','134.83','5.00','OM CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009051','ASMAKAST 5MG TAB','NULL','204.00','5.00','ASM 5 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009052','CIPAMOX 250MG TAB','NULL','245.38','5.00','CIP 250 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009053','CIPAMOX 500 TAB','NULL','553.35','5.00','CIP 500 TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009054','CIPAMOX DROPS','NULL','18.62','5.00','CIP DRP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009055','CIPROCIDE 250MG TAB','NULL','86.87','5.00','CIPR 250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009056','CIPROCIDE 500MG TAB','NULL','166.35','5.00','CIPR 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009057','DIARHOL SYP','NULL','15.83','5.00','DIA SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009058','DOLORAN PALIN TAB','NULL','352.72','5.00','DOL R PL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009059','DOLORAN SYP','NULL','10.69','5.00','DOL R SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009060','DOLORAN DS TAB','NULL','221.00','5.00','DOL DS TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009061','EPIDOX 100MG CAP','NULL','39.95','5.00','EPI CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009062','EPLAROX  150MG TAB','NULL','144.50','5.00','EP ROX 150','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009063','HIBASTIN TAB','NULL','82.45','5.00','HIB TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009064','HISTADINE TAB','NULL','50.15','5.00','HIS TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009065','HISTAMOL TAB JAR','NULL','62.63','5.00','HIST TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009066','NACTA TAB','NULL','76.52','5.00','NAC TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009067','RHEPROX 500MG TAB','NULL','131.75','5.00','RHE 500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009068','WORMIZIL FORT TAB','NULL','12.75','5.00','WORM FRT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009069','WORMIZOL SUSP','NULL','16.63','5.00','WORM SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009070','WORMIZOL TAB','NULL','102.43','5.00','WORM PL TB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009071','CEFYLE ESF SYP NEW','NULL','35.08','5.00','CEF NEW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009072','RINERGE NASAL SOLUTION','NULL','31.45','5.00','RIN SOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009073','ACNESAFE LOTION','NULL','127.50','3.00','ACNE LOT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009074','AZOCIN DRY SUSP','NULL','63.75','5.00','AZO SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('009075','AZOCIN 250MG CAP','NULL','216.75','5.00','AZO CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010','PACIFIC PHARMA','7','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010001','CINQUIN 250MG TAB','NULL','98.18','5.00','CINQ250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010002','CINQUIN 500MG TAB','NULL','156.58','5.00','CINQ500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010003','COLENTICON SYP','NULL','71.47','5.00','COLEN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010004','DELTARHINOL SPRAY','NULL','23.80','5.00','DELTASP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010005','LEVOPRAID 25MG TAB','NULL','175.63','5.00','LEVO25','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010006','NAPERBEN GEL','NULL','93.50','5.00','NAPER','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010007','NAPERBEN 275MG CAP','NULL','225.18','5.00','NAPERB275','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010008','NAPREBEN 550MG CAP','NULL','336.20','5.00','NAPR550','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010009','NOVAHIST 120MG TAB','NULL','89.25','5.00','NOVA120','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010010','NOVAHIST 180MG TAB','NULL','72.25','5.00','NOVA180','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010011','NOVAHIST 60MG TAB','NULL','53.55','5.00','NOVA60','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010012','NOVAHIST-D TAB','NULL','78.20','5.00','NOVAD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010013','PLASENZYM TAB','NULL','195.02','5.00','PLAS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010014','PLASIL W/ENZYME TAB','NULL','195.02','5.00','PLASWITH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010015','CLOMID 50MG TAB','NULL','297.50','5.00','CLOMID','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010016','CYSTALGON TAB','NULL','348.50','5.00','CYST','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010017','FEMIDOL PLUS TAB','NULL','252.45','5.00','FEMPLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010018','FEMIDOL TAB','NULL','120.41','5.00','FEMI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010019','GENURIN FORTE TAB','NULL','340.00','5.00','GENFORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010020','GENURIN SIMPLICE TAB','NULL','124.10','5.00','GENURSIMP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010021','LOMEXIN DERMAL LARGE','NULL','84.95','5.00','LOMDER','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010022','LOMEXIN DERMAL SMALL.','NULL','53.60','5.00','LOMSMA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010023','LOMEXIN VAGINAL CREAM','NULL','246.10','5.00','LOMVAG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010024','LOMEXIN-T 1000MG TAB','NULL','447.15','0.00','LOMT1000','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010025','MAXIUS LOZ(HONEY)','NULL','56.91','5.00','MHON','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010026','MAXIUS LOZ.(LEMON)','NULL','60.33','5.00','MLEM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010027','MAXIUS LOZ.(M.F)','NULL','51.85','5.00','M-MF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010028','MAXIUS LOZ.(P.F)','NULL','51.85','5.00','M-P.F','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010029','MAXIUS M/WASH SYP','NULL','65.74','5.00','M-MWASH','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010030','PHLOGENZYM TAB','NULL','455.51','5.00','PHLO','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010031','WOBENZYM-N TAB','NULL','436.39','5.00','WOB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010032','CRAFILM SMALL SYP','NULL','83.87','5.00','CRASMSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010033','CRAFILM SYP','NULL','148.66','5.00','CRASYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010034','CRAFILM CHEWABLE TAB','NULL','63.56','5.00','CRACHEW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010035','LEVOPRAID 100MG TAB','NULL','648.59','5.00','LEVO100','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010036','LEVOPRAID 50MG TAB','NULL','351.26','5.00','LEVO50','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010037','LORTEM TABLET','NULL','34.85','5.00','LORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010038','"PACIFIC','S DM SYP"','NULL','55.27','5.00','PACDM');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010039','"PACIFIC','S JACK JILL"','NULL','45.20','5.00','PACJJ');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010040','PACIFIC MIXTURE','NULL','43.05','5.00','PACMIX','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010041','PACIFIC PAIN RUB GEL','NULL','106.25','5.00','PACGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010042','RIFADIN SYP','NULL','47.60','5.00','RIFADSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010043','RIFATER TAB','NULL','272.85','5.00','RIFAT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010044','RIFIN FORTE TAB','NULL','744.60','5.00','RIFFOR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010045','RIFIN-E TABLET','NULL','521.05','5.00','RIF-E','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010046','RIFINAH 300MG TAB','NULL','218.45','5.00','RIFN300','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010047','RIFINAH 450MG TAB','NULL','332.35','5.00','RIF450','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010048','THEO-DUR 200MG TAB','NULL','418.88','5.00','THEO200','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010049','THEO-DUR 300MG TAB','NULL','309.47','5.00','THEO300','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010050','VELOXIN 400MG TAB','NULL','267.75','5.00','VELO400','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010051','XIBEN SYP','NULL','29.75','5.00','XIBSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010052','XIBEN TABLET','NULL','53.55','5.00','XIBTAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010053','DOLOPRIN 75MG TAB','NULL','24.05','5.00','DOLO75','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010054','OLBETAM 250MG CAP','NULL','576.26','5.00','OLB250','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010055','VALVOZID-10 TAB','NULL','136.00','5.00','VALVO10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010056','VALVOZID-5 PLUS TAB','NULL','80.75','5.00','VALV5PLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010057','VALVOZID-5 TAB','NULL','80.75','5.00','VALV5','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010058','XURIN-K TAB','NULL','127.50','5.00','XURK','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010059','ZANIDIP-20MG TAB','NULL','173.55','5.00','ZAN20','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010060','ZANIDIP-10MG TAB','NULL','108.34','5.00','ZAN10','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('010061','PACIFIC JACK JILL RUB 45 GM','NULL','93.50','0.00','PCFIC RUB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011','HERBION LABS','11','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011001','ALFAGIN CAP','NULL','85.00','5.00','ALFACAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011002','ALFAGIN SYP','NULL','63.75','5.00','ALFASYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011003','BONJIGAR CAP','NULL','68.00','5.00','BONJCAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011004','BONJIGAR SYP','NULL','63.75','5.00','BONJSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011005','DERMIDOC ACNE CREAM','NULL','112.20','5.00','DERMACNE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011006','DERMIDOC CREAM','NULL','32.30','5.00','DERMI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011007','ENTOBAN CAP','NULL','51.00','5.00','ENTOCAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011008','ENTOBAN SYP','NULL','25.50','5.00','ENTOSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011009','ENTOCID SYP','NULL','42.50','5.00','ENTCID','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011010','EVICA SYP','NULL','51.00','5.00','EVICASYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011011','EVICA CAP','NULL','85.00','5.00','EVICACAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011012','INFIDOL COLIC SYP','NULL','34.00','5.00','INFICOL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011013','INFIDOL DROPS','NULL','29.75','5.00','INFIDRPS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011014','INTELAN CAP','NULL','68.00','5.00','INTELCAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011015','INTELAN SYP','NULL','76.51','5.00','INTSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011016','LINKUS SUGAR FREE SYP','NULL','38.25','5.00','LINKSF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011017','LINKUS SYP','NULL','34.00','5.00','LINK','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011018','MAXFER IRON SYP','NULL','59.50','5.00','MAXFSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011019','REXAMIN TAB','NULL','229.50','5.00','REXATAB','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011020','VERONA CAP','NULL','161.50','5.00','VERCAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011021','VERONA PLUS CAP','NULL','255.00','5.00','VERPLUS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011022','VIVABON SYP','NULL','46.75','5.00','VIVASYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011023','DIGESTY SACHETS','NULL','21.25','5.00','DIGSAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011024','FIBERLAX FP JAR','NULL','153.00','5.00','FIBFPJAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011025','FIBERLAX FRUIT PUNCH','NULL','51.00','5.00','FIBFP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011026','FIBERLAX ORANGE JAR','NULL','165.75','5.00','FIBORAN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011027','FIBERLAX ORNAGE SACHET','NULL','51.00','5.00','FIBORSAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011028','FIBERLAX PLAIN JAR','NULL','161.50','5.00','FIBPLJAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011029','FIBERLAX PLAIN SACHET','NULL','51.00','5.00','FIBPLSAC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011030','GASTRIL-P LARGE TABLET','NULL','38.50','5.00','GASPLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011031','GASTRIL-P SMALL TABLET','NULL','25.50','5.00','GASTSMAL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011032','INSTY JOSHANDA ANISE','NULL','21.25','5.00','INSANS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011033','INSTY JOSHANDA CARDANIUM','NULL','21.25','5.00','INSCAR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011034','INSTY JOSHANDA CHOCLATE','NULL','21.25','5.00','INSCHOC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011035','INSTY JOSHANDA COFEE','NULL','21.25','5.00','INSCOF','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011036','INSTY JOSHANDA LEMON','NULL','21.25','5.00','INSLEM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011037','INSTY JOSHANDA PLAIN','NULL','21.25','5.00','INSPLA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011038','LINKUS BALM','NULL','29.75','5.00','LINBAL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011039','LINKUS HONEY LOZGS','NULL','212.50','5.00','LINHON','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011040','LINKUS MINT FLAVOUR','NULL','212.50','5.00','LINMINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011041','LINKUS NOVA CHERRY','NULL','204.00','5.00','LINCHER','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011042','LINKUS NOVA EXTRA MINT','NULL','280.00','0.00','LINKEXMIN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011043','LINKUS NOVA GRAPES LARGE','NULL','280.00','0.00','LINGRPLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011044','LINKUS NOVA GRAPES SMALL','NULL','235.00','0.00','LINGRSM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011045','LINKUS NOVA HONEY LEMON SMALL','NULL','235.00','0.00','LINHOLE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011046','LINKUS NOVA LEMON LARGE','NULL','280.00','0.00','LINNOVLE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011047','LINKUS NOVA LEMON SMALL','NULL','235.00','0.00','LINNOVLEM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011048','LINKUS NOVA ORANGE LRG','NULL','280.00','0.00','LINORLRG','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011049','LINKUS NOVA ORANGE SMALL','NULL','235.00','0.00','LINKOR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011050','LINKUS NOVA ORANGE T','NULL','357.00','5.00','LINORT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011051','LINKUS NOVA PINEAPPLE','NULL','235.00','0.00','LINPA','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011052','LINKUS NOVA PINE APPLE','NULL','204.00','5.00','LINKPAS','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011053','LINKUS NOVA S.F ORANGE','NULL','357.00','5.00','LINSFOR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011054','LINKUS NOVA STRAWBERRY','NULL','204.00','5.00','LINSTRAW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011055','LINKUS ORANGE LOZDGES','NULL','212.50','5.00','LINORLOZ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011056','PEDIGON GRIPE WATER','NULL','15.30','5.00','PEDGW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011057','TOOT RUS JAR','NULL','161.50','5.00','TOTRJR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011058','TOOT RUS LOZENGUS','NULL','200.00','0.00','TOTLOZ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('011059','TOOT RUS SYP','NULL','25.50','5.00','TOOTSYP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012','ALAST PHYTOCEUTICALS','12','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012001','AFERIC CAP','NULL','101.15','5.00','AF CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012002','AFERIC SYP','NULL','68.85','5.00','AF SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012003','ALASTI OINTMENT','NULL','27.20','5.00','ALSTI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012004','AP COUGH SYP','NULL','44.20','5.00','AP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012005','WELBON SYP','NULL','86.70','5.00','WLBN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012006','DZINC SYP','NULL','51.00','5.00','D ZINC','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012007','LECUR CAP','NULL','289.00','5.00','LEC CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012008','RPILE CAP','NULL','255.00','5.00','RPLE CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012009','SILYBUM SYP','NULL','90.95','5.00','SBUM SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012010','SILYBUM CAP','NULL','167.45','5.00','SBUMCP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012013','SILYBUM PLUS POWDER','NULL','616.25','5.00','S BUM PWD','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012014','TRIFLA SYP','NULL','44.20','5.00','TRF SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012015','VIGON CAP','NULL','320.45','5.00','VGON','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012016','RABILING 0.5ML INJ','NULL','603.50','5.00','RABI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012017','WARTET INJ','NULL','272.00','5.00','WAR IJ','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012018','SWEET BERRY SACHET','NULL','170.00','5.00','S BERY','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012019','HERBORA MOUTH WASH','NULL','102.00','5.00','HER MW','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012020','ORILIFE SACHET','NULL','127.50','5.00','ORI','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012021','VIGON CAP NEW','NULL','255.00','5.00','VIG CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012022','GAST CUR CAP','NULL','238.00','5.00','GAS CP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('012023','AGUELING  SYP','NULL','102.00','5.00','AGU SP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013','MARKETING COMPANIES','14','0.00','5.00','NULL','');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013001','UNIDOL 500MG TAB','NULL','82.00','5.00','UNI500','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013002','OPTIAIR (SPACER DEVICE)','NULL','299.20','1.00','OPTIAIR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013003','-CYNODOX C SYP','NULL','56.03','0.00','','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013004','-SCABION FORTE LOTION','NULL','64.82','5.00','SC FRT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013005','-COMBINOL-E SYP','NULL','30.60','5.00','COMBE','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013006','CLINGARD GEL','NULL','195.50','3.00','CLIGEL','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013007','KETOREX SCALP LOTION','NULL','184.45','3.00','KTRX LTN','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013008','MOMETADERM CREAM','NULL','187.85','3.00','MTDM CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013009','MOMETADERM OINT','NULL','187.85','3.00','MTDM OINT','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013010','ELUCIDER CREAM','NULL','119.00','3.00','ELDR CREAM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013011','TRETIGEN CAPSULES 20 MG','NULL','516.80','3.00','TRTGN CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013012','DERMAGLOW NIGHT CREAM','NULL','706.50','3.00','DMG CERAM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013013','NEOBRELLA SPF 60 CREAM','NULL','346.50','3.00','NBRL60 CR','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013014','NEOBLANC CREAM','NULL','148.75','3.00','NBLC CREAM','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013015','APHRODEX CAPSULES','NULL','675.00','5.00','APH CAP','001001');insert  into `products`(`productid`,`prodname`,`supplierid`,`unitprice`,`discounts`,`misccode`,`ProductType`) values ('013016','ISO-ACNE GEL','NULL','195.50','5.00','ISOGEL','001001');