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 datafeed 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 datafeed, which you import via the following link: https://data.buienradar.nl/1.0/feed/xml. However, it is also possible to use another weather datafeed.
Step 3 - Within the weather datafeed find the most relevant weather observation station
The weather datafeed 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 datafeeds contain a shared field
To add the weather data to your current import you will need to combine both feeds. In order to combine feeds there needs to be a field and a value which is the same in both feeds. The webshop datafeed and weather datafeed in our example do not contain such a field, which is why we are going to add a field to the webshop datafeed 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 linkfeed
After you have added the field to the mapping of your webshop import, we will need to create a linkfeed 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 datafeeds 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. The first feed we are going to combine is the linkfeed. 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. You can now add the weather data feed and 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. In this feed also make sure the field "id" is set to "do not import" otherwise your product ID codes will be overwritten!
Step 7 - Enjoy your handiwork!
After adding the weather data feed, your Setup import overview should look like the screenshot below.