To upload product data to Google Merchant Center, you first need to include it in your feed and register it with our service. When downloading or updating this file again, run last action not required.

Feed merging

You can create an additional feed and combine it with the main one using the id [identifier] attribute.

Example

Main feed:

Merged feed:

id [identifier]	title [name]	price [price]	brand [brand]	custom_label [seller_label]
1	shirt	34	Grade A	SALE
2	boots	55	Brand B
3	hiking boots	100	Brand B
4	trousers	75	Grade A	SALE

Main feeds

The main feed is the data source required to display ads with your products. If the information in it matches our policies and specifications, you won't need to do anything else after you download the file. If there are errors in it, they can be corrected using advanced features in Merchant Center, such as additional feeds - they are designed specifically to supplement or change product information.

Use master feeds when you want to apply conversion rules, add or remove data, or target by country or language. You can only include or exclude products using these feeds.

How to create a main feed

• Country of sale. This is the region or state from which your products will be sold to users. All information provided about the assortment must comply with the requirements for the selected country of sale, including specifications and service rules. To change countries after uploading, click on the feed name and open the "Settings" tab.
• Language. Indicate the one that contains your information about the product. For target countries where residents speak multiple languages, such as Canada, Belgium and Switzerland, lists are provided from which you can select the desired option.
• Feed name. Provide a title that describes the content of the main feed. It may not match the name of the downloaded file.
• Data loading method. There are several options:
  • Google Sheets. You can use our template or upload your own table. Read more...
  • Scheduled.
  • Scanning the site. If you don't have feeds in your account and you've added the appropriate structured data to your site, Google will crawl your site pages and upload product details to Merchant Center.
• File name.

Once you have filled in these details, click "Continue". The created feed will appear in your Merchant Center account under the "Feeds" tab.

Treatment

Additional feeds

They are needed in order to change data about products included in the main feed. You cannot add or delete positions using them. Using one additional feed, you can update several main ones.

To apply an additional feed, you need to link it to an existing main feed through the id [identifier] attribute. In this case, product identifiers must match in both files, otherwise the data will not be updated.

Online assortment update
You can change pricing and availability information in the main feed using additional feeds. In this case, you need to apply the “Use last value” rule.

How to create an additional feed

Additional feeds are not independent sources of data and are needed to add mandatory and additional attributes to the main feed. Here's an example of what you can do with them:

• add or edit seller tags for campaign management;
• add or change promotion IDs;
• change product names;
• exclude certain positions using the excluded_destination [excluded_services] attribute;
• add missing GTIN codes;
• add information about .

Any additional feed must have at least two columns: one with the id attribute and one with the updated data.

To create such a feed, in Merchant Center, select “Products” in the left menu, open the “Feeds” tab and click Create an additional feed. Follow the onscreen instructions and provide the following information:

• Name of the additional feed. Enter a descriptive name that will help you identify this feed later. It does not need to be the same as the name of the downloaded file.
• Input method. There are three options:
  • Google Sheets. You can use our template or upload your own table.
  • Scheduled. Feeds hosted on your server will be downloaded automatically.
  Files can be added to Merchant Center via SFTP, FTP, Google Cloud Storage or send from your computer.
• File name. You may need to enter a name for the file you are sending. It must exactly match the name of the created file and include a valid extension.
• Link to the main feed. Select the primary feed you want to link the secondary feed to and select the appropriate country and language.
• Schedule. So that you don't have to update product data yourself, set the frequency of downloading it, and this will happen automatically.

To download data manually, click on the name of the desired feed, then on the menu icon on the tab Treatment and select the appropriate option.

When you create an additional feed and link it to the main one, a rule will appear in the Feed Conversion Rules tab that will combine the data from these two files based on the id attribute.

Was this information useful?

How can this article be improved?

When realtors are faced with a growing volume of real estate listings, organizing and storing listings becomes a labor-intensive process. Many people are starting to order a real estate website and publish their ads on it.
But we all know that for effective sales it is necessary to publish your ads on popular real estate platforms, such as Avito, Cyan, RBC, Dmir, GdeThisDom, etc.

