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:
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|
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:
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.
- From your Shopify admin, click Settings > Notifications.
- 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.
- In the Transporter app, make sure that Upload file is enabled for the Action.
- 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)||
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.
- Select Delete records from Shopify from the Actions drop-down.
- Click Upload file and enter the CSV file.
After the file has uploaded, the Transporter app begins deleting the objects.