{"slug":"sop-218-set-up-google-shopping-product-feed","title":"Set Up Google Shopping Product Feed","tags":["source:clickminded","type:sop","server:clickminded-sop","google","shopping","product","feed"],"agent_summary":"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 __Last Updated / Reviewed:__ 01/31/2025 __Execution Time:__ 30 minu","trigger_phrases":["set up google shopping product feed","how to set up google shopping product feed"],"runnable":false,"markdown":"\r\nSOP 218: Set Up Google Shopping Product Feed\r\n\r\nSet up a product data sheet for your online store and feed it to Google Merchant Center\r\n\r\n__Last Updated / Reviewed:__ 01/31/2025\r\n\r\n__Execution Time:__ 30 minutes to 2 hours (depending on the number of products) \r\n\r\n__🚀 Goal:__ To feed product data to your Google Merchant Center Next account.\r\n\r\n__🤞 Ideal Outcome:__ You successfully create and upload your product data to your Google Merchant Center Next.\r\n\r\n__🤔 Why this is important:__ 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.\r\n\r\n__🧐 Where this is done__ In Google Merchant Center Next and Google Excel.\r\n\r\n__🗓️ When this is done:__ Whenever there are new updates to your products. \r\n\r\n__👨 Who does this:__ The business owner/manager or the local/agency digital marketer. \r\n\r\n__⚠️Prerequisites or requirements: If you’re new to Google Merchant Center Next, you will need the following tasks to be completed before using this SOP:__\r\n\r\nSet up a Google Merchant Center Next (SOP 213 – [web version](https://members.clickminded.com/sop/213/))\r\n\r\nFamiliarize yourself with the type of feeds available. (refer to [types of feeds](https://support.google.com/merchants/answer/7439882?hl=en&ref_topic=3163841))\r\n\r\nYou must adhere to Google’s formats before feeding your product data to your Google Merchant Center Next (Refer to [file formats](https://support.google.com/merchants/answer/160567?hl=en&ref_topic=3163841#zippy=%2Ctext-spreadsheet-or-tab-delimited))\r\n\r\nIt 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](https://support.google.com/merchants/answer/160588?hl=en))\r\n\r\nYou will need to create a new primary feed Excel sheet. Click on the ready-made Google Excel sheet (Template 068 – [web version](https://members.clickminded.com/template/068/)). 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.\r\n\r\n__If you already use Google Merchant Center Next, you will need the following tasks to be completed before using this SOP:__\r\n\r\nIf you already have a primary feed previously set up, use the ready-made supplemental feed Google Excel sheet (Template 069 – [web version](https://members.clickminded.com/template/069/)). Copy it into your Gmail business account.\r\n\r\n[__Click here to get the most up-to-date version of this SOP__](https://members.clickminded.com/sop/218)\r\n\r\n## Preparing the data feed\r\n\r\n### 01▸ 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](https://members.clickminded.com/template/068/)).\r\n\r\n### 02▸ In the Google Excel sheet, go to “File” and click “Make a copy”.\r\n\r\n\r\n### 03▸ Ensure that you have the right folder to copy into and hit “Make a copy”.\r\n\r\n### \r\n\r\n### 04▸ 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.\r\n\r\n\r\nIf you already have a primary feed previously set up and would like to add data that are missing from your primary feed, follow the same steps above and fill out the Supplemental Feed Google Excel Sheet (Template 069: Supplementary Google Shopping Product Feed Template - [web version](https://members.clickminded.com/template/069/)).\r\n\r\n## How to set up a new primary feed\r\n\r\n### 01▸ Sign in to your Google Merchant Center [here](https://merchants.google.com/). Choose the appropriate Gmail account and log in with your password. Click “Next”.\r\n\r\n\r\n### 02▸ Click \"Products” under “Your Business” > \"Add products\".\r\n\r\n\r\n### 03▸ Select \"Add another product source\".\r\n\r\n### \r\n\r\n### 04▸ Next, click “Use Google Sheets” > \"Choose spreadsheet\".\r\n\r\n\r\n### 05▸ Choose a Gmail account that consists of your Google Excel (primary data feed) sheets. It will automatically link to your Google account.\r\n\r\n### 06▸ Select the appropriate Excel data feed sheet. Click “Insert”.\r\n\r\n### 07▸ 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.\r\n\r\n### 08▸ Click “Continue” to move forward.\r\n\r\n\r\n## How to set up a supplemental feed\r\n\r\n### 01▸ Sign in to your Google Merchant Center [here](https://merchants.google.com/). Choose a Gmail account and log in with your password. Click “Next”.\r\n\r\n\r\n### 02▸ Go to the settings or click on the gear icon in your Merchant Center > \"Add-ons\".\r\n\r\n### \r\n\r\n### 03▸ In the \"Discover\" tab, locate \"Advanced Data Source Management\" and click \"Add\".\r\n\r\n### 04▸ Go to \"Data sources\" under the settings or gear icon.\r\n\r\n### \r\n\r\n### 05▸ Select the \"Supplemental sources\" tab. Click on \"Add supplemental product data\".\r\n\r\n### 06▸ Choose \"Add Product data from file\" and provide the necessary details.\r\n\r\n### 07▸ 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!\r\n\r\n## Troubleshoot your data feed\r\n\r\n### 01▸ Go to your Google Merchant Center Next dashboard and click “Products” under \"Your Business\".\r\n\r\n### 02▸ Then, select the \"Needs attention\" tab. You will be able to review all the errors you have for feeds.\r\n\r\n### 03▸ If you are unsure of how to fix the issue, click on the drop-down arrow to reveal more details.\r\n\r\n### 04▸ Click “Learn more” for more information on why the feed is facing an issue.","html":"

SOP 218: Set Up Google Shopping Product Feed

\n

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

\n

Last Updated / Reviewed: 01/31/2025

\n

Execution Time: 30 minutes to 2 hours (depending on the number of products)

\n

🚀 Goal: To feed product data to your Google Merchant Center Next account.

\n

🤞 Ideal Outcome: You successfully create and upload your product data to your Google Merchant Center Next.

\n

🤔 Why this is important: 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.

\n

🧐 Where this is done In Google Merchant Center Next and Google Excel.

\n

🗓️ When this is done: Whenever there are new updates to your products.

\n

👨 Who does this: The business owner/manager or the local/agency digital marketer.

\n

⚠️Prerequisites or requirements: If you’re new to Google Merchant Center Next, you will need the following tasks to be completed before using this SOP:

\n

Set up a Google Merchant Center Next (SOP 213 – web version)

\n

Familiarize yourself with the type of feeds available. (refer to types of feeds)

\n

You must adhere to Google’s formats before feeding your product data to your Google Merchant Center Next (Refer to file formats)

\n

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)

