Export Products Tool for Shopify

What it does

Export Products pulls your Shopify products into a CSV or Excel file with one row per variant. Each row carries the variant’s own columns (SKU, options, price, cost, barcode, weight, inventory) plus the product-level columns (title, description, vendor, type, tags, status, SEO, collections, images) — product values are repeated on every row of the product, so the file sorts and filters cleanly in a spreadsheet.

You choose which products to export (by collection, or by title/vendor/type/tag/status filters) and which fields to include. The export runs in the background, and when it is ready you receive an email with a link to download the file.

When to use it

• You want a backup or snapshot of your catalog.
• You plan to bulk-edit products in a spreadsheet — content, pricing, weights, tags — and re-import with Import Products.
• You’re copying products to another store — the file references products by handle and variants by SKU, so it ports cleanly.
• You need a review sheet: which products are missing SEO fields, what’s in which collection, costs vs. prices, stock levels.

Before you start

• Your Shopify store must be connected to your account.
• Decide what to export. Pick a single collection, or use the filters (title, vendor, type, tag, status) — leave everything empty to export all products.
• Know where the file goes. The finished file is emailed to you as a download link, so make sure the email address is correct.

Step-by-step

How to read the file

Rows are grouped by Handle, one row per variant. Product-level values repeat on every row of the product.

A small example — one two-variant product and one single-variant product:

Handle	Title	Tags	Variant SKU	Option1 Name	Option1 Value	Variant Price
the-shirt	The Shirt	summer,sale	SHIRT-S	Size	Small	10.00
the-shirt	The Shirt	summer,sale	SHIRT-M	Size	Medium	12.00
the-hat	The Hat	summer	HAT-1			5.00

Product columns (repeated on every row)

Column	Notes
Product ID	The product’s Shopify ID. Export-only — the import matches variants by SKU.
Handle	The product’s handle — this is what groups rows together. Always exported.
Title	The product name.
Body (HTML)	The product description (HTML).
Vendor / Type	The product’s vendor and product type.
Tags	Comma separated.
Status	active, draft, or archived.
SEO Title / SEO Description	The search engine listing fields.
Collections	Comma separated titles of every collection the product is in.
Online Store URL	The product’s storefront address (blank for unpublished products). Export-only.
Created At / Updated At	Timestamps. Export-only.
Image Src – 1…10 / Image Alt Text – 1…10	The product’s first ten images and their alt text.

Variant columns (one row per variant)

Column	Notes
Variant ID	The variant’s Shopify ID. Export-only — the import matches by SKU.
Variant SKU	The variant’s SKU.
Option1–3 Name / Value	The product’s options (e.g. Size / Small). Blank on single-variant products with no options.
Variant Price / Variant Compare At Price	Prices.
Cost per item	The variant’s unit cost.
Variant Barcode	The barcode (ISBN, UPC, GTIN).
Variant Weight / Variant Weight Unit	The weight, with the unit written as g, kg, lb, or oz.
Variant Taxable / Variant Requires Shipping	TRUE / FALSE.
Variant Inventory Tracked	TRUE / FALSE — whether Shopify tracks this variant’s stock.
Variant Inventory Qty	The variant’s stock, totaled across all locations. (The import writes to a single location you pick.)
Variant Image	The variant’s assigned image, by web address.

Troubleshooting / FAQ