Add or edit products in bulk with the .csv importer.
To add or edit products in bulk, you'll need to complete and import a product .csv file. The product .csv file formatting requirements depend on your goals and which version of Squarespace your site is on. This guide covers the steps and requirements for:
- Moving products between Squarespace sites
- Bulk-editing products
- Importing products from a different platform
You can import up to 10,000 products to a version 7.1 site, and up to 200 products to a version 7.0 site. In both versions, you can import up to 250 variants per product.
No matter your use case, this is a one-time import. Any updates to your original store or product .csv file won't automatically sync after the import.
Importing products is available on the Business, Commerce, Professional, and Premium plans.
Download the product .csv file
The product .csv file you'll need depends on what your goal is:
- Moving products between Squarespace sites - In the original site's Products panel, click Export all.
- Bulk-editing products - In the Products panel, click Export all
- Importing products from Shopify, Etsy, or BigCartel - You don't need to complete a product .csv file to import from these platforms. Instead, use our platform-specific options.
- Importing products from a different platform or creating new products - In your Squarespace Products panel, click Import, then click Download CSV template.
After you download the product .csv file, open it in a spreadsheet editor like Excel or Google Sheets.
How products appear in the product .csv file
The product .csv file organizes product information in a way that's recognizable to your Squarespace site. It's important to maintain this structure, even if you edit the values in the cells.
In the image below:
- Row 2 is a single product with no variants. Because there are no variants (extra options, like size or flavor), the Option cells in this row are empty.
- Rows 3-8 are a single product with multiple variants. Each row has a different combination of options, which customers select from drop-down menus on the product details page. Customers can select Beets, Caperberries, or Kimchi in Small or Large.
- For the Pickled Things product, Row 3 is the First product row, and rows 4-8 are the Option rows. We use these terms throughout the guide.
Move products between Squarespace sites
To move products from one Squarespace site to another:
- Export a product .csv file from the existing Squarespace site and open it in a spreadsheet editor like Google Sheets or Microsoft Excel.
- Ensure the cells beneath Product ID and Variant ID are blank.
- Ensure you've created a store on the receiving site and that the Product Page slug matches its URL slug. If not, update the spreadsheet or edit the store's URL slug.
- (Version 7.1 only) Ensure the Categories match existing categories and subcategories on the receiving store. If not, add the product categories to the store.
- If you edit product details, follow the formatting requirements in the table below.
- Import the file to the receiving Squarespace site.
You can edit some of the product details in the file before importing it, but you don't have to. How you format the .csv file depends on which version of Squarespace the receiving site uses.
If you edit product details before importing the .csv file, follow these formatting requirements.
Column | Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option names 1-3 |
|
Option values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, length, width, height |
|
Visible |
|
Hosted Image URLs |
|
If you edit product details before importing the .csv file, follow these formatting requirements.
Column |
Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option names 1-3 |
|
Option values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, length, width, height |
|
Visible |
|
Hosted Image URLs |
|
Edit products in bulk
After you export your products to a .csv file, you can edit some of the product details and import the file to the same site. This will update the existing products on your site in bulk.
It's not possible to edit these details in the product .csv file:
- Product ID
- Variant ID
- Product type
- Product page
- Hosted image URLs
How you format the .csv file depends on which version of Squarespace your site uses.
The Product Page and Categories cell values must match the Store page's URL slug and existing categories and subcategories on your site. If you edit these in the spreadsheet, you'll need to edit your URL slug or create new categories to match them.
As you edit product details, follow these formatting requirements.
Column | Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option Names 1-3 |
|
Option Values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, Length, Width, Height |
|
Visible |
|
Hosted Image URL |
|
The Product Page must match the Store page's URL slug on your site. If you edit this in the spreadsheet, you'll need to edit your URL slug to match. As you edit product details, follow these formatting requirements.
Column | Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option Names 1-3 |
|
Option Values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, Length, Width, Height |
|
Visible |
|
Hosted Image URL |
|
Import products from a different platform
You can import physical and service products to Squarespace from a different platform, or as a way of creating new products.
If you're importing from:
- Big Cartel, Etsy, or Shopify - Use our platform-specific options instead.
- Other platforms - Download the product .csv template, then replace all existing values below the header row with your own product details, following the table below. If you're using Chrome, Firefox, or Microsoft Edge, clicking the link automatically downloads the .csv. If you're using Safari, right-click the link and select Download Linked File.
Complete the product import .csv file to import from other services or to create new products in your store. How you format the .csv file depends on which version of Squarespace the receiving site is on.
Ensure you've created a store on your Squarespace site, and that its URL and categories match the Product Page and Category columns in the .csv. If not, edit your URL slug and create new categories on your site to match them.
As you complete the product .csv template, follow these formatting requirements.
Column | Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option Names 1-3 |
|
Option Values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, Length, Width, Height |
|
Visible |
|
Hosted Image URL |
|
As you complete the product .csv template, follow these formatting requirements.
Column | Formatting requirements |
Product ID |
|
Variant ID |
|
Product Type |
|
Product Page |
|
Product URL |
|
Title |
|
Description |
|
SKU |
|
Option Names 1-3 |
|
Option Values 1-3 |
|
Price |
|
Sale Price |
|
On Sale |
|
Stock |
|
Categories |
|
Tags |
|
Weight, Length, Width, Height |
|
Visible |
|
Hosted Image URL |
|
Import the .csv file
After you complete the product .csv file and prepare your site for the import, you're ready to import the file.
- In the Products panel, click Import in the top-right corner.
- Drag and drop the completed .csv file into the Upload Squarespace CSV box.
- (Optional) To prevent the import from updating stock levels to the values in the spreadsheet, uncheck Update product quantities.
- Review the results and correct any errors by uploading the .csv file and re-importing it.
- Click Save.
Limitations
- You can only import physical and service products.
- You can import up to 10,000 products to a version 7.1 site.
- You can import up to 200 products to a version 7.0 site.
- In both versions, you can import up to 250 variants per product.
- You can’t import customers.
- You can’t move customer subscriptions between Squarespace sites.
- You can’t schedule products with an import. You can only publish or hide.
- Imported products won't have a set featured image. You can set featured images manually.
- Moving print-on-demand products between sites doesn't transfer your connection to the fulfillment service. You should follow the connection and product creation steps from the beginning on your new site.
Troubleshooting
I accidentally imported the sample products
If the products from the example rows in the .csv imported, you can delete them.
Error message: Product page not found
This means you imported products with a product page URL slug that didn't match an existing URL slug on the receiving site. To resolve this, update the spreadsheet or edit the store's URL slug.
Error message: Categories not assigned
This means you imported products with categories that don't already exist on your Squarespace site. To resolve this, add categories to your store and re-import products.
Error message: Missing column. Add product ID column.
This means the import spreadsheet is missing the product ID column, or there's an extra row at the top of the spreadsheet. To resolve this, ensure cell 1A reads Product ID [Non Editable], and that cell 2A contains a product ID.
Images aren't appearing after import
Images may not import if the beginning of the URL (the protocol) is incorrect. If the import fails try importing again using a different protocol, such as:
- If the protocol was http://, try importing again using https://
- If the protocol was https://, try importing again using http://
- If the protocol was ftp://, try again using http:// or https://
I followed the guidelines but my import still fails
If the import fails, copy all the text in the .csv file, paste it into a new spreadsheet, and then upload the new .csv. This will resolve most issues.
If your import continues to fail, we recommend opening the .csv with a spreadsheet program to check for unsupported formatting. Common formatting problems include:
- Bulleted lists
- Hyperlinks
- Nonstandard characters
Depending on their settings, some spreadsheet programs may not export .csv files correctly. For example, they may use semicolons to separate values instead of commas. If that's the case, contact your spreadsheet program's provider for help changing this setting.
If you don't see any formatting issues, ensure you're using the correct template.