prepare( "INSERT INTO products (store_id, sku, name, price, stock, status, created_at) VALUES (:store_id, :sku, :name, :price, :stock, :status, :created_at)" ); $stmt->bindValue(':store_id', $storeId, PDO::PARAM_INT); $stmt->bindValue(':sku', $sku); $stmt->bindValue(':name', $name); $stmt->bindValue(':price', $price); $stmt->bindValue(':stock', $stock, PDO::PARAM_INT); $stmt->bindValue(':status', $status); $stmt->bindValue(':created_at', date('Y-m-d H:i:s')); $stmt->execute(); flash_set('success', 'Product added to the catalog.'); } header('Location: /products.php'); exit; } $filterStore = isset($_GET['store_id']) ? (int)$_GET['store_id'] : null; $products = get_products($filterStore, 50); render_header('Product Catalog', 'Manage SKUs, pricing, and inventory for every store.'); ?>

Add product

Create a store first to add products.

Assign every SKU to a store to keep inventory separated.

Catalog list

Filter by store to narrow inventory.

No products match this filter.

Add a new SKU to get started.

SKU	Product	Store	Status	Price	Stock
				$