How to get product ID and variant ID with bulk editor

Shopify Discussion

Topic summary

Users seek methods to export product IDs and variant IDs from Shopify, which the native bulk editor and standard product export don’t include by default.

Proposed Solutions:

  • Third-party apps: Excelify and EZ Exporter can export product/variant data including IDs (some offer free trials)
  • JSON API method: Access /admin/variants.json with parameters like ?fields=id,product-id,title&limit=250, then convert JSON output to CSV using online converters. Note: Shopify deprecated page-based pagination in favor of cursor-based pagination (API version 2019-07+)
  • PHP scripts: Custom code snippets provided to programmatically fetch product/variant IDs via Shopify API (requires API credentials and PHP server)
  • Built-in Analytics workaround: Navigate to Analytics > Reports > ABC Analysis by Product, customize columns to show IDs, then export
  • Command-line tools: shopify_id_export program combined with xsv for merging exports
  • Google Merchant export: Product IDs appear in the “id” field when exporting from Google Merchant Center

Limitations:

  • Analytics reports only show last 28 days of data
  • JSON method requires technical knowledge and handling pagination
  • Many users express frustration that this basic functionality isn’t natively available in Shopify’s standard export feature

The discussion remains active with users sharing various technical and non-technical approaches, though no single definitive solution exists without third-party tools or custom development.

Summarized with AI on October 25. AI used: claude-sonnet-4-5-20250929.
21

These were all helpful but not quite what I needed, which was everything from the typical export BUT with product IDs. What worked for me was combining the data

  1. Grabbing the admin/variants.json, downloading, converting to csv (just google json to csv there is a free converter)

  2. Typical full product export

  3. Bring both into Google Sheets and sort both by SKU (the best unique field that is in both exports from above), then combine the columns into one sheet, do a visual check to make sure it all lines up.