How to Extract Shopify Product Variants and Pricing Data

Product variants are critical for e-commerce stores offering items in multiple sizes, colors, materials, or package options. While a product has a single title, it can contain dozens of unique variant combinations. Each variant has its own price, SKU, weight, stock quantity, and variant-specific image.

When scraping competitor data or backing up your catalog, a basic product scraper will only extract the main product details, missing the critical variant options. This guide outlines how to extract all product variant and pricing data from any Shopify store.

Understanding Shopify's Variant Data Structure

In Shopify's database, variants are children of the parent product. They are structured as a nested array containing:

• Variant ID: A unique numeric identifier.
• Option Values: E.g., `Option1` = "Red", `Option2` = "Medium".
• Pricing: The current active variant price and the `compare_at_price` (the original MSRP).
• SKU & Barcode: The manufacturer's product code.
• Variant Image: A specific image URL linked to that variant.

Method 1: Direct JSON Endpoint Query

You can access raw product data by querying Shopify's public product catalog JSON endpoints:

1. Append `/products.json?limit=250` to the competitor's root domain.
2. Press **Enter** to load a raw JSON feed containing the product and variant arrays.
3. While this includes variant records, it requires programming knowledge (like Python or Node.js) to parse the JSON and format it into a readable table.

Method 2: 1-Click Extraction via Shopify Product Exporter

To avoid coding, use **Shopify Product Exporter** to handle variant parsing automatically. The extension reads the storefront database and builds a clean variant list:

1. Navigate to the target Shopify store in Chrome.
2. Click the **Shopify Product Exporter** extension icon.
3. Click **Download Products**.
4. In the dashboard, export the data as an **Excel Workbook** (`.xlsx`). The extension creates a structured workbook with two tabs: * **Products Tab:** Displays main product details (titles, descriptions, handles). * **Variants Tab:** A dedicated spreadsheet displaying all individual variants, their pricing, SKUs, stock levels, and variant option values (Color, Size, etc.) mapped cleanly to their parent product handle!

Why Variant Pricing Data Matters

Analyzing variant data is useful for:

• Dynamic Pricing Strategies: Notice if competitors charge more for specific colors or larger package options.
• Supplier Sourcing Alignment: Match competitor SKUs directly with listings on AliExpress, CJ Dropshipping, or DHgate.
• Flawless Catalog Imports: When migrating stores, importing parent products without variants breaks the shopping cart experience. Having the full variant mapping prevents this.

Conclusion

Extracting variant tables is essential for any serious e-commerce competitor analysis. With tools like **Shopify Product Exporter**, you get a clean breakdown of product options and variant pricing automatically, saving you hours of manual formatting.