Froogle Merchant Center merged into GoogleBase

[Woodymon]

3. I am unsure but Google may not support within their schema the ability to assign more than one price (regular price and sale price) for each product. But if someone wants to check with Google to see if they support multiple prices, maybe the needed logic can be coded into the mod, using existing code as an example.

Just visited http://base.google.com/base/products.html#price and confirmed GoogleBase/Froogle does not currently support a sale price attribute.

I suspect the Google Froogle mod could be hacked to test for the existence of a sale price for each of your products, and if that condition exists then replace the regular unit price for each of your products with the sale price in an array, before writing the feed file. Or something like that. IANAP.

Woody

[a_berezin]

Woody,

4. Again I can understand why Andrew is ridding himself of the pain of supporting this mod. Attempting to match the schema of Zen Cart products to Google's constantly changing feed requirements is near impossible.

Is not present. Ok, I should explain the reason.
I have stopped support of this module because i don't use it - this service is not accessible for me. And to spend my time and my money for its support it is too prodigal.

[jeking]

Hi kbalona,

You are not alone. Same kind of error on my end. I posted it a few days ago but nobody seems to have insight.

I wonder, did nobody else have these #1064 - You have an error in your SQL syntax; errors?

Why is there a syntax error if the SQL patch is supposed to be sound? Any help or pointers is highly appreciated....

I'm still getting the same 1064 error. I tried uninstalling and reinstalling and still get the same 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

I don't understand why.

[mydanilo]

I'm still getting the same 1064 error. I tried uninstalling and reinstalling and still get the same 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

I don't understand why.

I know we should not be pushy and post the same question over and over, but....I can't believe that nobody can give a quick pointer to why or where the 1064 errors come from. How come the SQL patch seem to work for some an not for others? I personally have no SQL syntax experience. PHP a lttle, HTML ok and I am willing to help the community where I can. Here with this I am on my wits end. Do I sound like I am begging for help? Hmm.....

I hope some of us will pick up where a_berezin leaves off. This mod is very important to many of us and it should be continued. Right?

[Woodymon]

I know we should not be pushy and post the same question over and over, but....I can't believe that nobody can give a quick pointer to why or where the 1064 errors come from. How come the SQL patch seem to work for some an not for others?

Also have you attempted to run in phpmyadmin? If that does not work for you attach the complete SQL patch file and so we can take a look.

Woody

[jeking]

Woody,

Thanks for the offer to help. I had not tried from phpmyadmin, but just did and got a different error. This is the script I ran:

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

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google Froogle Configuration', 'Set Froogle Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

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', @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<br />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, 'Product Type', 'GOOGLE_FROOGLE_PRODUCT_TYPE', 'other', 'Choose your product type', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'book\', \'music\', \'video\', \'other\'),'),
(NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),'),
(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?<br />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:<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>', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'now\', \'product\'),'),
(NULL, 'Expiration Date Adjust', 'GOOGLE_FROOGLE_EXPIRATION_DAYS', '365', 'Expiration Date Adjust in Days', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Use cPath in url', 'GOOGLE_FROOGLE_USE_CPATH', 'false', 'Use cPath in product info url', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

and the error I got:

SQL query:

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

MySQL said:

#1146 - Table 'dog_zc1.configuration_group' doesn't exist

[Woodymon]

Woody,

Thanks for the offer to help. I had not tried from phpmyadmin, but just did and got a different error. This is the script I ran: {snipped}

and the error I got:

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

MySQL said:
#1146 - Table 'dog_zc1.configuration_group' doesn't exist

So this last error report came from phpmyadmin?

I just have basic SQL knowledge but I suspect a db table prefix issue. However usually you will see an error like that from within Zen Cart's built-in SQL Executor (which will attempt to add the prefix your shop database is set up with), but not from phpmyadmin.

In phpmyadmin when you select your database do all the tables listed in the left column show a prefix of "dog_zc1." ? That is do you observe a table named "configuration_group" or is it named "dog_zc1.configuration_group"?

If the table is named "configuration_group" (without a prefix) then you should be able to run the SQL in phpmyadmin without that error. If you have a prefix on each table then you will need to either edit the SQL, or patch your database from within Zen Cart "Tools > Install SQL Patches" (do not upload, just paste in and the proper prefix should be auto applied).

Woody

[jeking]

Woody, you rock!! My tables do have the prefix. I pasted the sql script into the box in box and it worked! I have been using the file upload option on that page. I installed the rest of the files and the whole thing is working.

I'd bet others with the 1064 error are also uploading. I'd be curious to heard if this works for mydanilo now too.

Thanks again Woody.

[ctcentralinfo]

What could be causing this? When I try to start the feed I get:

Froogle Data Feeder v.GOOGLE_FROOGLE_VERSION started 2007/02/16 12:39:45 Feed file - /home/cooltechcentral.txt
Fatal error: Maximum execution time of 30 seconds exceeded in /home/wwwcool/public_html/includes/functions/functions_lookups.php on line 522

I set Admin Session Time Out in Seconds to 7200 and Admin Set max_execution_time for processes to 300 and I stillgetting the same response. This wasn't happening before I upgraded to the newwst version and disabled dhl shipping mod.

[ctcentralinfo]

Anyone? Anyone? Bueller?