Facebook Catalogue Data Feed

This article is intended for advanced users and our partners as it requires advanced web development or Salesforce admin or programming knowledge. While the functionality is part of StoreConnect, we do not provide end user assistance to implement it beyond our help documentation. If you need help or are unsure on how to do this, you can hire one of our StoreConnect partners.

StoreConnect provides a Facebook Catalogue Data 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 Facebook Catalog Data Feed is a list of all products to be uploaded and kept synchronised with a Facebook Commerce Manager account.

A Facebook Commerce Manager account is the management platform for the Facebook network including Facebook Marketplaces and Instagram.

Note, we also automatically generate a Google Merchant 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/facebook.xml file on your store site.

What is the merchant_feed/facebook.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 its own separate feed file.

This file is used by Facebook to promote your StoreConnect products to the Facebook network via the Facebook Commerce Manager.

The feed generates a file that looks 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>NZ::Standard Shipping:14.95 AUD,AU::Standard Shipping:14.95 AUD</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.

Facebook 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__Search_Description_Markdown__c field if present, otherwise 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 Search Description and Summary fields on the product are 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 and are shown in a string separated by commas
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