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

Importing products from a .csv

You can use our standard .csv to import products from any platform into your Squarespace store. The .csv helps you create a Squarespace-friendly format for all of your existing product data, including variants, prices, stock, tags, and categories. You can also bulk-edit products by importing an updated .csv file.

Download the .csv.

Product importing is only available on the Commerce Basic and Advanced plans.

Before you begin

The importer scans the .csv for certain formatting. Keep in mind:

  • When completing your .csv file, your column headers and entries must match the standard formatting in the file.
  • If you’re coming from Big Cartel, Etsy, or Shopify, use our platform-specific options instead.
  • If you already have a .csv of your products, that file might not import into Squarespace as-is. We recommend copying the data into our formatted file for the best results.

Limitations:

  • Imported products won't have a set thumbnail image. You can set a thumbnail image manually.
  • This is a one-time import. Any updates to your original store or .csv won't automatically sync to Squarespace after the import.
  • The import is only for physical and service products. Digital products won’t import.
  • Subscription products won't import.
  • It’s not possible to schedule products with an import, only publish or hide.
  • You can import up to 200 products per Product Page via .csv. Each product can have up to 100 variants. 

Step 1 - Download the .csv

  1. In the Home Menu, click Commerce, then click Inventory.  
  2. Click the ... icon in the top-right corner.
  3. Click Import.
  4. Click Download CSV template.
  5. Open the file with a spreadsheet program, like Excel or Google Sheets.

Step 2 - Complete the .csv file

Next, add your products to the downloaded .csv file. The .csv spreadsheet contains sample text, which guides you through formatting your product information.

To complete the spreadsheet:

  1. Open the .csv file in a spreadsheet editor, like Google Sheets or Microsoft Excel.
  2. Add your products one row at a time, following the example rows and tips in the table below.
  3. Delete the example rows.
  4. Save the file.

When you enter your products in the .csv file, ensure that you:

  • Complete all required columns for each product.
  • Don’t change or delete any column headers.
  • Don’t delete any columns. You can leave optional columns blank instead.
  • Delete all example rows after using them as a reference for formatting your data.
  • Delete all empty rows.
  • If you’re importing variants, see Formatting variants for the import.
  • Save the file as a .csv.

Use the table below to help format your entries.

Note: The .csv doesn’t support columns other than those listed here. Adding unsupported columns may cause your import to fail.

Column

Description and format tips

Product ID [Non Editable]

  • Our system uses the values in this column to edit existing products in your store. Do not edit existing values in this column.
  • Leaving this column blank will create new products.

Variant ID [Non Editable] 

  • Our system uses the values in this column to edit existing products in your store. Do not edit existing values in this column.
  • Leaving this column blank will create new variants.

Product Type [Non Editable]

  • Our system uses the values in this column to edit existing products in your store. Do not edit existing values in this column.

Product Page

  • Optional
  • The Product Page URL slug where the product will import, without the /.
  • Between 3 and 250 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 variants, enter each variant on a new line. You only need to enter the Product Page URL for the first variant.

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 250 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 variants, enter each variant on a new line. You only need to enter the product ULR for the first variant. 
  • Example: v-neck-t-shirt

Title

  • Required
  • Up to 200 characters.
  • If the product has variants, only enter the product title in the first variant’s row.
  • Example: V-Neck T-Shirt

Description

  • Optional
  • If the product has variants, only enter the description in the first variant 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 Name 1

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Color

Option Value 1

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Blue, Red, Black

Option Name 2

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Size

Option Value 2

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Small, Medium, Large

Option Name 3

  • Optional
  • The label of a drop-down menu.
  • Each pair of an Option Name # and Option Value # creates a variant. Add a new row for every possible combination of options in the product. For more help, see Formatting variants for the import.
  • Example: Sleeve Length

