Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: open
If you reaaly want to pay to have someone do it, you can search the web for Froogle submission services, or you can try posting in the Commercial Exchange Forum [webmasterworld.com].
personally, i use microsoft bCentral, and we are able to download a csv file, but it doesn't have the urls either, so what i do is:
1. go into frontpage and pull all the product pages into a new page, which creates links to each page...
2. go into HTML view, and find all the <a href> tags, which link to the individual pages (not external links, but i'll get to that in a sec)... then i use the find/replace function to remove all data except the partial urls.
3. copy the partial urls into a new excel workbook, and again use the find/replace function to add in the first of the web address.
voilá, you have all the urls in an excel workbook, now you just copy/paste the column into the csv file, and save the properly formatted file as a tab-delimited file...
personally, it takes me about 2-3hours to go from the csv file i am able to download from bCentral to the properly configured and formatted tab-delimited file that froogle wants...
if you have any further questions/clarifications on the subject, don't hesitate to post them here, or send me a sticky mail.
there is not problem to add an url. The problem is when you have to do it to 4000/10000 items all with different urls.
I'm looking for a way to do it inside excel to all the items at once