Google Merchants/Shopping - Create Your Data Feed (Supported file formats)

HireNishaan 1:37 PM


We currently support data feeds in the following formats:


Text (Spreadsheet) or Tab Delimited
In this format, you'll first include the attribute names in the first row (i.e., header) separated by a tab. Then starting on the second row, include the corresponding values under each attribute name. We recommend using a spreadsheet program such as Microsoft Excel or Google Spreadsheet to create this and save the file as a tab-delimited file.
Note: We are currently unable to accept a feed in the Excel file format (.xls). You can convert your Excel file to a text format before you upload it.
To see example files, please click either Tab delimited (.txt) or Tab delimited (.xls) (for viewing only, not accepted format).
Advantages:
  • Simple to create and edit if you have a spreadsheet program
  • Easier to view multiple items
Disadvantages:
  • Easier to make formatting mistakes
An example using all the required attributes would look like this:

idtitledescriptionpriceconditionlink
123-ukYellow BearA fuzzy, cuddly teddy bear12newhttp://www.example.com
XML
We support extended versions of RSS 2.0 and Atom 1.0. You can create and edit these files using any text editor, such as Notepad or SimpleText. Like HTML, XML uses tags to define blocks of content. Information about your items is enclosed within these tags, which are indicated by angle brackets.
Advantages:
  • Your site may already generate an XML file of your content
  • Including multiple values for an attribute is easier
Disadvantages:
  • May require more tech-savviness
  • Difficult to see many items at once
For example files please click the appropriate format of XML and download it. RSS 2.0 or Atom 1.
When creating your data feed, remember to save your file in one of the supported filetypes with the appropriate filename extension:
  • .txt: text
  • .xml: XML
  • .gz: Gnu zip, compressed text or XML
  • .zip: Zip, compressed text or XML
  • .bz2: Bzip2, compressed text or XML
If you're unsure of your file's format, please select the Autodetect option.
If you are scheduling your data feed, please ensure that the feed URL directly points to your feed file. If it points to your website instead, your item information will be fetched in a HTML format which will result in a feed failure. The URL must begin with either http://, https://, ftp://, or sftp://. If your file requires a username and password to access, please enter the appropriate login information to allow Google to access your file.

0 Comments