Skip to Content
LLM Decode learn.llmdecode.com
Back to all resources
SOP-218

Set Up Google Shopping Product Feed

Set up a product data sheet for your online store and feed it to Google Merchant Center

Type SOPs · PDF
Last updated 31 January 2025
Who does this The business owner/manager or the local/agency digital marketer
Length 10 pages

Goal

To feed product data to your Google Merchant Center Next account

Ideal outcome

You successfully create and upload your product data to your Google Merchant Center Next

Why it matters

When you add your product data to your Google Merchant Center Next, it enables you to run shopping advertisments and promote your products across Google's various platforms. The Google Shopping data feed is crucial to the success of your Google shopping campaigns

Before you start

If you’re new to Google Merchant Center Next, you will need the following tasks to be completed before using this SOP: Set up a Google Merchant Center Next (SOP 213 – web version) Familiarize yourself with the type of feeds available. (refer to types of feeds) You must adhere to Google’s formats before feeding your product data to your Google Merchant Center Next (Refer to file formats) It is recommended to use Google Excel Sheets instead of Microsoft Excel saved as “Tab-separated values (.tsv, current sheet)” (Refer to how to convert spreadsheet) You will need to create a new primary feed Excel sheet. Click on the ready-made Google Excel sheet (Template 068 – web version). Copy it into your Gmail business account. A few examples are given in Excel for your reference. Key in your product information according to the attributes. If you already use Google Merchant Center Next, you will need the following tasks to be completed before using this SOP: If you already have a primary feed previously set up, use the ready-made supplemental feed Google Excel sheet (Template 069 – web version). Copy it into your Gmail business account

Key steps 23 steps

What is inside 27 headings

1 Preparing the data feed 4

  1. If you are a new user, you will need to create a new primary data feed in Google Excel. Please refer to the Template 068: Primary Google Shopping Product Feed Template (web version).
  2. In the Google Excel sheet, go to “File” and click “Make a copy”.
  3. Ensure that you have the right folder to copy into and hit “Make a copy”.
  4. Next, you will need to fill out your product attributes such as ID, Title, Description, Price, Condition, Link, Availability, and Image link. A few examples are illustrated below.

2 How to set up a new primary feed 8

  1. Sign in to your Google Merchant Center here. Choose the appropriate Gmail account and log in with your password. Click “Next”.
  2. Click "Products” under “Your Business” > "Add products".
  3. Select "Add another product source".
  4. Next, click “Use Google Sheets” > "Choose spreadsheet".
  5. Choose a Gmail account that consists of your Google Excel (primary data feed) sheets. It will automatically link to your Google account.
  6. Select the appropriate Excel data feed sheet. Click “Insert”.
  7. Adjust the country that the products will be shown to with the preferred language and set it to "for all marketing methods". Enter a feed label only when you need to categorize your products.
  8. Click “Continue” to move forward.

3 How to set up a supplemental feed 7

  1. Sign in to your Google Merchant Center here. Choose a Gmail account and log in with your password. Click “Next”.
  2. Go to the settings or click on the gear icon in your Merchant Center > "Add-ons".
  3. In the "Discover" tab, locate "Advanced Data Source Management" and click "Add".
  4. Go to "Data sources" under the settings or gear icon.
  5. Select the "Supplemental sources" tab. Click on "Add supplemental product data".
  6. Choose "Add Product data from file" and provide the necessary details.
  7. Adjust the country that the products will be shown to with the preferred language and set it to "for all marketing methods". Enter a feed label only when you need to categorize your products. Click “Continue” to move forward and that's it!

4 Troubleshoot your data feed 4

  1. Go to your Google Merchant Center Next dashboard and click “Products” under "Your Business".
  2. Then, select the "Needs attention" tab. You will be able to review all the errors you have for feeds.
  3. If you are unsure of how to fix the issue, click on the drop-down arrow to reveal more details.
  4. Click “Learn more” for more information on why the feed is facing an issue.

The document 10 pages

The file is locked

It comes with 2 DAY GEN AI ENGINEERING MASTERMIND, or with the full library.

Bought from LLM Decode before? Sign in to pay ₹ 1,999.00.

Up next · SOP-219 Link Merchant Center Next with Google Ads Account Link your Google Merchant Center to your Google Ads account so you can start running campaigns for Google Shopping Unlock to read