CatalogHop

eBay product export: convert it for another store

eBay's Active listings report (Seller Hub, Reports, Downloads) is a CSV of your current listings, with columns such as Item number, Title, Variation, Custom label (SKU), Available quantity, Start price and Current price. eBay does not say whether each variation gets a row of its own, so both layouts are read. It has no description, photo or weight columns.

Convert an eBay export

eBay to Shopify

Your eBay Active listings report 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 eBay

  1. In eBay, open Seller Hub and go to the Reports tab, then Downloads.
  2. Click Download report. Choose the source Listings and the type All active listings, then download. eBay shows a summary of the report's columns on the right before you download.
  3. Upload the CSV as it was downloaded. If you open it in Excel first, eBay says to format the Item number column as a number with 0 decimals before saving, or the 12-digit item numbers get rounded and variations can no longer be grouped.
  4. Do not use the Edit price and quantity template from the Uploads page. eBay lists it in Downloads under the same label, All active listings, but it is a different file, and the converter refuses it with a message.

What to know about eBay files

  • The report has no description, photos or weight. eBay's list of the report's columns has none of them, so every product is written without them and the converter says so. Add descriptions and photos in the new store, or the products import with a title, price and stock only.
  • eBay does not document how this report lays out variations, so the converter handles a listing row followed by variation rows, and variation rows alone. Rows with the same Item number are one listing. A row with a single combination in the Variation column, such as Size=M, becomes a variant with its own SKU, price, stock and barcode. The listing's own row, either blank in Variation or listing all the values the way eBay's templates write it (Size=Medium; Small), gives only the title, and its SKU becomes the WooCommerce parent SKU. A variation row with a blank Item number is added to the listing in the row above, and the converter names those rows. If a listing has only one row that lists several values, it is written as one product without options, and named.
  • eBay does not say how the Variation column is written in this report. The converter reads it the way eBay writes variations in its Seller Hub templates, Name=Value pairs separated by semicolons, such as Color=Blue;Size=M, so each name becomes an option. Any other value, or more than 3 option names, is kept as one option named Variation with the value as written, and the converter names those listings.
  • Fixed price listings: the Current price is written as the price, because it is what buyers pay now (eBay says it may include a sale). When the Start price is higher, it goes in Shopify's Compare-at price, or in WooCommerce's Regular price with the current price as the Sale price, and the converter names those listings so you can end the sale. A Current price above the Start price is written as it is and named. When Current price is blank, the Start price is used.
  • Auction-style listings become drafts, because a store has no bidding. They get the Buy It Now price, or the start price when there is none, and are named so you can set a price and publish them. Reserve prices, bids and watchers do not move.
  • Available quantity, the number left after sales, becomes tracked stock.
  • eBay category 1 name and eBay category 2 name are the last level of the eBay category, not a full path. WooCommerce files get both as categories; Shopify files get category 1 name as the product type (the Type column).
  • P:UPC, P:EAN and P:ISBN become the Shopify barcode, the first one filled in. "Does not apply" is skipped. WooCommerce's importer does not map barcodes on its own, and the converter says so.
  • Condition (New, Used and so on) has no column in a Shopify or WooCommerce product file. When a listing is not new, the converter names the conditions and how many listings have each, so you can put it in the title, description or a tag.
  • Not carried over, and named when the file has them: Item number, eBay Product ID (ePID), Listing site, sold quantity, views, watchers, bids, start and end dates, category numbers, reserve price and the trading card grading columns.
  • eBay's Unsold listings report and its upload templates (they have an Action column, and the price template an #INFO row) are refused with a message, so an ended listing or a template is not converted by mistake. That includes the Edit price and quantity template with its #INFO row and Action column deleted, recognised by its Relationship columns. An Orders report is not a listing export, and eBay gives no column list for it, so it is not recognised.
  • Built from eBay's Seller Hub Reports guides (the list of the Active listings report's columns and the upload templates guide). eBay publishes no sample report, and this was not verified against a real download. 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 eBay products to Shopify or WooCommerce?
Export your products from eBay 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.
Why do my eBay products have no photos or descriptions in Shopify?
eBay's Active listings report does not contain them. Its columns are listed in eBay's Seller Hub Reports guide, and there is no description, photo or weight column, so the converter cannot carry them over and says so. Add them in Shopify after import.
Why do my eBay products have no photos or descriptions in WooCommerce?
eBay's Active listings report does not contain them, so there is nothing to carry over. The converter says so on every file. Add them in WooCommerce after import.
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