Product CSV converter for Shopify

Shopify's product importer wants its own template: exact column names, one row per variant, all rows of a product together, plain-number prices and weights in grams. The converter below builds that file from another platform's product export, on your device.

Convert a product file to Shopify

To Shopify

A product export from Etsy, Wix, Squarespace, BigCommerce, Square, Magento, PrestaShop, Ecwid, eBay, WooCommerce or Shopify. The platform is detected from the file.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

No file handy? or download the sample to look at it first.

The products in the sample are invented. It is converted on this device, the same way your own file would be.

Loading the converter...

Pick the platform you are moving from

What the Shopify file gets

  • The 61 columns of Shopify's current product template, as UTF-8 with no byte order mark.
  • One row per variant, with extra rows for additional images, and all rows of a product kept together.
  • Weights in whole grams, with your display unit kept.
  • Products with no options get the usual "Title" / "Default Title" option.
  • Products Shopify would reject (more than 3 options, more than 2,048 variants, repeated option combinations, a blank or negative price, or anything else the Shopify checker on this site finds) are left out of the file and listed on screen so you can fix them in the source.
  • Image paths that are not full web links are left out with a note, so the product itself still imports.
  • Files over Shopify's 15 MB limit are also offered as smaller parts, each product kept whole.

How to import it

  1. In Shopify admin, go to Products and click Import.
  2. Click Add file and choose shopify-products.csv.
  3. Leave "Publish new products to all sales channels" and the overwrite option as you need them. Overwrite replaces products that have the same URL handle.
  4. Click Upload and preview, look over the first product, then Import products. Shopify emails you when it finishes, including any rows it skipped.

Before you import everything

  • A few of Shopify's rules are our best reading rather than something Shopify states outright: that the 2,048 variant limit also applies to CSV imports, that decimal gram weights should be rounded, and that "Title" is the option name for products without options. Try a small file first.
  • Images are imported by Shopify downloading each link. Links that are private, slow or removed fail on Shopify's side, which no file check can see.
  • Inventory quantity in the file only applies to stores with a single location. With more than one location, set stock after import (or with Shopify's inventory CSV).
  • Import the file as it is. Opening it in Excel or Google Sheets and saving again can change prices, SKUs and accents.

Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.

Questions

How do I import products into Shopify from another platform?
Export your products from the old platform, convert the file on this page, then in Shopify admin go to Products, click Import and choose shopify-products.csv. Import a few products first and check variants, prices, stock and images.
Which platforms can I convert to Shopify from?
Etsy, Wix, Squarespace, WooCommerce, BigCommerce, Square, Magento, PrestaShop, Ecwid or eBay. Each one has its own converter page with export steps and a before and after sample.
Will the import definitely work?
Nobody can promise that from a file alone. The converter follows each importer's documented rules, leaves out products that would be rejected and tells you about them, and checks the Shopify file against Shopify's documented import rules before download. Import a few products first, look at them in your store, then import the rest.
Was this tested by importing into a live Shopify store?
No. It follows each platform's published export layout and Shopify's documented import rules, and every file is checked against those rules before download. Import a few products first and check them.
Does it move customers, orders or reviews?
No. Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.

Have a Shopify CSV already? Check it before importing.