How To Add eCommerce Shopping Feeds To Google Merchant

12 Jan. 2020 - - Total Reads 2,713

A basic guide to google shooping

E-Commerce has become a trend setter in business and economy after the COVID-19 hit the world. Show your products on the website, advertise and sell them within the website. But how does this really happen? How a customer or a client will know about your products and services? This is when you need Google Merchant.

After setup Google Merchant for your store, you now need to upload the google shopping product feed to launch and display the products in the eCommerce market. You can manage how your in-store and online products appear on Google.  The product feed is the file that includes your product list with its attributes that google needs to display, advertise and compare products.

Create and Register Feed (Primary or Supplementary) in Google Merchant

Google merchant has two types of feeds; Primary Feeds and Supplementary Feeds. Primary feeds are the main data sources where as Supplementary includes the missing data that you might forget to include on primary feed.
Let’s dive into these steps on how to create a feed for your store. 

First login to the merchant account. Go to the Products tab in the sidebar menu, click Feeds. Now Click this icon.

Ecommerce shopping feed setup
Ecommerce shopping feed setup

It will prompt you to the screen below. As you can see there are three tabs, namely Basic information, Name and input method and Setup.  Enter the information specified in these tabs and continue to set up your feed. 

Create and Register ecommerce shopping Feed
Create and Register shopping Feed
  1. Country of sale: Choose the main country where your products from the feeds are sold.
  2. Language: Choose which language is used in your product data.
  3. Destination: Destination determines which google features can be used for the items.
  4. Primary feed name: Add a descriptive name to identify the primary feed. You can change the name from feed settings as well.
Feed name and input method
Feed name and input method tab

Now select any convenient method to set up or upload your feed and continue to connect. 

Upload the feed input file

Google merchant allows four input methods to upload the feed spreadsheet or text file, XML file and connect API. Let’s go through each method.

Google sheet

After you select the google sheet method on the above “Name and input method” tab, then you will be prompted to sign in to your Gmail account. Then select Generate a new google spreadsheet from a template and continue.

Access the google sheet which includes required information titles to put the values.

Feed access and processing step
Feed access and processing step
Google sheet Feed Template
Google sheet Feed Template

Now, go to your eCommerce shopping website and extract all the product information in a spreadsheet. If your eCommerce website is Shopify then, go to all products and export as CSV for excel.

Export product lists from the website.
Export product lists from the website.

Under the product feed of the merchant centre, you will find the link for the google sheet which includes required titles and attributes. 

List of product feed
List of product feed

Compare the titles of your spreadsheet and merchant template sheet. Now paste information on the respective columns. Complete the sheet and fetch the feed from Google Merchant.

Fetch the product from sheet
Fetch the product from sheet

Now go to the settings tab, under the fetch schedule, adjust your fetch schedule, time and zone as needed and save it.

Configure the feed settings
Configure the feed settings

Now your feed is ready and can be optimised and diagnosed for the disapproved product items.

Scheduled Fetch

If you do not want to use Google Sheet method, Google merchant center also allows you to create an uploading schedule for product feed hosted on the website. According to the fetch schedule, it will upload the file from the website. 

Select schedule fetch input method like we did earlier for google sheets input method. 

Schedule fetch method
Schedule fetch method

You will be prompted to complete the next step. Enter the information; Feed file name, fetch frequency, time and zone, file URL (the URL protocols can be http, https, ftp and sftp) and login info of your file URL to create the feed.

Feed File Upload Setup
Feed File Upload Setup

Upload

Merchants who have few products or rarely make any adjustments on the feed then this method is best for them. It is easy and doesn’t need many requirements.

Select upload input method and continue which will take you to the next step to upload your file.

File Upload Method
File Upload Method

Export the product from your eCommerce website and save it on a local computer. Now drag or browse files to the Merchant Centre. Keep in mind that the maximum file size limit is 4 GB. A file size more than 4 GB cannot be uploaded.

Ecommerce Shopping feed file Upload setup
Shopping feed file Upload setup

Enter the file name exactly as the file you uploaded. Then click Create Feed.

Upload feed file via FTP 

For the merchants who manage large inventory and need frequent updates on the product, it is recommended to use this method.

To upload the feed via FTP, you need to create a FTP account. Go to the settings of the merchant center and click SFTP/FTP/GCS. Select SFTP/FTP tab and create FTP account but SFTP is recommended as it is more secure. Your FTP username will be generated automatically. Click Generate Password to generate the password and enable the account.

FTP account Setup in Google Merchant
FTP account Setup in Google Merchant
Generate FTP

Now enter the data feed using FTP program. Download the FTP client, Filezilla for Windows on your computer. Configure the settings to connect with Google merchant FTP server. The FTP client program will need the following settings: 

Hostname: uploads.google.com