Each real estate website has its own requirements for advertisements, their placement and updating. And given the growing volume of your ads, manually placing ads on all popular sites is becoming a very labor-intensive task.

And here automation of the process comes to the rescue, namely uploading your advertisements to a file in the format that the real estate site accepts.

So XML uploading is exporting your real estate listings in XML format and within an XML file structure that another popular real estate site understands.

What is Feed

A feed is the same as an XML upload for real estate portals. It’s just that this meaning of the word is used on a par with XML upload.

How to connect XML upload/feed

The site has a tab "Import from XML feeds". Here you can add your uploads of Yandex.Real Estate, Cyan, Avito, RBC, Hand to Hand, OLX, AFY, Quadrum, Mail.ru, Winner and other popular real estate portals.

Your advertisements will be automatically updated every day on our real estate portal; when new advertisements appear, they will be automatically published immediately.

How to create an XML upload/feed

If you want to download your advertisements (for example) from our real estate portal website in one of the formats XML upload for sites Yandex.Real Estate, Cyan, Avito, RBC, From Hand to Hand, OLX, AFY, Quadrum, Mail.ru, Winner and others, then this is possible!

This post will be useful in solving the work problems of PPC specialists. I will tell you step by step about carrying out three cases when it is not possible to connect a developer to the project;)

Case No. 1: The tag has been implemented on the site Adwords remarketing with dynamic parameters. There is a feed that is downloaded from a link, but is not updated automatically, which means it is irrelevant.

Case No. 2: The site has implemented a remarketing tag with dynamic parameters. The feed is updated automatically, but some of the data in the feed is incorrect or missing, which means some feed elements will not be approved. Any data can be incorrect: broken links on images or products.

Case No. 3: There is no feed or Adwords remarketing tag.

1. Case No. 1

In this case, we need to create the feed from scratch. So let's get started.

For the feed we need the following columns:

• Item title
• Item subtitle
• Final URL
• Image URL
• Item description
• Price
• Sale price

Remember that not all columns are required. You can learn more about the features of the Google Adwords feed.

We will obtain the values ​​for the feed using the parsing tool in Netpeak Spider.

1.1. Parsing IDs and prices for a dynamic feed

After starting parsing with these settings, we will receive script code for each page of the site, which contains ID and Price data for our product catalog (feed).

All that remains is to divide the information received into 2 columns.

Here's how to do it using formulas in Google Spreadsheets:

Using the same principle, using parsing (you can use both XPath queries and CSS selectors), we can get all the other columns. You just need to correctly set the query in the XPath language in the parsing settings for the corresponding elements on the product card page. Next, let's look at a few more examples of data extraction.

1.2. Image URL

Set in the parsing settings:

Parsing result:

1.3 Final URL

This is our default URL field. There is no need to configure anything in the parsing parameters; the URL value will be in the table.

1.4. Item title and Item description

To fill the Item title and Item description, you can use the values ​​of the Title and Description meta tags of the page. To do this, simply check the appropriate options in the sidebar.

Of course, this method will work provided that the meta tags are filled out correctly on the site. IN Item subtitle you can specify the domain address.

1.5. Sale price

If there are promotional products on the site, you can set them in the settings additional rule to retrieve the price of a product with a discount (parameter Sale price in the feed).

The element whose value needs to be retrieved:

In our case, this is an XPath query copied like this:

And we got this result:

//*[@id="product-price-4005"]/span

Initially, I did not parse the discounted product price value we needed. Therefore, the correct XPath query was manually written and specified in the settings:

//p[@class="special-price"]/span[@class="price"]

This happens quite often. I recommend learning the basics of XPath syntax. Parsing will become much easier ;)

Basically, these are all settings. As a result of parsing you will get 2 tables:

Now all that remains is to combine both of these tables into one. You can do this using the QUERY function in Google Spreadsheets. I recommend reading it.

We have also prepared a document with an example of how this can be done. Copy it for yourself before work. The Query function is located on the “Feed Adw – step1” tab in the cells of column E:

2. Case No. 2

The situation is similar to the first case. If you are creating a feed from scratch, then follow all the steps according to the instructions above.

If you don’t need to create a catalog from scratch, but just need to supplement it with some data (for example, add a column that is not in the original feed), or correct the values ​​of links in the Image URL column, the task becomes easier.

