Here's a concise version focusing on the essential information about importing products via CSV in Squarespace:

CSV product imports in Squarespace allow you to add or edit multiple products simultaneously. You can:

• Transfer products between Squarespace sites
• Bulk edit existing products
• Import products from other platforms

Import Limits:

• Version 7.1: Up to 10,000 products
• Version 7.0: Up to 200 products
• Both versions: Up to 250 variants per product

Getting Started:

1. Download the appropriate CSV file:

• For transfers: Export All from original site's Products panel
• For bulk edits: Export All from Products panel
• For new imports: Download CSV template from Import menu

Key CSV Formatting Requirements:

• Product ID and Variant ID must remain untouched
• URL slugs must match existing store pages
• Categories must match existing store categories
• Prices should use only numbers and decimal points
• Image URLs must link directly to image files

Essential Fields:

• Product Title (mandatory, up to 200 characters)
• URL Slug (mandatory, 3-200 characters)
• Price (optional, numbers only)
• Stock Level (optional, number or "unlimited")
• Visibility (mandatory, "Yes" or "No")

Importing Process:

1. Go to Products panel
2. Click Import
3. Drag and drop your CSV file
4. Review for errors
5. Click Save

Common Troubleshooting:

• Missing categories: Add categories to store first
• Failed images: Try alternate URL protocols (http:// vs https://)
• Import errors: Copy data to new spreadsheet and re-save as CSV
• Formatting issues: Remove bullets, hyperlinks, and special characters

Limitations:

• Physical and service products only
• No customer data transfer
• No subscription transfer
• No scheduled publishing
• No automatic variant images
• No featured images transfer

Follow these guidelines carefully to ensure successful product imports and avoid common pitfalls.

Related Articles

Previous Articles