Skip to main content

How to Export a List of My Products

You can export your products, or just your product variations, to a CSV file.

Start an export​

  1. Navigate to Products in the left sidebar.
  2. Click Export Product. A menu opens with two options:
    • Products - one row per product
    • Product Variations - one row per variation of your variable products
  3. Choose one. You'll see "Product CSV export initiated. You can view the export list in the product export page." and be taken to the CSV Exports page.

Download your export​

  1. Go to Products > CSV Exports (you're taken here automatically after starting an export).
  2. Each export is listed by the date and time it was started, with a Download column.
  3. While an export is still being prepared, its row shows "pending...". If it fails it shows "failed...".
  4. When it's finished, click Download to save the file.
note

The CSV Exports list doesn't say whether an export is a Products or a Variations file, so keep track of the time you started each one. The downloaded file name has no ".csv" ending, so add .csv if your computer doesn't open it in a spreadsheet.

What's included​

Exports include all of your products, including draft, disabled and trashed ones, and add-ons. There's no filter, so use your spreadsheet to remove rows you don't want. If you have no products, no export is created even though the message says it started.

Products export​

The columns are: name, description, shortDescription, featuredImage, images, sku, type, price, quantity, stockStatus, status, trackInventory, shippingCost, shippingWeight, shippingLength, shippingWidth, shippingHeight, taxable, taxAmount, incTax, syncId and isCustomisable. Storefronts and locations are included for products that have them. Images are separated by commas.

Product Variations export​

The columns are: parentProductIdentifier (the parent product's name, or its SKU, sync ID or ID if it has no name), sku, price, qty, stockStatus, syncId and attributePair. The attributePair column lists the variation's options, for example Size:Large; Colour:Red.

Products with no variations don't appear in this file.

Using an export to update your products​

The export uses the same columns that the importer expects, so you can edit the file and import it again. See How to import my products from a CSV.