pmac
msg:1532006 | 7:02 pm on Jan 27, 2004 (gmt 0) |
What problem are you having? We can probably help figure it out. :) 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]. Good luck!
|
sebans
msg:1532007 | 9:38 am on Jan 28, 2004 (gmt 0) |
pmac, my main problem is that the url is missing from the cvs for excel I downloaded from phpmyadmin. I have 4000/5000 items all with different urls and to add it manually is a problem. thanks sebans
|
jatar_k
msg:1532008 | 5:29 am on Jan 29, 2004 (gmt 0) |
Is the url listed in the database? I would think that, if it is, it may just be a problem with the export you are doing.
|
sebans
msg:1532009 | 11:33 pm on Jan 29, 2004 (gmt 0) |
unfortunately the url is not listed. only the item number is listed. the correct url of the product would be the url plus the item number. thanks sebans
|
oilman
msg:1532010 | 11:37 pm on Jan 29, 2004 (gmt 0) |
if the url part that is missing it the same for all your items you could do a little excel magic and have it inserted into a whole column then concatenate the that column together with your item number and away you go. Should take about 2 minutes to do.
|
sebans
msg:1532011 | 9:54 pm on Feb 3, 2004 (gmt 0) |
oilman thanks, it seem I must master excel or hire somebody. sebans
|
skateboardsales
msg:1532012 | 12:06 am on Feb 5, 2004 (gmt 0) |
i have this exact same problem.... do you use a wysiwyg editor to create your pages? or is it all in a database somewhere? 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.
|
sebans
msg:1532013 | 11:55 am on Feb 5, 2004 (gmt 0) |
I downloaded a cvs file for excel from my database with phpmyadmin. 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 sebans
|
|
