How to Migrate from Squarespace to Magento 2 or Sync Data Between Them

- E-Commerce, Magento 2, Our extensions

Magento 2 Squarespace Migration

While Big Cartel is a platform dedicated to creative businesses, Squarespace is a giant website builder used for all possible purposes. Although it belongs to the lesser-known e-commerce solutions, Squarespace offers quite decent opportunities for digital commerce. Like other minor e-commerce systems, it is great to start your business, but at a certain point of your growth, the provided functionality is not enough. If you also face this situation or just want to avoid it in the future, you’ve come to the right place. In the following article, we discuss how to migrate from Squarespace to Magento 2. Furthermore, the report sheds light on how to synchronize data flow between the two platforms.

Introduction to Squarespace

Squarespace exists for ages. Launched in 2004, it has got a dominant position in many industries providing users with intuitive and straightforward instruments designed to create a website suitable for their needs. Being a basic drag-and-drop website builder, the platform offers the ability to develop everything from a blog to a landing page or an online storefront. With about 1 million users on board, Squarespace shows reliability, durability, and customer-centric nature. And of course, the platform provides all the necessary e-commerce features. What are the main benefits of Squarespace?

Being a website builder first and foremost, Squarespace introduces quite interesting opportunities for e-commerce store owners. The platform allows leveraging rich visual features and designer templates to represent products most attractively. Of course, Magento 2 also offers the same opportunity, but Squarespace provides more intuitive ways of implementing the same ideas. And unlike Big Cartel, you don’t have any limitations on the number of products. What about integrations?

Get ready to provide your customers with limited payment options! A selected payment gateway doesn’t work in countries where your potential buyers live? It’s time to migrate from Squarespace to Magento 2! But let’s compare the two platforms first.

Magento vs. Squarespace

This chapter is based on materials by SimilarTech. According to the website, Magento is ascending with 143,759 stores in the ecosystem, and Squarespace shows the same tendency with 225,050 websites. Are they all e-commerce websites? No, Squarespace is a website builder that covers sites of all kind. Are they all large websites? No, the platform lags behind Magento in Top 10K Sites, Top 100K Sites, and Top 1M Sites but leads in the Entire Web. The following diagrams illustrate the situation:

Magento 2 Squarespace Migration

Magento has better usage coverage in Shopping, Autos & Vehicles, Computer & Electronics, Adult, and 6 more website categories. As for Squarespace, It is leading in Business & Industry, Arts & Entertainment, People & Society, Food & Drink, and 11 others.

When it comes to geographical distribution, Magento is a clear leader in Germany, Netherlands, France, Italy, and 81 other countries. Squarespace dominates in the United States, the United Kingdom, Canada, Australia, and 114 others. Just take a look at the following map generated by SimilarTech:

Magento 2 Squarespace Migration

While Squarespace is a merchant-friendly solution, it’s ecosystem is not e-commerce-centric. Thus, it lags behind Magento in terms of online storefronts. The lack of many specific features is a great reason to migrate to our favorite platform. Below, we shed light on the most natural way of transferring data from Squarespace to Magento 2. So if you are looking for the Magento 2 Squarespace migration guide, continue reading this article.

How to Migrate from Squarespace to Magento 2

Below, we shed light upon the process of the Squarespace Magento 2 migration. You will find the most straightforward procedure based on a third-party solution and the explanation of why the native Magento 2 tools are not worth your attention. Furthermore, the guide explains the Magento 2 Squarespace synchronization.

While the most evident way to migrate from Squarespace to Magento 2 is based on the default import tools, we don’t recommend you to do this due to multiple drawbacks. The first reason is the lack of support for all entities. Consequently, you have to recreate parts of your Squarespace store on a new platform manually. The second reason is the inability to automate data transfers and map third-party attributes in the Magento admin. That’s why we recommend merchants to rely on third-party solutions to run the complete Squarespace Magento 2 migration with the minimum effort.

The following parameters are essential for seamless data transfers between Magento 2 and Squarespace or other external systems:

  • the chosen module should support all Magento 2 entities;
  • it should be able to automate data transfers;
  • the chosen solution should solve the problem of different attribute standards.

