Google Product feed

The following steps outline how to get a Google Product feed integrated in Content Studio to be able to browse and select products.

What you'll need

To configure your Google Product feed integration in Content Studio you'll need the following:

• Google Product feed URL

Google Product feed limitations

Google Product feed integrations are primarily aimed at small categories, testing and demoing product data and as a result, these types of feed integrations have some limitations.

• The Google Product feed must be a public URL
• The Google Product feed must be less than 2MB in size

Setting up the Content Studio integration

• In Content Studio choose the Commerce Repositories icon and click "Add Commerce Repository"
• Choose "Google Product feed" from the dialog options and add the integration.

Expand the section labelled "Edit default mappings" to see the initial configuration. In most cases you will not need to change the default mappings, but if you do then you'll need to follow the steps in the Updating the default mappings section.

Using your feed

Once the integration is set up, your product data is available to browse and add when using Content Studio templates such as "Rewrite product description".

Google Product feed example

An example Google Product feed is hosted at the following URL.

https://amp-product.s3.eu-west-1.amazonaws.com/content-studio/commerce-repository/product-feed-examples/products-google-feed.xml

The data structure is as follows (showing one product):

<?xml version="1.0"?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
  <channel>
    <title>Example - Demostore Store</title>
    <description>This is an example of a Google Product Feed</description>
    <item>
      <g:id>e3b5c192-2f17-433c-b73c-12a7c7e87dc6</g:id>
      <g:title>Handbag Moschino Love white</g:title>
      <g:description>Handbag Moschino Love white</g:description>
      <g:image_link>https://cdn.media.amplience.net/s/willow/079310?w=1000</g:image_link>
      <g:additional_image_link>https://cdn.media.amplience.net/s/willow/079310/2?w=1000</g:additional_image_link>
      <g:additional_image_link>https://cdn.media.amplience.net/s/willow/079310/3?w=1000</g:additional_image_link>
      <g:additional_image_link>https://cdn.media.amplience.net/s/willow/079310/4?w=1000</g:additional_image_link>
      <g:condition>new</g:condition>
      <g:availability>in stock</g:availability>
      <g:price>256.25 USD</g:price>
      <g:shipping>
        <g:country>US</g:country>
        <g:service>Standard</g:service>
        <g:price>7.99 USD</g:price>
      </g:shipping>
      <g:gtin>123456789123</g:gtin>
      <g:brand>Demostore</g:brand>
    </item>
  </channel>
</rss>

Example mappings

The JSON path mappings for the attributes are shown below:

Attribute	Mapping
Products	$.rss.channel.item[*]
ID/SKU	$.g:id
Name	$.g:title
Description	$.g:description
Images	$[g:image_link,g:additional_image_link]

Updating the default mappings

If you choose to update the default mappings for your Google Product feed then you'll need to do the following to verify the JSON paths.

• Convert the Google Product feed file (in XML format) to JSON using a tool such as the XML to JSON converter. You will still import your feed in Google Product feed format, the conversion to JSON is only required to configure the JSON paths required in the "Add Commerce Repository" dialog.

• Use a JSON Path evaluator such as the JSON Path online evaluator to determine the JSON paths for your feed.

Related pages

Content Studio- generating content