Shopify Product Bundle Creator from Individual Items

Open Google Sheet with bundle information at: {{BUNDLE_SPREADSHEET_URL}} The spreadsheet should contain: - Bundle Name - Products to Include (SKUs or titles) - Bundle Price - Bundle Description - Discount/Savings Amount Navigate to Shopify Admin. For each bundle (up to {{BUNDLE_COUNT}} bundles): **Method 1: Create as New Product (Recommended for physical bundles)** - Go to Products > Add Product - **Product Details:** * **Title:** Create compelling bundle name from spreadsheet - Example: "Ultimate Skincare Bundle - Complete Morning Routine" * **Description:** Write bundle-focused description: - What's included in the bundle - Total value vs bundle price - Savings amount or percentage - Why products work well together - Benefits of buying bundle - Perfect for (gift giving, starter pack, etc.) * List each included product: - Product name - Key features - Retail price * Show total savings calculation * Add urgency if limited quantity - **Media:** * Create bundle image showing all products together * Or use collage of individual product images * Include all product images in gallery * Add lifestyle shots if available - **Pricing:** * Set bundle price (typically 10-30% discount) * Show compare-at price (sum of individual prices) * Shopify will display savings automatically - **Inventory:** * Track inventory (if possible) * Or note components in inventory system * Set available quantity - **Variants:** (if applicable) * Size combinations * Color combinations * Each with appropriate pricing - **SEO:** * Optimize title for search * Add keyword-rich meta description * Use bundle-related keywords - **Product Organization:** * Add to "Bundles" collection * Tag with: bundle, gift-set, value-pack * Assign to appropriate category - **Add Cross-sells:** * Link to individual products * Suggest complementary items **Method 2: Using Shopify Bundles App (if installed)** - Open Shopify Bundles app - Click "Create Bundle" - Select products to include - Set bundle pricing - Configure inventory settings - Publish bundle **Bundle Description Template:** "🎁 **[Bundle Name]** **What's Included:** ✓ [Product 1] (Value: $XX) ✓ [Product 2] (Value: $XX) ✓ [Product 3] (Value: $XX) **Total Value: $XXX** **Bundle Price: $XXX** **You Save: $XX (XX%)** **Why This Bundle:** [Explain how products complement each other] [Mention convenience of having everything] [Note any special pairing benefits] **Perfect For:** - [Use case 1] - [Use case 2] - [Gift giving] **Product Details:** [List key features of each included product]" - Save and publish bundle - Test purchase flow - Verify pricing displays correctly - Check mobile display **Additional Setup:** - Create collection for all bundles - Add banner: "Save More with Bundles" - Set up email marketing for bundles - Create social media posts - Add bundles to navigation menu Create {{BUNDLE_COUNT}} product bundles. Wait 30-60 seconds between bundle creations.