07. Manual: DataFeed to RSS Converter
Posted by Mark Seaman on 02 March 2010 07:14 AM
By RSS Ground service.
To Convert your Data feed to RSS feed you need to go through three steps.
On the first step upload your datafeed to the Converter.
Note: only CSV or TXT files not bigger than 32 MB are allowed.
Import from file - Press "Browse" button to upload datafeed from your computer.
First row contains field titles - this is a default setting and it is correct for most datafeeds. It interprets content in the first row as field names.
If you know that this is not the case if your datafeed uncheck this option.
Press "Next" to move the second step.
Assign field names
To better understand what to do on this step you should remember that datafeed is a number of products with several descriptive fields regarding each one of them. If datafeed was parsed correctly you will see a table with information regarding ONE product from your datafeed.
In this table you see "Fields titles" column with a list of field names and "Sample records" column with data regarding each field.
Note: Leftmost column is a record number of a filed from the feed. You may notice that some numbers are missing. That means that some fields were empty and were ignored by the program.
As it was said the table shows information regarding just ONE product while there could be hundreds and thousands of them in the feed. You need to set this product as a sample for the rest of them.
What exactly we are doing here?
As you probably know RSS feed consists of items. It is similar to datafeed which consists of products. In its turn each RSS item consists of several elements. A list of datafeed fields is like a list of RSS item elements elements. And now we need to assign each datafeed field to a certain RSS item element.
This may seem confusing but you shouldn’t worry about this. We have already assigned standard datafeed fields (rightmost column) to standard RSS item elements. You just need to compare and assign fields from your datafeed to our standard fields.
So, now you pay attention to the "Fields titles" and description in "Sample record" column and choose a name for this field from "Assign to fields" column (use drop-down menu).
In drop-down menu you see three groups of standard field names: required, recommended and optional.
To convert datafeed to RSS you need to assign at least two required fields: "Name/Title" and "Link/Buy URL". Other fields you may use at your discretion.
Note: all fields from the rightmost column should be unique. You can assign them only for one field from your datafeed.
Use "Feed preview" button to see how your RSS feed will look like.
Among optional field names you will see "Extra Field 1" and "Extra Field 2". If you think that offered field names are not enough for your datafeed you may choose these extra filed names. You will be able to name them whatever you want on the further step.
Press "Next" once all fields are set up.
On the last step you see three tabs with setting options.
Number of RSS items to show – set how many products you wish to include in your RSS feeds. It may be not more than 50. If there are more than 50 products in your datafeed they will be rotating with every refresh of the RSS feed.
Now you need to set up RSS channel. Channel is one of the components of every RSS feed. It contains information about content provider, link to the provider’s website and short description RSS feeds content.
Press "Next" to go to the next tab.
Product Image Location – here you choose the way you want to place product image in the description:
Select "Buy Now" button – you may add "Buy Now" button to each product description. This button will be automatically converted in to "Buy URL" link. If you choose "None" product title will be converted into link to order page.
Click here to edit description layout HTML – if you feel yourself comfortable with HTML editing you may choose this option to edit description the very way you want.
Description layout HTML
Here you can change the order of fields in description, place product’s image anywhere you want, use your custom "Buy Now" button and all the other editing with HTML. You can also rename fields including "Extra Field 1" and "Extra Field 2".
We do not recommend using styles and Java Script here. They will not function in RSS feed as they will not be read by RSS feed readers.
Use "Preview feed" to see the changes in your RSS feed.
Press "Next" to move on.
An average datafeed may contain hundreds of products. Products may refer to different categories, to different vendors, may be of different price ranges. It is obviously that filters will be a help to sort out all products and include in RSS feed only the most targeted.
Containing keywords – only products which contain these keywords in title or description will be included into RSS feed. And if you choose
Excluding keywords – products containing these keywords in title or description will be ignored.
This is how you can for example choose to show products of a special vendor or exclude products of a certain category or simply include/exclude products with any keyword in title or description.
Note: use comma to separate several keywords for Containing/Excluding keywords.
With price from/to – filter products using price range. If you need products with a specific price use the same price in From and To fields: for example From: 100 To 100 – this will show products which cost 100 only.
Now comes a very important feature. In affiliate datafeeds all "Buy URLs" contain a tag with affiliate ID. It can be already inserted or needed to be inserted manually. Affiliate links can also include someone else’s affiliate ID. To insert your affiliate ID into affiliate links you can use "Search and replace" feature.
Here is an example of a "Buy URL" used in datafeed:
If you wish to insert your Affiliate ID in all "Buy URLs" you do as follows:
Search in every URL: affilaitateID-xxx
Replace it with: affilaitateID-myaffiliateID
You may replace any part of "Buy URL" in such a way.
But be very careful with this option. A minor mistake can make links not valid.
Also remember that in most cases before using affiliate datafeed you need to be approved by vendor. Otherwise you will not receive your commissions. So before using any datafeed make sure if you can use your affiliate ID without vendor’s or provider’s approval.
Don't forget to use "Preview feed" option to see changes in your RSS feed.
Press "Generate feed" button when you are all done.
Here is an example of RSS feed URL you will receive.
Note: when the feed is generated you may find it in "My Saves" – "My RSS feeds". Use "Edit" icon to get to the last step settings and update your RSS feed using different filters.
Remember! When you edit your already generated RSS feed you will be able to work with products already filtered for this RSS feed.
For example if you set Include products from a given vendor you will be able to work only with his products. And if you wish to generate RSS feeds with other products you need to go through all the steps all over again: upload your Data feed, assign fields and set filters.
Send feed to – choose a tool from drop-down menu you wish to transfer your RSS feeds to. It can be RSS Feeds to Code Converter, RSS to Twitter Poster, RSS to Wordpress Poster or RSS to Blogger Poster.
Now let’s see how the features used in our settings work in the generated feed.
Also pay attention to the "Buy Now" link where our affiliate ID was embedded
Here is the list of useful links you may also be interested in:
In case you are an unregistered visitor, please see RSS Ground offers page: