Google Merchant Center Supplemental Feeds: Fixing Feed Errors at Scale (2026 Guide)

Your product feed is not just a spreadsheet.

It is the engine behind Shopping campaigns.

It tells Google what you sell.

It tells Google when to show your products.

It tells Google which searches are relevant.

It shapes your Shopping visibility.

It shapes Performance Max.

It shapes free listings.

It shapes product approvals.

It shapes how your products appear.

And in ecommerce, feed quality is often the difference between growth and waste.

The problem is simple.

Your main product feed usually comes from the website.

Shopify.

WooCommerce.

Magento.

BigCommerce.

A custom CMS.

An ERP.

A product information management system.

That feed is the source of truth.

It is useful.

But it can be rigid.

If you change a product title in the website backend, it may change on the storefront.

That is not always what you want.

A product title that looks good on the website may be poor for Shopping.

Your website might say:

Legacy Chair

But Google Shopping may need:

Mid-Century Modern Dining Chair - Grey Walnut

Your developer may be busy.

Your ecommerce team may not want to change the live product title.

Your platform may not support the extra fields you need.

Your feed may be missing custom labels.

Your product titles may be too generic.

Your sale data may need quick edits.

Your disapprovals may need urgent fixes.

This is where Supplemental Feeds come in.

Google now often calls them supplemental data sources in Merchant Center.

They are additional data sources used to enhance or override information in your primary product data source. (Google Merchant Center Help)

Think of them as an overlay.

The primary feed remains the base.

The supplemental feed adds, improves or replaces specific attributes.

For product ID 123, the website might send one title.

Your supplemental feed can send a better title for Shopping.

The website stays the same.

Google receives the improved product data.

That is why supplemental feeds are a secret weapon for Shopping optimisation.

In this "Mega-Authority" guide, we cover:

1. The Use Cases: Titles, custom labels, missing data and promotions.
2. The Setup: Connecting a Google Sheet.
3. The Rules: How matching and merging work.
4. Bulk Edits: Using formulas to optimise thousands of products.

The goal is simple.

Do not wait weeks for a developer when a clean feed overlay can solve the problem today.

---

Part 1: Top 3 Use Cases

Supplemental feeds are useful when you need to improve product data without changing the website source.

They are especially useful for advertisers managing Shopping, Performance Max or free listings.

1. Title Optimisation

Product titles matter.

They help Google understand what the product is.

They also help users decide whether to click.

A weak title can limit visibility.

A vague title can attract the wrong search terms.

A strong title can improve relevance.

Example:

Website title:

Legacy Chair

Shopping title:

Mid-Century Modern Dining Chair - Grey Walnut

The website title may be fine for existing customers who browse by collection.

But Google needs more context.

A Shopping title should usually include:

1. Product type.
2. Brand where relevant.
3. Colour.
4. Material.
5. Size.
6. Gender where relevant.
7. Use case.
8. Key attribute.
9. Variant.
10. Style.

Example for apparel:

Women's Linen Shirt - White - Relaxed Fit

Example for tea:

Loose Leaf Earl Grey Tea - 100g Pouch - Bergamot Black Tea

Example for furniture:

Oak Dining Table - 6 Seater - Natural Finish

A supplemental feed lets you rewrite titles for Google without changing the customer-facing product name on the site.

2. Custom Labels

Custom labels are one of the most useful feed attributes for Shopping and PMax management.

They let you group products for bidding, reporting and campaign structure.

Examples:

custom_label_0 = High Margin
custom_label_1 = Best Seller
custom_label_2 = Seasonal
custom_label_3 = Clearance
custom_label_4 = Low Stock

You can use custom labels to segment products by:

1. Margin.
2. Season.
3. Stock level.
4. Bestseller status.
5. Price tier.
6. Product category.
7. Promotion status.
8. New arrival.
9. Clearance.
10. Brand priority.

This is powerful because not all products deserve the same budget.

A £20 product with 10% margin should not be treated the same as a £90 product with 60% margin.

A bestseller should not be treated the same as a product that never sells.

A clearance product should not be pushed with the same ROAS target as a premium product.

Supplemental feeds make custom labels easy to manage in bulk.

3. Missing or Incorrect Product Data

You can use supplemental feeds to add or correct attributes.

Common examples:

1. GTIN.
2. MPN.
3. Brand.
4. Product type.
5. Colour.
6. Size.
7. Material.
8. Gender.
9. Age group.
10. Custom labels.
11. Sale price.
12. Ads redirect.
13. Excluded destinations.
14. Additional image links.
15. Product highlights where supported.

Always check the official product data specification before making changes, because some attributes are required only in certain categories, and formatting matters. Google’s product data specification explains how to format product information for Merchant Center and prevent disapprovals or display issues. (Google Merchant Center Help)

