docs/user/manage-products/import-products.mdx
Adding products one at a time can be time consuming - especially when you're dealing with hundreds or thousands of SKUs.
Spree’s CSV importer allows you to upload products in bulk using a pre-formatted CSV file, dramatically reducing the time required to launch or scale your catalog.
Need an example? Please refer to <u>Product Import File Template</u> to download a template and see a list of internal fields.
<Note>Your product file does not need to exactly match the import template. Thanks to the field mapping step, you can manually match each column to the appropriate internal field during import (see Step 2 below).</Note>
To get started, navigate to the Products tab of the admin dashboard.
Click Import in the top right corner. This will open a side panel where you can begin the import process.
From here, simply follow these steps to import your product catalog:
First, you’ll need to upload the file you wish to import. Either drag-and-drop the file into the box or select a file from your computer by clicking browse files.
<Note>The importer supports both single and multi-variant products - just follow the multi-variant format in the <u>Product File Import Template</u>.</Note>
If successful, the UI will indicate that the upload was completed:
<Note>Double-check for any formatting issues, data type mismatches, and duplicates before uploading.</Note>
Before processing the file, you need to select which delimiter separates values in your file:
Once the file has been uploaded and the correct delimiter has been selected, click Create at the bottom of the side panel to continue to Step 2.
With the file uploaded, you’ll now be prompted to map your file’s columns to Spree’s internal fields.
Spree will try to match fields automatically when names are identical (or very similar), but you can manually select destination fields from the dropdowns on the right-hand side column for any unmatched, or incorrectly mapped fields.
Once satisfied, click Continue in the bottom-right corner to submit the file for import.
After submitting the file, you'll be redirected to a processing screen where you can monitor the progress of the import. All that’s left to do is wait until the import has finished processing
<Note>If there are any errors in your file (e.g., missing fields, duplicate values), the processing screen will indicate the error with an error message on the affected row.</Note>
You can also use the product importer to update existing products in your catalog.
To do so:
<Warning>When updating products in bulk, make sure to keep the slug exactly the same for each existing product. The slug is the unique identifier used during import - changing it will cause Spree to treat the row as a new product and create a duplicate record.</Warning>
This is the safest and most efficient way to make large-scale updates to product data such as pricing, descriptions, inventory, or metafields.
<Note>If your store sells in multiple currencies, your exported file will include additional price-only rows for each currency. See <u>Multi-Currency Import/Export</u> for details on how these rows work.</Note>