$store = App\Models\Store::where('slug', 'kopitiam')->firstOrFail();
DB::statement("SET app.current_tenant_id = '{$store->id}'");
$products = $store->products()->with('variants')->get();
echo json_encode([
    'products' => $products->count(),
    'variants' => $products->sum(fn ($product) => $product->variants->count()),
    'with_description' => $products->filter(fn ($product) => filled($product->description))->count(),
    'active' => $products->where('is_active', true)->count(),
    'categories' => $products->groupBy('category_name')->map->count()->all(),
    'sample' => $products->take(3)->map(fn ($product) => [$product->title, $product->category_name, $product->price, $product->variants->first()?->stock])->all(),
], JSON_PRETTY_PRINT);