Google Base Feeder

Author

Description

This Script generates a Google Base data feed as described here:
http://www.google.com/base/products.html

Support Thread

Affects DB

Yes (creates new records into configuration_group, configuration tables and products)

DISCLAIMER

Installation of this contribution is done at your own risk.
Backup your ZenCart database and any and all applicable files before proceeding.

Features

• supports Search-Engine Safe URLs
• could be accessed by http or command line
• auto-upload to Google Base Merchant's FTP
• full zen-cart compatibility

Install

1. Unzip and upload all files to your store directory (except .sql files);
2. Chmod feed directory to 777
3. Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload);
4. Go to http://base.google.com and create/sign to your account. Follow the link on the right hand side of their website to create your FTP account.
5. Go to Admin->Configuration->Google Base Configuration and setup all parameters;
6. Register your bulk upload .xml file using the same name in your Google Base Configuration at base.google.com
7. Go to Admin->Tools>Google Base Feeder and follow instructions to create, view, and upload feed file.

Update

1. Upload/Overwrite all files;
2. Install current version update_#_#_#.sql by copying and pasting (do not upload);
3. If no update.sql file available, then no SQL updates required;

Tips

To have this update and automatically upload to Google Base, you
will need to set up a Cron job via your host's control panel.

To run it as a cron job (i.e. at 5:00am), put something in your crontab like the
following:

0 5 * * * GET http://your_http_catalog/googlefroogle.php?feed=fy_uy_tp
or
0 5 * * * wget http://your_http_catalog/googlefroogle.php?feed=fy_uy_td
or
0 5 * * * curl -s http://your_http_catalog/googlefroogle.php?feed=fy_uy_tn

If your host has disabled cron jobs, try webcron services such as http://www.webcron.org/

Troubleshooting

1. If your script is timing out, in the root of your server (not store root), create/open a file called php.ini and add the following lines:
   

   max_execution_time = 300
   max_input_time = 90
   memory_limit = 32M

2. If you are having issues with the FTP function, please contact your host to make sure all the required ports for PHP FTP functions are open.
3. If you are seeing constants in the ADMIN->CONFIGURATION or ADMIN->TOOLS (i.e. BOX_GOOGLEFROOGLE), then you are missing a definitions file.
   Reupload the files by overwriting the old ones.
4. If the FTP function is timing out, as indicated by a timeout error, increase the timeout length in admin->googlefroogle.php near the beginning of the file.
5. For additional troubleshooting, please visit the support thread, read the entire thread for existing bugs or installation support before posting your questions.