Google Base Excel Spread Sheet

[Miss Pretty Pink]

Hi
Not sure this is the correct place to ask,but I'm sure someone will point me in the right direction if I need to ask else where.

I am trying to work out the correct things to put in an excel spread sheet to save and download to Googlebase,by this I mean price discription etc.

I have followed their instructions,but it still doesn't load ( only practising on one item till it does) each time saying I haven't added something.

I do know how to load the data,it's setting up the spread sheet ,that I am having problems with.

Does anyone on here do it by spreadsheet and if so can they tell me where I am going wrong?

Thanks

Miss Pretty Pink:redface:

 

[Claude & Celeste]

ok google base does accept spreadsheet you need to save your spreadsheet at a text file and upload it to google base try that if this doen's work I will send you our template

Alex

 

[CaterTrade]

I posted this on another thread, might be helpful to you too.

A data feed is a file you upload that is a tabbed delimited text file (excel can save to this format or you can write it manually)

The file needs to have the following titled columns separated by tabs

id[tab]product_url[tab]name[tab]description[tab]image_url[tab]condition[tab]price

Below these titles in the spreadsheet file you need to list each product on a separate line with the following example information.

1[tab]http://www.example.com/product1.php[tab]Blue Widget[tab]Lovely Blue Widget with 10 sproggits[tab]http://www.example.com/images/widget1.jpg[tab]New[tab]67.54

The google guidelines explain this a bit better here http://www.google.com/support/mercha...r=160588&hl=en

Where's I've written tab, in excel that would be the next column

 

[Miss Pretty Pink]

ok google base does accept spreadsheet you need to save your spreadsheet at a text file and upload it to google base try that if this doen's work I will send you our template

Alex

Can you send me a copy of your template,I should have mentioned I knew how to save it as a text file .
Very grateful
Miss Pretty Pink

 

[Miss Pretty Pink]

I posted this on another thread, might be helpful to you too.



Where's I've written tab, in excel that would be the next column

I clicked on but nothing appears to be there?
Miss Pretty Pink

 

[CaterTrade]

Clicked what? The guide is in the quoted text

 

[debbidoo]

Miss PP,

Try saving your file as a comma separated file (.csv)

In excel, go to file > "save as" and in the 'file type' drop-down box at the bottom of the 'save as' window, select 'comma separated (csv)' and click 'save'. You'll get a couple of messages saying that this file format doesn't support multiple worksheets - just click OK and you're done

You should be able to upload the CSV file then to Google.

Good luck

Debs

 

[Miss Pretty Pink]

Hi
It is the details that I require to put in the spread sheet ,sorry I think you all have misunderstood me

They show you to write item ,discription,etc but I must be missing some other details out. I take id stands for my id number.

Also they show url for image - where do I find that I can find url for the product but not image.

So a template of the list of words one puts on the spread sheet is basically what I require as I am manually adding my products.

Thanks
Miss Pretty Pink

 

[debbidoo]

Ahh sorry - my bad

 

[AndyP]

We use the following columns: (unique) ID, Price, Link (to product page), Description, Title, Image Link (URL to product image), Condition (new/used etc), Quantity (in stock), Payment Note (seems to default to Mastercard), Brand, Model Number, Product Type (Home & Garden > Kitchen & Dining > Tableware > Coffee Pots & Tea Pots for example), Colour, Weight, Manufacturer.

Have all these in separate columns, populate with your products, save as a .txt file, upload and you're done.

 

[Miss Pretty Pink]

Thanks ever so much!!
Miss Pretty Pink
xx

 

[Miss Pretty Pink]

Hi,

Thanks ever so much it worked!!

I tried it on one item - a brooch- and voila it's on.

I am most indebted .

Many thanks
Miss Pretty Peach

 

[AndyP]

Hi,

Thanks ever so much it worked!!

I tried it on one item - a brooch- and voila it's on.

I am most indebted .

Many thanks
Miss Pretty Peach

My pleasure. Glad to have been able to help!

 

[searchability]

HI There

I know you had problems with Google Base and it is happening to me!!

Please could you send me an example of the file that you uploaded because mine got rejected again!!! Thanks Joanne, my e mail is jo at search-ability co uk. I wasn't allowed to put my e mail in directly as I am new to the forum

 

[AndyP]

Hi

As per my previous post....

We use the following columns: (unique) ID, Price, Link (to product page), Description, Title, Image Link (URL to product image), Condition (new/used etc), Quantity (in stock), Payment Note (seems to default to Mastercard), Brand, Model Number, Product Type (Home & Garden > Kitchen & Dining > Tableware > Coffee Pots & Tea Pots for example), Colour, Weight, Manufacturer.

Have all these in separate columns, populate with your products, save as a .txt file, upload and you're done.

I hope that helps...it really is very straightforward.

 

[MDG]

We use a few less columns and don't seem to have any problems, the columns we use are -

Unique ID
Title
Description
Image URL
Price
Link
Condition

 

[RedEvo]

This should help you, there's even screen vids to show you exactly what to do.

d