Importing products from a .csv

Note: While our most popular guides have been translated into Spanish, some guides are only available in English.

Importing products from a .csv

Last updated May 01, 2023 17:27

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 Inventory panel, click Export all.
Bulk-editing products - In the Inventory 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 Inventory 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.

Move products to a 7.1 site
Move products to a 7.0 site

If you edit product details before importing the .csv file, follow these formatting requirements.

Column	Formatting requirements
Product ID	If there are existing values, remove them.
Variant ID	If there are existing values, remove them.
Product Type	Required Don't edit existing values in this column. If a row in this column is blank, leave it blank.
Product Page	Required The store page URL slug where the product will import, without the /. The receiving site must have an identical store page URL slug before you import. Adding a non-existent URL slug will cause the import to fail.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size and color, only add the product URL to the first product row. Example: v-neck-t-shirt Tip: Products in version 7.1 have a /p/ preceding the URL slug. If you're moving from version 7.0 and relying on links to products, you may want to set up URL redirects after the import.
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row. Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. Example: Made of our softest blend of cotton.
SKU	Optional Up to 20 characters per SKU. If this row is blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option names 1-3	Optional Text in these fields represent the label for a drop-down menu on the product details page. Each pair of Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, visit Adding product variants. Example: Color
Option values 1-3	Optional Text in these fields represent the options inside of a drop-down menu on the product details page. Each pair of Option Name # and Option Value # creates a variant. Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51.
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. Here's an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Required These must match existing categories on the receiving site. Enter the URL slug from the filtered category or subcategory page, including the / Lowercase only. To add multiple, separate by commas. Up to 25 characters per category. If the product has multiple options, like size and color, only add categories to the first product row. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size and color, only add tags to the first product row. Example: organic, soft
Weight, length, width, height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard. Example: 5 or 5.5
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size and color, only add the visibility status to the first product row.
Hosted Image URLs	Optional Supports web-hosted product image link(s). Paste the image’s full URL. Ensure the URL leads directly to the image, not a page that includes the image. Ensure the URL ends in an image file extension—like .jpg, .gif, or .png—instead of .com or .html. Separate multiple images with spaces or line breaks. (Google Sheets: `Alt`+`Enter` or Excel: `Ctrl`+`Alt`+`Enter`). If the product has multiple options, like size and color, only add image URLs to the first product row. It’s not possible to upload images from your hard drive into this .csv. After importing, Squarespace becomes the host for these image files. Changing or deleting the hosted image URLs won't affect your images.

If you edit product details before importing the .csv file, follow these formatting requirements.

Column	Formatting requirements
Product ID	If there are existing values, remove them.
Variant ID	If there are existing values, remove them.
Product Type	Required Don't edit existing values in this column. If a row in this column is blank, leave it blank.
Product Page	Optional The store page URL slug where the product will import, without the /. You can delete values in this field to create a new, disabled, not-linked store page on the receiving site. Move and enable the page after the import. If there is a URL slug in this field, it must match an existing store page slug on the receiving site.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size and color, only add the product URL to the first product row. Example: v-neck-t-shirt
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row. Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. Example: Made of our softest blend of cotton
SKU	Optional Up to 20 characters per SKU. If this row is blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option names 1-3	Optional Text in these fields represent the label for a drop-down menu on the product details page. Each pair of Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, visit Adding product variants. Example: Color
Option values 1-3	Optional Text in these fields represent the options inside of a drop-down menu on the product details page. Each pair of Option Name # and Option Value # creates a variant. Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51.
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. Here's an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Optional Lowercase only. To add multiple, separate by commas. Up to 25 characters per category. If the product has multiple options, like size or color, only add categories to the first product row. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size and color, only add tags to the first product row. Example: organic, soft
Weight, length, width, height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard. Example: 5 or 5.5
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size and color, only add the visibility status to the first product row.
Hosted Image URLs	Optional Supports web-hosted product image link(s). Paste the image’s full URL. Ensure the URL leads directly to the image, not a page that includes the image. Ensure the URL ends in an image file extension—like .jpg, .gif, or .png—instead of .com or .html. Separate multiple images with spaces or line breaks. (Google Sheets: `Alt`+`Enter` or Excel: `Ctrl`+`Alt`+`Enter`). If the product has multiple options, like size and color, only add the image URLs to the first product row. It’s not possible to upload images from your hard drive into this .csv. After importing, Squarespace becomes the host for these image files. Changing or deleting the hosted image URLs won't affect your images.

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.

