-- =============================================================================
-- BhoFit catalog seed (categories + products)
-- Import in phpMyAdmin AFTER deploy/fliemart-import.sql
-- Images are Unsplash URLs — you do NOT need to upload images for this seed.
-- Safe to re-run: clears OrderItem/Order/Product/Category then re-inserts catalog.
-- Does NOT delete users or settings.
-- =============================================================================
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DELETE FROM `OrderItem`;
DELETE FROM `Order`;
DELETE FROM `Product`;
DELETE FROM `Category`;
SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO `Category` (`id`, `name`, `slug`, `description`, `image`, `gender`, `createdAt`, `updatedAt`) VALUES
('cat-outerwear', 'Outerwear', 'outerwear', 'Lightweight layers, blazers, and everyday jackets.', 'https://images.unsplash.com/photo-1539533018447-63fcce2678e3?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-tops', 'T-Shirts & Sweats', 'tops', 'Crews, mini tees, and easy sweatshirts.', 'https://images.unsplash.com/photo-1521572163474-6864f9cf17ab?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-bottoms', 'Bottoms', 'bottoms', 'Barrel jeans, easy pants, shorts, and wide legs.', 'https://images.unsplash.com/photo-1541099649105-f69ad21f3246?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-shirts', 'Shirts & Blouses', 'shirts', 'Oxfords, linen camp shirts, and clean collars.', 'https://images.unsplash.com/photo-1488161628813-04466f872be2?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-sweaters', 'Sweaters & Cardigans', 'sweaters', 'Fine-gauge crews and cropped cardigans.', 'https://images.unsplash.com/photo-1434389677669-e08b4cac3105?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-dresses', 'Dresses & Skirts', 'dresses', 'Easy dresses, culottes, and pleated skirts.', 'https://images.unsplash.com/photo-1595777457583-95e059d581b8?auto=format&fit=crop&w=1200&q=80', 'women', NOW(3), NOW(3)),
('cat-innerwear', 'Innerwear', 'innerwear', 'Soft everyday bras, tanks, and underwear.', 'https://images.unsplash.com/photo-1441984904996-e0b6ba687e04?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-loungewear', 'Loungewear', 'loungewear', 'Home wear that still looks put together.', 'https://images.unsplash.com/photo-1485230895905-ec40ba36b9bc?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-accessories', 'Accessories', 'accessories', 'Bags, socks, and small daily extras.', 'https://images.unsplash.com/photo-1590874103328-eac38a683ce7?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-kids', 'Kids', 'kids', 'Soft tees, shorts, and easy kidswear.', 'https://images.unsplash.com/photo-1503454537195-1dcabb73ffb9?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3)),
('cat-baby', 'Baby', 'baby', 'Gentle knits and everyday baby layers.', 'https://images.unsplash.com/photo-1515488042361-ee00e0ddd4e4?auto=format&fit=crop&w=1200&q=80', 'all', NOW(3), NOW(3));

INSERT INTO `Product` (`id`, `name`, `slug`, `price`, `compareAt`, `categoryId`, `categoryName`, `categorySlug`, `gender`, `description`, `shortDescription`, `longDescription`, `details`, `materials`, `care`, `fit`, `sizeGuide`, `sizeGuideNote`, `images`, `variants`, `stock`, `rating`, `reviewCount`, `tags`, `featured`, `flashSale`, `recentlyOrdered`, `bestSeller`, `newArrival`, `seller`, `verified`, `sold`, `flashLimit`, `createdAt`, `updatedAt`) VALUES
('bottoms-barrel-jeans', 'Barrel Jeans', 'bottoms-barrel-jeans', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Barrel Jeans — simple, well-made clothes for every day.', 'Barrel Jeans — simple, well-made clothes for every day.', 'Barrel Jeans is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1541099649105-f69ad21f3246?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1576995853123-5a10305d93c0?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1523275335684-37898b6baf30?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 18, 4.4, 12, '["bottoms","unisex","lifewear"]', 1, 0, 1, 1, 0, 'BhoFit', 1, NULL, NULL, '2026-01-01 00:00:00.000', NOW(3)),
('bottoms-jersey-barrel-pants', 'Jersey Barrel Pants', 'bottoms-jersey-barrel-pants', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Jersey Barrel Pants — simple, well-made clothes for every day.', 'Jersey Barrel Pants — simple, well-made clothes for every day.', 'Jersey Barrel Pants is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1524504388940-b1c1722653e1?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1509631179647-0177331693ae?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1487222477894-8943e31ef7b2?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 25, 4.5, 53, '["bottoms","unisex","lifewear"]', 0, 0, 0, 1, 1, 'BhoFit', 1, NULL, NULL, '2026-02-02 00:00:00.000', NOW(3)),
('bottoms-baggy-jeans', 'Baggy Jeans', 'bottoms-baggy-jeans', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Baggy Jeans — simple, well-made clothes for every day.', 'Baggy Jeans — simple, well-made clothes for every day.', 'Baggy Jeans is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1604176354204-9268737828e4?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1584626128261-75a4a218fc11?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1475178626620-a4d074967452?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 32, 4.6, 94, '["bottoms","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-03-03 00:00:00.000', NOW(3)),
('bottoms-easy-waist-pants', 'Easy Waist Pants', 'bottoms-easy-waist-pants', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Easy Waist Pants — simple, well-made clothes for every day.', 'Easy Waist Pants — simple, well-made clothes for every day.', 'Easy Waist Pants is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1479064555552-3ef4979f8908?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1560243563-062bfc001d68?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1551803091-e20673f15770?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 39, 4.7, 135, '["bottoms","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-04-04 00:00:00.000', NOW(3)),
('bottoms-wide-leg-pants', 'Wide Leg Pants', 'bottoms-wide-leg-pants', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Wide Leg Pants — simple, well-made clothes for every day.', 'Wide Leg Pants — simple, well-made clothes for every day.', 'Wide Leg Pants is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1469334031218-e382a71b716b?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1534528741775-53994a69daeb?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1500917293891-ef795e70e1f6?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 46, 4.8, 176, '["bottoms","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-05-05 00:00:00.000', NOW(3)),
('bottoms-utility-wide-pants', 'Utility Wide Pants', 'bottoms-utility-wide-pants', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Utility Wide Pants — simple, well-made clothes for every day.', 'Utility Wide Pants — simple, well-made clothes for every day.', 'Utility Wide Pants is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1556906781-9a412961c28c?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1520975916090-3105956dac38?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1611312449408-fcece27cdbb7?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 53, 4.9, 217, '["bottoms","unisex","lifewear"]', 0, 0, 1, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-06-06 00:00:00.000', NOW(3)),
('bottoms-linen-blend-trousers', 'Linen Blend Trousers', 'bottoms-linen-blend-trousers', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Linen Blend Trousers — simple, well-made clothes for every day.', 'Linen Blend Trousers — simple, well-made clothes for every day.', 'Linen Blend Trousers is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1594633312681-425c7b97ccd1?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1506629082955-511b1aa562c8?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1492534513006-37715f336a39?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 20, 4.4, 258, '["bottoms","unisex","lifewear"]', 0, 0, 0, 1, 0, 'BhoFit', 1, NULL, NULL, '2026-07-07 00:00:00.000', NOW(3)),
('bottoms-dry-stretch-shorts', 'Dry Stretch Shorts', 'bottoms-dry-stretch-shorts', 49.9, NULL, 'cat-bottoms', 'Bottoms', 'bottoms', 'unisex', 'Dry Stretch Shorts — simple, well-made clothes for every day.', 'Dry Stretch Shorts — simple, well-made clothes for every day.', 'Dry Stretch Shorts is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed through the seat with a slight taper at the ankle. Unisex. Pair it with other bottoms from BhoFit.', '["Relaxed barrel-leg silhouette","Mid rise","Pockets"]', '["Cotton-blend jersey","Smooth interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed through the seat with a slight taper at the ankle. Unisex.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Compare waist with a pair you already own. Short and Tall are separate SKUs in-store.', '["https://images.unsplash.com/photo-1591195853828-11db59a44f6b?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1460353581641-37baddab0fa2?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1542291026-7eec264c27ff?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Natural","Black","Indigo","Olive","Grey"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 27, 4.5, 299, '["bottoms","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-08-08 00:00:00.000', NOW(3)),
('tops-mini-cotton-t-shirt', 'Mini Cotton T-Shirt', 'tops-mini-cotton-t-shirt', 14.9, 19.9, 'cat-tops', 'T-Shirts & Sweats', 'tops', 'unisex', 'Mini Cotton T-Shirt — simple, well-made clothes for every day.', 'Mini Cotton T-Shirt — simple, well-made clothes for every day.', 'Mini Cotton T-Shirt is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular to slightly cropped. Size up for an easier drape. Pair it with other t-shirts & sweats from BhoFit.', '["Clean crew neck","Daily-wear knit","Holds shape after wash"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular to slightly cropped. Size up for an easier drape.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Mini styles run cropped. Check length in the size guide.', '["https://images.unsplash.com/photo-1521572163474-6864f9cf17ab?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1556909114-f6e7ad7d3136?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1523381210434-271e8be1f52b?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Black","Navy","Lilac","Yellow"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 34, 4.6, 340, '["tops","unisex","limited"]', 1, 1, 0, 0, 0, 'BhoFit', 1, 18, 58, '2026-01-09 00:00:00.000', NOW(3)),
('tops-supima-crew-neck-t-shirt', 'Supima Crew Neck T-Shirt', 'tops-supima-crew-neck-t-shirt', 14.9, NULL, 'cat-tops', 'T-Shirts & Sweats', 'tops', 'unisex', 'Supima Crew Neck T-Shirt — simple, well-made clothes for every day.', 'Supima Crew Neck T-Shirt — simple, well-made clothes for every day.', 'Supima Crew Neck T-Shirt is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular to slightly cropped. Size up for an easier drape. Pair it with other t-shirts & sweats from BhoFit.', '["Clean crew neck","Daily-wear knit","Holds shape after wash"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular to slightly cropped. Size up for an easier drape.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Mini styles run cropped. Check length in the size guide.', '["https://images.unsplash.com/photo-1583743814966-8936f5b7be1a?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1562157873-818bc0726f68?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1576566588028-4147f3842f27?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Black","Navy","Lilac","Yellow"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 41, 4.7, 381, '["tops","unisex","lifewear"]', 0, 0, 0, 1, 1, 'BhoFit', 1, NULL, NULL, '2026-02-10 00:00:00.000', NOW(3)),
('tops-oversized-sweat-pullover', 'Oversized Sweat Pullover', 'tops-oversized-sweat-pullover', 14.9, NULL, 'cat-tops', 'T-Shirts & Sweats', 'tops', 'unisex', 'Oversized Sweat Pullover — simple, well-made clothes for every day.', 'Oversized Sweat Pullover — simple, well-made clothes for every day.', 'Oversized Sweat Pullover is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular to slightly cropped. Size up for an easier drape. Pair it with other t-shirts & sweats from BhoFit.', '["Clean crew neck","Daily-wear knit","Holds shape after wash"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular to slightly cropped. Size up for an easier drape.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Mini styles run cropped. Check length in the size guide.', '["https://images.unsplash.com/photo-1556821840-3a63f95609a7?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1512436991641-6745cdb1723f?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1556905055-8f358a7a47b2?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Black","Navy","Lilac","Yellow"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 48, 4.8, 422, '["tops","unisex","lifewear"]', 0, 0, 1, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-03-11 00:00:00.000', NOW(3)),
('tops-pima-cotton-polo', 'Pima Cotton Polo', 'tops-pima-cotton-polo', 14.9, NULL, 'cat-tops', 'T-Shirts & Sweats', 'tops', 'unisex', 'Pima Cotton Polo — simple, well-made clothes for every day.', 'Pima Cotton Polo — simple, well-made clothes for every day.', 'Pima Cotton Polo is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular to slightly cropped. Size up for an easier drape. Pair it with other t-shirts & sweats from BhoFit.', '["Clean crew neck","Daily-wear knit","Holds shape after wash"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular to slightly cropped. Size up for an easier drape.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Mini styles run cropped. Check length in the size guide.', '["https://images.unsplash.com/photo-1618354691373-d851c5c3a990?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1506794778202-cad84cf45f1d?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1620799140408-edc6dcb6d633?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Black","Navy","Lilac","Yellow"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 55, 4.9, 463, '["tops","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-04-12 00:00:00.000', NOW(3)),
('shirts-linen-camp-shirt', 'Linen Camp Shirt', 'shirts-linen-camp-shirt', 39.9, NULL, 'cat-shirts', 'Shirts & Blouses', 'shirts', 'unisex', 'Linen Camp Shirt — simple, well-made clothes for every day.', 'Linen Camp Shirt — simple, well-made clothes for every day.', 'Linen Camp Shirt is cut for how you move: clean lines, honest cloth, and a fit you can live in. Boxy through the body. Looks sharp tucked or open. Pair it with other shirts & blouses from BhoFit.', '["Boxy shoulder","Button front","Easy summer cloth"]', '["Linen-cotton blend","Breathable weave"]', '["Gentle cycle","Hang dry","Warm iron"]', 'Boxy through the body. Looks sharp tucked or open.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Designed to sit off the body. Size down for a closer fit.', '["https://images.unsplash.com/photo-1488161628813-04466f872be2?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1500648767791-00dcc994a43e?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1544441893-675973e31985?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Light Blue","Khaki","Navy"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 22, 4.4, 504, '["shirts","unisex","lifewear"]', 0, 0, 0, 1, 0, 'BhoFit', 1, NULL, NULL, '2026-05-13 00:00:00.000', NOW(3)),
('shirts-oxford-boxy-shirt', 'Oxford Boxy Shirt', 'shirts-oxford-boxy-shirt', 39.9, NULL, 'cat-shirts', 'Shirts & Blouses', 'shirts', 'unisex', 'Oxford Boxy Shirt — simple, well-made clothes for every day.', 'Oxford Boxy Shirt — simple, well-made clothes for every day.', 'Oxford Boxy Shirt is cut for how you move: clean lines, honest cloth, and a fit you can live in. Boxy through the body. Looks sharp tucked or open. Pair it with other shirts & blouses from BhoFit.', '["Boxy shoulder","Button front","Easy summer cloth"]', '["Linen-cotton blend","Breathable weave"]', '["Gentle cycle","Hang dry","Warm iron"]', 'Boxy through the body. Looks sharp tucked or open.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Designed to sit off the body. Size down for a closer fit.', '["https://images.unsplash.com/photo-1603252109303-2751441dd157?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1602810318383-e386cc2a3ccf?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1617137984095-74e4e5e3613f?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Light Blue","Khaki","Navy"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 29, 4.5, 545, '["shirts","unisex","lifewear"]', 0, 0, 0, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-06-14 00:00:00.000', NOW(3)),
('sweaters-extra-fine-merino-crew', 'Extra Fine Merino Crew', 'sweaters-extra-fine-merino-crew', 39.9, NULL, 'cat-sweaters', 'Sweaters & Cardigans', 'sweaters', 'women', 'Extra Fine Merino Crew — simple, well-made clothes for every day.', 'Extra Fine Merino Crew — simple, well-made clothes for every day.', 'Extra Fine Merino Crew is cut for how you move: clean lines, honest cloth, and a fit you can live in. Cropped cardigan hits at the high hip. Crew is regular. Pair it with other sweaters & cardigans from BhoFit.', '["Fine gauge knit","Layering weight","Soft next to skin"]', '["Extra-fine merino wool","Machine-washable knit"]', '["Machine wash cold wool cycle","Lay flat to dry"]', 'Cropped cardigan hits at the high hip. Crew is regular.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Wool knits have slight give. Start with your usual size.', '["https://images.unsplash.com/photo-1434389677669-e08b4cac3105?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1558769132-cb1aea458c5e?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1519741497674-611481863552?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Cream","Navy","Brown","Black"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 36, 4.6, 586, '["sweaters","women","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-07-15 00:00:00.000', NOW(3)),
('sweaters-cropped-cardigan', 'Cropped Cardigan', 'sweaters-cropped-cardigan', 39.9, NULL, 'cat-sweaters', 'Sweaters & Cardigans', 'sweaters', 'women', 'Cropped Cardigan — simple, well-made clothes for every day.', 'Cropped Cardigan — simple, well-made clothes for every day.', 'Cropped Cardigan is cut for how you move: clean lines, honest cloth, and a fit you can live in. Cropped cardigan hits at the high hip. Crew is regular. Pair it with other sweaters & cardigans from BhoFit.', '["Fine gauge knit","Layering weight","Soft next to skin"]', '["Extra-fine merino wool","Machine-washable knit"]', '["Machine wash cold wool cycle","Lay flat to dry"]', 'Cropped cardigan hits at the high hip. Crew is regular.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Wool knits have slight give. Start with your usual size.', '["https://images.unsplash.com/photo-1487412720507-e7ab37603c6f?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1551232864-3f0890e580d9?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1488426862026-3ee34a7d66df?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Cream","Navy","Brown","Black"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 43, 4.7, 627, '["sweaters","women","lifewear"]', 0, 0, 1, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-08-16 00:00:00.000', NOW(3)),
('outerwear-ultra-light-packable-jacket', 'Ultra Light Packable Jacket', 'outerwear-ultra-light-packable-jacket', 79.9, NULL, 'cat-outerwear', 'Outerwear', 'outerwear', 'unisex', 'Ultra Light Packable Jacket — simple, well-made clothes for every day.', 'Ultra Light Packable Jacket — simple, well-made clothes for every day.', 'Ultra Light Packable Jacket is cut for how you move: clean lines, honest cloth, and a fit you can live in. Designed to layer over a knit or oxford. True to size. Pair it with other outerwear from BhoFit.', '["Packs into its pocket","Wind-resistant shell","Everyday polish"]', '["Ripstop nylon","Recycled fill (jacket)"]', '["Gentle cycle","Do not iron fill","Hang to dry"]', 'Designed to layer over a knit or oxford. True to size.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Choose your usual top size for layering.', '["https://images.unsplash.com/photo-1539533018447-63fcce2678e3?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1544022613-e87ca75a784a?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1543076447-215ad9ba6923?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Black","Navy","Natural","Olive"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 50, 4.8, 668, '["outerwear","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-01-17 00:00:00.000', NOW(3)),
('outerwear-unlined-easy-blazer', 'Unlined Easy Blazer', 'outerwear-unlined-easy-blazer', 79.9, NULL, 'cat-outerwear', 'Outerwear', 'outerwear', 'unisex', 'Unlined Easy Blazer — simple, well-made clothes for every day.', 'Unlined Easy Blazer — simple, well-made clothes for every day.', 'Unlined Easy Blazer is cut for how you move: clean lines, honest cloth, and a fit you can live in. Designed to layer over a knit or oxford. True to size. Pair it with other outerwear from BhoFit.', '["Packs into its pocket","Wind-resistant shell","Everyday polish"]', '["Ripstop nylon","Recycled fill (jacket)"]', '["Gentle cycle","Do not iron fill","Hang to dry"]', 'Designed to layer over a knit or oxford. True to size.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Choose your usual top size for layering.', '["https://images.unsplash.com/photo-1591047139829-d91aecb6caea?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1507679799987-c73779587ccf?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1462536943532-57a629f6cc60?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Black","Navy","Natural","Olive"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 57, 4.9, 709, '["outerwear","unisex","lifewear"]', 0, 0, 0, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-02-18 00:00:00.000', NOW(3)),
('dresses-poplin-shirt-dress', 'Poplin Shirt Dress', 'dresses-poplin-shirt-dress', 49.9, NULL, 'cat-dresses', 'Dresses & Skirts', 'dresses', 'women', 'Poplin Shirt Dress — simple, well-made clothes for every day.', 'Poplin Shirt Dress — simple, well-made clothes for every day.', 'Poplin Shirt Dress is cut for how you move: clean lines, honest cloth, and a fit you can live in. Shirt dress is relaxed. Culottes sit at the natural waist. Pair it with other dresses & skirts from BhoFit.', '["Easy summer drape","Pockets","Belt loops where shown"]', '["Cotton poplin","Light lining on skirt"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Shirt dress is relaxed. Culottes sit at the natural waist.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Skirts use waist/hip. Dresses use chest + length.', '["https://images.unsplash.com/photo-1595777457583-95e059d581b8?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1515372039744-b8f02a3ae446?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1572804013427-4d7ca7268217?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Navy","Lilac","Black"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 24, 4.4, 750, '["dresses","women","lifewear"]', 0, 0, 0, 1, 0, 'BhoFit', 1, NULL, NULL, '2026-03-19 00:00:00.000', NOW(3)),
('dresses-pleated-midi-skirt', 'Pleated Midi Skirt', 'dresses-pleated-midi-skirt', 49.9, NULL, 'cat-dresses', 'Dresses & Skirts', 'dresses', 'women', 'Pleated Midi Skirt — simple, well-made clothes for every day.', 'Pleated Midi Skirt — simple, well-made clothes for every day.', 'Pleated Midi Skirt is cut for how you move: clean lines, honest cloth, and a fit you can live in. Shirt dress is relaxed. Culottes sit at the natural waist. Pair it with other dresses & skirts from BhoFit.', '["Easy summer drape","Pockets","Belt loops where shown"]', '["Cotton poplin","Light lining on skirt"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Shirt dress is relaxed. Culottes sit at the natural waist.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Skirts use waist/hip. Dresses use chest + length.', '["https://images.unsplash.com/photo-1583496661160-fb5886a0aaaa?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1529626455594-4ff0802cfb7e?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1496747611176-843222e1e57c?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Navy","Lilac","Black"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 31, 4.5, 791, '["dresses","women","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-04-20 00:00:00.000', NOW(3)),
('dresses-cotton-culottes', 'Cotton Culottes', 'dresses-cotton-culottes', 49.9, NULL, 'cat-dresses', 'Dresses & Skirts', 'dresses', 'women', 'Cotton Culottes — simple, well-made clothes for every day.', 'Cotton Culottes — simple, well-made clothes for every day.', 'Cotton Culottes is cut for how you move: clean lines, honest cloth, and a fit you can live in. Shirt dress is relaxed. Culottes sit at the natural waist. Pair it with other dresses & skirts from BhoFit.', '["Easy summer drape","Pockets","Belt loops where shown"]', '["Cotton poplin","Light lining on skirt"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Shirt dress is relaxed. Culottes sit at the natural waist.', '[{"size":"XXS","waist":"22–23","hip":"32","length":"28.8"},{"size":"XS","waist":"24–25","hip":"34","length":"29.5"},{"size":"S","waist":"26–27","hip":"36","length":"29.5"},{"size":"M","waist":"28–29","hip":"38","length":"30.0"},{"size":"L","waist":"30–31","hip":"40","length":"30.3"},{"size":"XL","waist":"32–33","hip":"42","length":"30.3"},{"size":"XXL","waist":"34–35","hip":"44","length":"30.3"}]', 'Skirts use waist/hip. Dresses use chest + length.', '["https://images.unsplash.com/photo-1490481651871-ab68de25d43d?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1494790108377-be9c29b29330?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1483985988355-763728e1935b?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Navy","Lilac","Black"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 38, 4.6, 832, '["dresses","women","lifewear"]', 0, 0, 1, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-05-21 00:00:00.000', NOW(3)),
('innerwear-soft-rib-bralette', 'Soft Rib Bralette', 'innerwear-soft-rib-bralette', 14.9, NULL, 'cat-innerwear', 'Innerwear', 'innerwear', 'women', 'Soft Rib Bralette — simple, well-made clothes for every day.', 'Soft Rib Bralette — simple, well-made clothes for every day.', 'Soft Rib Bralette is cut for how you move: clean lines, honest cloth, and a fit you can live in. Bralette is stretch-to-fit. Briefs are mid-rise. Pair it with other innerwear from BhoFit.', '["No underwire","Soft rib knit","Everyday set"]', '["Cotton-modal blend","Elastane for recovery"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Bralette is stretch-to-fit. Briefs are mid-rise.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Choose your usual undergarment size.', '["https://images.unsplash.com/photo-1441984904996-e0b6ba687e04?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1555529669-e69e7aa0ba9a?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1503342217505-b0a15ec3261c?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Beige","Black","White","Pink"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 45, 4.7, 873, '["innerwear","women","lifewear"]', 0, 0, 0, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-06-22 00:00:00.000', NOW(3)),
('innerwear-cotton-brief-3-pack', 'Cotton Brief 3-Pack', 'innerwear-cotton-brief-3-pack', 14.9, 19.9, 'cat-innerwear', 'Innerwear', 'innerwear', 'women', 'Cotton Brief 3-Pack — simple, well-made clothes for every day.', 'Cotton Brief 3-Pack — simple, well-made clothes for every day.', 'Cotton Brief 3-Pack is cut for how you move: clean lines, honest cloth, and a fit you can live in. Bralette is stretch-to-fit. Briefs are mid-rise. Pair it with other innerwear from BhoFit.', '["No underwire","Soft rib knit","Everyday set"]', '["Cotton-modal blend","Elastane for recovery"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Bralette is stretch-to-fit. Briefs are mid-rise.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Choose your usual undergarment size.', '["https://images.unsplash.com/photo-1551488831-00ddcb6c6bd3?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1600185365926-3a2ce3cdb9eb?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1441986300917-64674bd600d8?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Beige","Black","White","Pink"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 52, 4.8, 14, '["innerwear","women","limited"]', 0, 1, 0, 0, 0, 'BhoFit', 1, 12, 76, '2026-07-23 00:00:00.000', NOW(3)),
('loungewear-stripe-lounge-set', 'Stripe Lounge Set', 'loungewear-stripe-lounge-set', 39.9, NULL, 'cat-loungewear', 'Loungewear', 'loungewear', 'unisex', 'Stripe Lounge Set — simple, well-made clothes for every day.', 'Stripe Lounge Set — simple, well-made clothes for every day.', 'Stripe Lounge Set is cut for how you move: clean lines, honest cloth, and a fit you can live in. Relaxed. Pants have an elastic waist. Pair it with other loungewear from BhoFit.', '["Matching top and pants","Elastic waist","Home-to-errand"]', '["Cotton jersey","Soft brushed interior"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Relaxed. Pants have an elastic waist.', '[{"size":"XXS","chest":"30–32","length":"22"},{"size":"XS","chest":"32–34","length":"23"},{"size":"S","chest":"34–36","length":"24"},{"size":"M","chest":"38–40","length":"25"},{"size":"L","chest":"42–44","length":"26"},{"size":"XL","chest":"46–48","length":"27"},{"size":"XXL","chest":"50–52","length":"28"}]', 'Sold as a set. Pick your usual top size.', '["https://images.unsplash.com/photo-1485230895905-ec40ba36b9bc?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1595950653106-6c9ebd614d3a?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1551028719-00167b16eac5?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Grey","Navy","Cream"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 19, 4.9, 55, '["loungewear","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-08-24 00:00:00.000', NOW(3)),
('accessories-round-mini-shoulder-bag', 'Round Mini Shoulder Bag', 'accessories-round-mini-shoulder-bag', 29.9, NULL, 'cat-accessories', 'Accessories', 'accessories', 'unisex', 'Round Mini Shoulder Bag — simple, well-made clothes for every day.', 'Round Mini Shoulder Bag — simple, well-made clothes for every day.', 'Round Mini Shoulder Bag is cut for how you move: clean lines, honest cloth, and a fit you can live in. One size bag. Socks: S/M and L/XL in size options. Pair it with other accessories from BhoFit.', '["Daily carry","Adjustable strap on bag","Cushioned socks"]', '["Woven polyester body","Cotton-blend socks"]', '["Wipe bag clean","Wash socks cold"]', 'One size bag. Socks: S/M and L/XL in size options.', '[{"size":"S","foot":"US 4–7"},{"size":"M","foot":"US 6–9"},{"size":"L","foot":"US 8–11"},{"size":"XL","foot":"US 10–13"}]', 'Bag is one size. Socks use the size chart above.', '["https://images.unsplash.com/photo-1590874103328-eac38a683ce7?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1548036328-c9fa89d128fa?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1584917865442-de89df76afd3?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Black","Lilac","Natural","Navy"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 26, 4.4, 96, '["accessories","unisex","lifewear"]', 0, 0, 0, 1, 0, 'BhoFit', 1, NULL, NULL, '2026-01-25 00:00:00.000', NOW(3)),
('accessories-cotton-crew-socks-3-pack', 'Cotton Crew Socks 3-Pack', 'accessories-cotton-crew-socks-3-pack', 29.9, NULL, 'cat-accessories', 'Accessories', 'accessories', 'unisex', 'Cotton Crew Socks 3-Pack — simple, well-made clothes for every day.', 'Cotton Crew Socks 3-Pack — simple, well-made clothes for every day.', 'Cotton Crew Socks 3-Pack is cut for how you move: clean lines, honest cloth, and a fit you can live in. One size bag. Socks: S/M and L/XL in size options. Pair it with other accessories from BhoFit.', '["Daily carry","Adjustable strap on bag","Cushioned socks"]', '["Woven polyester body","Cotton-blend socks"]', '["Wipe bag clean","Wash socks cold"]', 'One size bag. Socks: S/M and L/XL in size options.', '[{"size":"S","foot":"US 4–7"},{"size":"M","foot":"US 6–9"},{"size":"L","foot":"US 8–11"},{"size":"XL","foot":"US 10–13"}]', 'Bag is one size. Socks use the size chart above.', '["https://images.unsplash.com/photo-1549298916-b41d501d3772?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1606107557195-0e29a4b5b4aa?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1543163521-1bf539c55dd2?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["Black","Lilac","Natural","Navy"]},{"id":"size","label":"Size","options":["XXS","XS","S","M","L","XL","XXL"]}]', 33, 4.5, 137, '["accessories","unisex","lifewear"]', 0, 0, 1, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-02-26 00:00:00.000', NOW(3)),
('kids-kids-cotton-graphic-tee', 'Kids Cotton Graphic Tee', 'kids-kids-cotton-graphic-tee', 12.9, NULL, 'cat-kids', 'Kids', 'kids', 'unisex', 'Kids Cotton Graphic Tee — simple, well-made clothes for every day.', 'Kids Cotton Graphic Tee — simple, well-made clothes for every day.', 'Kids Cotton Graphic Tee is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular kids fit. Size up for growth room. Pair it with other kids from BhoFit.', '["Soft jersey","Easy on/off","Play-ready"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular kids fit. Size up for growth room.', '[{"size":"90","chest":"20","length":"14"},{"size":"100","chest":"22","length":"15"},{"size":"110","chest":"24","length":"16"},{"size":"120","chest":"26","length":"17"},{"size":"130","chest":"28","length":"18"},{"size":"140","chest":"30","length":"19"}]', 'Sizes are height in centimeters.', '["https://images.unsplash.com/photo-1503454537195-1dcabb73ffb9?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1608231387042-66d1773070a5?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1503919545889-aef636e10ad4?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Navy","Yellow","Green"]},{"id":"size","label":"Size","options":["90","100","110","120","130","140"]}]', 40, 4.6, 178, '["kids","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-03-27 00:00:00.000', NOW(3)),
('kids-kids-easy-shorts', 'Kids Easy Shorts', 'kids-kids-easy-shorts', 12.9, NULL, 'cat-kids', 'Kids', 'kids', 'unisex', 'Kids Easy Shorts — simple, well-made clothes for every day.', 'Kids Easy Shorts — simple, well-made clothes for every day.', 'Kids Easy Shorts is cut for how you move: clean lines, honest cloth, and a fit you can live in. Regular kids fit. Size up for growth room. Pair it with other kids from BhoFit.', '["Soft jersey","Easy on/off","Play-ready"]', '["100% cotton","Pre-washed for softness"]', '["Machine wash cold","Do not bleach","Tumble dry low"]', 'Regular kids fit. Size up for growth room.', '[{"size":"90","chest":"20","length":"14"},{"size":"100","chest":"22","length":"15"},{"size":"110","chest":"24","length":"16"},{"size":"120","chest":"26","length":"17"},{"size":"130","chest":"28","length":"18"},{"size":"140","chest":"30","length":"19"}]', 'Sizes are height in centimeters.', '["https://images.unsplash.com/photo-1519238263530-99bdd11df2ea?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1540479859555-17af45c78602?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1491553895911-0055eca6402d?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Navy","Yellow","Green"]},{"id":"size","label":"Size","options":["90","100","110","120","130","140"]}]', 47, 4.7, 219, '["kids","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-04-01 00:00:00.000', NOW(3)),
('baby-baby-rib-bodysuit', 'Baby Rib Bodysuit', 'baby-baby-rib-bodysuit', 9.9, NULL, 'cat-baby', 'Baby', 'baby', 'unisex', 'Baby Rib Bodysuit — simple, well-made clothes for every day.', 'Baby Rib Bodysuit — simple, well-made clothes for every day.', 'Baby Rib Bodysuit is cut for how you move: clean lines, honest cloth, and a fit you can live in. True to month size. Rib has stretch. Pair it with other baby from BhoFit.', '["Snap closures","Tag-free neck","Gentle knit"]', '["Organic cotton rib","Nickel-free snaps"]', '["Machine wash cold","Tumble dry low"]', 'True to month size. Rib has stretch.', '[{"size":"50","chest":"16","length":"12"},{"size":"60","chest":"17","length":"13"},{"size":"70","chest":"18","length":"14"},{"size":"80","chest":"19","length":"15"},{"size":"90","chest":"20","length":"16"}]', 'Sizes follow baby height in centimeters.', '["https://images.unsplash.com/photo-1515488042361-ee00e0ddd4e4?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1522771739844-6a9f6d5f14af?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1519689680058-324335c77eba?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Cream","Navy","Pink"]},{"id":"size","label":"Size","options":["50","60","70","80","90"]}]', 54, 4.8, 260, '["baby","unisex","lifewear"]', 0, 0, 0, 0, 0, 'BhoFit', 1, NULL, NULL, '2026-05-02 00:00:00.000', NOW(3)),
('baby-baby-knit-pants', 'Baby Knit Pants', 'baby-baby-knit-pants', 9.9, NULL, 'cat-baby', 'Baby', 'baby', 'unisex', 'Baby Knit Pants — simple, well-made clothes for every day.', 'Baby Knit Pants — simple, well-made clothes for every day.', 'Baby Knit Pants is cut for how you move: clean lines, honest cloth, and a fit you can live in. True to month size. Rib has stretch. Pair it with other baby from BhoFit.', '["Snap closures","Tag-free neck","Gentle knit"]', '["Organic cotton rib","Nickel-free snaps"]', '["Machine wash cold","Tumble dry low"]', 'True to month size. Rib has stretch.', '[{"size":"50","chest":"16","length":"12"},{"size":"60","chest":"17","length":"13"},{"size":"70","chest":"18","length":"14"},{"size":"80","chest":"19","length":"15"},{"size":"90","chest":"20","length":"16"}]', 'Sizes follow baby height in centimeters.', '["https://images.unsplash.com/photo-1516627145497-ae6968895b74?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1566004100631-35d015d6a491?auto=format&fit=crop&w=1200&q=80","https://images.unsplash.com/photo-1591561954557-26941169b49e?auto=format&fit=crop&w=1200&q=80"]', '[{"id":"color","label":"Color","options":["White","Cream","Navy","Pink"]},{"id":"size","label":"Size","options":["50","60","70","80","90"]}]', 21, 4.9, 301, '["baby","unisex","lifewear"]', 0, 0, 0, 0, 1, 'BhoFit', 1, NULL, NULL, '2026-06-03 00:00:00.000', NOW(3));

-- Seeded 11 categories, 30 products.