Automate process of creating URL from CSV file

We have a link that looks like this: [login to view URL] We now want to reproduce this link 500 000 times with 500 000 different products. We then want to insert 4 parameters. Two of these will be the same for all URL'S. However, the other two parameters will be two different numbers showing what product this URL points to. You will fetch these two numbers from a csv file. You will then add the URL as a new column in a new csv file. The finish URL will look like this: [login to view URL];lkip=fixednumber1&pubip=Fixednumber2&prid=22334455667 You will create an automated solution we can use to create these URL for ourself in the future and fix the first CSV file for us.