Username and password can be found on Google Merchant FTP where you generated the user and password. 
Log on type must be normal and not anonymous.

Now, the next step is to optimize the product feed. If the product data are not optimized, values unmatched and missing attributes, then it might cost against you which we will learn in the next article in andmine.com

Michael Simonetti
Posted by:

Post Reads: 2.7K

Share this

Go on, see if you can challenge us on "How To Add eCommerce Shopping Feeds To Google Merchant" - Part of our 183 services at AndMine. We are quick to respond but if you want to go direct, test us during office hours.

Add Your Comment

Trusted by

Gilbert+Tobin
Taylor Rose
Elucent
Microsoft Certified Azure Fundamentals
Tomorrow Stars Basketball
Naturtint
QV Skincare
Brisbane Times
Toni&Guy
Fit My Car
21st Century Australia Party
The Fortune Institute
Cell Therapies
Ego Pharmaceuticals
Tribe
Plants
Acquia Certified Site Builder Drupal
Wild Rhino Shoes
Jetstar
SunSense Digital Agency
Buy Aussie Now
The Royal Melbourne Hospital
ADP Payroll
Ello
Kadac
Viktoria & Woods
Tassal
Xavier
LBG Australia and New Zealand
Fairfax Media
Amino Active
Instant RockStar
Cronos Australia
Bostik
CSquared Executive
Hanover
Etihad Stadium
Max’s
Drupal
Oakdale Meat Co
CAN- Common Wealth Bank
GPT Group
Chia
ISO CERTIFIED 27001
Appstore
Inferflora
Hairhouse Warehouse
The University Of Melbourne
Smart Company
Passage To India
Grow Your Business
CB Richard Ellis
Switzer Media+Publishing
Focus On Furniture
Watches of Switzerland
Green St Juice CO
ACTUATE IP
Bank of Cyprus
University of South Australia
Melrose MCT
Scrum.org
McArthur Skincare
Melrose Health
PranaOn
James Buyer Advocates
DUSA, Deakin University Student Association
RMIT University
Novvi
Bigcommerce
Florsheim Shoes
Moov Head Lice
NextTech
National Relay Services
Arthur Galan
Vitura Health
Positive Poster
DeeWhy Market
Schiavello
Adobe Professional
Parker Lane
DepSkin.com
Australian Government
Beaumont
Matchbox Homewares
Gadens
Herbert Smith Freehills
Rock Pool Group
Van Egmond Group
OpenAI
SwinBurne University of Technology
Crumpler
Metricon
Cooper Mills
iPrimus
Palace Cinemas
NMI Insurance
National Museum of Australia
Macpherson Kelley
Melbourne Heart
Vendor Advocacy Australia
News
Street Kitchen
The Age
Ebay
WTFN
BlackMores
Craft CMS
Bulk Nutrients
Think & Grow Rich Inc
Atlantic Group of Companies
Madman Entertainment
Macmillan Publishing
SMH – The Sydney Morning Herald
Dinosaur Designs
Australian Physiotherapy Association
Ubertas Group
Google
NGS Super
Royal Freemasons
Mamma Lucia
Boston Consulting Group
Unsw Australia
POSTER Magazine
Celebrate Health
Federation Square
Paypal
Carlton Football Club
Eway
Kay&Burton
The Burger Cheese
Oracle
Cleanfit
Natralus Australia
Engineers Without Borders
Fresh Cheese Company
Toy World
Sunday Creek
High Street Armadale
Aqium Gel
AC/DC
HGG 
Grays Ecommerce
Plan It Sync It
Magento Solution Specialist
Tek Ocean
Sports Power
ABC
Uber
MAP
Windsorsmith
Australian Organic Food CO
TPP
One Shift
MyAccount
Associated Press
Mark Alexander Design
Rackspace
White Suede
OMS – Order Management System
Arc One
Fast.co
The Canberra Times
Movember
Grainshaker
Passage Foods
Catholic Insurance
Loan Market
Garmin
Jalna
Melbourne Sports and Aquatic Centre – MSAC
Rydges
Castran Gilbert
Dial Before You Dig
Thomson Geer
Engine Swim
Federation University Australia
Australian Anthill
GooglePlay
Bintani Australia
Maxine
Marshall White
King Wood Mallesons
Victorian Government
Bondi Sands
Mecca Brands
Coles
Forbes
OJAY
Heat Holders
Banki Haddock Fiora
French Tables
131 Pizza
Telstra
Melbourne Central
Magento
ISO Certified
VISSF
Liveoneday
Peter Mac
Shell

Testimonials

It is great working with such a dedicated and competent team in this ever changing space and I would highly recommend Michael and his work. Stephanie Clayton, Marketing Services Manager, Ego Pharmaceuticals

More Testimonials
AndMine-Google-Partner-Signature