Transporter app

Use the Transporter app to import customer, product, and order records into your Shopify store. This app accepts comma-separated values (CSV) files for each of these record types, processes the records, and then imports them as objects into Shopify.

Transporter app is part of a suite of tools that makes it easier migrate online stores from other platforms to Shopify Plus. This suite includes the following tools:

  • The Transporter command line tool that you can use to extract and convert records from one platform into CSV files that are supported by the Transporter app. Developers can edit the source files for this tool and convert data from other platforms into CSV files. The command-line tool is an open source Ruby gem, that can be downloaded and installed from github.com/Shopify/shopify_transporter.

  • The Transporter app that you can use to import product, customer, and order data into Shopify. This app uploads CSV files and it is available from the Shopify App Store.

CSV sample files and descriptions

To import customers, products, and orders into Shopify, you need a separate CSV file for each record type. You can use the Transporter command-line tool to generate this CSV file, or you can follow the format in the sample CSV file to create it yourself.

The CSV format that the Transporter supports is different from the format that the Shopify admin uses to import products and customers, and to export products, customers, and orders.

Sample files and descriptions of supported columns are available for each object.

Sample files Column descriptions
Products.csv Product descriptions
Customers.csv Customer descriptions
Orders.csv Order descriptions

CSV file rules

If you use the Transporter command-line tool to create your CSV files, then your files already conform to the following rules:

  • The name of your CSV file needs to include the name of the object type (products, customers, orders) that it contains. For example, a file that contains the customer records needs to have the word customers in it (for example, mycustomers.csv).
  • The CSV file must use UTF-8 encoding to avoid generating unwanted special characters in your file. If you save your file without using UTF-8 encoding, then your data will be corrupted when you upload it as a new spreadsheet. Shopify can't recover corrupted files for you.

Also, as is true with most CSV files:

  • The first line in the CSV file needs to contain the names of the column headers.
  • The order of the columns is not important, but every row needs to follow the same order of columns.
  • Each column in the file needs to be separated with a comma and each line needs to be separated by a line break.
  • If any value contains special characters, such as a comma (,), a quote ('), or a double quote ("), then you must surround the entire value with double quotes. For example, "Unit 8, 150 Elgin Street" (not Unit 8"," 150 Elgin Street). If you need to use a double quote within this value, then use two double quotes:" ""8th Floor"", 150 Elgin Street".
  • Make sure that you use straight quotes instead of smart quotes (also known as "curly quotes").

If you edit your CSV files or you use another process to create your CSV files, then make sure that your CSV files conform to these rules. If you have trouble working with your CSV files, then try using Google Sheets.

Order your imports

The order in which you import your products, customers, and orders is important. You need to import them in the following order:

  1. Products
  2. Customers
  3. Orders

Run test imports

Before you import a large number of records into Shopify, try importing a few records. Often an iterative approach is needed, such as one that involves importing a small number of records, reviewing their results (in the app and in the admin), correcting the CSV file, and then reimporting the objects. Before you can reimport any objects, you need to delete them from Shopify. You can use the Transporter app to delete the objects by providing a CSV file that lists the objects to be deleted.

Disable notification emails

When orders are imported into Shopify using the Transporter app:

  • notifications are not sent to your customers.
  • notifications are sent to your team to let them know that new orders have been added to your store. When you are testing and importing orders into a store that is not yet active, these notifications can be a distraction. You can disable these notifications for the duration of your order imports.

Steps:

  1. From your Shopify admin, click Settings > Notifications.
  2. Under Order notifications, click Disable.

After you have finished importing your orders, remember to re-enable the notifications.

Import products, customers, and orders

Remember to import products, customers, and then orders.

Steps:

  1. In the Transporter app, make sure that Upload file is enabled for the Action.
  2. Enter your CSV file.

After your file has uploaded, the app begins importing your objects.

Delete test products, customers, and orders

You can delete products, customers, and orders in bulk from your Shopify store by using the Transporter app. You can use the same CSV file that you used to import the objects, but this CSV file only needs the column that contains the object's unique key:

Object type Required unique key columns
Products (including all associated product variants) Handle
Customers Email or Phone Number
Orders Name

The Transporter app can only delete objects, not parts of objects. For example, it can delete products (including their associated variants), but it cannot delete individual variants.

Steps:

  1. Select Delete records from Shopify from the Actions drop-down.
  2. Click Upload file and enter the CSV file.

After the file has uploaded, the Transporter app begins deleting the objects.

Ready to start selling with Shopify?

Try it free