0) { $file = $_FILES['csv_file']['tmp_name']; $handle = fopen($file, "r"); // Skip Header Row fgetcsv($handle); $count = 0; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { // CSV Format: Name, Description, Category ID, Price, Variant Name (e.g. 1 Year) $name = $data[0]; $desc = $data[1]; $cat_id = $data[2]; $price = $data[3]; $var_name = $data[4]; $slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $name))); // 1. Insert Product $stmt = $pdo->prepare("INSERT INTO products (name, slug, description, category_id, is_active) VALUES (?, ?, ?, ?, 1)"); $stmt->execute([$name, $slug, $desc, $cat_id]); $pid = $pdo->lastInsertId(); // 2. Insert Variant $stmtV = $pdo->prepare("INSERT INTO product_variants (product_id, name, price, stock_qty) VALUES (?, ?, ?, -1)"); $stmtV->execute([$pid, $var_name, $price]); $count++; } fclose($handle); $msg = "Success! Imported $count products."; $msgClass = "success"; } } ?> Bulk Import

Bulk Product Import

CSV Format Required (Columns):
Name, Description, Category ID, Price, Plan Name

Example:
Canva Pro, Best Design Tool, 1, 499, 1 Year