-- =============================================================================
-- BhoFit — ONE FILE SQL IMPORTER (MariaDB / MySQL / phpMyAdmin)
-- =============================================================================
-- How to import (cPanel, no SSH):
--   1. cPanel → MySQL Databases → create database + user + ALL PRIVILEGES
--   2. phpMyAdmin → select that database (left sidebar)
--   3. Import → Choose file → select this file → Go
--
-- This file:
--   - Creates all store tables + foreign keys
--   - Inserts BhoFit SiteSettings (contact + social columns included)
--   - Inserts the starter admin user
--   - Inserts policy / content pages
--   - Inserts the clothing catalog (categories + products)
--
-- First admin login (change immediately after going live):
--   Email:    admin@bhofit.com
--   Password: admin123
-- =============================================================================

SET NAMES utf8mb4;
SET time_zone = '+00:00';
SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `OrderItem`;
DROP TABLE IF EXISTS `Order`;
DROP TABLE IF EXISTS `Product`;
DROP TABLE IF EXISTS `Category`;
DROP TABLE IF EXISTS `StripeWebhookEvent`;
DROP TABLE IF EXISTS `RateLimitBucket`;
DROP TABLE IF EXISTS `ContentPage`;
DROP TABLE IF EXISTS `SiteSettings`;
DROP TABLE IF EXISTS `User`;

SET FOREIGN_KEY_CHECKS = 1;