Option Value 3

  • Optional
  • An option inside of a drop-down menu.
  • Examples: Long Sleeve, Short Sleeve 

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 TRUE (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.
  • Example: 7 or 7.50
  • Sale price must be lower than the listed price.

On Sale

  • Optional
  • The product or variant’s sale status. Enter TRUE if the product or variant should display a sale price.
  • If the status is TRUE, 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
  • Up to 25 characters per category.
  • Separate categories by commas.
  • If the product has variants, only enter categories in the first variant row.
  • Example: Tops

Tags

  • Optional
  • Up to 80 characters per tag.
  • Separate tags by commas.
  • If the product has variants, only enter tags in the first variant row.
  • Example: organic, soft

Weight

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Length

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Width

  • Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Height

  •  Optional
  • Enter numbers and decimal points (.) only. After the import, dimensions will match your store’s measurement standard.
  • Example: 5 or 5.5

Visible

  • Required
  • Enter TRUE to make the product visible after importing or FALSE to keep it hidden.
  • If the product has variants, only enter the visibility in the first variant row.

Hosted image URLs

  • Optional
  • 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. Check if 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 variants, only enter image URLs in the first variant 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.

Formatting variants for the import

Variants are variations of a product with different attributes, like size or color. Learn more about basic and complex variants.

If your product has variants, enter a new row in the .csv for each possible combination of options. Complete all relevant fields for the main item, then create a new row for each variant. You only need to add the Product URL for the first variant. This lets Squarespace import them as different versions of the same product, and adds them to drop-down menus on the same product details page.

For each variant, keep these fields blank so they inherit the same values for the main item:

  • Title
  • Short Description
  • Product Type
  • Tags
  • Categories
  • Hosted Image URLs

You can complete all other optional columns for each variant.

Note: A single product can have up to 100 variants.

Completing the combination rows

For example, you’re selling a tote bag that comes in blue and red. On your site, this product will have one Color drop-down menu.

  • First variant row: Enter Color as Option Name 1, then Red as Option Value 1.
  • Second variant row: Enter Color as Option Name 1 and Blue as Option Value 1.

Variant_example_-_Handbag.png

As another example, you’re selling a shirt that comes in black or white, and you sell sizes Medium or Large. On your site, this product will have two drop-down menus: Color and Size. You’ll create four variant rows to cover the different combinations:

Untitled_spreadsheet_-_Google_Sheets.png

As a third example, you’re selling a shoes that come in brown or black, sizes 6 through 10, and M or W width. On your site, this product will have three drop-down menus: Color, Size, and Width. You’ll create many rows that cover the different combinations of options. The first few rows should look like this:

Variant_Example_-_Shoes.png

Note: The import won't support additional Option Value and Option Name columns.

Step 3 - Upload the file

  1. Drag and drop the completed .csv into the Upload Squarespace CSV box.
  2. To prevent the import from updating stock levels to the values in the spreadsheet, uncheck Update product quantities.
  3. Review the results and correct any errors by uploading an edited .csv file.
  4. Click Save.
Tip: 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.

Step 4 - Enable your content

Your imported content will appear in a new Products Page in the Not Linked section of the Pages panel, or on the specific Product Page you listed in the Product Page column. This page is disabled by default. This means that it's hidden from your navigation menus, and visitors can't see it until you're ready to move and enable it.

Tip: If you don't see a Imported Products page in the Pages panel, refresh your browser.

not_linked_section.jpg

Next steps

From here, you can customize the Products Page:

FAQ

Why did my import fail?

If your import failed, review your completed .csv file to ensure that all fields are properly formatted.

Check that:

  • All column headers match the table above.
  • All rows follow the formatting rules in the table above.
  • The file doesn't have any columns or headers other than those shown above.
  • All variants of a product are listed in adjacent rows.
  • The required columns of each product row are complete.
  • The file is saved as a .csv (comma-separated values), not .scsv or tsv.
  • The .csv file doesn't exceed the 200 product-per-page limit.

Fix any of the issues above, save the file as a .csv, and try importing again.

What if I accidentally imported the sample products?

If the products from the example rows in the .csv imported, you can delete them.

Can I import products from another Squarespace site?

Yes. To import products from one Squarespace site to another, export your products to a .csv. You may need to edit the file if you sell digital products, or products with many variants.

Will importing more .csv files erase any existing products on my site?

No. You can import as many .csv files as you need. Each import of new products creates a new Products Page in the Not Linked section of your site.

Can I import customers?

No. Products via .csv only supports product imports.

Is there a limit to how many products I can import?

Yes. Products via .csv supports up to 200 products per Product Page. Each product can support up to 100 variants.

Troubleshooting

 

Images aren't appearing after import

Ensure your image URL begin with “http://” and not “https://” or “ftp://”

I followed the guidelines but my import still fails

If your import continues to fail, we recommend importing the .csv into a spreadsheet to check for unsupported formatting. We updated the product import template on December 6, 2019. Download the new template here. Common formatting problems include:

  • Bulleted lists
  • Hyperlinks
  • Nonstandard characters
Was this article helpful?
19 out of 61 found this helpful
Importing products from a .csv