Bulk edit on version 7.1
Bulk edit on version 7.0

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	Don't edit existing values in this column.
Variant ID	Don't edit existing values in this column.
Product Type	Don't edit existing values in this column.
Product Page	Required The store page URL slug where the product will import, without the /. Must match an existing store page URL slug. If the product has multiple options, like size and color, only add the product page URL slug to the first product row.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size and color, only add the product URL to the first product row. Example: v-neck-t-shirt
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. Example: Made of our softest blend of cotton.
SKU	Optional Up to 20 characters per SKU. If blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option Names 1-3	Optional The names of the drop-down menus on a product details page. Each pair of Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. Example: Color
Option Values 1-3	Optional The names of the options inside a drop-down menu on the product details page. Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51.
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. Here's an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Required Ensure these match existing categories. Enter the URL slug from the filtered category or subcategory page, including the / Lowercase only. To add multiple, separate by commas. Up to 25 characters per category. If the product has multiple options, like size and color, only add categories to the first product row. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size and color, only add tags to the first product row. Example: organic, soft
Weight, Length, Width, Height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size and color, only add the visibility status to the first product row.
Hosted Image URL	Not editable when bulk-editing products.

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	Don't edit existing values in this column.
Variant ID	Don't edit existing values in this column.
Product Type	Don't edit existing values in this column.
Product Page	Optional The store page URL slug where the product will import, without the /. If the product has multiple options, like size or color, only the first product row will have a product page URL slug. If you remove existing values, the import will create a new not-linked store page. If you edit existing values, you must also edit the store page slug in the receiving site to match.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size and color, only add the product URL to the first product row. Example: v-neck-t-shirt
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row. Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. Example: Made of our softest blend of cotton.
SKU	Optional Up to 20 characters per SKU. If blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option Names 1-3	Optional The names of the drop-down menus on a product details page. Each pair of Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. Example: Color
Option Values 1-3	Optional The names of the options inside a drop-down menu on the product details page. Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51.
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. Here's an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Optional Enter the URL slug from the filtered category or subcategory page, including the / Lowercase only. To add multiple, separate by commas. Up to 25 characters per category. If the product has multiple options, like size and color, only add categories to the first product row. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size and color, only add tags to the first product row. Example: organic, soft
Weight, Length, Width, Height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size and color, only add the visibility status to the first product row.
Hosted Image URL	Not editable when bulk-editing products.

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.

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.

Import to a version 7.1 site
Import to a version 7.0 site

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	Leave this column blank.
Variant ID	Leave this column blank.
Product Type	Required Enter Physical or Service. To learn more about product types in Squarespace, visit Adding products to your store. If the product has multiple options, like size or color, only add the product type to the first product row.
Product Page	Required The store page URL slug where the product will import, without the /. Ensure the store page on the receiving site matches this URL slug in this cell. You may need to add a store page and edit its URL slug to do this. Learn how to find a URL slug. If the product has multiple options, like size or color, only add the product page URL slug to the first product row.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size or color, only add the product URL slug to the first product row. Example: v-neck-t-shirt
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row. Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. If the product has multiple options, like size or color, only add the title to the first product row. Example: Made of our softest blend of cotton.
SKU	Optional Up to 20 characters per SKU. If you leave this blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option Names 1-3	Optional The names of the drop-down menus on a product details page. Each pair of Option Name # and Option Value # creates a variant Add a new row for every possible combination of options in the product. Example: Color
Option Values 1-3	Optional The names of the options inside a drop-down menu on the product details page. Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. Here's an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Required Ensure these match existing categories. Enter the URL slug from the filtered category or subcategory page, including the / Lowercase only. To add multiple, separate by commas. Up to 25 characters per category If the product has multiple options, like size or color, only add the categories to the first product row. Learn how to find the URL slugs. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size or color, only add the tags to the first product row. Example: organic, soft
Weight, Length, Width, Height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size or color, only add the visibility status to the first product row.
Hosted Image URL	Optional Supports web-hosted product image link(s). Paste the image’s full URL. Ensure the URL leads directly to the image, not a page that includes the image. Ensure the URL ends in an image file extension—like .jpg, .gif, or .png—instead of .com or .html. Separate multiple images with spaces or line breaks. (Google Sheets: `Alt`+`Enter` or Excel: `Ctrl`+`Alt`+`Enter`) It’s not possible to upload images from your hard drive into this .csv. After importing, Squarespace becomes the host for these image files. Changing or deleting the hosted image URLs won't affect your images. If the product has multiple options, like size or color, only add the hosted image URLs to the first product row.

