Adding weather data to your import

Step 1 - Import your webshop datafeed in Channable

In our example, the webshop data feed is called "Webshop". For more info on how to add your webshop data in Channable, check out our import support article.

Step 2 - Search for a weather data feed on the internet

Here we use the Dutch Buienradar data, which you import via the following link: https://data.buienradar.nl/1.0/feed/xml. However, it is also possible to use other weather data feeds.

Step 3 - Within the weather data find the most relevant weather observation station

The weather data will likely contain several weather observation stations that contain different data. Select the station for which the data is most relevant to you. In this example, we chose "Meetstation De Bilt".

Step 4 - Make sure that your webshop and weather data feeds contain a shared field

To add the weather data to your current import you will need to combine both feeds. To combine feeds there needs to be a field and a value that is the same in both feeds. The webshop data feed and weather data feed in our example do not contain such a field, which is why we are going to add a field to the webshop data feed import.

We have chosen to use the field "stationnaam" as a shared field, but you could also use another unique identifier field like "stationcode". Add this field to your project by going to Setup > Setup project fields, scroll down, and click on ''Add project field'' in the left bottom corner. You will see the following screen, fill in a name, and click "Save & import''.

Step 5 - Create a link feed

After you have added the field to the mapping of your webshop import, we will need to create a link feed to ensure the field is filled with the correct value. You can create a new XML export feed for this.

Within this feed, you will need to set up a rule which gives the "stationnaam" field the value of the chosen weather observation station, in this case, "Meetstation De Bilt".

After creating and saving the rule, you can set up the Finalize step by including the fields "id" and "stationnaam".

Finally, in the Preview step get the feed file URL, you will need this for the next step.

Step 6 - Combine the three data feeds in the Setup

You now have three feeds, your webshop datafeed, the weather datafeed, and the linkfeed. In the Setup tab, you will need to combine these three feeds.

1. The first feed we are going to combine is the link feed. Fill in the feed file URL and in the mapping under "More options" choose "Combine on Field" to combine the imports on the field "id".

   

   Now you should have two imports in your Setup import overview, your webshop data feed and the linkfeed.
2. You can now add the weather data feed. Make sure to combine the feed in the mapping on the field "stationnaam" so that all data of the "Meetstation De Bilt" will be added to your items.

   

Step 7 - Enjoy your handiwork!

After adding the weather data feed, your Setup import overview should look like the screenshot below.