Shopify Store Products Exporter

Export every product from any public Shopify store or collection to CSV, Excel, or JSON. Titles, prices, compare-at prices, SKUs, variants, stock status, images, and tags. Free to run, no login, no API key, and no extension.

Up to 25,000 rows per export

Works on most public Shopify stores. No login, API key, or extension needed.

How to Export Products from a Shopify Store

Shopify stores show their products on collection and product pages but give visitors no way to download the catalog. Behind the scenes, every Shopify storefront publishes the same products as a public feed. This tool reads that feed page by page and turns it into a spreadsheet, one row per variant or one row per product.

It works on custom domains as well as .myshopify.com addresses, and on single collections. Nothing is installed and you don't sign in to the store.

Step-by-Step Guide

Step 1

Paste the store or collection link

Enter a store address such as allbirds.com, or a collection link such as https://store.com/collections/sale to export just that collection.

Step 2

Choose rows and click Export Products

Pick one row per variant (SKU-level prices and stock) or one row per product (price range and variant count). Set Max Rows if you only want a sample, or press Stop at any time.

Step 3

Download your file

Download CSV, Excel, or JSON. Downloads use credits (1 per 100 rows); a free account includes 5 credits a month.

What You Get

Variant mode gives one row per size, color, or option. Product mode gives one row per product with the lowest and highest price, a stock flag, the variant count, and all SKUs in one cell.

ColumnsWhat they hold
Product ID, Title, Product URLThe Shopify product ID, its name, and a link to the product page on the store.
Vendor, Product Type, TagsThe brand or supplier, the store's product type, and every tag on the product.
Variant ID, Variant Title, SKUOne row per size, color, or other option, with its SKU when the store fills it in.
Price, Compare At PriceThe current price and the crossed-out "was" price used for sales, in the store's currency.
AvailableIn stock or Sold out, as the storefront shows it. Exact inventory counts are not public.
Option 1-3, Weight (g)The option values (for example Size: 10, Color: Black) and the shipping weight.
Image URL, DescriptionThe variant or main product image, and the product description as plain text.
Published At, Updated AtWhen the product went live and when the store last changed it.

Honest Limits

  • Shopify stores only. Sites on WooCommerce, BigCommerce, Wix, or custom carts don't have this feed.
  • Public, published products only. No orders, customers, costs, or exact inventory counts.
  • Some large stores block automated catalog reads or turn the feed off; you get a clear message when that happens.
  • Prices are in the store's default currency, without a currency code, and don't include market-specific or logged-in pricing.
  • Up to 25,000 rows per export. For very large catalogs, export one collection at a time.

What People Use It For

  • Competitor price research: see a rival store's full price list, sale prices, and what is sold out.
  • Wholesale and dropshipping: pull a supplier's catalog with SKUs and images into a spreadsheet.
  • Product research: count products per type or vendor, and spot new launches by Published At.
  • Migrations and audits: snapshot a storefront's live catalog before a redesign or platform move.

Need This From a Site That Isn't Shopify, or Every Week?

This tool only reads Shopify's product feed. Lection's AI scraper works on any website: open the side panel on a product or category page, describe the data you want, and it builds the table, including on pages that need you to be logged in. Save it and Lection can refresh it into Google Sheets on a schedule, so a competitor's price changes land in your sheet every week. See how the AI scraper works.

Need this done for you, across many searches or every week? Tell us what you need.

Frequently Asked Questions

How do I export all products from a Shopify store?
Paste the store address (for example allbirds.com) above and click Export Products. The tool reads the store's public catalog 250 products at a time, then you download the result as CSV, Excel, or JSON. To export one collection, paste the collection link instead, such as https://store.com/collections/sale.
Can I scrape a Shopify store I don't own?
Yes, for public product data. Every Shopify storefront publishes its catalog at /products.json, the same data shoppers see on the product pages. The tool does not log in, cannot see orders, customers, or inventory counts, and only reads published products.
Do I need a Shopify API key, an app, or admin access?
No. You don't need an API key, a Shopify account, or the Lection extension. For your own store's full admin export (with cost and inventory), use Products > Export in your Shopify admin instead.
How do I know if a website is a Shopify store?
Paste it in and run the tool. If the site is not on Shopify, or the owner turned the public feed off, you get a clear message instead of a file. Many stores on custom domains (not .myshopify.com) are still Shopify stores.
Is there a limit on how many products I can export?
The tool loads up to 25,000 rows per export, or the Max Rows value you set. Loading and previewing is free. Downloads need a free Lection account and use credits: 1 credit per 100 rows, and the free plan includes 5 credits a month.
Why are some prices or SKUs missing?
The export shows exactly what the store publishes. Some stores leave SKUs empty, and prices are in the store's own currency without a currency code. Stock shows as In stock or Sold out because Shopify does not publish exact inventory counts.
Why did a store return an error?
A few large stores block automated catalog reads, some stores are password protected, and some disable the product feed. For those, Lection's AI scraper can read the product pages in your own browser instead.
Can I track a competitor's prices every week?
Yes. Export now and later and compare the files, or use Lection's AI scraper to send a store's product page into Google Sheets on a schedule so price changes show up automatically.

Related Resources

Scrape any site, every page, on a schedule.

Add to Chrome — free

This free tool is one ready-made template of Lection, an AI web scraper Chrome extension that extracts lists, tables and detail pages from any website. It can also scrape any website to Google Sheets on a schedule. Need a recurring data feed for your team or clients? We can set it up for you.