DROP TABLE IF EXISTS admin;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `pre` varchar(3) NOT NULL,
  `company` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `city` varchar(50) NOT NULL,
  `director` varchar(100) NOT NULL,
  `open` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO admin VALUES
('1', 'admin', 'admin', 'CSM', 'Farm To Home', 'Barshi Road, Osmanabad - 413 501', 'Osmanabad', '', 'No');
DROP TABLE IF EXISTS cart;
CREATE TABLE `cart` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
DROP TABLE IF EXISTS category;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO category VALUES
('6', 'Vegetables', 'photo1_6_2025-07-27-10-23-48.jpg', '<p>Vegetables&nbsp;</p>\r\n', '1'),
('7', 'Fruits', 'photo1_7_2025-07-27-10-24-07.jpg', '<p>Fresh Friuts</p>\r\n', '1'),
('8', 'Oil Products', 'photo1_8_2025-07-15-13-59-18.webp', '<p>Oil Products</p>\r\n', '1'),
('9', 'Milk Products', 'photo1_9_2025-07-15-13-59-09.webp', '<p>Milk Products</p>\r\n', '1'),
('10', 'Pulses', 'photo1_10_2025-07-17-18-15-02.jfif', '', '1'),
('11', 'Combo Pack', 'category_11_2025-08-04-06-50-58.jpg', '<p>Combo of Vegetables</p>\r\n', '1'),
('12', 'flowers', 'category_12_2025-08-06-18-41-10.jpg', '', '1'),
('13', 'Grains', 'category_13_2025-08-07-15-18-15.jpg', '', '1');
DROP TABLE IF EXISTS customers;
CREATE TABLE `customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(50) DEFAULT NULL,
  `lname` varchar(50) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `password` varchar(60) DEFAULT NULL,
  `cpassword` varchar(50) DEFAULT NULL,
  `approve` varchar(10) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `area` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `pincode` varchar(10) DEFAULT NULL,
  `bfname` varchar(50) DEFAULT NULL,
  `bname` varchar(50) DEFAULT NULL,
  `bemail` varchar(100) DEFAULT NULL,
  `bmobile` varchar(20) DEFAULT NULL,
  `bstate` varchar(50) DEFAULT NULL,
  `bcity` varchar(50) DEFAULT NULL,
  `barea` varchar(100) DEFAULT NULL,
  `bpincode` varchar(10) DEFAULT NULL,
  `baddress` varchar(200) DEFAULT NULL,
  `activate_code` varchar(15) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO customers VALUES
('9', 'Shyam', 'Tete', 'grtete99@gmail.com', '12345', '', '0', '9226807651', 'Maharashtra', 'Pune', 'Sinhagad Road', 'National Park, Sinhagad Road, Pune - 4110151', '411051', '', '', '', '', '', '', '', '', '', 'wzPGkX5IODlTYHg', '2018-05-09 00:00:00'),
('52', 'Prakash ', 'Lekawale ', 'lprakash26282@gmail.com', '1111', '', '', '9657299314', 'Maharashtra', 'Pune', '', 'Shivprabha apprt. Flat no. 05,  2nd floor, opp. Yash platinum, dhayri  narhe road, dhayri pune 411041', '412213', '', '', '', '', '', '', '', '', '', '', '2025-07-22 23:09:04'),
('53', 'Suvarna', 'Lekawale', 'kartikipangare@gmail.com', '312948', '', '', '9309716266', 'Maharashtra', 'Pune', '', 'Shivprabha ,flat no.5 ,  2nd floor, dhayari pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-22 23:31:27'),
('54', 'Kaustubh ', 'Pallod', 'pallodkaustubh@gmail.com', '12345', '', '', '7519785555', 'Maharashtra', 'Pune', '', 'B12/5,Ganga Village , Handewadi Road , Hadapsar', '411028', '', '', '', '', '', '', '', '', '', '', '2025-07-23 10:33:29'),
('55', 'Pratik', 'Gawande', 'pratikgawande1986@gmail.com', 'Pratik@2025', '', '', '9130016012', 'Maharashtra', 'Amravati', '', 'Saturna, Near DPS', '444605', '', '', '', '', '', '', '', '', '', '', '2025-07-23 20:37:07'),
('57', 'Tanmay', 'Lekawale ', 'pangaretanmay1@gmail.com', 'Tanmay', '', '', '8208928659', 'Maharashtra ', 'Pune', '', 'Shivprabha Apartment, flat no. 05,second floor, in front of yash platinum,Dhayari narhe road  dhayri pune ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-29 13:41:54'),
('58', 'Rahul ', 'Gaikwad ', 'rahulsampatigaikwad12985@gmail.com', '1588', '', '', '9730087358', 'Maharashtra ', 'Pune ', '', 'A3/109 Sinhgad PMAY vadgaion khurd Pune.', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-29 18:04:36'),
('59', 'Nisha ', 'Hodbe ', 'kurunkarnisha123@gmail.com', 'Nisha@123', '', '', '8097961310', 'Maharashtra ', 'Pune', '', 'Sinhgad PMAY Society A-1 Flat no - 65 , 6th floor behind chul angan hotel vadgaon Pune -411041', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-29 19:05:40'),
('60', 'Devendra ', 'Chavan', 'devchavan9922@gmail.com', '1234', '', '', '9922460740', 'Maharashtra', 'Vadgaon khurd Pune', '', 'Sinhgad Pmay  society   building A 7 flat no 107  Vadgaon khurd Pune Near hotel chul aangan ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-29 19:35:40'),
('61', 'GANESH ', 'SHINGARE ', 'shingare.ganesh@gmail.com', 'Ganesh@10031983', '', '', '8999986918', 'MAHARASHTRA ', 'PUNE', '', 'SINHAGAD PMPAY GRUHRACHNA SOCIETY BULIDING NO A2 FLAT NO 104 9 FOOLR VADGAON KHURD PUNE 411068', '411068', '', '', '', '', '', '', '', '', '', '', '2025-07-30 09:17:18'),
('62', 'Shilpa', 'Sadawrate ', 'swarshilpas@gmail.com', 'Swar$iddhi1980', '', '', '9403663139', 'Maharashtra', 'Pune', '', 'Skyi Star City, C7,104 second floor, Dhayari,pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-30 11:01:59'),
('63', 'Arun', 'Mayacharya', 'arunjagtap15170@gmail.com', '15170', '', '', '8830917755', 'Maharshtra', 'Pune', '', 'Sinhgad PMY sahakari gruhrachna sanstha maryadit, vadgaon khurd', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-30 18:37:34'),
('64', 'Prashant shriram', 'Dhakane ', 'dhakneprashant063@gmail.com', '1234', '', '', '9623828556', 'Maharshtra', 'Pune ', '', 'Sinhgad PMY sahakari gruh rachna sanstha maryadit, vadgaon khurd', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-30 18:47:08'),
('65', 'Ranjeet', 'Dattasamje ', 'ranjeetsamje@facebook.com', '585416', '', '', '8421388388', 'Maharashtra', 'Pune ', '', 'S. No 39/40 Bldg No A8 4 Th Floor Flat No 46 Sinhgad Pmay Sahkari Grah Rachana Sanstha maryadit, Sinhgad Road. Pune City. Po vadgaon Budruk Dist Pune Maharashtra 410041', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-30 21:16:19'),
('66', 'Mayur ', 'YELAGUNDE', 'vibha4434@gmail.com', '12345', '', '', '7083382145', 'Maharashtra', 'Nanded (N.V.)', '', 'NANDED CITY RD SIHGAD HOUSING SOCISOCI FLAT NO 133 A2', '411041', '', '', '', '', '', '', '', '', '', '', '2025-07-31 21:13:54'),
('67', 'Siya', 'Chavan', 'siyachavan2003@gmail.com', '123456', '', '', '9356969621', 'Maharashtra', 'Pune', '', 'Lipanewasti jambhulwadi road sadguru hospital ambegaon khurd ', '411046', '', '', '', '', '', '', '', '', '', '', '2025-08-01 11:59:32'),
('68', 'Sneha ', 'Chavan', 'snehachavan7208@gmail.com', '654321', '', '', '9579231967', 'Maharashtra', 'Pune', '', 'Lipanewasti jambhulwadi road sadguru hospital ambegaon khurd pune 411046', '411046', '', '', '', '', '', '', '', '', '', '', '2025-08-01 12:03:14'),
('69', 'Kavita', 'Konapure', 'kavitakonapure1990@gmail.com', '2211', '', '', '8149909384', 'Maharashtra', 'Pune', '', 'A7 building ,Flat No. 84 PMAY Society, Wadgaon  ,Pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-01 12:04:38'),
('70', 'Sujata', 'Mhaiskar', 'mvaibhavi8765@gmail.com', 'bhaji1234', '', '', '9284886251', 'Maharashtra', 'Pune', '', 'Flat 97, 9th Floor, Wing A7, Sinhgad Pmay Co Operative Soc, Near Hotel Chul Angan and Right to Nanded City Main Gate, Vadgaon BK', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-02 22:15:31'),
('71', 'Usha ', 'Chavan ', 'ushachavan3272@gmail.com', '123890', '', '', '9322573272', 'Maharashtra', 'Pune', '', 'Lipanewasti jambhulwadi road sadguru hospital ambegaon khurd pune ', '411046', '', '', '', '', '', '', '', '', '', '', '2025-08-03 20:17:21'),
('72', 'Aditya ', 'Chavan ', 'ramdaszombade46@gmail.com', 'aditya', '', '', '9511660631', 'Maharashtra', 'Pune', '', 'Lipanewasti jambhulwadi road sadguru hospital ambegaon khurd pune ', '411046', '', '', '', '', '', '', '', '', '', '', '2025-08-03 20:19:28'),
('73', 'Mahesh ', 'Vastre', 'maheshvastre@outlook.com', 'Mahesh123', '', '', '8055983404', 'Maharashtra', 'Pune', '', 'Pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-04 14:02:03'),
('74', 'Reshma', 'Waghmare', 'reshmawaghmare67@gmail.com', 'resh4141', '', '', '9049576333', 'Maharashtra', 'Pune', '', 'Flat no.67,bui. A6,PMAY soc., (near nanded city), Wadgaon khurd, Pune-411041', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-04 21:08:36'),
('75', 'Smita', 'Kotwal', 'sgkotwal@gmail.com', 'karandikar', '', '', '9822012603', 'Maharashtra ', 'Pune ', '', 'Agasti bungalow no 35.SBI colony.Patwardhan baug .Erandwane ', '411004', '', '', '', '', '', '', '', '', '', '', '2025-08-05 21:12:52'),
('76', 'Amar', 'Ranbhare', 'amardj30@gmail.com', 'Seco@123', '', '', '7387723713', 'MAHARASHTRA', 'Pune', '', 'A-9, Radhika Park , Benkar Vasti , Dhayari ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-06 14:25:08'),
('77', 'Jitendra ', 'Mahajan ', 'rtnjsmahajan@gmail.com', 'Jsm!%)$1504', '', '', '9225609593', 'Maharashtra ', 'Pune / Parvati ', '', 'Flat no 101, Kamaleshwari Park,\r\nCTS no 231, Near Mahalaxmi Sabhagruh,\r\nParvati', '411009', '', '', '', '', '', '', '', '', '', '', '2025-08-07 08:22:57'),
('78', 'Deepak ', 'Bhalghare ', 'deepakbhalghare121@gmail.com', 'aayush@11', '', '', '9175443380', 'Maharashtra ', 'Pune ', '', 'Jijai vilha ....narhe pune ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-07 13:26:57'),
('79', 'Amit ', 'Amit', 'amitlekawale123@gmail.com', '4545', '', '', '8421175121', 'Maharashtra', 'Pune', '', 'Nanded city asawari c 1304', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-07 14:25:55'),
('81', 'Amit ', 'Sarpale ', 'balasahebsarpale9424@gmail.com', 'amit9424', '', '', '9970087167', 'Maharashtra ', 'Pune', '', 'Katraj', '411046', '', '', '', '', '', '', '', '', '', '', '2025-08-08 11:27:01'),
('82', 'Abhijeet ', 'Nemane ', 'abhijeetnemane17@gmail.com', 'Abhijeetnemane', '', '', '9049978167', 'Maharashtra ', 'Pune', '', 'Yashoda narayn dhayri narhe road opp Yash platinum pune ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-08 19:30:17'),
('83', 'Sunil', 'Lekawale ', 'sunillekavle1972@gmail.com', 'sunillekawle', '', '', '9673590974', 'Maharashtra ', 'Pune', '', 'Sinhgad PMAY society vadgov khurd near nanded city', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-08 21:37:01'),
('84', 'Pooja  jitendra ', 'Bhalghare ', 'poojabhalghare166@gmail.com', '1111', '', '', '8329275852', 'Maharashtra ', 'Pune ', '', 'Hotel Triveni kitchen, jijai vilha, manajinagar,narhe pune 411041', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-09 10:28:45'),
('86', 'Deepa  ', 'Salunke', 'deepasalunke05@gmail.com', 'Deepa06', '', '', '8766633806', 'Maharashtra ', 'Pune', '', 'PMAY SOCIETY, VADGAON KHRUD, Pandurang industrial area,A3-23,Nanded ,Pune ,Chul Angan', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-11 13:44:12'),
('87', 'Vaishnavi ', 'Salunke ', 'salunkevaishnavi466@gmail.com', 'Vaishnavi01', '', '', '9834965760', 'maharashtra ', 'Pune', '', 'PMAY SOCIETY, VADGAON KHURD, PANDURANG INDUSTRIAL AREA,A3-23,CHUL ANGAN ,NANDED ,PUNE', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-11 14:01:34'),
('88', 'Swapnil', 'Deshpande ', '', 'Caswapnil@1989', '', '', '9561543025', 'Maharashtra ', 'Pune ', '', 'Building No C4, Flat No 605, 7th Floor, SKY I Star City, DSK Vishwa, Dhayari, Pune', '411024', '', '', '', '', '', '', '', '', '', '', '2025-08-14 20:33:15'),
('89', 'Lata ', 'Ravindra Lokhande ', '', '1111', '', '', '8805494238', 'Maharashtra', 'Pune', 'Pune ', 'PMY sinhgad nanded city building  A2 flat no. 54, 5 th floor  vadgaon khurd. Pune ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-16 18:10:31'),
('90', 'Lata ', 'Sagade', 'Lprakash26282@gmail.com', '1111', '', '', '8830802491', 'Maharashtra', 'Pune', 'prayeja city road ', 'Prayeja city co. operative society flat no 401 wing B-2', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 10:40:43'),
('91', 'Asha ', 'Bhavekar', 'klbhavekae@gmail.com', '1111', '', '', '9850470778', 'Maharashtra', 'Pune', 'Prayeja city ', 'C-2 Flat no 802', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 10:49:49'),
('92', 'Lokesh ', 'Bhavekar', 'lsbhavekar55@gmail.com', '1111', '', '', '8308155255', 'Maharashtra', 'Pune', 'prayeja city', 'prayeja city C-2 flat no 802', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 10:52:20'),
('93', 'deepti', 'godbole', 'deepti.mulay01@gmail.com', '1111', '', '', '9860949576', 'Maharashtra', 'Pune', 'Prayeja city ', 'C-3 Flat 902 prayeja city co. operative socity', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 11:42:31'),
('94', 'kaustubh', 'bhave', 'Kaustubhbhave95@gmail.com', '1111', '', '', '9405891967', 'maharashtra', 'Pune', 'Prayeja city', 'Prayeja city co.opertive society  C- 4 Flat no 203', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 11:53:22'),
('95', 'Deepak ', 'kelkar', 'dsk7375@hotmail.com', '1111', '', '', '9923287376', 'Maharashtra', 'Pune', 'Prayeja city', 'C-3 Flat 803  Prayeja city Co operative housing society', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 11:59:36'),
('98', 'Vaishali', 'kandhare', 'kandharevaishali6@gamil.com', '1111', '', '', '7517322871', 'maharashtra', 'Pune', 'Prayeja city', 'Prayeja city C -1 Flat no 703', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-17 12:49:17'),
('99', 'Ravindra', 'Karanjikar', '', '12345', '', '', '9823112560', 'Maharashtra', 'Pune', '', 'C4, 801, Prayeja City, Pune', '411051', '', '', '', '', '', '', '', '', '', '', '2025-08-19 19:54:33'),
('100', 'Ashok ', 'Badkas ', '', '92267347', '', '', '9226734723', 'Mh', 'Pune', '', 'Prayeja City C1/802', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-19 20:05:07'),
('101', 'Pratik', 'Kamble', '', 'Pk@#1992', '', '', '8793495959', 'Maharashtra ', 'Pune', '', '401, Wing-C4 Prayeja City Sinhgad Road Vadgaon Bk ', '411068', '', '', '', '', '', '', '', '', '', '', '2025-08-19 21:04:04'),
('102', 'Sonali', 'Parit', '', '1234567', '', '', '9370186391', 'MAHARASTRA', 'Pune', '', 'D-605, Greenland county narhe pune ', '411043', '', '', '', '', '', '', '', '', '', '', '2025-08-20 07:45:29'),
('103', 'Rohan ', 'Lambe', '', 'Keyur@123', '', '', '7507577177', 'Maharashtra', 'Pune', '', 'Skyi star city, C7-003, inside dsk vishwa, Dhayari', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-20 09:56:37'),
('104', 'Ketaki', 'Joshi', '', 'joshi302', '', '', '7506043550', 'Maharashtra ', 'DSK VISHVA DHAYARI ', '', 'Bhaskara E 302\r\nDSK VISHVA \r\nDHAYARI PUNE ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-20 11:17:23'),
('105', 'KV', 'Kulkarni', '', 'K1@krishna', '', '', '9370936119', 'Maharashtra', 'Pune', '', 'Flat No 606, I Tower, SKYi Star City, Near DSK Vishawa', '411024', '', '', '', '', '', '', '', '', '', '', '2025-08-21 15:24:08'),
('106', 'Ashwini', 'Kothawale', '', '281422', '', '', '9766580717', 'Maharashtra ', 'Pune,dsk vishwa road ', '', 'H103,sai avishkar society,near Omega heritage,dsk vishwa road', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-22 18:27:03'),
('107', 'Pooja ', 'DESHPANDE ', '', 'vrgetable', '', '', '9890084676', 'Maharashtra', 'Pune ', '', 'E 201 shriniwas serene county wadgaon khurd Sinhagad road Pune ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-23 12:18:59'),
('108', 'Aruna ', 'Devdhar ', '', '9975', '', '', '9975681488', 'Maharashtra', 'Pune', '', 'Seren county,D 103,1st floor, dhayri phata ', '411051', '', '', '', '', '', '', '', '', '', '', '2025-08-23 12:23:54'),
('109', 'Yashwant ', 'Deshpande ', '', 'yash11', '', '', '9970505930', 'Maharashtra', 'Pune ', '', 'E 201 shriniwas serene county wadgaon khurd Sinhagad road ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-23 12:27:14'),
('110', 'Reena ', 'Joshi ', '', 'Maulij23!', '', '', '9822734500', 'Maharashtra ', 'Pune, Singhad road ', '', 'A-403 SERENE COUNTY, Nanded Fata, Pandurang Industrial Area, Nanded, Pune, Maharashtra 411068', '411068', '', '', '', '', '', '', '', '', '', '', '2025-08-23 13:15:13'),
('111', 'Amit', 'Chothwe', '', 'Adira3144', '', '', '9404911986', 'Maharashtra', 'Pune', '', 'B1004, Prayeja Pearl,\r\nNear Prayeja city, sinhagad road ', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-23 13:20:35'),
('112', 'SAMPAT KISAN ', 'DORGE', '', 'Ayushi', '', '', '9028099399', 'MAHARASHATRA', 'PUNE', '', 'A-201 SERENE COUNTY SINHGAD ROAD NEAR LOKMAT PRESS', '411051', '', '', '', '', '', '', '', '', '', '', '2025-08-23 16:54:33'),
('114', 'Kirti ', 'Jog', '', 'Password@123', '', '', '9689907450', 'Maharashtra', 'Pune', '', 'Serene County, Wing I flat no 403,Near Lokmat Press, Sinhgad Rd, Near Lokmat Press, Vadgaon khurda pune 41', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-24 17:06:11'),
('115', 'Sonal ', 'Gujarathi', '', 'Harsh@2021', '', '', '9405664421', 'Maharashtra ', 'Pune', '', 'Prayeja pearl, B wing, 10th floor, 1003, Sinhgad road, pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-08-28 16:49:57'),
('116', 'Krishna ', 'Jagtap ', '', 'ap251296', '', '', '9371104994', 'Maharashtra ', 'Pune ', '', '17/1 B-2 Kautilya Apartments, Anand Nagar, Sinhgad Road', '411051', '', '', '', '', '', '', '', '', '', '', '2025-09-05 10:37:14'),
('117', 'Dnyanesh', 'Alhat ', '', 'Dba#29111967', '', '', '8668222961', 'Maharashtra ', 'Pimpri Chinchwad Pune ', '', 'Scheme 10 sector 21 building 20 flat 9 Jayshankar Co Op Hsg Society , yamuna nagar Nigdi pune 411044', '411044', '', '', '', '', '', '', '', '', '', '', '2025-09-06 14:46:01'),
('118', 'Tushar ', 'Gaikwad', '', 'Tushar@26', '', '', '9975631920', 'Maharashtra', 'Pune', '', 'Sr no 49 anant appatrment flat no 06  shivraj chowk chandan nagar pune', '411014', '', '', '', '', '', '', '', '', '', '', '2025-09-06 14:58:16'),
('119', 'Madhuri ', 'Burange', '', 'madhuri', '', '', '9561284050', 'Maharashtra', 'PUNE', '', 'Welworth blue scape flat no B 702,Sun Empire lane near Soham Riveria building Sun City rd Pune 51', '411051', '', '', '', '', '', '', '', '', '', '', '2025-09-06 16:54:07'),
('120', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('121', 'Dipali', 'Patwardhan', '', 'dipali', '', '', '9890639610', 'Maharashtra', 'Pune', '', 'Suncity housing society\r\nBuilding A1, Flat no 4, pune 411051', '411051', '', '', '', '', '', '', '', '', '', '', '2025-09-08 18:59:14'),
('122', 'SURAJ ', 'Jagadale ', '', 'Ratnamala123#', '', '', '7709332035', 'Maharashtra ', 'Pune', '', 'Flat no 503 , Prayeja puram , H wing , behind prayeja city , sinhgad road , pune 411041', '411041', '', '', '', '', '', '', '', '', '', '', '2025-09-12 19:51:01'),
('123', 'Vinit ', 'Patil ', '', '67890', '', '', '8010643285', 'Pune ', 'Ambegoan ', '', 'Ambegoan dwarka dham flat 202 pune Maharashtra ', '411046', '', '', '', '', '', '', '', '', '', '', '2025-09-13 13:39:54'),
('124', 'Pallavi', 'Prabhune', '', 'pallavi@2411', '', '', '7720001942', 'MAHARASHTRA', 'Pune', '', 'A2/12, thakkars green hills\r\nDhabadi\r\nAambegaon', '411046', '', '', '', '', '', '', '', '', '', '', '2025-09-15 17:54:10'),
('125', 'Sneha ', 'Kakade ', '', 'Snehaamol', '', '', '7397954795', 'Maharashtra ', 'Pune', '', 'C6 208 star city, \r\nNear DSK VISHWA,  Dhayari Pune', '411041', '', '', '', '', '', '', '', '', '', '', '2025-09-15 18:22:11'),
('126', 'Ramakant ', 'Prabhune ', '', 'Organic925@', '', '', '9423033531', 'Maharashtra ', 'Dhabadi ( Durga Mandir)', '', 'A-2/ Flat no 12 \r\nThakkar Green Hills Hsg Society Sadashiv Dangat Nagar Dhabadi. Ambegaon budruk Pune near Navale bridge - Vadgaon budruk Road Pune.', '411046', '', '', '', '', '', '', '', '', '', '', '2025-09-15 18:47:35'),
('127', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('128', 'SACHIN', 'Kulkarni', '', 'Trust@1976', '', '', '9765553466', 'Mahrashtra', 'Pune', '', 'Flat no a22 shalini residency katraj pune', '411046', '', '', '', '', '', '', '', '', '', '', '2025-09-28 19:46:20'),
('129', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('130', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('131', 'A', 'R', '', '123456789', '', '', '8392890068', 'Maharashtra', 'Pune', '', 'Pimpri Chinchwad', '411033', '', '', '', '', '', '', '', '', '', '', '2025-10-10 17:02:31'),
('132', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('133', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('134', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('135', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('136', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('137', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('138', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('139', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('140', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('141', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('142', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('143', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('144', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('145', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('146', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('147', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('148', 'Prashant ', 'Savale ', '', 'Prashant@9', '', '', '8483824774', 'Maharashtra', 'Pune', '', 'AT-POST NERE TAL BHOR DIST-PUNE ', '411009', '', '', '', '', '', '', '', '', '', '', '2025-11-24 19:36:40'),
('149', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('150', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('151', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('152', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('153', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('154', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('155', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('156', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('157', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('158', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('159', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('160', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('161', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('162', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('163', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('164', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('165', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('166', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('167', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('168', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('169', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('170', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('171', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('172', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('173', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('174', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('175', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('176', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('177', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('178', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('179', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('180', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('181', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('182', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('183', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('184', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('185', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('186', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('187', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('188', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('189', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('190', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('191', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('192', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('193', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('194', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('195', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('196', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('197', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('198', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('199', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('200', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('201', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('202', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('203', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('204', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('205', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('206', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('207', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('208', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('209', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('210', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('211', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('212', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('213', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('214', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('215', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('216', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('217', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('218', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('219', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('220', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('221', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('222', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('223', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('224', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('225', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('226', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('227', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('228', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
DROP TABLE IF EXISTS details;
CREATE TABLE `details` (
  `id` int(11) NOT NULL,
  `sales_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO details VALUES
