froogle submit pay service

[sebans]

I have to submit but i have a problem
is any pay service helping submit to froogle?

thanks
sebans

[pmac]

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]

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]

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]

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]

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]

oilman thanks,

it seem I must master excel or hire somebody.

sebans

[skateboardsales]

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]

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