Parse the required data from the list of URLs from the source feed and supplement it with new data (again using the QUERY function to match the values ​​from the two tables).

3. Case No. 3

The difference in this case is that the site does not have a remarketing tag, and ID and Price data cannot be taken from dynamic parameters. The problem is solved in 2 stages:

1. We parse the data according to the instructions above with the only difference: we use the article/code on the product card as an ID for the feed elements. We also pull Price from the product card.
2. We configure the Adwords remarketing tag using Google Tag Manager ourselves. To a variable dynx_itemid We transmit the article/code on the product card. Thus, the main task is to ensure that the ID of the element in the feed matches and dynx_itemid on product card pages.

This option is the most difficult and I hope that you will not find yourself in this situation. We will not consider it. Better find a developer =)

Let's sum it up

Creating a dynamic remarketing feed from scratch can be a daunting task for PPC professionals. However, this process can be made much easier by scraping data in Netpeak Spider. Following the instructions in this post, simply extract the following required elements:

• Item title
• Item subtitle
• Final URL
• Image URL
• Item description
• Price
• Sale price

And be sure to tell us in the comments what solutions you use for the cases I presented;)

In which countries is it available and how to set it up. In this post I will show one way to create and upload a data feed. This is an important stage in preparation for the launch of Google Shopping.

How to choose a feed file format

Data feed - information about the products you want to sell, compiled in a format that Google can understand. Google crawls your feed and determines whether the product or products match a specific search query. Needs to be structured various elements your feed, otherwise Google won't consider it relevant.

There are two main ways to create a feed:

TXT - text format(spreadsheet) or tab-delimited format.

You can create it in Microsoft Excel or Google Spreadsheets. A simple and clear feed format, in the first line of which you should indicate the names of attributes, separated by tabs. The second contains the values ​​of these attributes.

XML - Text Document with XML extension.

A more complex method that requires technical knowledge. Wherein XML file with the necessary data you can create it directly on your website. Another advantage of the format: it is easier to specify several values ​​for one attribute, which means it provides more accurate information about the product.

Important: Google does not support XLS or CSV feeds. Before adding such a file, convert it to text format.

If you have multiple products, you can create your feed manually using Google Sheets. Hundreds or thousands of products? Manually is not an option. In my case, there are few products, so I made the feed in text format.
On topic: you can create a feed using Netpeak Spider.

Required feed fields

Regardless of how you create a feed: using an application or manually, follow the rules for filling out fields (attributes). The important thing here is to maintain consistency and meet the submission requirements. If you mess up, Google will reject the feed or, in the long run, your clicks will become much more expensive.

Attribute	Description
id [identifier]	unique product identifier (no more than 50 characters)
title [name]	product name (no more than 150 characters)
description [description]	product description (no more than 5000 characters)
availability [availability]	availability of goods in the store Valid values in_stock [in_stock] out_of_stock [out of stock] preorder [pre-order]
price [price]	product price (Syntax - number, formatting in accordance with ISO 4217 standard)
condition [state]	product condition

I note id [identifier] andlink [link] - attributes that are set by default. We will have to tinker with filling in other required attributes, but our efforts will be rewarded.

The product title must be descriptive and accurate, otherwise Google will have a hard time knowing when to show your ad. Here's a good example:

Use these six tips to create a clear product name:

• add keywords. What keyword do you want to show your product to the user? Take it in the title;
• use the product name. Obviously? However, not everyone does this;
• use color, brand, size to differentiate. Long queries usually indicate a desire to buy. The one who types in the search bar “ Apple iPhone 8 Plus 64GB Gold" is more interested in purchasing than someone who dials "phone". Create a detailed title to appear as relevant as possible;
• important first. Put the main points at the beginning. For example, if you sell baby food, users search for it using a similar query. Call your product “Baby food from the first days of life. Only high-quality products”, and not “Only high-quality products for babies. Baby food from the first days of life";
• model number and other elements of the product description. Perhaps you yourself often search for the product you need by indicating the model year or edition. Yours potential clients they do that too;
• use up to 150 characters. I don’t know the ideal length for a product name, but I do know that the more detailed the better.

