How to Bulk Import Products via CSV File in Squarespace

How to Bulk Import Products via CSV File in Squarespace

By Michael Turner

January 24, 2025 at 08:36 AM

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

Import Options:

  • Move products between Squarespace sites
  • Bulk edit existing products
  • Import from other platforms
  • Create new products

Key Limitations:

  • Version 7.1: Up to 10,000 products
  • Version 7.0: Up to 200 products
  • Maximum 250 variants per product
  • Only physical products and services supported

Squarespace Product Options Table

Squarespace Product Options Table

Basic Steps:

  1. Download appropriate CSV template:

    • For moving products: Export from original site
    • For new products: Use Squarespace template
    • For other platforms: Use platform-specific import options
  2. Format Requirements:

    • Use correct column headers
    • Follow character limits
    • Use proper URL slugs
    • Separate multiple values with commas
    • Format prices as numbers only
  3. Import Process:

    • Click Import in Products panel
    • Upload completed CSV file
    • Review for errors
    • Save changes

Important Notes:

  • Ensure store page URLs match CSV data
  • Categories must exist before import
  • Images require direct web URLs
  • Cannot import customers or subscriptions
  • Featured images must be set manually
  • Print-on-demand products need reconnection

Troubleshooting Tips:

  • Verify column headers
  • Check URL protocols for images
  • Ensure clean CSV formatting
  • Match existing store categories
  • Validate URL slugs
  • Remove special characters
  • Use proper decimal formatting

Related Articles

Previous Articles