Froogle Merchant Center merged into GoogleBase

@t4 statement is a SQL thing.

Hello
So I am Guessing that @T4 is for mysql 5+ ??
My hosting service is using MySQL 4.1.21-standard.
If others have this contribution working with 4.1+ mysql, then I am doing something wrong.
I am asking for help.
Please help me.

Thank You

Herbals

Ok I figured it out.
In the googlefroogle.sql there are two reference:

SELECT (@t4:=configuration_group_id) as t4

they should be:

SELECT @t4:=(configuration_group_id) as t4

When I tried to upload the corrected file through admin sql patches, it did not work.
Copying and pasting the code into the admin sql patches worked like a charm.

Fixed googlefroogle.sql to be copied and pasted into admin>tools>Install SQL Patches

SET @t4=0;
SELECT @t4:=(configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
INSERT INTO configuration_group VALUES (NULL, 'Google Froogle Configuration', 'Set Froogle Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @t4=0;
SELECT @t4:=(configuration_group_id) as t4 
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration';
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @t4, 1, NOW(), NULL, NULL),
(NULL, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @t4, 2, NOW(), NULL, NULL),
(NULL, 'Froogle Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: hedwig.google.com', @t4, 3, NOW(), NULL, NULL),
(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @t4, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @t4, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('),
(NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'true', 'A unique alphanumeric identifier for the item - products_id code. ', @t4, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'id\', \'model\', \'false\'),'),
(NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @t4, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'The shipping options available for an item', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @t4, 8, NOW(), NULL, NULL),
(NULL, 'Show Manufacturer', 'GOOGLE_FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Show Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type', @t4, 11, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type', @t4, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'book\', \'music\', \'video\', \'other\'),'),
(NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @t4, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?<br />default = en', @t4, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('),
(NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @t4, 19, NOW(), NULL, NULL),
(NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @t4, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @t4, 21, NOW(), NULL, NULL),
(NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @t4, 20, NOW(), NULL, NULL),
(NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:<ul><li>now - add Adjust to current date;</li><li>product - add Adjust to product date (max(date_added, last_modified, date_available))</li></ul>', @t4, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @t4, 2, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @t4, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

This is a great contribution, thank you for sharing this with the community.

With much gratitude,
Herbals

Thanks!
What version mySQL you use?

Can you test this construction:

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Google Froogle Configuration'
LIMIT 1;

http://dev.mysql.com/doc/refman/5.1/en/user-variables.html

I'm using the newest version 1.3.1. I uploaded and ran the required sql file. However, when I go to admin/configuration/ Google Froogle Configuration there is nothing there to conifgure.

You "using the newest version 1.3.1" of what?
What sql file you run? How you run it?

I am having a problem.
I installed everything successfully (i hope).
I configured it first in Admin->Configuration.

When I go to Tools->Google Froogle Feeder,
and then click on "STEP 1: Click [HERE] to create / update your product feed."

it just takes me to the main page of my store, and does not create anything.
(I checked the file froogle.txt and it is blank)

What am I doing wrong?

Thanks.

You use any SEFU?

I use the SEO addon, but I figured it out. There was something wrong with my .htaccess file, as I have some shared domains on it, and using a 301 redirect.
It was just redirecting to the front page.

Thanks for giving me a place to look :)

works perfectly!!!

I am not using the SEO mod by the way.

thank you so much!!

I am having trouble with this contribution. Downloaded the requisite files from Andrew's site yesterday (with 1_2_6, 1_2_9 and 1_3_ 1 updates). When I hit the Google Froogle Feeder button I get the following messge:

Froogle Data Feeder started 2007/01/29 12:37:39
Feed file - /home/sites/mysite.com/public_html/feed/my_file_name.txt

Nothing happens. The address is http://www.mysite.com/admin/googlefroogle.php

I am using ZenCart version 1.3.6 MySQL 5.0.26-standard Apache/2.0.55 (Red Hat)

I have created and uploaded my_file_name.txt to the feed/ directory and it and the directory are set 777 chmod.

There is no .htaccess file in my root.

I have used the Froogle model successfully in the past on the same server set-up so I do not believe it is a server issue.

Can anyone shed any light please?

Look an error log. May be some error here?

v 1.3.2 30.01.2007 7:05

1. Fix bug with currency value;
2. Add IH support (Thanks to Dan);
3. Don't use module FILENAME_MAIN_PRODUCT_IMAGE;
4. Use medium image (Comments from Dan - "medium should be enough, it is 150 x 120 while Google needs 90 x 90");
5. Fix bug with price = 0;

a_berezin:

v 1.3.2 30.01.2007 7:05

1. Fix bug with currency value;
2. Add IH support (Thanks to Dan);
3. Don't use module FILENAME_MAIN_PRODUCT_IMAGE;
4. Use medium image (Comments from Dan - "medium should be enough, it is 150 x 120 while Google needs 90 x 90");
5. Fix bug with price = 0;

V1.3.2---so is this available yet? I do not see it on your site.

For some reason when I try and use this I get a message saying that the feed/froogle.txt comes up no and no. Any thoughts on what may have happened?

Hi Andrew,

The new v 1.3.2 only uses the medium image even where a large image exists?

Some shops don't use medium images - only large and small (ie. they don't have a product info page, only the product listing page - with the 'Click for larger image' on that page).

Could the code maybe default to use the large image if no medium image exists?

I just got the e-mail below from Google:

Froogle Merchant Announcement
New product upload requirements Google

Hello,

As you know, we're always looking for new ways to improve our product search experience, both for our users and for content providers. We've found that one of the most effective ways to help users conduct faster and more effective searches is to describe products with relevant attributes - ideally those assigned by the people who best understand their own products, meaning you.

That's why we're asking all Froogle merchants to send us bulk uploads in the Google Base format, with five additional attributes (along with the basic ones you've submitted in the past). Because we think it's important to provide a consistent user experience, we will no longer list items that don't meet a minimal number of attributes by the end of February 2007. Please review the following bulk uploads - they do not currently meet the minimum attribute requirement:

myfile_gmail_com.txt

For further explanation please visit our FAQ section

You can review this attribute requirement page to learn about these new guidelines for general product attributes and specific attributes per product type. You can also learn how to submit your feed using Google Base here. We recommend that you include as many attributes as possible; the more information you provide, the better chance you'll have of matching users' "refinement" queries.

We hope you'll continue enjoying the benefits of listing your products on Google, and even increase your potential customer base using the new Google Base format.

Thanks,
The Google Base Team

Required new attributes / per product type:

http://base.google.com/base/help/products.html#specific

So will a new update be needed to make our files acceptable or will this be something we will have to change ourselves?

I downloaded the add on and got it all installed but when i ran the SQL patch I got the following error

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD',' at line 1
in:
[INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Froogle Username', 'GOOGLE_FROOGLE_USERNAME', 'froogle_username', 'Enter your Froogle username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Froogle Password', 'GOOGLE_FROOGLE_PASSWORD', 'froogle_password', 'Enter your froogle password', @configuration_group_id, 2, NOW(), NULL, NULL), (NULL, 'Froogle Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server
default: hedwig.google.com', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Default Currency', 'GOOGLE_FROOGLE_CURRENCY', 'USD', 'Select currency', @configuration_group_id, 5, NOW(), NULL, 'zen_cfg_pull_down_currencies('), (NULL, 'Show Offer ID', 'GOOGLE_FROOGLE_OFFER_ID', 'true', 'A unique alphanumeric identifier for the item - products_id code. ', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('id', 'model', 'false'),'), (NULL, 'Display quantity', 'GOOGLE_FROOGLE_IN_STOCK', 'false', 'Display products quantity?', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'The shipping options available for an item', 'GOOGLE_FROOGLE_SHIPPING', '', 'The shipping options available for an item', @configuration_group_id, 8, NOW(), NULL, NULL), (NULL, 'Show Manufacturer', 'GOOGLE_FROOGLE_MANUFACTURER', 'false', 'Display Manufacturer Name', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW', 'false', 'Display Product Type', @configuration_group_id, 11, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'If Display Product Type is True, choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array('book', 'music', 'video', 'other'),'), (NULL, 'Show Feed Lanugage', 'GOOGLE_FROOGLE_LANGUAGE_DISPLAY', 'false', 'Display Feed Language', @configuration_group_id, 13, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Feed Language', 'GOOGLE_FROOGLE_LANGUAGE', 'English', 'If Show Feed Language is True, what is your feed language?
default = en', @configuration_group_id, 14, NOW(), NULL, 'zen_cfg_pull_down_languages_list('), (NULL, 'Output File Name', 'GOOGLE_FROOGLE_OUTPUT_FILENAME', 'froogle.txt', 'Set the name of your froogle output file', @configuration_group_id, 19, NOW(), NULL, NULL), (NULL, 'Compress Feed File', 'GOOGLE_FROOGLE_COMPRESS', 'false', 'Compress Google froogle file', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Uploaded date', 'GOOGLE_FROOGLE_UPLOADED_DATE', '', 'Date and time of the last upload', @configuration_group_id, 21, NOW(), NULL, NULL), (NULL, 'Output Directory', 'GOOGLE_FROOGLE_DIRECTORY', 'feed/', 'Set the name of your froogle output directory', @configuration_group_id, 20, NOW(), NULL, NULL), (NULL, 'Expiration Date Base', 'GOOGLE_FROOGLE_EXPIRATION_BASE', 'now', 'Expiration Date Base:

I am running the following on my server - **Database: **MySQL 4.1.21-standard
**PHP Version: **4.4.4 (Zend: 1.3.0)
Zen Cart 1.3.6

Database Patch Level: 1.3.6

What do I need to do to correct this?