Froogle Merchant Center merged into GoogleBase

[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

[a_berezin]

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/...variables.html

[estrange]

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.

[a_berezin]

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

[tatsumaki]

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.

[a_berezin]

You use any SEFU?

[tatsumaki]

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 :)

[jewelrylady]

works perfectly!!!

I am not using the SEO mod by the way.

thank you so much!!

[spinnywoman]

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?

[a_berezin]

Look an error log. May be some error here?