Import products from a spreadsheet

1. Prepare your file

Your file can be a .csv, .xls, or .xlsx export from a spreadsheet (Excel, Google Sheets, Numbers) or another system. Put one product per row, with a header row on top.

Bakeboost reads these columns:

Column	Required	Notes
Product Code	✅ Yes	Your SKU / internal code. Must be present on every row.
Product Name	✅ Yes	The display name shown on orders and the storefront.
Stock Quantity	✅ Yes	A number. Use `0` if you don't track stock for the item.
Product Type	—	e.g. `cake`, `cupcake`, `ingredient`. Optional.
Regular Price	—	The list price. Optional.
Retail Price	—	The price charged to customers. Optional.
Supply Price	—	What the item costs you. Optional, used for profit reporting.

Your headers don't have to match these names exactly — you'll line them up in step 3. The three required columns must have a value in every row, or those rows will be rejected.

2. Open the importer

3. Upload and match your columns

The Import dialog walks you through four steps shown at the top: Choose file → Match columns → Review → Done.

Drop your file into the Upload File area, or click to browse. Bakeboost accepts .csv, .xls, and .xlsx, up to 10,000 rows per import.
On the Match columns step, line up each Bakeboost field (left) with the matching column from your file (right). If your headers are close to the names above, Bakeboost pre-selects them for you — just confirm.
Product Code, Product Name, and Stock Quantity are required and must be mapped. Leave any field you're not importing on Don't import.

Click Continue to preview once the required fields are mapped.

4. Review what's about to be saved

Bakeboost shows the first rows it's about to import. Sanity-check that:

Product names and codes are in the right columns (a common Excel paste bug shifts everything one column over).
Prices are numbers, not text like $4.50 or 4,50 — strip currency symbols and use a dot for decimals.
Stock Quantity is a plain number.

Nothing is written until you press Import. If something looks off, go Back and re-map — you don't need to re-upload the file.

5. Review the result

After the import runs you'll see how many products were created. Click Done to close the dialog; the product list refreshes automatically.

What gets created behind the scenes

For each row, Bakeboost creates a product record under your account with the fields you mapped. Anything you left on Don't import is simply left blank and can be filled in later by editing the product.

Imports are capped at 10,000 rows per run — split larger catalogues into two files.

Troubleshooting

Symptom	Likely cause	Fix
Some rows didn't import	A required column (Product Code, Product Name, or Stock Quantity) was empty on those rows	Fill the required columns for every row and re-import only the missing ones
Prices show as 0 or blank	Price cells contained currency symbols or text	Remove `$`, `£`, etc., use a dot for decimals (`4.50`), and re-import the affected rows
Every product appears twice	The import was run more than once	Expected — there's no duplicate detection. Select the duplicates in the Products list and delete them in bulk
"Import is capped at 10,000 rows per run"	The file is larger than the per-run cap	Split the file in two and import each half
Imported products don't appear	The list hasn't refreshed	Reload the Products page; it re-fetches on navigation

What's not (yet) supported

Updating existing products in bulk. The importer only creates new products; it doesn't match-and-update existing ones.
Duplicate detection. Re-running creates copies (see the warnings above).
Images, variants, recipes, and supplies aren't set by the importer — add those by editing the product after import.

Last updated June 10, 2026