('14', '9', '11', '2'),
('15', '9', '13', '5'),
('16', '9', '3', '2'),
('17', '9', '1', '3'),
('18', '10', '13', '3'),
('19', '10', '2', '4'),
('20', '10', '19', '5');
DROP TABLE IF EXISTS orderproducts;
CREATE TABLE `orderproducts` (
  `opid` int(11) NOT NULL AUTO_INCREMENT,
  `orderid` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(10,3) DEFAULT NULL,
  `rate` float(10,2) NOT NULL,
  `cost` float(10,2) NOT NULL,
  PRIMARY KEY (`opid`)
) ENGINE=InnoDB AUTO_INCREMENT=516 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO orderproducts VALUES
('1', '31', '39', 'आले', '0.000', '9.00', '2.25'),
('2', '33', '39', 'आले', '0.250', '9.00', '2.25'),
('3', '33', '36', 'बटाटा', '2.000', '14.00', '28.00'),
('4', '33', '33', 'गवार', '0.500', '30.00', '15.00'),
('5', '34', '39', 'आले', '0.250', '9.00', '2.25'),
('6', '34', '36', 'बटाटा', '2.000', '14.00', '28.00'),
('7', '34', '33', 'गवार', '0.500', '30.00', '15.00'),
('8', '35', '39', 'आले', '0.250', '9.00', '2.25'),
('9', '35', '36', 'बटाटा', '2.000', '14.00', '28.00'),
('10', '35', '33', 'गवार', '0.500', '30.00', '15.00'),
('11', '36', '39', 'आले', '0.250', '9.00', '2.25'),
('12', '36', '36', 'बटाटा', '2.000', '14.00', '28.00'),
('13', '36', '33', 'गवार', '0.500', '30.00', '15.00'),
('14', '36', '39', 'आले', '0.500', '9.00', '4.50'),
('15', '36', '38', 'तोंडली', '2.000', '67.00', '134.00'),
('16', '36', '36', 'बटाटा', '2.000', '14.00', '28.00'),
('17', '36', '39', 'आले', '0.500', '9.00', '4.50'),
('18', '36', '38', 'तोंडली', '2.000', '67.00', '134.00'),
('19', '36', '40', 'मक्याचे कणीस', '0.500', '48.00', '24.00'),
('20', '36', '39', 'आले', '0.250', '9.00', '2.25'),
('21', '36', '38', 'तोंडली', '1.000', '67.00', '67.00'),
('22', '36', '40', 'मक्याचे कणीस', '0.500', '48.00', '24.00'),
('23', '36', '40', 'मक्याचे कणीस', '0.500', '48.00', '24.00'),
('24', '37', '40', 'मक्याचे कणीस', '0.500', '48.00', '24.00'),
('25', '38', '40', 'मक्याचे कणीस', '0.500', '48.00', '24.00'),
('26', '39', '39', 'आले', '2.000', '9.00', '18.00'),
('27', '40', '40', 'मक्याचे कणीस', '0.250', '48.00', '12.00'),
('28', '40', '33', 'गवार', '0.250', '160.00', '40.00'),
('29', '40', '31', 'बीट', '0.250', '40.00', '10.00'),
('30', '40', '29', 'फ्लॉवर', '0.500', '100.00', '50.00'),
('31', '40', '24', 'मिरची', '0.250', '120.00', '30.00'),
('32', '40', '23', 'काकडी', '0.500', '80.00', '40.00'),
('33', '40', '18', 'वांगं', '0.250', '60.00', '15.00'),
('34', '40', '16', 'भोपळा', '0.250', '60.00', '15.00'),
('35', '40', '58', 'स्ट्रॉबेरी', '0.500', '51.00', '25.50'),
('36', '40', '60', 'अंजीर', '0.500', '7.00', '3.50'),
('37', '40', '55', 'ब्लॅकबेरी', '0.500', '54.00', '27.00'),
('38', '40', '46', 'सफरचंद', '0.500', '9.00', '4.50'),
('39', '40', '41', 'केळी', '0.500', '22.00', '11.00'),
('40', '40', '81', 'Chatani Pack', '0.250', '50.00', '12.50'),
('41', '41', '46', 'सफरचंद', '1.000', '9.00', '9.00'),
('42', '41', '43', 'पेरू', '1.000', '1.00', '1.00'),
('43', '41', '51', 'किवी', '0.500', '28.00', '14.00'),
('44', '41', '52', 'आंबा', '1.000', '5.00', '5.00'),
('45', '41', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('46', '42', '88', 'ब्रोकोली ', '0.250', '150.00', '37.50'),
('47', '43', '88', 'ब्रोकोली ', '0.500', '150.00', '75.00'),
('48', '44', '90', 'बेबी स्वीट कॉर्न ', '0.500', '100.00', '50.00'),
('49', '44', '88', 'ब्रोकोली ', '0.500', '150.00', '75.00'),
('50', '44', '82', 'Veg Combo PAck', '1.000', '99.00', '99.00'),
('51', '44', '81', 'Chatani Pack', '0.250', '40.00', '10.00'),
('52', '44', '79', 'Pulav Pack', '0.250', '120.00', '30.00'),
('53', '44', '34', 'घेवडा ', '0.250', '80.00', '20.00'),
('54', '44', '31', 'बीट', '0.250', '40.00', '10.00'),
('55', '44', '25', 'कांदा', '2.000', '20.00', '40.00'),
('56', '44', '16', 'भोपळा', '0.250', '80.00', '20.00'),
('57', '44', '17', 'लसूण', '0.250', '120.00', '30.00'),
('58', '44', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('59', '45', '67', 'ड्रॅगनफळ', '0.500', '140.00', '70.00'),
('60', '45', '90', 'बेबी स्वीट कॉर्न ', '0.250', '100.00', '25.00'),
('61', '45', '88', 'ब्रोकोली ', '0.250', '150.00', '37.50'),
('62', '47', '99', 'गावरान ज्वारी ', '1.000', '290.00', '290.00'),
('63', '48', '90', 'बेबी स्वीट कॉर्न ', '0.500', '100.00', '50.00'),
('64', '49', '90', 'बेबी स्वीट कॉर्न ', '0.500', '100.00', '50.00'),
('65', '52', '88', 'ब्रोकोली ', '1.000', '150.00', '150.00'),
('66', '52', '81', 'Chatani Pack', '0.250', '40.00', '10.00'),
('67', '52', '79', 'Pulav Pack', '0.250', '149.00', '37.25'),
('68', '52', '39', 'आले', '0.250', '60.00', '15.00'),
('69', '52', '29', 'फ्लॉवर', '1.000', '80.00', '80.00'),
('70', '52', '31', 'बीट', '0.250', '40.00', '10.00'),
('71', '52', '18', 'वांगं', '0.250', '50.00', '12.50'),
('72', '52', '16', 'भोपळा', '0.250', '80.00', '20.00'),
('73', '52', '15', 'टोमॅटो', '1.000', '80.00', '80.00'),
('74', '52', '60', 'अंजीर', '0.500', '250.00', '125.00'),
('75', '52', '56', 'खरबूज ', '1.000', '149.00', '149.00'),
('76', '52', '55', 'ब्लॅकबेरी', '0.250', '300.00', '75.00'),
('77', '52', '46', 'सफरचंद', '1.000', '240.00', '240.00'),
('78', '52', '41', 'केळी', '0.500', '60.00', '30.00'),
('79', '52', '92', 'मोडाची मटकी ', '0.250', '160.00', '40.00'),
('80', '53', '101', 'भुईमुगाच्या शेंगा ', '0.500', '249.00', '124.50'),
('81', '53', '90', 'बेबी स्वीट कॉर्न ', '0.500', '100.00', '50.00'),
('82', '53', '88', 'ब्रोकोली ', '0.500', '150.00', '75.00'),
('83', '53', '67', 'ड्रॅगनफळ', '0.500', '140.00', '70.00'),
('84', '53', '80', 'Pavbhaji Pack', '0.500', '199.00', '99.50'),
('85', '53', '79', 'Pulav Pack', '0.500', '149.00', '74.50'),
('86', '53', '81', 'Chatani Pack', '0.250', '40.00', '10.00'),
('87', '53', '82', 'Veg Combo PAck', '0.500', '99.00', '49.50'),
('88', '54', '39', 'आले', '0.250', '60.00', '15.00'),
('89', '54', '87', 'शेवगा ', '0.500', '110.00', '55.00'),
('90', '54', '88', 'ब्रोकोली ', '0.500', '150.00', '75.00'),
('91', '55', '39', 'आले', '0.250', '60.00', '15.00'),
('92', '55', '87', 'शेवगा ', '1.000', '110.00', '110.00'),
('93', '55', '88', 'ब्रोकोली ', '0.500', '150.00', '75.00'),
('94', '56', '60', 'अंजीर', '0.500', '250.00', '125.00'),
('95', '56', '54', 'सीताफळ', '0.500', '90.00', '45.00'),
('96', '57', '83', 'कोथिंबीर ', '1.000', '14.00', '14.00'),
('97', '57', '21', 'फ्रेश वाटाणा ( सोललेला )', '0.250', '160.00', '40.00'),
('98', '57', '25', 'कांदा', '1.000', '20.00', '20.00'),
('99', '57', '86', 'शेपु ', '1.000', '15.00', '15.00'),
('100', '57', '53', 'द्राक्ष', '0.250', '199.00', '49.75'),
('101', '58', '43', 'पेरू', '0.250', '90.00', '22.50'),
('102', '58', '110', 'निवडलेली कोथिंबीर ', '1.000', '40.00', '40.00'),
('103', '58', '90', 'बेबी स्वीट कॉर्न ', '0.500', '100.00', '50.00'),
('104', '58', '39', 'आले', '0.250', '50.00', '12.50'),
('105', '58', '25', 'कांदा', '1.000', '18.00', '18.00'),
('106', '59', '57', 'डाळिंब', '0.250', '199.00', '49.75'),
('107', '59', '36', 'बटाटा', '1.000', '28.00', '28.00'),
('108', '59', '35', 'लिंबू', '1.000', '10.00', '10.00'),
('109', '59', '25', 'कांदा', '1.000', '18.00', '18.00'),
('110', '59', '60', 'अंजीर', '0.250', '250.00', '62.50'),
('111', '60', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('112', '60', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('113', '60', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('114', '60', '33', 'गवार', '0.250', '120.00', '30.00'),
('115', '60', '32', 'दोडका', '0.250', '110.00', '27.50'),
('116', '60', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('117', '60', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('118', '60', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('119', '61', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('120', '62', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('121', '62', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('122', '62', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('123', '62', '33', 'गवार', '0.250', '120.00', '30.00'),
('124', '62', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('125', '62', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('126', '62', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('127', '63', '97', 'शेतकऱ्याकडचा गहू ', '2.000', '249.00', '498.00'),
('128', '64', '97', 'शेतकऱ्याकडचा गहू ', '2.000', '249.00', '498.00'),
('129', '65', '111', 'सोललेला घेवडा ', '2.000', '160.00', '320.00'),
('130', '66', '111', 'सोललेला घेवडा ', '0.250', '160.00', '40.00'),
('131', '66', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('132', '67', '118', 'पांढरं कारलं ', '1.000', '95.00', '95.00'),
('133', '67', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('134', '67', '67', 'ड्रॅगनफळ', '0.250', '210.00', '52.50'),
('135', '68', '118', 'पांढरं कारलं ', '1.000', '95.00', '95.00'),
('136', '69', '118', 'पांढरं कारलं ', '1.000', '95.00', '95.00'),
('137', '69', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('138', '69', '67', 'ड्रॅगनफळ', '0.250', '210.00', '52.50'),
('139', '70', '118', 'पांढरं कारलं ', '1.000', '95.00', '95.00'),
('140', '70', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('141', '70', '67', 'ड्रॅगनफळ', '0.250', '210.00', '52.50'),
('142', '71', '118', 'पांढरं कारलं ', '1.000', '95.00', '95.00'),
('143', '71', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('144', '71', '67', 'ड्रॅगनफळ', '0.250', '210.00', '52.50'),
('145', '71', '114', 'फ्रेश वांगी ', '0.500', '88.00', '44.00'),
('146', '72', '117', ' मिरची ', '0.500', '100.00', '50.00'),
('147', '72', '116', 'हिरवी शिमला मिरची ', '1.000', '100.00', '100.00'),
('148', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('149', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('150', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('151', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('152', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('153', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('154', '72', '116', 'हिरवी शिमला मिरची ', '1.000', '100.00', '100.00'),
('155', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('156', '72', '116', 'हिरवी शिमला मिरची ', '1.000', '100.00', '100.00'),
('157', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('158', '72', '116', 'हिरवी शिमला मिरची ', '1.000', '100.00', '100.00'),
('159', '72', '118', 'पांढरं कारलं ', '5.000', '95.00', '475.00'),
('160', '72', '116', 'हिरवी शिमला मिरची ', '5.000', '100.00', '500.00'),
('161', '72', '116', 'हिरवी शिमला मिरची ', '5.000', '100.00', '500.00'),
('162', '72', '81', 'Chatani Pack', '1.000', '80.00', '80.00'),
('163', '72', '84', 'पालक ', '1.000', '20.00', '20.00'),
('164', '72', '91', 'मोडाचे मूग ', '0.250', '160.00', '40.00'),
('165', '72', '81', 'Chatani Pack', '1.000', '80.00', '80.00'),
('166', '72', '84', 'पालक ', '1.000', '20.00', '20.00'),
('167', '72', '91', 'मोडाचे मूग ', '0.250', '160.00', '40.00'),
('168', '72', '115', 'फ्रेश कोबी ', '3.000', '80.00', '240.00'),
('169', '73', '115', 'फ्रेश कोबी ', '3.000', '80.00', '240.00'),
('170', '79', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('171', '79', '110', 'निवडलेली कोथिंबीर ', '1.000', '40.00', '40.00'),
('172', '79', '88', 'ब्रोकोली ', '0.250', '165.00', '41.25'),
('173', '79', '85', 'मेथी ', '1.000', '20.00', '20.00'),
('174', '79', '38', 'तोंडली', '0.250', '80.00', '20.00'),
('175', '79', '20', 'गाजर', '0.500', '80.00', '40.00'),
('176', '80', '115', 'फ्रेश कोबी ', '3.000', '80.00', '240.00'),
('177', '81', '116', 'हिरवी शिमला मिरची ', '4.000', '100.00', '400.00'),
('178', '82', '116', 'हिरवी शिमला मिरची ', '4.000', '100.00', '400.00'),
('179', '83', '116', 'हिरवी शिमला मिरची ', '4.000', '100.00', '400.00'),
('180', '84', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('181', '84', '39', 'आले', '0.500', '90.00', '45.00'),
('182', '84', '31', 'बीट', '0.250', '65.00', '16.25'),
('183', '84', '117', ' मिरची ', '0.250', '100.00', '25.00'),
('184', '84', '87', 'शेवगा ', '0.250', '120.00', '30.00'),
('185', '85', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('186', '85', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('187', '85', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '90.00', '22.50'),
('188', '85', '25', 'कांदा', '5.000', '20.00', '100.00'),
('189', '85', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('190', '86', '20', 'गाजर', '0.500', '80.00', '40.00'),
('191', '86', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('192', '86', '36', 'बटाटा', '1.000', '40.00', '40.00'),
('193', '86', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('194', '86', '25', 'कांदा', '1.000', '20.00', '20.00'),
('195', '87', '114', 'फ्रेश वांगी ', '750.000', '88.00', '66000.00'),
('196', '87', '85', 'मेथी ', '3.000', '20.00', '60.00'),
('197', '87', '84', 'पालक ', '2.000', '20.00', '40.00'),
('198', '87', '38', 'तोंडली', '0.500', '80.00', '40.00'),
('199', '87', '29', 'फ्लॉवर', '0.250', '120.00', '30.00'),
('200', '88', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('201', '88', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('202', '88', '91', 'मोडाचे मूग ', '0.250', '160.00', '40.00'),
('203', '88', '20', 'गाजर', '0.250', '80.00', '20.00'),
('204', '88', '67', 'ड्रॅगनफळ', '0.250', '210.00', '52.50'),
('205', '88', '35', 'लिंबू', '0.200', '20.00', '4.00'),
('206', '88', '47', 'चिकू', '0.250', '155.00', '38.75'),
('207', '89', '87', 'शेवगा ', '0.250', '120.00', '30.00'),
('208', '89', '20', 'गाजर', '0.250', '80.00', '20.00'),
('209', '89', '21', 'फ्रेश वाटाणा ( सोललेला )', '0.250', '160.00', '40.00'),
('210', '89', '84', 'पालक ', '1.000', '20.00', '20.00'),
('211', '89', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('212', '90', '82', 'Veg Combo PAck', '1.000', '120.00', '120.00'),
('213', '90', '95', 'नारळ ', '1.000', '48.00', '48.00'),
('214', '91', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('215', '91', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('216', '91', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('217', '91', '85', 'मेथी ', '1.000', '20.00', '20.00'),
('218', '91', '38', 'तोंडली', '0.250', '80.00', '20.00'),
('219', '91', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '90.00', '22.50'),
('220', '91', '22', 'दुधी भोपळा', '0.250', '35.00', '8.75'),
('221', '91', '18', 'वांगं', '0.250', '80.00', '20.00'),
('222', '91', '15', 'टोमॅटो', '0.250', '80.00', '20.00'),
('223', '91', '43', 'पेरू', '0.500', '120.00', '60.00'),
('224', '92', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('225', '92', '116', 'हिरवी शिमला मिरची ', '0.250', '100.00', '25.00'),
('226', '92', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('227', '92', '85', 'मेथी ', '1.000', '20.00', '20.00'),
('228', '92', '38', 'तोंडली', '0.250', '80.00', '20.00'),
('229', '92', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '90.00', '22.50'),
('230', '92', '22', 'दुधी भोपळा', '0.250', '35.00', '8.75'),
('231', '92', '18', 'वांगं', '0.250', '80.00', '20.00'),
('232', '92', '15', 'टोमॅटो', '0.250', '80.00', '20.00'),
('233', '92', '43', 'पेरू', '0.500', '120.00', '60.00'),
('234', '93', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('235', '93', '34', 'घेवडा ', '0.250', '80.00', '20.00'),
('236', '93', '24', 'तिखट हिरवी मिरची ', '0.250', '120.00', '30.00'),
('237', '93', '84', 'पालक ', '1.000', '20.00', '20.00'),
('238', '93', '85', 'मेथी ', '1.000', '20.00', '20.00'),
('239', '93', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('240', '94', '124', 'पावटा ', '0.250', '80.00', '20.00'),
('241', '94', '118', 'पांढरं कारलं ', '0.250', '85.00', '21.25'),
('242', '94', '116', 'हिरवी शिमला मिरची ', '0.250', '80.00', '20.00'),
('243', '94', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('244', '94', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('245', '94', '29', 'फ्लॉवर', '0.250', '120.00', '30.00'),
('246', '94', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '90.00', '22.50'),
('247', '94', '25', 'कांदा', '0.500', '30.00', '15.00'),
('248', '94', '20', 'गाजर', '0.250', '80.00', '20.00'),
('249', '94', '18', 'वांगं', '0.250', '80.00', '20.00'),
('250', '94', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('251', '95', '33', 'गवार', '0.250', '120.00', '30.00'),
('252', '95', '34', 'घेवडा ', '0.250', '80.00', '20.00'),
('253', '95', '112', 'सोललेला पावटा ', '0.250', '198.00', '49.50'),
('254', '95', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('255', '95', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('256', '95', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('257', '95', '84', 'पालक ', '1.000', '20.00', '20.00'),
('258', '95', '32', 'दोडका', '0.250', '110.00', '27.50'),
('259', '95', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('260', '95', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '90.00', '22.50'),
('261', '95', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('262', '95', '17', 'लसूण', '0.500', '120.00', '60.00'),
('263', '95', '117', ' मिरची ', '0.250', '120.00', '30.00'),
('264', '95', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('265', '95', '25', 'कांदा', '2.000', '30.00', '60.00'),
('266', '95', '36', 'बटाटा', '2.000', '40.00', '80.00'),
('267', '96', '114', 'फ्रेश वांगी ', '0.250', '88.00', '22.00'),
('268', '96', '123', 'वाटाणा ', '0.250', '130.00', '32.50'),
('269', '96', '124', 'पावटा ', '0.250', '80.00', '20.00'),
('270', '96', '86', 'शेपु ', '1.000', '20.00', '20.00'),
('271', '96', '84', 'पालक ', '1.000', '20.00', '20.00'),
('272', '96', '39', 'आले', '0.250', '90.00', '22.50'),
('273', '96', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('274', '96', '32', 'दोडका', '0.500', '110.00', '55.00'),
('275', '96', '34', 'घेवडा ', '0.250', '80.00', '20.00'),
('276', '96', '29', 'फ्लॉवर', '0.250', '120.00', '30.00'),
('277', '96', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('278', '96', '22', 'दुधी भोपळा', '1.000', '22.00', '22.00'),
('279', '96', '15', 'टोमॅटो', '0.500', '80.00', '40.00'),
('280', '96', '121', 'आळू ची पाने ', '1.000', '15.00', '15.00'),
('281', '97', '124', 'पावटा ', '5.000', '90.00', '450.00'),
('282', '98', '124', 'पावटा ', '5.000', '90.00', '450.00'),
('283', '99', '124', 'पावटा ', '5.000', '90.00', '450.00'),
('284', '100', '124', 'पावटा ', '5.000', '90.00', '450.00'),
('285', '101', '124', 'पावटा ', '5.000', '90.00', '450.00'),
('286', '101', '118', 'पांढरं कारलं ', '0.500', '80.00', '40.00'),
('287', '102', '87', 'शेवगा ', '0.250', '120.00', '30.00'),
('288', '102', '38', 'तोंडली', '0.250', '140.00', '35.00'),
('289', '102', '36', 'बटाटा', '3.000', '40.00', '120.00'),
('290', '102', '33', 'गवार', '0.250', '120.00', '30.00'),
('291', '102', '88', 'ब्रोकोली ', '0.250', '400.00', '100.00'),
('292', '102', '34', 'घेवडा ', '0.500', '80.00', '40.00'),
('293', '102', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.500', '249.00', '124.50'),
('294', '102', '25', 'कांदा', '3.000', '30.00', '90.00'),
('295', '103', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('296', '103', '116', 'हिरवी शिमला मिरची ', '0.500', '70.00', '35.00'),
('297', '103', '86', 'शेपु ', '1.000', '20.00', '20.00'),
('298', '103', '30', 'कोबी जांभळा ', '0.250', '160.00', '40.00'),
('299', '103', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('300', '103', '20', 'गाजर', '0.500', '80.00', '40.00'),
('301', '104', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('302', '104', '116', 'हिरवी शिमला मिरची ', '0.500', '70.00', '35.00'),
('303', '104', '86', 'शेपु ', '1.000', '20.00', '20.00'),
('304', '104', '30', 'कोबी जांभळा ', '0.250', '160.00', '40.00'),
('305', '104', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('306', '104', '20', 'गाजर', '0.500', '80.00', '40.00'),
('307', '105', '123', 'वाटाणा ', '0.250', '130.00', '32.50'),
('308', '105', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('309', '105', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('310', '105', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('311', '105', '39', 'आले', '0.250', '90.00', '22.50'),
('312', '105', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('313', '105', '25', 'कांदा', '1.000', '30.00', '30.00'),
('314', '105', '41', 'केळी', '0.250', '60.00', '15.00'),
('315', '106', '123', 'वाटाणा ', '0.250', '130.00', '32.50'),
('316', '106', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('317', '106', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('318', '106', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('319', '106', '39', 'आले', '0.250', '90.00', '22.50'),
('320', '106', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('321', '106', '25', 'कांदा', '1.000', '30.00', '30.00'),
('322', '106', '41', 'केळी', '0.250', '60.00', '15.00'),
('323', '107', '123', 'वाटाणा ', '0.250', '130.00', '32.50'),
('324', '107', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('325', '107', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('326', '107', '87', 'शेवगा ', '0.250', '120.00', '30.00'),
('327', '107', '39', 'आले', '0.250', '90.00', '22.50'),
('328', '107', '25', 'कांदा', '1.000', '30.00', '30.00'),
('329', '107', '22', 'दुधी भोपळा', '0.250', '80.00', '20.00'),
('330', '107', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('331', '107', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('332', '107', '41', 'केळी', '0.250', '60.00', '15.00'),
('333', '108', '118', 'पांढरं कारलं ', '5.000', '80.00', '400.00'),
('334', '109', '117', ' मिरची ', '0.250', '120.00', '30.00'),
('335', '109', '85', 'मेथी ', '0.100', '28.00', '2.80'),
('336', '109', '121', 'आळू ची पाने ', '0.100', '18.00', '1.80'),
('337', '109', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('338', '109', '23', 'काकडी', '0.500', '80.00', '40.00'),
('339', '109', '15', 'टोमॅटो', '0.250', '72.00', '18.00'),
('340', '109', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('341', '109', '46', 'सफरचंद', '0.500', '199.00', '99.50'),
('342', '110', '117', ' मिरची ', '0.250', '120.00', '30.00'),
('343', '110', '85', 'मेथी ', '0.100', '28.00', '2.80'),
('344', '110', '121', 'आळू ची पाने ', '0.100', '18.00', '1.80'),
('345', '110', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('346', '110', '23', 'काकडी', '0.500', '80.00', '40.00'),
('347', '110', '15', 'टोमॅटो', '0.250', '72.00', '18.00'),
('348', '110', '36', 'बटाटा', '0.500', '40.00', '20.00'),
('349', '110', '46', 'सफरचंद', '0.500', '199.00', '99.50'),
('350', '111', '88', 'ब्रोकोली ', '0.250', '400.00', '100.00'),
('351', '111', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('352', '111', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('353', '111', '32', 'दोडका', '0.250', '110.00', '27.50'),
('354', '111', '31', 'बीट', '0.250', '65.00', '16.25'),
('355', '111', '29', 'फ्लॉवर', '0.500', '120.00', '60.00'),
('356', '111', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('357', '111', '18', 'वांगं', '0.250', '80.00', '20.00'),
('358', '111', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('359', '111', '101', 'भुईमुगाच्या शेंगा ', '0.500', '130.00', '65.00'),
('360', '111', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('361', '112', '88', 'ब्रोकोली ', '0.250', '400.00', '100.00'),
('362', '112', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('363', '112', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('364', '112', '32', 'दोडका', '0.250', '110.00', '27.50'),
('365', '112', '31', 'बीट', '0.250', '65.00', '16.25'),
('366', '112', '29', 'फ्लॉवर', '0.500', '120.00', '60.00'),
('367', '112', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('368', '112', '18', 'वांगं', '0.250', '80.00', '20.00'),
('369', '112', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('370', '112', '101', 'भुईमुगाच्या शेंगा ', '0.500', '130.00', '65.00'),
('371', '112', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('372', '113', '88', 'ब्रोकोली ', '0.250', '400.00', '100.00'),
('373', '113', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('374', '113', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('375', '113', '32', 'दोडका', '0.250', '110.00', '27.50'),
('376', '113', '31', 'बीट', '0.250', '65.00', '16.25'),
('377', '113', '29', 'फ्लॉवर', '0.500', '120.00', '60.00'),
('378', '113', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('379', '113', '18', 'वांगं', '0.250', '80.00', '20.00'),
('380', '113', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('381', '113', '101', 'भुईमुगाच्या शेंगा ', '0.500', '130.00', '65.00'),
('382', '113', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('383', '114', '88', 'ब्रोकोली ', '0.250', '400.00', '100.00'),
('384', '114', '87', 'शेवगा ', '0.250', '160.00', '40.00'),
('385', '114', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('386', '114', '32', 'दोडका', '0.250', '110.00', '27.50'),
('387', '114', '31', 'बीट', '0.250', '65.00', '16.25'),
('388', '114', '29', 'फ्लॉवर', '0.500', '120.00', '60.00'),
('389', '114', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('390', '114', '18', 'वांगं', '0.250', '80.00', '20.00'),
('391', '114', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('392', '114', '101', 'भुईमुगाच्या शेंगा ', '0.500', '130.00', '65.00'),
('393', '114', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('394', '115', '123', 'वाटाणा ', '0.250', '160.00', '40.00'),
('395', '115', '115', 'फ्रेश कोबी ', '0.250', '80.00', '20.00'),
('396', '115', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('397', '115', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('398', '115', '20', 'गाजर', '0.250', '80.00', '20.00'),
('399', '115', '15', 'टोमॅटो', '0.250', '72.00', '18.00'),
('400', '116', '36', 'बटाटा', '0.250', '40.00', '10.00'),
('401', '116', '118', 'पांढरं कारलं ', '0.250', '80.00', '20.00'),
('402', '116', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('403', '116', '121', 'आळू ची पाने ', '2.000', '18.00', '36.00'),
('404', '116', '16', 'भोपळा', '0.250', '160.00', '40.00'),
('405', '116', '26', 'भेंडी', '0.375', '80.00', '30.00'),
('406', '116', '117', ' मिरची ', '0.125', '120.00', '15.00'),
('407', '116', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('408', '116', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('409', '117', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('410', '117', '26', 'भेंडी', '0.750', '80.00', '60.00'),
('411', '117', '33', 'गवार', '0.750', '120.00', '90.00'),
('412', '117', '22', 'दुधी भोपळा', '0.750', '80.00', '60.00'),
('413', '117', '25', 'कांदा', '2.000', '30.00', '60.00'),
('414', '117', '85', 'मेथी ', '3.000', '28.00', '84.00'),
('415', '117', '84', 'पालक ', '2.000', '30.00', '60.00'),
('416', '117', '114', 'फ्रेश वांगी ', '0.750', '90.00', '67.50'),
('417', '118', '115', 'फ्रेश कोबी ', '0.250', '70.00', '17.50'),
('418', '118', '116', 'हिरवी शिमला मिरची ', '0.500', '80.00', '40.00'),
('419', '118', '114', 'फ्रेश वांगी ', '1.000', '90.00', '90.00'),
('420', '118', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('421', '118', '124', 'पावटा ', '0.250', '80.00', '20.00'),
('422', '118', '121', 'आळू ची पाने ', '1.000', '18.00', '18.00'),
('423', '119', '115', 'फ्रेश कोबी ', '0.250', '70.00', '17.50'),
('424', '119', '116', 'हिरवी शिमला मिरची ', '0.500', '80.00', '40.00'),
('425', '119', '114', 'फ्रेश वांगी ', '1.000', '90.00', '90.00'),
('426', '119', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('427', '119', '124', 'पावटा ', '0.250', '80.00', '20.00'),
('428', '119', '121', 'आळू ची पाने ', '1.000', '18.00', '18.00'),
('429', '120', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('430', '120', '123', 'वाटाणा ', '0.250', '120.00', '30.00'),
('431', '120', '122', 'कडीपत्ता ', '1.000', '10.00', '10.00'),
('432', '120', '67', 'ड्रॅगनफळ', '0.250', '180.00', '45.00'),
('433', '120', '64', 'नाशपाती (Pear)', '0.250', '249.00', '62.25'),
('434', '120', '63', 'आवळा', '0.250', '160.00', '40.00'),
('435', '121', '123', 'वाटाणा ', '1.000', '120.00', '120.00'),
('436', '121', '118', 'पांढरं कारलं ', '0.500', '80.00', '40.00'),
('437', '121', '87', 'शेवगा ', '0.500', '160.00', '80.00'),
('438', '121', '37', 'चवळी', '0.250', '165.00', '41.25'),
('439', '121', '66', 'रामफळ', '0.500', '120.00', '60.00'),
('440', '121', '67', 'ड्रॅगनफळ', '0.500', '180.00', '90.00'),
('441', '122', '70', 'लाकडी घाणा नैसर्गिक शेंगदाणा तेल ', '1.000', '350.00', '350.00'),
('442', '123', '124', 'पावटा ', '0.250', '80.00', '20.00'),
('443', '123', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('444', '123', '84', 'पालक ', '1.000', '30.00', '30.00'),
('445', '123', '39', 'आले', '0.250', '90.00', '22.50'),
('446', '123', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('447', '123', '31', 'बीट', '0.250', '65.00', '16.25'),
('448', '123', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('449', '123', '15', 'टोमॅटो', '0.250', '72.00', '18.00'),
('450', '123', '25', 'कांदा', '5.000', '30.00', '150.00'),
('451', '124', '124', 'पावटा ', '1.000', '80.00', '80.00'),
('452', '124', '115', 'फ्रेश कोबी ', '0.500', '70.00', '35.00'),
('453', '124', '29', 'फ्लॉवर', '0.500', '80.00', '40.00'),
('454', '125', '64', 'नाशपाती (Pear)', '0.500', '249.00', '124.50'),
('455', '125', '17', 'लसूण', '0.500', '100.00', '50.00'),
('456', '125', '117', ' मिरची ', '0.250', '120.00', '30.00'),
('457', '125', '116', 'हिरवी शिमला मिरची ', '0.250', '80.00', '20.00'),
('458', '125', '85', 'मेथी ', '1.000', '28.00', '28.00'),
('459', '125', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('460', '125', '26', 'भेंडी', '0.500', '80.00', '40.00'),
('461', '126', '116', 'हिरवी शिमला मिरची ', '0.500', '80.00', '40.00'),
('462', '126', '115', 'फ्रेश कोबी ', '1.000', '70.00', '70.00'),
('463', '126', '88', 'ब्रोकोली ', '0.250', '280.00', '70.00'),
('464', '126', '38', 'तोंडली', '0.250', '140.00', '35.00'),
('465', '126', '37', 'चवळी', '0.250', '165.00', '41.25'),
('466', '126', '33', 'गवार', '0.250', '160.00', '40.00'),
('467', '126', '31', 'बीट', '0.250', '65.00', '16.25'),
('468', '126', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('469', '126', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('470', '126', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('471', '126', '22', 'दुधी भोपळा', '0.250', '80.00', '20.00'),
('472', '126', '20', 'गाजर', '0.500', '80.00', '40.00'),
('473', '126', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('474', '127', '99', 'गावरान ज्वारी ', '1.000', '290.00', '290.00'),
('475', '128', '15', 'टोमॅटो', '1.000', '72.00', '72.00'),
('476', '128', '20', 'गाजर', '0.250', '80.00', '20.00'),
('477', '128', '36', 'बटाटा', '1.000', '40.00', '40.00'),
('478', '128', '83', 'कोथिंबीर ', '1.000', '20.00', '20.00'),
('479', '128', '115', 'फ्रेश कोबी ', '0.500', '70.00', '35.00'),
('480', '128', '16', 'भोपळा', '0.250', '160.00', '40.00'),
('481', '129', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('482', '129', '123', 'वाटाणा ', '0.500', '100.00', '50.00'),
('483', '129', '114', 'फ्रेश वांगी ', '0.250', '90.00', '22.50'),
('484', '129', '110', 'निवडलेली कोथिंबीर ', '1.000', '30.00', '30.00'),
('485', '129', '31', 'बीट', '0.250', '65.00', '16.25'),
('486', '129', '29', 'फ्लॉवर', '0.500', '80.00', '40.00'),
('487', '129', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('488', '129', '22', 'दुधी भोपळा', '0.250', '80.00', '20.00'),
('489', '129', '20', 'गाजर', '0.250', '80.00', '20.00'),
('490', '129', '15', 'टोमॅटो', '0.500', '72.00', '36.00'),
('491', '130', '125', 'मुळा ', '1.000', '30.00', '30.00'),
('492', '130', '117', ' मिरची ', '0.250', '120.00', '30.00'),
('493', '130', '116', 'हिरवी शिमला मिरची ', '0.250', '80.00', '20.00'),
('494', '130', '115', 'फ्रेश कोबी ', '0.250', '70.00', '17.50'),
('495', '130', '88', 'ब्रोकोली ', '0.250', '280.00', '70.00'),
('496', '130', '86', 'शेपु ', '1.000', '25.00', '25.00'),
('497', '130', '85', 'मेथी ', '1.000', '40.00', '40.00'),
('498', '130', '31', 'बीट', '0.250', '65.00', '16.25'),
('499', '130', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.250', '160.00', '40.00'),
('500', '130', '20', 'गाजर', '0.250', '80.00', '20.00'),
('501', '130', '18', 'वांगं', '0.250', '80.00', '20.00'),
('502', '130', '17', 'लसूण', '1.000', '100.00', '100.00'),
('503', '130', '28', 'शिमला मिरचं (लाल, पिवळी )', '0.250', '480.00', '120.00'),
('504', '130', '39', 'आले', '0.250', '90.00', '22.50'),
('505', '131', '116', 'हिरवी शिमला मिरची ', '0.250', '80.00', '20.00'),
('506', '131', '115', 'फ्रेश कोबी ', '0.500', '70.00', '35.00'),
('507', '131', '88', 'ब्रोकोली ', '0.250', '280.00', '70.00'),
('508', '131', '33', 'गवार', '0.250', '160.00', '40.00'),
('509', '131', '27', 'हिरवे बीन्स (घेवडा शेंग)', '0.500', '160.00', '80.00'),
('510', '131', '26', 'भेंडी', '0.250', '80.00', '20.00'),
('511', '131', '20', 'गाजर', '0.250', '80.00', '20.00'),
('512', '132', '95', 'नारळ ', '1.000', '40.00', '40.00'),
('513', '132', '123', 'वाटाणा ', '1.000', '200.00', '200.00'),
('514', '133', '95', 'नारळ ', '1.000', '40.00', '40.00'),
('515', '133', '123', 'वाटाणा ', '1.000', '200.00', '200.00');
DROP TABLE IF EXISTS orders;
CREATE TABLE `orders` (
  `orderid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `prodid` int(11) DEFAULT NULL,
  `quantity` decimal(10,3) DEFAULT NULL,
  `totalcost` decimal(10,2) DEFAULT NULL,
  `discost` decimal(10,2) DEFAULT NULL,
  `orderdate` date DEFAULT NULL,
  `delslot` varchar(50) DEFAULT NULL,
  `orderconfirm` char(1) DEFAULT NULL,
  `sellerid` int(11) DEFAULT NULL,
  `remark` varchar(200) DEFAULT NULL,
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`orderid`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO orders VALUES
('1', '2', '3', '4.000', '5.00', '6.00', '2020-07-23', '', 'Y', '1', 'remark', '2020-07-11 00:00:00'),
('2', '13', '3', '0.000', '0.00', '0.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 17:39:47'),
('3', '14', '3', '0.000', '0.00', '0.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 17:40:08'),
('4', '15', '3', '0.000', '0.00', '0.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 18:00:26'),
('5', '16', '3', '6.000', '286.00', '58.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 18:00:53'),
('6', '17', '3', '6.000', '286.00', '58.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 18:06:18'),
('7', '18', '3', '6.000', '286.00', '58.00', '2020-07-11', '', 'Y', '1', 'remark', '2020-07-11 18:08:51'),
('8', '19', '3', '4.000', '190.00', '25.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 07:23:03'),
('9', '21', '3', '4.000', '140.00', '17.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 08:33:37'),
('10', '22', '3', '0.000', '0.00', '0.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 08:35:51'),
('11', '23', '3', '2.000', '240.00', '61.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 08:38:25'),
('12', '24', '3', '0.000', '0.00', '0.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 08:39:14'),
('13', '25', '3', '4.000', '139.00', '6.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 08:46:06'),
('14', '26', '3', '7.000', '410.00', '33.00', '2020-07-12', '', 'Y', '1', 'remark', '2020-07-12 09:33:44'),
('15', '28', '3', '0.000', '0.00', '0.00', '2023-11-21', '', 'Y', '1', 'remark', '2023-11-21 17:35:48'),
('16', '29', '3', '0.000', '0.00', '0.00', '2023-11-21', '', 'Y', '1', 'remark', '2023-11-21 17:36:40'),
('17', '30', '3', '0.000', '0.00', '0.00', '2023-11-21', '', 'Y', '1', 'remark', '2023-11-21 17:36:50'),
('18', '31', '3', '0.000', '0.00', '0.00', '2023-11-21', '', 'Y', '1', 'remark', '2023-11-21 17:37:14'),
('19', '32', '3', '0.000', '0.00', '0.00', '2023-11-21', '', 'Y', '1', 'remark', '2023-11-21 17:39:09'),
('20', '37', '3', '0.000', '0.00', '0.00', '2023-11-23', '', 'Y', '1', 'remark', '2023-11-23 14:01:51'),
('21', '38', '3', '0.000', '0.00', '0.00', '2023-11-23', '', 'Y', '1', 'remark', '2023-11-23 14:21:04'),
('22', '9', '0', '1.000', '0.00', '-25.00', '2025-08-04', '', '', '0', '', '2025-08-04 08:34:45'),
('23', '9', '0', '1.000', '0.00', '-25.00', '2025-08-04', '', '', '0', '', '2025-08-04 08:36:47'),
('24', '9', '0', '1.000', '0.00', '-25.00', '2025-08-04', '', '', '0', '', '2025-08-04 08:37:26'),
('25', '9', '0', '2.000', '0.00', '-21.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:28:17'),
('26', '9', '0', '2.000', '0.00', '131.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:37:54'),
('27', '9', '0', '2.000', '0.00', '131.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:38:17'),
('28', '9', '0', '2.000', '0.00', '131.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:40:15'),
('29', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:40:59'),
('30', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:42:30'),
('31', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:43:55'),
('32', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:44:42'),
('33', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:45:33'),
('34', '9', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 11:46:19'),
('35', '2560', '0', '3.000', '0.00', '77.00', '2025-08-04', '', '', '0', '', '2025-08-04 12:28:22'),
('36', '9', '0', '3.000', '1.00', '77.00', '2025-08-04', '', 'Y', '0', '', '2025-08-04 12:29:45'),
('37', '9', '', '1.000', '124.50', '4.00', '2025-08-04', '', '', '', '', '2025-08-04 13:53:44'),
('38', '9', '', '1.000', '124.50', '4.00', '2025-08-04', '', '', '', '', '2025-08-04 13:56:17'),
('39', '73', '', '1.000', '118.50', '1.00', '2025-08-04', '', '', '', '', '2025-08-04 14:03:12'),
('40', '75', '', '14.000', '396.50', '391.00', '2025-08-05', '', '', '', '', '2025-08-05 21:14:56'),
('41', '76', '', '5.000', '149.50', '201.00', '2025-08-06', '', 'Y', '', '', '2025-08-06 14:27:58'),
('42', '1', '', '1.000', '138.00', '30.00', '2025-08-06', '', '', '', '', '2025-08-06 18:11:41'),
('43', '9', '', '1.000', '175.50', '30.00', '2025-08-06', '', '', '', '', '2025-08-06 18:12:55'),
('44', '75', '', '11.000', '524.50', '216.00', '2025-08-07', '', '', '', '', '2025-08-07 10:39:32'),
('45', '78', '', '3.000', '233.00', '80.00', '2025-08-07', '', '', '', '', '2025-08-07 13:29:05'),
('47', '52', '', '1.000', '290.00', '10.00', '2025-08-08', '', '', '', '', '2025-08-08 17:09:30'),
('48', '52', '', '1.000', '50.00', '20.00', '2025-08-08', '', '', '', '', '2025-08-08 17:16:10'),
('49', '52', '', '1.000', '50.00', '20.00', '2025-08-08', '', '', '', '', '2025-08-08 17:17:59'),
('50', '9', '', '0.000', '0.00', '0.00', '2025-08-08', '', '', '', '', '2025-08-08 17:50:46'),
('51', '9', '', '0.000', '0.00', '0.00', '2025-08-08', '', '', '', '', '2025-08-08 17:50:51'),
('52', '75', '', '15.000', '1073.75', '297.00', '2025-08-08', '', 'Y', '', '', '2025-08-08 20:38:10'),
('53', '1', '', '8.000', '553.00', '254.00', '2025-08-09', '', '', '', '', '2025-08-09 10:42:21'),
('54', '52', '', '3.000', '145.00', '90.00', '2025-08-11', '', '', '', '', '2025-08-11 10:45:05'),
('55', '52', '', '3.000', '200.00', '90.00', '2025-08-11', '', '', '', '', '2025-08-11 10:48:56'),
('56', '81', '', '2.000', '170.00', '60.00', '2025-08-11', '', '', '', '', '2025-08-11 12:07:45'),
('57', '87', '', '5.000', '138.75', '90.00', '2025-08-11', '', '', '', '', '2025-08-11 14:21:55'),
('58', '88', '', '5.000', '143.00', '62.00', '2025-08-14', '', 'Y', '', '', '2025-08-14 20:45:11'),
('59', '88', '', '5.000', '168.25', '85.00', '2025-08-15', '', 'Y', '', '', '2025-08-15 20:07:29'),
('60', '89', '', '8.000', '204.50', '103.00', '2025-08-16', '', '', '', '', '2025-08-16 18:37:16'),
('61', '89', '', '7.000', '177.00', '89.00', '2025-08-16', '', '', '', '', '2025-08-16 18:39:29'),
('62', '89', '', '7.000', '177.00', '89.00', '2025-08-16', '', '', '', '', '2025-08-16 18:39:34'),
('63', '92', '', '1.000', '498.00', '11.00', '2025-08-17', '', '', '', '', '2025-08-17 11:04:38'),
('64', '92', '', '1.000', '498.00', '11.00', '2025-08-17', '', 'Y', '', '', '2025-08-17 11:04:49'),
('65', '93', '', '1.000', '320.00', '20.00', '2025-08-17', '', '', '', '', '2025-08-17 11:46:04'),
('66', '95', '', '2.000', '515.00', '45.00', '2025-08-17', '', '', '', '', '2025-08-17 12:03:30'),
('67', '1', '', '3.000', '172.50', '55.00', '2025-08-18', '', '', '', '', '2025-08-18 20:34:45'),
('68', '1', '', '3.000', '172.50', '55.00', '2025-08-18', '', '', '', '', '2025-08-18 20:38:42'),
('69', '1', '', '3.000', '172.50', '55.00', '2025-08-18', '', '', '', '', '2025-08-18 20:38:46'),
('70', '1', '', '3.000', '172.50', '55.00', '2025-08-18', '', '', '', '', '2025-08-18 20:38:47'),
('71', '1', '', '4.000', '216.50', '62.00', '2025-08-18', '', '', '', '', '2025-08-18 20:39:42'),
('72', '9', '', '2.000', '150.00', '40.00', '2025-08-18', '', '', '', '', '2025-08-18 23:07:08'),
('73', '9', '', '1.000', '240.00', '10.00', '2025-08-19', 'Morning', '', '', '', '2025-08-19 18:55:26'),
('74', '99', '', '6.000', '181.25', '95.00', '2025-08-19', '', '', '', '', '2025-08-19 19:58:16'),
('75', '99', '', '6.000', '181.25', '95.00', '2025-08-19', '', '', '', '', '2025-08-19 19:58:22'),
('76', '99', '', '6.000', '181.25', '95.00', '2025-08-19', '', '', '', '', '2025-08-19 19:58:26'),
('77', '99', '', '6.000', '181.25', '95.00', '2025-08-19', '', '', '', '', '2025-08-19 19:58:27'),
('78', '99', '', '6.000', '181.25', '95.00', '2025-08-19', '', '', '', '', '2025-08-19 19:58:32'),
('79', '99', '', '6.000', '181.25', '95.00', '2025-08-19', 'Morning', 'Y', '', '', '2025-08-19 19:58:39'),
('80', '9', '', '1.000', '240.00', '10.00', '2025-08-19', '', '', '', '', '2025-08-19 19:59:05'),
('81', '9', '', '1.000', '400.00', '20.00', '2025-08-19', '', '', '', '', '2025-08-19 20:17:24'),
('82', '9', '', '1.000', '400.00', '20.00', '2025-08-19', 'Morning', '', '', '', '2025-08-19 20:18:51'),
('83', '9', '', '1.000', '400.00', '20.00', '2025-08-19', 'Morning', '', '', '', '2025-08-19 20:21:01'),
('84', '100', '', '5.000', '138.25', '61.00', '2025-08-19', 'Morning', 'Y', '', '', '2025-08-19 20:39:41'),
('85', '101', '', '5.000', '204.50', '49.00', '2025-08-19', 'Morning', 'Y', '', '', '2025-08-19 21:12:58'),
('86', '102', '', '5.000', '160.00', '42.00', '2025-08-20', 'Morning', 'Y', '', '', '2025-08-20 07:54:38'),
('87', '103', '', '5.000', '66170.00', '70.00', '2025-08-20', 'Morning', '', '', '', '2025-08-20 10:08:24'),
('88', '104', '', '7.000', '195.25', '95.00', '2025-08-20', 'Morning', '', '', '', '2025-08-20 11:19:09'),
('89', '88', '', '5.000', '130.00', '70.00', '2025-08-21', 'Morning', 'Y', '', '', '2025-08-21 08:18:32'),
('90', '105', '', '2.000', '168.00', '22.00', '2025-08-21', 'Morning', '', '', '', '2025-08-21 15:35:57'),
('91', '109', '', '10.000', '228.25', '127.00', '2025-08-23', 'Morning', '', '', '', '2025-08-23 12:36:50'),
('92', '109', '', '10.000', '228.25', '127.00', '2025-08-23', 'Morning', 'Y', '', '', '2025-08-23 12:48:22'),
('93', '115', '', '6.000', '140.00', '83.00', '2025-08-28', 'Morning', '', '', '', '2025-08-28 17:08:43'),
('94', '109', '', '11.000', '250.75', '144.00', '2025-08-29', 'Morning', 'Y', '', '', '2025-08-29 17:11:48'),
('95', '105', '', '16.000', '531.50', '215.00', '2025-08-30', 'Morning', '', '', '', '2025-08-30 10:46:21'),
('96', '101', '', '14.000', '379.00', '155.00', '2025-08-30', 'Morning', 'Y', '', '', '2025-08-30 18:10:33'),
('97', '1', '', '1.000', '450.00', '10.00', '2025-09-04', 'Morning', '', '', '', '2025-09-04 11:55:01'),
('98', '1', '', '1.000', '450.00', '10.00', '2025-09-04', 'Morning', '', '', '', '2025-09-04 11:55:22'),
('99', '1', '', '1.000', '450.00', '10.00', '2025-09-04', 'Morning', '', '', '', '2025-09-04 11:59:13'),
('100', '1', '', '1.000', '450.00', '10.00', '2025-09-04', 'Morning', '', '', '', '2025-09-04 12:00:21'),
('101', '1', '', '2.000', '490.00', '20.00', '2025-09-04', 'Morning', '', '', '', '2025-09-04 12:00:50'),
('102', '119', '', '8.000', '569.50', '175.00', '2025-09-06', 'Morning', 'Y', '', '', '2025-09-06 16:55:01'),
('103', '119', '', '6.000', '245.00', '95.00', '2025-09-07', 'Morning', 'Y', '', '', '2025-09-07 19:24:13'),
('104', '119', '', '6.000', '245.00', '95.00', '2025-09-07', 'Morning', '', '', '', '2025-09-07 19:25:39'),
('105', '115', '', '8.000', '202.50', '89.00', '2025-09-10', 'Morning', '', '', '', '2025-09-10 15:18:21'),
('106', '115', '', '8.000', '202.50', '89.00', '2025-09-10', 'Morning', '', '', '', '2025-09-10 15:19:44'),
('107', '115', '', '10.000', '248.50', '119.00', '2025-09-11', 'Morning', 'Y', '', '', '2025-09-11 14:30:22'),
('108', '1', '', '1.000', '400.00', '10.00', '2025-09-11', 'Morning', '', '', '', '2025-09-11 14:46:17'),
('109', '111', '', '8.000', '252.10', '92.00', '2025-09-12', 'Evening', '', '', '', '2025-09-12 12:23:23'),
('110', '111', '', '8.000', '252.10', '92.00', '2025-09-12', 'Morning', 'Y', '', '', '2025-09-12 12:23:54'),
('111', '119', '', '11.000', '592.75', '197.00', '2025-09-14', 'Morning', '', '', '', '2025-09-14 15:45:47'),
('112', '119', '', '11.000', '592.75', '197.00', '2025-09-14', 'Morning', '', '', '', '2025-09-14 15:47:24'),
('113', '119', '', '11.000', '592.75', '197.00', '2025-09-14', 'Morning', '', '', '', '2025-09-14 15:48:54'),
('114', '119', '', '11.000', '592.75', '197.00', '2025-09-14', 'Morning', '', '', '', '2025-09-14 15:51:25'),
('115', '111', '', '6.000', '160.50', '95.00', '2025-09-15', 'Morning', 'Y', '', '', '2025-09-15 07:37:23'),
('116', '1', '', '9.000', '209.00', '111.00', '2025-09-15', 'Morning', '', '', '', '2025-09-15 20:13:48'),
('117', '103', '', '8.000', '501.50', '92.00', '2025-09-16', 'Evening', '', '', '', '2025-09-16 12:03:04'),
('118', '1', '', '6.000', '215.50', '77.00', '2025-09-16', 'Morning', '', '', '', '2025-09-16 16:38:47'),
('119', '1', '', '6.000', '215.50', '77.00', '2025-09-16', 'Morning', '', '', '', '2025-09-16 16:40:05'),
('120', '53', '', '6.000', '217.25', '131.00', '2025-09-16', 'Morning', '', '', '', '2025-09-16 16:42:26'),
('121', '126', '', '6.000', '431.25', '124.00', '2025-09-16', 'Evening', '', '', '', '2025-09-16 17:12:05'),
('122', '126', '', '1.000', '350.00', '50.00', '2025-09-17', 'Evening', '', '', '', '2025-09-17 11:41:03'),
('123', '101', '', '9.000', '339.25', '107.00', '2025-09-18', 'Morning', 'Y', '', '', '2025-09-18 19:28:19'),
('124', '126', '', '3.000', '155.00', '60.00', '2025-09-19', 'Evening', '', '', '', '2025-09-19 11:29:20'),
('125', '115', '', '7.000', '312.50', '160.00', '2025-09-19', 'Morning', 'Y', '', '', '2025-09-19 14:36:49'),
('126', '119', '', '13.000', '628.50', '363.00', '2025-09-21', 'Morning', 'Y', '', '', '2025-09-21 13:00:09'),
('127', '126', '', '1.000', '290.00', '10.00', '2025-09-22', 'Morning', '', '', '', '2025-09-22 11:00:50'),
('128', '52', '', '6.000', '227.00', '95.00', '2025-09-23', 'Morning', '', '', '', '2025-09-23 08:58:21'),
('129', '109', '', '10.000', '284.75', '205.00', '2025-09-27', 'Morning', 'Y', '', '', '2025-09-27 15:53:02'),
('130', '119', '', '14.000', '571.25', '353.00', '2025-09-28', 'Morning', '', '', '', '2025-09-28 18:29:54'),
('131', '119', '', '7.000', '285.00', '270.00', '2025-10-05', 'Morning', 'Y', '', '', '2025-10-05 22:11:11'),
('132', '9', '', '2.000', '240.00', '30.00', '2025-11-17', 'Morning', '', '', '', '2025-11-17 18:09:18'),
('133', '9', '', '2.000', '240.00', '30.00', '2025-11-17', 'Morning', '', '', '', '2025-11-17 18:09:28');
DROP TABLE IF EXISTS products;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(200) NOT NULL,
  `oldprice` double(10,2) NOT NULL,
  `newprice` double(10,2) NOT NULL,
  `discount` int(11) NOT NULL,
  `offer` varchar(50) NOT NULL,
  `quantity` int(11) NOT NULL,
  `UOM` varchar(20) NOT NULL,
  `availablein` varchar(200) DEFAULT NULL,
  `minstock` int(11) NOT NULL,
  `photo1` varchar(200) NOT NULL,
  `photo2` varchar(50) NOT NULL,
  `photo3` varchar(50) NOT NULL,
  `createdon` datetime NOT NULL,
  `counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO products VALUES
('15', '6', '0', 'टोमॅटो', '<p><strong>Tomato (टोमॅटो) : 1 Kg</strong></p>\r\n\r\n<p>A versatile&nbsp;vegetable used&nbsp;in salads, curries, and sauces. Rich in&nbsp;<strong>Vitamin C</strong>&nbsp;and&nbsp;<strong>carotene</strong>, it&nbsp;supports collagen&nbsp;production, aiding&nbsp;<strong>skin and hair&nbsp;health</strong>.<br />\r\n<strong>Store</strong>&nbsp;at&nbsp;0&deg;C in the refrigerator.</p>\r\n', '', '67.00', '50.00', '43', '', '1000', 'Kg', 'gm', '500', 'photo1_15_2025-07-23-13-01-32.jfif', '', '', '2025-07-17 16:52:07', '1'),
('16', '6', '0', 'भोपळा', '<p><strong>भोपळा : 1 Kg&nbsp;</strong></p>\r\n\r\n<p>&nbsp;pumpkin has a sweet taste and soft texture when cooked. Commonly used in Indian curries and chutneys.<br />\r\nRich i&nbsp;<strong>Vitamin A</strong>, promoting&nbsp;<strong>eye health</strong>.</p>\r\n', '0', '190.00', '160.00', '16', '71', '1', 'Kg', 'gm', '500', 'photo1_16_2025-07-29-15-15-29.jpg', '', '', '2025-07-17 17:44:20', '1'),
('17', '6', '0', 'लसूण', '<p><strong>लसूण : 1 Kg&nbsp; &nbsp;&nbsp;</strong>An aromatic herb used globally for its strong flavor in dishes like dal and garlic bread. Contains&nbsp;<strong>multiple B-vitamins</strong>, fibre, and minerals. Acts as a&nbsp;<strong>natural antibiotic</strong>&nbsp;and aids in&nbsp;<strong>digestion</strong>.<br />\r\n<strong>Store</strong>&nbsp;in a dry, ventilated area.</p>\r\n', '0', '200.00', '170.00', '-21', '55', '1', 'Kg', 'gm', '500', 'photo1_17_2025-07-29-15-15-14.jpg', '', '', '2025-07-17 17:44:20', '1'),
('18', '6', '0', 'वांगं', '<p><strong>Varikatri Brinjal (वांगी) : 1 Kg</strong></p>\r\n\r\n<p>Deep purple, spongy-textured vegetable with edible seeds. Contains&nbsp;<strong>fiber</strong>,&nbsp;<strong>potassium</strong>, and&nbsp;<strong>antioxidants</strong>, offering protection against&nbsp;<strong>heart disease and cancer</strong>.<br />\r\n<strong>Vitamin C-rich</strong>.</p>\r\n', '0', '90.00', '80.00', '11', '65', '1', 'Kg', 'gm', '500', 'photo1_18_2025-07-29-15-14-45.jpg', '', '', '2025-07-17 17:44:20', '1'),
('19', '6', '0', 'कारले', '<p><strong>Bitter Gourd / Carly (कारले) : 1 Kg</strong></p>\r\n\r\n<p>Often used in curries or juiced for health. Known to stimulate digestion, reduce&nbsp;<strong>indigestion</strong>&nbsp;and&nbsp;<strong>constipation</strong>.<br />\r\n<strong>Store</strong>&nbsp;at 8&ndash;12&deg;C in a plastic bag in refrigerator</p>\r\n', '0', '140.00', '119.00', '-49', '19', '1', 'Kg', 'gm', '500', 'photo1_19_2025-07-29-15-14-25.png', '', '', '2025-07-17 17:44:20', '1'),
('20', '6', '0', 'गाजर', '<p><strong>Carrot (गाजर) 1 Kg</strong><br />\r\nSweet and crunchy, rich in beta-carotene, fiber, and vitamins. Enhances eye health, digestion, and immunity.<br />\r\nPerfect raw or cooked.<br />\r\nStore in refrigerator.</p>\r\n', '0', '100.00', '80.00', '56', '22', '1', 'Kg', 'gm', '500', 'photo1_20_2025-07-29-15-13-45.png', '', '', '2025-07-17 17:44:20', '1'),
('21', '6', '0', 'फ्रेश वाटाणा ( सोललेला )', '<p>फ्रेश वाटाणा ( सोललेला ) <strong>:</strong>&nbsp;1 Kg<br />\r\nPeeled green peas that are convenient for quick cooking. High in fiber and protein, they enhance the nutrient profile of many dishes.</p>\r\n', '0', '350.00', '250.00', '29', '74', '1', 'Kg', 'gm', '500', 'photo1_21_2025-07-29-15-13-31.png', '', '', '2025-07-17 17:44:20', '1'),
('22', '6', '0', 'दुधी भोपळा', '<p><strong>Bottle Gourd / Milk Pumpkin (दुधीभोपळा) : (250gm-400gm)</strong><br />\r\nLow-calorie, high-fiber veggie aiding digestion, sugar control, and constipation relief. Used in soups, dals, and saut&eacute;ed dishes.<br />\r\nStore at 4&ndash;7&deg;C in refrigerator.</p>\r\n', '0', '85.00', '80.00', '-167', '48', '100', 'Kg', 'Kg', '200', 'photo1_22_2025-07-29-15-13-12.jpg', '', '', '2025-07-17 17:44:20', '1'),
('23', '6', '0', 'काकडी', '<p><strong>Cucumber (काकडी) : 1 Kg</strong><br />\r\nHydrating and crisp, cucumbers are rich in Vitamin C, potassium, and beta-carotene. Eaten raw or pickled.<br />\r\nStore at 10&ndash;12&deg;C at room temperature for best freshness.</p>\r\n', '0', '95.00', '80.00', '33', '17', '1', 'Kg', 'gm', '500', 'photo1_23_2025-07-29-15-11-44.png', '', '', '2025-07-17 17:44:20', '1'),
('24', '6', '0', 'तिखट हिरवी मिरची ', '<p><strong>( Green Chilli) तिखट हिरवी मिरची : Kg</strong><br />\r\nEnhances flavor with spiciness while supplying antioxidants, boosting metabolism and immunity.<br />\r\nStore in refrigerator.</p>\r\n', '0', '140.00', '120.00', '14', '96', '1', 'Kg', 'gm', '500', 'photo1_24_2025-08-14-10-17-37.jpg', '', '', '2025-07-17 17:44:20', '1'),
('25', '6', '0', 'कांदा', '<p><strong>Onion (कांदे) : 1 Kg</strong><br />\r\nStaple in Indian cooking, versatile across cooking methods. Contains folic acid, Vitamin C, and amino acids, improving skin and hair health.<br />\r\nStore in mesh or wire-basket bags at 7&ndash;13&deg;C.</p>\r\n', '0', '45.00', '40.00', '-14', '81', '1', 'Kg', 'gm', '500', 'photo1_25_2025-07-29-15-11-10.png', '', '', '2025-07-17 17:44:20', '1'),
('26', '6', '0', 'भेंडी', '<p><strong>Lady Finger (भेंडी) : 1 Kg</strong><br />\r\nUsed in Indian cuisine, rich in vitamin C, folate, and fiber. Supports weight management through low-calorie content.<br />\r\nStore at 7&ndash;10&deg;C in a wrapped bag in refrigerator.</p>\r\n', '0', '100.00', '80.00', '98', '88', '1', 'Kg', 'gm', '500', 'photo1_26_2025-07-29-15-10-54.png', '', '', '2025-07-17 17:44:20', '1'),
('27', '6', '0', 'हिरवे बीन्स (घेवडा शेंग)', '<p><strong>French Beans (फरसबी) : 1 Kg</strong><br />\r\nCrisp and fresh, add to salads and stir-fries. High in iron, calcium, and fiber, promoting digestive and bone health.<br />\r\nStore in the refrigerator</p>\r\n', '0', '170.00', '160.00', '-23', '98', '100', 'Kg', 'gm', '500', 'photo1_27_2025-07-29-15-16-41.jpg', '', '', '2025-07-17 17:44:20', '1'),
('28', '6', '0', 'शिमला मिरचं (लाल, पिवळी )', '<p><strong>Capsicum &ndash; &nbsp;Red, Yellow (शिमला मिरची) : 230-250 Gm</strong><br />\r\nSweet peppers with crisp texture, used raw or cooked. Rich in Vitamins A, C, E, K, and antioxidants, enhancing immunity and eye health.<br />\r\nStore cut or wrapped at 7&ndash;13&deg;C</p>\r\n', '0', '499.00', '480.00', '-61', '96', '100', '2 pcs', '2 pcs', '500', 'photo1_28_2025-07-29-15-09-58.png', 'photo2_28_2025-09-15-20-33-45.webp', '', '2025-07-17 17:44:20', '1'),
('29', '6', '0', 'फ्लॉवर', '<p><strong>&nbsp;Cabbage (कोबी) : 1 Kg</strong><br />\r\nGreen leafy vegetable noted for folic acid, Vitamin C, and Vitamin K, aiding collagen formation and digestion.<br />\r\nUsed in salads and garnishes.</p>\r\n', '0', '100.00', '80.00', '45', '37', '1', 'Kg', 'gm', '500', 'photo1_29_2025-07-29-15-29-39.jpg', '', '', '2025-07-17 17:44:20', '1'),
('30', '6', '0', 'कोबी जांभळा ', '<p><strong>Cauliflower (फूलकोबी) : 1 Kg</strong><br />\r\nRich in fiber, antioxidants, and vitamins, it assists in immune function, digestion, and inflammation reduction. Ideal for soups, salads, or roasting.<br />\r\nStore in refrigerator.</p>\r\n', '0', '180.00', '160.00', '-33', '96', '100', 'Kg', 'gm', '500', 'photo1_30_2025-07-29-15-09-15.jpg', '', '', '2025-07-17 17:44:20', '1'),
('31', '6', '0', 'बीट', '<p><strong>Beetroot (बीट) : 1 Kg</strong><br />\r\nNaturally sweet and crimson-red, beetroot improves blood flow, digestive health, and combats inflammation.<br />\r\nStore cool and dry or in refrigerator.</p>\r\n', '0', '75.00', '65.00', '-44', '45', '1', ' Kg', 'gm', '500', 'photo1_31_2025-07-29-15-08-15.jpg', '', '', '2025-07-17 17:44:20', '1'),
('32', '6', '0', 'दोडका', '<p><strong>Ridge Gourd (दोडका) : 1 Kg</strong><br />\r\nMild and slightly sweet. Rich in fiber and folic acid, supports digestion and immunity. Used in curries and stir-fries.</p>\r\n', '0', '124.00', '110.00', '11', '93', '1', 'Kg', 'gm', '500', 'photo1_32_2025-07-23-12-55-44.jfif', '', '', '2025-07-17 17:44:20', '1'),
('33', '6', '0', 'गवार', '<p><strong>Cluster Beans (गवार) : 1 Kg</strong><br />\r\nSlightly bitter, popular in Indian cuisine. Rich in calcium, phosphorus, fiber, and folic acid, useful in blood sugar regulation.<br />\r\nStore at 5&ndash;10&deg;C in refrigerator</p>\r\n', '0', '180.00', '160.00', '-14', '47', '1', 'Kg', 'gm', '500', 'photo1_33_2025-07-29-15-07-30.jpg', '', '', '2025-07-17 17:44:20', '1'),
('34', '6', '0', 'घेवडा ', '<p><strong>घेवडा &nbsp;: 1 kg</strong></p>\r\n', '0', '100.00', '80.00', '43', '25', '100', 'Kg', 'gm', '500', 'photo1_34_2025-09-07-13-26-37.webp', '', '', '2025-07-17 17:44:20', '1'),
('35', '6', '0', 'लिंबू', '<p><strong>Lemon (लिंबू) : &nbsp;(4&nbsp;Unit 20&nbsp;rupees ]</strong><br />\r\nCitrus fruit packed with Vitamin C, enhances beauty, boosts skin health, and treats throat infections. Used widely in food and drink.<br />\r\nStore at 3&ndash;6&deg;C wrapped in plastic.</p>\r\n', '0', '25.00', '20.00', '-33', '60', '1000', '(4 Units)', 'Unit', '500', 'photo1_35_2025-07-29-14-59-06.png', 'photo2_35_2025-07-29-14-59-06.png', '', '2025-07-17 17:44:20', '1'),
('36', '6', '0', 'बटाटा', '<p><strong>Potato (बटाटा) : 1Kg</strong><br />\r\nCommon staple rich in fiber and nutrients, offers sustained energy, aids digestion, and suitable across dishes.<br />\r\nStore in refrigerator.</p>\r\n', '0', '45.00', '40.00', '-14', '26', '1', 'Kg', 'gm', '500', 'photo1_36_2025-07-29-14-58-47.png', '', '', '2025-07-17 17:44:20', '1'),
('37', '6', '0', 'चवळी', '<p><strong>Cowpea Beans (चवळी) : 1Kg</strong><br />\r\nRich in protein, fiber, and vitamins; beneficial for heart health, cholesterol, and blood sugar control.<br />\r\nStore in a cool, airtight container at 4&ndash;7&deg;C.</p>\r\n', '0', '199.00', '165.00', '-83', '48', '1', 'Kg', 'gm', '500', 'photo1_37_2025-07-29-15-28-08.jpg', '', '', '2025-07-17 17:44:20', '1'),
('38', '6', '0', 'तोंडली', '<p><strong>Ivy Gourd (तोंडले) : 1Kg</strong><br />\r\nSmall vegetable with laxative properties, high in beta-carotene and fiber, helping to regulate blood sugar.<br />\r\nUsed in stir-fries and curries.<br />\r\nStore in refrigerator, wrapped.</p>\r\n', '0', '150.00', '140.00', '-40', '48', '1', 'Kg', 'gm', '500', 'photo1_38_2025-07-29-15-12-50.jpg', '', '', '2025-07-17 17:44:20', '1'),
('39', '6', '0', 'आले', '<p><strong>Ginger (आले) :1 Kg</strong><br />\r\nPungent and aromatic. Rich in magnesium, Vitamin B6, and potassium. Known to reduce inflammation, pain, cough, and improve digestion.<br />\r\nCan be frozen for up to 6 months before grating.</p>\r\n', '0', '99.00', '90.00', '-29', '38', '1', 'Kg', 'gm', '500', 'photo1_39_2025-07-29-14-57-59.jpg', '', '', '2025-07-17 17:44:20', '1'),
('40', '6', '0', 'मक्याचे कणीस', '<p><strong>Corn (मका) : 1Kg&nbsp; &nbsp;&nbsp;</strong><br />\r\n&nbsp; Abundant in Vitamin C, iron, and carotenoids like lutein for eye health. Used in steaming or stir-fries, supports heart and immune function.</p>\r\n\r\n<p>If needed in a downloadable table or spreadsheet format, I can also provide that.</p>\r\n', '0', '110.00', '99.00', '-36', '82', '1', 'unit', 'Unit', '500', 'photo1_40_2025-07-29-15-08-43.jpg', '', '', '2025-07-17 17:44:20', '1'),
('41', '7', '0', 'केळी', '<p><strong>&nbsp;Banana :</strong></p>\r\n\r\n<p>Bananas are one of the most popular fruits in the world, easily recognized by their elongated shape, thick yellow skin that turns golden as they ripen, and creamy white flesh. They have a subtly sweet taste and soft texture, making them perfect for on-the-go snacks or for use in snacks, chips, and smoothies.</p>\r\n\r\n<p><strong>Nutritional benefits</strong> include: ● Rich in Vitamin B6 ● High in fibre ● Helps lower blood pressure ● Supports cardiovascular health ● Acts as an energy booster ● High in potassium.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Store uncovered at room temperature or in the refrigerator for several days ● Peel may turn brown but the fruit remains fine ● Ideal storage temperature: 13&ndash;16&deg;C.</p>\r\n', '0', '70.00', '60.00', '0', '11', '1', 'Dozen', 'dozen', '100', 'photo1_41_2025-07-29-14-56-45.jpg', '', '', '2025-07-17 18:06:24', '1'),
('42', '7', '0', 'पपई', '<p><strong>Papaya</strong>&nbsp; : 1 Kg</p>\r\n\r\n<p>is a delicious fruit that can be enjoyed fresh, blended into smoothies, or used in salads and desserts. It is rich in <strong>Vitamin A, C, and B6</strong>, and provides numerous health benefits.</p>\r\n\r\n<p><strong>Nutritional value and benefits</strong> include: ● Contains folic acid, Vitamin C, carotenes, amino acids ● Aids digestion ● Has anti-inflammatory properties ● Acts as a natural skin cleanser ● Boosts immunity. <strong>Storage tips</strong>: ● Refrigerate or store in a cool, dry place ● Once cut, store in airtight containers in the refrigerator ● Ideal storage temperature: 10&ndash;13&deg;C.</p>\r\n\r\n<p><strong>How to use</strong>: Perfect for snacks and salads.</p>\r\n', '0', '87.00', '80.00', '-60', '94', '1', 'UNIT', 'Unit', '100', 'photo1_42_2025-07-29-14-56-15.jpg', '', '', '2025-07-17 18:06:24', '1'),
('43', '7', '0', 'पेरू', '<p>Guava (पेरू) : 1 Kg</p>\r\n\r\n<p>is a tropical fruit, pear-shaped in appearance, with a green skin that turns yellow as it ripens. The entire fruit, including the seeds and rind, is edible. It is extremely rich in <strong>Vitamin C</strong>&mdash;in fact, guava contains nearly five times more Vitamin C than oranges including their rind.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Helps lower hypertension (high blood pressure).</p>\r\n', '0', '140.00', '80.00', '43', '84', '100', 'Kg', 'gm', '200', 'photo1_43_2025-07-29-14-55-45.jpg', '', '', '2025-07-17 18:06:24', '1'),
('44', '7', '0', 'सोललेला नारळ ', '<p><strong>Coconut (सोललेला नारळ&nbsp;): (1 Unit )&nbsp;</strong></p>\r\n\r\n<p>&nbsp;is a naturally refreshing fruit .&nbsp;It is best enjoyed fresh, offering a delicious taste straight from nature.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Rich in dietary fiber, making it beneficial for digestion and overall gut health.</p>\r\n', '0', '80.00', '45.00', '44', '65', '1', 'unit', 'Unit', '100', 'photo1_44_2025-07-29-14-54-53.jpg', '', '', '2025-07-17 18:06:24', '1'),
('45', '7', '0', 'अननस', '<p><strong>Pineapple (अननस):&nbsp; Unit 1</strong></p>\r\n\r\n<p>is a sweet, juicy, and highly nutritious fruit that makes a delicious addition to salads, juices, cocktails, and even stir-fry dishes.</p>\r\n\r\n<p><strong>Description</strong>: It&rsquo;s known for its vibrant flavor and versatility in both raw and cooked forms.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● High in antioxidants ● Packed with essential nutrients ● Considered a nutritional powerhouse.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Boosts overall wellness and immunity. <strong>How to use</strong>: Perfect for salads and juices.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Wrap in a plastic bag and store in the vegetable crisper of the refrigerator to maintain freshness ● Ideal storage temperature: 10&ndash;13&deg;C.</p>\r\n', '0', '91.00', '85.00', '-21', '34', '1', 'Unit', 'Unit', '100', 'photo1_45_2025-07-29-14-49-49.jpg', '', '', '2025-07-17 18:06:24', '1'),
('46', '7', '0', 'सफरचंद', '<p><strong>Apple (सफरचंद)</strong> &ndash; 1 kg</p>\r\n\r\n<p>Specifically the Royal Gala variety &ndash; is a sweet and crisp fruit with yellow-orange skin and red striping, known for its juicy, firm texture. It is perfect for snacking due to its balanced sweetness and refreshing taste, and also holds its shape well when cooked, making it ideal for pies, crisps, and sauces.</p>\r\n\r\n<p><strong>How to use</strong>: ● Great in snacks and salads.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Rich in dietary fiber, supporting digestion and heart health.</p>\r\n\r\n<p><strong>Storage tip</strong>: ● Store in the refrigerator to maintain freshness.</p>\r\n\r\n<p><strong>Source</strong>: ● Grown in Italy, Poland, and Kashmir.</p>\r\n', '0', '210.00', '199.00', '23', '75', '1', 'Kg', 'gm', '200', 'photo1_46_2025-07-29-14-49-27.png', '', '', '2025-07-17 18:06:24', '1'),
('47', '7', '0', 'चिकू', '<p><strong>Sapota (चकु / चिकू)</strong>, : 1 Kg</p>\r\n\r\n<p>also known as chikoo or sapodilla, is a tropical fruit with a uniquely sweet, caramel-like flavor. It is commonly enjoyed fresh as a dessert fruit and is also used in milkshakes, ice creams, and smoothies.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Contains fibre, Vitamin C, and amino acids ● Helps strengthen the immune and digestive systems ● Promotes healthy eyes and skin.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Boosts immunity.</p>\r\n\r\n<p><strong>How to use</strong>: ● Ideal for desserts, milkshakes, and smoothies.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Wrap in a plastic bag and store in the refrigerator or a cool, dry place ● Ideal storage temperature: 20&deg;C.</p>\r\n', '0', '180.00', '155.00', '-94', '35', '1', 'Kg', 'gm', '200', 'photo1_47_2025-07-29-14-48-54.jpg', '', '', '2025-07-17 18:06:24', '1'),
('48', '7', '0', 'संत्री', '<p><strong>Oranges (संत्री)</strong> &ndash;1 Kg</p>\r\n\r\n<p>specifically mini oranges or mandarins &ndash; are small citrus fruits known for their sweet, juicy flavor. They are easy to peel, contain only 2&ndash;3 seeds, and are ideal for quick, on-the-go snacking.</p>\r\n\r\n<p><strong>How to use</strong>: ● Great as an on-the-go snack or in fruit salads.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Rich in Vitamin C, supporting immunity and skin health.</p>\r\n', '0', '180.00', '161.00', '11', '26', '1', 'Kg', 'gm', '100', 'photo1_48_2025-07-29-14-48-22.jpg', '', '', '2025-07-17 18:06:24', '1'),
('49', '7', '0', 'मोसंबी', '<p><strong>Sweet Lime (मोसंबी)</strong>, 1 Kg</p>\r\n\r\n<p>also known as Mosambi, is a citrus fruit with a mild, sweet flavor and refreshing juiciness, best enjoyed fresh for a naturally thirst-quenching experience.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Rich source of Vitamin C ● Contains Vitamin A, B6, K, and amino acids ● Helps improve skin health ● Boosts the immune system ● Supports digestion.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Rich in Vitamins A, C, and B6.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Wrap in a plastic bag and store in the vegetable crisper of the refrigerator to maintain freshness.</p>\r\n', '0', '130.00', '120.00', '20', '62', '1', 'Kg', 'gm', '100', 'photo1_49_2025-07-29-14-25-14.jpg', '', '', '2025-07-17 18:06:24', '1'),
('50', '7', '0', 'बोर', '<p>बोर : 1 Kg</p>\r\n\r\n<p>It&#39;s a good source of vitamins A, C, and B6, as well as minerals like potassium, magnesium, and calcium.&nbsp;These nutrients contribute to&nbsp;improved digestion, enhanced eyesight, strengthened immunity, and better skin health.&nbsp;</p>\r\n', '0', '160.00', '150.00', '-369', '52', '0', 'Kg', 'gm', '0', 'photo1_50_2025-07-29-14-24-37.png', '', '', '2025-07-17 18:06:24', '1'),
('51', '7', '0', 'किवी', '<p><strong>Green Kiwi (किवी) : (&nbsp; pack of 3 kiwi&nbsp;)&nbsp;</strong></p>\r\n\r\n<p>is a sweet and slightly tangy fruit with vibrant green flesh that offers a tropical zing and a unique flavor. It&#39;s packed with nutrients and is an excellent addition to fruit salads and snacks.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Rich source of Vitamin C ● Contains fibre, Vitamin K, and amino acids ● Vitamin C acts as a powerful antioxidant and aids in collagen formation for healthy skin and hair ● Supports immunity and helps keep ailments at bay.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Excellent immunity booster.</p>\r\n\r\n<p><strong>How to use</strong>: ● Perfect for snacks and fruit salads.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Kiwi continues to ripen after picking&mdash;if unripe, leave on the kitchen counter for a few days ● Once ripe, refrigerate to keep fresh for several weeks ● Ideal storage temperature: 5&ndash;10&deg;C.</p>\r\n', '0', '425.00', '399.00', '6', '77', '1', 'pack', 'gm', '100', 'photo1_51_2025-07-29-14-24-06.png', 'photo2_51_2025-07-29-14-24-06.png', '', '2025-07-17 18:06:24', '1'),
('52', '7', '0', 'आंबा', '<p><strong>Mango (आंबा)</strong> &ndash; 1 Kg</p>\r\n\r\n<p>Currently, the Dasheri variety is sourced from Gujarat. This early-season mango is cherished for its exceptional sweetness, rich aroma, juicy flesh, and creamy texture. It is best enjoyed fresh as-is and is also perfect for use in salads, desserts, shakes, ice creams, and other mango-based dishes.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Boosts energy and revitalizes the body.</p>\r\n\r\n<p><strong>Season</strong>: ● Peak season fruit, available during the summer months.</p>\r\n', '0', '650.00', '399.00', '11', '18', '0', 'Kg', 'gm', '0', 'photo1_52_2025-07-29-14-23-45.jpg', '', '', '2025-07-17 18:06:24', '1'),
('53', '7', '0', 'द्राक्ष', '<p><strong>Grapes (द्राक्ष)</strong> &ndash;&nbsp; 1 Kg</p>\r\n\r\n<p>Often referred to as the &quot;queen of fruits,&quot; green grapes are small, juicy, round berries with a naturally sweet taste. They make a refreshing addition to fruit and vegetable salads and are also popular as toppings on fruit cakes and pastries.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Helps boost metabolism.</p>\r\n\r\n<p><strong>Storage tip</strong>: ● Store in the refrigerator to maintain freshness and extend shelf life.</p>\r\n', '0', '250.00', '199.00', '-99', '75', '0', 'Kg', 'gm', '100', 'photo1_53_2025-07-23-12-43-29.jfif', '', '', '2025-07-17 18:06:24', '1'),
('54', '7', '0', 'सीताफळ', '<p>सीताफळ : 1 Kg</p>\r\n\r\n<p>It&#39;s a good source of vitamins A, C, and B6, as well as minerals like potassium, magnesium, and calcium.&nbsp;These nutrients contribute to&nbsp;improved digestion, enhanced eyesight, strengthened immunity, and better skin health.&nbsp;</p>\r\n', '0', '150.00', '100.00', '52', '12', '1', 'Kg', 'gm', '100', 'photo1_54_2025-07-29-14-22-19.png', 'photo2_54_2025-07-29-14-22-19.jpg', '', '2025-07-17 18:06:24', '1'),
('55', '7', '0', 'ब्लॅकबेरी', '<p><strong>Blackberry </strong>&ndash; <strong>1 Kg</strong></p>\r\n\r\n<p>Also known as black plum, Jamun is a deep purple-colored fruit with a sweet and tangy flavor. It is commonly enjoyed fresh as a seasonal snack or used to prepare refreshing juices and desserts, especially during the summer. Jamun is valued for its unique taste and numerous health benefits.</p>\r\n\r\n<p><strong>How to use</strong>: ● Ideal as a fresh snack.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Enhances skin and hair health.</p>\r\n', '0', '350.00', '300.00', '-285', '11', '0', 'Kg', 'gm', '0', 'photo1_55_2025-07-29-14-21-18.jpg', '', '', '2025-07-17 18:06:24', '1'),
('56', '7', '0', 'खरबूज ', '<p><strong>Muskmelon</strong> &ndash; 1 Kg</p>\r\n\r\n<p>The Kiran variety is a small to medium-sized musk melon&nbsp;with a dark green rind and emerald-black undertones. Its dark yellow&nbsp;flesh is crisp, slightly grainy, and offers a light, sweet, and refreshing taste. It is perfect for slicing and enjoying chilled.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Rich in water content ● Contains carotenoids and amino acids ● Improves insulin sensitivity ● Reduces muscle soreness ● Keeps the body hydrated.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Helps reduce inflammation.</p>\r\n\r\n<p>&nbsp;</p>\r\n', '0', '160.00', '149.00', '-181', '2', '1', 'Kg', 'gm', '100', 'photo1_56_2025-08-06-15-25-23.webp', '', '', '2025-07-17 18:06:24', '1'),
('57', '7', '0', 'डाळिंब', '<p><strong>Pomegranate (डाळिंब)</strong> &ndash; 1 Kg&nbsp;</p>\r\n\r\n<p>Pomegranate contains juicy clusters of sparkling, opaque, red-colored seeds with a naturally sweet taste. It is popularly used for garnishing desserts, making fresh juice, or adding to fruit salads.</p>\r\n\r\n<p><strong>How to use</strong>: ● Ideal for garnish, juices, and fruit salads.</p>\r\n', '0', '220.00', '199.00', '10', '88', '1', 'Kg', 'gm', '100', 'photo1_57_2025-07-29-14-20-31.png', '', '', '2025-07-17 18:06:24', '1'),
('58', '7', '0', 'स्ट्रॉबेरी', '<p>स्ट्रॉबेरी : 1 Kg</p>\r\n\r\n<ul>\r\n	<li>Strawberries are packed with vitamin C. ...</li>\r\n	<li>Strawberries may improve heart health. ...</li>\r\n	<li>Strawberries contain fiber. ...</li>\r\n	<li>Strawberries support brain health. ...</li>\r\n	<li>Strawberries contain folate. ...</li>\r\n	<li>Strawberries are naturally sweet and low in calories. ...</li>\r\n	<li>Strawberries can reduce inflammation.</li>\r\n</ul>\r\n', '0', '400.00', '350.00', '-338', '92', '0', 'Kg', 'gm', '0', 'photo1_58_2025-07-29-14-08-04.jpg', '', '', '2025-07-17 18:06:24', '1'),
('59', '7', '0', 'कलिंगड', '<p><strong>Watermelon (कलिंगड / टरबूज)</strong> &ndash; 1 Unit</p>\r\n\r\n<p>The Kiran variety is a small to medium-sized watermelon with a dark green rind and emerald-black undertones. Its dark red flesh is crisp, slightly grainy, and offers a light, sweet, and refreshing taste. It is perfect for slicing and enjoying chilled.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Rich in water content ● Contains carotenoids and amino acids ● Improves insulin sensitivity ● Reduces muscle soreness ● Keeps the body hydrated.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Helps reduce inflammation. <strong>How to use</strong>: ● Best enjoyed sliced and chilled.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Can be stored at room temperature when whole ● Refrigerate after cutting to maintain freshness ● Ideal storage temperature: 10&ndash;15&deg;C.</p>\r\n', '0', '93.00', '80.00', '-86', '66', '1', 'Unit', 'Unit', '0', 'photo1_59_2025-07-29-14-07-28.jpg', '', '', '2025-07-17 18:06:24', '1'),
('60', '7', '0', 'अंजीर', '<p><strong>अंजीर : 1 Kg</strong></p>\r\n\r\n<p>Anjeer is also considered an antioxidant powerhouse, helping combat oxidative stress. It neutralizes free radicals, protects cells from damage, and reduces your risks for certain diseases. Aid In Weight Management: Anjeer is the healthiest option to maintain overall body weight.</p>\r\n', '0', '300.00', '250.00', '-209', '44', '0', 'Kg', 'gm', '500', 'photo1_60_2025-07-29-14-06-26.jpg', '', '', '2025-07-17 18:06:24', '1'),
('61', '7', '0', 'जांभुळ', '<p>जांभुळ : 1 Kg</p>\r\n\r\n<ul>\r\n	<li>Low On Calories: Jamun is the first choice for those on low calorie diet as it has a very minimal amount of glucose and fructose. ...</li>\r\n	<li>Fibre Rich: ...</li>\r\n	<li>Loaded With Vitamin C: ...</li>\r\n	<li>High On Iron:</li>\r\n</ul>\r\n', '0', '300.00', '250.00', '-510', '35', '0', 'Kg', 'gm', '0', 'photo1_61_2025-07-29-14-02-50.png', '', '', '2025-07-17 18:06:24', '1'),
('62', '7', '0', 'लिची', '<p><strong>Litchi (लिची)</strong> &ndash; 1 Kg&nbsp; Litchis are juicy and aromatic tropical fruits that contain several beneficial nutrients including potassium, copper, Vitamin C, and powerful antioxidants like epicatechin and rutin. These compounds may help protect against heart disease, cancer, and diabetes.</p>\r\n\r\n<p><strong>How to use</strong>: ● Perfect for snacking.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Rich in Vitamin C, supporting immunity and skin health.</p>\r\n', '0', '250.00', '230.00', '-1050', '1', '0', 'Kg', 'gm', '100', 'photo1_62_2025-07-29-14-02-32.jpg', '', '', '2025-07-17 18:06:24', '1'),
('63', '7', '0', 'आवळा', '<p><strong>Amla (आवळा)</strong> &ndash;&nbsp; 1 Kg</p>\r\n\r\n<p>Also known as Indian Gooseberry, Amla has a tangy and sour taste and is highly valued for its medicinal and nutritional properties. It is commonly used in culinary preparations like chutneys, pickles, juices, and candies, and is also widely incorporated into hair and skincare products for its nourishing effects.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Aids digestion and promotes gut health.</p>\r\n', '0', '180.00', '160.00', '-202', '74', '1', 'Kg', 'gm', '500', 'photo1_63_2025-07-29-14-02-09.png', '', '', '2025-07-17 18:06:24', '1'),
('64', '7', '0', 'नाशपाती (Pear)', '<p><strong>Packham Pear (नाशपाती)</strong> &ndash; 1 Kg</p>\r\n\r\n<p>Pear is a sweet and juicy fruit, characterized by its narrow top near the stalk and a wider, rounded bottom. It has soft white flesh with thin green or yellow skin.</p>\r\n\r\n<p><strong>Nutrient value and benefits</strong>: ● Contains fibre, Vitamin K, and amino acids ● Rich in Vitamin C, which improves skin health, boosts immunity, and supports digestion.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Helps reduce inflammation.</p>\r\n\r\n<p><strong>How to use</strong>: ● Ideal for snacks and baking.</p>\r\n', '0', '300.00', '249.00', '17', '13', '1', 'Kg', 'gm', '500', 'photo1_64_2025-07-29-14-01-55.png', '', '', '2025-07-17 18:06:24', '1'),
('65', '7', '0', 'करवंद', '<p>करवंद 1 Kg</p>\r\n', '0', '0.00', '0.00', '0', '51', '0', 'Kg', 'gm', '0', 'photo1_65_2025-08-07-14-05-11.jpg', '', '', '2025-07-17 18:06:24', '1'),
('66', '7', '0', 'रामफळ', '<p>रामफळ : 1 Kg</p>\r\n\r\n<ul>\r\n	<li>Nutrient-Rich: Ramphal is packed with essential nutrients, including vitamin C, vitamin A, dietary fiber, and potassium.</li>\r\n	<li>Digestive Health: The dietary fiber in ramphal aids digestion and promotes a healthy gut by preventing constipation and supporting regular bowel movements.</li>\r\n</ul>\r\n', '0', '140.00', '120.00', '0', '84', '0', 'Kg', 'gm', '0', 'photo1_66_2025-07-29-14-00-35.png', '', '', '2025-07-17 18:06:24', '1'),
('67', '7', '0', 'ड्रॅगनफळ', '<p><strong>Dragon Fruit (ड्रॅगनफळ)</strong> &ndash; <strong>1 KG</strong> Dragon fruit has a vibrant, scaly outer skin that encloses sweet white or red flesh speckled with black seeds. It is enjoyed fresh as-is or used in smoothies and mocktails. <strong>Nutrient value and benefits</strong>: ● Contains Vitamin C and carotenoids ● Rich in antioxidants that support overall health.</p>\r\n\r\n<p><strong>Health benefit</strong>: ● Boosts immunity and helps fight free radicals.</p>\r\n\r\n<p><strong>How to use</strong>: ● Ideal for snacks and desserts.</p>\r\n\r\n<p><strong>Storage tips</strong>: ● Store in a cool, dry place ● Ideal storage temperature: 10&deg;C.</p>\r\n', '0', '200.00', '180.00', '18', '32', '1', 'Kg', 'gm', '500', 'photo1_67_2025-07-29-14-00-12.png', '', '', '2025-07-17 18:06:24', '1'),
('68', '9', '0', 'म्हशीचे दूध', '<p>म्हशीचे दूध</p>\r\n\r\n<p>These nutrients contribute to&nbsp;strong bones and muscles, improved heart health, and potential weight management.&nbsp;It can also support brain health, enhance skin health, and potentially aid in relaxation and sleep.&nbsp;</p>\r\n', '0', '120.00', '90.00', '25', '92', '0', 'Liter', 'Unit', '0', 'photo1_68_2025-07-23-12-38-30.jfif', '', '', '2025-07-17 18:09:59', '1'),
('69', '9', '0', 'गाईचे दूध', '<p>गाईचे दूध</p>\r\n\r\n<p>Cow milk&nbsp;supports bone and muscle strength, can aid in weight management, and may reduce the risk of certain diseases.&nbsp;</p>\r\n', '0', '79.00', '70.00', '11', '66', '0', 'Liter', 'Unit', '0', 'photo1_69_2025-07-23-12-38-18.jfif', '', '', '2025-07-17 18:09:59', '1'),
('70', '8', '0', 'लाकडी घाणा नैसर्गिक शेंगदाणा तेल ', '<p>लाकडी घाणा नैसर्गिक शेंगदाणा तेल : 1 ltr</p>\r\n\r\n<p>offers several health benefits due to its rich composition of&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;sxsrf=AE3TifMpWjUO9mKN3xm-wcIcb_jgkKS7MQ%3A1754655698799&amp;q=monounsaturated+and+polyunsaturated+fats&amp;sa=X&amp;ved=2ahUKEwis4oTtmfuOAxVBRmcHHRrUJ7UQxccNegQIHhAC&amp;mstk=AUtExfDDd2TLkZdRlVNv5BJln7-pUSR3mG2NgsB5CPrSxcwBfZmX2lxCOEtJM2rUrMCRPqMCJTqooeYetdh2zY2GnEkfEr3YXM-BKxPGDB3yVokX-cM494v768l_3ruu7j3LrPXHmeQchFh_tO0Q8yhwWFAph1DClJO8xRr5Eyellevx1anODIBpq0nIm3flJm6S4u_odLszkvUzQc8FRUQK_g5lF9ZfrBSyHs_gtutPuGogXe5hsct37kt9aWvKwueIgDwP7FKQ4N3QYZexpCJNvfIte7MgTJLDnTsgKC7d1svWk6HbqaamH24ueEfnzxhBp8TmKnuMFkEa0XSnVD_oDZdgJfaPWzYP4sMiP7bKIC-s-zWaIuUw8z79rhD8DIzOxufiS-FP_qXR3rP1iRrzbJXv6yQVScg0ORgY65MQCS6MtYAgEiCXurR0kQkrhKRf&amp;csui=3\" target=\"_blank\">monounsaturated and polyunsaturated fats</a>,&nbsp;antioxidants like&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;sxsrf=AE3TifMpWjUO9mKN3xm-wcIcb_jgkKS7MQ%3A1754655698799&amp;q=Vitamin+E&amp;sa=X&amp;ved=2ahUKEwis4oTtmfuOAxVBRmcHHRrUJ7UQxccNegQIHhAD&amp;mstk=AUtExfDDd2TLkZdRlVNv5BJln7-pUSR3mG2NgsB5CPrSxcwBfZmX2lxCOEtJM2rUrMCRPqMCJTqooeYetdh2zY2GnEkfEr3YXM-BKxPGDB3yVokX-cM494v768l_3ruu7j3LrPXHmeQchFh_tO0Q8yhwWFAph1DClJO8xRr5Eyellevx1anODIBpq0nIm3flJm6S4u_odLszkvUzQc8FRUQK_g5lF9ZfrBSyHs_gtutPuGogXe5hsct37kt9aWvKwueIgDwP7FKQ4N3QYZexpCJNvfIte7MgTJLDnTsgKC7d1svWk6HbqaamH24ueEfnzxhBp8TmKnuMFkEa0XSnVD_oDZdgJfaPWzYP4sMiP7bKIC-s-zWaIuUw8z79rhD8DIzOxufiS-FP_qXR3rP1iRrzbJXv6yQVScg0ORgY65MQCS6MtYAgEiCXurR0kQkrhKRf&amp;csui=3\" target=\"_blank\">Vitamin E</a>,&nbsp;and&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;sxsrf=AE3TifMpWjUO9mKN3xm-wcIcb_jgkKS7MQ%3A1754655698799&amp;q=resveratrol&amp;sa=X&amp;ved=2ahUKEwis4oTtmfuOAxVBRmcHHRrUJ7UQxccNegQIHhAE&amp;mstk=AUtExfDDd2TLkZdRlVNv5BJln7-pUSR3mG2NgsB5CPrSxcwBfZmX2lxCOEtJM2rUrMCRPqMCJTqooeYetdh2zY2GnEkfEr3YXM-BKxPGDB3yVokX-cM494v768l_3ruu7j3LrPXHmeQchFh_tO0Q8yhwWFAph1DClJO8xRr5Eyellevx1anODIBpq0nIm3flJm6S4u_odLszkvUzQc8FRUQK_g5lF9ZfrBSyHs_gtutPuGogXe5hsct37kt9aWvKwueIgDwP7FKQ4N3QYZexpCJNvfIte7MgTJLDnTsgKC7d1svWk6HbqaamH24ueEfnzxhBp8TmKnuMFkEa0XSnVD_oDZdgJfaPWzYP4sMiP7bKIC-s-zWaIuUw8z79rhD8DIzOxufiS-FP_qXR3rP1iRrzbJXv6yQVScg0ORgY65MQCS6MtYAgEiCXurR0kQkrhKRf&amp;csui=3\" target=\"_blank\">resveratrol</a>.&nbsp;It can contribute to heart health by&nbsp;lowering bad cholesterol and potentially reducing the risk of heart disease.</p>\r\n', '0', '400.00', '350.00', '13', '76', '1', 'Kg', 'Unit', '300', 'photo1_70_2025-07-23-12-38-07.jfif', '', '', '2025-07-17 18:12:46', '1'),
('71', '8', '0', 'करडईतेल', '<p>करडईतेल : 1 Litr</p>\r\n\r\n<p>Kardai tel, also known as&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;cs=0&amp;sxsrf=AE3TifNN7dnAWCVvFKaCPR7C3r6uFZhPag%3A1754655637675&amp;q=safflower+oil&amp;sa=X&amp;ved=2ahUKEwjS39DPmfuOAxUwRmcHHVHvLAsQxccNegQIAhAB&amp;mstk=AUtExfDngcjwn62WDPqcP2X-OszZRiGjavZ37RUKVIwss5b5aNRevnOhAvLh3MfuPSrOawfC8PblMJfZFo64zgppmgzcZsJ7ArGDl8kZBUBi3bqoDfehy5ClCUIK2uJdIJEUX0C70_yNsJmc17jl5tj9AMdC2GSYRM98gP93IjqvpD0OPKnAgfZB9eojApuf05lh24FmkacdbgvxAhfkXGZDDdZnAVgZKafDieBwm-tqV6oMvEtIFr_sPgRWLwiTx6g8i4_C7Pax4kAlVVFsD2iu0h1UZDugSlcxtW05SMYs1anEksWhAsaAggGfrRQYCZCv-WN0SD5fVhRkXGTkY8p_nmH_xHZezD2QdQphDsHYZYNnyY4tM2Vz016QqeZf9Nrgu_dmTnMt3uvCOB3wM4DzyaTQiPK_W6jDJthoryXJkt4d5xC4B0yDpyC4xc8WOGnn&amp;csui=3\" target=\"_blank\">safflower oil</a>,&nbsp;offers several health benefits due to its rich content of unsaturated fatty acids, particularly&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;cs=0&amp;sxsrf=AE3TifNN7dnAWCVvFKaCPR7C3r6uFZhPag%3A1754655637675&amp;q=linoleic+acid&amp;sa=X&amp;ved=2ahUKEwjS39DPmfuOAxUwRmcHHVHvLAsQxccNegQIAhAC&amp;mstk=AUtExfDngcjwn62WDPqcP2X-OszZRiGjavZ37RUKVIwss5b5aNRevnOhAvLh3MfuPSrOawfC8PblMJfZFo64zgppmgzcZsJ7ArGDl8kZBUBi3bqoDfehy5ClCUIK2uJdIJEUX0C70_yNsJmc17jl5tj9AMdC2GSYRM98gP93IjqvpD0OPKnAgfZB9eojApuf05lh24FmkacdbgvxAhfkXGZDDdZnAVgZKafDieBwm-tqV6oMvEtIFr_sPgRWLwiTx6g8i4_C7Pax4kAlVVFsD2iu0h1UZDugSlcxtW05SMYs1anEksWhAsaAggGfrRQYCZCv-WN0SD5fVhRkXGTkY8p_nmH_xHZezD2QdQphDsHYZYNnyY4tM2Vz016QqeZf9Nrgu_dmTnMt3uvCOB3wM4DzyaTQiPK_W6jDJthoryXJkt4d5xC4B0yDpyC4xc8WOGnn&amp;csui=3\" target=\"_blank\">linoleic acid</a>.&nbsp;It is known to&nbsp;help with heart health, blood sugar regulation, and skin health.&nbsp;Additionally, it can be used for cooking due to its high smoke point.&nbsp;</p>\r\n', '0', '410.00', '370.00', '-30', '81', '1', 'Kg', 'Unit', '300', 'photo1_71_2025-07-23-12-37-48.jfif', '', '', '2025-07-17 18:12:46', '1'),
('73', '8', '0', 'लाकडी घाणा सूर्यफूल तेल ', '<p><strong>लाकडी घाणा सूर्यफूल तेल&nbsp;&nbsp;: 1 Ltr</strong></p>\r\n\r\n<p>&quot;Suryful&quot; oil, offers various health benefits due to its rich content of&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;cs=0&amp;sxsrf=AE3TifMOslilr0tJXPxaYz7vqnCx4bkJwQ%3A1754655541344&amp;q=vitamins&amp;sa=X&amp;ved=2ahUKEwie_tmhmfuOAxWxyzgGHQofH2wQxccNegQIBRAB&amp;mstk=AUtExfCvVvU52MpotHMH7iBI6n73nWbwNZnpqmKlqC68LhiB6enwnjKWhyG1-f7oWpAwboc95myWgUy6R1JJyQDDCy1dh4nZ0IC-3hAaK0hD8l-2M0YvRVcVsl840SFTbZ6uqRO_uMLqRzFM_fl0fBl2jsto3gFlts8iipGi8CyZ03v8v_Q9KGuLA0hQbMcdbD0p9n6WekHjvnU0zPZFPqPfMMrYEXNt1RXgNdkszW2e8ctqKuqygqQN2HQfF7k0qprcRWfqKIWz8DYaX-KISW_tDs17zmZrkBMWT_hgw_hBpjpueh0wsDYOHG52TyjRQTsfSFX1ugT7Lr0jS3WrKdbvGD0KOxFmeVfinGkoSVq-uSF7noEd-r4JP59Go2FCyHcNmMIwYNJMnecOUK_yGEFTVChORYU8m20gcS-a42oyO4-37xsq5QtsFK0-t6raF2_F&amp;csui=3\" target=\"_blank\">vitamins</a>,&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;cs=0&amp;sxsrf=AE3TifMOslilr0tJXPxaYz7vqnCx4bkJwQ%3A1754655541344&amp;q=antioxidants&amp;sa=X&amp;ved=2ahUKEwie_tmhmfuOAxWxyzgGHQofH2wQxccNegQIBRAC&amp;mstk=AUtExfCvVvU52MpotHMH7iBI6n73nWbwNZnpqmKlqC68LhiB6enwnjKWhyG1-f7oWpAwboc95myWgUy6R1JJyQDDCy1dh4nZ0IC-3hAaK0hD8l-2M0YvRVcVsl840SFTbZ6uqRO_uMLqRzFM_fl0fBl2jsto3gFlts8iipGi8CyZ03v8v_Q9KGuLA0hQbMcdbD0p9n6WekHjvnU0zPZFPqPfMMrYEXNt1RXgNdkszW2e8ctqKuqygqQN2HQfF7k0qprcRWfqKIWz8DYaX-KISW_tDs17zmZrkBMWT_hgw_hBpjpueh0wsDYOHG52TyjRQTsfSFX1ugT7Lr0jS3WrKdbvGD0KOxFmeVfinGkoSVq-uSF7noEd-r4JP59Go2FCyHcNmMIwYNJMnecOUK_yGEFTVChORYU8m20gcS-a42oyO4-37xsq5QtsFK0-t6raF2_F&amp;csui=3\" target=\"_blank\">antioxidants</a>,&nbsp;and unsaturated fats.&nbsp;These components contribute to&nbsp;heart health, skin and hair vitality, and overall well-being</p>\r\n', '0', '400.00', '350.00', '-27', '60', '1', 'Kg', 'Unit', '300', 'photo1_73_2025-07-23-12-37-24.jfif', '', '', '2025-07-17 18:12:46', '1'),
('74', '8', '0', 'राईस ब्रॅन ऑईल', '<p><strong>राईस ब्रॅन ऑईल :&nbsp;</strong></p>\r\n\r\n<p>Rice bran oil offers a variety of potential health and beauty benefits.&nbsp;It&#39;s&nbsp;rich in antioxidants, including Vitamin E and gamma-oryzanol, which can help protect against cell damage and promote heart health.</p>\r\n', '0', '565.00', '550.00', '0', '30', '1', 'Kg', 'Unit', '0', 'photo1_74_2025-07-23-12-37-12.jfif', '', '', '2025-07-17 18:12:46', '1'),
('75', '10', '0', 'पांढरा वाटाणा ', '<p>&nbsp;पांढरा वाटाणा&nbsp; - 1 kg</p>\r\n\r\n<p>White peas, also known as&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;sxsrf=AE3TifNgsHykqqplew6dgyF8GwHbEbahhg%3A1754655389704&amp;q=safed+matar&amp;sa=X&amp;ved=2ahUKEwiMotPZmPuOAxWxxDgGHVq7CjwQxccNegQIGRAB&amp;mstk=AUtExfBYAC4J6eD2qY67FEXs35JLQPZ_N0fKZx-cWyAby4ybESwE3ZHtMoKoBXKxWpU_2HX6NnIA96aqVMf8EU8HWGdlMoZrcd-7NVGjosAliyDY926GZF-6efhpdq9GvkqdqyT_NHam6SwiM-JFJmeFCF5qN7Ul837CoP5NH3FoZcAnUaU-HEr0qr3dgq9QaUoOUzNjxb6D1jEFviZf2VvvxyuTXpYUsD6awLwAbVbC9OKYCWPxAGuOGsq-oYSZ9IOgB9oBqlx1a98g2W4bDR0jXwevKLW0oRGbGC_ieJaOx8Yoo_nvFudejbPzskxMzDR9zc-AwHa1iOFP_je1j3HBHzXdC27ZQom27bccOcnfWa4CwBofj3hFSDSY8yLV-b84XupFA9jdWkDSdUoqr-kV9Izt8ssTVmP42ksJKcWyM2_fRsozi_BJocXxtT0hWoAq&amp;csui=3\" target=\"_blank\">safed matar</a>,&nbsp;offer a variety of health benefits due to their rich nutritional profile.&nbsp;They are&nbsp;a good source of protein, fiber, and various vitamins and minerals, making them a valuable addition to a balanced diet.&nbsp;</p>\r\n', '0', '160.00', '140.00', '0', '97', '1', 'kg', 'gm', '50', 'photo1_75_2025-07-29-13-59-44.png', '', '', '2025-07-17 18:16:49', '1'),
('76', '10', '0', 'वाटाणा भिजवलेला ', '<p>&nbsp;वाटाणा भिजवलेला&nbsp; - 1 Kg</p>\r\n\r\n<p>They are a good source of vitamins A, C, and K, folate, and antioxidants.&nbsp;They also contain minerals like potassium, iron, and calcium, as well as protein and fiber.&nbsp;These nutrients contribute to various health benefits, including&nbsp;boosting the immune system, supporting blood sugar control, and potentially reducing the risk of certain cancers.&nbsp;</p>\r\n', '0', '180.00', '160.00', '0', '22', '1', 'kg', 'gm', '100', 'photo1_76_2025-07-29-15-25-17.png', '', '', '2025-07-17 18:16:49', '1'),
('77', '10', '0', 'हरभरा', '<p>हरभरा - 1 kg</p>\r\n\r\n<p>&nbsp;It&#39;s&nbsp;a good source of protein, fiber, and various vitamins and minerals, contributing to heart health, weight management, and improved digestion.</p>\r\n', '0', '160.00', '140.00', '13', '12', '1', 'kg', 'gm', '100', 'photo1_77_2025-07-23-12-36-27.jfif', '', '', '2025-07-17 18:16:49', '1'),
('78', '10', '0', 'वाटाणा (हिरवा)', '<p>वाटाणा (&nbsp;हिरवा) - 1 Kg</p>\r\n\r\n<p>&nbsp;They are&nbsp;a good source of protein, fiber, and various vitamins and minerals, contributing to heart health, weight management, and improved digestion.&nbsp;</p>\r\n', '0', '160.00', '150.00', '6', '80', '1', 'kg', 'gm', '100', 'photo1_78_2025-07-23-12-36-00.jfif', '', '', '2025-07-17 18:16:49', '1'),
('79', '11', '82', 'Pulav Pack', '<p>Pulav pack of vegetable with Flower,Carrot ,mutter and Beans :<strong> 800 gm&nbsp;</strong></p>\r\n', '0', '160.00', '149.00', '1', '0', '1', 'Pack', 'Unit', '1', 'photo1_79_2025-08-08-15-20-21.webp', '', '', '2025-08-04 07:07:57', '1'),
('80', '11', '82', 'Pavbhaji Pack', '<p>Combo Pack of&nbsp; Paavbhaji<strong> 1 Kg</strong></p>\r\n\r\n<p>Flower, Potato, Shimla, Matar, Tomato for Pavbhaji</p>\r\n', '0', '280.00', '150.00', '46', '0', '1', 'Pack', 'Unit', '1', 'photo1_80_2025-08-08-15-36-55.jpg', '', '', '2025-08-04 07:19:48', '1'),
('81', '11', '82', 'Chatani Pack', '<p>Chatani PAck of Mirchi - 100 Gm</p>\r\n\r\n<p>&nbsp;Kothimbir, Pudina, KAdhipatta - 80&nbsp;Gm</p>\r\n', '0', '100.00', '80.00', '50', '0', '1', 'Pack', 'Unit', '100', 'photo1_81_2025-08-04-07-27-56.png', '', '', '2025-08-04 07:27:56', '1'),
('82', '11', '82', 'Veg Combo PAck', '<p>Combo PAck of Potato - 1 kg&nbsp;Tomato- 1kg&nbsp;Onion - 1kg</p>\r\n', '0', '140.00', '120.00', '14', '0', '1', 'Pack', 'Unit', '100', 'photo1_82_2025-08-04-07-32-30.jpg', '', '', '2025-08-04 07:32:30', '1'),
('83', '6', '82', 'कोथिंबीर ', '<p><strong>कोथिंबीर : </strong></p>\r\n\r\n<p>Coriander&nbsp;<strong>contains vitamin A, which helps feed your retinas, keep your eyes moist, and generally helps protect your vision</strong>. Coriander is also full of vitamin C, which is important to your immune system. Consuming enough vitamin C helps keep your white blood cells in working order and assists in the absorption of iron.19 Dec 2</p>\r\n', '0', '25.00', '20.00', '-33', '0', '1', 'Gaddi', 'Unit', '300', 'photo1_83_2025-08-06-16-57-59.jpg', '', '', '2025-08-06 16:57:57', '1'),
('84', '6', '82', 'पालक ', '<p><strong>पालक :</strong></p>\r\n\r\n<p>&nbsp;Nutrition and health sites say spinach can help&nbsp;boost immunity, improve heart health, aid digestion, support bone health, and promote healthy skin and hair.&nbsp;</p>\r\n', '0', '33.00', '30.00', '-20', '0', '100', 'Gaddi', 'Unit', '300', 'photo1_84_2025-08-06-17-00-36.webp', '', '', '2025-08-06 17:00:36', '1'),
('85', '6', '82', 'मेथी ', '<p><strong>मेथी :</strong></p>\r\n\r\n<p>Fenugreek, also known as methi, offers a range of health benefits, including&nbsp;blood sugar regulation, improved digestion, and enhanced lactation.&nbsp;</p>\r\n', '0', '60.00', '50.00', '-11', '0', '100', 'Gaddi', 'Unit', '500', 'photo1_85_2025-08-06-17-07-15.webp', '', '', '2025-08-06 17:07:15', '1'),
('86', '6', '82', 'शेपु ', '<p><strong>शेपु :</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Shepu, also known as dill or&nbsp;<a href=\"https://www.google.com/search?sca_esv=6803a1afa38366d6&amp;rlz=1C1VDKB_enIN1172IN1172&amp;sxsrf=AE3TifPVeBUofMgdXR50hpenRXBktOFFrg%3A1754654772736&amp;q=suva+bhaji&amp;sa=X&amp;ved=2ahUKEwihw7qzlvuOAxU24TgGHd0JE54QxccNegQIHRAB&amp;mstk=AUtExfDBXfFf8aKA3Yy4DxDqCgaU_eqcc-cj51PVRq5iiJkAj_e8HAABp3uCkHlH1sWAc136UE0cntU5hQCQbfuyMwr-Ta9mWEHykeeLSIOVCicskYVjO6lJnBeOJL4EQrBXFnEq-BtFiyYEIL6C37NbN1km7d1nH-5xuQfxceqYqlQOFio-NVGvTi2HcSCs1hfdoVBL52qS02QpFgnWMHctbZzXb6umrxqdEH71X1XwJo8tqitPejtgVIz4zGnPME-TA0zwddgONok1NN1BSXa1l7ynhckU944kaRIMQyjkdEzy3KX5F9STaUj-djFDBJh3JcCNawye7hLJ4TasHSuRM-IQaD3vphOPP7rB-uryocrUcmZm4urH84QAfq50VKMM618mbmwrX35xLX8sHWW8TjP7gvMr4DoIRWMUcevLWPn3cmP5XepTWjWTbOA9TtpW&amp;csui=3\" target=\"_blank\">suva bhaji</a>,&nbsp;offers numerous health benefits due to its rich nutrient profile.&nbsp;It&#39;s&nbsp;low in calories and packed with vitamins A and C, aiding in immune support and antioxidant protection.&nbsp;Additionally, dill is known for its potential to improve bone health, regulate blood sugar, and even aid in weight management.&nbsp;</p>\r\n', '0', '30.00', '20.00', '33', '0', '1', 'Gaddi', 'Unit', '1000', 'photo1_86_2025-08-06-17-10-08.webp', '', '', '2025-08-06 17:10:08', '1'),
('87', '6', '82', 'शेवगा ', '<p><strong>शेवगा :</strong></p>\r\n\r\n<p>Drumstick being an incredible source of essential mineral&#39;s calcium, iron and phosphorus, strengthens the bones in growing children. Regular addition of drumstick in the diet also reinstate bone density in older people and easing the symptoms of osteoporosis.</p>\r\n', '0', '170.00', '160.00', '-19', '0', '1', 'Kg', 'gm', '100', 'photo1_87_2025-08-06-17-13-06.webp', '', '', '2025-08-06 17:13:03', '1'),
('88', '6', '82', 'ब्रोकोली ', '<p><strong>ब्रोकोली :</strong></p>\r\n\r\n<p>Broccoli offers numerous health benefits due to its rich nutrient profile.&nbsp;It&#39;s packed with vitamins (C, K, A), minerals (potassium, calcium, iron), and antioxidants, which contribute to various aspects of well-being, including&nbsp;heart health, bone health, and eye health.&nbsp;</p>\r\n', '0', '450.00', '280.00', '38', '0', '1', 'Kg', 'gm', '100', 'photo1_88_2025-08-06-17-16-13.jpg', '', '', '2025-08-06 17:16:13', '1'),
('90', '6', '82', 'बेबी स्वीट कॉर्न ', '<p><strong>बेबी स्वीट कॉर्न :&nbsp; &nbsp;&nbsp;</strong></p>\r\n\r\n<p>Baby corn offers several health benefits due to its low calorie and high nutrient content.&nbsp;It&#39;s&nbsp;a good source of vitamins A, C, and B, as well as minerals like potassium and iron.&nbsp;Baby corn is also rich in dietary fiber, which aids digestion and promotes a feeling of fullness.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '0', '250.00', '235.00', '-96', '0', '1', 'Kg', 'gm', '100', 'photo1_90_2025-08-06-17-20-57.webp', '', '', '2025-08-06 17:20:55', '1'),
('91', '10', '56', 'मोडाचे मूग ', '<p><strong>मोडाचे मूग : 1 Kg</strong></p>\r\n\r\n<p>sprouted green gram, offers several health benefits due to its rich nutritional content.&nbsp;It&nbsp;aids in weight loss, digestion, and blood sugar control, while also boosting immunity and providing various vitamins and minerals.&nbsp;</p>\r\n', '0', '170.00', '160.00', '6', '0', '1', 'Kg', 'gm', '200', 'photo1_91_2025-08-06-18-14-29.avif', '', '', '2025-08-06 18:14:29', '1'),
('92', '10', '56', 'मोडाची मटकी ', '<p><strong>मोडाची मटकी : 1 Kg</strong></p>\r\n\r\n<p>&nbsp;It&#39;s a good source of protein, fiber, vitamins, and minerals, and is known to&nbsp;aid in weight management, improve heart health, boost immunity, and support digestion.&nbsp;</p>\r\n', '0', '170.00', '160.00', '0', '0', '1', 'Kg', 'gm', '100', 'photo1_92_2025-08-06-18-21-36.avif', '', '', '2025-08-06 18:21:35', '1'),
('93', '10', '56', 'मिक्स कडधान्ये ( Mix sprouts )', '<p><strong>Mix Sprouts - 1kg</strong></p>\r\n\r\n<p>Mixed sprouts, a combination of various sprouted seeds and legumes, are a nutritional powerhouse, offering numerous health benefits.&nbsp;They are&nbsp;rich in protein, fiber, vitamins, and minerals, supporting various bodily functions and promoting overall well-being.&nbsp;</p>\r\n', '0', '199.00', '180.00', '0', '0', '1', 'Kg', 'gm', '100', 'photo1_93_2025-08-06-18-32-02.webp', '', '', '2025-08-06 18:32:02', '1'),
('94', '12', '82', 'हारासाठी लागणारी फुले ', '<p><strong>हारासाठी लागणारी फुले :&nbsp; devpoojesathi lagnari phule :&nbsp; &nbsp;1kg</strong></p>\r\n', '0', '220.00', '200.00', '46', '0', '100', 'Kg', 'gm', '100', 'photo1_94_2025-08-06-18-44-55.jpg', '', '', '2025-08-06 18:44:55', '1'),
('95', '7', '82', 'नारळ ', '<p><strong>नारळ : 1 Unit</strong></p>\r\n\r\n<p><strong>Coconut is high in fiber and low in carbs.so it helps control blood sugar levels in our bodies.</strong></p>\r\n', '0', '50.00', '40.00', '20', '0', '1', 'Unit', 'Unit', '100', 'photo1_95_2025-08-07-14-41-41.jpg', '', '', '2025-08-07 14:41:41', '1'),
('96', '12', '82', 'बंच ऑफ रोझेस ', '<p><strong>बंच ऑफ रोझेस&nbsp; :&nbsp; Bunch of 20 roses&nbsp;</strong></p>\r\n', '0', '361.00', '350.00', '0', '0', '1', 'bunch', 'Unit', '0', 'photo1_96_2025-08-07-14-53-00.avif', '', '', '2025-08-07 14:52:42', '1'),
('97', '13', '45', 'शेतकऱ्याकडचा गहू ', '<p><strong>शेतकऱ्याकडचा गहू : Available in 5 Kg packing&nbsp;</strong></p>\r\n\r\n<p>Wheat offers several health benefits due to its rich nutritional content.&nbsp;It is&nbsp;a good source of dietary fiber, which aids digestion, promotes regular bowel movements, and can help manage weight by promoting satiety.&nbsp;</p>\r\n', '0', '260.00', '249.00', '0', '0', '1', '5Kg pack', 'Unit', '0', 'photo1_97_2025-08-07-15-21-41.jpg', '', '', '2025-08-07 15:21:41', '1'),
('98', '13', '45', ' सुवासिक इंद्रायणी तांदूळ ', '<p><strong>&nbsp;सुवासिक इंद्रायणी तांदूळ&nbsp;&nbsp;: Available in 5 Kg pack</strong></p>\r\n\r\n<p>easy to digest, potentially aiding in blood sugar regulation and promoting healthy bowel movements.</p>\r\n', '0', '350.00', '325.00', '0', '0', '0', '5Kg pack', 'Unit', '0', 'photo1_98_2025-08-07-15-26-25.jpeg', '', '', '2025-08-07 15:26:25', '1'),
('99', '13', '45', 'गावरान ज्वारी ', '<p><strong>गावरान ज्वारी : Available in 5 Kg pack&nbsp;</strong></p>\r\n\r\n<p>It&#39;s a good source of fiber, protein, and various vitamins and minerals, making it beneficial for digestion, heart health, and blood sugar management</p>\r\n', '0', '300.00', '290.00', '0', '0', '1', '5Kg pack', 'Unit', '500', 'photo1_99_2025-08-07-15-35-58.jpg', '', '', '2025-08-07 15:35:56', '1'),
('100', '12', '82', 'फ्लावर बुके ', '<p><strong>फ्लावर बुके&nbsp;&nbsp;</strong></p>\r\n\r\n<p>फुलांचा गुच्छ म्हणजे&nbsp;फुलांची एक आकर्षक मांडणी, जी अनेकदा भेट म्हणून दिली जाते किंवा सजावटीसाठी वापरली जाते&nbsp;.&nbsp;गुलदस्ते वेगवेगळ्या शैली आणि आकारांमध्ये बनवता येतात, साध्या हाताने बांधलेल्या गुच्छांपासून ते विस्तृत कॅस्केडिंग डिझाइनपर्यंत, आणि ते वारंवार खास प्रसंगी दिले जातात किंवा लग्नासारख्या कार्यक्रमांमध्ये वापरले जातात.&nbsp;&nbsp;&nbsp;</p>\r\n', '0', '341.00', '320.00', '0', '0', '1', 'bunch', 'Unit', '25', 'photo1_100_2025-08-07-16-16-27.png', '', '', '2025-08-07 15:49:59', '1'),
('101', '6', '82', 'भुईमुगाच्या शेंगा ', '<p><strong>भुईमुगाच्या शेंगा &nbsp;: ओल्या शेंगा&nbsp;</strong></p>\r\n\r\n<p>Groundnuts, also known as peanuts, offer numerous health benefits due to their rich nutritional profile, including&nbsp;protein, healthy fats, fiber, and various vitamins and minerals.&nbsp;They can contribute to heart health, weight management, and may even play a role in preventing certain diseases.&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '0', '150.00', '130.00', '13', '0', '1', 'Kg', 'gm', '100', 'photo1_101_2025-08-07-15-54-15.jpg', '', '', '2025-08-07 15:54:15', '1'),
('102', '12', '82', 'गुलाब ', '<p><strong>गुलाब : 1 unit&nbsp;&nbsp;</strong><a href=\"https://mr.wikipedia.org/w/index.php?title=%E0%A4%AC%E0%A4%BE%E0%A4%97&amp;action=edit&amp;redlink=1\">In the garden</a>&nbsp;,&nbsp;the&nbsp;<a href=\"https://mr.wikipedia.org/wiki/%E0%A4%97%E0%A5%81%E0%A4%B2%E0%A4%95%E0%A4%82%E0%A4%A6\">rose is used as&nbsp;</a><a href=\"https://mr.wikipedia.org/wiki/%E0%A4%85%E0%A4%A4%E0%A5%8D%E0%A4%A4%E0%A4%B0\">a perfume</a>&nbsp;, a symbol of love, friendship, peace, to decorate the home, to be applied to the head, etc., and rose petals are used in food to enhance the taste of food. Roses create a sense of beauty.&nbsp;</p>\r\n', '0', '35.00', '30.00', '0', '0', '1', 'unit', 'Unit', '100', 'photo1_102_2025-08-08-17-21-52.avif', '', '', '2025-08-08 17:21:52', '1'),
('103', '6', '82', 'निवडलेला पालक ', '<p><strong>निवडलेला पालक :&nbsp;निवडलेली १ गड्डी&nbsp;</strong></p>\r\n\r\n<p>Spinach is a nutrient-rich leafy green with a wide array of health benefits.&nbsp;It is packed with vitamins A, C, and K, as well as minerals like iron, potassium, and magnesium.&nbsp;These nutrients contribute to&nbsp;improved eye health, strong bones, better digestion, and enhanced immune function.&nbsp;</p>\r\n', '0', '62.00', '40.00', '44', '0', '1', 'Gaddi', 'Unit', '100', 'photo1_103_2025-08-12-12-20-46.jpg', '', '', '2025-08-12 12:20:46', '1'),
('104', '6', '82', 'चिरलेला कोबी ', '<p><strong>चिरलेला कोबी :&nbsp;</strong></p>\r\n\r\n<p>Cabbage offers a variety of health benefits due to its rich nutrient profile.&nbsp;It is&nbsp;a good source of vitamins C and K, fiber, and antioxidants, which can support digestion, heart health, and potentially protect against certain cancers.&nbsp;</p>\r\n', '0', '130.00', '100.00', '38', '0', '100', 'Kg ', 'Unit', '100', 'photo1_104_2025-08-12-12-28-53.jpg', '', '', '2025-08-12 12:28:53', '1'),
('105', '6', '82', 'चिरलेला फ्लॉवर ', '<p>चिरलेला फ्लॉवर : Kg</p>\r\n\r\n<p>Cauliflower offers numerous health benefits due to its rich nutrient profile.&nbsp;It&#39;s&nbsp;a good source of fiber, vitamins C and K, and antioxidants, which support digestion, boost the immune system, and may help prevent chronic diseases like heart disease and certain cancers.&nbsp;</p>\r\n', '0', '140.00', '120.00', '33', '0', '1', 'kg', 'Kg', '100', 'photo1_105_2025-08-12-12-31-29.jpg', '', '', '2025-08-12 12:31:29', '1'),
('106', '6', '82', 'चिरलेली भेंडी ', '<p>चिरलेली भेंडी : Kg</p>\r\n\r\n<p>Ladyfinger contains vitamin A and antioxidants that may be helpful in maintaining good eyesight. These antioxidants may help avoid eye conditions such as glaucoma and cataract. The slimy stuff in ladyfinger is alkaline and may help neutralise the acid in the stomach.</p>\r\n', '0', '120.00', '100.00', '38', '0', '1', 'Kg', 'Kg', '100', 'photo1_106_2025-08-12-12-40-47.jpg', '', '', '2025-08-12 12:40:47', '1'),
('107', '6', '82', 'चिरलेली गवार ', '<p>चिरलेली गवार : Kg</p>\r\n\r\n<p>Cluster&nbsp;beans, or&nbsp;Guar beans or Gawar beans, are annual legumes. They are a popular veggie in India. Cluster beans, also known as Cyamopsis&nbsp;tetragonoloba, are a member of the Fabaceae family.&nbsp;</p>\r\n', '0', '170.00', '160.00', '6', '0', '1', 'Kg', 'Kg', '100', 'photo1_107_2025-08-12-12-43-13.jpg', '', '', '2025-08-12 12:43:13', '1'),
('108', '6', '82', 'निवडलेली मेथी ', '<p>निवडलेली मेथी :&nbsp;निवडलेली १ गड्डी&nbsp;</p>\r\n\r\n<p>Fenugreek leaves, also known as&nbsp;<a href=\"https://www.google.com/search?sca_esv=0de3656c54fa3244&amp;rlz=1C1VDKB_enIN1172IN1172&amp;biw=1536&amp;bih=738&amp;q=methi+leaves&amp;sa=X&amp;ved=2ahUKEwiEkZ783ISPAxWDa2wGHWasHxkQxccNegQIJhAB&amp;mstk=AUtExfDyEkCfwFYvuIeR-awBOkvggpN28eAIymu32ZWcwGNtB6N9kvDjTBqDY8NN8mmWhAjQPFvZCHKOveJgJQV1DeYD2T9OM1Kz8KG3JS5D-CvW0VXW-SU7m65LJ1lbbxVpfFY&amp;csui=3\" target=\"_blank\">methi leaves</a>,&nbsp;offer various health benefits.&nbsp;They can&nbsp;aid digestion, help regulate blood sugar, and may assist in lowering cholesterol levels.</p>\r\n', '0', '70.00', '50.00', '38', '0', '100', 'Gaddi', 'Unit', '100', 'photo1_108_2025-08-12-12-46-26.jpg', '', '', '2025-08-12 12:46:26', '1'),
('109', '6', '82', 'निवडलेली शेपू ', '<p>निवडलेली शेपू :&nbsp;निवडलेली १ गड्डी&nbsp;</p>\r\n\r\n<p>Shepu leaves, also known as&nbsp;<a href=\"https://www.google.com/search?sca_esv=0de3656c54fa3244&amp;rlz=1C1VDKB_enIN1172IN1172&amp;biw=1536&amp;bih=738&amp;q=dill+leaves&amp;sa=X&amp;ved=2ahUKEwjij9O73YSPAxULR2wGHRkTBZkQxccNegQIKBAB&amp;mstk=AUtExfDM2DVNmwor-rDkKZ3u3R2_TkzsWOAU8Z4yNLPRh7xQ3X7tABtohTdG5jA7sV0vTkK-RmEK5TgSAN3oa5xa0pGLSEwD3wGHqLBPkLg3iphjQW2C2Lp7MuNvdZD0WsrA_X4&amp;csui=3\" target=\"_blank\">dill leaves</a>,&nbsp;offer a variety of health benefits due to their rich nutrient content.&nbsp;They are known to&nbsp;aid digestion, promote bone health, boost immunity, and help regulate blood sugar levels.&nbsp;</p>\r\n', '0', '45.00', '35.00', '-17', '0', '1', 'Gaddi', 'Unit', '100', 'photo1_109_2025-08-12-13-44-26.jpg', '', '', '2025-08-12 12:48:22', '1'),
('110', '6', '82', 'निवडलेली कोथिंबीर ', '<p>निवडलेली कोथिंबीर :&nbsp;निवडलेली १ गड्डी&nbsp;</p>\r\n\r\n<p>There are multiple health benefits of coriander leaves. Coriander is&nbsp;<strong>a rich source of dietary fiber, manganese, iron, and magnesium</strong>. Coriander is also a great source of Vitamin K, Vitamin C, and protein. In addition, they contain a small amount of phosphorus, calcium, potassium, carotene, and niacin.</p>\r\n', '0', '40.00', '30.00', '40', '0', '1', 'Gaddi', 'Unit', '100', 'photo1_110_2025-08-12-12-51-01.jpg', '', '', '2025-08-12 12:51:01', '1'),
('111', '6', '82', 'सोललेला घेवडा ', '<p>सोललेला घेवडा :In Kg</p>\r\n\r\n<p>Ghevda, also known as Hyacinth Bean or Lablab Bean, is a legume with edible seeds, pods, and flowers.&nbsp;The seeds are&nbsp;a good source of protein, fiber, and various vitamins and minerals.&nbsp;</p>\r\n', '0', '235.00', '199.00', '-11', '0', '1', 'Kg', 'gm', '100', 'photo1_111_2025-08-13-15-18-51.webp', '', '', '2025-08-12 12:59:54', '1'),
('112', '6', '82', 'सोललेला पावटा ', '<p>सोललेला पावटा : Kg</p>\r\n\r\n<p>Pavta seeds, also known as lablab or hyacinth beans, offer several health benefits.&nbsp;They are&nbsp;a good source of protein, fiber, vitamins (like A, C, and K), and minerals (including folate, potassium, calcium, and phosphorus).&nbsp;</p>\r\n', '0', '230.00', '198.00', '-10', '0', '1', 'Kg', 'gm', '100', 'photo1_112_2025-08-12-13-01-29.jpg', '', '', '2025-08-12 13:01:29', '1'),
('114', '6', '82', 'फ्रेश वांगी ', '<p>फ्रेश वांगी : Kg&nbsp;</p>\r\n\r\n<p>Brinjal, also known as eggplant, offers numerous health benefits.&nbsp;It&#39;s&nbsp;rich in antioxidants, supports heart health, aids in blood sugar control, and can be beneficial for weight management due to its high fiber and low-calorie content.</p>\r\n', '0', '110.00', '90.00', '18', '0', '1', 'Kg', 'gm', '200', 'photo1_114_2025-08-12-13-33-59.jpg', '', '', '2025-08-12 13:33:59', '1'),
('115', '6', '82', 'फ्रेश कोबी ', '<p>फ्रेश कोबी&nbsp; : Kg&nbsp;</p>\r\n\r\n<p>Cabbage offers a variety of health benefits due to its rich nutrient profile.&nbsp;It is&nbsp;a good source of vitamins C and K, fiber, and antioxidants, which can support digestion, heart health, and potentially protect against certain cancers.&nbsp;</p>\r\n', '0', '90.00', '70.00', '22', '0', '1', 'Kg', 'gm', '100', 'photo1_115_2025-08-12-13-40-16.jpg', '', '', '2025-08-12 13:40:16', '1'),
('116', '6', '82', 'हिरवी शिमला मिरची ', '<p>हिरवी शिमला मिरची : Kg</p>\r\n\r\n<p>Shimla Mirch, also known as bell pepper or capsicum, offers numerous health benefits due to its rich nutrient profile.&nbsp;It&#39;s packed with vitamins A and C, antioxidants, and fiber, contributing to&nbsp;improved immunity, healthy skin, and potential weight management.&nbsp;</p>\r\n', '0', '90.00', '80.00', '11', '0', '1', 'Kg', 'gm', '100', 'photo1_116_2025-08-14-10-09-50.jpg', '', '', '2025-08-14 10:09:50', '1'),
('117', '6', '82', ' मिरची ', '<p>&nbsp;मिरची : Kg</p>\r\n\r\n<p>Green chilies offer various health benefits due to their rich nutrient content.&nbsp;They are a good source of vitamins A and C, which are essential for&nbsp;boosting immunity, improving vision, and promoting healthy skin.&nbsp;Capsaicin, the compound that gives green chilies their spiciness, also provides benefits like improved digestion, pain relief, and even potential weight loss due to its metabolism-boosting properties.&nbsp;</p>\r\n', '0', '140.00', '120.00', '0', '0', '1', 'Kg', 'gm', '100', 'photo1_117_2025-09-15-20-28-42.jpeg', 'photo2_117_2025-09-15-20-27-13.jpeg', '', '2025-08-14 10:13:50', '1'),
('118', '6', '82', 'पांढरं कारलं ', '<p>पांढरं कारलं : Kg&nbsp;</p>\r\n\r\n<p>White bitter gourd, also known as white bitter melon, offers various health benefits, primarily due to its rich content of vitamins, minerals, and antioxidants.&nbsp;It is known to&nbsp;help regulate blood sugar levels, improve digestion, and boost immunity .</p>\r\n', '0', '90.00', '80.00', '20', '0', '1', 'Kg', 'gm', '100', 'photo1_118_2025-08-14-10-21-47.jpg', '', '', '2025-08-14 10:21:47', '1'),
('120', '7', '81', 'स्वीट कॉर्न ', '<p>स्वीट कॉर्न :&nbsp;</p>\r\n\r\n<p>Corn is a healthy grain and source of fiber, vitamins, minerals, and antioxidants. It may promote eye and digestive health.</p>\r\n', '0', '25.00', '20.00', '20', '0', '100', 'Unit', 'Unit', '100', 'photo1_120_2025-08-17-15-16-56.webp', '', '', '2025-08-17 15:16:56', '1'),
('121', '6', '82', 'आळू ची पाने ', '<p>आळू ची पाने : 1 gaddi&nbsp;</p>\r\n\r\n<p>Aalu leaves (taro leaves) offer several benefits, including&nbsp;boosting immunity, improving eye health due to Vitamin A, promoting heart health by regulating blood pressure and lowering cholesterol, aiding in weight management from their high fiber and water content, and helping control diabetes by managing blood sugar levels.&nbsp;&nbsp;</p>\r\n', '0', '20.00', '18.00', '10', '0', '100', 'Gaddi', 'Unit', '100', 'photo1_121_2025-08-22-11-36-32.webp', '', '', '2025-08-22 11:36:32', '1'),
('122', '6', '82', 'कडीपत्ता ', '<p>कडीपत्ता : 1 Gaddi&nbsp;</p>\r\n\r\n<p>Kadi patta, also known as curry leaves, offers a variety of health benefits due to its rich nutritional profile.&nbsp;These include&nbsp;improved digestion, potential for weight loss, promotion of hair growth, and management of diabetes and cholesterol levels.&nbsp;</p>\r\n', '0', '15.00', '10.00', '0', '0', '1', 'Gaddi', 'Unit', '100', 'photo1_122_2025-08-22-11-59-54.jpg', '', '', '2025-08-22 11:59:53', '1'),
('123', '6', '82', 'वाटाणा ', '<p>वाटाणा : 1 Kg</p>\r\n\r\n<p>Green peas benefit the skin by&nbsp;providing collagen-boosting vitamins (C and A), which promote elasticity and repair, and by supplying antioxidants (like flavonoids and carotenoids) that protect against UV damage and aging.&nbsp;</p>\r\n', '0', '220.00', '200.00', '-11', '0', '100', 'Kg', 'Kg', '100', 'photo1_123_2025-09-07-13-39-26.jpg', '', '', '2025-08-22 12:06:34', '1'),
('124', '6', '82', 'पावटा ', '<p>पावटा : 1 Kg</p>\r\n\r\n<p>Pavta, also known as lima beans, offers various health benefits due to its rich nutrient profile.&nbsp;It is&nbsp;a good source of fiber, protein, and vitamins like folate and minerals such as iron, phosphorus, and potassium.&nbsp;</p>\r\n', '0', '100.00', '80.00', '20', '0', '100', 'Kg', 'Kg', '100', 'photo1_124_2025-08-22-12-08-35.jpg', '', '', '2025-08-22 12:08:35', '1'),
('125', '6', '82', 'मुळा ', '<p>मुळा -&nbsp; Gaddi</p>\r\n', '0', '35.00', '30.00', '14', '0', '100', 'Gaddi', 'Unit', '500', 'photo1_125_2025-10-22-23-17-18.php', '', '', '2025-09-07 13:31:43', '1');
DROP TABLE IF EXISTS sales;
CREATE TABLE `sales` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `pay_id` varchar(50) NOT NULL,
  `sales_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO sales VALUES
('9', '9', 'PAY-1RT494832H294925RLLZ7TZA', '2018-05-10'),
('10', '9', 'PAY-21700797GV667562HLLZ7ZVY', '2018-05-10');
DROP TABLE IF EXISTS subcategory;
CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO subcategory VALUES
('45', '1', 'Grains', 'subcategory_45_2023-11-10-11-49-51.jpg', '', '1'),
('56', '1', 'Other Whole Pulses', 'subcategory_56_2023-11-10-11-51-36.jpeg', '', '1'),
('59', '1', 'Cooking Oil', 'subcategory_59_2023-11-09-19-06-40.jpg', '', '1'),
('70', '2', 'Beverages', 'subcategory_70_2023-11-10-11-48-34.jpg', '', '1'),
('77', '2', 'Snacks & Farsans', 'subcategory_77_2023-11-10-11-53-59.jpg', '', '1'),
('81', '3', 'Fresh Fruits', 'subcategory_81_2023-11-10-11-49-13.jpg', '', '1'),
('82', '3', 'Vegetables', 'subcategory_82_2023-11-10-11-55-47.jpg', '', '1'),
('89', '4', 'Baby Care', 'subcategory_89_2023-11-10-11-47-25.jpg', '', '1'),
('93', '4', 'Health & Wellness', 'subcategory_93_2023-11-10-11-50-34.jpg', '', '1'),
('100', '5', 'School Needs', 'subcategory_100_2023-11-10-11-52-24.jpg', '', '1'),
('103', '5', 'Stationery Sets', 'subcategory_103_2023-11-10-11-54-44.jpg', '', '1');
DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` varchar(60) NOT NULL,
  `type` int(1) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `address` text NOT NULL,
  `contact_info` varchar(100) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `status` int(1) NOT NULL,
  `activate_code` varchar(15) NOT NULL,
  `reset_code` varchar(15) NOT NULL,
  `created_on` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
INSERT INTO users VALUES
('1', 'ac@ac.com', '$2y$10$0SHFfoWzz8WZpdu9Qw//E.tWamILbiNCX7bqhy3od0gvK5.kSJ8N2', '1', 'SAgar', 'Munot', '114 E 2nd Stsss', '9999999999', 'photo-1532128519277-07cb90250ef0.jpg', '1', '', '', '2018-05-01'),
('9', 'ac@ac.com', '12345', '0', 'Shyam', 'Tete', '114 E 2nd St', '9999999999', 'photo-1470246973918-29a93221c455.jpg', '1', 'k8FBpynQfqsv', 'wzPGkX5IODlTYHg', '2018-05-09');