CREATE TABLE `User` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `email` VARCHAR(191) NOT NULL,
  `passwordHash` VARCHAR(191) NOT NULL,
  `role` ENUM('customer', 'admin') NOT NULL DEFAULT 'customer',
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  UNIQUE INDEX `User_email_key`(`email`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `Category` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `slug` VARCHAR(191) NOT NULL,
  `description` TEXT NOT NULL,
  `image` TEXT NOT NULL,
  `gender` VARCHAR(191) NOT NULL DEFAULT 'all',
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  UNIQUE INDEX `Category_slug_key`(`slug`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `Product` (
  `id` VARCHAR(191) NOT NULL,
  `name` VARCHAR(191) NOT NULL,
  `slug` VARCHAR(191) NOT NULL,
  `price` DOUBLE NOT NULL,
  `compareAt` DOUBLE NULL,
  `categoryId` VARCHAR(191) NOT NULL,
  `categoryName` VARCHAR(191) NOT NULL,
  `categorySlug` VARCHAR(191) NOT NULL,
  `gender` ENUM('men', 'women', 'unisex') NOT NULL,
  `description` TEXT NOT NULL,
  `shortDescription` TEXT NOT NULL,
  `longDescription` TEXT NOT NULL,
  `details` JSON NOT NULL,
  `materials` JSON NOT NULL,
  `care` JSON NOT NULL,
  `fit` TEXT NOT NULL,
  `sizeGuide` JSON NOT NULL,
  `sizeGuideNote` TEXT NOT NULL,
  `images` JSON NOT NULL,
  `variants` JSON NOT NULL,
  `stock` INTEGER NOT NULL DEFAULT 0,
  `rating` DOUBLE NOT NULL DEFAULT 4.5,
  `reviewCount` INTEGER NOT NULL DEFAULT 0,
  `tags` JSON NOT NULL,
  `featured` BOOLEAN NOT NULL DEFAULT false,
  `flashSale` BOOLEAN NOT NULL DEFAULT false,
  `recentlyOrdered` BOOLEAN NOT NULL DEFAULT false,
  `bestSeller` BOOLEAN NOT NULL DEFAULT false,
  `newArrival` BOOLEAN NOT NULL DEFAULT false,
  `seller` VARCHAR(191) NOT NULL DEFAULT 'BhoFit',
  `verified` BOOLEAN NOT NULL DEFAULT true,
  `sold` INTEGER NULL,
  `flashLimit` INTEGER NULL,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  UNIQUE INDEX `Product_slug_key`(`slug`),
  INDEX `Product_categorySlug_idx`(`categorySlug`),
  INDEX `Product_gender_idx`(`gender`),
  INDEX `Product_featured_idx`(`featured`),
  INDEX `Product_flashSale_idx`(`flashSale`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `Order` (
  `id` VARCHAR(191) NOT NULL,
  `userId` VARCHAR(191) NULL,
  `customerName` VARCHAR(191) NOT NULL,
  `email` VARCHAR(191) NOT NULL,
  `phone` VARCHAR(191) NULL,
  `status` ENUM('pending', 'processing', 'shipped', 'delivered', 'cancelled') NOT NULL DEFAULT 'pending',
  `subtotal` DOUBLE NOT NULL,
  `shipping` DOUBLE NOT NULL,
  `discount` DOUBLE NOT NULL DEFAULT 0,
  `total` DOUBLE NOT NULL,
  `shippingAddress` TEXT NOT NULL,
  `paymentMethod` VARCHAR(191) NULL,
  `paymentId` VARCHAR(191) NULL,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  INDEX `Order_userId_idx`(`userId`),
  INDEX `Order_email_idx`(`email`),
  INDEX `Order_status_idx`(`status`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `OrderItem` (
  `id` VARCHAR(191) NOT NULL,
  `orderId` VARCHAR(191) NOT NULL,
  `productId` VARCHAR(191) NULL,
  `name` VARCHAR(191) NOT NULL,
  `price` DOUBLE NOT NULL,
  `quantity` INTEGER NOT NULL,
  `image` TEXT NOT NULL,
  `variant` VARCHAR(191) NULL,
  INDEX `OrderItem_orderId_idx`(`orderId`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `SiteSettings` (
  `id` VARCHAR(191) NOT NULL DEFAULT 'default',
  `siteName` VARCHAR(191) NOT NULL DEFAULT 'BhoFit',
  `tagline` VARCHAR(191) NOT NULL DEFAULT 'Cut for how you move.',
  `description` TEXT NOT NULL,
  `logoUrl` TEXT NOT NULL,
  `faviconUrl` TEXT NOT NULL,
  `supportEmail` VARCHAR(191) NOT NULL DEFAULT 'support@bhofit.com',
  `supportPhone` VARCHAR(191) NOT NULL DEFAULT '',
  `address` TEXT NOT NULL,
  `facebookUrl` TEXT NOT NULL,
  `instagramUrl` TEXT NOT NULL,
  `twitterUrl` TEXT NOT NULL,
  `youtubeUrl` TEXT NOT NULL,
  `tiktokUrl` TEXT NOT NULL,
  `currency` VARCHAR(191) NOT NULL DEFAULT 'USD',
  `footerTagline` TEXT NOT NULL,
  `footerNote` VARCHAR(191) NOT NULL DEFAULT 'FREE shipping $99+ · 30-day returns · Fit notes on every style',
  `stripeEnabled` BOOLEAN NOT NULL DEFAULT false,
  `stripePublishableKey` TEXT NOT NULL,
  `stripeSecretKey` TEXT NOT NULL,
  `smtpHost` VARCHAR(191) NOT NULL DEFAULT '',
  `smtpPort` INTEGER NOT NULL DEFAULT 587,
  `smtpUser` VARCHAR(191) NOT NULL DEFAULT '',
  `smtpPass` TEXT NOT NULL,
  `smtpFrom` VARCHAR(191) NOT NULL DEFAULT '',
  `smtpSecure` BOOLEAN NOT NULL DEFAULT false,
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `ContentPage` (
  `id` VARCHAR(191) NOT NULL,
  `slug` VARCHAR(191) NOT NULL,
  `title` VARCHAR(191) NOT NULL,
  `excerpt` TEXT NOT NULL,
  `content` LONGTEXT NOT NULL,
  `published` BOOLEAN NOT NULL DEFAULT true,
  `showInFooter` BOOLEAN NOT NULL DEFAULT true,
  `footerGroup` VARCHAR(191) NOT NULL DEFAULT 'legal',
  `sortOrder` INTEGER NOT NULL DEFAULT 0,
  `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  UNIQUE INDEX `ContentPage_slug_key`(`slug`),
  INDEX `ContentPage_published_showInFooter_idx`(`published`, `showInFooter`),
  INDEX `ContentPage_footerGroup_sortOrder_idx`(`footerGroup`, `sortOrder`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `RateLimitBucket` (
  `id` VARCHAR(191) NOT NULL,
  `count` INTEGER NOT NULL DEFAULT 0,
  `resetAt` DATETIME(3) NOT NULL,
  INDEX `RateLimitBucket_resetAt_idx`(`resetAt`),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

CREATE TABLE `StripeWebhookEvent` (
  `id` VARCHAR(255) NOT NULL,
  `type` VARCHAR(191) NOT NULL,
  `processedAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE `Product`
  ADD CONSTRAINT `Product_categoryId_fkey`
  FOREIGN KEY (`categoryId`) REFERENCES `Category`(`id`)
  ON DELETE RESTRICT ON UPDATE CASCADE;

ALTER TABLE `Order`
  ADD CONSTRAINT `Order_userId_fkey`
  FOREIGN KEY (`userId`) REFERENCES `User`(`id`)
  ON DELETE SET NULL ON UPDATE CASCADE;

ALTER TABLE `OrderItem`
  ADD CONSTRAINT `OrderItem_orderId_fkey`
  FOREIGN KEY (`orderId`) REFERENCES `Order`(`id`)
  ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `OrderItem`
  ADD CONSTRAINT `OrderItem_productId_fkey`
  FOREIGN KEY (`productId`) REFERENCES `Product`(`id`)
  ON DELETE SET NULL ON UPDATE CASCADE;

INSERT INTO `User` (`id`, `name`, `email`, `passwordHash`, `role`, `createdAt`, `updatedAt`) VALUES
('admin_seed_001', 'BhoFit Admin', 'admin@bhofit.com', '$2b$12$oY.AWpo52va2131zHMlCRO89CXioaSBI8NO14ZTuWCoZRi8norfwO', 'admin', NOW(3), NOW(3));

INSERT INTO `SiteSettings` (
  `id`, `siteName`, `tagline`, `description`, `logoUrl`, `faviconUrl`,
  `supportEmail`, `supportPhone`, `address`,
  `facebookUrl`, `instagramUrl`, `twitterUrl`, `youtubeUrl`, `tiktokUrl`,
  `currency`, `footerTagline`, `footerNote`,
  `stripeEnabled`, `stripePublishableKey`, `stripeSecretKey`,
  `smtpHost`, `smtpPort`, `smtpUser`, `smtpPass`, `smtpFrom`, `smtpSecure`, `updatedAt`
) VALUES (
  'default',
  'BhoFit',
  'Cut for how you move.',
  'BhoFit — refined everyday clothes for women, men, kids, and baby. Honest cloth, considered fit. Free shipping over $99.',
  '',
  '/favicon.svg',
  'support@bhofit.com',
  '+1 (800) 555-0147',
  '1200 Market Street, Suite 400, San Francisco, CA 94103, USA',
  '',
  '',
  '',
  '',
  '',
  'USD',
  'Clothes cut for real days — women, men, kids, and baby, in one considered edit.',
  'FREE shipping $99+ · 30-day returns · Fit notes on every style',
  0,
  '',
  '',
  '',
  587,
  '',
  '',
  '',
  0,
  NOW(3)
);

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_about', 'about', 'About BhoFit', 'Who we are and what we sell.', 'BhoFit makes simple, well-made everyday clothes — tees, jeans, shirts, knits, outerwear, and kidswear.\n\nWomen, men, kids, and baby share one catalog with honest prices, color and size options, and free shipping over $99.\n\nOur promise is simple: clean product photos, fair policies, and a checkout that respects your time.', 1, 1, 'company', 10, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_contact', 'contact', 'Contact us', 'Reach BhoFit support.', 'Need help with an order, product question, or partnership?\n\nEmail: support@bhofit.com\nHours: Monday–Friday, 9:00–18:00 (US Eastern)\n\nUse the contact form on this page for the fastest response. Include your order ID when writing about a purchase.', 1, 1, 'company', 20, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_privacy', 'privacy', 'Privacy policy', 'How we collect and use your information.', 'Last updated: August 2026\n\nBhoFit (“we”, “us”) respects your privacy. This policy explains what we collect and why.\n\nInformation we collect\n• Account details such as name and email when you register\n• Order and shipping details needed to fulfill purchases\n• Payment references processed by Stripe (we do not store full card numbers)\n• Basic site analytics and device information\n\nHow we use information\n• To process orders, returns, and customer support\n• To improve the storefront and prevent fraud\n• To send order updates and, if you opt in, promotional emails\n\nSharing\nWe share data only with service providers required to run the store (payments, email delivery, hosting). We do not sell personal information.\n\nYour choices\nYou may request access or deletion of your account data by emailing support@bhofit.com.', 1, 1, 'legal', 10, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_terms', 'terms', 'Terms of service', 'Rules for using BhoFit.', 'Last updated: August 2026\n\nBy using BhoFit you agree to these terms.\n\nAccounts\nYou are responsible for keeping your login secure and for activity under your account.\n\nOrders & pricing\nPrices are shown in the selected store currency and may change without notice before checkout is completed. We may cancel or refuse an order in cases of pricing errors, stock issues, or suspected fraud.\n\nAcceptable use\nDo not misuse the site, attempt unauthorized access, or post unlawful content.\n\nLiability\nProducts are sold as described. To the fullest extent permitted by law, BhoFit is not liable for indirect or consequential damages.\n\nContact\nQuestions about these terms: support@bhofit.com', 1, 1, 'legal', 20, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_refund_policy', 'refund-policy', 'Refund policy', 'When and how refunds are issued.', 'Last updated: August 2026\n\nEligibility\nMost unused items in original condition may be refunded within 30 days of delivery. Final-sale or personalized items may be excluded and will be labeled on the product page.\n\nProcess\n1. Contact support@bhofit.com with your order ID\n2. Receive return instructions\n3. Ship the item back using a trackable method\n4. After inspection, refunds are issued to the original payment method\n\nTiming\nRefunds typically appear within 5–10 business days after approval, depending on your bank or card issuer.\n\nDamaged or incorrect items\nIf something arrives damaged or wrong, contact us within 7 days with photos — we will prioritize a refund or replacement.', 1, 1, 'support', 10, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_return_policy', 'return-policy', 'Return policy', 'How to return or exchange an item.', 'Last updated: August 2026\n\nReturn window\nYou may start a return within 30 days of delivery for eligible products.\n\nCondition\nItems should be unused, in original packaging, with tags attached where applicable.\n\nExchanges\nIf you need a different variant (color/size/pack), contact support first. Exchanges depend on stock availability.\n\nShipping costs\nReturn shipping is the customer’s responsibility unless the item is defective or we made an error. In those cases we cover return shipping.\n\nHow to start\nEmail support@bhofit.com with your order ID and reason for return. We will reply with the return address and next steps.', 1, 1, 'support', 20, NOW(3), NOW(3));

INSERT INTO `ContentPage` (`id`, `slug`, `title`, `excerpt`, `content`, `published`, `showInFooter`, `footerGroup`, `sortOrder`, `createdAt`, `updatedAt`) VALUES
('page_shipping', 'shipping', 'Shipping policy', 'Delivery timelines and shipping options.', 'Last updated: August 2026\n\nProcessing\nOrders usually ship within 1–3 business days after payment confirmation.\n\nDelivery estimates\n• United States: 3–7 business days after shipment\n• International: 7–21 business days depending on destination and customs\n\nTracking\nTracking details are emailed when your order ships. You can also review status under Account → Orders.\n\nCustoms & duties\nInternational customers are responsible for any import duties or taxes charged by their country.', 1, 1, 'support', 30, NOW(3), NOW(3));

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.

SELECT 'BhoFit import complete' AS status;