Squarespace to Shopify Migration - Products

🥦

Migrate Complete

Shopify Products CSV Format
valid rows

Convert your Squarespace Commerce catalog to Shopify CSV format. Preserves product URLs, handles variants, and maps sale pricing automatically.

Free preview, Pay only to download
Your data stays in your browser
Run on Google Cloud Platform

Download Sample Squarespace Export

Example Squarespace product export to test the converter

Sample Products

Tool Rating

4.6 / 5 (98 votes)

How It Works

1

Export from Squarespace

Products & Services → Products → Export all

2

Upload and Configure

Upload Products Export CSV and choose Product Import format

3

Preview and Download

Review converted data, download Shopify-ready file

4

Import to Shopify

Products → Import

Why Squarespace Products Don't Import Directly to Shopify

The Image Column Problem

Squarespace exports images in 5 separate columns (Product Image 1-5 URL). Shopify requires each image as a separate row with the same Handle identifier. Squarespace also uses different field names than Shopify expects.

Sale Pricing Structure

Squarespace has separate On Sale flag, Sale Price, and regular Price fields. Shopify uses Variant Price (selling price) and Compare At Price (original) model. Without conversion, sale pricing doesn't display correctly in Shopify.

What This Tool Does

We automatically restructure and transform your Squarespace export: - URL Preservation: Product Page → Shopify Handle (maintains SEO) - Image Restructuring: 5 image columns → separate Shopify image rows - Field Mapping: Squarespace names → exact Shopify column names - Sale Price Logic: On Sale + Sale Price → Variant Price + Compare At - Categories: Semicolon-separated → comma-separated tags - Weight Conversion: Squarespace units → grams - Options: Squarespace variant options → Shopify Option1/2/3 columns Your Shopify import succeeds with SEO preservation, complete data, and proper sale pricing.

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

Field Mapping

How Squarespace Products fields map to Shopify Products

Squarespace Products Source Value Shopify Products Target Value Note
Product Name Classic Cotton T-Shirt Title Classic Cotton T-Shirt Product name
Product Page classic-cotton-tshirt Handle classic-cotton-tshirt URL slug (preserves SEO)
SKU TSH-001 Variant SKU TSH-001 Stock keeping unit
Description <p>Comfortable 100% cotton t-shirt</p> Body (HTML) <p>Comfortable 100% cotton t-shirt</p> Product description
Price 29.99 Variant Price 29.99 Base price or sale price
Stock 100 Variant Inventory Qty 100 Stock quantity
Categories Apparel;T-Shirts Tags Apparel;T-Shirts Semicolon-separated → comma-separated
Tags cotton, casual, summer Tags cotton, casual, summer Merged with categories
Option Name 1 Size Option1 Name Size First variant option
Option Value 1 Small Option1 Value Small Option value
Visible TRUE Published TRUE Visibility status
SEO Title Classic T-Shirt - Comfortable Cotton SEO Title Classic T-Shirt - Comfortable Cotton Meta title
SEO Description Shop our classic 100% cotton t-shirt SEO Description Shop our classic 100% cotton t-shirt Meta description

Why Use This Tool?

SEO-Preserving URLs

Maps Squarespace Product Page to Shopify Handle to preserve product URLs and rankings.

Image Restructuring

Converts Squarespace's 5 image columns into separate Shopify rows with proper positioning.

Sale Price Mapping

Intelligently converts On Sale flag + Sale Price to Shopify's Compare At Price system.

Weight Conversion

Converts weights from pounds, kilograms, or ounces to Shopify's required grams format.

Category Flattening

Converts Squarespace semicolon-separated categories to comma-separated Shopify tags.

Variant Options

Maps Squarespace Option Name/Value fields to Shopify's Option1/2/3 structure.

Data Transformation

Each Squarespace product becomes multiple Shopify rows (base + images)

Input Squarespace Product

Single row with 5 image URL columns

Key columns: Product Name, Product Page, Price, Product Image 1-5 URL
1:N — One input row creates multiple output rows
Output Shopify Product Rows 1 + number of images rows per input

Main product row + additional image rows

Main Product Row Complete product data
Additional Image Rows Separate row per additional image
All rows share same Handle

Common Product Import Errors

Issues you might encounter when importing Products Export data to Product Import - and how we solve them

Missing Product Page Slug

Product Page column (URL slug) is required

Empty Product Page field
classic-cotton-tshirt

Ensure all products have URL slugs in Squarespace

Generate slugs from Product Name if missing

Sale Price Without On Sale Flag

Sale Price provided but On Sale is FALSE

Price=29.99, Sale Price=24.99, On Sale=FALSE
Set On Sale=TRUE when Sale Price < Price

Tool uses Sale Price if On Sale=TRUE and Sale Price < Price

Verify sale pricing logic in preview

Want to save on credits?

Buy bundles and get up to 27% off. Check our pricing options below.

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent

Credit Bundles

$ /Credit

One-time purchase

  • No monthly commitment
  • Credits valid for one year
  • Access to all tools
  • Full file downloads

Monthly Bundles Pro

$ /Credit

Best for professionals and content creators

Annual Discount
Per month, billed annually:
Save 20% more
  • Credits refresh monthly
  • Priority processing

Purchase Credits

  • Full CSV & Excel export
  • Google Sheets export
  • Instant browser download
for credits

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

How are credits calculated?

Credits are based on rows in your file. Each tool shows its rate (e.g., 2,000 rows = 4 credits). We round up to the nearest step. Minimum 1 credit per conversion.

Is my data secure?

Files process entirely in your browser. We're GDPR compliant with TLS encryption.

Can I get a refund?

Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.

Powered by Paddle

Terms of service applies. VAT included where applicable.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Use Commerce → Inventory → Export Products. This creates a CSV with all product data including variants, images, and pricing.
Squarespace exports images in 5 columns (Product Image 1-5 URL). We create a separate Shopify row for each image with the same Handle, properly numbered.
Yes! We use Squarespace's Product Page field as the Shopify Handle. This preserves product URLs for SEO. Set up domain forwarding and 301 redirects for the domain change.
If On Sale=TRUE and Sale Price < Price, we set Variant Price = Sale Price and Compare At Price = Price. This shows strikethrough pricing in Shopify.
Squarespace Option Name/Value fields map directly to Shopify's Option1/2/3 structure. Up to 3 options are supported (Shopify limit).
Squarespace categories are converted to Shopify tags. Create Shopify Collections manually and use tag-based automation rules.
The Digital flag is mapped (sets Variant Requires Shipping to FALSE). Actual digital files must be re-uploaded in Shopify.
Stock quantities migrate to Shopify Variant Inventory Qty. Inventory tracking is enabled automatically for products with stock data.
This tool migrates products only. Squarespace doesn't provide customer/order export for migration. You'll need Shopify migration apps for order history.
Migration time varies by store size. Small stores take a few hours to days, while larger stores with thousands of products can take weeks. Professional services typically complete migrations in 1-14 business days.

Also available as

This platform pair is available in 2 other hubs