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.
The four jobs inside feed management
- Mapping. Your platform calls it Colour or Vendor; Google wants
colorandbrand. Someone has to decide which of your fields feeds which of theirs. - 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.
- 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.
- 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
- Let the platform’s own app (Shopify’s Google & YouTube app, or a WooCommerce feed plugin) keep the main feed in sync.
- Put the values the platform does not hold (category IDs, custom labels) in a supplemental data source, keyed on
id. - 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.
Read next
What is a product feed? The file behind every Shopping listing
A product feed lists every product as one row of attributes. What goes in it, what Google requires, and why channels read it instead of your product pages.
Who to hire for product feed help: developer, feed specialist or agency?
Developers fix syncs, feed specialists fix data, PPC agencies fix campaigns. Match the hire to the problem, keep your accounts, and spot the red flags early.
Whose job is the product feed? Owning it when five people touch it
Catalog, pricing, ads and tech teams all feed the product feed, but one person must own it. Who supplies what, and a one-page ownership note to write today.