2 min read

Written By - Sunny Thakur

As someone who lives for connecting people, making the connection between consumers and brands is what Sunny, does best. As a conversion driven marketer, He is passionate about helping businesses expand their online visibility and reach their goals via Facebook, Instagram, Twitter, LinkedIn, and Native Ads.

May 25, 2020

If you are already running Google shopping ads then you must be familiar with Google Merchant Center, most of the people these days use some third-party tools or plugins to add a feed from store to merchant center. In this post today we will learn how we can manually enter the product data to the merchant center using Google sheets.

With uploading data manually you have full control over the product information and it’s quite easy with a spreadsheet interface.

1. Log into your Google Merchant Center

2. Go to Products > Feeds and  then click on the plus symbol in the blue circle as shown below:

Google merchant center feeds

3. After this you will be asked to set up your feed here you need to select Google sheet as your primary feed.

Google merchant center feeds

4. The next step is to register on Google Spreadsheet. Select “Generate a new Google Spreadsheet from template”.

If you select upload schedule in optional settings you will prompt Google to regularly update your inventory overwriting anything that you update through your online store.

Google merchant center feeds

5. After you click continue, Google Sheet will be created from the template and you can find a link to this sheet in your merchant center.

Product feeds

6. This sheet has a few tabs at the bottom which you should review carefully.

Google Doc

7. On the sheet you will need to fill out product information. For product data specification you should follow these details .

Id : Product Id is your SKU ( Stock Keeping Unit) which should match exactly on your eCommerce store and other marketplaces to ensure proper syncing .

Title:  Here you should add your product name, you can add distinguishing attributes such as color and size here but don’t try to add promotional text here. This should not be any longer than 150 characters.

Description: This should be no longer than 5000 characters. Try to add information that only describes your product. Don’t try to include promotional text, store links, or any accessories details in this field.

The other information you will need to add is the link of the product on the store, availability in the stock, price, and condition of the product.

8. Go back to your feed list and click on the name of your sheet. In a single merchant center account you can have multiple feeds.

Google merchant center feeds

Click on fetch now and you can now manually transfer data from the Google Sheet to the Google Merchant Center.

Google merchant center feeds

Adding Google Product information through Google sheet to Merchant Center takes time if your store has hundreds of products. But to optimize product data in bulk this is the best and easiest way. Here at ROI Minds we always focus on creating feed manually.


友情链: im电竞竞猜官网,im体育电竞登录-体育电竞官网 | 2022IM电竞官网注册-爱游戏IM电竞网址-在线电竞竞猜 | im电竞体育下注_im电竞体育官网网站 _ 靠谱的电竞体育竞猜 | im电竞中国官方入口 _ im电竞官方版APP下载 _ 直播竞猜电竞送88 | 新IM电竞下比赛的网址 im电竞官网登录|电竞竞猜官方网站 | im电竞百度知道-im电竞在线官网首页 电竞竞猜投注 | 新IM电竞平台首页,IM电竞注册官方网站_电竞竞猜官方 |