INSERT INTO `all_sales` (`_id`, `itemname`, `quantity`, `price`, `total`, `type`, `parent`, `parentid`, `mod_assigned`, `tax`, `taxname`, `bill_no`, `time`, `date`, `user`, `table_id`, `billtype`, `paymentmethod`, `billamount_disapply`, `billamount_disnotapply`, `_idd`, `deleted_not`, `modifiedquantity`, `quantitycopy`, `modifiedtotal`, `date1`, `datetimee`, `disc_type`, `disc_value`, `newtotal`, `disc_thereornot`, `disc_indiv_total`, `new_modified_total`, `datetimee_new`, `hsn_code`, `taxname2`, `tax2`, `taxname3`, `tax3`, `taxname4`, `tax4`, `taxname5`, `tax5`, `category`, `counterperson_username`, `counterperson_name`, `credit`, `Phone_num`, `barcode_get`, `order_id`, `old_total`, `hsn_code2`, `hsn_code3`, `hsn_code4`, `hsn_code5`, `item_online`, `old_total_indiv`) VALUES (1,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000011','10:39:21 AM','2024 10 10','admin','1','  General','  Cash','476.00','476.00','4',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:39:21','%','0','56.00','no','0.00',NULL,'202410101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(2,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000011','10:39:21 AM','2024 10 10','admin','1','  General','  Cash','476.00','476.00','5',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:39:21','%','0','250.00','no','0.00',NULL,'202410101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(3,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000011','10:39:21 AM','2024 10 10','admin','1','  General','  Cash','476.00','476.00','6',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:39:21','%','0','170.00','no','0.00',NULL,'202410101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(4,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000012','10:39:49 AM','2024 10 10','admin','1','  General','  Cash','306.00','306.00','7',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:39:49','%','0','56.00','no','0.00',NULL,'202410101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(5,'tata urad dal whole white 1kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000012','10:39:49 AM','2024 10 10','admin','1','  General','  Cash','306.00','306.00','8',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:39:49','%','0','250.00','no','0.00',NULL,'202410101039','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(6,'cucumbers kg','2.0','20.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','9',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','40.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(7,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','10',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','170.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(8,'eggs 6pcs','1.0','38.00','38.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','11',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','38.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'bread bakery and eggs','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(9,'rin powder 6kg','1.0','420.00','420.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','12',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','420.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(10,'rin fabric whitener 500ml','1.0','55.00','55.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','13',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','55.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(11,'robin powder blue 200gm','1.0','46.00','46.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','14',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','46.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'household','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(12,'frooty','1.0','10.00','10.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','15',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','10.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(13,'tata tea agni250gm','1.0','58.00','58.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','16',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','58.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(14,'pepsi 2lt','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','17',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','76.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(15,'maaza 600ml','1.0','31.00','31.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','18',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','31.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(16,'tropicana mixed fruit 1ltr','1.0','94.00','94.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','19',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','94.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(17,'bajaj oil 200ml','1.0','113.00','113.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','20',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','113.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(18,'parachute hair cream 50gm','1.0','38.00','38.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','21',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','38.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(19,'godrej color soft','1.0','147.00','147.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','22',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','147.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(20,'loreal conditioner 180gm','1.0','142.00','142.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','23',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','142.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(21,'dabur  paste 200gm','1.0','84.00','84.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','24',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','84.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(22,'axe deo 150ml','1.0','175.00','175.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','25',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','175.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(23,'pineapple kg','1.0','80.00','80.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','26',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','80.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(24,'muskmelon kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','27',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','45.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(25,'grapes kg','1.0','145.00','145.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','28',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','145.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(26,'apples kg','1.0','202.00','202.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','29',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','202.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(27,'banana yelakki kg','1.0','88.00','88.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','30',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','88.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(28,'tomatoes kg','1.0','25.00','25.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','31',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','25.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(29,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','32',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','20.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(30,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','33',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','32.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(31,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','34',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','28.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(32,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000013','10:46:33 AM','2024 10 10','admin','1','  General','  Cash','2442.00','2442.00','35',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:46:33','%','0','40.00','no','0.00',NULL,'202410101046','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(33,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','36',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','70.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(34,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','37',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','45.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(35,'nutella','1.0','170.00','170.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','38',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','170.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'branded foods','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(36,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','39',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','250.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(37,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','40',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','40.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(38,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','41',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','15.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(39,'ladies finger kg','1.0','28.00','28.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','42',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','28.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(40,'radish white kg','1.0','24.00','24.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','43',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','24.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(41,'onions big kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','44',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','20.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(42,'beet root kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','45',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','32.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(43,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','46',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','76.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(44,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','47',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','20.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(45,'potatoes kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','48',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','32.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(46,'spinach bunch','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','49',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','20.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(47,'cabbage kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000014','10:52:25 AM','2024 10 10','admin','1','  General','  Cash','874.00','874.00','50',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101010:52:25','%','0','32.00','no','0.00',NULL,'202410101052','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(48,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000015','11:24:33 AM','2024 10 10','admin','1','  General','  Cash','191.00','191.00','51',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:24:33','%','0','76.00','no','0.00',NULL,'202410101124','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(49,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000015','11:24:33 AM','2024 10 10','admin','1','  General','  Cash','191.00','191.00','52',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:24:33','%','0','70.00','no','0.00',NULL,'202410101124','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(50,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000015','11:24:33 AM','2024 10 10','admin','1','  General','  Cash','191.00','191.00','53',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:24:33','%','0','45.00','no','0.00',NULL,'202410101124','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(51,'tata tea premium 1 kg','1.0','412.00','412.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','54',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','412.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'beverages','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(52,'urad dal black whole loose kg','1.0','202.00','202.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','55',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','202.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'dals and pulses','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(53,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','56',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','250.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(54,'sweet corn piece','1.0','15.00','15.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','57',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','15.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(55,'potatoes kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','58',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','32.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(56,'spinach bunch','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000016','11:25:18 AM','2024 10 10','admin','1','  General','  Cash','931.00','931.00','59',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:25:18','%','0','20.00','no','0.00',NULL,'202410101125','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(57,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000017','11:35:09 AM','2024 10 10','admin','1','  General','  Cash','358.00','358.00','60',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:09','%','0','56.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(58,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000017','11:35:09 AM','2024 10 10','admin','1','  General','  Cash','358.00','358.00','61',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:09','%','0','250.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(59,'spinach bunch','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000017','11:35:09 AM','2024 10 10','admin','1','  General','  Cash','358.00','358.00','62',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:09','%','0','20.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(60,'potatoes kg','1.0','32.00','32.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000017','11:35:09 AM','2024 10 10','admin','1','  General','  Cash','358.00','358.00','63',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:09','%','0','32.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(61,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000018','11:35:20 AM','2024 10 10','admin','1','  General','  Cash','376.00','376.00','64',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:20','%','0','70.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(62,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000018','11:35:20 AM','2024 10 10','admin','1','  General','  Cash','376.00','376.00','65',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:20','%','0','56.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(63,'fig fruit kg','1.0','250.00','250.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000018','11:35:20 AM','2024 10 10','admin','1','  General','  Cash','376.00','376.00','66',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:35:20','%','0','250.00','no','0.00',NULL,'202410101135','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(64,'carrots kg','1.0','70.00','70.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000019','11:36:05 AM','2024 10 10','admin','1','  General','  Cash','211.00','211.00','67',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:05','%','0','70.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(65,'cauliflower kg','1.0','45.00','45.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000019','11:36:05 AM','2024 10 10','admin','1','  General','  Cash','211.00','211.00','68',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:05','%','0','45.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(66,'beans kg','1.0','40.00','40.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000019','11:36:05 AM','2024 10 10','admin','1','  General','  Cash','211.00','211.00','69',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:05','%','0','40.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(67,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-000019','11:36:05 AM','2024 10 10','admin','1','  General','  Cash','211.00','211.00','70',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:05','%','0','56.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(68,'cucumbers kg','1.0','20.00','20.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-0000110','11:36:31 AM','2024 10 10','admin','1','  General','  Cash','248.00','248.00','71',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:31','%','0','20.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(69,'loreal color 90gms','1.0','76.00','76.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-0000110','11:36:31 AM','2024 10 10','admin','1','  General','  Cash','248.00','248.00','72',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:31','%','0','76.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'personal care','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(70,'beet root kg','3.0','32.00','96.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-0000110','11:36:31 AM','2024 10 10','admin','1','  General','  Cash','248.00','248.00','73',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:31','%','0','96.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'fruits and vegetables','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL),(71,'sona masoori raw rice 1kg','1.0','56.00','56.00','Item',NULL,NULL,'no',NULL,NULL,'20241010-0000110','11:36:31 AM','2024 10 10','admin','1','  General','  Cash','248.00','248.00','74',NULL,NULL,NULL,NULL,'10 Oct 2024','2024101011:36:31','%','0','56.00','no','0.00',NULL,'202410101136','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rice whole grains','admin','madmin',NULL,NULL,'',NULL,NULL,'','','','',NULL,NULL);
INSERT INTO `billcount` (`_id`, `value`) VALUES (1,'0');
INSERT INTO `billnumber` (`_id`, `billnumber`, `total`, `user`, `date`, `paymentmethod`, `billtype`, `subtotal`, `taxtotal`, `roundoff`, `globaltaxtotal`, `billcount`, `datetimee_new`, `comments_sales`, `delivery_fee`, `packing_charges`, `loyalty_points`, `loyalty_amount`, `order_id`) VALUES (1,'20241010-000011','476.00','admin','2024 10 10','  Cash','  General','476.00','0.00','0.00','0.0','1','202410101039',NULL,NULL,NULL,NULL,NULL,NULL),(2,'20241010-000012','306.00','admin','2024 10 10','  Cash','  General','306.00','0.00','0.00','0.0','2','202410101039',NULL,NULL,NULL,NULL,NULL,NULL),(3,'20241010-000013','2442.00','admin','2024 10 10','  Cash','  General','2442.00','0.00','0.00','0.0','3','202410101046',NULL,NULL,NULL,NULL,NULL,NULL),(4,'20241010-000014','874.00','admin','2024 10 10','  Cash','  General','874.00','0.00','0.00','0.0','Ratnadeep Super Market_4','202410101052',NULL,NULL,NULL,NULL,NULL,NULL),(5,'20241010-000015','191.00','admin','2024 10 10','  Cash','  General','191.00','0.00','0.00','0.0','Ratnadeep Super Market_5','202410101124',NULL,NULL,NULL,NULL,NULL,NULL),(6,'20241010-000016','931.00','admin','2024 10 10','  Cash','  General','931.00','0.00','0.00','0.0','Ratnadeep Super Market_6','202410101125',NULL,NULL,NULL,NULL,NULL,NULL),(7,'20241010-000017','358.00','admin','2024 10 10','  Cash','  General','358.00','0.00','0.00','0.0','Ratnadeep Super Market_7','202410101135',NULL,NULL,NULL,NULL,NULL,NULL),(8,'20241010-000018','376.00','admin','2024 10 10','  Cash','  General','376.00','0.00','0.00','0.0','Ratnadeep Super Market_8','202410101135',NULL,NULL,NULL,NULL,NULL,NULL),(9,'20241010-000019','211.00','admin','2024 10 10','  Cash','  General','211.00','0.00','0.00','0.0','Ratnadeep Super Market_9','202410101136',NULL,NULL,NULL,NULL,NULL,NULL),(10,'20241010-0000110','248.00','admin','2024 10 10','  Cash','  General','248.00','0.00','0.00','0.0','Ratnadeep Super Market_10','202410101136',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `clicked_cust_name` (`_id`, `name`) VALUES (1,'');
INSERT INTO `itemdata` (`_id`, `itemname`, `total`) VALUES (1,'apples kg',202),(2,'axe deo 150ml',175),(3,'bajaj oil 200ml',113),(4,'banana yelakki kg',88),(5,'beans kg',120),(6,'beet root kg',160),(7,'cabbage kg',32),(8,'carrots kg',280),(9,'cauliflower kg',135),(10,'cucumbers kg',80),(11,'dabur  paste 200gm',84),(12,'eggs 6pcs',38),(13,'fig fruit kg',1000),(14,'frooty',10),(15,'godrej color soft',147),(16,'grapes kg',145),(17,'ladies finger kg',56),(18,'loreal color 90gms',228),(19,'loreal conditioner 180gm',142),(20,'maaza 600ml',31),(21,'muskmelon kg',45),(22,'nutella',510),(23,'onions big kg',40),(24,'parachute hair cream 50gm',38),(25,'pepsi 2lt',76),(26,'pineapple kg',80),(27,'potatoes kg',96),(28,'radish white kg',24),(29,'rin fabric whitener 500ml',55),(30,'rin powder 6kg',420),(31,'robin powder blue 200gm',46),(32,'sona masoori raw rice 1kg',336),(33,'spinach bunch',60),(34,'sweet corn piece',30),(35,'tata tea agni250gm',58),(36,'tata tea premium 1 kg',412),(37,'tata urad dal whole white 1kg',500),(38,'tomatoes kg',25),(39,'tropicana mixed fruit 1ltr',94),(40,'urad dal black whole loose kg',202);
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,'21','apples kg',202,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'274','axe deo 150ml',175,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'197','bajaj oil 200ml',113,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'24','banana yelakki kg',88,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'9','beans kg',120,2,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'13','beet root kg',160,2,'5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'19','cabbage kg',32,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'7','carrots kg',280,4,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'8','cauliflower kg',135,2,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'11','cucumbers kg',80,1,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'285','dabur  paste 200gm',84,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'306','eggs 6pcs',38,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'4','fig fruit kg',1000,16,'4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'108','frooty',10,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'230','godrej color soft',147,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'27','grapes kg',145,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'5','ladies finger kg',56,1,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'12','loreal color 90gms',228,4,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'242','loreal conditioner 180gm',142,2,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'131','maaza 600ml',31,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'33','muskmelon kg',45,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,'3','nutella',510,8,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'14','onions big kg',40,1,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(24,'216','parachute hair cream 50gm',38,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(25,'117','pepsi 2lt',76,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'25','pineapple kg',80,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,'16','potatoes kg',96,2,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,'15','radish white kg',24,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,'80','rin fabric whitener 500ml',55,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'71','rin powder 6kg',420,7,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'98','robin powder blue 200gm',46,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(32,'1','sona masoori raw rice 1kg',336,5,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,'17','spinach bunch',60,1,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'10','sweet corn piece',30,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(35,'56','tata tea agni250gm',58,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,'47','tata tea premium 1 kg',412,6,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,'2','tata urad dal whole white 1kg',500,8,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,'20','tomatoes kg',25,0,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,'157','tropicana mixed fruit 1ltr',94,1,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,'48','urad dal black whole loose kg',202,3,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `top_category` (`_id`, `category`, `value`) VALUES (1,'beverages',681),(2,'branded foods',510),(3,'bread bakery and eggs',38),(4,'dals and pulses',202),(5,'dals pulses',500),(6,'fruits and vegetables',2698),(7,'household',521),(8,'personal care',927),(9,'rice whole grains',336),(10,'beverages',681),(11,'branded foods',510),(12,'bread bakery and eggs',38),(13,'dals and pulses',202),(14,'dals pulses',500),(15,'fruits and vegetables',2698),(16,'household',521),(17,'personal care',927),(18,'rice whole grains',336);
INSERT INTO `userdata` (`_id`, `username`, `total`) VALUES (1,'admin',6413);
INSERT INTO `userwiseorderlistitems` (`_id`, `username`, `sales`, `salespercentage`) VALUES (1,'madmin',6413,100);
