Froogle Merchant Center merged into GoogleBase

[Pixxi]

itguru:

I also moved all the other files in my store's root directory.

Upload all the files in the mod again - make sure all the files in the mod are copied to where they should be on your server - mirror the folder/paths in the mod exactly.

[CarolinaReefs]

ITGURU

I was having the same problem as you with step 4. My problem was simple. I don't have an admin folder, I renamed it for security...bet you did too. Just put those files under admin, in your admin folder, whatever it is named.

CR

[ccn1]

Guys

Where is this php.ini file your all talking about ?, I cant find it !

Hey Pixxi, did you see my reply listing "Timeout's" ??

Regards
Chris

[ctcentralinfo]

I was having issues with mine as well. I solved my googlefroogle timeout problem by making changes in my php.ini configuration file to the following:

max_execution_time = 300
max_input_time = 90
memory_limit = 32M

Guys

Where is this php.ini file your all talking about ?, I cant find it !

Hey Pixxi, did you see my reply listing "Timeout's" ??

Regards
Chris

You should be able to find the location of this file by clicking on server information from your Zen Cart Admin.

[Pixxi]

Not all servers/hosts allow you to have a php.ini file, which is maybe why you can't find it.

You could try setting those parameters via your .htaccess file - if your host allows it. Remember to check in admin->tools->server info after to see if the changes have taken.

php_flag max_execution_time 300
php_flag max_input_time 90
php_flag memory_limit 32M

You can also check the value set in

admin->configuration->My Store->Set max_execution_time for processes

[ctcentralinfo]

Not all servers/hosts allow you to have a php.ini file, which is maybe why you can't find it.

You could try setting those parameters via your .htaccess file - if your host allows it. Remember to check in admin->tools->server info after to see if the changes have taken.

php_flag max_execution_time 300
php_flag max_input_time 90
php_flag memory_limit 32M

You can also check the value set in

admin->configuration->My Store->Set max_execution_time for processes

I don't think that the php.ini file is the issue, besides unless you have a semi-dedicated server I don't think your host company will allow you to access this file do to security issues(I know I wouldn't) I ran easy populate advanced and it generated a file containing almost 50,000 products in no time flat. the issue has something to do with the froogle google base mod. Since I am not a coder, I don't know where to start.

[bekinky]

I uploaded my feed manually for the first time yesterday. It is showing as "Pending, awaiting approval" in my account. When I click "details" it says there are errors in the feed and a bad data line. I have not received any emails from froogle telling me the feed has not been approved or about any errors.

Is this normal and to do with their system while the file awaits approval or are there really errors in the feed? If there are errors how do I fix them? The file was auto-generated by googlefroogle.php

Thanks for any help

[mbheald]

I uploaded all of the files for the Froogle/Google base upload file and I received this error when I ran the SQL Patch:

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 hotnbottconfiguration (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, '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?
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:

• now - add Adjust to current date;
• product - add Adjust to product date (max(date_added, last_modified, date_available))

', @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'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Does anyone know what this means?

[kelvyn]

I uploaded all of the files for the Froogle/Google base upload file and I received this error when I ran the SQL Patch:
Does anyone know what this means?

Exactly how were you installing the patch? If you just uploaded the file, try opening it in notepad and then pasting it in..

[ctcentralinfo]

I uploaded all of the files for the Froogle/Google base upload file and I received this error when I ran the SQL Patch:



Does anyone know what this means?

I have gotten this error also. Usually what I do is cut and paste the frooglegoogle.sql file contents paste them into the area above where you attempted to upload the frooglegoogle.sql file the just hit the send.