\n

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.

\n

If you already use Google Merchant Center Next, you will need the following tasks to be completed before using this SOP:

\n

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.

\n

Click here to get the most up-to-date version of this SOP

\n

Preparing the data feed

\n

01▸ 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).

\n

02▸ In the Google Excel sheet, go to “File” and click “Make a copy”.

\n

03▸ Ensure that you have the right folder to copy into and hit “Make a copy”.

\n

\n

04▸ 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.

\n

If you already have a primary feed previously set up and would like to add data that are missing from your primary feed, follow the same steps above and fill out the Supplemental Feed Google Excel Sheet (Template 069: Supplementary Google Shopping Product Feed Template - web version).

\n

How to set up a new primary feed

\n

01▸ Sign in to your Google Merchant Center here. Choose the appropriate Gmail account and log in with your password. Click “Next”.

\n

02▸ Click \"Products” under “Your Business” > \"Add products\".

\n

03▸ Select \"Add another product source\".

\n

\n

04▸ Next, click “Use Google Sheets” > \"Choose spreadsheet\".

\n

05▸ Choose a Gmail account that consists of your Google Excel (primary data feed) sheets. It will automatically link to your Google account.

\n

06▸ Select the appropriate Excel data feed sheet. Click “Insert”.

\n

07▸ 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.

\n

08▸ Click “Continue” to move forward.

\n

How to set up a supplemental feed

\n

01▸ Sign in to your Google Merchant Center here. Choose a Gmail account and log in with your password. Click “Next”.

\n

02▸ Go to the settings or click on the gear icon in your Merchant Center > \"Add-ons\".

\n

\n

03▸ In the \"Discover\" tab, locate \"Advanced Data Source Management\" and click \"Add\".

\n

04▸ Go to \"Data sources\" under the settings or gear icon.

\n

\n

05▸ Select the \"Supplemental sources\" tab. Click on \"Add supplemental product data\".

\n

06▸ Choose \"Add Product data from file\" and provide the necessary details.

\n

07▸ 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!

\n

Troubleshoot your data feed

\n

01▸ Go to your Google Merchant Center Next dashboard and click “Products” under \"Your Business\".

\n

02▸ Then, select the \"Needs attention\" tab. You will be able to review all the errors you have for feeds.

\n

03▸ If you are unsure of how to fix the issue, click on the drop-down arrow to reveal more details.

\n

04▸ Click “Learn more” for more information on why the feed is facing an issue.

\n"}