What is product feed management, and when does a spreadsheet stop being enough?

Product feed management is the ongoing work of keeping the product data you send to shopping channels complete, correct and in each channel’s format: mapping your fields to theirs, filling gaps such as categories and identifiers, fixing what Merchant Center flags, and keeping it in sync as the catalog changes. A small catalog can manage with a platform app and a spreadsheet; a dedicated tool pays off as products, channels and repeated edits multiply.

What this comes down to

  • Feed management is four jobs: mapping your fields to the channel’s, filling gaps, fixing flagged issues and keeping data in sync.
  • Merchant Center has attribute rules built in (they used to be called feed rules) once the Advanced data source management add-on is on.
  • A spreadsheet is enough while the catalog is small and changes rarely; rules and tools pay off when the same edit repeats across many rows.
  • A feed tool reformats values; it cannot know the right category or GTIN unless someone has decided it first.

SellerSort Team · Updated

The four jobs inside feed management

  1. Mapping. Your platform calls it Colour or Vendor; Google wants color and brand. Someone has to decide which of your fields feeds which of theirs.
  2. Filling gaps. Most store platforms do not hold a Google product category, a GTIN for every product, or custom labels for your ad strategy. Those have to come from somewhere.
  3. Fixing what gets flagged. Merchant Center lists problems under Products & store > Products > Needs attention. A warning limits how a product performs; a disapproval stops it showing.
  4. Staying in sync. Price and availability change daily. Google marks a product as needing an update 30 days after its last one, and a feed that disagrees with the site on price is its own issue.
A feed tool that copies a wrong value to three channels has made one mistake into three.

What Merchant Center already gives you

Before paying for anything, it is worth knowing what is built in:

  • Attribute rules. Google renamed feed rules to attribute rules. They transform values as the data comes in: set a value, find and replace, add text to the start or end. They appear only after you turn on the Advanced data source management add-on, then under Data sources, on the source’s attribute rules tab.
  • Supplemental data sources. A second file or sheet that adds or replaces attributes for products already in your main feed, matched on id. It cannot add or remove products. See supplemental data source.
  • Diagnostics. The Needs attention tab, with a Prioritized fixes toggle that hides issues with little impact.

When a spreadsheet stops being enough

There is no product count where the answer flips. These signals matter more:

  • You sell on more than one channel and each wants slightly different fields or titles.
  • You keep making the same edit, such as adding the brand to every title, across hundreds of rows every time the catalog changes.
  • The catalog churns: new arrivals weekly, variants appearing and disappearing.
  • More than one person edits and nobody can say which version is current.

One of these is a nuisance. Three of them together is usually when a rules-based tool, or a person whose job it is, pays for itself.

What a feed tool can and cannot fix

Feed tools are good at moving and reshaping data. They are not a source of truth. If your catalog has no GTINs, a feed tool cannot invent them, and Google’s own guidance is Don’t guess or make up a value. If a product has no category, a rule can copy one from somewhere, but somebody still has to decide what the right category is.

That is why the decision work, such as choosing a Google product category for each product, is worth doing once, carefully, and storing where every channel can reuse it.

A lightweight setup that works for most small stores

  1. Let the platform’s own app (Shopify’s Google & YouTube app, or a WooCommerce feed plugin) keep the main feed in sync.
  2. Put the values the platform does not hold (category IDs, custom labels) in a supplemental data source, keyed on id.
  3. Once a month, open Needs attention and clear what is there.

The Bulk Mapper produces step 2’s category file from a catalog export, with the uncertain rows split out for you to check.

Questions

Can Merchant Center do feed rules without a third-party tool?

Yes. Feed rules are now called attribute rules and are built into Merchant Center. Turn on the Advanced data source management add-on, then open the data source and its attribute rules tab.

How often should a product feed be updated?

Often enough that price and availability always match your site. Merchant Center also marks a product as needing an update 30 days after its last one, so no product should go longer than that.

Do I need a feed management tool for one Shopify store?

Usually not at first. The Google & YouTube app syncs the catalog, and a supplemental data source can carry the few values Shopify does not hold. A tool starts to earn its fee when you add channels or repeat the same edits across many rows.