INSERT INTO `cancelwiseorderlistitems` (`_id`, `date`, `time`, `user`, `billno`, `sale`, `refund`, `reason`, `billcount`) VALUES (1,'27 Jun 2024','03:48:30 PM','ladmin','20240627-0000128','10.00','10.00','Changed mind','537'),(2,'27 Jun 2024','03:49:31 PM','ladmin','20240623-0000197','500.00','500.00','Changed mind','377'),(3,'27 Jun 2024','03:50:37 PM','ladmin','20240623-0000312','110.00','30.00','Accidental charge','404'),(4,'27 Jun 2024','04:01:39 PM','ladmin','20240621-0000151','1300.00','500.00','Changed mind','68'),(5,'27 Jun 2024','04:07:49 PM','ladmin','20240621-0000129','95.00','75.00','Changed mind','46'),(6,'27 Jun 2024','04:01:39 PM','ladmin','20240621-0000151','1300.00','500.00','Changed mind','68'),(7,'27 Jun 2024','04:07:49 PM','ladmin','20240621-0000129','95.00','75.00','Changed mind','46'),(8,'07 Jul 2024','04:25:25 PM','ladmin','20240707-0000171','220.00','80.00','Changed mind','1115'),(9,'07 Jul 2024','05:09:45 PM','ladmin','20240707-0000168','810.00','750.00','Changed mind','1112'),(10,'07 Jul 2024','05:11:43 PM','ladmin','20240707-0000135','260.00','200.00','Changed mind','1079'),(11,'07 Jul 2024','05:14:52 PM','ladmin','20240707-0000138','400.00','400.00','Changed mind','1082'),(12,'06 Jul 2024','06:33:35 PM','ladmin','20240706-0000260','50.00','50.00','Changed mind','1025'),(13,'04 Jul 2024','06:52:13 PM','ladmin','20240704-000021','40.00','40.00','Changed mind','780'),(14,'04 Jul 2024','07:00:44 PM','ladmin','20240704-0000132','10.00','10.00','Changed mind','782'),(15,'05 Jul 2024','08:18:40 PM','ladmin','20240705-0000361','2500.00','700.00','Changed mind','859'),(16,'08 Jul 2024','09:25:00 AM','ladmin','20240708-000011','280.00','80.00','Changed mind','1120'),(17,'05 Jul 2024','09:25:43 PM','ladmin','20240705-0000361','1800.00','800.00','Changed mind','859'),(18,'05 Jul 2024','09:27:33 PM','ladmin','20240705-0000361','1000.00','1000.00','Changed mind','859'),(19,'05 Jul 2024','10:58:13 PM','ladmin','20240705-0000161','900.00','300.00','Changed mind','909'),(20,'06 Jul 2024','12:12:27 AM','ladmin','20240705-0000153','30.00','30.00','Changed mind','901'),(21,'09 Jul 2024','10:37:45 AM','ladmin','20240708-0000137','180.00','30.00','Changed mind','1156'),(22,'05 Jul 2024','10:58:13 PM','ladmin','20240705-0000161','900.00','300.00','Changed mind','909'),(23,'06 Jul 2024','12:12:27 AM','ladmin','20240705-0000153','30.00','30.00','Changed mind','901');
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'nutella',850),(2,'Candle (5Nos)',300),(3,'Chain',1700),(4,'Idol',1600),(5,'Key Chain',170),(6,'Rosary',920),(7,'bay leaf/patta 20g',11),(8,'beans kg',160),(9,'beet root kg',64),(10,'capsicum green kg',80),(11,'carrots kg',70),(12,'cauliflower kg',45),(13,'dabur lemon juice 250ml',66),(14,'ghari detergent powder 1kg',47),(15,'limca 2.25ltr',76),(16,'monster energy 475ml',90),(17,'mountain dew 600ml',33),(18,'mtr badam drink 200gm',93),(19,'nutella',1020),(20,'onions big kg',60),(21,'radish white kg',48),(22,'real fruit mango 1ltr',94),(23,'real fruit orange 1ltr',94),(24,'rin powder 6kg',420),(25,'roohafza 750ml',119),(26,'sprite 2ltr',76),(27,'sweet corn piece',15),(28,'tata urad dal whole white 1kg',500),(29,'tide plus 4kg',361),(30,'tropicana apple 1ltr',94),(31,'மெழுகுவர்த்தி',280),(32,'Urivam',200),(33,'Textile 350',350),(34,'Textile 400',400),(35,'Textile 500',1000),(36,'Thottil',50),(37,'Urivam',380),(38,'Textile 500',2000),(39,'Thottil',50),(40,'Urivam',490),(41,'Textile 400',2800),(42,'Textile 450',900),(43,'Textile 500',4500),(44,'Thottil',50),(45,'Urivam',560),(46,'Urivam',560),(47,'Thottil',50),(48,'Urivam',630),(49,'Velankanni Madha (S)',250),(50,'Velankanni Madha (S)',250),(51,'Wood Sticker',100),(52,'Textile 450',900),(53,'Textile 500',5000),(54,'Textile 600',1200),(55,'Textile 650',650),(56,'Textile 800',800),(57,'Thottil',50),(58,'Urivam',980),(59,'Velankanni Madha (S)',250),(60,'Wood Sticker',100),(61,'Velankanni Madha (S)',250),(62,'Vennila Small cup',100),(63,'Vennila cone',280),(64,'metal  magnets',60),(65,'photo Stand',50),(66,'Textile 800',800),(67,'Urivam',120),(68,'Velankanni Madha (S)',250),(69,'Vennila Small cup',40),(70,'Vennila cone',120),(71,'White Glass Small',40),(72,'key stand',160),(73,'metal  magnets',60),(74,'photo Stand',50),(75,'sli candle stand',200),(76,'photo Stand',50),(77,'sli candle stand',200),(78,'sli candle stand',200),(79,'sli candle stand',200),(80,'sli candle stand',200),(81,'photo Stand',50),(82,'sli candle stand',200),(83,'sli candle stand',200),(84,'photo Stand',50),(85,'sli candle stand',200),(86,'Vennila cone',120),(87,'Vennila mini cone',40),(88,'White Glass Small',40),(89,'Wood Cross (S)',60),(90,'Wood Keychain BK',40),(91,'key stand',240),(92,'metal  magnets',60),(93,'photo Stand',50),(94,'scapier M',30),(95,'sli candle stand',200),(96,'Madha Frame LED',300),(97,'Magnet Sticker',50),(98,'Malai Madha book',40),(99,'Mango Ice cream',440),(100,'Mary Madha Statue',500),(101,'Mary Madha Statue (S)',250),(102,'Metal Magnets',120),(103,'Metal rosary',2000),(104,'Michael Statue Big',1600),(105,'PL Candle Stand Pair',640),(106,'Pasta bar ice',240),(107,'Photo Frame Chakra',300),(108,'Photo Freme',500),(109,'Red velvet cone',700),(110,'Rosary 10',1190),(111,'Sagaya Madha Statue',2000),(112,'Samrani',2775),(113,'Scapler (S)',120),(114,'Sleeping Joseph',2700),(115,'Statue',250),(116,'Sticker 10',720),(117,'Sticker 20',700),(118,'Sticker 30',810),(119,'Sticker 50',50),(120,'Straberry mini cone',540),(121,'Straberry sundae cup',100),(122,'Super Photo Stand',260),(123,'Tender coconut minitub',180),(124,'Textile 200',11200),(125,'Textile 250',8500),(126,'Textile 300',8100),(127,'Textile 350',10150),(128,'Textile 400',13600),(129,'Textile 450',4950),(130,'Textile 500',9000),(131,'Textile 550',550),(132,'Textile 600',1200),(133,'Textile 650',1300),(134,'Textile 700',700),(135,'Textile 800',3200),(136,'Thottil',50),(137,'Urivam',1470),(138,'Velankanni Madha (S)',1250),(139,'Vennila Small cup',730),(140,'Vennila cone',520),(141,'Vennila mini cone',320),(142,'White Glass Small',300),(143,'Wood Cross (L)',80),(144,'Wood Cross (S)',60),(145,'Wood Keychain BK',280),(146,'Wood Sticker',400),(147,'key stand',640),(148,'malaimadha book',120),(149,'metal  magnets',60),(150,'metal rosary',200),(151,'photo Stand',50),(152,'scapier M',150),(153,'sli candle stand',200);
INSERT INTO `itemwiseorderlistcategory` (`_id`, `itemno`, `categoryname`, `sales`, `salespercentage`, `itemtotalquan`) VALUES (1,NULL,'None',6870,55,'31'),(2,NULL,'Rosary',1380,11,'30'),(3,NULL,'Spritual Item',4290,34,'163'),(4,NULL,'Statues',3220,46,'7'),(5,NULL,'Statues',750,2,'2');
INSERT INTO `itemwiseorderlistitems` (`_id`, `itemno`, `itemname`, `sales`, `salespercentage`, `itemtotalquan`, `category`, `i_buying_price`, `mi_buying_price`, `i_cost_value`, `i_cost_percent`, `mi_cost_value`, `mi_cost_percent`, `barcode_value`) VALUES (1,'3','nutella',850,100,'5','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1599','Candle (5Nos)',300,3,'6','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1609','Chain',1700,18,'4','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1605','Idol',1600,17,'2','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'1603','Key Chain',170,2,'2','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'1601','Rosary',920,10,'8','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'1601','bay leaf/patta 20g',11,0,'1','masalas and spices',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1601','beans kg',160,2,'4','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'1601','beet root kg',64,1,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'1601','capsicum green kg',80,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'1601','carrots kg',70,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'1601','cauliflower kg',45,1,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'1601','dabur lemon juice 250ml',66,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'1601','ghari detergent powder 1kg',47,1,'1','household',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'1601','limca 2.25ltr',76,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'1601','monster energy 475ml',90,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'1601','mountain dew 600ml',33,0,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'1601','mtr badam drink 200gm',93,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'1601','nutella',1020,11,'6','branded foods',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'1601','onions big kg',60,1,'3','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'1601','radish white kg',48,1,'2','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'1601','real fruit mango 1ltr',94,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'1601','real fruit orange 1ltr',94,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'1601','rin powder 6kg',420,5,'1','household',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'1601','roohafza 750ml',119,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'1601','sprite 2ltr',76,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'1601','sweet corn piece',15,0,'1','fruits and vegetables',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'1601','tata urad dal whole white 1kg',500,5,'2','dals pulses',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'1601','tide plus 4kg',361,4,'1','household',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'1601','tropicana apple 1ltr',94,1,'1','beverages',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'1601','மெழுகுவர்த்தி',280,3,'5','rice whole grains',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'10','Urivam',200,2,'20.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(33,'1920','Textile 350',350,3,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'1922','Textile 400',400,3,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'1925','Textile 500',1000,8,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'1913','Thottil',50,0,'1','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'1911','Urivam',380,3,'38','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'1925','Textile 500',2000,11,'4','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'1913','Thottil',50,0,'1','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'1911','Urivam',490,3,'49','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,'400','Textile 400',2800,9,'7.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12005'),(42,'450','Textile 450',900,3,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12006'),(43,'500','Textile 500',4500,15,'9.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12007'),(44,'50','Thottil',50,0,'1.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(45,'10','Urivam',560,2,'56.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(46,'10','Urivam',560,2,'56.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(47,'1913','Thottil',50,0,'1','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,'1911','Urivam',630,2,'63','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,'1883','Velankanni Madha (S)',250,1,'1','Statues',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,'1883','Velankanni Madha (S)',250,1,'1','Statues',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,'1891','Wood Sticker',100,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,'1924','Textile 450',900,2,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,'1925','Textile 500',5000,10,'10','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,'1927','Textile 600',1200,2,'2','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(55,'1928','Textile 650',650,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,'1931','Textile 800',800,2,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,'1913','Thottil',50,0,'1','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,'1911','Urivam',980,2,'98','Spritual Item',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,'1883','Velankanni Madha (S)',250,1,'1','Statues',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,'1891','Wood Sticker',100,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,'1883','Velankanni Madha (S)',250,2,'1','Statues',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,'1994','Vennila Small cup',100,1,'10','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,'1974','Vennila cone',280,2,'7','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,'2010','metal  magnets',60,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,'2010','photo Stand',50,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,'800','Textile 800',800,4,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12013'),(67,'10','Urivam',120,1,'12.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(68,'250','Velankanni Madha (S)',250,1,'1.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11018'),(69,'10','Vennila Small cup',40,0,'4.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991230'),(70,'40','Vennila cone',120,1,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991452'),(71,'20','White Glass Small',40,0,'2.0','Rosary','0.0','0.0','0.0','0.0','0.0','0.0','202437'),(72,'80','key stand',160,1,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11039'),(73,'80','metal  magnets',60,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11043'),(74,'80','photo Stand',50,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','10128'),(75,'200','sli candle stand',200,1,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11046'),(76,'2010','photo Stand',50,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,'2010','photo Stand',50,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,'2010','photo Stand',50,0,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,'2055','sli candle stand',200,1,'1','None',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,'40','Vennila cone',120,0,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991452'),(87,'20','Vennila mini cone',40,0,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991759'),(88,'20','White Glass Small',40,0,'2.0','Rosary','0.0','0.0','0.0','0.0','0.0','0.0','202437'),(89,'60','Wood Cross (S)',60,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11050'),(90,'40','Wood Keychain BK',40,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11052'),(91,'80','key stand',240,1,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11039'),(92,'80','metal  magnets',60,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11043'),(93,'80','photo Stand',50,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','10128'),(94,'10','scapier M',30,0,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11049'),(95,'200','sli candle stand',200,1,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11046'),(96,'300','Madha Frame LED',300,0,'1.0','Photo Frames','0.0','0.0','0.0','0.0','0.0','0.0','10122'),(97,'300','Magnet Sticker',50,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11019'),(98,'40','Malai Madha book',40,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0',' 13006'),(99,'40','Mango Ice cream',440,0,'11.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991278'),(100,'500','Mary Madha Statue',500,0,'1.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11002'),(101,'250','Mary Madha Statue (S)',250,0,'1.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11015'),(102,'60','Metal Magnets',120,0,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11043'),(103,'200','Metal rosary',2000,1,'10.0','None','0.0','0.0','0.0','0.0','0.0','0.0','16002'),(104,'1600','Michael Statue Big',1600,1,'1.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11007'),(105,'160','PL Candle Stand Pair',640,0,'4.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11044'),(106,'20','Pasta bar ice',240,0,'12.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991827'),(107,'150','Photo Frame Chakra',300,0,'2.0','Photo Frames','0.0','0.0','0.0','0.0','0.0','0.0','10121'),(108,'500','Photo Freme',500,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','115003'),(109,'50','Red velvet cone',700,0,'14.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991988'),(110,'10','Rosary 10',1190,1,'119.0','None','0.0','0.0','0.0','0.0','0.0','0.0','16001'),(111,'500','Sagaya Madha Statue',2000,1,'4.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11003'),(112,'75','Samrani',2775,1,'37.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0','10002'),(113,'5','Scapler (S)',120,0,'24.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11048'),(114,'300','Sleeping Joseph',2700,1,'9.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11013'),(115,'250','Statue',250,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11023'),(116,'10','Sticker 10',720,0,'72.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11030'),(117,'20','Sticker 20',700,0,'35.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11031'),(118,'30','Sticker 30',810,0,'27.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11028'),(119,'50','Sticker 50',50,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11029'),(120,'20','Straberry mini cone',540,0,'27.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151992060'),(121,'50','Straberry sundae cup',100,0,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991179'),(122,'130','Super Photo Stand',260,0,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11042'),(123,'60','Tender coconut minitub',180,0,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991636'),(124,'200','Textile 200',11200,6,'56.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12001'),(125,'250','Textile 250',8500,4,'34.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12002'),(126,'300','Textile 300',8100,4,'27.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12003'),(127,'350','Textile 350',10150,5,'29.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12004'),(128,'400','Textile 400',13600,7,'34.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12005'),(129,'450','Textile 450',4950,2,'11.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12006'),(130,'500','Textile 500',9000,4,'18.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12007'),(131,'550','Textile 550',550,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12008'),(132,'600','Textile 600',1200,1,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12009'),(133,'650','Textile 650',1300,1,'2.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12010'),(134,'700','Textile 700',700,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12011'),(135,'800','Textile 800',3200,2,'4.0','None','0.0','0.0','0.0','0.0','0.0','0.0','12013'),(136,'50','Thottil',50,0,'1.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(137,'10','Urivam',1470,1,'147.0','Spritual Item','0.0','0.0','0.0','0.0','0.0','0.0',''),(138,'250','Velankanni Madha (S)',1250,1,'5.0','Statues','0.0','0.0','0.0','0.0','0.0','0.0','11018'),(139,'10','Vennila Small cup',730,0,'73.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991230'),(140,'40','Vennila cone',520,0,'13.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991452'),(141,'20','Vennila mini cone',320,0,'16.0','None','0.0','0.0','0.0','0.0','0.0','0.0','8906151991759'),(142,'20','White Glass Small',300,0,'15.0','Rosary','0.0','0.0','0.0','0.0','0.0','0.0','202437'),(143,'80','Wood Cross (L)',80,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11051'),(144,'60','Wood Cross (S)',60,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11050'),(145,'40','Wood Keychain BK',280,0,'7.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11052'),(146,'100','Wood Sticker',400,0,'4.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11022'),(147,'80','key stand',640,0,'8.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11039'),(148,'40','malaimadha book',120,0,'3.0','None','0.0','0.0','0.0','0.0','0.0','0.0','13006'),(149,'40','metal  magnets',60,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11043'),(150,'40','metal rosary',200,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','16002'),(151,'40','photo Stand',50,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','10128'),(152,'10','scapier M',150,0,'15.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11049'),(153,'200','sli candle stand',200,0,'1.0','None','0.0','0.0','0.0','0.0','0.0','0.0','11046');
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'branded foods',850),(2,'Spritual Item',5290),(3,'beverages',835),(4,'branded foods',1020),(5,'dals pulses',500),(6,'fruits and vegetables',542),(7,'household',828),(8,'masalas and spices',11),(9,'rice whole grains',280),(10,'Spritual Item',5290),(11,'beverages',835),(12,'branded foods',1020),(13,'dals pulses',500),(14,'fruits and vegetables',542),(15,'household',828),(16,'masalas and spices',11),(17,'rice whole grains',280),(18,'Spritual Item',2370),(19,'None',6450),(20,'Rosary',1040),(21,'Spritual Item',4170),(22,'None',6450),(23,'Rosary',1090),(24,'Spritual Item',4250),(25,'None',6870),(26,'Rosary',1380),(27,'Spritual Item',4290),(28,'None',7100),(29,'Rosary',1770),(30,'Spritual Item',4470),(31,'None',8050),(32,'Rosary',1810),(33,'Spritual Item',4540),(34,'None',12050),(35,'Rosary',2130),(36,'Spritual Item',4580),(37,'None',13600),(38,'Rosary',2180),(39,'Spritual Item',4600),(58,'None',23460),(59,'Rosary',2850),(60,'Spritual Item',4650),(61,'None',23460),(62,'Rosary',2940),(63,'Spritual Item',4650),(64,'None',24060),(65,'Rosary',3330),(66,'Spritual Item',4720),(67,'Statues',500),(68,'None',27730),(69,'Rosary',3900),(70,'Spritual Item',4880),(71,'Statues',1000),(72,'None',1510),(73,'Rosary',1030),(74,'Spritual Item',20),(75,'None',400),(76,'Rosary',300),(77,'Spritual Item',725),(78,'None',1140),(79,'Rosary',750),(80,'Spritual Item',2225),(81,'Statues',1600),(82,'None',4260),(83,'Rosary',900),(84,'Spritual Item',4095),(85,'Statues',1600),(86,'None',8580),(87,'Rosary',990),(88,'Spritual Item',5120),(89,'Statues',1850),(90,'None',8680),(91,'Rosary',990),(92,'Spritual Item',5720),(93,'Statues',1850),(94,'None',9220),(95,'Rosary',1080),(96,'Spritual Item',5730),(97,'Statues',2250),(98,'None',9220),(99,'Rosary',1080),(100,'Spritual Item',6070),(101,'Statues',2250),(102,'None',300),(103,'Spritual Item',340),(104,'None',800),(105,'Rosary',590),(106,'Spritual Item',1370),(107,'None',800),(108,'Rosary',740),(109,'Spritual Item',1675),(116,'None',800),(117,'Rosary',740),(118,'Spritual Item',1675),(119,'None',1450),(120,'Rosary',550),(121,'Spritual Item',785),(122,'Statues',3220),(123,'None',1450),(124,'Rosary',550),(125,'Spritual Item',1135),(126,'Statues',3220),(127,'None',1750),(128,'Rosary',550),(129,'Spritual Item',1460),(130,'Statues',3220),(131,'None',1750),(132,'Rosary',550),(133,'Spritual Item',1610),(134,'Statues',3220),(135,'None',1750),(136,'Rosary',550),(137,'Spritual Item',1660),(138,'Statues',3220),(139,'None',1790),(140,'Rosary',550),(141,'Spritual Item',1660),(142,'Statues',3220),(147,'None',1790),(148,'Rosary',550),(149,'Spritual Item',1895),(150,'Statues',3220),(151,'None',1790),(152,'Rosary',550),(153,'Spritual Item',1995),(154,'Statues',3220),(155,'None',1790),(156,'Rosary',600),(157,'Spritual Item',1995),(158,'Statues',3220),(159,'Rosary',50),(160,'Spritual Item',40),(161,'None',850),(162,'Rosary',50),(163,'Spritual Item',280),(164,'None',850),(165,'Rosary',50),(166,'Spritual Item',290),(167,'None',850),(168,'Rosary',50),(169,'Spritual Item',490),(170,'None',870),(171,'Rosary',100),(172,'Spritual Item',610),(173,'None',870),(174,'Rosary',100),(175,'Spritual Item',660),(176,'None',870),(177,'Rosary',100),(178,'Spritual Item',730),(179,'None',1420),(180,'Rosary',300),(181,'Spritual Item',1020),(182,'None',1450),(183,'Rosary',300),(184,'Spritual Item',1020),(185,'None',1450),(186,'Rosary',300),(187,'Spritual Item',1050),(188,'Spritual Item',200),(189,'None',920),(190,'Rosary',350),(191,'Spritual Item',1320),(198,'None',940),(199,'Rosary',500),(200,'Spritual Item',1320),(214,'None',34880),(215,'Rosary',7560),(216,'Spritual Item',5690),(217,'Statues',2800),(256,'None',940),(257,'Rosary',500),(258,'Spritual Item',1665),(259,'None',360),(260,'Rosary',130),(261,'Spritual Item',75),(262,'None',440),(263,'Rosary',130),(264,'Spritual Item',75),(265,'None',1160),(266,'Rosary',370),(267,'Spritual Item',85),(268,'None',1160),(269,'Rosary',370),(270,'Spritual Item',85),(271,'None',1610),(272,'Rosary',420),(273,'Spritual Item',85),(274,'None',1670),(275,'Rosary',420),(276,'Spritual Item',85),(277,'None',34880),(278,'Rosary',7210),(279,'Spritual Item',4995),(280,'Statues',2800),(281,'None',4120),(282,'Rosary',2170),(283,'Spritual Item',455),(288,'None',7320),(289,'Rosary',2910),(290,'Spritual Item',1295),(291,'Statues',1150),(292,'None',7510),(293,'Rosary',2910),(294,'Spritual Item',1295),(295,'Statues',1150),(320,'None',9615),(321,'Rosary',3360),(322,'Spritual Item',1640),(323,'Statues',1650),(332,'None',380),(333,'Rosary',380),(334,'Spritual Item',150),(335,'Statues',250),(340,'None',380),(341,'Rosary',380),(342,'Spritual Item',150),(343,'Statues',250),(344,'None',50),(345,'None',1510),(346,'Rosary',910),(347,'Spritual Item',1950),(348,'Statues',500),(349,'None',1510),(350,'Rosary',910),(351,'Spritual Item',2050),(352,'Statues',500),(353,'None',1510),(354,'Rosary',910),(355,'Spritual Item',2050),(356,'Statues',500),(363,'None',1980),(364,'Rosary',540),(365,'Spritual Item',705),(366,'None',1980),(367,'Rosary',540),(368,'Spritual Item',705),(369,'None',2070),(370,'Rosary',540),(371,'Spritual Item',755),(372,'None',2470),(373,'Rosary',540),(374,'Spritual Item',1005),(375,'None',2530),(376,'Rosary',620),(377,'Spritual Item',1065),(378,'None',2530),(379,'Rosary',670),(380,'Spritual Item',1415),(384,'None',2530),(385,'Rosary',670),(386,'Spritual Item',1425),(387,'Spritual Item',230),(388,'Spritual Item',230),(390,'None',2530),(391,'Rosary',670),(392,'Spritual Item',1425),(395,'None',2530),(396,'Rosary',670),(397,'Spritual Item',1425),(398,'None',80),(399,'Spritual Item',430),(400,'None',80),(401,'Spritual Item',680),(402,'None',80),(403,'Spritual Item',1010),(404,'None',1090),(405,'Rosary',100),(406,'Spritual Item',1285),(407,'None',1090),(408,'Rosary',100),(409,'Spritual Item',1335),(410,'None',1090),(411,'Rosary',150),(412,'Spritual Item',1345),(413,'None',2750),(414,'Rosary',2190),(415,'Spritual Item',40),(416,'None',5315),(417,'Rosary',3330),(418,'Spritual Item',40),(419,'Statues',250),(428,'None',5945),(429,'Rosary',3420),(430,'Spritual Item',90),(431,'Statues',250),(432,'None',5945),(433,'Rosary',3520),(434,'Spritual Item',90),(435,'Statues',250),(436,'None',5945),(437,'Rosary',3600),(438,'Spritual Item',90),(439,'Statues',250),(444,'None',6075),(445,'Rosary',3650),(446,'Spritual Item',90),(447,'Statues',250),(448,'None',6115),(449,'Rosary',3650),(450,'Spritual Item',90),(451,'Statues',250),(452,'None',7415),(453,'Rosary',3650),(454,'Spritual Item',90),(455,'Statues',250),(456,'None',7415),(457,'Rosary',3650),(458,'Spritual Item',90),(459,'Statues',250),(460,'None',7415),(461,'Rosary',3850),(462,'Spritual Item',90),(463,'Statues',250),(464,'None',9415),(465,'Rosary',3850),(466,'Spritual Item',90),(467,'Statues',250),(468,'None',9475),(469,'Rosary',3950),(470,'Spritual Item',90),(471,'Statues',250),(472,'None',9725),(473,'Rosary',3950),(474,'Spritual Item',90),(475,'Statues',250),(476,'None',9765),(477,'Rosary',4000),(478,'Spritual Item',90),(479,'Statues',250),(480,'None',9775),(481,'Rosary',4000),(482,'Spritual Item',90),(483,'Statues',250),(484,'None',10045),(485,'Rosary',4100),(486,'Spritual Item',90),(487,'Statues',250),(488,'None',10055),(489,'Rosary',4100),(490,'Spritual Item',90),(491,'Statues',250),(492,'None',12555),(493,'Rosary',4100),(494,'Spritual Item',90),(495,'Statues',250),(500,'None',17185),(501,'Rosary',5100),(502,'Spritual Item',120),(503,'Statues',250),(504,'None',16385),(505,'Rosary',5100),(506,'Spritual Item',120),(507,'Statues',250),(508,'None',16125),(509,'Rosary',5180),(510,'Spritual Item',140),(511,'Statues',250),(512,'None',16125),(513,'Rosary',5280),(514,'Spritual Item',140),(515,'Statues',250),(516,'None',17355),(517,'Photo Frames',300),(518,'Rosary',5770),(519,'Spritual Item',140),(520,'Statues',250),(521,'None',17485),(522,'Photo Frames',300),(523,'Rosary',5870),(524,'Spritual Item',140),(525,'Statues',250),(526,'None',17485),(527,'Photo Frames',300),(528,'Rosary',5920),(529,'Spritual Item',140),(530,'Statues',250),(531,'None',17615),(532,'Photo Frames',300),(533,'Rosary',5920),(534,'Spritual Item',140),(535,'Statues',250),(541,'None',17615),(542,'Photo Frames',300),(543,'Rosary',5920),(544,'Spritual Item',140),(545,'Statues',250),(546,'None',17945),(547,'Photo Frames',300),(548,'Rosary',6000),(549,'Spritual Item',140),(550,'Statues',250),(551,'None',17965),(552,'Photo Frames',300),(553,'Rosary',6000),(554,'Spritual Item',140),(555,'Statues',250),(556,'None',17965),(557,'Photo Frames',300),(558,'Rosary',6030),(559,'Spritual Item',140),(560,'Statues',250),(561,'None',18915),(562,'Photo Frames',300),(563,'Rosary',6030),(564,'Spritual Item',140),(565,'Statues',250),(566,'None',18915),(567,'Photo Frames',300),(568,'Rosary',6080),(569,'Spritual Item',140),(570,'Statues',250),(571,'None',19235),(572,'Photo Frames',300),(573,'Rosary',6080),(574,'Spritual Item',140),(575,'Statues',250),(576,'None',20135),(577,'Photo Frames',300),(578,'Rosary',6080),(579,'Spritual Item',140),(580,'Statues',250),(581,'None',19835),(582,'Photo Frames',300),(583,'Rosary',6080),(584,'Spritual Item',140),(585,'Statues',250),(586,'None',20015),(587,'Photo Frames',300),(588,'Rosary',6080),(589,'Spritual Item',140),(590,'Statues',250),(591,'None',20015),(592,'Photo Frames',300),(593,'Rosary',6080),(594,'Spritual Item',140),(595,'Statues',250),(596,'None',20265),(597,'Photo Frames',300),(598,'Rosary',6170),(599,'Spritual Item',140),(600,'Statues',250),(601,'None',20285),(602,'Photo Frames',300),(603,'Rosary',6170),(604,'Spritual Item',140),(605,'Statues',250),(606,'None',20285),(607,'Photo Frames',300),(608,'Rosary',6170),(609,'Spritual Item',140),(610,'Statues',250),(611,'None',20285),(612,'Photo Frames',300),(613,'Rosary',6170),(614,'Spritual Item',140),(615,'Statues',250),(616,'None',650),(617,'Rosary',340),(618,'None',1230),(619,'Rosary',480),(620,'Spritual Item',10),(621,'Statues',500),(626,'None',1280),(627,'Rosary',600),(628,'Spritual Item',40),(629,'Statues',500),(634,'None',3230),(635,'Rosary',1340),(636,'Spritual Item',30),(637,'Statues',500),(638,'None',3240),(639,'Rosary',1340),(640,'Spritual Item',30),(641,'Statues',500),(642,'None',3300),(643,'Rosary',1340),(644,'Spritual Item',30),(645,'Statues',500),(646,'None',3300),(647,'Rosary',1440),(648,'Spritual Item',30),(649,'Statues',500),(650,'None',3470),(651,'Rosary',1960),(652,'Spritual Item',30),(653,'Statues',500),(654,'None',3640),(655,'Rosary',2010),(656,'Spritual Item',30),(657,'Statues',500),(666,'None',3640),(667,'Rosary',2010),(668,'Spritual Item',30),(669,'Statues',500),(670,'None',3640),(671,'Rosary',2410),(672,'Spritual Item',30),(673,'Statues',500),(674,'None',3640),(675,'Rosary',2590),(676,'Spritual Item',30),(677,'Statues',500),(692,'None',2530),(693,'Rosary',670),(694,'Spritual Item',1425),(715,'None',590),(716,'Rosary',630),(717,'Spritual Item',20),(722,'None',840),(723,'Rosary',630),(724,'Spritual Item',20),(729,'None',4920),(730,'Rosary',2640),(731,'Spritual Item',50),(732,'Statues',500),(741,'None',1320),(742,'Rosary',630),(743,'Spritual Item',20),(744,'None',5480),(745,'Rosary',2640),(746,'Spritual Item',50),(747,'Statues',500),(748,'None',5630),(749,'Rosary',2680),(750,'Spritual Item',50),(751,'Statues',500),(752,'None',6130),(753,'Rosary',2680),(754,'Spritual Item',50),(755,'Statues',500),(756,'None',6320),(757,'Rosary',2680),(758,'Spritual Item',50),(759,'Statues',500),(764,'None',3480),(765,'Rosary',730),(766,'Spritual Item',20),(767,'None',7120),(768,'Rosary',2740),(769,'Spritual Item',50),(770,'Statues',500),(776,'None',6470),(777,'Photo Frames',300),(778,'Rosary',1190),(779,'Spritual Item',50),(780,'None',10440),(781,'Photo Frames',600),(782,'Rosary',3200),(783,'Spritual Item',80),(784,'Statues',500),(799,'None',7700),(800,'Photo Frames',600),(801,'Rosary',1330),(802,'Spritual Item',50),(808,'None',7740),(809,'Photo Frames',600),(810,'Rosary',1330),(811,'Spritual Item',50),(817,'None',7800),(818,'Photo Frames',600),(819,'Rosary',1330),(820,'Spritual Item',50),(826,'None',7860),(827,'Photo Frames',600),(828,'Rosary',1480),(829,'Spritual Item',50),(835,'None',7870),(836,'Photo Frames',600),(837,'Rosary',1820),(838,'Spritual Item',50),(839,'None',11780),(840,'Photo Frames',600),(841,'Rosary',3830),(842,'Spritual Item',80),(843,'Statues',500),(849,'None',16520),(850,'Photo Frames',600),(851,'Rosary',3950),(852,'Spritual Item',80),(853,'Statues',770),(854,'None',16870),(855,'Photo Frames',600),(856,'Rosary',3950),(857,'Spritual Item',80),(858,'Statues',770),(859,'None',17270),(860,'Photo Frames',600),(861,'Rosary',3950),(862,'Spritual Item',80),(863,'Statues',770),(864,'None',19290),(865,'Photo Frames',600),(866,'Rosary',3950),(867,'Spritual Item',80),(868,'Statues',770),(874,'None',15680),(875,'Photo Frames',600),(876,'Rosary',2020),(877,'Spritual Item',50),(878,'Statues',270),(879,'None',19320),(880,'Photo Frames',600),(881,'Rosary',4100),(882,'Spritual Item',80),(883,'Statues',770),(884,'None',19320),(885,'Photo Frames',600),(886,'Rosary',4100),(887,'Spritual Item',80),(888,'Statues',770),(889,'None',19320),(890,'Photo Frames',600),(891,'Rosary',4300),(892,'Spritual Item',80),(893,'Statues',770),(894,'None',19360),(895,'Photo Frames',600),(896,'Rosary',4400),(897,'Spritual Item',80),(898,'Statues',770),(904,'None',15920),(905,'Photo Frames',600),(906,'Rosary',2490),(907,'Spritual Item',50),(908,'Statues',270),(909,'None',15920),(910,'Photo Frames',600),(911,'Rosary',2490),(912,'Spritual Item',50),(913,'Statues',270),(914,'None',19880),(915,'Photo Frames',600),(916,'Rosary',4500),(917,'Spritual Item',80),(918,'Statues',770),(934,'None',23925),(935,'Photo Frames',300),(936,'Rosary',8150),(937,'Spritual Item',170),(938,'Statues',750),(939,'None',16240),(940,'Photo Frames',600),(941,'Rosary',2490),(942,'Spritual Item',60),(943,'Statues',270),(949,'None',16770),(950,'Photo Frames',600),(951,'Rosary',2490),(952,'Spritual Item',60),(953,'Statues',270),(959,'None',17090),(960,'Photo Frames',600),(961,'Rosary',2490),(962,'Spritual Item',60),(963,'Statues',570),(969,'None',17090),(970,'Photo Frames',600),(971,'Rosary',2490),(972,'Spritual Item',60),(973,'Statues',570),(974,'None',620),(975,'Rosary',150),(976,'None',620),(977,'Rosary',480),(994,'None',17090),(995,'Photo Frames',600),(996,'Rosary',2490),(997,'Spritual Item',60),(998,'Statues',570),(1001,'None',17090),(1002,'Photo Frames',600),(1003,'Rosary',2490),(1004,'Spritual Item',60),(1005,'Statues',570),(1010,'None',17090),(1011,'Photo Frames',600),(1012,'Rosary',2490),(1013,'Spritual Item',60),(1014,'Statues',570),(1018,'None',17090),(1019,'Photo Frames',600),(1020,'Rosary',2490),(1021,'Spritual Item',60),(1022,'Statues',570),(1023,'None',3360),(1024,'Rosary',3230),(1025,'Spritual Item',10),(1026,'None',4770),(1027,'Rosary',3370),(1028,'Spritual Item',10),(1029,'Statues',2950),(1034,'None',4790),(1035,'Rosary',3610),(1036,'Spritual Item',10),(1037,'Statues',2950),(1038,'None',6050),(1039,'Rosary',4140),(1040,'Spritual Item',10),(1041,'Statues',2950),(1042,'None',6340),(1043,'Rosary',4490),(1044,'Spritual Item',10),(1045,'Statues',2950),(1050,'None',6525),(1051,'Rosary',4650),(1052,'Spritual Item',30),(1053,'Statues',2950),(1054,'None',7025),(1055,'Rosary',4650),(1056,'Spritual Item',30),(1057,'Statues',2950),(1058,'None',7505),(1059,'Rosary',4650),(1060,'Spritual Item',30),(1061,'Statues',2950),(1062,'None',7625),(1063,'Rosary',4650),(1064,'Spritual Item',30),(1065,'Statues',2950),(1066,'None',8075),(1067,'Rosary',4650),(1068,'Spritual Item',30),(1069,'Statues',2950),(1070,'None',8115),(1071,'Rosary',4880),(1072,'Spritual Item',30),(1073,'Statues',2950),(1074,'None',8365),(1075,'Rosary',4980),(1076,'Spritual Item',30),(1077,'Statues',2950),(1078,'None',9495),(1079,'Rosary',5080),(1080,'Spritual Item',30),(1081,'Statues',2950),(1082,'None',9495),(1083,'Rosary',5380),(1084,'Spritual Item',30),(1085,'Statues',2950),(1086,'None',10055),(1087,'Rosary',5380),(1088,'Spritual Item',30),(1089,'Statues',3200),(1094,'None',12095),(1095,'Rosary',5500),(1096,'Spritual Item',50),(1097,'Statues',3200),(1098,'None',12095),(1099,'Rosary',5500),(1100,'Spritual Item',50),(1101,'Statues',3200),(1102,'None',12215),(1103,'Rosary',5500),(1104,'Spritual Item',50),(1105,'Statues',3200),(1110,'None',12215),(1111,'Rosary',5530),(1112,'Spritual Item',50),(1113,'Statues',3200),(1114,'None',11715),(1115,'Rosary',5530),(1116,'Spritual Item',50),(1117,'Statues',2950),(1122,'None',11715),(1123,'Rosary',5330),(1124,'Spritual Item',50),(1125,'Statues',2950),(1126,'None',11715),(1127,'Rosary',4930),(1128,'Spritual Item',50),(1129,'Statues',2950),(1132,'None',11715),(1133,'Rosary',4930),(1134,'Spritual Item',50),(1135,'Statues',2950),(1136,'None',310),(1137,'Rosary',230),(1140,'None',11715),(1141,'Rosary',4930),(1142,'Spritual Item',50),(1143,'Statues',2950),(1160,'None',11715),(1161,'Rosary',4930),(1162,'Spritual Item',50),(1163,'Statues',2950),(1172,'None',2080),(1173,'Rosary',730),(1174,'Spritual Item',130),(1175,'Statues',850),(1176,'None',2140),(1177,'Rosary',820),(1178,'Spritual Item',140),(1179,'Statues',850),(1180,'None',2160),(1181,'Rosary',820),(1182,'Spritual Item',85),(1183,'Statues',850),(1188,'None',120805),(1189,'Photo Frames',900),(1190,'Rosary',39090),(1191,'Spritual Item',25130),(1192,'Statues',16290),(1193,'None',2410),(1194,'Rosary',850),(1195,'Spritual Item',85),(1196,'Statues',850),(1197,'None',2910),(1198,'Rosary',850),(1199,'Spritual Item',85),(1200,'Statues',850),(1205,'None',2910),(1206,'Rosary',850),(1207,'Spritual Item',80),(1208,'Statues',850),(1209,'None',2910),(1210,'Rosary',850),(1211,'Spritual Item',80),(1212,'Statues',850),(1213,'None',2940),(1214,'Rosary',850),(1215,'Spritual Item',80),(1216,'Statues',850),(1217,'None',3180),(1218,'Rosary',900),(1219,'Spritual Item',80),(1220,'Statues',850),(1233,'None',3520),(1234,'Rosary',1780),(1235,'Spritual Item',80),(1236,'Statues',850),(1237,'None',3180),(1238,'Rosary',900),(1239,'Spritual Item',80),(1240,'Statues',850),(1241,'None',840),(1242,'Rosary',280),(1243,'None',122885),(1244,'Photo Frames',900),(1245,'Rosary',40300),(1246,'Spritual Item',25125),(1247,'Statues',16290),(1250,'None',1050),(1251,'Rosary',530),(1252,'None',3720),(1253,'Rosary',570),(1254,'Spritual Item',10),(1255,'None',3870),(1256,'Rosary',710),(1257,'Spritual Item',10),(1258,'None',3990),(1259,'Rosary',710),(1260,'Spritual Item',10),(1264,'None',3990),(1265,'Rosary',710),(1266,'Spritual Item',10),(1273,'None',4830),(1274,'Rosary',1040),(1275,'Spritual Item',10),(1276,'None',3600),(1277,'Rosary',70),(1282,'None',3650),(1283,'Rosary',110),(1284,'None',3760),(1285,'Rosary',180),(1286,'Statues',500),(1293,'None',3760),(1294,'Rosary',180),(1295,'Statues',500),(1296,'None',3610),(1297,'Rosary',180),(1298,'Statues',500),(1299,'None',3640),(1300,'Rosary',280),(1301,'Statues',500),(1302,'None',4490),(1303,'Rosary',280),(1304,'Statues',500),(1305,'None',4490),(1306,'Rosary',370),(1307,'Statues',500),(1308,'None',5000),(1309,'Rosary',370),(1310,'Statues',500),(1311,'None',5750),(1312,'Rosary',370),(1313,'Statues',500),(1314,'None',60),(1315,'Rosary',980),(1318,'None',390),(1319,'Rosary',1280),(1320,'None',390),(1321,'Rosary',1280),(1322,'None',1550),(1323,'Rosary',1380),(1328,'None',1550),(1329,'Rosary',1380),(1330,'Rosary',100),(1334,'None',1810),(1335,'Rosary',1770),(1346,'None',5750),(1347,'Rosary',370),(1348,'Statues',500),(1349,'None',1810),(1350,'Rosary',1770),(1357,'None',1560),(1358,'Rosary',1090),(1359,'None',1560),(1360,'Rosary',1090),(1363,'None',1810),(1364,'Rosary',1770),(1365,'None',1620),(1366,'Rosary',1090),(1369,'None',1920),(1370,'Rosary',1090),(1371,'None',1960),(1372,'Rosary',1390),(1373,'None',210),(1374,'Rosary',150),(1375,'None',3840),(1376,'Rosary',1540),(1377,'None',1850),(1378,'Rosary',230),(1379,'None',6260),(1380,'Rosary',600),(1381,'Statues',300),(1382,'None',6300),(1383,'Rosary',600),(1384,'Statues',300),(1385,'None',8030),(1386,'Rosary',650),(1387,'Spritual Item',50),(1388,'Statues',550),(1389,'None',8790),(1390,'Rosary',650),(1391,'Spritual Item',50),(1392,'Statues',550),(1393,'None',350),(1394,'Rosary',360),(1397,'None',10650),(1398,'Rosary',1000),(1399,'Spritual Item',350),(1400,'Statues',550),(1403,'None',10650),(1404,'Rosary',1000),(1405,'Spritual Item',350),(1406,'Statues',550),(1409,'None',10650),(1410,'Rosary',1000),(1411,'Spritual Item',350),(1412,'Statues',550),(1425,'None',1860),(1426,'Rosary',350),(1427,'Spritual Item',300),(1428,'None',6220),(1429,'Rosary',2070),(1430,'Statues',250),(1435,'None',6960),(1436,'Rosary',2820),(1437,'Spritual Item',20),(1438,'Statues',250),(1439,'None',11945),(1440,'Rosary',2920),(1441,'Spritual Item',30),(1442,'Statues',250),(1443,'None',12195),(1444,'Rosary',3100),(1445,'Spritual Item',30),(1446,'Statues',250),(1447,'None',13015),(1448,'Rosary',3290),(1449,'Spritual Item',60),(1450,'Statues',250),(1451,'None',13365),(1452,'Rosary',3290),(1453,'Spritual Item',60),(1454,'Statues',250),(1455,'None',13455),(1456,'Rosary',3510),(1457,'Spritual Item',60),(1458,'Statues',250),(1459,'None',14095),(1460,'Rosary',3940),(1461,'Spritual Item',60),(1462,'Statues',250),(1463,'None',1160),(1464,'Rosary',390),(1465,'None',1160),(1466,'Rosary',470),(1467,'None',1570),(1468,'Rosary',1220),(1475,'None',1980),(1476,'Rosary',1520),(1477,'None',1980),(1478,'Rosary',1520),(1479,'None',2140),(1480,'Rosary',1800),(1489,'None',70),(1490,'Rosary',150),(1495,'None',2140),(1496,'Rosary',1800),(1497,'None',1155),(1498,'Rosary',900),(1501,'None',2140),(1502,'Rosary',1800),(1503,'None',1195),(1504,'Rosary',900),(1505,'None',1195),(1506,'Rosary',900),(1507,'None',1520),(1508,'Rosary',360),(1509,'Statues',770),(1510,'None',2520),(1511,'Rosary',600),(1512,'Statues',1520),(1513,'None',4360),(1514,'Rosary',850),(1515,'Statues',1520),(1516,'None',5030),(1517,'Rosary',850),(1518,'Statues',1520),(1528,'None',5840),(1529,'Rosary',1100),(1530,'Statues',1520),(1531,'None',730),(1536,'None',6750),(1537,'Rosary',1150),(1538,'Statues',1520),(1539,'None',730),(1540,'Rosary',300),(1541,'Spritual Item',50),(1542,'None',1120),(1543,'Rosary',420),(1544,'Spritual Item',50),(1545,'None',1180),(1546,'Rosary',460),(1547,'Spritual Item',50),(1548,'None',2120),(1549,'Rosary',560),(1550,'Spritual Item',50),(1551,'Statues',250),(1556,'None',2370),(1557,'Rosary',560),(1558,'Spritual Item',50),(1559,'Statues',250),(1564,'None',2400),(1565,'Rosary',560),(1566,'Spritual Item',50),(1567,'Statues',250),(1568,'None',60),(1569,'Rosary',1760),(1570,'None',430),(1571,'Rosary',2190),(1572,'None',480),(1573,'Rosary',2190),(1582,'None',1850),(1583,'Rosary',2420),(1584,'None',2450),(1585,'Rosary',2420),(1586,'None',2100),(1587,'Rosary',850),(1588,'Spritual Item',110),(1592,'None',2450),(1593,'Rosary',2440),(1594,'None',3650),(1595,'Rosary',1200),(1596,'Spritual Item',140),(1597,'None',3670),(1598,'Rosary',1210),(1599,'Spritual Item',140),(1600,'None',3730),(1601,'Rosary',1210),(1602,'Spritual Item',140),(1603,'None',3840),(1604,'Rosary',1210),(1605,'Spritual Item',140),(1621,'None',2450),(1622,'Rosary',2440),(1628,'None',3940),(1629,'Rosary',1210),(1630,'Spritual Item',140),(1631,'None',4060),(1632,'Rosary',1210),(1633,'Spritual Item',140),(1634,'None',4650),(1635,'Rosary',1210),(1636,'Spritual Item',140),(1637,'None',4690),(1638,'Rosary',1210),(1639,'Spritual Item',140),(1640,'None',4760),(1641,'Rosary',1210),(1642,'Spritual Item',140),(1643,'None',3590),(1644,'Rosary',940),(1645,'Spritual Item',50),(1646,'Statues',250),(1647,'None',4800),(1648,'Rosary',1260),(1649,'Spritual Item',140),(1653,'None',2450),(1654,'Rosary',2440),(1655,'None',5010),(1656,'Rosary',1450),(1657,'Spritual Item',140),(1658,'None',5030),(1659,'Rosary',1450),(1660,'Spritual Item',140),(1661,'None',6600),(1662,'Rosary',3200),(1663,'Spritual Item',130),(1667,'None',6680),(1668,'Rosary',2130),(1669,'Spritual Item',140),(1670,'Statues',270),(1671,'None',9330),(1672,'Rosary',3640),(1673,'Spritual Item',140),(1674,'Statues',500),(1675,'None',9520),(1676,'Rosary',3690),(1677,'Spritual Item',140),(1678,'Statues',500),(1679,'None',16615),(1680,'Rosary',4640),(1681,'Spritual Item',200),(1682,'Statues',1020),(1683,'None',16785),(1684,'Rosary',4640),(1685,'Spritual Item',200),(1686,'Statues',1020),(1687,'None',29215),(1688,'Rosary',5610),(1689,'Spritual Item',270),(1690,'Statues',1270),(1691,'None',29935),(1692,'Rosary',5610),(1693,'Spritual Item',290),(1694,'Statues',1270),(1695,'None',29935),(1696,'Rosary',5610),(1697,'Spritual Item',340),(1698,'Statues',1270),(1699,'None',41895),(1700,'Rosary',6540),(1701,'Spritual Item',530),(1702,'Statues',1270),(1707,'None',41985),(1708,'Rosary',6690),(1709,'Spritual Item',610),(1710,'Statues',1270),(1711,'None',42835),(1712,'Rosary',6770),(1713,'Spritual Item',620),(1714,'Statues',1270),(1715,'None',43735),(1716,'Rosary',7020),(1717,'Spritual Item',710),(1718,'Statues',1270),(1719,'None',44625),(1720,'Rosary',7200),(1721,'Spritual Item',740),(1722,'Statues',1270),(1723,'None',44925),(1724,'Rosary',7370),(1725,'Spritual Item',740),(1726,'Statues',1270),(1727,'None',45265),(1728,'Rosary',7620),(1729,'Spritual Item',740),(1730,'Statues',1270),(1731,'None',45445),(1732,'Rosary',7650),(1733,'Spritual Item',740),(1734,'Statues',1270),(1735,'None',46185),(1736,'Rosary',7700),(1737,'Spritual Item',740),(1738,'Statues',1270),(1739,'None',52475),(1740,'Rosary',8390),(1741,'Spritual Item',790),(1742,'Statues',1270),(1743,'None',57135),(1744,'Rosary',9370),(1745,'Spritual Item',790),(1746,'Statues',1270),(1747,'None',57455),(1748,'Rosary',9370),(1749,'Spritual Item',790),(1750,'Statues',1270),(1751,'None',61500),(1752,'Rosary',9910),(1753,'Spritual Item',860),(1754,'Statues',1270),(1755,'None',61500),(1756,'Rosary',10110),(1757,'Spritual Item',860),(1758,'Statues',1270),(1764,'None',61700),(1765,'Photo Frames',150),(1766,'Rosary',10130),(1767,'Spritual Item',860),(1768,'Statues',1270),(1769,'None',65400),(1770,'Photo Frames',150),(1771,'Rosary',10310),(1772,'Spritual Item',880),(1773,'Statues',1270),(1774,'None',66240),(1775,'Photo Frames',150),(1776,'Rosary',10450),(1777,'Spritual Item',880),(1778,'Statues',1270),(1779,'None',67280),(1780,'Photo Frames',150),(1781,'Rosary',10450),(1782,'Spritual Item',890),(1783,'Statues',1270),(1784,'None',67530),(1785,'Photo Frames',150),(1786,'Rosary',10450),(1787,'Spritual Item',890),(1788,'Statues',1270),(1789,'None',67700),(1790,'Photo Frames',150),(1791,'Rosary',10450),(1792,'Spritual Item',900),(1793,'Statues',1270),(1794,'None',67950),(1795,'Photo Frames',150),(1796,'Rosary',10450),(1797,'Spritual Item',900),(1798,'Statues',1270),(1799,'None',68100),(1800,'Photo Frames',150),(1801,'Rosary',10450),(1802,'Spritual Item',900),(1803,'Statues',1270),(1804,'None',69540),(1805,'Photo Frames',150),(1806,'Rosary',10500),(1807,'Spritual Item',900),(1808,'Statues',1270),(1809,'None',70140),(1810,'Photo Frames',150),(1811,'Rosary',10630),(1812,'Spritual Item',990),(1813,'Statues',1520),(1820,'None',4130),(1821,'Rosary',3010),(1822,'Spritual Item',130),(1828,'None',70410),(1829,'Photo Frames',150),(1830,'Rosary',10670),(1831,'Spritual Item',990),(1832,'Statues',1520),(1833,'None',2890),(1834,'Rosary',110),(1835,'None',3540),(1836,'Rosary',470),(1837,'None',4210),(1838,'Rosary',470),(1839,'None',6980),(1840,'Rosary',640),(1841,'None',7700),(1842,'Rosary',840),(1843,'Spritual Item',60),(1844,'None',8710),(1845,'Rosary',960),(1846,'Spritual Item',60),(1847,'None',9620),(1848,'Rosary',1320),(1849,'Spritual Item',60),(1850,'None',11110),(1851,'Rosary',1340),(1852,'Spritual Item',60),(1853,'None',11110),(1854,'Rosary',1550),(1855,'Spritual Item',80),(1856,'None',11290),(1857,'Rosary',1550),(1858,'Spritual Item',80),(1859,'None',11400),(1860,'Rosary',2310),(1861,'Spritual Item',100),(1865,'None',11550),(1866,'Rosary',2310),(1867,'Spritual Item',110),(1868,'None',11650),(1869,'Rosary',2370),(1870,'Spritual Item',110),(1879,'None',11650),(1880,'Rosary',2460),(1881,'Spritual Item',110),(1882,'None',11710),(1883,'Rosary',2460),(1884,'Spritual Item',110),(1888,'None',160),(1889,'Rosary',50),(1893,'None',12260),(1894,'Rosary',3200),(1895,'Spritual Item',110),(1899,'None',82120),(1900,'Photo Frames',150),(1901,'Rosary',13130),(1902,'Spritual Item',1100),(1903,'Statues',1520),(1907,'None',82120),(1908,'Photo Frames',150),(1909,'Rosary',13130),(1910,'Spritual Item',1100),(1911,'Statues',1520),(1923,'None',82120),(1924,'Photo Frames',150),(1925,'Rosary',13130),(1926,'Spritual Item',1100),(1927,'Statues',1520),(1928,'None',380),(1929,'Rosary',340),(1930,'Statues',600),(1931,'None',82120),(1932,'Photo Frames',150),(1933,'Rosary',13130),(1934,'Spritual Item',1100),(1935,'Statues',1520),(1942,'None',82120),(1943,'Photo Frames',150),(1944,'Rosary',13130),(1945,'Spritual Item',1100),(1946,'Statues',1520),(1950,'None',82120),(1951,'Photo Frames',150),(1952,'Rosary',13130),(1953,'Spritual Item',1100),(1954,'Statues',1520),(1961,'None',2180),(1962,'Rosary',1120),(1966,'None',2635),(1967,'Rosary',890),(1968,'Statues',600),(1969,'None',2635),(1970,'Rosary',890),(1971,'Statues',600),(1975,'None',6680),(1976,'Rosary',2130),(1977,'Spritual Item',140),(1978,'Statues',270),(1982,'None',2635),(1983,'Rosary',890),(1984,'Statues',600),(1988,'None',3335),(1989,'Rosary',890),(1990,'Statues',850),(1991,'None',3335),(1992,'Rosary',890),(1993,'Statues',850),(2006,'None',82120),(2007,'Photo Frames',150),(2008,'Rosary',13130),(2009,'Spritual Item',1100),(2010,'Statues',1520),(2011,'None',4385),(2012,'Rosary',890),(2013,'Statues',850),(2014,'None',4675),(2015,'Rosary',1000),(2016,'Statues',850),(2017,'None',4675),(2018,'Rosary',1080),(2019,'Statues',850),(2020,'None',845),(2021,'Rosary',320),(2022,'None',1395),(2023,'Rosary',910),(2024,'None',20),(2025,'None',910),(2026,'Rosary',210),(2027,'None',1540),(2028,'Rosary',1870),(2031,'None',1660),(2032,'Rosary',1870),(2033,'None',1680),(2034,'Rosary',1870);
INSERT INTO `top_reason` (`_id`, `reason`, `value`) VALUES (5,'Accidental charge',1),(6,'Changed mind',2),(37,'Accidental charge',1),(38,'Changed mind',4),(40,'Changed mind',1),(41,'Changed mind',2),(42,'Changed mind',3),(43,'Changed mind',3),(44,'Changed mind',3),(45,'Changed mind',3),(46,'Changed mind',3),(47,'Changed mind',3),(49,'Changed mind',3),(50,'Changed mind',3),(51,'Changed mind',3),(52,'Changed mind',3),(53,'Changed mind',3),(54,'Changed mind',3),(55,'Changed mind',3),(56,'Changed mind',3),(57,'Changed mind',4),(58,'Changed mind',4),(59,'Changed mind',4),(60,'Changed mind',4),(61,'Changed mind',4),(62,'Changed mind',4),(63,'Changed mind',4),(65,'Changed mind',1),(66,'Changed mind',1),(67,'Changed mind',1),(68,'Changed mind',1),(69,'Changed mind',1),(70,'Changed mind',1),(73,'Changed mind',1),(74,'Changed mind',1),(75,'Changed mind',1),(84,'Changed mind',1),(87,'Changed mind',1),(88,'Changed mind',1),(89,'Changed mind',1),(90,'Changed mind',1),(92,'Changed mind',1),(94,'Changed mind',1),(101,'Changed mind',1),(103,'Changed mind',1),(104,'Changed mind',1),(105,'Changed mind',1),(106,'Changed mind',1),(108,'Changed mind',1),(109,'Changed mind',2),(110,'Changed mind',2),(111,'Changed mind',2),(113,'Changed mind',1),(114,'Changed mind',1),(115,'Changed mind',2),(119,'Changed mind',5),(120,'Changed mind',1),(122,'Changed mind',1),(124,'Changed mind',1),(126,'Changed mind',1),(129,'Changed mind',1),(130,'Changed mind',1),(131,'Changed mind',1),(132,'Changed mind',1),(134,'Changed mind',1),(135,'Changed mind',1),(136,'Changed mind',1),(138,'Changed mind',1),(139,'Changed mind',2),(141,'Changed mind',3),(142,'Changed mind',4),(144,'Changed mind',4),(145,'Changed mind',1),(147,'Changed mind',4),(153,'Changed mind',4),(156,'Changed mind',1),(157,'Changed mind',1),(158,'Changed mind',2),(160,'Accidental charge',1),(161,'Changed mind',19),(162,'Changed mind',2),(163,'Changed mind',2),(165,'Changed mind',3),(166,'Changed mind',3),(167,'Changed mind',3),(168,'Changed mind',3),(173,'Changed mind',3),(174,'Changed mind',3),(175,'Changed mind',2),(176,'Accidental charge',1),(177,'Changed mind',22),(179,'Changed mind',2),(180,'Changed mind',2),(181,'Changed mind',2),(182,'Changed mind',2),(184,'Changed mind',2),(187,'Changed mind',2),(188,'Changed mind',1),(189,'Changed mind',1),(190,'Changed mind',1),(191,'Changed mind',1),(192,'Changed mind',1),(193,'Changed mind',1),(195,'Changed mind',1),(196,'Changed mind',1),(202,'Changed mind',1),(204,'Changed mind',1),(205,'Changed mind',1),(206,'Changed mind',1),(207,'Changed mind',1),(208,'Changed mind',1),(209,'Changed mind',1),(210,'Changed mind',1),(212,'Changed mind',1),(214,'Changed mind',1),(215,'Changed mind',1),(217,'Changed mind',1),(218,'Changed mind',1),(220,'Changed mind',1),(222,'Changed mind',1),(224,'Changed mind',1),(225,'Changed mind',1),(226,'Changed mind',1),(232,'Changed mind',1),(233,'Changed mind',1),(234,'Changed mind',1),(235,'Changed mind',1),(236,'Changed mind',1),(237,'Changed mind',1),(238,'Changed mind',1),(240,'Changed mind',1),(241,'Changed mind',1),(242,'Changed mind',1),(243,'Changed mind',1),(245,'Changed mind',1),(246,'Changed mind',2),(247,'Changed mind',2),(248,'Changed mind',2),(249,'Changed mind',2),(250,'Changed mind',2),(251,'Changed mind',2),(252,'Changed mind',2),(253,'Changed mind',2),(254,'Changed mind',2),(255,'Changed mind',2),(256,'Changed mind',3),(257,'Changed mind',3),(259,'Changed mind',3),(260,'Changed mind',3),(261,'Changed mind',3),(262,'Changed mind',3),(263,'Changed mind',3),(264,'Changed mind',3),(265,'Changed mind',3),(266,'Changed mind',3),(267,'Changed mind',3),(268,'Changed mind',3),(270,'Changed mind',3),(273,'Changed mind',1),(274,'Changed mind',3),(275,'Changed mind',3),(277,'Changed mind',3),(278,'Changed mind',3),(279,'Changed mind',3),(280,'Changed mind',3),(282,'Changed mind',1),(283,'Changed mind',1),(286,'Changed mind',3),(287,'Changed mind',1),(288,'Changed mind',1),(290,'Changed mind',1),(291,'Changed mind',1);
INSERT INTO `usercancelleddata` (`_id`, `username`, `total`) VALUES (1,'ladmin',540);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'ladmin',850);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'ladmin',850,100);
