php artisan make:migration create_users_table
php artisan make:migration create_brands_table
php artisan make:migration create_categories_table

2. Authorization & ProfilesThese tables depend on the users table.Bash

php artisan make:migration create_roles_table
php artisan make:migration create_role_user_table --table=role_user
php artisan make:migration create_customer_profiles_table # Assuming this is your general 'user_addresses' table


3. Product Inventory (Source of Truth)This is the critical chain: products $\rightarrow$ variations.Bash

php artisan make:migration create_products_table
php artisan make:migration create_product_details_table
php artisan make:migration create_product_sliders_table
php artisan make:migration create_product_variations_table

# MUST run before cart_items/invoice_products




4. Transactional & Line Item MigrationsThese tables depend on users, products, and product_variations.Bash

php artisan make:migration create_carts_table
php artisan make:migration create_cart_items_table
php artisan make:migration create_invoices_table

# These line item tables depend on product_variations


php artisan make:migration create_invoice_products_table
php artisan make:migration create_product_wish_lists_table --table=product_wish_lists

php artisan make:migration create_pages_table
# Your wishlist pivot table



php artisan tinker

$image = App\Models\ProductImage::create([
    'product_id' => 1,
    'image_path' => 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQh6rPd9hx_fUGzorshx1fG5kzUM5FGCSYmm2YBuLU3uSFFI5BviIWd6hrHbw&s',
    'sort_order' => 1, // This sets it as the first image in the gallery
]);


App\Models\ProductVariation::create(['product_id'=> 1, 'size'=>'S', 'color'=>'Red', 'stock_quantity'=> 50]);

App\Models\ProductVariation::all();

php artisan tinker
use App\Models\ProductVariation;

for ($i = 1; $i <= 100; $i++) {
    ProductVariation::create([
        'product_id' => rand(1, 100), // assuming you already have 100 products
        'size' => ['S', 'M', 'L', 'XL'][array_rand(['S', 'M', 'L', 'XL'])],
        'color' => ['Red', 'Blue', 'Green', 'Black', 'White'][array_rand(['Red', 'Blue', 'Green', 'Black', 'White'])],
        'stock_quantity' => rand(10, 100),
    ]);
}


$products = range(1, 100); // your product IDs
$sizes = ['S', 'M', 'L', 'XL']; // define sizes
$colors = ['Red', 'Blue', 'Green', 'Black', 'White']; // define colors

for ($i = 1; $i <= 100; $i++) {
    $product_id = $products[array_rand($products)];
    $size = $sizes[array_rand($sizes)];
    $color = $colors[array_rand($colors)];

    if (!\App\Models\ProductVariation::where('product_id', $product_id)
        ->where('size', $size)
        ->where('color', $color)
        ->exists()) {

        \App\Models\ProductVariation::create([
            'product_id' => $product_id,
            'size' => $size,
            'color' => $color,
            'stock_quantity' => rand(10, 100),
        ]);
    } else {
        $i--; // retry for unique combination
    }
}







ProductVariation::all();
ProductVariation::count();