Product Description

To determine which keywords will trigger advertisements, Google carefully examines product descriptions. Write the description incorrectly and you will miss out on valuable clicks. Make sure it is informative.

Lodge Cast-Iron Product Description:

Five simple tips to create a correct description:

• Imagine yourself in the client's place. Consider what the buyer needs to know to make a purchase;
• concise and precise. Laconically describe all information useful to a potential buyer;
• include the most relevant attributes. This could be the size of the product, the expected age of the buyer, special features of the product, technical specifications;
• the most important information about the product - to the beginning. Would you like to look for the necessary characteristics in the text?;
• watch your grammar. It's hard to concentrate on reading when your eyes are constantly tripping over errors in the text.

Google Product Category

Google uses this attribute to identify your product as accurately as possible. Select categories— a mandatory step in creating the right search queries.

Example:“Electronics” - “Audio systems” - “Accessories for audio systems” - “Accessories for MP3 players.”

If you're having trouble finding the right Google product category, then your own typing becomes especially important. While this is not a required part of your feed, I recommend making the most of it. Why? The more detail you provide, the easier it is to gain visibility and adjust bids at the detail level.

Use your site or category taxonomy. Look at the product page, there are these category layers:

This could be a great type of product. Simply copy and paste the layers into your product type field in the feed.

If a site's taxonomy isn't described and you don't find it useful, add your own layers. Just remember that the main thing in a product type is visibility.

Image

The image is the most important reason for people to click on your ad. If the images are of poor quality or blurry, it can turn off potential buyers.

Make sure you have three or more photos good quality for all products.

• each image must provide the client Additional information about the product: relative size, how to use the product, its target buyer;
• people love clothes and accessories look from all sides. Give them this opportunity;
• The main image of the product must include a clear product view on white background;
• Visible in miniature. If buyers can't view your product, don't expect many clicks.

Price

Typically, it is the price that influences the click on a product. When you have a unique product and it has obvious advantages over competitors - more high price will attract the right clicks.

Brand

Regardless of whether you are selling your own or reselling someone else's branded product, the brand must be indicated. Why? Most often, people who buy a product are those who search for a product by brand name.

Availability

Please ensure that this information matches what is stated on the website. Not only will a potential buyer be disappointed to discover that the item declared “in stock” is not available, your item simply will not show up in the results Google search Shopping.

Condition

The condition of the goods can be new (new), used (used), restored (refurbished). Please note that refurbished (refurbished) products may not be sold in all countries. More about the "condition" attribute, examples of padding can be found in the Merchant Center help.

To increase the effectiveness of your ads, I recommend using additional attributes. Of course, your ads may already be running and competing with others, but with additional elements they will become more informative and attractive:

• additional_image_link [additional_image_link];
• mobile_link [mobile_link];
• availability_date [arrival_date];
• expiration_date [expiration_date];
• sale_price [discount_price];
• sale_price_effective_date [discount_validity_date];
• unit_pricing_measure [item_quantity];
• unit_pricing_base_measure [item_measurement];
• product_type [product_type];
• identifier_exists [has_identifier];
• energy_efficiency_class [energy efficiency_class];
• material [material];
• pattern [pattern];
• item_group_id [product_group_identifier];
• adwords_redirect [adwords redirect];
• excluded_destination [excluded_services];
• included_destination [enabled_services];
• custom_label [seller_label].

To add an additional feed, go to the Merchant Center in the Products section and select the Feeds tab. Enter the data in the same way as the main feed.

Google Sheets is an easy way to create a feed when products are always in stock and the assortment remains virtually unchanged. Set up a data download schedule depending on the frequency of updating product information on your website.

You can also install the Google Merchant Center extension. With its help, feeds are created, verified and sent. The extension must be linked to a feed from Merchant Center so that information is sent to the tables and vice versa, sent to the system. The add-on allows you to:

• scan the entire table or selected rows on demand;
• use microdata for automatic update values;
• check attributes in a spreadsheet;
• view processing errors and warnings;
• upload feed to Merchant Center;
• view Merchant Center processing results.

