Back to Blog
ShopifyData ExtractionChrome Extensions

Shopify Product Exporter Not Working? Check These Six Things

Diagnose empty exports, missing products, interrupted captures, and damaged spreadsheet values before repeating the same run.

Anas Nadeem
4 min read

Your Shopify export finishes with fewer products than expected. Clicking the button again gives you another file, but no explanation.

Before retrying, identify the symptom. An empty response, a partial capture, and a spreadsheet that rounded an ID need different fixes. This checklist applies to evaluating a catalog export, with specific steps for Catalog Prep.

1. Check which catalog you requested

A collection is not automatically the whole store, even when its title is "All Products." A product page, a collection feed, and the public website feed can describe different sets of records.

Record the exact source URL and selected scope before comparing totals. Compare product counts with product counts, then variant counts with variant counts. A shirt with four sizes can produce four CSV rows while remaining one product.

Catalog Prep presents website, collection, and product choices separately. Use the relevant Get data action and check the source scope in the result and manifest. The collection guide explains how to avoid mixing those views.

2. Distinguish blocked access from an empty catalog

A password page, access challenge, HTTP denial, or rate limit is a source-access result. It cannot establish that the store has no products.

Catalog Prep labels blocked or limited results. It stops on source denial instead of reporting a successful empty catalog. Inspect the result status and warnings before importing a zero-row file into another system.

Return to a supported public storefront, confirm that the active page belongs to the intended store, and use a permitted source. Repeatedly retrying a denied endpoint does not validate the catalog.

3. Check the run limit and the remaining allowance

The extension's Free plan includes 100 captured products per UTC calendar month in the browser profile. Every plan also has 500-product and 2,500-variant operational bounds per run. A large product with many variants can affect which bound is reached first.

Look at the status and manifest rather than assuming Pro means a complete store of any size. Pro removes the monthly product quota while retaining the operational bounds.

Start with a smaller relevant collection. If you need a larger configurable or repeatable workflow, assess the companion Apify actor, which has separate settings and billing. Neither workflow guarantees access to every public storefront.

4. Check whether capture was interrupted

Catalog Prep collects while its popup stays open. Closing it can interrupt an in-flight run. Reopen the extension on the same storefront page and use Resume capture when saved progress is available.

Download the completed result before starting a different scope on that active page. The latest capture replaces the previous saved capture there.

Resuming saved progress and starting another capture are different actions. A new capture counts newly collected products again against the Free allowance. Re-downloading saved files does not. Clearing a capture does not restore used monthly allowance.

5. Inspect the file before blaming extraction

Did the source ID change, or did the spreadsheet change how it displays the value?

Opening a CSV directly can strip leading zeros, interpret dates, or round long identifiers. Use Catalog Prep's text-typed catalog.xlsx for inspection, or import CSV columns explicitly as text. Keep the original file untouched.

Likewise, a URL in an image column is an image reference rather than a missing binary download. The image table and normalized JSON help you check associations without relying on spreadsheet previews.

The SKU, variant, and image checklist covers these checks in detail.

6. Check whether the field exists in the public source

A public source may omit SKU, barcode, currency, or a variant-specific image. Missing values should remain missing. Product titles and collection names are insufficient evidence to invent the absent fields.

Store metadata can establish feed currency when available. A displayed page currency is a separate observation, and Catalog Prep does not convert prices. Public availability also does not reveal actual stock quantity.

Inspect a few source products and the export's status fields. If the source does not expose the required information, use an authorized source that does rather than assuming a different exporter can reconstruct it.

Keep a useful support record

Save the store URL, scope, capture time, product and variant counts, status, and one example of the mismatch. Include the manifest and a small redacted row sample if needed; omit license keys and sensitive business material.

That evidence helps distinguish a reproducible tool defect from a scope or source difference. It is also useful if you are evaluating a replacement for another exporter.

For a fresh test, install Catalog Prep, capture a small collection, and inspect the ZIP alongside the storefront. Use the getting-started guide for the full workflow.