-- Products
INSERT INTO products (product_id, name, description, category, brand, sku,
                      stock_quantity, reorder_level, supplier, weight_grams, dimensions_cm,
                      color, release_date, price, discount, rating, active)
VALUES (1, 'Ceramic Mug', '350ml ceramic coffee mug', 'Home & Kitchen', 'BrewCraft', 'MUG-350-WHT',
        120, 10, 'BrewCraft Supplies', 320, '9x9x10', 'White', '2022-05-15', 9.90, 10.0, 4.6, TRUE),
       (2, 'Notebook A5', 'A5 dotted notebook, 120 pages', 'Stationery', 'PaperNest', 'NBK-A5-DOT',
        250, 20, 'PaperNest Co.', 180, '21x14x1', 'Brown', '2022-03-10', 7.50, 0.0, 4.8, TRUE),
       (3, 'Water Bottle', '1L stainless steel bottle', 'Outdoor', 'AquaMate', 'BOT-1000-SS',
        80, 15, 'AquaMate Imports', 380, '28x8x8', 'Silver', '2023-01-22', 24.90, 5.0, 4.5, TRUE),
       (4, 'Backpack', '18L daypack with laptop sleeve', 'Bags', 'TrailPro', 'BAG-18L-GRY',
        60, 10, 'TrailPro Gear', 700, '45x30x15', 'Grey', '2023-04-01', 59.00, 0.0, 4.7, TRUE),
       (5, 'Cotton T-Shirt', 'Unisex, size M', 'Apparel', 'ComfyWear', 'TSH-M-COT',
        140, 25, 'ComfyWear Ltd.', 220, '30x25x2', 'Blue', '2023-06-15', 14.90, 15.0, 4.4, TRUE),
       (6, 'Wireless Headphones', 'On-ear, bluetooth', 'Electronics', 'SoundZen', 'HD-ON-BT-BLK',
        90, 10, 'SoundZen Audio', 280, '18x17x7', 'Black', '2022-11-05', 89.00, 20.0, 4.3, TRUE),
       (7, 'Bluetooth Speaker', 'Portable 10W waterproof speaker', 'Electronics', 'SoundZen', 'SPK-BT-10W',
        150, 20, 'SoundZen Audio', 400, '10x10x9', 'Red', '2023-02-14', 39.90, 5.0, 4.6, TRUE),
       (8, 'Desk Lamp', 'LED lamp with adjustable arm', 'Home & Office', 'LumiTech', 'LMP-LED-ARM',
        75, 10, 'LumiTech Lighting', 850, '50x15x10', 'Silver', '2023-07-01', 29.50, 0.0, 4.2, TRUE),
       (9, 'Yoga Mat', 'Non-slip 6mm thick exercise mat', 'Sports', 'FlexFit', 'MAT-YOGA-6MM',
        100, 15, 'FlexFit Gear', 1250, '180x60x0.6', 'Purple', '2023-03-18', 22.90, 10.0, 4.9, TRUE),
       (10, 'Travel Mug', 'Insulated stainless steel, 400ml', 'Home & Kitchen', 'BrewCraft', 'MUG-400-INS',
        130, 15, 'BrewCraft Supplies', 350, '8x8x17', 'Black', '2022-08-10', 15.90, 0.0, 4.5, TRUE),
       (11, 'Laptop Stand', 'Adjustable aluminum stand for laptops up to 17"', 'Electronics', 'TechLift', 'LST-AL-17',
        60, 10, 'TechLift Solutions', 700, '25x22x6', 'Silver', '2023-01-05', 34.00, 5.0, 4.7, TRUE),
       (12, 'Wireless Mouse', 'Ergonomic optical mouse, rechargeable', 'Electronics', 'ClickPro', 'MSE-WL-ERG',
        120, 15, 'ClickPro Electronics', 150, '12x7x4', 'Black', '2023-03-01', 19.90, 0.0, 4.8, TRUE),
       (13, 'Phone Holder', 'Flexible gooseneck mount for desk or bed', 'Accessories', 'GripEase', 'HLD-GOOSENECK',
        180, 25, 'GripEase Manufacturing', 350, '70x7x7', 'Black', '2022-09-20', 12.90, 0.0, 4.4, TRUE),
       (14, 'Power Bank', '10000mAh USB-C fast charging', 'Electronics', 'VoltMax', 'PBK-10K-USB-C',
        95, 15, 'VoltMax Energy', 220, '14x7x2', 'Black', '2023-05-02', 29.90, 10.0, 4.6, TRUE),
       (15, 'Smartwatch', 'Fitness tracker with heart rate monitor', 'Wearables', 'FitPulse', 'SWT-FIT-HRM',
        75, 10, 'FitPulse Tech', 90, '4x4x1', 'Black', '2023-03-12', 79.00, 0.0, 4.3, TRUE),
       (16, 'Sunglasses', 'Polarized UV400 protection, unisex', 'Accessories', 'SunEdge', 'GLS-UV400',
        150, 25, 'SunEdge Optics', 90, '15x6x5', 'Brown', '2023-04-11', 24.90, 10.0, 4.5, TRUE),
       (17, 'Running Shoes', 'Lightweight mesh upper, size 42', 'Footwear', 'StrideMax', 'RUN-SZ42',
        85, 15, 'StrideMax Sports', 600, '30x20x12', 'Black', '2023-06-01', 69.00, 5.0, 4.7, TRUE),
       (18, 'Wireless Keyboard', 'Compact Bluetooth keyboard with numeric pad', 'Electronics', 'KeyMaster', 'KYB-BT-NP',
        70, 10, 'KeyMaster Electronics', 480, '40x13x2', 'White', '2023-02-25', 45.00, 0.0, 4.5, TRUE),
       (19, 'Desk Organizer', 'Wooden pen holder and cable management set', 'Home & Office', 'WoodWorks',
        'ORG-WOOD-SET',
        110, 20, 'WoodWorks Studio', 600, '25x15x10', 'Walnut', '2022-12-10', 18.90, 0.0, 4.9, TRUE),
       (20, 'LED Strip Light', '5m RGB with remote control', 'Lighting', 'LumiTech', 'LED-STRIP-5M',
        80, 15, 'LumiTech Lighting', 250, '18x18x6', 'Multi', '2023-03-05', 16.50, 0.0, 4.4, TRUE),
       (21, 'Gaming Mouse Pad', 'Large extended surface, anti-slip base', 'Gaming', 'ClickPro', 'PAD-GAME-XL',
        140, 20, 'ClickPro Electronics', 420, '90x40x0.3', 'Black', '2023-01-12', 14.00, 0.0, 4.6, TRUE),
       (22, 'Thermal Flask', '750ml vacuum insulated, keeps drinks hot for 12h', 'Outdoor', 'AquaMate', 'FLK-750-SS',
        75, 10, 'AquaMate Imports', 450, '27x8x8', 'Silver', '2022-10-14', 27.90, 5.0, 4.8, TRUE),
       (23, 'Canvas Tote Bag', 'Eco-friendly reusable bag, 38x42cm', 'Bags', 'EcoCarry', 'BAG-CANVAS',
        220, 30, 'EcoCarry Supplies', 160, '38x42x1', 'Beige', '2023-05-18', 9.50, 0.0, 4.7, TRUE),
       (24, 'Smart Plug', 'Wi-Fi enabled, works with Alexa and Google Home', 'Smart Home', 'VoltMax', 'PLG-SM-WIFI',
        60, 10, 'VoltMax Energy', 150, '7x5x5', 'White', '2023-02-01', 19.00, 0.0, 4.2, TRUE),
       (25, 'Noise-Cancelling Earbuds', 'In-ear, with charging case', 'Electronics', 'SoundZen', 'EAR-NC-BT',
        85, 10, 'SoundZen Audio', 80, '6x4x3', 'Black', '2023-03-22', 59.90, 5.0, 4.4, TRUE),
       (26, 'Mechanical Keyboard', 'RGB backlit, tactile switches', 'Gaming', 'KeyMaster', 'KYB-MECH-RGB',
        70, 10, 'KeyMaster Electronics', 980, '45x14x4', 'Black', '2022-09-28', 89.00, 10.0, 4.8, TRUE),
       (27, 'Portable Charger', '20000mAh power bank with fast charging', 'Electronics', 'VoltMax', 'PBK-20K-FC',
        90, 15, 'VoltMax Energy', 380, '16x8x2', 'Black', '2023-04-05', 39.90, 0.0, 4.5, TRUE),
       (28, 'Wireless Charger', 'Qi-certified 15W fast charging pad', 'Electronics', 'VoltMax', 'CHR-WL-15W',
        100, 15, 'VoltMax Energy', 200, '10x10x1', 'White', '2023-02-10', 24.90, 0.0, 4.3, TRUE),
       (29, 'Smart LED Bulb', 'Wi-Fi enabled RGB bulb, E27 socket', 'Smart Home', 'LumiTech', 'BULB-RGB-E27',
        140, 20, 'LumiTech Lighting', 120, '6x6x11', 'White', '2022-11-17', 14.90, 0.0, 4.6, TRUE),
       (30, 'Action Camera', '4K waterproof sports camera with accessories', 'Electronics', 'VisionPro', 'CAM-4K-SPRT',
        60, 10, 'VisionPro Tech', 350, '7x5x4', 'Black', '2023-01-09', 89.00, 10.0, 4.4, TRUE),
       (31, 'Laptop Sleeve', 'Neoprene 15-inch protective sleeve', 'Accessories', 'TechLift', 'SLV-15-NPRN',
        100, 15, 'TechLift Solutions', 280, '38x26x2', 'Grey', '2023-03-01', 17.90, 0.0, 4.5, TRUE),
       (32, 'USB-C Hub', '6-in-1 adapter with HDMI, USB, SD, and PD ports', 'Electronics', 'TechLift', 'HUB-USB-C-6IN1',
        80, 10, 'TechLift Solutions', 120, '9x4x1', 'Grey', '2023-06-12', 34.90, 5.0, 4.7, TRUE),
       (33, 'External SSD', 'Portable 1TB USB 3.2 drive', 'Storage', 'DataSwift', 'SSD-1TB-USB3',
        70, 10, 'DataSwift Storage', 100, '10x6x1', 'Black', '2022-12-01', 109.00, 0.0, 4.9, TRUE),
       (34, 'Smart Scale', 'Bluetooth body composition scale', 'Smart Home', 'FitPulse', 'SCL-BT-BODY',
        65, 10, 'FitPulse Tech', 1600, '32x32x3', 'White', '2023-01-19', 49.90, 5.0, 4.4, TRUE),
       (35, 'Electric Toothbrush', 'Rechargeable sonic toothbrush with 3 modes', 'Personal Care', 'SmilePro',
        'TBH-SNC-3M',
        120, 20, 'SmilePro Dental', 300, '24x4x4', 'White', '2023-02-07', 39.00, 0.0, 4.6, TRUE),
       (36, 'Mini Tripod', 'Flexible tripod with phone mount', 'Photography', 'VisionPro', 'TRP-MINI-FLX',
        130, 20, 'VisionPro Tech', 260, '25x5x5', 'Black', '2022-10-23', 12.90, 0.0, 4.5, TRUE),
       (37, 'Reusable Water Cup', 'Glass cup with silicone sleeve, 400ml', 'Home & Kitchen', 'EcoCarry', 'CUP-GLS-400',
        110, 15, 'EcoCarry Supplies', 360, '8x8x15', 'Green', '2023-05-10', 14.00, 5.0, 4.6, TRUE),
       (38, 'Cable Organizer', 'Magnetic silicone cable clips, 3-pack', 'Accessories', 'GripEase', 'ORG-CABLE-3P',
        180, 25, 'GripEase Manufacturing', 80, '12x8x1', 'Grey', '2023-02-15', 8.90, 0.0, 4.7, TRUE),
       (39, 'USB Flash Drive', '64GB high-speed USB 3.0 memory stick', 'Storage', 'DataSwift', 'USB-64GB-3.0',
        150, 20, 'DataSwift Storage', 50, '6x2x1', 'Black', '2023-01-22', 11.90, 0.0, 4.8, TRUE),
       (40, 'Bluetooth Tracker', 'Smart key finder with app connectivity', 'Smart Home', 'VoltMax', 'TRK-BT-APP',
        100, 15, 'VoltMax Energy', 60, '4x4x1', 'White', '2022-09-12', 19.90, 0.0, 4.3, TRUE),
       (41, 'Coffee Grinder', 'Manual stainless steel burr grinder', 'Home & Kitchen', 'BrewCraft', 'GRD-MAN-SS',
        70, 10, 'BrewCraft Supplies', 420, '19x5x5', 'Silver', '2023-01-10', 29.00, 0.0, 4.7, TRUE),
       (42, 'Desk Mat', 'PU leather dual-sided writing pad, 80x40cm', 'Home & Office', 'WoodWorks', 'MAT-DESK-PU',
        90, 10, 'WoodWorks Studio', 600, '80x40x0.2', 'Black', '2023-04-20', 22.50, 0.0, 4.8, TRUE),
       (43, 'Smart Thermometer', 'Infrared non-contact digital thermometer', 'Smart Home', 'HealthEase',
        'THM-INFRA-DIG',
        80, 10, 'HealthEase Medical', 220, '14x5x4', 'White', '2023-02-12', 32.90, 0.0, 4.6, TRUE),
       (44, 'Mini Projector', '1080p portable LED projector, HDMI support', 'Electronics', 'VisionPro', 'PRJ-MINI-1080',
        55, 10, 'VisionPro Tech', 900, '18x15x8', 'White', '2023-03-11', 139.00, 10.0, 4.5, TRUE),
       (45, 'Foldable Headphones', 'Over-ear wired headphones with mic', 'Electronics', 'SoundZen', 'HD-FLD-WRD',
        95, 10, 'SoundZen Audio', 320, '18x15x6', 'Black', '2022-12-20', 27.90, 0.0, 4.4, TRUE),
       (46, 'USB Desk Fan', 'Quiet 3-speed metal fan, USB powered', 'Home & Office', 'BreezeTech', 'FAN-USB-MET',
        100, 10, 'BreezeTech Appliances', 450, '17x15x10', 'Silver', '2023-03-08', 16.50, 0.0, 4.5, TRUE),
       (47, 'Electric Kettle', '1.7L stainless steel cordless kettle', 'Home & Kitchen', 'BrewCraft', 'KTL-17L-SS',
        85, 10, 'BrewCraft Supplies', 1150, '22x18x15', 'Silver', '2023-02-05', 34.90, 10.0, 4.7, TRUE),
       (48, 'Smart Doorbell', 'Wi-Fi video doorbell with motion detection and night vision', 'Smart Home', 'VoltMax',
        'DBL-WIFI-VID',
        55, 8, 'VoltMax Energy', 260, '13x6x4', 'Black', '2023-06-01', 79.00, 5.0, 4.5, TRUE),
       (49, 'Fitness Resistance Bands', 'Set of 5 latex workout bands with carry bag', 'Sports', 'FlexFit', 'BND-SET-5',
        160, 20, 'FlexFit Gear', 280, '20x15x3', 'Multi', '2023-03-27', 14.90, 0.0, 4.8, TRUE),
       (50, 'Wireless Presenter', 'Laser pointer and slide controller, USB-C receiver', 'Electronics', 'ClickPro',
        'PRS-WL-USBC',
        95, 10, 'ClickPro Electronics', 120, '13x3x2', 'Black', '2023-05-14', 24.90, 0.0, 4.6, TRUE);
