Importing CSV files with the Store Importer app

If you're migrating to a Shopify store from an existing Shopify store, or from a platform that's not listed here, then you can use the Store Importer app to import your product, customer, and inventory data.

Considerations

  • The import process doesn't create fulfillment services. Fulfillment services need to exist on your store before importing. If your import contains a missing fulfillment service, then a product with the manual fulfillment service is created. A message appears on the import summary error index page with this information.

Migrating from one Shopify store to another

To migrate from one Shopify store to another, you need to first export your product, customer, and inventory data to CSV files, and then import this data using the Store Importer app.

Steps:

  1. Export the following data from your current Shopify store:
  2. From your Shopify admin, click Apps > Import store.

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

  4. Under Upload files, click Add file and select your exported files. You can select any number of CSV files.

  5. Click Continue import > Import.

Migrating from another platform

When migrating from another platform to Shopify, you need to export your store data from your current platform, and then put the data into CSV files in a format provided by Shopify. After your data is in the correct CSV format, you can import the CSV files into your Shopify store using the Store Importer app.

Steps:

  1. Export your store data.

  2. Use the CSV templates for products, customers, and inventory to make sure that your data is in the acceptable CSV file format.

  3. From your Shopify admin, click Apps > Import store.

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

  5. Under Upload files, click Add file and select your exported files. You can select any number of CSV files.

  6. Click Continue import > Import.

Review and update your imported data

If your data import was successful, then you should see your 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 data into Shopify:

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.

Historical orders

Orders that were imported from your previous platform are migrated to your Shopify store only for historical purposes. These orders are automatically set to the Archived status. While you can technically unarchive them, you'll not be able to perform any functionality normally reserved for orders created in a Shopify store.

Products imported successfully but aren't published

If your product visibility was set to hidden in your previous store, 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.

Some products or customers failed to import

If some of your products or customers did not import, then you can add a product or add a customer manually.

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, suppose that you sell T-shirts that have different options for size and color. If one of your variants includes information about its size but not its color, then your product isn't imported.

Gift card products

Gift card products are not imported and need to be created manually.

Some inventory records failed to import

Inventory imports only work for stores with multiple locations enabled. The import process doesn't create locations. Locations need to exist on your store before importing. If your import contains a missing location, an error message appears in the import summary and the inventory is imported for this location.

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