Basically if you're an Amazon affiliate you can use their affiliate feeds in the Squidoo RSS modules - I think this would be ideal for the sidebar which means I have a lot of work to do next week.
There appears to be a couple of ways of getting this feed and the easiest way (in my opinion anyways) is to get some tag-based feeds which is done like this -
Now to translate this feed you need to understand the different parts of the url which are these -
tag - this is your affiliate code which should end in 20
books - this is the tag you want to use - it could be blu-ray, shoes, anything that is relevant to your lens.
the part in green - this relates to how you want to sort the results ie new is as it suggests products tagged with (in my example) books for the very first time. Popular is the most popular products with that tag.
Another way of sorting out an RSS feed is by using the bestseller feeds and this looks pretty easy as well, but instead of typing it all in here I'm going to give you a link to Squidoography as they have got their url bar captures to show you exactly where to find the numbers you'll need.
This is definitely going on my to do list for next week as I think (especially in the lead up to the holiday season) this could be an absolute windfall in sales.
If you're already doing this let me know how you've found it and if not I hope you'll join me to try and maximize our Squidoo returns.