Migrating from Squarespace to Shopify

You can migrate your products, customers, and order data from Squarespace to Shopify. You need to export your data from Squarespace before you can import it to Shopify.

Step 1: Export your store data from Squarespace

The first step in store migration is to export the product, customer, and order data from Squarespace. When your export is complete, you'll have two CSV files saved to your computer that you can use to import your data into Shopify.

Steps:

  1. From your Squarespace account, go to your advanced settings to download a CSV export file for product data. See Exporting products to a csv for instructions.

  2. From your Squarespace account, go to your orders page to download a CSV export file for orders and customer data. See Exporting orders for instructions.

Step 2: Import your store data into Shopify

After you've exported your product, customer, and order data from Squarespace into CSV files, you need to import these files into Shopify. You need to have Shopify's Import store app installed to complete your data import.

Steps:

  1. From the Shopify admin, click Apps > Import store.

  2. On the Import store page, click Add file and select the exported files. You can add your CSV files individually to the Import store app.

Files selected to import

  1. Click Continue import > Import.

Step 3: Review and update your imported data

If your data import was successful, then you should see your product, customer, and order data in your Shopify admin. If some of your products or customers didn't import successfully, then you can add them manually. Learn how to add a product or add a customer in Shopify.

The following sections describe some of the behaviors that you might see while importing your Squarespace data into Shopify:

Import was successful with changes

When your import is finished, the import summary page shows you the details of your import. If some of your products or customers were imported with changes, then you see specific messages in the Products to review section of the import summary. You can edit your products and customers manually by clicking View items next to these messages.

Products imported successfully but aren't published

If your product visibility was set to hidden in Squarespace, then your product isn't available for purchase on Shopify. If you don't want a product to be hidden, then make it available for the sales channels of your choice.

Imported products no longer have their dimensions

If your customers need the dimensions of your product, then add the dimensions directly to the product description.

Service products imported as physical products

If you had any service products in your Squarespace site, then they are imported as physical products without shipping options in your Shopify store. If your service products require bookings or subscriptions, then you need to install a suitable app to support this.

Some products, customers, or orders failed to import

You might notice that some of your products, customers, or orders failed to import. If some of your products or customers did not import, then you can add a product or add a customer manually.

Note that Squarespace can only export up to 2000 products, with each variant being considered as a single product. So products exceeding this number are not included in your export file and hence not imported to your Shopify store. For example, if your Squarespace site has 500 products, and each product has 5 variants, then you expect 2500 rows to appear in your export file. However, due to the export limit, the export file only contains 2000 rows of data. The remaining 500 rows are excluded from the file, which means 100 products including their variants are not exported.

Any customers with the same email address or phone number aren't included in an import. Only the most recent customer entry with the duplicated data is imported.

Digital products and gift cards aren't imported

Digital products and gift cards aren't included in your product export file, so they can't be imported. You need to add them separately to your Shopify store. For more information, see Selling services or digital products and Adding or updating gift card products.

Product variants failed to import

If your product has variants, and one of the variants is missing an option, then the product isn't imported. You need to add this product to Shopify manually. For example, if you sell T-shirts with the options of size and color and one of your variants includes information about its size but not its color, then your product isn't imported.

Tags applied to imported records

The Import Store app applies tags to imported records. Tags make it easier to find the things you've imported, review them for errors, or make adjustments.

Tags automatically applied to each imported record are in the following format: import_<date>_<import_id>. Tags for any import errors can vary depending on your platform or error type; for example, missing-image or duplicate-variants.

You can keep these tags on your imported records, but this might create problems if you use tags as a method of organization for your store. For example, these tags could be visible to your customers on your online store. To avoid this, you can remove them once you've checked your imported records for errors.

Import data on top of an existing import

If you think you missed something in your previous import, then you can import your store data again on top of your current import by clicking Start new import.

  • If your Shopify store or previous import already contains customers, then they will be updated if a matching customer is found on the import so that no data on the customer in Shopify is lost. The customers are first matched on email address, and then on telephone number if no email address match is found. If a match is found, then the existing record is updated as follows:

    • Tax exempt and marketing subscription statuses are overwritten.
    • Tags, addresses, and notes from the import are added.
    • If the first name, last name, or telephone number fields are empty in the existing record and included in the imported customer record, then they will be added.
  • If your Shopify store or previous import already contains products, then this import ignores import of matching products. You'll see the list of skipped products in the Import summary after your import is complete.

Delete a store data import

If you’re unsatisfied with a data import, then you can delete it. For example, if your data import contains many failed items, then it might be helpful to remove that import and try again. You can delete only your latest import, and need to wait for the data to delete completely before you start another import.

Steps

  1. On the Import complete page, click Delete import.

Delete Import button on the Import complete page

  1. On the Delete import dialog, click Delete import.

After all your imported files are deleted, click Start new import to start another import.

Ready to start selling with Shopify?

Try it free