X-Cart forums

[jgkiefer]

Has anyone an easy way to create a file for Froogle Google?

[jpsowin]

Here is the new export filter.
If you need help with it, I can do work on the side integrating it into your cart if you do not know how, but this should certainly get you started, as it's pretty much all done right here. This took me hours of work and going back and forth with froogle to get this exactly right, so if you have problems then I'd be happy to help, just go to my x-cart services page.

/main/products_export.tpl

{* HEADER FOR GOOGLE FEED By Joshua Sowin*}
{* If you remove these headers or change them you do not have permission to use this code. This code is copyright 2003 Joshua Sowin www.gracehost.net *}
{strip}
product_url{$delimiter}
name{$delimiter}
description{$delimiter}
price{$delimiter}
image_url{$delimiter}
category{$delimiter}
offer_id{$delimiter}
shipping
{/strip}
{* END HEADER *}
{section name=prod_num loop=$products}
{strip}
http://www.YOURWEBSITENAME.com/store/customer/product.php?productid={$products[prod_num].productid|replace:"\"":""}&cat={$products[prod_num].categoryid|replace:"\"":""}&partner=froogle{$deli miter}
{$products[prod_num].product|replace:"\"":""}{$delimiter}
{$products[prod_num].fulldescr|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "|replace:"\"":""|replace:",":","|strip_tags}{$del imiter}
{$products[prod_num].price|replace:"\"":""}{$delimiter}
http://www.YOURWEBSITENAME.com/store/image.php?productid={$products[prod_num].productid|replace:"\"":""}{$delimiter}
{$products[prod_num].category|replace:"/":" > "|replace:"\"":""}{$delimiter}
{$products[prod_num].productcode|replace:"\"":""}{$delimiter}
0.00
{/strip}
{/section}

[jgkiefer]

Wow, how cool. Do I replace main/export_products.tpl with this or add to it?

[jpsowin]

Replace

[arismo]

Thank you. I did it and I got this from Froogle:

"Thank you for submitting your feed to Froogle.
We have reviewed your feed and need you to make the following changes to it.

- Please remove all empty newlines from your file."

Where the problem may be?

[minorgod]

Could someone tell me what Froogle Google is and why I might want to use it?

Also, I'd suspect you just need to do a final search/replace for \n\n on the data you're sending to Froogel Google. Basically just replace any double newlines with single newlines to strip out the blank lines. Or do a search and replace for any lines that start and end with a newline. I could easily show you this in PHP, but I've never tried anything like it in SMARTY code.

[POSDepot]

First of all, thanks so much for the Froogle export. We used it and all our products were on Froogle in 2 days.

The export does put a blank line between records.
Just load the file into Excel and click Data>> Filter>> Autofilter.
One of the choices is to show only blank lines.
Highlight all the blank lines and delete.
Resave the file and upload to Froogle.

Randy

[jgkiefer]

Originally Posted by minorgod

Could someone tell me what Froogle Google is and why I might want to use it?

You can read about it here.
http://froogle.google.com/froogle/about.html

[BeZerk]

Great script - how can it be modified to remove the blank line?

[magnumkp]

I'm just waiting for a UK Google Froogle. Though good to get it tested on someone else for a change before they bring it here