Google Merchant Center: Your Product Feed’s Best Friend

Why Your Google Merchant Center Product Feed is the Foundation of Shopping Success

A google merchant center product feed is a file with your product data—titles, prices, images, and more—that you upload to Google Merchant Center. This feed determines how your products appear across Google Search, Shopping, Maps, YouTube, and Google Images. Without a well-structured feed, your products won’t be visible to potential customers, regardless of your ad budget.

Quick Answer: Managing Your Google Product Feed

To manage your feed effectively:

1. Format: Use .txt, .tsv, or .xml files (up to 4 GB).
2. Attributes: Include required data like id, title, description, link, image_link, price, availability, condition, brand, and gtin.
3. Updates: Upload daily; the minimum is every 30 days.
4. Feed Rules: Use rules to modify data, add missing attributes, or standardize values.
5. Error Monitoring: Check the “All products” page for disapprovals and warnings.

Why This Matters

Your product feed is the source of truth Google uses to match products with customer searches. A correct feed leads to relevant product placement with accurate information. An incorrect one results in disapprovals, poor visibility, and wasted ad spend.

Google uses your feed to determine:

• Where your products appear (Search, Shopping, Maps, etc.)
• Which search queries trigger your products.
• How your products are displayed (title, price, image).
• Whether your products qualify for free listings or paid ads.

I’m Samir ElKamouny, founder of Fetch and Funnel. I’ve spent years helping e-commerce brands optimize their google merchant center product feed to maximize ROI. I’ve seen how feed quality directly impacts conversion rates and customer acquisition costs. This guide will show you how to build, structure, and optimize your feed for peak performance.

Creating Your Product Feed: Formats and Structure

Before your products can appear on Google, you must package your product data into a file Google can read. This google merchant center product feed is a detailed catalog telling Google everything about your products.

Google Merchant Center accepts three file formats: .txt (text files), .tsv (tab-separated values), and .xml (Extensible Markup Language). Text and TSV files are essentially spreadsheets saved in a plain text format. XML is more technical, using tags to organize information hierarchically.

Your file can be up to 4 GB, which is sufficient for most catalogs. Ensure you use the correct file extension (.txt, .tsv, or .xml) to avoid rejection.

Which format should you choose?

• Spreadsheet formats (.txt and .tsv) are ideal for smaller catalogs or manual updates. You can create them in Google Sheets or Excel. They are easy to use but can become difficult to manage with thousands of products and are harder to automate.
• XML feeds are better for large inventories and automation. They are more compact for complex data and integrate well with APIs and e-commerce platforms, though they can be more technical to set up. Many businesses leverage third-party feed management tools like DataFeedWatch to simplify and automate this process.

For detailed instructions, refer to Google’s official guide: Create a product file for Merchant Center – Google Help.

Structuring Your Google Merchant Center Product Feed with a Spreadsheet

Creating a tab-delimited google merchant center product feed is like building a table where columns represent product information and rows represent individual products.

Start with a header row. This first row tells Google what each column contains, using attribute names like id, title, price, and image_link. The exact spelling and format (e.g., image_link with an underscore) are critical.

Below the header, each line is a single product. A Google Pixel 6a gets its own row with its specific data, and a pair of Pixel Buds gets another.

Here’s a simple feed structure:

To upload, save your spreadsheet as a tab-delimited file. In Google Sheets, use File > Download > Tab Separated Values (.tsv). In Excel, choose File > Save As > Text (Tab delimited) (.txt).

Structuring Your Feed with XML

For larger scale or automation, XML is the preferred format. An XML-formatted google merchant center product feed uses a hierarchical structure ideal for programmatic updates.