A supplemental feed is not a licence to guess.

If the GTIN is wrong, do not invent one.

If the brand is wrong, do not fake it.

If the product condition is wrong, fix it truthfully.

Merchant Center data must be accurate.

Bad product data can cause disapprovals.

Worse, it can damage trust.

---

Part 2: Execution - Creating the Feed

The easiest way to start is with Google Sheets.

This gives you a simple, editable feed overlay.

Step 1: Download Product IDs

Before building anything, download your current primary feed or product list.

You need the exact product IDs.

Not the SKU you wish Google used.

Not the Shopify product ID in another format.

The exact id Google receives.

Example IDs might look like:

12345

or:

shopify_GB_123456789_987654321

or:

SKU-RED-100G

They must match.

If the ID does not match, the supplemental data will not apply.

Step 2: Create the Google Sheet

Open Google Sheets.

Row 1 should contain attribute names.

Example:

id | title | custom_label_0 | custom_label_1

Then add rows:

12345 | Mid-Century Modern Dining Chair - Grey Walnut | High Margin | Best Seller
12346 | Oak Dining Table - 6 Seater - Natural Finish | High Margin | Core Range
12347 | Loose Leaf Earl Grey Tea - 100g Pouch | Tea | Best Seller

Keep it clean.

Do not use merged cells.

Do not add notes above the header row.

Do not add inconsistent formatting.

Do not leave random formulas that break on refresh.

Step 3: Add Supplemental Data Source

In Merchant Center, the interface may vary depending on whether you are using Merchant Center Next or older views.

The general process is:

1. Go to Merchant Center.
2. Go to Products or Data sources.
3. Find Supplemental data sources.
4. Click Add supplemental data source.
5. Choose Google Sheets or upload a file.
6. Name it clearly.
7. Select the primary source it should connect to.
8. Confirm the matching attribute.
9. Fetch or process the feed.
10. Review results.

Google’s custom data source matching documentation explains that when creating a supplemental data source, you choose how to set up the source, select a common attribute to join it to your primary source and then select the primary data source to join it with. (Google Merchant Center Help)

Step 4: Fetch and Review

After uploading or linking the sheet:

1. Fetch now.
2. Wait for processing.
3. Review diagnostics.
4. Check product details.
5. Confirm the updated values appear.
6. Check affected item count.
7. Fix errors.
8. Re-fetch if needed.

Do not assume it worked.

Check.

Step 5: Build a Refresh Schedule

If using Google Sheets, set a refresh schedule that matches your use case.

For title updates:

Daily may be enough.

For sale price overrides:

Every few hours may be better.

For custom labels:

Daily or weekly may be fine.

Do not over-refresh without need.

But do not leave promotional data stale.

---

Part 3: The Matching Logic

Supplemental feeds usually work by matching a field in the supplemental source to a field in the primary source.

The standard match is product ID.

Standard ID Matching

Google looks for the id column.

If the ID exists in both the primary feed and supplemental feed, Google can apply the supplemental values for the attributes included.

Example:

Primary feed:

Supplemental feed:

Result:

Product 12345 receives the updated title and custom label.

Product 12346 stays unchanged.

Exact Match Matters

Be careful.

These are not the same:

12345

012345

shopify_GB_12345

Shopify_GB_12345

If the ID format differs, the match can fail.

Always copy IDs from Merchant Center.

Do not rebuild them from memory.

Custom Data Source Matching

Google also supports custom data source matching.

That means you can join a supplemental source to the primary source using another shared attribute, not only id.

For example, you might match on:

1. Brand.
2. Product type.
3. Custom attribute.
4. Another shared field.

Google’s documentation gives an example where a supplemental data source uses the brand attribute rather than id to add custom labels to all products from that brand. It also states there is a 30,000-row limit for supplemental data sources joined to the primary source using custom matching. (Google Merchant Center Help)

This can be useful for bulk logic.

Example:

If all products with brand Brand A should receive:

custom_label_0 = SALE

You may not need a row for every product.

But use this carefully.

Custom matching is powerful.

It can also apply changes more broadly than intended.

For precise product-level edits, use ID matching.

---

Part 4: Bulk Intelligence (Excel Formulas)

Supplemental feeds are not just for manual edits.

They are for bulk intelligence.

A Google Sheet can become your feed optimisation layer.

Formula 1: Build Better Product Titles

Example columns:

brand | product_type | colour | size | material

Formula:

=CONCATENATE(A2, " ", B2, " - ", C2, " - ", D2, " - ", E2)

Or:

=TEXTJOIN(" - ", TRUE, A2, B2, C2, D2, E2)

Result:

Muave Loose Leaf Tea - Earl Grey - 100g - Black Tea

This gives Google more context.

Formula 2: Create Margin Labels

