Migrating from Square to Shopify

You can migrate your product, inventory, and customer data from Square to Shopify. You need to export your data from Square before you can import it to Shopify.

Step 1: Export your store data from Square

The first step in store migration is to export the product, inventory, and customer data from Square. When your export is complete, your computer downloads two CSV files containing your Square data, that you use to import that data into Shopify.

Steps:

  1. Log in to your Square account, and then go to your advanced settings.

  2. To download your product and inventory data, Export Your Library in CSV format.

  3. To download your customer data, go to your customers page and click Import/Export > Export customers > Download.

Step 2: Import your store data into Shopify

After you export your product, inventory, and customer data from Square into CSV files, you need to import these files into Shopify.

Steps:

  1. From your Shopify admin, click Apps > Store Importer.

  2. On the Import your data into Shopify page, select Square from the drop-down menu.

  3. In the Upload files section, click Add file, and select the exported CSV files.

  4. Click Continue import > Import.

Step 3: Review and update your imported data

If your data import was successful, then your product and customer data is available in your Shopify admin. If some of your products or customers didn't import successfully, then you can add them manually.

Steps:

  1. In your Shopify admin, review your product, inventory, and customer data to verify that all the data was imported.

  2. If some of the data was not imported, then add missing products or missing customers records manually.

Troubleshooting data import errors

If you encounter errors when you import your data with the CSV file, review the solutions to common product CSV import problems.

If you notice that your data did not import as expected, review the following solutions.

Import was successful with changes

When your import is finished, the import summary page shows you the details of your import. Review the messages in the review section of the import summary for any errors. You can edit your imported information manually by clicking View items next to these messages.

Some products or customers records failed to import

If some of your products or customers didn't import, then you can add a product or add a customer.

Product images and custom attributes do not import. You need to add product images in your Shopify store.

Any customers with the same email address or phone number aren't included in an import. If two or more customers share an email address or phone number, then only the most recently created customer entry is imported.

Limits on product variant creation

If your store has more than 50,000 product variants, then you are limited to creating 1,000 product variants per day.

Multi-location inventory failed to import

In order to import multi-location inventory, you first need to create the locations in Shopify. The names in Shopify need to match the names in Square exactly. You can find the exact location names in the exported CSV file in the columns that contain Current Quantity.

If you attempt to import multi-location inventory before the locations have been created in Shopify, then the inventory will fail to import.

Products with variable prices imported with price of 0

Products that have variable prices or per-location prices have price of 0 after they are imported, and they are not available in any of your sales channels. You are prompted to review these products and set product prices for each of the impacted products.

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 are updated. The customers are first matched by email address, and then 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 are added.
  • If an import contains products that are already on your Shopify store, then the matching products in the import are skipped and not imported. A list of the skipped products is shown in the Import summary after the 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. Wait for the data to delete completely before you start another import.

Steps

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

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

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

Considerations for customer passwords

Because passwords are encrypted, you can't migrate customer passwords from another platform to Shopify. As a result, only customer records are migrated to Shopify instead of customer accounts.

Ready to start selling with Shopify?

Try it free