As you complete the product .csv template, follow these formatting requirements.

Column	Formatting requirements
Product ID	Leave this column blank
Variant ID	Leave this column blank
Product Type	Required Enter Physical or Service. To learn more about product types in Squarespace, visit Adding products to your store. If the product has multiple options, like size or color, only add the product type to the first product row.
Product Page	Optional Leave this blank to create a new, not-linked store page. If you add a URL slug in this field, it must match an existing store page slug on the receiving site. The store page URL slug where the product will import, without the /. Learn how to find a URL slug. If the product has multiple options, like size or color, only add the product page URL slug to the first product row.
Product URL	Required The URL slug the product will have on your site, without the /. This creates a direct URL to the product details page. Between 3 and 200 characters. Separate words with dashes (-). Don’t include spaces or special characters other than dashes. Capital letters will automatically become lowercase on your site. If the product has multiple options, like size or color, only add the product URL slug to the first product row. Example: v-neck-t-shirt
Title	Required Up to 200 characters. If the product has multiple options, like size and color, only add the title to the first product row. Example: V-Neck T-Shirt
Description	Optional If the product has multiple options, like size and color, only add the description to the first product row. If the product has multiple options, like size or color, only add the title to the first product row. Example: Made of our softest blend of cotton.
SKU	Optional Up to 20 characters per SKU. If you leave this blank, Squarespace will automatically generate SKUs for each product/variant. Example: SQ3579
Option Names 1-3	Optional The names of the drop-down menus on a product details page Each pair of Option Name # and Option Value # creates a variant Add a new row for every possible combination of options in the product. Example: Color
Option Values 1-3	Optional The names of the options inside a drop-down menu on the product details page Example: Blue
Price	Optional The price of the product or variant. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. The price field only supports two decimal places, so round values to the nearest hundredth. Example: enter 10.513 as 10.51.
Sale Price	Optional If the product is on sale, this is its sale price. Only enter a sale price if the sale status is set as Yes (next column). Leave this field blank to only display the standard price. Enter numbers and decimal points (.) only. After the import, prices will display in your store’s currency. Sale price must be lower than the listed price. Example: 7 or 7.50
On Sale	Optional The product or variant’s sale status. Enter Yes if the product or variant should display a sale price. Enter No if the product isn't on sale. If the status is Yes, the product will display a Sale label, the sale price, and the original price with a strikethrough. See an example. Leave the field blank to only display the standard price.
Stock	Optional The number of products or variants in stock. Enter unlimited for items with unlimited stock. Example: 35
Categories	Optional Enter the URL slug from the filtered category or subcategory page, including the / Lowercase only Up to 25 characters per category If the product has multiple options, like size or color, only add the categories to the first product row. Category example: /clothing Subcategory example: /clothing/blouses
Tags	Optional Up to 80 characters per tag. Separate tags by commas. If the product has multiple options, like size or color, only add the tags to the first product row. Example: organic, soft
Weight, Length, Width, Height	Optional Enter numbers (up to 10,000) and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
Visible	Required Enter Yes to make the product visible after importing or No to keep it hidden. If the product has multiple options, like size or color, only add the visibility status to the first product row.
Hosted Image URL	Optional Supports web-hosted product image link(s). Paste the image’s full URL. Ensure the URL leads directly to the image, not a page that includes the image. Ensure the URL ends in an image file extension—like .jpg, .gif, or .png—instead of .com or .html. Separate multiple images with spaces or line breaks. (Google Sheets: `Alt`+`Enter` or Excel: `Ctrl`+`Alt`+`Enter`) It’s not possible to upload images from your hard drive into this .csv. After importing, Squarespace becomes the host for these image files. Changing or deleting the hosted image URLs won't affect your images. If the product has multiple options, like size or color, only add the hosted image URLs to the first product row.

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 Inventory 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.

Was this article helpful?

239 out of 486 found this helpful