If you have cost and price data:

=IF((Price-Cost)/Price>0.5,"High Margin","Low Margin")

Then upload as:

custom_label_0

This lets you segment campaigns by profitability.

Formula 3: Create Price Tiers

=IF(Price>100,"Premium",IF(Price>50,"Mid Tier","Entry"))

Upload as:

custom_label_1

This helps reporting and bidding.

Formula 4: Create Seasonal Labels

=IF(ISNUMBER(SEARCH("christmas",LOWER(title))),"Christmas","Evergreen")

Upload as:

custom_label_2

Useful for seasonal PMax asset groups and Shopping segmentation.

Formula 5: Bestseller Labels

If units sold last 30 days are available:

=IF(UnitsSold30D>50,"Best Seller","Standard")

Upload as:

custom_label_3

This helps push proven products.

Formula 6: Stock Priority

=IF(Stock<5,"Low Stock",IF(Stock>50,"High Stock","Normal Stock"))

Upload as:

custom_label_4

This helps avoid pushing products that are about to sell out.

Important: Paste Values

If your formulas rely on other sheets or temporary data, paste values before final feed upload where appropriate.

Why?

Because broken formulas can break the feed.

Keep the production supplemental sheet clean.

Use a working sheet for formulas.

Use a final export sheet for Merchant Center.

---

Part 5: Summary & Checklist

Supplemental feeds are one of the fastest ways to improve Google Shopping and PMax data.

They let you fix product information without waiting for website changes.

They let you add custom labels.

They let you improve titles.

They let you repair missing attributes.

They let you run controlled feed experiments.

Your Action Plan:

1. Download your primary feed to get exact product IDs.
2. Identify products with generic titles.
3. Create a supplemental feed to add richer Shopping titles.
4. Upload and check diagnostics after processing.

Do not wait for the dev team when the data can be overlaid safely.

Here is the deeper checklist:

1. Export your product IDs from Merchant Center.
2. Choose one use case first.
3. Create a Google Sheet with correct headers.
4. Match IDs exactly.
5. Add only the attributes you need.
6. Fetch the feed.
7. Check affected products.
8. Review diagnostics.
9. Document the feed purpose.
10. Set an appropriate refresh schedule.
11. Create custom labels for segmentation.
12. Test title changes on a subset first.
13. Avoid overwriting good data with weak data.
14. Review performance after 2 to 4 weeks.
15. Remove stale promotional overrides.

A supplemental feed is not a shortcut for bad data management.

It is a controlled way to improve feed quality faster.

---

The "Layer" Concept — What a Supplemental Feed Actually Is

Think of your primary feed as the foundation layer.

It comes from your store.

It contains the base product data.

The supplemental feed is an overlay.

It does not replace the whole building.

It updates specific rooms.

More technically:

Your primary feed sends the base attributes.

Your supplemental feed supplies additional or improved attributes for matching products.

It is similar to a controlled override.

Your website may keep:

Legacy Chair

Merchant Center may receive:

Mid-Century Modern Dining Chair - Grey Walnut

Your website stays clean.

Your Shopping feed becomes richer.

That is the value.

What It Can Help With

Supplemental feeds can help with:

1. Titles.
2. Descriptions.
3. Custom labels.
4. Sale price.
5. Ads redirects.
6. Additional image links.
7. Missing identifiers where accurate.
8. Product highlights where supported.
9. Excluded destinations.
10. Promotion-related attributes where appropriate.

Always check attribute eligibility.

Do not assume every attribute can be overlaid in every context.

What It Should Not Be Used For

Do not use supplemental feeds to:

1. Misrepresent products.
2. Invent GTINs.
3. Hide shipping costs.
4. Claim false discounts.
5. Add misleading brands.
6. Fake condition.
7. Override stock in a way that conflicts with reality.
8. Mask policy violations.
9. Create titles that do not match the product.
10. Push products that should not be advertised.

Google product data must match the product and landing page.

Accuracy matters.

Supplemental Feed Use Case — Promotion Overrides

A common reason to use a supplemental feed is promotion control.

Example:

Your dev team publishes the primary feed from Shopify every 24 hours.

A flash sale starts tonight.

You need sale prices live in Merchant Center.

You do not want to change every product manually in the store.

A supplemental feed can help.

Setup

Create a Google Sheet with:

id | sale_price | sale_price_effective_date

Example:

12345 | 79.99 GBP | 2026-07-01T00:00+0100/2026-07-03T23:59+0100

Then:

1. Link it as a supplemental feed.
2. Match by ID.
3. Fetch before the sale starts.
4. Verify products.
5. Monitor diagnostics.
6. Remove or expire the sale data after the sale.

This gives you control without editing the storefront.

Warning

Sale price must be real.

The landing page must show the sale price.

