CatalogHop

Ecwid product export: convert it for another store

Ecwid's catalog export (Catalog, then Data Import & Export, then Export Catalog) is a CSV with a row for each product, each option value and each variation, marked in a column named type. The other columns have names such as product_name, product_sku and product_price.

Convert an Ecwid export

Ecwid to Shopify

Your Ecwid catalog export CSV.

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

Where is it going?

How to export from Ecwid

  1. In your Ecwid admin, go to Catalog, then Data Import & Export.
  2. In the Export data block, click Export Catalog. The CSV file downloads to your device. Ecwid says it holds all the details of all your products and categories.
  3. To export only some products, go to Catalog, then Products, tick them and click Export Selected. Or search, then click Export All Found.
  4. Ecwid lists catalog export on the Venture, Business and Unlimited plans.
  5. Note your store's weight unit. Ecwid writes weights without a unit, so this page asks you for it before you download.
  6. Upload the file as it was downloaded. Ecwid separates columns with commas, or with semicolons when your price format uses a decimal comma. Both are read.

What to know about Ecwid files

  • One file holds several kinds of rows, named in the type column: product, product_option (one row for each option value), product_variation (one row for each variation), and category, product_file, site_redirect or customer rows. Only products, options and variations are converted. The other rows are skipped and counted.
  • Every combination of a product's options becomes a variant, because Shopify and WooCommerce need one for each. A variation row gives its combination its own SKU, price, compare-to price, stock, weight, UPC and image. A combination with no variation row gets the product price plus all its option price modifiers, and the converter lists those combinations with their prices for you to check (the first 5, then a count). If that comes to zero or less, the product price is used instead and the combination is named, so nothing is sold for free by mistake. Ecwid does not document how a percent modifier combines with others; the converter takes the percent of the product price.
  • Ecwid keeps stock for the whole product unless a combination has its own variation. Combinations with no variation row are written without stock tracking, with a note, so set their stock in the new store.
  • Options made from drop-downs, radio buttons, swatches and sizes become variants. Checkboxes (the buyer may pick several) and input fields such as text, date and file upload are not variants, so they are named and not carried over.
  • product_is_available true, yes, 1 or on becomes active, and false, no, 0 or off becomes a draft. A blank value also becomes a draft, as Ecwid itself creates such a product as disabled. Any other value becomes a draft and is quoted in a note.
  • Stock: product_quantity is used when product_is_inventory_tracked is true. False or blank means unlimited stock in Ecwid, so stock is not tracked. ALLOW_PREORDER as the out-of-stock behaviour becomes continue selling when out of stock.
  • product_compare_to_price, the price before a sale, becomes the compare-at price when it is higher than the price.
  • Categories are paths such as Kitchen/Cups in product_category_1, product_category_2 and so on, and the first is the main one. They become Kitchen > Cups. WooCommerce files get every category; Shopify files get the last level of the first category as the product type (the Type column).
  • The main image and the gallery images move in the order Ecwid numbers them, with their alt text. Brands become the Shopify vendor and UPC codes the Shopify barcode. WooCommerce's importer has no column for either, and the converter says so.
  • Prices and weights in a semicolon file use a decimal comma, as Ecwid writes them. The converter reads 12,50 as 12.50 and says so once.
  • Not carried over, and named when the file has them: translations, product attributes, videos, wholesale price tiers, subscriptions, ribbons and subtitles, related products, dimensions, shipping and tax settings, and the storefront URL, so redirects from old product links are not made.
  • A customers or redirects export from Ecwid is refused with a message, so the wrong file is not converted by mistake. Ecwid's guide to exporting customers names no columns, so the customers check uses the customer column names from Ecwid's import column list; it was inferred from that list and not verified against a real customers export. Orders exports have no product columns and are not recognised.
  • Stores that signed up before 24.05.2023 may still have Ecwid's older (legacy) product export. Ecwid documents only some of its column names and says it does not export variations, so the converter refuses it with a message.
  • Built from Ecwid's Help Center (the list of supported CSV columns, the format guidelines and the export guide). Ecwid publishes no sample export file, and this was not verified against a real export. It was not tested by importing into a live store.

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 move my Ecwid products to Shopify or WooCommerce?
Export your products from Ecwid as a CSV with the steps on this page, drop the file into the converter and pick Shopify or WooCommerce. The file is converted in your browser, and you download a CSV in that importer's layout. Import a few products first and check them before importing the rest.
Do my Ecwid variations move to Shopify?
Yes. Every combination of a product's options becomes a Shopify variant. A combination with a variation row in the Ecwid export keeps its own SKU, price, stock and image. A combination without one gets the product price plus the option price modifiers and no stock tracking, and the converter lists those combinations with their prices for you to check.
Do my Ecwid variations move to WooCommerce?
Yes. Each product with options becomes a variable product, with one variation for every combination. Variation rows in the Ecwid export keep their own SKU, price, stock and image; other combinations get the product price plus the option price modifiers.
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.
Is my file uploaded anywhere?
No. The page reads the file with your browser and converts it there. The only thing the site records is an anonymous count: which converter was used, a rough row count, and whether it worked. The privacy page lists every field.

Sources