Google Merchant Feed

StoreConnect supports Google Merchant Feed automatically via an automatically generated XML file. To make your feed1 active you only need to ensure your products meet the necessary prerequisites below.

The Google Merchant Feed is a list of all products to be uploaded and kept synchronised with a Google Merchant Center account.

A Google Merchant account is the management platform for the Google Shopping network, a Google-hosted marketplace for many types of products.

Note, StoreConnect also automatically generates a Facebook Merchant Catalog Data Feed.

Prerequisites

To have a product show up in the merchant feed, the following must be true of each product:

  1. It must be active
  2. It must not be deleted
  3. It must have an available on date in the past
  4. It must have no discontinued at date or if present, it is in the future
  5. It must have “Sync to Google” selected in the product page
  6. It must have a price greater than $0
  7. It must have an image
  8. It must have a meta title
  9. To show shipping, it must have shipping options defined

Once all requirements have been met, the product will show up within 6 hours in the /merchant_feed/google.xml file on your store site.

What is the merchant_feed/google.xml file?

This is a file StoreConnect automatically generates once a day and is accessible via the below URL. When downloading, use your browser’s ‘Private Mode’ to ensure you get the most current version otherwise you could be downloading an older version from your cache.

https://store.example.com/merchant_feed/facebook.xml

Note, each store will have it’s own separate feed file.

This file is used by Google to promote your StoreConnect products to the Google Shopping network via the Google Merchant Center.

The feed generates a file that look like this:

<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">
  <channel>
    <item>
      <g:id>01t2u0000003ubFBAQ</g:id>
      <g:title>Our Amazing Product</g:title>
      <g:google_product_category>Electronics &gt; Video &gt; Televisions &gt; Flat Panel Televisions</g:google_product_category>
      <g:product_type>Consumer Electronics &gt; TVs &gt; Flat Panel TVs</g:product_type>
      <g:link>https://store.example.com/products/your-product-slug</g:link>
      <g:image_link>https://image-link.example.com/example.png</g:image_link>
      <g:condition>new</g:condition>
      <g:availability>in stock</g:availability>
      <g:price>799.95 AUD</g:price>
      <g:sale_price>699.95 AUD</g:sale_price>
      <g:brand>Product Brand</g:brand>
      <g:mpn>PRODUCT-CODE</g:mpn>
      <g:description>If you're looking for an &gt;em&lt;LED TV&lt;/em&gt;, this is the one to buy. It's an impressive model that offers great picture quality &amp; performance, as well as a ton of extra features. It looks fairly sleek &amp; will not stick out when wall-mounted.</g:description>
      <g:shipping>
        <g:country>AU</g:country>
        <g:service>Regular Australia Post Shipping</g:service>
        <g:price>10.00 AUD</g:price>
      </g:shipping>
      <g:shipping_weight>0.2 kg</g:shipping_weight>
      <g:shipping_length>21 cm</g:shipping_length>
      <g:shipping_width>15 cm</g:shipping_width>
      <g:shipping_height>4 cm</g:shipping_height>
    </item>
  </channel>
</rss>

The following table shows which attributes set each field.

Google Field StoreConnect Field
g:id Shows the Product2 Id field
g:title Shows the Product2 s_c__Display_Name__c or if blank, the Name field
g:google_product_category Generated from the s_c__Google_Product_Category__c fields on the nested product categories of this product
g:product_type Generated from the s_c__Display_Name__c or if blank, the Name fields on the nested product categories of this product
g:link Created from your Store Domain name plus the products sub path and the Product2 s_c__slug__c field
g:image_link The public link to the first Product2 Media item sorted by the Media.s_c__Position__c field
g:condition Shows the Product2 s_c__Condition__c field
g:availability Shows In Stock or Out of Stock depending on stock level. Always “In Stock” unless Product2 s_c__Track_Inventory__c is checked
g:price Shows the Store Pricebook entry price for this product with the Store Currency
g:sale_price Shows the Store Pricebook entry s_c__sale_price__c for this product with the Store Currency
g:brand Shows the name of the associated Brand on the product (an Account object) if defined
g:mpn Shows the Product2 s_c__Supplier_Code__c field
g:description Shows the contents of the Product2.s_c__Summary_Markdown__c field. This field is first parsed through a liquid filter and then converted from Markdown to HTML (keeping any HTML in there). The field then has any tag that is not supported by Google Merchant feed listed at https://support.google.com/merchants/answer/6324468 removed and line breaks inserted as appropriate. If the Summary field on the product is blank, StoreConnect will attempt to put the brand, name and meta description into this field separated by hyphens.
g:shipping Shows any shipping options available for this product, there can be more than one shipping option depending on your StoreConnect configuration
g:shipping:g:country The country code that this shipping set relates to, is taken from the Zone Country of the Shipment object and sent as a 2 letter country code
g:shipping:g:service The shipping name
g:shipping:g:price The price of the shipping with the Store currency code
g:shipping_weight Shows the s_c__shipping_weight__c field of the product with the s_c__Shipping_Weight_Unit__c
g:shipping_length Shows the s_c__shipping_length__c field of the product with the Shipping_Dimensions_Unit__c
g:shipping_width Shows the s_c__shipping_width__c field of the product with the Shipping_Dimensions_Unit__c
g:shipping_height Shows the s_c__shipping_height__c field of the product with the Shipping_Dimensions_Unit__c

 


 

  1. Feed: A ‘feed’ is a file containing information necessary to provide up-to-date content as soon as it becomes available. As the information changes, the ‘feed’ will update accordingly. This ‘feed’ is used by social media and shopping platforms to maintain up-to-date content information. 

 

 
Back to Documentation