Q: I only have ASINs and titles on a sheet but not the URLs... How to build Amazon URLs for Sku Fetch?


A: If you're using something that grabs ASINs, I'd suggest either building a spreadsheet with a concat function to allow you to add: 

Depending on your Amazon selling country, to the beginning of your ASINs and then you'd just copy and paste the output into Sku Fetch... or you can use a site like this which will do it for you: https://textmechanic.com/text-tools/basic-text-tools/merge-text-line-line/ 


Just type https://www.amazon.com/dp/ in the "Prefix" box


Paste in your ASINs into the Input 1 Box. Click Merge Lines and the output will show at the bottom.


Example: https://www.amazon.com/dp/B00N9OH1BA/


You can then copy and paste the full URLs into Sku Fetch.


Also, be sure that you have your pricing option set in your filters and formatting settings of sku fetch to make sure that the correct pricing option is being applied to your listings