Merchant Center feed eligibility audit

Shopify Google Merchant Center Missing Products CSV Audit

Check why Shopify variants are missing from your Google Merchant Center feed. Audit required attributes, identify missing Brand, GTIN, MPN, Price, or Status per variant, and export a local eligibility worksheet for review.

Local browser scanSafe fixes onlyShopify-focused checks

Browser-side scan

Drop a Shopify product export CSV

-

No CSV selected

No CSV selectedUpload a Shopify product export to audit each variant's eligibility for a Google Merchant Center feed. Files are read locally in your browser and nothing is uploaded.
Private by default. Your Shopify product or variant CSV data stays in this browser session. The export applies only safe deterministic changes and leaves manual-review items in the findings list.

Google Merchant Center generally needs each variant to have a Brand (Vendor), a GTIN (Barcode), a non-blank Price, and an active or published status; MPN is optional but recommended. This audit runs locally in your browser with the File API, reading a Shopify product export with no data uploaded to a server. It scans each variant row for those fields, flags missing or blank required attributes, detects unpublished or inactive status, separates a missing MPN as an informational enrichment note, and exports an eligibility review worksheet showing which attribute barrier blocks each variant. The worksheet is for manual review only; it does not submit data to Google Merchant Center, call the Merchant Center or Google and YouTube APIs, or change any Shopify or Merchant Center data.

Import blockers

Common causes this scan checks

  • Variants have a blank Brand or Vendor value, which Google Merchant Center generally requires for feed eligibility.
  • Variants are missing a GTIN (Barcode), so Merchant Center cannot identify the product for the feed.
  • Products priced per variant do not always carry an individual variant price, leaving feed rows without a Price.
  • Variants are unpublished or marked inactive, which keeps them out of the Merchant Center feed even when other fields are filled.
  • An MPN column is missing or only product-level, so variant-specific MPN values are not captured for feed enrichment.

Workflow

How to use the cleaned CSV

  1. Upload a Shopify product export and confirm it includes Vendor (Brand), Variant Barcode, Variant Price, and a Published or Status column.
  2. Review the missing-Brand, missing-GTIN, blank-Price, and inactive-Status findings to see each variant's eligibility barrier.
  3. For variants with fixable gaps (blank Brand, Price, or GTIN), update the CSV in your catalog and re-export to recheck.
  4. Export the eligibility worksheet and use it to prioritize which variants or attributes to fix before your next Merchant Center feed sync.

Auto-fix policy

What the export can safely change

  • Detects Vendor/Brand, GTIN/Barcode, MPN, Price, and Published/Status columns from common Shopify export headers and aliases.
  • Flags missing or blank required attributes (Brand, GTIN, Price) and inactive status per variant row.
  • Treats a missing MPN as an informational enrichment note rather than a blocking error, so blockers stay clearly separated.
  • Records each variant's eligibility status and a semicolon-separated list of the missing attributes that block it.
  • Exports a local eligibility worksheet with variant identity, missing-attribute details, and a review note per row, without calling any APIs.

CSV example

CSV example: variant feed eligibility for Merchant Center products

The audit shows row 2 missing both Brand/Vendor and a GTIN, row 3 missing Price, and row 4 unpublished, listing each variant's missing attributes so a merchant can fill empty Vendor and Barcode cells, add the blank price, and republish before the next Merchant Center sync.

Before
Handle,Title,Vendor,Variant Barcode,Variant Price,Published,Google Shopping / MPN
widget-blue,Blue Widget,,,12.99,TRUE,MFR-2024-BLUE
widget-red,Red Widget,Brand Inc,RED-GTIN-001,,TRUE,
widget-green,Green Widget,Brand Inc,GREEN-GTIN-002,9.99,FALSE,MFR-2024-GRN
After
Handle,Title,Variant SKU,Vendor,Barcode,Price,Published,MPN,Eligibility status,Missing attributes,Source row
widget-blue,Blue Widget,,,,12.99,TRUE,MFR-2024-BLUE,Blocked,Brand/Vendor; GTIN,2
widget-red,Red Widget,,Brand Inc,RED-GTIN-001,,TRUE,,Blocked,Price,3
widget-green,Green Widget,,Brand Inc,GREEN-GTIN-002,9.99,FALSE,MFR-2024-GRN,Blocked,Status (unpublished),4

FAQ

Shopify CSV questions

Why are my Shopify products missing from Google Merchant Center even though I synced them?

Merchant Center generally needs each variant to have a Brand (Vendor), a valid GTIN, a Price, and an active status. Even when the product is published, an individual variant can be missing one of these and will not appear in the feed until it is filled. This audit shows you which one is missing per variant.

What is the difference between Brand and Vendor in a Shopify export?

In a Shopify product export the Brand is typically the Vendor column. This audit reads Vendor (and Brand or Manufacturer aliases) and flags a blank value as a missing Brand that Merchant Center expects.

Do I need an MPN if I already have a GTIN?

No. The GTIN (Barcode) is the primary identifier for Merchant Center. MPN is optional but recommended for product matching and deduplication, so the audit reports a missing MPN as informational, not as a blocking error.

Can I upload this worksheet straight to Google Merchant Center?

No. This tool produces a local CSV worksheet for manual review of missing attributes and status. You use it to fix your Shopify catalog or feed settings, then sync through Shopify's Google and YouTube channel or your own upload; the tool never submits data to Google.

What does Status mean in this audit?

Status reflects whether a variant is published or active in Shopify, read from the Published or Status column. Merchant Center will not show unpublished or inactive variants, so the audit flags any non-active status as a feed-blocking issue. If no status column is present, the audit notes that it assumes active and cannot verify it.

Related tools

Shopify Variant MPN Google Merchant Center Feed Audit

Audit Shopify variant MPN values for Google Merchant Center feed readiness, separate legacy product-level MPN from variant metafield MPN, match by SKU or Variant ID, and export a supplemental feed worksheet locally.

Shopify Variant Metafield CSV Importer

Plan Shopify variant metafield CSV imports by matching variant identity, checking metafield columns, and preparing safer export-ready update batches.

Shopify CSV Product Category Validator

Validate Shopify Product Category CSV values, taxonomy paths, category IDs, and preview-risk signals before bulk category imports silently drop.

Shopify CSV Validator

Check a Shopify product CSV before import so you can catch structure, encoding, image, price, and variant problems early.

Feedback

How is this tool working for you?

Found a bug, a false alarm, or a missing check? Tell me — a human reads every note.