-- Shoeniverse update: 14 Nov 2026: 7 tracksuit sets at KES 6,500; official shoes KES 4,500; other unpriced sets KES 6,500
-- phpMyAdmin › shoeniverse database › SQL › paste › Go. Safe to run twice.
SET NAMES utf8mb4;
START TRANSACTION;

-- Zip hoodie tracksuit with chest stripe
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Zip hoodie tracksuit with chest stripe','zip-hoodie-tracksuit-with-chest-stripe-2','Zip hoodie tracksuit with chest stripe in black. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Tracksuit","Set"]','["Black"]','Zip hoodie tracksuit with chest stripe | Shoeniverse Nairobi','Zip hoodie tracksuit with chest stripe in black. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:zip-hoodie-tracksuit-with-chest-stripe-black','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:zip-hoodie-tracksuit-with-chest-stripe-black');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:zip-hoodie-tracksuit-with-chest-stripe-black');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-706-1-M','M','Black','Black',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-706-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-706-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-706-1-L','L','Black','Black',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-706-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-706-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-706-1-XL','XL','Black','Black',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-706-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-706-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-706-1-2XL','2XL','Black','Black',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-706-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-706-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-706-1-3XL','3XL','Black','Black',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-706-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-706-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/706/eYZcCVylWItx9JyrtfGV.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.29.jpeg','Zip hoodie tracksuit with chest stripe – Black',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/706/eYZcCVylWItx9JyrtfGV.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Piped track jacket tracksuit
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Piped track jacket tracksuit','piped-track-jacket-tracksuit','Piped track jacket tracksuit in black. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Tracksuit","Set"]','["Black"]','Piped track jacket tracksuit | Shoeniverse Nairobi','Piped track jacket tracksuit in black. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:piped-track-jacket-tracksuit-black','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:piped-track-jacket-tracksuit-black');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:piped-track-jacket-tracksuit-black');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-705-1-M','M','Black','Black',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-705-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-705-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-705-1-L','L','Black','Black',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-705-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-705-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-705-1-XL','XL','Black','Black',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-705-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-705-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-705-1-2XL','2XL','Black','Black',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-705-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-705-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-705-1-3XL','3XL','Black','Black',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-705-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-705-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/705/NMTL6aWmxHsEjWb9XIdZ.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.29 (3).jpeg','Piped track jacket tracksuit – Black',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/705/NMTL6aWmxHsEjWb9XIdZ.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Piped hoodie tracksuit
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Piped hoodie tracksuit','piped-hoodie-tracksuit','Piped hoodie tracksuit in black / grey. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Tracksuit","Set"]','["Multi"]','Piped hoodie tracksuit | Shoeniverse Nairobi','Piped hoodie tracksuit in black / grey. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:piped-hoodie-tracksuit-black-grey','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:piped-hoodie-tracksuit-black-grey');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:piped-hoodie-tracksuit-black-grey');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-704-1-M','M','Black / grey','Multi',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-704-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-704-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-704-1-L','L','Black / grey','Multi',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-704-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-704-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-704-1-XL','XL','Black / grey','Multi',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-704-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-704-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-704-1-2XL','2XL','Black / grey','Multi',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-704-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-704-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-704-1-3XL','3XL','Black / grey','Multi',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-704-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-704-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/704/6I2Mumell8Il8jS8TMLP.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.29 (2).jpeg','Piped hoodie tracksuit – Black / grey',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/704/6I2Mumell8Il8jS8TMLP.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Zip hoodie tracksuit with chest stripe
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Zip hoodie tracksuit with chest stripe','zip-hoodie-tracksuit-with-chest-stripe','Zip hoodie tracksuit with chest stripe in cream. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Tracksuit","Set"]','["Beige"]','Zip hoodie tracksuit with chest stripe | Shoeniverse Nairobi','Zip hoodie tracksuit with chest stripe in cream. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:zip-hoodie-tracksuit-with-chest-stripe-cream','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:zip-hoodie-tracksuit-with-chest-stripe-cream');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:zip-hoodie-tracksuit-with-chest-stripe-cream');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-703-1-M','M','Cream','Beige',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-703-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-703-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-703-1-L','L','Cream','Beige',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-703-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-703-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-703-1-XL','XL','Cream','Beige',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-703-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-703-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-703-1-2XL','2XL','Cream','Beige',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-703-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-703-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-703-1-3XL','3XL','Cream','Beige',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-703-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-703-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/703/Q09kDOgx7co7oJz1LlDf.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.29 (1).jpeg','Zip hoodie tracksuit with chest stripe – Cream',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/703/Q09kDOgx7co7oJz1LlDf.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Textured shirt & trouser set
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Textured shirt & trouser set','textured-shirt-trouser-set-2','Textured shirt & trouser set in black. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Set","Shirt set"]','["Black"]','Textured shirt & trouser set | Shoeniverse Nairobi','Textured shirt & trouser set in black. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:textured-shirt-trouser-set-black','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:textured-shirt-trouser-set-black');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:textured-shirt-trouser-set-black');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-702-1-M','M','Black','Black',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-702-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-702-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-702-1-L','L','Black','Black',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-702-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-702-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-702-1-XL','XL','Black','Black',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-702-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-702-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-702-1-2XL','2XL','Black','Black',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-702-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-702-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-702-1-3XL','3XL','Black','Black',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-702-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-702-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/702/3VcIVkyRN2I6JQoH74qp.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.28.jpeg','Textured shirt & trouser set – Black',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/702/3VcIVkyRN2I6JQoH74qp.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Textured shirt & trouser set
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Textured shirt & trouser set','textured-shirt-trouser-set','Textured shirt & trouser set in white. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Set","Shirt set"]','["White"]','Textured shirt & trouser set | Shoeniverse Nairobi','Textured shirt & trouser set in white. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:textured-shirt-trouser-set-white','2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:textured-shirt-trouser-set-white');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:textured-shirt-trouser-set-white');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-701-1-M','M','White','White',NULL,0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-701-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-701-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-701-1-L','L','White','White',NULL,1,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-701-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-701-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-701-1-XL','XL','White','White',NULL,2,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-701-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-701-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-701-1-2XL','2XL','White','White',NULL,3,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-701-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-701-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-701-1-3XL','3XL','White','White',NULL,4,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-701-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-701-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/701/O972yFSjkBkUlkRCEf9n.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.28 (1).jpeg','Textured shirt & trouser set – White',0,'2026-11-14 07:20:41','2026-11-14 07:20:41' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/701/O972yFSjkBkUlkRCEf9n.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Panelled hoodie tracksuit
INSERT INTO `products` (`category_id`,`name`,`slug`,`description`,`price`,`compare_at_price`,`status`,`is_addon`,`coming_soon`,`tags`,`colour_families`,`seo_title`,`seo_description`,`review_flags`,`source_ref`,`created_at`,`updated_at`) SELECT (SELECT `id` FROM `categories` WHERE `slug` = 'full-sets'),'Panelled hoodie tracksuit','panelled-hoodie-tracksuit','Panelled hoodie tracksuit in black / grey. Sizes M–3XL. Ask us on WhatsApp for measurements. Pick up at Shoeniverse, Dubai Merchant Mall F46, or order online for delivery.',6500,NULL,'published',0,0,'["Tracksuit","Set"]','["Multi"]','Panelled hoodie tracksuit | Shoeniverse Nairobi','Panelled hoodie tracksuit in black / grey. Pick up at Dubai Merchant Mall F46 or order online for delivery.','["confirm sizes in stock"]','own:panelled-hoodie-tracksuit-black-grey','2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `products` WHERE `source_ref` = 'own:panelled-hoodie-tracksuit-black-grey');
SET @p = (SELECT `id` FROM `products` WHERE `source_ref` = 'own:panelled-hoodie-tracksuit-black-grey');
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-700-1-M','M','Black / grey','Multi',NULL,0,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-700-1-M');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-700-1-M');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-700-1-L','L','Black / grey','Multi',NULL,1,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-700-1-L');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-700-1-L');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-700-1-XL','XL','Black / grey','Multi',NULL,2,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-700-1-XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-700-1-XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-700-1-2XL','2XL','Black / grey','Multi',NULL,3,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-700-1-2XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-700-1-2XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `variants` (`product_id`,`sku`,`size`,`colour`,`colour_family`,`price_override`,`position`,`created_at`,`updated_at`) SELECT @p,'SV-OWN-700-1-3XL','3XL','Black / grey','Multi',NULL,4,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `variants` WHERE `sku` = 'SV-OWN-700-1-3XL');
SET @v = (SELECT `id` FROM `variants` WHERE `sku` = 'SV-OWN-700-1-3XL');
INSERT INTO `variant_stocks` (`variant_id`,`shop_id`,`quantity`,`created_at`,`updated_at`) SELECT @v, s.`id`, NULL, NOW(), NOW() FROM `shops` s WHERE NOT EXISTS (SELECT 1 FROM `variant_stocks` x WHERE x.`variant_id` = @v AND x.`shop_id` = s.`id`);
INSERT INTO `product_images` (`product_id`,`path`,`source_url`,`alt`,`position`,`created_at`,`updated_at`) SELECT @p,'products/700/WgM5hDLbPzOmApeVNfMN.jpeg','own/ts/WhatsApp Image 2026-11-13 at 17.09.27.jpeg','Panelled hoodie tracksuit – Black / grey',0,'2026-11-14 07:20:40','2026-11-14 07:20:40' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `product_images` WHERE `path` = 'products/700/WgM5hDLbPzOmApeVNfMN.jpeg');
SET @hs = (SELECT `id` FROM `homepage_sections` WHERE `key` = 'new-arrivals');
SET @has = (SELECT COUNT(*) FROM `homepage_section_product` WHERE `homepage_section_id` = @hs AND `product_id` = @p);
UPDATE `homepage_section_product` SET `position` = `position` + 1 WHERE `homepage_section_id` = @hs AND @has = 0;
INSERT INTO `homepage_section_product` (`homepage_section_id`,`product_id`,`position`) SELECT @hs, @p, 0 FROM DUAL WHERE @hs IS NOT NULL AND @has = 0;