(according to schedule) - the most convenient way, but only if you have xml configured correctly. If the feed is not recognized, you can transfer it to Excel and follow the first path.

. In this case, you will have to upload the feed manually at least once a month. I recommend that you first upload the feed as a test one - any errors identified will not affect the operation of your account. To do this, at the first step of loading the feed, check the box next to the “Test” type. Feed processing time is usually 5-10 minutes, depending on the number of products. To view information about a feed after uploading, click on its title. If errors occur during adding and processing, they will appear on the Diagnostics tab.

How to check product details

You can check product details in the main feed:

1. Select the main feed you want to check.
2. Click on the three dots icon on the right side of the tab "Treatment".
3. From the drop-down menu, select "Upload file."

1. Check the box "Upload file in test mode".
2. Check to see if any errors or warnings appear.

As you can see, creating feeds is not difficult. It just takes time to figure it out. I hope I helped you with this.

Use Google Shopping and get more conversions.

conclusions

1. To create a main feed, select a file format.
2. Fill in the required fields: title, description, link, image_link, availability, price, condition.
3. Recommended feed fields are needed to improve your ad performance. With additional elements they will become more informative and attractive.
4. Additional feeds are not independent sources of data and are needed to add mandatory and additional attributes to the main feed.
5. To create an additional feed, use Google Sheets. Google extension Merchant Center, auto-download from the site, or download data manually.

A fifth of US users use iGoogle as their home page. You can place an "Add to Google" button on your site so that people will take your selected content to iGoogle and view it every time they visit home page.

The Add to Google button allows you to focus users' attention on specific content (interactive apps, feeds, links to your website, etc.) and makes it easier to add content to . By adding your content to iGoogle, users will be able to see it every time they visit your home page. Active users set up automatic redirection to iGoogle when logging into Google.com. Therefore, popular feeds or gadgets that link to your website can significantly increase traffic to your website over time.

2. How to add a button to the site?

To generate HTML code for your site, use this form. Be sure to choose the right content type: feed or gadget. Enter the URL of the feed or gadget, click "Generate HTML", copy the resulting text and paste it into the website code.

If you want to use multiple gadgets or feeds, select the "Multiple" option. This will create new tab for iGoogle, where your gadgets and/or feeds will be located.

3. How do you know if the button works?

To check if a button added to your site works, click on it and follow all subsequent steps. If your content appears on or in Google Reader, then the button works as expected.

4. What are feeds?

If your site is updated frequently, such as if you have a blog or publish news, using a feed can help keep users updated latest updates on your website. A feed is a specially formatted version of content posted on your website. Feeds are available for automatic reading. This means that feed readers and aggregators can automatically show your users the newest content, as well as update alerts.

5. What are gadgets? How to create them?

Google Gadgets API allows you to create gadgets that are more functional than feeds. Turn your web content or app into gadgets that users can add to their . You can use additional functions to change the font, page color, and other settings. The Google Gadgets API provides maximum flexibility and ease of use and requires no download.

6. How to create a feed for my website?

Most blog hosting services make it easy to create a feed. For more information, check out the help on relevant sites (such as Blogger, LiveJournal, or Typepad). You can also create personalized feeds using Google News and Google Groups. If you're hosting your website yourself, there are many guides you can use to create feeds, such as Danny Sullivan's guide.

7. How do I add a badge to my feed?

Most gadgets have Google directory There are icons depicting their functions. You can also assign a badge to your feed. The best size for this icon is 120 pixels wide by 60 pixels high. Google will download the image, resize it to 120 x 60, add padding if necessary, and host the image on the Google.com server for greater efficiency and reliability.

The syntax may vary depending on the feed format you are using. Below is an example of how you can add icon information for an RSS feed.

http://www.google.com/









http://www.google.com/

Example for Atom:

type="text/css"?>


A nice long description of your feed.
http://www.google.com/ig/gadgets/sticky-thm.png

8. What feed formats are supported?

There are many popular feed formats. We currently support Atom (versions 0.3 and 1.0) as well as RSS (versions 0.91, 0.92, 1.0 and 2.0).

9. I still don’t understand everything. Where can I get more support?

Contact us if you have any questions or need help placing your Add to Google button.