Here's a concise guide to importing products in Squarespace using .csv files:

You can bulk add or modify up to 10,000 products (version 7.1) or 200 products (version 7.0) using a .csv file import. Each product can have up to 250 variants.

Requirements before importing:

• Create a store on your Squarespace site
• Ensure store page URL slugs match the Product Page column
• Set up matching categories if specified in the .csv file

To import products:

1. Get the correct .csv template:

• For moving between Squarespace sites: Export from original site
• For bulk editing: Export from current site
• For new products: Download template from Products panel

2. Format the .csv file properly:

• Use only allowed characters and formats
• Keep product details in the first row of variant groups
• Include required fields (Product Type, Page URL, Product URL, Title)
• Follow character limits for each field

3. Import the file:

• Go to Products panel and click Import
• Drag and drop your completed .csv file
• Review results and fix any errors
• Click Save

Key limitations:

• One-time import only (no automatic syncing)
• Physical and service products only
• No customer or subscription transfers
• No scheduled publishing
• Featured images must be set manually
• Variant images must be added manually

Common issues:

• Missing product page URLs
• Unassigned categories
• Missing Product ID column
• Image import failures (check URL protocols)
• Formatting problems (avoid bullets, hyperlinks, special characters)

For a successful import, use the correct template, maintain proper formatting, and ensure all required fields and URLs match your site structure.

Related Articles

Previous Articles