When you have more than a handful of products, import them from a spreadsheet instead of entering them one at a time. The same tool updates existing products in bulk.
Preparing your file
Export the template from Catalog β Products β Import, then fill it in. At minimum each row needs a SKU, title, price, and quantity.
π‘ Tip: The SKU column is the key. Rows whose SKU already exists update that product; new SKUs create new products. This is how you do mass price or stock updates safely.
Importing
- Upload your file β go to Catalog β Products β Import and upload your
.xlsxor.csv. - Map columns β match each spreadsheet column to a product field.
- Validate β review the preview; the importer flags missing required fields or duplicate SKUs.
- Run the import β confirm to apply.
β οΈ Warning: Always run a small test file first (5β10 rows) before importing thousands.