Data Export & Feeds

Vanilo Cloud supports several export and feed formats that can be generated automatically on a schedule.

Each feed needs to be enabled and configured in the config/vanilo.json file. Once enabled, the data gets generated in every hour.

Sitemap

To enable sitemap generation, add the following entry to the vanilo.json config file:

{
  "cloud": {
    "export": {
      "sitemaps": [
        {
          "filename": "sitemap.xml"
        }
      ]
    }
  }
}

As the result of the above configuration, the https://yourshop.com/sitemap.xml file will be generated in every hour based on the categories and products in your shop.

Note that the sitemaps value is an array of objects, because you can define multiple sitemaps.

This can be useful if you ecommerce system runs multiple shops, channels or storefronts.

Example multi-sitemap config:

{
  "cloud": {
    "export": {
      "sitemaps": [
        {
          "filename": "sitemap_es.xml",
          "base_url": "https://mysite.es",
          "channels": ["spain"],
          "taxonomies": "*"
        },
        {
          "filename": "sitemap_pt.xml",
          "base_url": "https://mysite.pt",
          "channels": ["portugal"],
          "taxonomies": "*"
        }
      ]
    }
  }
}

Google Product Feed

To enable google product feed generation, add the following entries to the vanilo.json config file:

{
  "export": {
    "google_feed": [
      {
        "filename": "google_feed.xml",
        "shipping_method_id": 1,
        "shipping_country": "FI"
      }
    ]
  }
}

Google Product Feed has shipping support, which can tell the prospects the shipping fees of specific products to their countries. Having a valid shipping data is even mandatory for certain countries.

To use this feature, you need to provide the shipping (destination) country and the shipping method ID, based on which the shipping fee gets calculated for the feed.

There are certain fields required by the Google Product Feed which need to be supplied as custom attributes. Here's the reference of how each field gets populated in the feed:

XML Field	Origin
id	sku
gtin	gtin - if specified, omitted otherwise
title	custom_attributes.google_feed.title
description	custom_attributes.google_feed.description
google_product_category	custom_attributes.google_feed.category
brand	custom_attributes.google_feed.default_brand
availability	in_stock, out_of_stock or backorder (depending on the stock field)
price	price
identifier_exists	yes if GTIN is available, no otherwise
color	If the product has a color property, its label will be used
material	If the product has a material property, its label will be used
pattern	If the product has a motif property, its label will be used
item_group_id	The id of the master product in case of product variants