The structure begins with a root element, like <rss> or <feed>, which includes namespace declarations (e.g., xmlns:g=\"http://base.google.com/ns/1.0\") to specify Google’s attribute format.

Each product is contained within an <item> element. All data for that product is nested inside these tags. Google-specific attributes use a g: prefix, such as <g:id> and <g:price>.

Here’s a basic XML feed structure:

<?xml version=\"1.0\"?><rssversion=\"2.0\"xmlns:g=\"http://base.google.com/ns/1.0\"><channel><title>OurAmazingProducts</title><link>https://store.google.com/</link><description>Ouronlinestoreproducts</description><item><g:id>CHROMECASTTV</g:id><g:title>GoogleChromecastwithGoogleTV-Snow</g:title><g:description>Streamyourentertainmentin4KHDR.</g:description><g:link>https://store.google.com/us/product/chromecast_google_tv</g:link><g:image_link>https://www.gstatic.com/webp/gallery/3.jpg</g:image_link><g:condition>new</g:condition><g:availability>in_stock</g:availability><g:price>49.99USD</g:price><g:brand>Google</g:brand><g:gtin>810013621458</g:gtin></item><!-- More product items --></channel></rss>

XML is excellent for connecting your feed to an e-commerce platform or inventory system, as many platforms can generate XML feeds automatically. This automation is key for data-driven ad strategies that help you scale. The format you choose is the foundation; accuracy and consistency are what matter most.

Mastering Key Product Feed Attributes

Your google merchant center product feed‘s quality depends on the data within it. Attributes like title, price, and brand create a complete picture of each item, helping Google match your products with the right shoppers.

Following Google’s Product data specification – Google Merchant Center Help is mandatory for visibility in Shopping ads and free listings. Correct attributes are fundamental to Google Shopping Feed Optimization and directly impact sales. For another perspective on attribute optimization, resources from agencies like Tinuiti can also be valuable.

Attributes are categorized as required (non-negotiable), optional (improve performance), and conditional (required only in specific cases, like for apparel or certain countries). Understanding these is key to getting your products seen.

Basic Product Data

These core attributes define your product’s appearance to customers.

• id: A unique, consistent identifier (like an SKU) for each product. Changing it makes Google see a new item.
• title: The product name, matching your landing page. Use title or structured_title. Avoid promotional text or all caps. For AI-generated titles, use structured_title and set digital_source_type to trained_algorithmic_media.
• description: A detailed product description, matching your landing page. Use description or structured_description. Focus on product features, not promotions or links. For AI content, use structured_description with the correct digital_source_type.
• link: The direct URL to the product landing page, using your verified domain.
• image_link: The main product photo. It must be high-quality, showing only the product without text, watermarks, or borders. AI-generated images require specific IPTC metadata.

Price and Availability

Accuracy here is critical to avoid frustrating shoppers and earning disapprovals.

• price: Must match the price on your landing page and at checkout, including currency.
• availability: Must match your website’s stock status (in_stock, out_of_stock, preorder, backorder).
• sale_price: Use this attribute during a sale. It must also match the landing page price.
• sale_price_effective_date: Defines the start and end dates for your sale. Without it, the sale price is considered permanent. For sale annotations, the original price must have been active for at least 30 non-consecutive days in the past 200.

Unique Product Identifiers (UPIs)

UPIs help Google identify your products and improve visibility.

• brand: The product’s brand name. Use your own brand if you’re the manufacturer; otherwise, use the reseller’s brand.
• gtin: The Global Trade Item Number (UPC, EAN, ISBN). Submit valid GTINs without dashes or spaces. Missing a required GTIN limits visibility; an incorrect one leads to disapproval.
• mpn: The Manufacturer Part Number. Submit only valid, manufacturer-assigned MPNs.
• identifier_exists: Set to no only if a product genuinely lacks a brand, GTIN, and MPN. Misusing this will lead to disapproval.

Detailed Product Descriptions and Variants

These attributes add specificity, especially for products with variations.

• condition: new, used, or refurbished.
• item_group_id: Crucial for product variants. Assign the same ID to all variations of a single product (e.g., a shirt in different sizes and colors). This groups them together, which is vital for Google Ads Performance Max Campaign strategies.
• Variant Attributes: Use color, size, material, age_group (newborn, infant, toddler, kids, adult), and gender (male, female, unisex) with item_group_id to differentiate each variant.

Shipping, Tax, and Destination Attributes

These attributes control shipping costs and where your products appear.

• shipping and tax: Override account-level settings for specific products.
• excluded_destination: Prevent products from appearing in specific programs (e.g., Shopping_ads, Free_listings).
• included_destination: Explicitly select where you want a product to appear.

Uploading and Optimizing Your Google Merchant Center Product Feed

You’ve built your google merchant center product feed; now it’s time to get it into Google Merchant Center so your products can start appearing to shoppers.

Google offers several upload methods:

• Scheduled Fetch: You host the file, and Google fetches it on a schedule you set. Daily is recommended. This is a popular, automated method.
• Direct Upload: Manually upload your .txt, .tsv, or .xml file. Good for smaller catalogs or infrequent updates.
• Platform Integrations: Use apps for platforms like Shopify or BigCommerce to sync your catalog automatically. For example, Shopify’s native Google & YouTube channel is a popular choice, while third-party solutions like GoDataFeed offer more advanced features. As one merchant noted, this allows you to “sync our entire catalog… and get them live within a couple days.”
• Google Sheets: Use a template to create your feed in Google Sheets, and Merchant Center will pull data from it automatically.
• Content API for Shopping: The most powerful option for large operations, allowing your systems to update product data programmatically in real-time.
• Website Crawl: Google can automatically collect product information from structured data on your site.

After uploading, check the “All products” page for errors. While Google requires updates at least every 30 days, daily updates are strongly recommended to keep data fresh.

Using Feed Rules for Powerful Modifications

Feed rules allow you to modify your product data directly within Merchant Center without altering your source file. This is useful for fixing errors, adding missing attributes, or optimizing data. Rules can add new data or modify existing data, which is essential for maintaining data quality and supporting features like Google Enhanced Conversions.

Changing Data with ‘Set To’, ‘Extract’, and ‘Take Latest’

• ‘Set To’: A versatile rule to assign static values (e.g., set condition to “new” for all products) or combine multiple attributes into one (e.g., merge brand, name, and color into an optimized title).
• ‘Extract’: Pulls specific terms from one attribute to populate another. For example, it can find “Red” in a product title and populate the color attribute.
• ‘Take Latest’: Ensures Google uses the most recent data when you have multiple feeds (like a main feed and a supplemental sale feed). This prevents price mismatches during promotions.

Advanced Modifications: ‘Prepend/Append’, ‘Find & Replace’, and ‘Split & Choose’

These rules offer finer control over your google merchant center product feed.

• ‘Prepend/Append’: Adds text to the beginning or end of an attribute, such as adding your brand name to all product titles.
• ‘Find & Replace’: Standardizes terminology across your catalog, like replacing “trainer” with “athletic shoe.”
• ‘Split & Choose’: Parses complex data fields. For example, it can split a comma-separated list of features in a description into individual custom attributes.
• ‘Clear data’: Use this rule with extreme caution. It permanently removes an attribute’s data for a product. Clearing a required attribute will cause an immediate disapproval.

Feed rules are a cornerstone of scalable data-driven ad strategies, allowing you to optimize thousands of products efficiently.

Frequently Asked Questions about Google Product Feeds

After years of managing google merchant center product feed optimization, we’ve seen the same questions arise. Here are the answers to the most common ones.

What are the most common reasons for product disapprovals in Merchant Center?

Disapprovals are Google’s way of highlighting data quality issues. The most common culprits are:

• Mismatched Price or Availability: The price or stock status in your feed must exactly match your landing page.
• Missing or Incorrect UPIs: Products that require a brand, gtin, or mpn will be disapproved if the identifiers are missing or incorrect.
• Low-Quality Images: Images with promotional text, watermarks, or borders, or that don’t accurately represent the product, will be rejected.
• Broken Landing Page Links: The link attribute must lead to a valid, working product page.
• Policy Violations: Including promotional text (e.g., “FREE SHIPPING!”) in titles or descriptions, or misrepresenting product condition.

How often should I update my product feed?

While Google’s minimum requirement is once every 30 days, this is insufficient for most businesses. Daily updates are the industry standard and our strong recommendation. This practice keeps your data fresh, prevents price and availability mismatches, and ensures customers see accurate information.

For businesses with volatile inventory or frequent price changes, even more frequent updates via the Content API for Shopping are ideal. Outdated data leads to wasted ad spend and lost sales, so keeping your feed fresh is essential for profitability.

Can I use one product feed for multiple countries?

Yes, you can use a single primary google merchant center product feed to expand internationally. You can add target countries in Merchant Center and use supplemental feeds to provide country-specific data. Services like Lengow are designed to help manage the complexities of localization, such as currency and language translation.

Key considerations include:

• Currency: Google offers automatic currency conversion, but providing prices in the local currency generally improves performance.
• Language: While Google can translate some text, providing professionally translated title and description attributes in the local language is best for user experience. Supplemental feeds are perfect for this.
• Local Requirements: Attributes for shipping, tax, and other regulations can vary by country. Use supplemental feeds to provide these overrides.

At Fetch and Funnel, we use this approach to help brands expand into new markets, ensuring their product data is compliant and optimized for each region.

Conclusion

Your google merchant center product feed is the heartbeat of your Google Shopping presence, shaping how customers find your products across Google’s network. You can have the best products and prices, but if your feed is inaccurate or incomplete, your products won’t be visible when customers are ready to buy.

We’ve covered how to build, format, and optimize your feed. The key takeaway is that data accuracy drives ROI. A well-maintained feed ensures your products appear in the right searches with correct information, forming a solid foundation for your Shopping campaigns, Performance Max strategies, and free listings.

At Fetch and Funnel, we specialize in data-driven strategies that increase ROI, and we know that success starts with a perfectly optimized product feed. It’s not just a technical file; it’s your digital storefront on the world’s largest shopping platform.

Ready to turn your product feed into a powerful growth engine? Get a free Google Shopping feed optimization audit and let’s build a feed that delivers measurable results for your business.