Squarespace's product CSV import is simpler than most platforms — fewer columns, cleaner structure. But it has specific requirements that aren't documented well, and the format is different enough from Shopify and WooCommerce that you can't convert between them with simple column renaming.
How Squarespace's CSV works
Squarespace uses a Product ID / Variant ID system. The first row for a product contains the Product ID, title, description, and shared data. Variant rows share the same Product ID but have different Variant IDs. The Product ID and Variant ID are just incrementing numbers, not SKUs or handles.
Required columns
- Product ID — Numeric. Groups variants together.
- Variant ID — Numeric. Unique per variant row.
- Product Type — "Physical" or "Digital" (capitalized).
- Title — Product name. Only on the first row per product.
- Price — Selling price as a decimal.
- Visible — "TRUE" or "FALSE" (uppercase).
SEO fields
Squarespace includes SEO Title and SEO Description columns directly in the CSV. This is more convenient than WooCommerce (which needs Yoast meta columns) or Etsy (which doesn't have SEO fields at all). Fill these in during import and your products are search-optimized from day one.
Descriptions
Squarespace product descriptions in the CSV are plain text, not HTML. If you have HTML descriptions from another platform, you'll need to strip the tags before importing. Squarespace adds its own formatting through the content editor after import.
Variant options
Squarespace supports "Option Name 1," "Option Value 1," "Option Name 2," "Option Value 2" columns. The first row for a product defines the option names. Each variant row specifies its values. Squarespace supports up to 2 options per product (compared to Shopify's 3).
What trips people up
- Product URL column — Squarespace uses "Product URL" for the page slug. If blank, it generates from the title. If you include it, make sure it starts with "/" and uses hyphens.
- "On Sale" column — "TRUE" or "FALSE." If TRUE, the "Sale Price" column becomes the active price and "Price" shows as the crossed-out original.
- Stock management — "Unlimited Stock" must be "TRUE" or "FALSE." If FALSE, the "Stock" column determines available quantity.
Get the format right automatically
Catalogd exports Squarespace-ready CSVs with proper Product ID/Variant ID numbering, SEO fields filled in, descriptions in plain text, and correct boolean formatting. Upload your product data and download a file that imports cleanly. Try it free with 5 products.