Google Base Feeder Support Thread [OLD]

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?

can anyone help with the above?

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?

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.

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

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!

looks like everyone got problems with this mod

i think its too risky to install

and not even working propely

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.

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

:oops:

Quote:

---

Originally Posted by 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!

---

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

Code:

---

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

---

as the cronjob.

or if there's no select time options enter

Code:

---

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

---

which is for 5:00 am.

Quote:

---

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.