And there are many more aspects substantial for each individual business case. The only Magento 2 extension that combines all of them is the Improved Import & Export extension – a module developed to move any data to and from your e-commerce storefront seamlessly. Thus, if you want to run the Magento 2 Squarespace migration and connect your store to all possible external systems including ERPs, CRMs, marketplaces, and databases, choose our solution. Let’s see how to import any data from Squarespace to Magento 2 in a few clicks using data file transfers or API connections.

Migrate from Squarespace to Magento 2 via Data Files

  1. The first thing you need to do while migrating from Squarespace to Magento 2 is to export products, orders, customers, catalog, and other entities from your old website. The Improved Import & Export Magento 2 extension lets you use XML or CSV files. Create the Squarespace output in these formats. If the desired functionality is not available, you may try to leverage additional solutions. All Squarespace customizations are available here: Squarespace Applications.
  2. Next, import data files to the Magento 2 website using the Improved Import & Export extension. Create a new import job under System -> Improved Import / Export -> Import Jobs.
  3. Configure the job customizing the following sections: General Settings, Import Settings, Import Behavior, and Import Source:
    1. In General Settings, specify a job title and configure other parameters;
      Magento 2 Squarespace Migration
    2. In Import Settings, select an entity that should be moved from Squarespace to Magento 2. The Improved Import & Export extension allows transferring Products, Categories, Customers, Advanced Pricing, Orders, Attributes, Cart Price Rules, CMS Pages and Blocks to your Magento 2 website. Some of them may include additional features. For example, you can get rid of product associations or old categories for products;
      Magento 2 Squarespace Migration
    3. In Import Behavior, choose one of the available import behavior options. Next, determine a validation strategy suitable for the Magento 2 Squarespace migration and add separators;
      Magento 2 Squarespace Migration
    4. In Import Source, select an import file type and file source. Configure other parameters, upload a data file, and validate it.
      Magento 2 Squarespace Migration
    5. Map external Squarespace attributes to ones utilized in Magento 2. Leverage either a mapping preset or the extension’s matching grid.
      Magento 2 Squarespace Migration

Don’t forget to create a separate import job for each entity. Otherwise, you won’t complete the Squarespace Magento 2 migration. Contact our support here to get more information: Firebear Help Center. We will help you run the Magento 2 Squarespace migration on the basis of data files.

Migrate from Squarespace to Magento 2 via API

The alternative way of running the Magento 2 Squarespace migration is based on the ability to connect to Squarespace directly via API using the Improved Import & Export Magento 2 module. To replace file transfers with REST or SOAP connections, follow the guide below:

  1. Go to System -> Improved Import / Export -> Import Jobs and create a new import job there.
  2. Configure General Settings, Import Settings, Import Behavior, and Import Source. Note that the procedure slightly differs from the one described above:
    1. In General Settings, type a job title and configure other parameters;
      Magento 2 Squarespace Migration
    2. In Import Settings, enable API transfers: set ‘Use API’ to ‘Yes’ to turn on the feature. Next, specify an entity that will be transferred from Squarespace to Magento 2;
      Magento 2 Squarespace Migration
    3. In Import Behavior, choose one of the available import behavior options and specify a validation strategy. Select separators to finish the configuration of this section;
      Magento 2 Squarespace Migration
    4. In Import Source, specify a type of the import file: the Improved Import & Export extension lets you run the Magento 2 Squarespace migration using XML or JSON. Next, choose its source: it can be either REST or SOAP. Configure other parameters to continue the Magento 2 Squarespace migration. Validate the data file in the end.
      Magento 2 Squarespace Migration
    5. Now, map Squarespace attributes to Magento 2 ones using presets or a manual matching grid. Otherwise, the further import procedure will be interrupted.

Create a separate import job for each entity and run multiple import processes to migrate from Squarespace to Magento 2 via API. For further information, contact our support here: Firebear Help Center. You will get help regarding the Magento 2 Squarespace migration via API.

How to Synchronize Magento 2 and Squarespace

