How to Manually Export and Import Products to Squarespace Using CSV
You can also move your product catalog yourself using Squarespace’s built-in CSV product importer. This manual method works with exports from many eCommerce platforms. It requires you to prepare a Squarespace-compatible CSV file, import the products, organize product categories, and configure SEO redirects yourself.
Step 1. Export Products and Product Categories from Your Current Store
Sign in to your current eCommerce platform and find its product export or catalog export feature. Download a CSV file containing the products you want to move. Menu names vary by platform, so look for options such as Products, Catalog, Export, or Export CSV.
Where available, include product titles, short and full descriptions, SKUs, regular and sale prices, stock quantities, product variants, option names, category assignments, tags, image URLs, and product URL slugs. Save your current product categories and their parent-child structure as a reference, even if they are exported in a separate file.
Keep a backup of the original export and note the important old product and category URLs. You’ll use these when checking the import and creating 301 redirects to Squarespace later.
Step 2. Download the Squarespace Product CSV Template
Set up your Squarespace site and create a store page first. In the Squarespace admin, open Products & Services > Products, select Import, and choose Download CSV Template. Open the template in Excel or Google Sheets and compare its columns with your source export.
Squarespace’s importer expects its own file structure, so copying the original export directly into the import screen may not work. Keep the template’s column names and fill in the appropriate values:
- Product ID and Variant ID: Leave these blank when importing products from another platform.
- Product Type: Use
Physical or Service as appropriate.
- Product Page and Product URL: Enter the Squarespace store-page slug and a valid URL slug for each product.
- Title, Description, SKU, Price, and Stock: Match these fields to your exported catalog and check the pricing and inventory values.
- Categories and Tags: Match your product categories and tags to the structure you want in Squarespace.
- Visible and On Sale: Set the product visibility and sale status according to the template’s requirements.
For a Squarespace 7.1 store, create the required product categories and subcategories before importing. Their slugs must match the values in the CSV, such as /clothing or /clothing/shirts. The Product Page value must also match the URL slug of an existing Squarespace store page. Incorrect slugs can cause import errors.
Step 3. Prepare Variants, Product Images, and URL Slugs
For products with sizes, colors, or other options, organize the CSV according to Squarespace’s product and option-row format. Check each variant’s SKU, price, stock, and option combination. Put shared details, such as the product title and category assignment, in the appropriate main product row.
For product images, use publicly accessible, direct Hosted Image URLs in the Squarespace CSV template. Links must point to the image file rather than to a webpage or a private storage page. Squarespace downloads these images during import; local image files cannot be attached directly through the CSV. Featured images and images specific to each variant may need to be assigned manually afterward.
Review each Product URL value before uploading. Squarespace may use a different product URL structure from your previous store, so keeping a list of old and new URLs now will make 301 redirect setup easier.
Step 4. Import Your CSV File into Squarespace
Return to Products & Services > Products > Import and upload the completed file to the Upload Squarespace CSV area. Review the import results, correct any problems, and select Save when the data is ready. If you do not want the import to change existing inventory counts, review the Update product quantities option before saving.
Two common errors are Product page not found, when the store-page slug in the file does not match an existing Squarespace page, and Categories not assigned, when product category slugs do not match categories already created in Squarespace. Fix the relevant values, then upload the corrected CSV again.
Squarespace’s published CSV limits differ by version: up to 10,000 products in version 7.1 and 200 products in version 7.0, with up to 250 variants per product. The native importer accepts physical and service products, not downloadable products. Check the official Squarespace CSV import guide for the latest limits and field requirements.
Step 5. Review Products, Categories, and SEO Details
Open the imported products in Squarespace and compare them with the original store. Check product names, descriptions, SKUs, prices, sale prices, inventory, variants, images, and the product categories shown on the storefront. Assign featured and variant images manually where needed.
Also review product page URLs, SEO titles, meta descriptions, category navigation, and links between pages. Importing product data does not recreate your old theme, design, apps, or checkout settings. Set up the Squarespace storefront, payment methods, shipping, taxes, and domain separately, then test product selection, cart, and checkout before launch.
Step 6. Create 301 Redirect URLs and Launch Squarespace
When your old store’s product or category URLs differ from the new Squarespace URLs, set up 301 redirects so visitors and search engines can reach the correct replacement pages. Prepare a list that pairs each old URL path with its new destination.
In Squarespace, open Developer Tools > URL Mappings and enter the redirect rules using the old path, new path, and redirect type. For example:
/old-product-url -> /shop/p/new-product-url 301
Save the rules and test a sample of old product and category links. Redirects work for domains connected to your Squarespace site, and the original path must no longer be an active page there. If you’re moving from a different domain, plan the domain connection or transfer separately. Follow the Squarespace URL Mappings guide for redirects covering multiple URLs and other cases.
Keep your old store available until you’ve checked the new storefront and scheduled the final domain switch. A manual CSV import is a one-time transfer, not an ongoing sync. Product or inventory changes made after your export must be handled separately. The native product CSV importer does not move historical orders, customer accounts, product reviews, or your previous site’s design.
