Import the Converter's files into Shopify

The files written for Shopify

At the Export step, the Converter writes one CSV file per conversion, on your computer: comma separator, CRLF line endings, UTF-8 with BOM by default (Encoding setting in Settings). The suggested name is your file's name followed by _shopify, for example products-atelier_shopify.csv.

• Products: the columns of Shopify's product file (Handle, Title, Variant SKU…), one row per variant or image, under the same Handle. These are the column names of a Shopify export; Shopify's help now lists newer names and says it stays compatible with the older ones.
• Customers: the columns of Shopify's customer file (First Name, Email…). Accepts Email Marketing and Accepts SMS Marketing are no for every customer: no consent is carried over.
• Orders: the columns of Shopify's order export (Email, Lineitem name…), with the Name column empty. Shopify does not import them by CSV: see below.

According to its help, Shopify refuses a product or customer file larger than 15 MB. For a large catalogue, tick the split into files of at most 500 rows at the Export step: each file repeats the header row, and the rows of one Handle stay together. The split counts rows, not size: check the size of the _01.csv, _02.csv… files.

Import the products

1. In the Shopify admin, open Products, then click Import.
2. Click Add file and choose the file the Converter wrote (one split file at a time).
3. For a first import, leave Overwrite products with matching handles unticked.
4. Click Upload and continue, review the summary, then click Import products.

According to Shopify's help, an import cannot be cancelled once started, and a confirmation email is sent to you. Images are downloaded from their addresses during the import: keep the old store online until it ends (Images and image addresses).

Import the customers

1. In the Shopify admin, open Customers, then click Import.
2. Click Add file and choose the customer file.
3. Tick Overwrite existing customers that have the same email or phone number only to update customers already in the store.
4. Click Import customers.

According to Shopify's help, when several rows share an email address or a phone number, only the last one is imported; the Converter flags duplicate emails at the Review step. Passwords do not migrate to Shopify. Shopify asks you to invite your customers to create new ones.

Orders

The Converter writes an order file for Shopify, but Shopify's official help says that orders can't be imported to Shopify by using a CSV file, and points to a third-party migration app. If you choose one, first check that it reads this file. Each order's original number is in the Note Attributes column.

Shopify error messages

Check the result

• In Products, compare the number of products with your original store, then open a few products: price, weight, stock, variants, images.
• A product imported as hidden is only published once you make it available on your sales channels.
• In Customers, check a few addresses and the marketing subscription, no for everyone.
• The What will not transfer (Shopify limits) section of the Review step lists what the file does not contain.

If Shopify refuses a row

1. Note the message and the line number: it is the line in the imported file, not in your original file. Find the product by its Handle.
2. In History, click Start again, then Continue, and drop your original file again.
3. At the Review step, correct the value with Fix if the Converter flags this product; otherwise, correct it in your original file.
4. Export, then import the new file without ticking overwrite: according to Shopify's help, products whose handle already exists are then skipped.

If the Converter itself blocks the export, see Error blocking the export.