| 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].
| 9:38 am on Jan 28, 2004 (gmt 0)|
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.
| 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.
| 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.
| 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.
| 9:54 pm on Feb 3, 2004 (gmt 0)|
it seem I must master excel or hire somebody.
| 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.
| 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