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:
Paste or edit your own Squarespace product fields (live converter)
02 / THE 4 SQUARESPACE EXPORT QUIRKSWhat breaks if you import a Squarespace CSV directly.
- The
Sale Price = 0.00trap: Unlike WooCommerce (which leaves Sale price blank when inactive), Squarespace often populatesSale Pricewith0.00alongsideOn Sale = No. Always checkOn Sale = YesANDSale Price > 0before copyingSale Priceinto Shopify’sPrice(see zero-price audit rules). Stock = Unlimitedfails Shopify integer validation: Shopify’sInventory quantityonly accepts whole integers. ReplaceUnlimitedwith an emptyInventory tracker(untracked inventory) or setContinue selling when out of stock = continue.- 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’sURL handle(see multi-image continuation guide). - Nested slashes in
Product URL& non-physical rows: Strip category prefixes likeshop/p/ceramic-mugdown to the clean last slug (ceramic-mug) for Shopify’sURL handle, and filter outGIFT_CARDor file-downloadDIGITALrows that require Shopify’s Digital Downloads app.
03 / HEADER DICTIONARYSquarespace Commerce to Shopify CSV mapping table.
| Squarespace CSV header | Shopify CSV header | Conversion rule |
|---|---|---|
Product ID / Variant ID [Non Editable] | Omit from Shopify CSV | Internal Squarespace database IDs; keep only in your local backup copy. |
Product URL | URL handle (Handle) | Take final slug segment (lowercase letters, digits, hyphens; no slashes). |
Title & Description | Title & Description | Keep on primary row of each handle; leave blank on child variant/image rows. |
Option Name 1..3 / Option Value 1..3 | Option1..3 name & value | Squarespace already uses 1 row per variant—carry option values onto every variant row! |
Price, Sale Price, On Sale | Price + Compare-at price | If On Sale = Yes and Sale Price > 0, swap; otherwise use Price only. |
Stock | Inventory quantity | Integer count + Inventory tracker = shopify; if Unlimited, leave tracker blank. |
Visible (Yes / No) | Status + Published | Yes → active / TRUE; No → draft / FALSE. |
Hosted Image URLs | Product image URL | Split space/newline URLs onto shared-handle continuation rows. |
04 / SAFE MIGRATION STEPSMove from Squarespace to Shopify without downtime.
- 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 everysquarespace-cdn.comphoto. - 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. - 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.00prices, non-integer stock cells, or missing handles. - 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.
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 ↗