If you want to run the migration between Magento 2 and Squarespace in several stages or need to sync both platforms, the Improved Import & Export extension will be helpful as well. It is possible to use either data files or APIs as in the cases described above.

Synchronize Magento 2 and Squarespace via Data Files

  1. Go to the admin section of your Squarespace website and export products, orders, customers, catalog, and other entities in XML or CSV formats. If the desired functionality is not available, you may try to leverage additional solutions. All Squarespace customizations are available here: Squarespace Applications.
  2. In your Magento 2 admin, create a new import job under System -> Improved Import / Export -> Import Jobs.
  3. Now, you can configure General Settings, Import Settings, Import Behavior, and Import Source:
    1. In General Settings, type a title of your new job and create a schedule of updates to enable automated data transfers;

    2. In Import Settings, specify an entity you want to move from Squarespace to Magento 2;

    3. In Import Behavior, choose import behavior, validation strategy, and separators;

    4. In Import Source, specify a type of your import file and its source. Upload and validate data to continue.

    5. Apply a mapping preset or match attributes manually to make the Squarespace output suitable for Magento 2.

Create a separate import job for each entity to synchronize the entire data flow from Squarespace to your Magento 2 website.

Now, we’d like to draw your attention to another side of the Magento 2 Squarespace synchronization. The following guide illustrates how to provide your Squarespace website with the Magento 2 data.

  1. Enable data import on your Squarespace store. If the desired functionality is not available, you may try to leverage additional solutions. All Squarespace customizations are available here: Squarespace Applications.
  2. Next, go to your Magento 2 website and create a new export job under System -> Improved Import / Export -> Export Jobs.
  3. Configure General Settings, Export Settings, Store Filter, Export Behavior, and Export Source:
    1. In General Settings, specify a title of your new import job and configure automated updates. The created schedule will automate the Magento 2 Squarespace synchronization;
      Magento 2 Squarespace Migration
    2. In Export Settings, select an entity you want to move from Magento 2 to Squarespace;

    3. In Store Filter, choose a Magento 2 store view to export data from;

    4. In Export Behavior, select file format and separators;

    5. In Export Source, choose a source to export your data file to.

    6. Now, apply mapping and filters, matching Magento 2 attributes to ones used in Squarespace.
      Magento 2 Squarespace Migration
  4. Return to your Squarespace website and launch import.

Don’t forget to create a separate export job for every entity used in the Magento 2 Squarespace synchronization. Save and launch all import and export jobs to synchronize the two systems via data files. To find more information, contact our support here: Firebear Help Center. We will help you explore all the opportunities related to the Magento 2 Squarespace migration via data files.

Synchronize Magento 2 and Squarespace via API

Besides, the Improved Import & Export Magento 2 extension provides the ability to synchronize Magento 2 and Squarespace via API. The module lets you move all the necessary information from your old store to a new one via REST or SOAP.

  1. In your Magento 2 admin, create a new import job under System -> Improved Import / Export -> Import Jobs.
  2. Configure General Settings, Import Settings, Import Behavior, and Import Source:
    1. In General Settings, specify a job title and configure a schedule of updates;

    2. In Import Settings, turn on API transfers: set ‘Use API’ to ‘Yes.’ Next, choose an entity you want to import from Squarespace to Magento 2;

    3. In Import Behavior, switch to an import behavior option and a validation strategy suitable for the migration from Squarespace to Magento 2. Specify separators;

    4. In Import Source, select an import file type. As mentioned above, it can be either XML or JSON. As for an import source, nothing changes: you can rely on REST or SOAP. Configure other parameters and validate the data file.

    5. Apply mapping to match attributes used in Squarespace to the corresponding ones suitable for Magento 2.

Create and configure a separate import job for each entity. Thus, you will enable multiple import processes synchronizing data transfers from Squarespace to Magento 2 via API. Also, create corresponding export jobs to provide Squarespace with the Magento 2 data.

For further information, contact our support here: Firebear Help Center. We will help you with the Magento 2 Squarespace migration via API.

Get Improved Import & Export Magento 2 Extension

Improved Import & Export Magento 2 Extension Features

Magento 2 Squarespace Migration