The timing must match.

Do not use sale attributes to fake discounts.

That can create disapprovals and trust issues.

Feed Rules vs Supplemental Feeds — The Decision Tree

Both tools can modify product data without changing the source website.

But they are not the same.

Use Feed Rules When:

You need simple transformation logic inside Merchant Center.

Examples:

1. If title is missing, use product type.
2. Append brand to title.
3. Set shipping label based on price.
4. Map one field to another.
5. Clean a repeated value.
6. Use simple conditional logic.

Feed rules are good for simple internal logic.

They do not require a separate spreadsheet.

Use Supplemental Feeds When:

You need external, structured, or business-specific data.

Examples:

1. Override 1,000 product titles.
2. Add custom labels based on margin.
3. Add GTINs from a supplier file.
4. Upload promotional pricing.
5. Add business priority labels.
6. Add stock movement labels.
7. Use spreadsheet formulas.
8. Use custom matching.
9. Add data from finance or merchandising.
10. Manage seasonal campaign labels.

Rule of thumb:

Single-attribute transformation = Feed Rules
External or multi-attribute data = Supplemental Feed

Use Both Together

Advanced accounts often use both.

Example:

1. Primary feed from Shopify.
2. Feed rule cleans size formatting.
3. Supplemental feed adds custom labels.
4. Supplemental feed overrides weak titles.
5. Feed rule maps product type into a better taxonomy.
6. Supplemental feed adds sale price data for promotions.

The goal is clean final product data.

Not loyalty to one method.

Title Optimisation Framework

Product title optimisation is one of the highest-impact feed projects.

A good Shopping title should describe the product in the language users search.

Use this order as a starting point.

Apparel

Brand + Gender + Product Type + Key Attribute + Colour + Size

Example:

Nike Men's Running Shoes - Lightweight - Black - Size 10

Furniture

Material + Product Type + Style + Size + Colour

Example:

Oak Dining Table - 6 Seater - Scandinavian Style - Natural Finish

Tea and Food

Product Type + Flavour/Variant + Pack Size + Key Attribute

Example:

Loose Leaf Earl Grey Tea - 100g Pouch - Bergamot Black Tea

Electronics

Brand + Model + Product Type + Key Spec + Colour

Example:

Sony WH-1000XM5 Wireless Headphones - Noise Cancelling - Black

Beauty

Brand + Product Type + Benefit + Size + Shade

Example:

Hydrating Face Serum - Vitamin C - 30ml

Rules

1. Put the most important terms early.
2. Avoid keyword stuffing.
3. Use accurate attributes.
4. Include variant details.
5. Match the landing page.
6. Do not add fake claims.
7. Keep titles readable.
8. Avoid all caps.
9. Do not include promotional text unless allowed.
10. Test changes.

Title optimisation is not about cramming every keyword into the feed.

It is about clarity.

Custom Labels Strategy

Custom labels turn feed data into campaign strategy.

Use all five labels with purpose.

Example structure:

This helps you build smarter Shopping and PMax structures.

Example:

1. High margin products get more budget.
2. Low stock products get limited spend.
3. Clearance products get their own asset group.
4. Premium products get stronger creative.
5. Bestsellers get a dedicated campaign.

Without custom labels, all products look equal.

They are not equal.

Common Mistakes

1. Wrong ID Format

The most common failure.

The supplemental feed processes, but nothing changes.

Why?

The IDs do not match.

Check exact ID format.

2. Bad Headers

Attribute names must match valid product data attributes.

Use:

custom_label_0

Not:

Custom Label

Use:

sale_price

Not:

Sale

3. Overwriting Good Data

Do not replace a strong title with a weaker formula-generated one.

Test first.

4. Leaving Promotions Live

Old sale prices can create errors.

Use effective dates where appropriate.

Review after promotions end.

5. Editing the Live Sheet Without Controls

One accidental paste can affect thousands of products.

Use:

1. Protected ranges.
2. Backup tabs.
3. Change logs.
4. Limited editors.
5. Version history.

6. Inventing Product Identifiers

Do not make up GTINs.

If you do not know the correct identifier, fix the source data properly.

7. No Performance Review

Feed changes should be measured.

Track:

1. Impressions.
2. Clicks.
3. CTR.
4. CPC.
5. Conversions.
6. Conversion value.
7. ROAS.
8. Search term relevance.
9. Product approval rate.
10. PMax asset group performance.

Final Rule

A primary feed is the source.

A supplemental feed is the control layer.

Use it to improve data quickly.

Use it to add business logic.

Use it to segment products.

Use it to fix errors.

Use it to test title improvements.

But keep it accurate.

Keep it documented.

Keep it clean.

The better your product data, the better Google can match your products to the right searches.

And in Shopping, better matching is the whole game.