<?php

namespace Database\Seeders;

use App\Models\Category;
use App\Models\Product;
use Illuminate\Database\Seeder;

class ProductSeeder extends Seeder
{
    /**
     * Run the database seeds.
     */
    public function run(): void
    {
        $riverFish = Category::where('slug', 'river-fish')->first();
        $seaFish = Category::where('slug', 'sea-fish')->first();
        $dryFish = Category::where('slug', 'dry-fish')->first();
        $importedFish = Category::where('slug', 'imported-fish')->first();
        $pondFish = Category::where('slug', 'pond-fish')->first();
        $liveFish = Category::where('slug', 'live-fish')->first();

        $products = [
            [
                'name' => 'Rohu Fish (রুই মাছ)',
                'slug' => 'rohu-fish',
                'description' => 'Fresh Rohu fish from Padma river. Rich in protein and omega-3 fatty acids.',
                'short_description' => 'Fresh river Rohu fish - 1kg',
                'category_id' => $riverFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 800.00,
                        'final_price' => 450.00,
                        'sale_price' => 420.00,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 420.00,
                        'final_price' => 480.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Katla Fish (কাতলা মাছ)',
                'slug' => 'katla-fish',
                'description' => 'Premium quality Katla fish from freshwater rivers. Perfect for Bengali curry.',
                'short_description' => 'Fresh Katla fish - 1kg',
                'category_id' => $riverFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '800–900 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 550.00,
                        'final_price' => 480.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 460.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Hilsha Fish (ইলিশ মাছ)',
                'slug' => 'hilsha-fish',
                'description' => 'The national fish of Bangladesh. Premium quality Padma Hilsha with authentic taste.',
                'short_description' => 'Padma Hilsha fish - 1kg',
                'category_id' => $riverFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '600–700 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1800.00,
                        'final_price' => 1200.00,
                        'sale_price' => 1150.00,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 1100.00,
                        'final_price' => 1350.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Pomfret Fish (চাঁদা মাছ)',
                'slug' => 'pomfret-fish',
                'description' => 'Fresh sea Pomfret from Bay of Bengal. Excellent for frying and steaming.',
                'short_description' => 'Fresh sea Pomfret - 1kg',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1400.00,
                        'final_price' => 650.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 900.00,
                        'final_price' => 720.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Red Snapper (রাঙা মাছ)',
                'slug' => 'red-snapper',
                'description' => 'Premium red snapper from deep sea. Rich flavor and firm texture.',
                'short_description' => 'Fresh Red Snapper - 1kg',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1300.00,
                        'final_price' => 750.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '800 gm–1 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 680.00,
                        'final_price' => 880.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Tilapia Fish (তেলাপিয়া মাছ)',
                'slug' => 'tilapia-fish',
                'description' => 'Farm-raised Tilapia fish. Healthy and affordable protein source.',
                'short_description' => 'Farm fresh Tilapia - 1kg',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 420.00,
                        'final_price' => 220.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 200.00,
                        'final_price' => 240.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Pangasius Fish (পাঙ্গাস মাছ)',
                'slug' => 'pangasius-fish',
                'description' => 'Fresh Pangasius fish from local farms. Mild taste and few bones.',
                'short_description' => 'Farm fresh Pangasius - 1kg',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 340.00,
                        'final_price' => 180.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 160.00,
                        'final_price' => 200.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Dry Hilsha (শুটকি ইলিশ)',
                'slug' => 'dry-hilsha',
                'description' => 'Traditional dried Hilsha fish. Perfect for Bengali delicacies.',
                'short_description' => 'Dried Hilsha fish - 250g',
                'category_id' => $dryFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '200–250 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1800.00,
                        'final_price' => 450.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 900.00,
                        'final_price' => 480.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Dry Bombay Duck (লইট্টা শুটকি)',
                'slug' => 'dry-bombay-duck',
                'description' => 'Traditional dried Bombay Duck. Authentic taste of coastal Bangladesh.',
                'short_description' => 'Traditional dried Bombay Duck - 250g',
                'category_id' => $dryFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '200–250 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1300.00,
                        'final_price' => 320.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 640.00,
                        'final_price' => 360.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Live Carp Fish (জীবন্ত কার্প)',
                'slug' => 'live-carp-fish',
                'description' => 'Fresh live Carp fish. Delivered alive to ensure maximum freshness.',
                'short_description' => 'Live Carp fish - 1kg',
                'category_id' => $liveFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '600–700 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 420.00,
                        'final_price' => 280.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 260.00,
                        'final_price' => 320.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Mrigel Fish (মৃগেল মাছ)',
                'slug' => 'mrigel-fish',
                'description' => 'Premium Mrigel fish from fresh river water. Excellent for traditional Bengali cooking.',
                'short_description' => 'Fresh Mrigel fish - 1kg',
                'category_id' => $riverFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 580.00,
                        'final_price' => 460.00,
                        'sale_price' => 430.00,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 410.00,
                        'final_price' => 510.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Silver Carp (সিলভার কার্প)',
                'slug' => 'silver-carp',
                'description' => 'Fresh Silver Carp fish. Known for its tender meat and great taste.',
                'short_description' => 'Silver Carp fish - 1kg',
                'category_id' => $riverFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 550.00,
                        'final_price' => 320.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 290.00,
                        'final_price' => 350.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Grass Carp (গ্রাস কার্প)',
                'slug' => 'grass-carp',
                'description' => 'Large Grass Carp fish perfect for family meals. Rich in protein.',
                'short_description' => 'Large Grass Carp fish - 1.5kg',
                'category_id' => $riverFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 340.00,
                        'final_price' => 380.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1.5–2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 260.00,
                        'final_price' => 420.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Bhetki Fish (ভেটকি মাছ)',
                'slug' => 'bhetki-fish',
                'description' => 'Premium Bhetki fish with minimal bones. Perfect for frying and curry.',
                'short_description' => 'Fresh Bhetki fish - 800g',
                'category_id' => $riverFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1400.00,
                        'final_price' => 650.00,
                        'sale_price' => 620.00,
                    ],
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 850.00,
                        'final_price' => 720.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Pomfret Fish (পমফ্রেট মাছ)',
                'slug' => 'fresh-pomfret-fish',
                'description' => 'Premium white Pomfret fish. Delicate taste and perfect for special occasions.',
                'short_description' => 'Fresh Pomfret fish - 600g',
                'category_id' => $seaFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '300–350 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 2200.00,
                        'final_price' => 720.00,
                        'sale_price' => 680.00,
                    ],
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1300.00,
                        'final_price' => 780.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Red Snapper (রেড স্ন্যাপার)',
                'slug' => 'fresh-red-snapper',
                'description' => 'Fresh Red Snapper from deep sea. Excellent for grilling and steaming.',
                'short_description' => 'Red Snapper fish - 800g',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1200.00,
                        'final_price' => 580.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 820.00,
                        'final_price' => 680.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Mackerel Fish (শিং মাছ)',
                'slug' => 'mackerel-fish',
                'description' => 'Fresh Mackerel fish rich in omega-3. Perfect for Bengali fish curry.',
                'short_description' => 'Mackerel fish - 500g',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '250–300 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1000.00,
                        'final_price' => 280.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 650.00,
                        'final_price' => 340.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Tuna Fish (টুনা মাছ)',
                'slug' => 'tuna-fish',
                'description' => 'Fresh Tuna fish steaks. High in protein and perfect for healthy cooking.',
                'short_description' => 'Tuna fish steaks - 1kg',
                'category_id' => $seaFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1500.00,
                        'final_price' => 850.00,
                        'sale_price' => 800.00,
                    ],
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 760.00,
                        'final_price' => 920.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Sea Bass (সি বাস)',
                'slug' => 'sea-bass',
                'description' => 'Premium Sea Bass with firm white meat. Great for all cooking methods.',
                'short_description' => 'Sea Bass fish - 700g',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '300–400 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1400.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '600–700 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 780.00,
                        'final_price' => 580.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Thai Koi Fish (থাই কৈ মাছ)',
                'slug' => 'thai-koi-fish',
                'description' => 'Premium Thai Koi fish from controlled farming. Sweet taste and nutritious.',
                'short_description' => 'Thai Koi fish - 800g',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 780.00,
                        'final_price' => 380.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 520.00,
                        'final_price' => 420.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Thai Sarputi (থাই সরপুঁটি)',
                'slug' => 'thai-sarputi',
                'description' => 'Farm-raised Thai Sarputi fish. Fast-growing variety with excellent taste.',
                'short_description' => 'Thai Sarputi fish - 1kg',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 500.00,
                        'final_price' => 250.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '900 gm–1 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 240.00,
                        'final_price' => 260.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Mirror Carp (মিরর কার্প)',
                'slug' => 'mirror-carp',
                'description' => 'Large Mirror Carp fish perfect for special occasions. Tender and flavorful.',
                'short_description' => 'Large Mirror Carp fish - 1.2kg',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 380.00,
                        'final_price' => 420.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1.5–2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 280.00,
                        'final_price' => 460.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Thai Pangas (থাই পাঙ্গাস)',
                'slug' => 'thai-pangas',
                'description' => 'Premium Thai Pangas with superior taste. Ideal for family meals.',
                'short_description' => 'Thai Pangas fish - 1kg',
                'category_id' => $pondFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 360.00,
                        'final_price' => 200.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '900 gm–1 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 190.00,
                        'final_price' => 210.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Dry Shutki Maach (চিংড়ি শুটকি)',
                'slug' => 'dry-shutki-maach',
                'description' => 'Traditional dried shrimp. Essential ingredient for Bengali cuisine.',
                'short_description' => 'Dried shrimp - 200g',
                'category_id' => $dryFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '200 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1900.00,
                        'final_price' => 380.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 760.00,
                        'final_price' => 420.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Dry Coral Fish (প্রবাল শুটকি)',
                'slug' => 'dry-coral-fish',
                'description' => 'Premium dried coral fish. Adds authentic flavor to traditional dishes.',
                'short_description' => 'Premium dried coral fish - 300g',
                'category_id' => $dryFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '200–250 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1800.00,
                        'final_price' => 420.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 840.00,
                        'final_price' => 450.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Dry Rupchanda (রুপচাঁদা শুটকি)',
                'slug' => 'dry-rupchanda',
                'description' => 'Dried Rupchanda fish. Premium quality for special Bengali recipes.',
                'short_description' => 'Dried Rupchanda - 250g',
                'category_id' => $dryFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '200–250 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 2200.00,
                        'final_price' => 550.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1000.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Norwegian Salmon (নরওয়েজিয়ান স্যামন)',
                'slug' => 'fresh-norwegian-salmon',
                'description' => 'Premium imported Norwegian Salmon. Rich in omega-3 and perfect for healthy cooking.',
                'short_description' => 'Norwegian Salmon fillet - 500g',
                'category_id' => $importedFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '250–300 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 4200.00,
                        'final_price' => 1200.00,
                        'sale_price' => 1150.00,
                    ],
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 2200.00,
                        'final_price' => 1350.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'King Fish Steak (কিং ফিশ স্টেক)',
                'slug' => 'king-fish-steak',
                'description' => 'Premium King Fish steaks imported from Indian Ocean. Perfect for grilling.',
                'short_description' => 'King Fish steaks - 800g',
                'category_id' => $importedFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1400.00,
                        'final_price' => 680.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '700–800 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 920.00,
                        'final_price' => 780.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Seabream Fish (সি brim)',
                'slug' => 'seabream-fish',
                'description' => 'Fresh imported Seabream fish. Delicate flavor perfect for fine dining.',
                'short_description' => 'Fresh imported Seabream fish - 600g',
                'category_id' => $importedFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '300–350 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 2200.00,
                        'final_price' => 750.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500–600 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 1300.00,
                        'final_price' => 820.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Live Rui Fish (জীবন্ত রুই)',
                'slug' => 'live-rui-fish',
                'description' => 'Fresh live Rui fish delivered alive. Maximum freshness guaranteed.',
                'short_description' => 'Live Rui fish - 1.5kg',
                'category_id' => $liveFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '1–1.2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 360.00,
                        'final_price' => 480.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '1.5–2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 240.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Live Katla Fish (জীবন্ত কাতলা)',
                'slug' => 'live-katla-fish',
                'description' => 'Premium live Katla fish. Freshness guaranteed with live delivery.',
                'short_description' => 'Live Katla fish - 2kg',
                'category_id' => $liveFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '1.5–2 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 260.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '2.5–3 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 180.00,
                        'final_price' => 600.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Live Tilapia (জীবন্ত তেলাপিয়া)',
                'slug' => 'live-tilapia',
                'description' => 'Farm-fresh live Tilapia fish. Perfect for those who prefer maximum freshness.',
                'short_description' => 'Live Tilapia fish - 1kg',
                'category_id' => $liveFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '400–500 gm (Per Piece)',
                        'unit' => 'gm',
                        'base_unit_price' => 480.00,
                        'final_price' => 240.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '900 gm–1 kg (Per Piece)',
                        'unit' => 'kg',
                        'base_unit_price' => 220.00,
                        'final_price' => 260.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Small Prawns (ছোট চিংড়ি)',
                'slug' => 'small-prawns',
                'description' => 'Fresh small prawns perfect for curry and frying. Sweet and tender.',
                'short_description' => 'Small prawns - 500g',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '250–300 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1200.00,
                        'final_price' => 320.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 640.00,
                        'final_price' => 360.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Medium Prawns (মাঝারি চিংড়ি)',
                'slug' => 'medium-prawns',
                'description' => 'Medium-sized fresh prawns. Perfect for special dishes and entertaining.',
                'short_description' => 'Medium prawns - 500g',
                'category_id' => $seaFish->id,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '250–300 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1800.00,
                        'final_price' => 480.00,
                        'sale_price' => null,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 960.00,
                        'final_price' => 520.00,
                        'sale_price' => null,
                    ],
                ],
            ],
            [
                'name' => 'Jumbo Prawns (জাম্বো চিংড়ি)',
                'slug' => 'jumbo-prawns',
                'description' => 'Large jumbo prawns for premium dining. Exceptional taste and size.',
                'short_description' => 'Large jumbo prawns - 500g',
                'category_id' => $seaFish->id,
                'is_featured' => true,
                'is_active' => true,
                'variants' => [
                    [
                        'label' => '250–300 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 2600.00,
                        'final_price' => 720.00,
                        'sale_price' => 680.00,
                    ],
                    [
                        'label' => '500 gm (Per Packet)',
                        'unit' => 'gm',
                        'base_unit_price' => 1300.00,
                        'final_price' => 800.00,
                        'sale_price' => null,
                    ],
                ],
            ],
        ];

        foreach ($products as $product) {
            Product::updateOrCreate(
                ['slug' => $product['slug']],
                $product
            );
        }
    }
}
