Google Base Feeder Support Thread [OLD]

[pace]

Evening all,

I've just tried to instal this as follows:

1.Unzip and upload all files to your store directory (except .sql files)

done, checked

2.Chmod feed directory to 777

done, checked

3.Go to Admin->Tools->Install SQL Patches and install googlefroogle.sql by copying and pasting (do not upload);

the only SGL file is install.sql so I assume this is it?

I copied the contents of the file (as text) to the SQL Query Executor

The result was a message at the top of the screen stating "failed"

Please advise what to do next.

Presumably the SQL updates also need ot be run once the main one is sorted?

[pace]

can anyone help with the above?

[pace]

Update...

I have re-run the install.sql and seems it worked this time

I have then set about installing all the SQL patches, but keep coming across the following error,

1062 Duplicate entry 'GOOGLE_BASE_PRODUCT_TYPE' for key 2
in:
[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, 'Product Type', 'GOOGLE_BASE_PRODUCT_TYPE', 'top', 'Use top-level, bottom-level, or full-path as product_type?', @configuration_group_id, 34, NOW(), NULL, 'zen_cfg_select_option(array(\'top\', \'bottom\', \'full\'),'), (NULL, 'Starting Point', 'GOOGLE_BASE_START_PRODUCTS', '0', 'Start at which entry (not product_id)?
Default=0', @configuration_group_id, 24, NOW(), NULL, NULL);]
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.

Please can someone clarify that I should be copying the contents of all of these files into the box and running them, as it is unclear from the instructions.

Further, if I am meant to be running these, why do I keep getting this error message?

[akreation]

Not all products are exported. I have about 330 records in my database, but only 42 records are being exported. Any help. I have searched the forum, but cant find an answer.

[farhansabir]

Hi. I tried installing the module. pasted the sql into Install SQL Patch. On top i saw 8 statements processed successfully. But underneath that there was only the link that says "Configuration". All other menus disappeared. When i mouse over that configuration, it shows:


1062 Duplicate entry '0' for key 1
in:
[insert into zen_admin_files set page = 'Google Base Feeder Configuration']
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 field.
(screenshot attached)

Need your help please.

Thanks
Farhan

[iscatech]

Can someone help guide me to set up my Google Base feeder to update and upload automatically? I see the note in the Admin panel that says to set up a cron job via the host control panel, but I don't know what that means at all. Would you point me in the right direction? Thank you!

[mataleo]

looks like everyone got problems with this mod

i think its too risky to install

and not even working propely

[PinkLeopard]

Got this error:



We don't accept non-numeric values, zero (0), or negative prices. If you are including the currency code or symbol, please make sure it matches the currency of the target country.
Examples:
Item Nr. Line Nr. Value
72 1,161 MODULE_SHIPPING_FLAT_COST
74 1,193 MODULE_SHIPPING_FLAT_COST
83 1,337 MODULE_SHIPPING_FLAT_COST
92 1,481 MODULE_SHIPPING_FLAT_COST
178 2,857 MODULE_SHIPPING_FLAT_COST


How do I fix it??

Thanks.

[xiuzhe]

I kept getting this info. when genearting datafeed, pls help:

Google Base Feeder v1.7.4 started 2010/08/16 04:05:45
Feed file - /home/xxx/public_html/feed/domain_products.xml
Processing: Feed - Yes, Upload - No

Fatal error: Maximum execution time of 30 seconds exceeded in /home1/xxx/public_html/includes/classes/google_base.php on line 186

[Kenichi]

Can someone help guide me to set up my Google Base feeder to update and upload automatically? I see the note in the Admin panel that says to set up a cron job via the host control panel, but I don't know what that means at all. Would you point me in the right direction? Thank you!

If your hosting has cPanel you can set up a cron job by clicking the Cron Job icon, selecting a time (once per day, month, etc) and entering

wget http://www.yourdomain.com/googlefroogle.php?feed=fy_uy_tp

as the cronjob.

or if there's no select time options enter

0 5 * * * wget http://www.yourdomain.com/googlefroogle.php?feed=fy_uy_tp

which is for 5:00 am.

I kept getting this info. when genearting datafeed, pls help:

Google Base Feeder v1.7.4 started 2010/08/16 04:05:45
Feed file - /home/xxx/public_html/feed/domain_products.xml
Processing: Feed - Yes, Upload - No

Fatal error: Maximum execution time of 30 seconds exceeded in /home1/xxx/public_html/includes/classes/google_base.php on line 186

You may need to edit your php.ini file to allow a longer execution time/file size limit. Ask your host if you don't know how to do this.