Importing CSV files with the Import store 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 Import store 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 Import store app.

Steps:

  1. Export your the following data from your current Shopify store:

  1. From the Shopify admin of your new store, click Apps > Import store. If you don't see this app, then you need to install it.

  2. Complete one of the following steps, according to what you see on the page:

    • Click Get started.
    • Under Select your platform, select Shopify.
  3. Under Upload files, click Add file and select the exported files. The Import store app lets you add multiple files, so you can add all your CSV files at once.

    Uploaded CSV files validated and ready for import

  4. Click Continue import > Import.

Migrating from another platform

When you're migrating to Shopify from another platform, you need to first export the store data from your current platform and add it to CSV files in a format provided by Shopify. Then you can import this data using the Import store 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 the Shopify admin of your new store, click Apps > Import store. If you don't see this app, then you need to install it.

  4. Complete one of the following steps, according to what you see on the page:

    • Click Get started.
    • Under Select your platform, select Shopify.
  5. Under Upload files, click Add file and select the exported files. The Import store app lets you add multiple files, so you can add all your CSV files at once.

    Uploaded CSV files validated and ready for import

  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. If some of your products or customers were imported with changes, then you see specific messages in the PRODUCTS TO REVIEW or CUSTOMERS TO REVIEW sections of the import summary. You can edit your products and customers manually by clicking View products or View customers next to these messages.

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

You might notice that some of your 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 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.

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 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