-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mysorepak`
--

-- --------------------------------------------------------

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` enum('Pending','Completed') NOT NULL DEFAULT 'Pending',
  `order_id` varchar(255) DEFAULT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cart_items`
--

INSERT INTO `cart_items` (`id`, `user_id`, `product_id`, `quantity`, `created_at`, `updated_at`, `status`, `order_id`, `products_json`) VALUES
(26, 8, 17, 1, '2025-05-14 13:41:19', '2025-05-14 13:41:57', 'Completed', '32', '[{\"productId\":\"17\",\"quantity\":1,\"name\":\"addsa\",\"description\":\"asdasd\",\"image\":\"/uploads/1747222954869-organic-store-contains-fruits-vegetables--and-reus.png\",\"metrics\":[]},{\"productId\":13,\"quantity\":1,\"name\":\"rrjydyt\",\"description\":\"yfktutkfumc\",\"image\":\"/uploads/1747061327904-image (8).jpg\",\"metrics\":[{\"id\":7,\"product_id\":13,\"name\":\"1KG\",\"common_price\":\"111.00\",\"tier1_price\":\"1111.00\",\"tier2_price\":\"111.00\",\"tier3_price\":\"111.00\",\"created_at\":\"2025-05-13T06:15:42.000Z\",\"updated_at\":\"2025-05-13T06:15:42.000Z\"}]}]'),
(27, 8, 18, 1, '2025-05-14 13:45:37', '2025-05-15 04:32:14', 'Completed', '33', '[{\"productId\":18,\"quantity\":1,\"name\":\"testting Data\",\"description\":\"testting Data\",\"image\":\"/uploads/1747223482290-steaming-cup-of-chamomile-tea-with-dried-flowers-o.png\",\"metrics\":[{\"id\":8,\"product_id\":18,\"name\":\"100GM\",\"common_price\":\"11.00\",\"tier1_price\":\"11.00\",\"tier2_price\":\"11.00\",\"tier3_price\":\"11.00\",\"created_at\":\"2025-05-14T11:51:22.000Z\",\"updated_at\":\"2025-05-14T11:51:22.000Z\"},{\"id\":9,\"product_id\":18,\"name\":\"50GM\",\"common_price\":\"1.00\",\"tier1_price\":\"11111.00\",\"tier2_price\":\"1.00\",\"tier3_price\":\"1.00\",\"created_at\":\"2025-05-14T11:51:22.000Z\",\"updated_at\":\"2025-05-14T12:02:34.000Z\"}]},{\"productId\":17,\"quantity\":1,\"name\":\"addsa\",\"description\":\"asdasd\",\"image\":\"/uploads/1747222954869-organic-store-contains-fruits-vegetables--and-reus.png\",\"metrics\":[]}]'),
(31, 8, 13, 1, '2025-05-15 05:54:10', '2025-05-15 09:55:25', 'Completed', '34', '[{\"productId\":13,\"quantity\":1,\"name\":\"rrjydyt\",\"description\":\"yfktutkfumc\",\"image\":\"/uploads/1747061327904-image (8).jpg\",\"metrics\":[{\"id\":7,\"product_id\":13,\"name\":\"1KG\",\"common_price\":\"111.00\",\"tier1_price\":\"1111.00\",\"tier2_price\":\"111.00\",\"tier3_price\":\"111.00\",\"created_at\":\"2025-05-13T06:15:42.000Z\",\"updated_at\":\"2025-05-13T06:15:42.000Z\"}]},{\"productId\":\"15\",\"quantity\":4,\"name\":\"TTTTTTTTTTTTTTTTTTT\",\"description\":\"jrdrtdjtrdthd\",\"image\":\"/uploads/1747163906523-enjoy-farm-fresh-organic-fruits-and-vegetables-gro (2).png\",\"metrics\":[]}]'),
(33, 8, 15, 1, '2025-05-15 06:22:19', '2025-05-20 06:52:43', 'Completed', '35', '[{\"productId\":15,\"quantity\":2,\"name\":\"TTTTTTTTTTTTTTTTTTT\",\"description\":\"jrdrtdjtrdthd\",\"image\":\"/uploads/1747163906523-enjoy-farm-fresh-organic-fruits-and-vegetables-gro (2).png\",\"metrics\":[]},{\"productId\":\"17\",\"quantity\":1,\"name\":\"addsa\",\"description\":\"asdasd\",\"image\":\"/uploads/1747222954869-organic-store-contains-fruits-vegetables--and-reus.png\",\"metrics\":[]}]'),
(34, 8, 21, 1, '2025-05-16 13:59:08', '2025-05-20 06:52:43', 'Completed', '35', '[{\"productId\":21,\"quantity\":1,\"name\":\"rrjydyt\",\"description\":\"yfktutkfumc\",\"image\":\"/uploads/1747061327904-image (8).jpg\",\"metrics\":[]}]'),
(36, 8, 109, 1, '2025-05-20 10:37:21', '2025-05-20 11:20:46', 'Completed', '36', '[{\"productId\":\"109\",\"finalProductId\":109,\"metricId\":null,\"quantity\":1,\"name\":\"Choco Dates with Roasted Almond Chocolate\",\"description\":\"\",\"price\":0,\"image\":\"/products\",\"metrics\":[]}]'),
(37, 8, 171, 1, '2025-05-20 13:15:42', '2025-05-20 17:50:01', 'Completed', '37', '[{\"productId\":\"171\",\"finalProductId\":171,\"metricId\":null,\"quantity\":1,\"name\":\"RIBBON 1 INCH\",\"description\":\"No description available\",\"price\":0,\"image\":\"/products/ribbon-1-inch.jpg\",\"metrics\":[]}]'),
(38, 8, 160, 1, '2025-05-20 13:26:09', '2025-05-20 17:50:01', 'Completed', '37', '[{\"productId\":\"160\",\"finalProductId\":160,\"metricId\":null,\"quantity\":1,\"name\":\"SIMPLE LOGO PRINTED COVER 3INCH * 5 INCH\",\"description\":\"No description available\",\"price\":0,\"image\":\"/products/simple-logo-printed-cover-3x5-inch.jpg\",\"metrics\":[]}]'),
(39, 8, 155, 1, '2025-05-20 15:27:02', '2025-05-20 17:50:01', 'Completed', '37', '[{\"productId\":\"155\",\"finalProductId\":155,\"metricId\":null,\"quantity\":1,\"name\":\"WATER BOTTLE 1LTR PER CASE\",\"description\":\"\",\"price\":0,\"image\":\"/products/waterbottle.jpg\",\"metrics\":[]}]'),
(40, 8, 56, 1, '2025-05-20 15:44:05', '2025-05-20 17:50:01', 'Completed', '37', '[{\"productId\":\"56_111\",\"finalProductId\":56,\"metricId\":\"111\",\"quantity\":1,\"name\":\"Mava Katli\",\"description\":\"No description available\",\"price\":720,\"image\":\"/images/logo.png\",\"metrics\":[]}]'),
(41, 8, 9, 2, '2025-05-20 18:22:27', '2025-05-21 06:03:51', 'Completed', '38', '[{\"productId\":\"9\",\"finalProductId\":9,\"metricId\":null,\"quantity\":2,\"name\":\"Jaggery Millet Mysore Pak\",\"description\":\"No description available\",\"price\":1100,\"image\":\"/images/logo.png\",\"metrics\":[]}]'),
(42, 8, 12, 1, '2025-05-20 18:26:33', '2025-05-21 06:03:51', 'Completed', '38', '[{\"productId\":\"12\",\"finalProductId\":12,\"metricId\":null,\"quantity\":1,\"name\":\"MIX MYSORE PAK\",\"description\":\"No description available\",\"price\":420,\"image\":\"/images/logo.png\",\"metrics\":[]}]'),
(44, 8, 2, 1, '2025-05-21 05:00:22', '2025-05-21 06:03:51', 'Completed', '38', '[{\"productId\":\"2\",\"finalProductId\":2,\"metricId\":null,\"quantity\":1,\"name\":\"Special Mysore Pak\",\"description\":\"\",\"price\":0,\"metrics\":[]}]'),
(45, 8, 3, 1, '2025-05-21 06:05:23', '2025-05-21 06:06:02', 'Completed', 'order_1747807540515', '[{\"productId\":\"3\",\"finalProductId\":3,\"metricId\":null,\"quantity\":1,\"name\":\"Jaggery Mysore Pak\",\"description\":\"\",\"price\":0,\"image\":\"/images/logo.png\",\"metrics\":[]}]'),
(47, 8, 4, 1, '2025-05-21 06:18:53', '2025-05-21 06:22:48', 'Completed', 'order_1747808524594', '[{\"productId\":\"4\",\"finalProductId\":4,\"metricId\":null,\"quantity\":1,\"name\":\"Millet Mysore Pak\",\"description\":\"No description available\",\"price\":770,\"image\":\"/images/logo.png\",\"metrics\":[]}]'),
(48, 8, 8, 1, '2025-05-21 06:19:03', '2025-05-21 06:22:48', 'Completed', 'order_1747808524594', '[{\"productId\":\"8\",\"finalProductId\":8,\"metricId\":null,\"quantity\":1,\"name\":\"Roasted Almond Mysore Pak\",\"description\":\"\",\"price\":0,\"image\":\"/images/logo.png\",\"metrics\":[]}]');

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image_url` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `title`, `description`, `image_url`, `created_at`, `updated_at`) VALUES
(1, 'Sweets', 'Sweets', 'Sweets', '/categories/sweets.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(2, 'Mysorepak', 'Mysorepak', 'Mysorepak', '/categories/mysorepak.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(3, 'Namkeen', 'Namkeen', 'Namkeen', '/categories/namkeen.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(4, 'Chocolates', 'Chocolates', 'Chocolates', '/categories/chocolates.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(5, 'Beverages', 'Beverages', 'Beverages', '/categories/beverages.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(6, 'Dry Fruits', 'Dry Fruits', 'Dry Fruits', '/categories/dry-fruits.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(7, 'Bakery', 'Bakery', 'Bakery', '/categories/bakery.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32'),
(8, 'Wraps & Boxes', 'Wraps & Boxes', 'Wraps & Boxes', '/categories/wraps-&-boxes.png', '2025-05-19 09:45:32', '2025-05-19 09:45:32');

-- --------------------------------------------------------

--
-- Table structure for table `metrics`
--

CREATE TABLE `metrics` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `common_price` decimal(10,2) NOT NULL,
  `tier1_price` decimal(10,2) NOT NULL,
  `tier2_price` decimal(10,2) NOT NULL,
  `tier3_price` decimal(10,2) NOT NULL,
  `aprox-no-of-pcs-per-kg/gms` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `metrics`
--

INSERT INTO `metrics` (`id`, `product_id`, `name`, `common_price`, `tier1_price`, `tier2_price`, `tier3_price`, `aprox-no-of-pcs-per-kg/gms`, `created_at`, `updated_at`) VALUES
(1, 1, '1 KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(2, 1, '500 gms', '300.00', '210.00', '200.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(3, 1, '250 gms', '150.00', '105.00', '100.00', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(4, 1, '100 gms', '60.00', '42.00', '40.00', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(5, 1, '50 gms', '30.00', '21.00', '20.00', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(6, 1, 'Unpacked', '600.00', '360.00', '342.86', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(7, 2, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(8, 2, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(9, 2, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(10, 2, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(11, 2, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(12, 2, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(13, 3, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(14, 3, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(15, 3, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(16, 3, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(17, 3, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(18, 3, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(19, 4, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(20, 4, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(21, 4, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(22, 4, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(23, 4, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(24, 4, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(25, 5, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(26, 5, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(27, 5, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(28, 5, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(29, 5, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(30, 5, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(31, 6, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(32, 6, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(33, 6, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(34, 6, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(35, 6, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(36, 6, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(37, 7, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(38, 7, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(39, 7, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(40, 7, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(41, 7, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(42, 7, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(43, 8, '1 KG', '1200.00', '840.00', '800.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(44, 8, '500 gms', '600.00', '420.00', '400.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(45, 8, '250 gms', '300.00', '210.00', '200.00', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(46, 8, '100 gms', '120.00', '84.00', '80.00', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(47, 8, '50 gms', '60.00', '42.00', '40.00', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(48, 8, 'Unpacked', '1200.00', '780.00', '742.86', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(49, 9, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(50, 9, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(51, 9, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(52, 9, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(53, 9, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(54, 9, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(55, 10, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(56, 10, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(57, 10, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(58, 10, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(59, 10, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(60, 10, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(61, 11, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(62, 11, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(63, 11, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(64, 11, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(65, 11, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(66, 11, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(67, 12, '500 gms', '600.00', '420.00', '400.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(68, 13, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(69, 14, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(70, 15, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(71, 16, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(72, 17, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(73, 18, 'Per KG', '1100.00', '770.00', '733.33', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(74, 19, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(75, 20, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(76, 21, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(77, 22, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(78, 23, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(79, 24, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(80, 25, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(81, 26, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(82, 27, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(83, 28, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(84, 29, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(85, 30, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '35', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(86, 31, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(87, 32, 'Per KG', '800.00', '560.00', '533.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(88, 33, 'Per KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(89, 34, 'Per KG', '800.00', '560.00', '533.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(90, 35, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(91, 36, 'Per KG', '850.00', '595.00', '566.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(92, 37, 'Per KG', '700.00', '490.00', '466.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(93, 38, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(94, 39, 'Per KG', '600.00', '420.00', '400.00', '0.00', '40', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(95, 40, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(96, 41, 'Per KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(97, 42, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(98, 43, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(99, 44, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(100, 45, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(101, 46, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(102, 47, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(103, 48, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(104, 49, 'Per KG', '720.00', '504.00', '480.00', '0.00', '40', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(105, 50, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(106, 51, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(107, 52, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(108, 53, 'Per KG', '720.00', '504.00', '480.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(109, 54, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(110, 55, 'Per KG', '800.00', '560.00', '533.33', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(111, 56, 'Per KG', '720.00', '504.00', '480.00', '0.00', '50', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(112, 57, 'Per KG', '1000.00', '700.00', '666.67', '0.00', '50', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(113, 58, 'Per KG', '1100.00', '770.00', '733.33', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(114, 59, '1PCS', '80.00', '44.00', '41.90', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(115, 60, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(116, 61, '1PCS', '45.00', '31.50', '30.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(117, 62, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(118, 63, '1PCS', '30.00', '21.00', '20.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(119, 64, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(120, 65, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(121, 66, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(122, 67, 'Per KG', '1350.00', '945.00', '843.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(123, 68, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(124, 69, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(125, 70, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(126, 71, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(127, 72, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(128, 73, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(129, 74, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(130, 75, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(131, 76, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(132, 77, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(133, 78, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(134, 79, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(135, 80, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(136, 81, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(137, 82, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(138, 83, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(139, 84, 'Per KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(140, 85, 'Per KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(141, 86, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(142, 87, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(143, 88, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(144, 89, 'Per KG', '500.00', '350.00', '312.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(145, 90, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(146, 91, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(147, 92, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(148, 93, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(149, 94, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(150, 95, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(151, 96, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(152, 97, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(153, 98, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(154, 99, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(155, 100, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(156, 101, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(157, 102, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(158, 103, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(159, 65, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(160, 66, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(161, 67, '100 gms', '135.00', '94.50', '84.38', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(162, 68, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(163, 69, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(164, 70, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(165, 71, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(166, 72, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(167, 73, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(168, 74, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(169, 75, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(170, 76, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(171, 77, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(172, 78, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(173, 79, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(174, 80, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(175, 81, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(176, 82, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(177, 83, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(178, 84, '100 gms', '80.00', '56.00', '50.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(179, 85, '100 gms', '80.00', '56.00', '50.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(180, 86, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(181, 87, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(182, 88, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(183, 89, '100 gms', '50.00', '35.00', '31.25', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(184, 90, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(185, 91, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(186, 92, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(187, 93, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(188, 94, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(189, 95, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(190, 96, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(191, 97, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(192, 98, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(193, 99, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(194, 100, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(195, 101, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(196, 102, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(197, 103, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(198, 104, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(199, 105, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(200, 106, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(201, 107, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(202, 108, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(203, 109, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(204, 110, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(205, 111, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(206, 112, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(207, 113, '1 Pkt (100 gms)', '150.00', '105.00', '88.98', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(208, 114, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(209, 115, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(210, 116, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(211, 117, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(212, 118, '1 KG', '1500.00', '1050.00', '889.83', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(213, 119, '1 KG', '1000.00', '700.00', '593.22', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(214, 120, 'Per Bottle', '70.00', '49.00', '41.53', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(215, 121, 'Per Bottle', '50.00', '35.00', '33.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(216, 122, 'Per Bottle', '70.00', '49.00', '41.53', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(217, 123, 'Per Bottle', '70.00', '49.00', '46.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(218, 124, 'Per Bottle', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(219, 125, 'Per Bottle', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(220, 126, '1 KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(221, 127, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(222, 128, '1 KG', '1500.00', '1050.00', '1000.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(223, 129, '1 KG', '800.00', '560.00', '533.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(224, 130, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(225, 131, '1 KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(226, 132, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(227, 133, '1 KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(228, 134, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(229, 135, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(230, 136, 'Per Pack', '300.00', '210.00', '200.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(231, 137, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48');

-- --------------------------------------------------------

--
-- Table structure for table `metric_constants`
--

CREATE TABLE `metric_constants` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `metric_constants`
--

INSERT INTO `metric_constants` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '1KG', '2025-05-12 14:30:07', '2025-05-12 14:30:07'),
(2, '500GM', '2025-05-12 14:30:07', '2025-05-12 14:30:07'),
(3, '250GM', '2025-05-12 14:30:07', '2025-05-12 14:30:07'),
(4, '100GM', '2025-05-12 14:30:07', '2025-05-12 14:30:07'),
(5, '50GM', '2025-05-12 14:30:07', '2025-05-12 14:30:07'),
(6, 'UNPACKED', '2025-05-12 14:30:07', '2025-05-12 14:30:07');

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pending','processing','completed','cancelled','paid') DEFAULT NULL,
  `payment_id` varchar(100) DEFAULT NULL,
  `payment_method` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `order_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `total_amount`, `status`, `payment_id`, `payment_method`, `created_at`, `updated_at`, `order_id`) VALUES
(1, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 04:48:41', '2025-05-14 04:48:41', NULL),
(2, 8, '50.00', 'paid', '2', NULL, '2025-05-14 04:53:36', '2025-05-14 04:53:36', NULL),
(3, 8, '50.00', 'paid', '3', NULL, '2025-05-14 04:54:26', '2025-05-14 04:54:27', NULL),
(4, 8, '50.00', 'paid', '4', NULL, '2025-05-14 04:58:30', '2025-05-14 04:58:30', NULL),
(5, 8, '50.00', 'paid', '5', NULL, '2025-05-14 05:02:43', '2025-05-14 05:02:43', NULL),
(6, 8, '50.00', 'pending', '6', NULL, '2025-05-14 05:09:52', '2025-05-14 05:09:52', NULL),
(7, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 07:21:49', '2025-05-14 07:21:49', NULL),
(8, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 07:28:24', '2025-05-14 07:28:24', NULL),
(9, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 07:49:10', '2025-05-14 07:49:10', NULL),
(10, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 07:56:01', '2025-05-14 07:56:01', NULL),
(11, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 08:01:07', '2025-05-14 08:01:07', NULL),
(12, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 08:11:07', '2025-05-14 08:11:07', NULL),
(13, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 08:49:52', '2025-05-14 08:49:52', NULL),
(14, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 08:52:16', '2025-05-14 08:52:16', NULL),
(15, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 08:56:22', '2025-05-14 08:56:22', NULL),
(16, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:07:01', '2025-05-14 09:07:01', NULL),
(17, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:15:04', '2025-05-14 09:15:04', NULL),
(18, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:22:57', '2025-05-14 09:22:57', NULL),
(19, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:23:36', '2025-05-14 09:23:36', NULL),
(20, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:24:35', '2025-05-14 09:24:35', NULL),
(21, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:27:54', '2025-05-14 09:27:54', NULL),
(22, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:31:45', '2025-05-14 09:31:45', NULL),
(23, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:34:31', '2025-05-14 09:34:31', NULL),
(24, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:37:36', '2025-05-14 09:37:36', NULL),
(25, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:53:19', '2025-05-14 09:53:19', NULL),
(26, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:58:09', '2025-05-14 09:58:09', NULL),
(27, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 09:59:26', '2025-05-14 09:59:26', NULL),
(28, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 10:02:03', '2025-05-14 10:02:03', NULL),
(29, 8, '50.00', 'pending', NULL, NULL, '2025-05-14 10:14:26', '2025-05-14 10:14:26', NULL),
(30, 8, '0.00', 'paid', NULL, NULL, '2025-05-14 13:36:07', '2025-05-14 13:36:07', NULL),
(31, 8, '0.00', 'paid', NULL, NULL, '2025-05-14 13:37:36', '2025-05-14 13:37:36', 'order_1747229828368'),
(32, 8, '0.00', 'paid', NULL, NULL, '2025-05-14 13:41:57', '2025-05-14 13:41:57', 'order_1747230099898'),
(33, 8, '0.00', 'paid', NULL, NULL, '2025-05-15 04:32:14', '2025-05-15 04:32:14', NULL),
(34, 8, '0.00', 'paid', NULL, NULL, '2025-05-15 09:55:25', '2025-05-15 09:55:25', NULL),
(35, 8, '0.00', 'paid', NULL, NULL, '2025-05-20 06:52:43', '2025-05-20 06:52:43', NULL),
(36, 8, '0.00', 'paid', NULL, NULL, '2025-05-20 11:20:46', '2025-05-20 11:20:46', NULL),
(37, 8, '0.00', 'paid', NULL, NULL, '2025-05-20 17:50:01', '2025-05-20 17:50:01', NULL),
(38, 8, '0.00', 'paid', NULL, NULL, '2025-05-21 06:03:51', '2025-05-21 06:03:51', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `products_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `created_at`) VALUES
(1, 1, 15, 1, '0.00', '2025-05-14 04:48:41'),
(2, 2, 15, 1, '0.00', '2025-05-14 04:53:36'),
(3, 3, 14, 1, '0.00', '2025-05-14 04:54:26'),
(4, 3, 13, 1, '0.00', '2025-05-14 04:54:26'),
(5, 4, 14, 2, '0.00', '2025-05-14 04:58:30'),
(6, 5, 13, 2, '0.00', '2025-05-14 05:02:43'),
(7, 6, 14, 2, '0.00', '2025-05-14 05:09:52'),
(8, 7, 14, 2, '0.00', '2025-05-14 07:21:49'),
(9, 7, 13, 1, '0.00', '2025-05-14 07:21:49'),
(10, 8, 14, 2, '0.00', '2025-05-14 07:28:24'),
(11, 8, 13, 1, '0.00', '2025-05-14 07:28:24'),
(12, 9, 14, 2, '0.00', '2025-05-14 07:49:10'),
(13, 9, 13, 2, '0.00', '2025-05-14 07:49:10'),
(14, 10, 14, 2, '0.00', '2025-05-14 07:56:01'),
(15, 10, 13, 2, '0.00', '2025-05-14 07:56:01'),
(16, 11, 14, 2, '0.00', '2025-05-14 08:01:07'),
(17, 11, 13, 2, '0.00', '2025-05-14 08:01:07'),
(18, 12, 14, 2, '0.00', '2025-05-14 08:11:07'),
(19, 12, 13, 2, '0.00', '2025-05-14 08:11:07'),
(20, 13, 14, 3, '0.00', '2025-05-14 08:49:52'),
(21, 13, 13, 2, '0.00', '2025-05-14 08:49:52'),
(22, 14, 14, 3, '0.00', '2025-05-14 08:52:16'),
(23, 14, 13, 2, '0.00', '2025-05-14 08:52:16'),
(24, 15, 14, 3, '0.00', '2025-05-14 08:56:22'),
(25, 15, 13, 2, '0.00', '2025-05-14 08:56:22'),
(26, 16, 14, 3, '0.00', '2025-05-14 09:07:01'),
(27, 16, 13, 2, '0.00', '2025-05-14 09:07:01'),
(28, 17, 14, 3, '0.00', '2025-05-14 09:15:04'),
(29, 17, 13, 2, '0.00', '2025-05-14 09:15:04'),
(30, 18, 14, 3, '0.00', '2025-05-14 09:22:57'),
(31, 18, 13, 2, '0.00', '2025-05-14 09:22:57'),
(32, 19, 14, 3, '0.00', '2025-05-14 09:23:36'),
(33, 19, 13, 2, '0.00', '2025-05-14 09:23:36'),
(34, 20, 14, 3, '0.00', '2025-05-14 09:24:35'),
(35, 20, 13, 2, '0.00', '2025-05-14 09:24:35'),
(36, 21, 14, 3, '0.00', '2025-05-14 09:27:54'),
(37, 21, 13, 2, '0.00', '2025-05-14 09:27:54'),
(38, 22, 14, 3, '0.00', '2025-05-14 09:31:45'),
(39, 22, 13, 2, '0.00', '2025-05-14 09:31:45'),
(40, 23, 14, 3, '0.00', '2025-05-14 09:34:31'),
(41, 23, 13, 2, '0.00', '2025-05-14 09:34:31'),
(42, 24, 14, 3, '0.00', '2025-05-14 09:37:36'),
(43, 24, 13, 2, '0.00', '2025-05-14 09:37:37'),
(44, 25, 14, 3, '0.00', '2025-05-14 09:53:19'),
(45, 25, 13, 2, '0.00', '2025-05-14 09:53:19'),
(46, 26, 14, 3, '0.00', '2025-05-14 09:58:09'),
(47, 26, 13, 2, '0.00', '2025-05-14 09:58:09'),
(48, 27, 14, 3, '0.00', '2025-05-14 09:59:26'),
(49, 27, 13, 2, '0.00', '2025-05-14 09:59:26'),
(50, 28, 14, 3, '0.00', '2025-05-14 10:02:04'),
(51, 28, 13, 2, '0.00', '2025-05-14 10:02:04'),
(52, 29, 14, 3, '0.00', '2025-05-14 10:14:26'),
(53, 29, 13, 2, '0.00', '2025-05-14 10:14:26');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `common_price` decimal(10,2) DEFAULT NULL,
  `tier1_price` decimal(10,2) DEFAULT NULL,
  `tier2_price` decimal(10,2) DEFAULT NULL,
  `tier3_price` decimal(10,2) NOT NULL,
  `image_url` text DEFAULT NULL,
  `gst` varchar(10) DEFAULT NULL,
  `hsn` varchar(10) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `category_id` int(11) DEFAULT NULL,
  `metrics_enabled` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `description`, `common_price`, `tier1_price`, `tier2_price`, `tier3_price`, `image_url`, `gst`, `hsn`, `created_at`, `updated_at`, `category_id`, `metrics_enabled`) VALUES
(1, 'Traditional Mysore Pak', NULL, '0.00', '0.00', '0.00', '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, 0),
(2, 'Special Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(3, 'Jaggery Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(4, 'Millet Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(5, 'Milk Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(6, 'Carrot Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(7, 'Kaju Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(8, 'Roasted Almond Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(9, 'Jaggery Millet Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(10, 'Anjeer Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(11, 'Mango Mysore Pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(12, 'MIX MYSORE PAK', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 2, NULL),
(13, 'Rose Bite', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(14, 'Kaju Bites', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(15, 'Pista Bites', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(16, 'Kesar Bites', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(17, 'Chocoalte Bites', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(18, 'Kaju Barfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(19, 'Mango Delight', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(20, 'kaju Pista Roll', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(21, 'Kaju Kesar Roll', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(22, 'Kaju Chocoalte Roll', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(23, 'Anjeer Dry Fruit Roll', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(24, 'Kaju Anjeer Sandwich', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(25, 'Kaju Apple', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(26, 'Kaju Mango', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(27, 'Kaju Katlet', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(28, 'kaju Katori', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(29, 'Kaju Rose', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(30, 'Dry Fruit Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(31, 'Pure Ghee Bombay Halwa', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(32, 'Dry Fruit Ladoo', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(33, 'Badusha', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(34, 'Banarsai Soan Papdi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(35, 'White Soan Papadi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(36, 'Horlicks Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(37, 'moti pak', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(38, 'Motichur Laddu', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(39, 'Dhardwad Pedha', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(40, 'Beason Laddu', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(41, 'Milk Cake', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(42, 'Moong dal Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(43, 'Moon dal Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(44, 'Kharjur Dry Fruit burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(45, 'Misty Milk Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(46, 'Venilla Dry fruit Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(47, 'Chocolate Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(48, 'Coconut Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(49, 'Doodh Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(50, 'Fruite Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(51, 'Doodh Burfi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(52, 'Doodh Pedha', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(53, 'Boondi Laddu', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(54, 'Kesar Peda', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(55, 'GHEE KALAKAND', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(56, 'Mava Katli', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(57, 'MYSORE PEDA', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(58, 'PA-KA SANDWICH', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(59, 'Pataka Matakagulla', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(60, 'Jamoon', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(61, 'Kashmiri Kesar Rasmalai', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(62, 'Rasgulla', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(63, 'Champakali', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(64, 'Malai Sandwich', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '17049090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 1, NULL),
(65, 'Mota Sev', NULL, NULL, NULL, NULL, '0.00', '/products/crispy-sev.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(66, 'Gujarati Papdi', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(67, 'Mysore Special Avarekalu', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(68, 'Special Om Pudi', NULL, NULL, NULL, NULL, '0.00', '/products/special-crispy-om-pudi.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(69, 'Masala Peanut', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(70, 'Thill Murk', NULL, NULL, NULL, NULL, '0.00', '/products/tasty-thill-murk.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(71, 'Chana Dal', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(72, 'Bakarwadi', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(73, 'Gatiya', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(74, 'Fried Chana', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(75, 'Peri Peri Makhana', NULL, NULL, NULL, NULL, '0.00', '/products/peri-peri-makhana.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(76, 'Salt Makhana', NULL, NULL, NULL, NULL, '0.00', '/products/salted-makhana.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(77, 'Pepper Makhana', NULL, NULL, NULL, NULL, '0.00', '/products/pepper-makhana.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(78, 'Cajun Spice Makhana', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(79, 'Hot and Spicy Makhana', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(80, 'Fried Green Peas', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(81, 'Masala Kaju', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(82, 'Pepper Kaju', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(83, 'Ribbon Muruku', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(84, 'Kara Chips', NULL, NULL, NULL, NULL, '0.00', '/products/khara-chips.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(85, 'Salt Chips', NULL, NULL, NULL, NULL, '0.00', '/products/crispy-salt-chips.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(86, 'Andhra Muruku', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(87, 'Methi Matri', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(88, 'Garlic Mixture', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(89, 'Mysore Masala Kadlepuri', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(90, 'Mysore Mixture', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(91, 'Mini Nippattu', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(92, 'Kodubale', NULL, NULL, NULL, NULL, '0.00', '/products/kodbale.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(93, 'Chakkuli', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(94, 'Chilli Kaju', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(95, 'Salt Kaju', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(96, 'Salt Moongdal', NULL, NULL, NULL, NULL, '0.00', '/products/crispy-salt-moong-dal.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(97, 'Spicy Moongdal', NULL, NULL, NULL, NULL, '0.00', '/products/spicy-moong-dal.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(98, 'Grains&Pulses Masla', NULL, NULL, NULL, NULL, '0.00', '/products/mix-grain-&-pulses.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(99, 'Palak chakkuli', NULL, NULL, NULL, NULL, '0.00', '/products/palak-chakkuli.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(100, 'Ragi chakkuli( finger millet)', NULL, NULL, NULL, NULL, '0.00', '/products/ragi-chakkuli.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(101, 'Bendi fry', NULL, NULL, NULL, NULL, '0.00', '/products/bhendi-okra-fries.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(102, 'Bitter gourd fry', NULL, NULL, NULL, NULL, '0.00', '/products', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(103, 'Potato sticks', NULL, NULL, NULL, NULL, '0.00', '/products/potato-sticks.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(104, 'masala khakhra', NULL, NULL, NULL, NULL, '0.00', '/products/masala-khakra.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(105, 'methi masala khakhra', NULL, NULL, NULL, NULL, '0.00', '/products/methi-masala-khakra.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(106, 'jeera khakhra', NULL, NULL, NULL, NULL, '0.00', '/products/jeera-khakra.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(107, 'Cheese khakhra', NULL, NULL, NULL, NULL, '0.00', '/products/cheese-khakra.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(108, 'plain khakhra', NULL, NULL, NULL, NULL, '0.00', '/products/plain-khakra.jpg', '12', '210690', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 3, NULL),
(109, 'Choco Dates with Roasted Almond Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(110, 'Choco Dipped Biscuit', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(111, 'Paan Dates Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(112, 'Rasamalai Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(113, 'Dipped Chocolate Oreo', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(114, 'Roasted Almond Dark Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products/crispy-almond-dark-chocolate.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(115, 'Fruit and Nut Milk Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products/milk-chocolate fruit-&-nut.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(116, 'Hazelnut Dark Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products/hazelnut-chocolate.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(117, 'Roasted Kaju Milk Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products/cashews-milk-chocolate.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(118, 'White Chocolate Raisins', NULL, NULL, NULL, NULL, '0.00', '/products/milk-chocolate-raisins.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(119, 'Milk Chocolate', NULL, NULL, NULL, NULL, '0.00', '/products/milk-chocolate.jpg', '18', '18069090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 4, NULL),
(120, 'Jal Jeera', NULL, NULL, NULL, NULL, '0.00', NULL, '18', '22029100', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(121, 'Butter Milk', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '40390', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(122, 'Aampanna', NULL, NULL, NULL, NULL, '0.00', NULL, '18', '22029100', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(123, 'Sweet Lassi', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '40390', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(124, 'Rose Milk', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '22029930', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(125, 'Special Badam Milk', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '22029930', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 5, NULL),
(126, 'Salted pista', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '0.802', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(127, 'Almond', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '0.80211', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(128, 'whole Kaju', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '0.80132', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(129, 'Rasins', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '0.806201', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(130, 'walnet', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '0.80232', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(131, 'Dry Karjur', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '0.804103', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(132, 'Rasberry', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '0.804101', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(133, 'Anjeer', NULL, NULL, NULL, NULL, '0.00', NULL, '12', '0.804101', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 6, NULL),
(134, 'Kaju Biscticks', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '19059020', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 7, NULL),
(135, 'Almond Bisticks', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '19059020', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 7, NULL),
(136, 'Pista Bisticks', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '19059020', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 7, NULL),
(137, 'Chocolated Bisticsk', NULL, NULL, NULL, NULL, '0.00', NULL, '5', '19059020', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 7, NULL),
(138, 'Carry bag 1/2kg', NULL, NULL, NULL, NULL, '0.00', '/products/carry-bag-500-gms.jpg', NULL, '63053900', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(139, 'carry bag 1/4 kg', NULL, NULL, NULL, NULL, '0.00', '/products/carrybag-250-gms.jpg', NULL, '63053900', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(140, 'Carry bag 1kg', NULL, NULL, NULL, NULL, '0.00', '/products/carrybag-1-kg.jpg', NULL, '63053900', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(141, 'Paper cup Doda Katori /Sample Katori', NULL, NULL, NULL, NULL, '0.00', '/products/katori.jpg', '18', '4823', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(142, 'IML BOX 250ML', NULL, NULL, NULL, NULL, '0.00', '/products/white-iml-box-250gms.jpg', '18', '39233090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(143, 'IMLBOX 500ML', NULL, NULL, NULL, NULL, '0.00', '/products/white-iml-box 500gms.jpg', '18', '39233090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(144, 'IML BOX 1KG', NULL, NULL, NULL, NULL, '0.00', '/products/iml-box-1-kg.jpg.jpg', '18', '39233090', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(145, 'PAPPER BOX 50GM', NULL, NULL, NULL, NULL, '0.00', '/products/paper-box-50gms.jpg', '18', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(146, 'PAPPER BOX 100GM', NULL, NULL, NULL, NULL, '0.00', '/products/paper-box-100gms.jpg', '18', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(147, 'PAPPER BOX 250GM', NULL, NULL, NULL, NULL, '0.00', '/products/paper-box-250-gms.jpg', '18', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(148, 'PAPPER BOX 500GM', NULL, NULL, NULL, NULL, '0.00', '/products/paper-box-500gms.jpg', '18', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(149, 'PAPPER BOX 1KG', NULL, NULL, NULL, NULL, '0.00', '/products/paper-box-1-kg.jpg', '18', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(150, 'PLASTIC CONTAINER 100ML', NULL, NULL, NULL, NULL, '0.00', '/products/plastic-container-100ml.jpg', NULL, '3924', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(151, 'PLASTIC CONTAINER 250ML', NULL, NULL, NULL, NULL, '0.00', '/products/plastic-container-250ml.jpg', NULL, '3924', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(152, 'PLASTIC CONTAINER 500ML', NULL, NULL, NULL, NULL, '0.00', '/products/plastic-container-500ml.jpg', NULL, '3924', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(153, 'TISSUES', NULL, NULL, NULL, NULL, '0.00', '/products/tissues.jpg', '18', '48189000', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(154, 'RUBBER HAND GLOUSE', NULL, NULL, NULL, NULL, '0.00', '/products/good-rubber-gloves.jpg', NULL, '3926', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(155, 'WATER BOTTLE 1LTR PER CASE', NULL, NULL, NULL, NULL, '0.00', '/products/waterbottle.jpg', '18', '2201', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(156, 'GARBAGE BAGS MEDIUM', NULL, NULL, NULL, NULL, '0.00', '/products/garbage-bags-medium.jpg', NULL, '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(157, 'GARBAGE BAGS JUMBOW', NULL, NULL, NULL, NULL, '0.00', '/products/garbage-bags-jumbo.jpg', NULL, '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(158, 'PEPAR PLATES', NULL, NULL, NULL, NULL, '0.00', '/products/papper-plate.jpg', NULL, '4823', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(159, 'LOGO STICKERS', NULL, NULL, NULL, NULL, '0.00', '/products/logo-stickers.jpg', NULL, '4821', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(160, 'SIMPLE LOGO PRINTED COVER 3INCH * 5 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/simple-logo-printed-cover-3x5-inch.jpg', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(161, 'SIMPLE LOGO PRINTED COVER 5 INCH * 7 INCH', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(162, 'SIMPLE LOGO PRINTED COVER 6 INCH * 8 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/simple-logo-printed-cover-6x8-inch.jpg', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(163, 'SIMPLE LOGO PRINTED COVER 9 INCH * 12 INCH', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(164, 'SIMPLE LOGO PRINTED COVER 9.5 INCH * 14 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/plain-simple-logo-printed-cover-9.5x14-inch.jpg', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(165, 'COROGATED BOX', NULL, NULL, NULL, NULL, '0.00', '/products/corrogated-box.jpg', '12', '4819', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(166, 'STAND UP POUCH 11 CM* 20.5 CM', NULL, NULL, NULL, NULL, '0.00', '/products/plain-stand-up-pouch-11x20.5 -cm.jpg', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(167, 'STAND UP POUCH 15.5CM * 21CM', NULL, NULL, NULL, NULL, '0.00', '/products/plain-standup-pouch-15.5x21-cms.jpg', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(168, 'STAND UP POUCH 18CM * 24CM', NULL, NULL, NULL, NULL, '0.00', '/products', '18', '3923', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(169, 'SUGAR CANE BOWLS MEDIUM SIZE', NULL, NULL, NULL, NULL, '0.00', '/products/sugarcane-bowls-medium-size.jpg', '18', '4823', '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(170, 'RIBBON 0.75 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/ribbon-0.75-inch.jpg', NULL, NULL, '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(171, 'RIBBON 1 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/ribbon-1-inch.jpg', NULL, NULL, '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL),
(172, 'RIBBON 1.5 INCH', NULL, NULL, NULL, NULL, '0.00', '/products/quality-ribbon-1.5-inch.jpg', NULL, NULL, '2025-05-19 10:04:28', '2025-05-19 10:04:28', 8, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `product_metrics`
--

CREATE TABLE `product_metrics` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `common_price` decimal(10,2) NOT NULL,
  `tier1_price` decimal(10,2) NOT NULL,
  `tier2_price` decimal(10,2) NOT NULL,
  `tier3_price` decimal(10,2) NOT NULL,
  `aprox-no-of-pcs-per-kg/gms` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_metrics`
--

INSERT INTO `product_metrics` (`id`, `product_id`, `name`, `common_price`, `tier1_price`, `tier2_price`, `tier3_price`, `aprox-no-of-pcs-per-kg/gms`, `created_at`, `updated_at`) VALUES
(1, 1, '1 KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(2, 1, '500 gms', '300.00', '210.00', '200.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(3, 1, '250 gms', '150.00', '105.00', '100.00', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(4, 1, '100 gms', '60.00', '42.00', '40.00', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(5, 1, '50 gms', '30.00', '21.00', '20.00', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(6, 1, 'Unpacked', '600.00', '360.00', '342.86', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(7, 2, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(8, 2, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(9, 2, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(10, 2, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(11, 2, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(12, 2, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(13, 3, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(14, 3, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(15, 3, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(16, 3, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(17, 3, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(18, 3, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(19, 4, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(20, 4, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(21, 4, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(22, 4, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(23, 4, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(24, 4, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(25, 5, '1 KG', '1000.00', '700.00', '666.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(26, 5, '500 gms', '500.00', '350.00', '333.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(27, 5, '250 gms', '250.00', '175.00', '166.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(28, 5, '100 gms', '100.00', '70.00', '66.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(29, 5, '50 gms', '50.00', '35.00', '33.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(30, 5, 'Unpacked', '1000.00', '640.00', '609.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(31, 6, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(32, 6, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(33, 6, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(34, 6, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(35, 6, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(36, 6, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(37, 7, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(38, 7, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(39, 7, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(40, 7, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(41, 7, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(42, 7, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(43, 8, '1 KG', '1200.00', '840.00', '800.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(44, 8, '500 gms', '600.00', '420.00', '400.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(45, 8, '250 gms', '300.00', '210.00', '200.00', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(46, 8, '100 gms', '120.00', '84.00', '80.00', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(47, 8, '50 gms', '60.00', '42.00', '40.00', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(48, 8, 'Unpacked', '1200.00', '780.00', '742.86', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(49, 9, '1 KG', '1100.00', '770.00', '733.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(50, 9, '500 gms', '550.00', '385.00', '366.67', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(51, 9, '250 gms', '275.00', '192.50', '183.33', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(52, 9, '100 gms', '110.00', '77.00', '73.33', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(53, 9, '50 gms', '55.00', '38.50', '36.67', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(54, 9, 'Unpacked', '1100.00', '710.00', '676.19', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(55, 10, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(56, 10, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(57, 10, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(58, 10, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(59, 10, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(60, 10, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(61, 11, '1 KG', '1300.00', '910.00', '866.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(62, 11, '500 gms', '650.00', '455.00', '433.33', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(63, 11, '250 gms', '325.00', '227.50', '216.67', '0.00', '5', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(64, 11, '100 gms', '130.00', '91.00', '86.67', '0.00', '2', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(65, 11, '50 gms', '65.00', '45.50', '43.33', '0.00', '1', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(66, 11, 'Unpacked', '1300.00', '850.00', '809.52', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(67, 12, '500 gms', '600.00', '420.00', '400.00', '0.00', '10', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(68, 13, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(69, 14, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(70, 15, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(71, 16, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(72, 17, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(73, 18, 'Per KG', '1100.00', '770.00', '733.33', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(74, 19, 'Per KG', '1350.00', '945.00', '900.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(75, 20, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(76, 21, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(77, 22, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '55', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(78, 23, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(79, 24, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(80, 25, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(81, 26, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(82, 27, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(83, 28, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(84, 29, 'Per KG', '1200.00', '840.00', '800.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(85, 30, 'Per KG', '1600.00', '1120.00', '1066.67', '0.00', '35', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(86, 31, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(87, 32, 'Per KG', '800.00', '560.00', '533.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(88, 33, 'Per KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(89, 34, 'Per KG', '800.00', '560.00', '533.33', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(90, 35, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(91, 36, 'Per KG', '850.00', '595.00', '566.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(92, 37, 'Per KG', '700.00', '490.00', '466.67', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(93, 38, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(94, 39, 'Per KG', '600.00', '420.00', '400.00', '0.00', '40', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(95, 40, 'Per KG', '700.00', '490.00', '466.67', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(96, 41, 'Per KG', '600.00', '420.00', '400.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(97, 42, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(98, 43, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(99, 44, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(100, 45, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(101, 46, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(102, 47, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(103, 48, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(104, 49, 'Per KG', '720.00', '504.00', '480.00', '0.00', '40', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(105, 50, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(106, 51, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(107, 52, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(108, 53, 'Per KG', '720.00', '504.00', '480.00', '0.00', '20', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(109, 54, 'Per KG', '720.00', '504.00', '480.00', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(110, 55, 'Per KG', '800.00', '560.00', '533.33', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(111, 56, 'Per KG', '720.00', '504.00', '480.00', '0.00', '50', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(112, 57, 'Per KG', '1000.00', '700.00', '666.67', '0.00', '50', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(113, 58, 'Per KG', '1100.00', '770.00', '733.33', '0.00', '30', '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(114, 59, '1PCS', '80.00', '44.00', '41.90', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(115, 60, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(116, 61, '1PCS', '45.00', '31.50', '30.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(117, 62, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(118, 63, '1PCS', '30.00', '21.00', '20.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(119, 64, '1PCS', '35.00', '24.50', '23.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(120, 65, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(121, 66, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(122, 67, 'Per KG', '1350.00', '945.00', '843.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(123, 68, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(124, 69, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(125, 70, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(126, 71, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(127, 72, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(128, 73, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(129, 74, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(130, 75, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(131, 76, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(132, 77, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(133, 78, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(134, 79, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(135, 80, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(136, 81, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(137, 82, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(138, 83, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(139, 84, 'Per KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(140, 85, 'Per KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(141, 86, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(142, 87, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(143, 88, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(144, 89, 'Per KG', '500.00', '350.00', '312.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(145, 90, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(146, 91, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(147, 92, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(148, 93, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(149, 94, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(150, 95, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(151, 96, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(152, 97, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(153, 98, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(154, 99, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(155, 100, 'Per KG', '600.00', '420.00', '375.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(156, 101, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(157, 102, 'Per KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(158, 103, 'Per KG', '700.00', '490.00', '437.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(159, 65, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(160, 66, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(161, 67, '100 gms', '135.00', '94.50', '84.38', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(162, 68, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(163, 69, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(164, 70, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(165, 71, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(166, 72, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(167, 73, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(168, 74, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(169, 75, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(170, 76, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(171, 77, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(172, 78, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(173, 79, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(174, 80, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(175, 81, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(176, 82, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(177, 83, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(178, 84, '100 gms', '80.00', '56.00', '50.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(179, 85, '100 gms', '80.00', '56.00', '50.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(180, 86, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(181, 87, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(182, 88, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(183, 89, '100 gms', '50.00', '35.00', '31.25', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(184, 90, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(185, 91, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(186, 92, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(187, 93, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(188, 94, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(189, 95, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(190, 96, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(191, 97, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(192, 98, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(193, 99, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(194, 100, '100 gms', '60.00', '42.00', '37.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(195, 101, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(196, 102, '100 gms', '200.00', '140.00', '125.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(197, 103, '100 gms', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(198, 104, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(199, 105, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(200, 106, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(201, 107, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(202, 108, '1 Pkt (100 gms)', '100.00', '70.00', '62.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(203, 109, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(204, 110, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(205, 111, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(206, 112, '1 Pkt (100 gms)', '200.00', '140.00', '118.64', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(207, 113, '1 Pkt (100 gms)', '150.00', '105.00', '88.98', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(208, 114, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(209, 115, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(210, 116, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(211, 117, '1 KG', '2000.00', '1400.00', '1186.44', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(212, 118, '1 KG', '1500.00', '1050.00', '889.83', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(213, 119, '1 KG', '1000.00', '700.00', '593.22', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(214, 120, 'Per Bottle', '70.00', '49.00', '41.53', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(215, 121, 'Per Bottle', '50.00', '35.00', '33.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(216, 122, 'Per Bottle', '70.00', '49.00', '41.53', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(217, 123, 'Per Bottle', '70.00', '49.00', '46.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(218, 124, 'Per Bottle', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(219, 125, 'Per Bottle', '70.00', '49.00', '43.75', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(220, 126, '1 KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(221, 127, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(222, 128, '1 KG', '1500.00', '1050.00', '1000.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(223, 129, '1 KG', '800.00', '560.00', '533.33', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(224, 130, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(225, 131, '1 KG', '800.00', '560.00', '500.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(226, 132, '1 KG', '1500.00', '1050.00', '937.50', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(227, 133, '1 KG', '2000.00', '1400.00', '1250.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(228, 134, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(229, 135, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(230, 136, 'Per Pack', '300.00', '210.00', '200.00', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48'),
(231, 137, 'Per Pack', '250.00', '175.00', '166.67', '0.00', NULL, '2025-05-19 10:08:48', '2025-05-19 10:08:48');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_product` (`user_id`,`product_id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `fk_cart_order` (`order_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `metrics`
--
ALTER TABLE `metrics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `metric_constants`
--
ALTER TABLE `metric_constants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id` (`order_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_category` (`category_id`);

--
-- Indexes for table `product_metrics`
--
ALTER TABLE `product_metrics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cart_items`
--
ALTER TABLE `cart_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `metrics`
--
ALTER TABLE `metrics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=232;

--
-- AUTO_INCREMENT for table `metric_constants`
--
ALTER TABLE `metric_constants`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT for table `product_metrics`
--
ALTER TABLE `product_metrics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=232;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cart_items`
--
ALTER TABLE `cart_items`
  ADD CONSTRAINT `cart_items_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cart_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `metrics`
--
ALTER TABLE `metrics`
  ADD CONSTRAINT `metrics_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `order_details`
--
ALTER TABLE `order_details`
  ADD CONSTRAINT `order_details_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`),
  ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `product_metrics`
--
ALTER TABLE `product_metrics`
  ADD CONSTRAINT `product_metrics_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

