INSERT IGNORE INTO `Category` (`id`, `name`, `slug`, `description`) VALUES
  (UUID(), 'Phones', 'phones', 'Smartphones and feature phones'),
  (UUID(), 'Laptops', 'laptops', 'Laptops and notebooks'),
  (UUID(), 'Accessories', 'accessories', 'Cases, chargers, cables, and more'),
  (UUID(), 'Smart Home', 'smart-home', 'Smart gadgets for your home'),
  (UUID(), 'Audio', 'audio', 'Headphones, earphones, and speakers');

SET @cat_phones = (SELECT `id` FROM `Category` WHERE `slug` = 'phones');
SET @cat_laptops = (SELECT `id` FROM `Category` WHERE `slug` = 'laptops');
SET @cat_accessories = (SELECT `id` FROM `Category` WHERE `slug` = 'accessories');
SET @cat_smarthome = (SELECT `id` FROM `Category` WHERE `slug` = 'smart-home');
SET @cat_audio = (SELECT `id` FROM `Category` WHERE `slug` = 'audio');

INSERT IGNORE INTO `Product` (`id`, `name`, `slug`, `description`, `price`, `comparePrice`, `stock`, `images`, `specs`, `isFeatured`, `status`, `categoryId`) VALUES
  (UUID(), 'Samsung Galaxy A24', 'samsung-galaxy-a24', '6.5" Super AMOLED, 128GB, 5000mAh battery, 50MP camera.', 28500.00, 32000.00, 15, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'Samsung', 'screen', '6.5"', 'storage', '128GB', 'battery', '5000mAh'), 1, 'active', @cat_phones),
  (UUID(), 'iPhone 13', 'iphone-13', '6.1" OLED, 128GB, A15 Bionic, 5G ready.', 72000.00, 78000.00, 8, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'Apple', 'screen', '6.1"', 'storage', '128GB', 'chip', 'A15 Bionic'), 1, 'active', @cat_phones),
  (UUID(), 'HP 250 G8 Laptop', 'hp-250-g8-laptop', '15.6" HD, Intel Core i3, 4GB RAM, 1TB HDD, Windows 11.', 42000.00, 48000.00, 6, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'HP', 'screen', '15.6"', 'ram', '4GB', 'storage', '1TB HDD'), 1, 'active', @cat_laptops),
  (UUID(), 'Lenovo IdeaPad 3', 'lenovo-ideapad-3', '14" FHD, AMD Ryzen 3, 8GB RAM, 256GB SSD.', 48500.00, NULL, 4, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'Lenovo', 'screen', '14"', 'ram', '8GB', 'storage', '256GB SSD'), 0, 'active', @cat_laptops),
  (UUID(), 'Anker PowerPort Charger', 'anker-powerport-charger', '20W fast wall charger with USB-C cable included.', 1800.00, 2500.00, 50, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'Anker', 'wattage', '20W', 'ports', '1x USB-C'), 0, 'active', @cat_accessories),
  (UUID(), 'USB-C to HDMI Cable', 'usb-c-to-hdmi-cable', '2m braided USB-C to HDMI cable, 4K support.', 1500.00, NULL, 30, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('length', '2m', 'resolution', '4K', 'type', 'USB-C to HDMI'), 0, 'active', @cat_accessories),
  (UUID(), 'Xiaomi Mi Smart Band 7', 'xiaomi-mi-smart-band-7', 'Fitness tracker with AMOLED display, 14-day battery, heart rate monitor.', 4500.00, 5500.00, 20, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'Xiaomi', 'battery', '14 days', 'features', 'Heart rate, SpO2'), 1, 'active', @cat_smarthome),
  (UUID(), 'JBL Tune 510BT', 'jbl-tune-510bt', 'Wireless on-ear headphones with deep bass, 40h battery.', 5500.00, 6500.00, 12, JSON_ARRAY('/placeholder.svg'), JSON_OBJECT('brand', 'JBL', 'type', 'Wireless', 'battery', '40h'), 0, 'active', @cat_audio);
