Quick Rule Summary · Updated November 2026

Never import a raw Squarespace Commerce CSV straight into Shopify: Squarespace exports Sale Price = 0.00 on non-discounted items (which prices products at $0.00 if mapped blindly!), writes text Unlimited inside Stock, and requires Product Page + Product URL to become a shared URL handle.

01 / INTERACTIVE SQUARESPACE CONVERTERSanitize 0.00 sale prices, Unlimited stock & space-delimited gallery URLs.

Click any Squarespace scenario below—or open the live field drawer to paste values from your own export—and download a clean UTF-8 Shopify CSV:

Source Row Exported From Squarespace Commerce
Paste or edit your own Squarespace product fields (live converter)
Check full CSV in Workspace ↗

02 / THE 4 SQUARESPACE EXPORT QUIRKSWhat breaks if you import a Squarespace CSV directly.

  1. The Sale Price = 0.00 trap: Unlike WooCommerce (which leaves Sale price blank when inactive), Squarespace often populates Sale Price with 0.00 alongside On Sale = No. Always check On Sale = Yes AND Sale Price > 0 before copying Sale Price into Shopify’s Price (see zero-price audit rules).
  2. Stock = Unlimited fails Shopify integer validation: Shopify’s Inventory quantity only accepts whole integers. Replace Unlimited with an empty Inventory tracker (untracked inventory) or set Continue selling when out of stock = continue.
  3. Space-separated Hosted Image URLs: Squarespace joins multiple photo URLs with spaces or line breaks inside one cell on the first row of each product. Split those URLs into vertical continuation rows sharing the product’s URL handle (see multi-image continuation guide).
  4. Nested slashes in Product URL & non-physical rows: Strip category prefixes like shop/p/ceramic-mug down to the clean last slug (ceramic-mug) for Shopify’s URL handle, and filter out GIFT_CARD or file-download DIGITAL rows that require Shopify’s Digital Downloads app.

03 / HEADER DICTIONARYSquarespace Commerce to Shopify CSV mapping table.

Mapping Squarespace product export columns to canonical Shopify product CSV headers
Squarespace CSV headerShopify CSV headerConversion rule
Product ID / Variant ID [Non Editable]Omit from Shopify CSVInternal Squarespace database IDs; keep only in your local backup copy.
Product URLURL handle (Handle)Take final slug segment (lowercase letters, digits, hyphens; no slashes).
Title & DescriptionTitle & DescriptionKeep on primary row of each handle; leave blank on child variant/image rows.
Option Name 1..3 / Option Value 1..3Option1..3 name & valueSquarespace already uses 1 row per variant—carry option values onto every variant row!
Price, Sale Price, On SalePrice + Compare-at priceIf On Sale = Yes and Sale Price > 0, swap; otherwise use Price only.
StockInventory quantityInteger count + Inventory tracker = shopify; if Unlimited, leave tracker blank.
Visible (Yes / No)Status + PublishedYes → active / TRUE; No → draft / FALSE.
Hosted Image URLsProduct image URLSplit space/newline URLs onto shared-handle continuation rows.

04 / SAFE MIGRATION STEPSMove from Squarespace to Shopify without downtime.

  1. Export all products from Squarespace: In Squarespace, go to Selling (or Commerce) → Products → Export All to download your products.csv—and keep your Squarespace site live until Shopify finishes importing every squarespace-cdn.com photo.
  2. Sanitize On Sale, Stock = Unlimited & Product URL: Apply the conditional price and inventory formulas shown in the converter above, and split multi-image cells into continuation rows.
  3. Preflight locally in Row & Record: Drop your cleaned UTF-8 CSV into our browser-local workspace (or verify headers with our Chrome Extension ↗) to catch any residual 0.00 prices, non-integer stock cells, or missing handles.
  4. Test 3 products in Shopify Admin first: Import a 3-product sample slice via Products → Import, confirm storefront variants, CDN photos, and strikethrough pricing, then import your full catalog.

Common questions.

Why did my Squarespace products import into Shopify at $0.00?

Squarespace exports 0.00 in the Sale Price column for non-discounted products (with On Sale set to No). If you map Sale Price directly to Shopify’s Price without checking On Sale = Yes, full-price items import at $0.00.

How do I fix Squarespace’s “Unlimited” stock error when importing to Shopify?

Shopify’s Inventory quantity column only accepts whole numbers and rejects the word Unlimited. For made-to-order or untracked items, leave Inventory tracker and Inventory quantity blank (or set Continue selling when out of stock to continue).

How are multiple product images formatted in a Squarespace CSV export?

Squarespace places multiple image URLs inside a single Hosted Image URLs cell separated by spaces or line breaks, whereas Shopify requires one Product image URL per vertical continuation row sharing the same URL handle.

Do Squarespace DIGITAL and SERVICE products import cleanly via Shopify CSV?

Shopify’s Product CSV imports product titles and prices, and you can set Requires shipping to FALSE for services or digital items, but downloadable digital files themselves must be re-attached in Shopify’s free Digital Downloads app after import.

RELATED CSV TOOLSConverting from another storefront to Shopify?

Ready to preflight your Squarespace-to-Shopify CSV?

Audit prices, headers, and variant grouping locally in your browser—zero store credentials or uploads.

Open CSV Preflight Workspace ↗

Verified November 2026 against Squarespace Commerce’s CSV export schema and Shopify’s Product CSV importer.

Shopify official Squarespace migration guideShopify product CSV column referenceRow & Record Chrome Extension ↗