DEV Community

王磊
王磊

Posted on

Check Variant MPNs Before Sending a Shopify Feed

When variant-level MPNs do not show up in Google Merchant Center, I would not start by editing every product again. The safer first step is to prove where the value disappears.

A practical checklist:

  1. Export the Shopify product data you use as the source of truth.
  2. Keep the variant identity columns together: Handle, Variant SKU, barcode or GTIN, option values, and any Google or app-specific MPN field you maintain.
  3. Pick a few affected products with multiple variants and compare each variant row against the item IDs shown in Merchant Center.
  4. Separate three cases: MPN is missing in Shopify, MPN exists in Shopify but is not submitted, or Merchant Center receives it but groups the item differently.
  5. Only after that, decide whether a supplemental feed is enough or whether the product data needs cleanup first.

The main mistake is treating a parent product as the unit of review. For feed problems, the variant row is usually the unit that matters. If the same product has ten sizes or colors, one clean parent-level value does not prove that every submitted item has the right manufacturer part number.

I keep this kind of check in a spreadsheet-friendly format: one row per variant, one column for the Shopify-side value, one for the Merchant Center-side value, and a status column for missing, mismatch, duplicate, or ready. That makes it much easier to hand the issue to a feed app, a developer, or a supplemental-feed workflow without guessing.

If you want a browser-side worksheet for that comparison, I use this local variant MPN audit as a starting point: https://shopify-csv.aivismonitor.com/shopify-google-mpn-variant-feed-audit

The useful output is not just a cleaned value. It is a short list of variants where the identifier story is incomplete, so you can fix the right rows before another feed sync.

Top comments (0)