After describing the Magento 2 Squarespace migration, we’d like to draw your attention to the Improved Import & Export features that simplify the procedure. With our module, you can completely revamp the default import and export functionality of the platform avoiding many inconveniences. The most important fact related to the use of our plugin is that you don’t need to recreate your old e-commerce store on a new platform manually. People face this problem when they use the default Magento 2 import tools which are limited and cannot import all entities. With our extension, all information can be transferred from Squarespace to Magento 2 automatically, different external attributes and their values – matched to ones used internally, multiple file formats – leveraged in the migration, and all entities – imported/exported! As a result, you effortlessly migrate from Squarespace to Magento 2.

Automated Import & Export

The migration from Squarespace to Magento 2 is usually a one-time procedure, so it doesn’t require automation. But we cannot say the same about the synchronization of the two platforms, which is based on regular data transfers. The Improved Import & Export extension provides you with the ability to avoid your daily duties related to data transfers. The module allows automating data transfers in two different ways: via schedules and event-based triggers.

Schedules

Schedules are the most intuitive and straightforward way of automation. Data transfers between Magento 2 and Squarespace or other systems run in the background. Being based on cron, they let you create fully independent import and export jobs that connect your new e-commerce store to Squarespace. The Improved Import & Export Magento 2 module offers several options, such as custom intervals, customizable predefined update schemes, profiles with no schedules (which are good for maintaining such tasks as the Magento 2 Squarespace migration), and asynchronous data transfers (launch every scheduled profile manually whenever you want). The following gif image shows how to configure a schedule:

Events

Event-based triggers are the second huge improvement provided by the Improved Import & Export module. Use the following algorithm to automate data transfers between Magento 2 and Squarespace:

  1. Create a trigger;
  2. Connect it to an event;
  3. Link an action to a trigger to launch it automatically.

Thus, transferring data to Squarespace or other external systems with the help of a trigger is also possible. The same functionality can be leveraged for import. Follow the link below for more details: How to Run Magento 2 Import or Export After Specific System Event or Process.

Advanced Mapping Features

Map Squarespace attributes to ones used in Magento 2 to automate data transfers. If you don’t do that, you won’t import any data to Magento 2 since the platform does not support external attributes. What about the default tools?

If you use them, this procedure takes lots of time and effort since it is necessary to apply changes in a file editor repeating the same actions every time a new update is required. As for the Improved Import & Export Magento 2 extension, it radically simplifies the migration from Squarespace to Magento 2 in terms of attributes and their values with the following features:

Mapping Presets

Use our module to solve the problem of different attribute standards without headaches and enable the Magento 2 Squarespace migration in the most intuitive way with mapping presetspredefined mapping schemes that eliminate manual attributes matching.

Our extension can do all the necessary changes automatically. It analyzes the input data file transferred from Squarespace, discovers third-party attributes, and matches them to the ones used in Magento. You only need to select a matching scheme suitable for your migration. The process is shown below:

Matching Interface

Importing data from Squarespace to Magento 2 can also be enabled by mapping external attributes to the corresponding internal ones. And you do everything right in the Magento admin! The Improved Import & Export module offers a unique matching interface which provides full control over matching: you map external attributes to the corresponding internal ones in a special grid enabling the data transfer. This feature lets you forever forget about doing the same things in a data file. Here is how everything works:

As for the “Default Value” column, it plays an important role in attributes matching when you transfer any data from Squarespace. The column is designed for values, which are provided to all items of a corresponding attribute. For instance, feel free to transfer product data from your old Squarespace store replacing multiple old categories with a specified one. Type a hardcoded value containing a new store view specified for the “_store” attribute, and the Improved Import & Export extension will replace the third-party catalog elements with the chosen one.

Attribute Values Mapping

The Improved Import & Export Magento 2 extension offers a separate interface for attribute values mapping that provides the ability to simplify the Magento 2 Squarespace synchronization and automate it entirely. With our module, external designations will no longer interrupt transfers. Сhoose an external value from Squarespace and specify the internal one from Magento 2 as a replacement. Repeat the procedure until all third-party designations from your old store are mapped to ones utilized in the new one. Note that the created schemes will be saved and applied for further updates. Read this article for more details: Attribute Values Mapping.