-- Prices for items still showing "Ask for price"
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:woven-leather-lace-up-navy' AND `price` = 0; -- Woven leather lace-up
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:woven-horsebit-loafer-black-tan-navy' AND `price` = 0; -- Woven horsebit loafer
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:woven-leather-lace-up-tan' AND `price` = 0; -- Woven leather lace-up
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:woven-double-monk-loafer-navy-black-tan' AND `price` = 0; -- Woven double-monk loafer
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:woven-tassel-loafer-tan-navy-black' AND `price` = 0; -- Woven tassel loafer
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:textured-tassel-loafer-brown-black' AND `price` = 0; -- Textured tassel loafer
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:bit-loafer-brown-black' AND `price` = 0; -- Bit loafer
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:monk-strap-shoe-red-sole-brown-black' AND `price` = 0; -- Monk-strap shoe, red sole
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:single-monk-strap-shoe-brown-black' AND `price` = 0; -- Single monk-strap shoe
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:leather-oxford-black-brown' AND `price` = 0; -- Leather oxford
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:patent-lace-up-black' AND `price` = 0; -- Patent lace-up
UPDATE `products` SET `price` = 4500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:cut-out-bit-loafer-brown' AND `price` = 0; -- Cut-out bit loafer
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:zip-hoodie-sweatpants-set-light-blue-black' AND `price` = 0; -- Zip hoodie & sweatpants set
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:zip-hoodie-set-with-gold-trim-black' AND `price` = 0; -- Zip hoodie set with gold trim
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:zip-hoodie-set-grey' AND `price` = 0; -- Zip hoodie set
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:graphic-hoodie-track-pants-black' AND `price` = 0; -- Graphic hoodie & track pants
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:track-jacket-pants-olive' AND `price` = 0; -- Track jacket & pants
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:hooded-tracksuit-brown' AND `price` = 0; -- Hooded tracksuit
UPDATE `products` SET `price` = 6500, `review_flags` = '["confirm sizes in stock"]', `updated_at` = NOW() WHERE `source_ref` = 'own:short-sleeve-shirt-trouser-set-black-white' AND `price` = 0; -- Short-sleeve shirt & trouser set
COMMIT;
