Store Product CSV Converter

About the Store Product CSV Converter

Moving a store means moving its catalogue, and retyping it is not an option. This converter opens a Shopify products export, a WooCommerce product CSV or an eBay listings report and writes it in Shopify’s or WooCommerce’s import layout: titles, descriptions (HTML kept or cleaned), vendors and brands, product types and categories, tags, options and variants (Shopify’s option rows become WooCommerce’s variable products and variations, and back), SKUs, barcodes, prices and compare-at prices, stock, weights and image addresses.

Both Shopify’s current and its older column names are read. Anything without an equivalent — metafields, market prices, a short description, cost per item — is listed with how many products hold it, never dropped silently, and a big catalogue is split into files the target accepts, without cutting a product in two. Orders and customers are not part of a products file and are not moved.

Without a pass the result is a free preview: the whole catalogue is converted, the counts and the list of what is not converted show in full, and the first rows of the new file show read-only; the converted file and the split files unlock with a Pro pass. Your files are read in this browser and never uploaded.

Common uses

• Moving a store from Shopify to WooCommerce, or from WooCommerce to Shopify, without retyping the products.
• Bringing eBay listings into a new web shop.
• Writing an old Shopify export again with Shopify’s current column names.
• Splitting a big catalogue into files the target platform accepts.

How products and variants move

• Shopify writes a product’s details on its first row, then one row per variant and one per extra image, all with the same URL handle; a product without options has Option1 name “Title” and Option1 value “Default Title”, and a product can have up to 3 options (Shopify’s help).
• WooCommerce writes a “simple” product on one row, or a “variable” product followed by its “variation” rows, which name their parent by SKU (or “id:” and its ID) in the Parent column; the options are “Attribute 1 name” and “Attribute 1 value(s)” and so on (WooCommerce’s CSV guide).
• eBay: the rows of one item number become the variants of one product, their option names and values read from the variation details (“Size:8|Colour:White”). eBay’s report columns are recognised by their usual names; choose any column the converter misses under “Columns, dates and numbers”.

Prices, stock and weights

• A compare-at price above the price (Shopify) is a sale: WooCommerce gets the compare-at price as its regular price and the price as its sale price, and back.
• Stock: Shopify’s inventory quantity is WooCommerce’s stock; “continue selling when out of stock” is “backorders allowed”. A product whose stock is not tracked stays untracked.
• Weights: Shopify keeps grams; WooCommerce keeps the unit your store is set to (kg, g, lbs or oz), which names its weight column — choose it before converting.
• Barcodes: a valid GTIN goes into Shopify’s barcode column with its type (gtin:…), anything else as a custom barcode; WooCommerce gets it in its “GTIN, UPC, EAN, or ISBN” column.

Categories, tags, images and status

• WooCommerce categories have levels (“Clothing > Tops”); Shopify has one product type and a category from its own list. By default the product type and the category’s last level swap places; you can send the categories to Shopify as tags instead, or leave them out.
• Tags move as they are. Images are moved as addresses: the target platform downloads each image from its address when it imports the file, so the old store must still be online.
• Shopify’s active products are published in WooCommerce; drafts and archived products become drafts, and the other way round.

Splitting big catalogues

• Shopify: “Your product CSV can't exceed 15 MB” (Shopify’s import guide), so a bigger file is split into parts below it, each with the column names and whole products only.
• WooCommerce: the largest upload is set by your store’s server, so you choose how many products go into each file.
• Several files download together as one ZIP; import them one after another.

Limitations

• MySmartCoPilot is not affiliated with or endorsed by Shopify, WooCommerce or eBay.
• The converter writes Shopify and WooCommerce files; it reads eBay listings but does not write eBay’s upload templates.
• Orders, customers, reviews, redirects and pages are not part of a products file; move them with the platforms’ own tools.
• Metafields and custom fields need a matching definition in the target store; they are listed rather than invented (WooCommerce can keep Shopify’s as custom fields if you choose).
• A product’s address changes with the platform: set up redirects from the old addresses after the move.

Privacy

On this device; its files download once

Your products files are read in this browser and never uploaded; only your settings are remembered on this device.