[PeachyLove]

Hello,
I am a newbie and technology challenge. Could someone tell where to find the .xml file name to place in Google base data feed. Also, where can I find Google base, shopping. COM and I can not remember the third links or information in admin. I have the gold level.
Thank you so much,
Robin

My site is www.totallyfashiontrendy.com if anyone would like to comment.

[Songofsnow_books]

Your best bet is to use a tab file for upload - imo, which you can access from

Products -> Import/Export -> Saved Exports - > Google Base

this will generate a .txt file when you save it as a tabbed file

Upload this as your data feed manually to Google Base

You will want to modify the Google Base saved query to fit your products, I imagine - size, color, style, mpn. Check with Google Base help pages to see what fields are recommended for your industry and then come back here

Once you are set up, all you'll have to do is periodically upload. Can take a bit of time to get things the way you want them, and the way that Google Base wants them, but after that it's a breeze

Good Luck
Lynne

[PureInfant]

Is the Google Base export there by default? I don't seem to have it in my Saved Export list.

[Songofsnow_books]

Here is the link to the query bank where your saved searches and exports are kept - be sure to replace yourwebsite.com

https://www.yourwebsite.com/admin/Ta...able=QueryBank

If there is no Google Base query there, select ADD
and enter the following:

QB_CustomerID field = 0
QB_AccessList field = leave blank
QB_Table = DB_Export
QB_Title = Google Base
QB_QueryType = Select
QB_Query = see big cut and paste that you will need to customize for your items below

SELECT
'Config_FullStoreURLProductDetails.asp?ProductCode =' + p.ProductCode + '&click=35' AS link
, p.ProductCode AS id
, pe.Google_Product_Type AS product_type
, p.ProductName AS title
, pd.ProductDescription AS [stripHTML-description]
, 'Config_FullStoreURLConfig_ProductPhotosFolder/' + IsNull(p.Photos_Cloned_From,p.ProductCode) + '-2T.jpg' AS image_link
, IsNull(pe.SalePrice,pe.ProductPrice) AS price
, pe.ProductManufacturer AS brand
, pe.ProductCondition AS condition
, pe.UPC_code AS upc
, p.Vendor_PartNo AS mpn
, CONVERT(VARCHAR(10), (GETDATE() + 30),120) AS expiration_date
FROM Products p
INNER JOIN Products_Descriptions pd ON p.ProductID = pd.ProductID
INNER JOIN Products_Extended pe ON pd.ProductID = pe.ProductID
INNER JOIN Products_Memos pm ON pd.ProductID = pm.ProductID
WHERE (p.IsChildOfProductCode is NULL OR p.IsChildOfProductCode = '')
AND (p.HideProduct is NULL OR p.HideProduct <> 'Y')
AND (pe.ProductPrice > 0)
ORDER BY p.ProductCode

Hit save

Examples of fields you may need to add for your business

, pe.CustomField3 AS size
, pe.CustomField4 AS main_color
, pe.CustomField5 AS sleeve_length


The custom fields can be used for any variable you like, just keep it consistant

[vintagerv]

Why not just use the Volusion API to create the XML and send it to Google Base? Much easier, right?

I have heard there some product types that are not fully supported with the Volusion API for Google Base, but I don't know the details.

[Songofsnow_books]

I asked that earlier when I looked into it. As it stands, and as I understand it from looking at the output, many of the fields required are not generated through the API and the ability to customize the output through the API is not available YET according to what I was told on these boards.

[PeachyLove]

Hello Lynn,
I am so sorry for the late reply. Thank you so much for your help and time.
Sincerely,
Robin

[PeachyLove]

Sorry, Lynne

[Songofsnow_books]

de nada - let us know if that works for you :)

Lynne

www.songofsnow.com