How to automatically add amazon affiliate link into my DB using product description

I'm developing a price comparison website.

My products database is automatically updated using scrapy spiders. I want to add an Amazon affiliate link next to each item.

Since it's a dynamic and very long table, i'm looking to use/ build a tool that will fetch for each product's row it's relevant amazon product link. prefered with my amazon affiliate code already embedded in it, but this can be easily done later.

i have searched the web for options but didn't find.