Attribute Values Editing

If attribute values mapping is not enough, streamline attribute values editing while transferring data from Squarespace or other systems. It is another feature of the Improved Import & Export module that makes the migration more merchant-friendly. To modify attribute values in bulk, use the following rules:

  • Add a prefix to multiple attribute values;
  • Add a suffix to multiple attribute values;
  • Split multiple attribute values;
  • Merge multiple attribute values.

Note that you can combine them and create conditions increasing the efficiency of the applied changes. Don’t miss the flexibility of our module! For further information, follow this link: How to Modify Attribute Values During Import and Export in Magento 2.

Category Mapping

Category mapping is a feature developed for product data transfers to Magento 2 so that it will help you migrate from Squarespace to Magento 2. Oriented at product import processes, it lets merchants match external categories to ones used internally. As a result, much fewer difficulties occur while products are transferred from Squarespace to Magento 2. The Improved Import & Export module allows mapping external product categories to ones used in your catalog as follows:

To create new categories in the import job, choose a parent category and specify a new one that will be generated automatically. Thus, the extension will link products to it during the import process. If your new Magento 2 store doesn’t include a category from your old Squarespace website, it’s no longer a problem. You can find more information about this feature here: Category Mapping.

Attributes On The Fly

And if a Squarespace data file lacks attributes, create them on the fly via the following general form:

Attribute|attribute_property_name:attribute_property_value|…

The feature is described here in more detail: Product attributes import.

Extended Connectivity Options

As for the extended connectivity options of our module, they are designed to improve all data transfers and simplify the Magento 2 Squarespace migration. With Improved Import & Export, you can leverage new file formats and two alternative ways of transferring data between your e-commerce store and external systems. Also, note that you can move all Magento 2 entities, while the default Magento tools support only several options.

Multiple File Standards

The Magento 2 Squarespace migration on the basis of the Improved Import & Export extension can be performed leveraging XML and JSON file. At the same time, you can leverage ODS and Excel files for other integrations.

Another feature that essentially simplifies data transfers between Magento 2 and other platforms is support for compressed data. Our module knows how to unpack file archives automatically while the default tools work with uncompressed CSV files only! As a result, you can eliminate multiple procedures including the necessity to unpack archives and convert data files into CSV.

Multiple File Sources

The following file sources can be leveraged to import and export data files between Magento 2 and Squarespace:

  • FTP/SFTP. Transfer data files using a local or remote server.
  • Dropbox. Use a Dropbox account to establish a connection between the two systems. Alternatively, you can rely on Box, OneDrive, Google Drive, iCloud, and Amazon Drive.
  • URL. A direct URL can be used to import a data file as well.

Alternative Ways of Import & Export

As for the alternative ways of import and export, they are not represented in Magento 2 by default. Direct API connections and intermediary services enable multiple new integrations. As for connecting Magento 2 to Squarespace, the Improved Import & Export extension provides the ability to leverage REST or SOAP APIs. Note that our module supports the GraphQL standard as well, so you can use it for other cases. All API connections are fully compatible with the extension’s features, so you can streamline mapping, schedules, and attributes on the fly while transferring data via API.

As for the intermediary services, our module works with Google Sheets, Office 365 Excel, and Zoho Sheet. Although they cannot be utilized in the migration from Squarespace to Magento 2, feel free to leverage them for integrations with other systems. The following image shows how to use Google Sheets to move data to Magento 2:

Magento 2 Squarespace Migration

The video below displays our extension in action:

Final Words

The Improved Import & Export module dramatically simplifies the Magento 2 Squarespace migration. Our plugin makes the complicated process more intuitive, user-friendly, and completely automated, as well as eliminates multiple issues and headaches caused by the default import and export tools.

With the support for all entities and multiple file formats, API connections and various file sources, schedules and mapping, you will effortlessly import any data from Squarespace and any external systems to Magento 2 turning the migration procedure into an entirely automated process. For further information, follow the link below and contact our support:

Get Improved Import & Export Magento 2 Extension