Re: Google Base Feeder Support Thread
Hi,
I'm having a problem with installing Google Base feeder and I don't know why, because I installed it last week in a store, same ZC version 1.3.8a (that I am installing it in today) and last week the install went perfectly, but now when I run the SQL patch while installing it in a different store, for some reason when I go to Admin>Configuration, the Google base configuration link is not showing up at the bottom of the list, even though the Google base feeder link is showing up in the tools menu.
So anyway, I re ran the install MySQL patch and now I am getting the below error:
Code:
1062 Duplicate entry 'GOOGLE_BASE_DEFAULT_QUANTITY' 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, 'Default Quantity', 'GOOGLE_BASE_DEFAULT_QUANTITY', '0', 'What is the default quantity for products with zero quantity?', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'Payment Notes', 'GOOGLE_BASE_PAYMENT_NOTES', 'GoogleCheckout', 'Add payment notes (use this for showing you accept Google Checkout)', @configuration_group_id, 35, 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.
Any insights or ideas on how I could troubleshoot this problem appreciated.
Thanks.
Re: Google Base Feeder Support Thread
Just to add here with this above problem I'm having, I checked the configuration table, and there are only two entries in it for the base feed – Configuration ID’s 567 and 568; Default Quantity and Payment notes. And these two rows are assigned a configuration_group_id of 0.
The configuration table for the functional site with the google base feed installed however, shows rows 567 to 604 filled with correct configuration_group_id of 31. So for some reason this table did not get filled on install.
I’ve edited table data for a long time using my trusty Navicat MySQL GUI, but only for products and pricing, I have never done it for the configuration tables.
Would a fix to this install problem be to just copy the data from the table of the functioning site, and paste it to the non working site/table?? Or would that cause more problems that it’s worth?
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
nadsab
Just to add here with this above problem I'm having, I checked the configuration table, and there are only two entries in it for the base feed – Configuration ID’s 567 and 568; Default Quantity and Payment notes. And these two rows are assigned a configuration_group_id of 0.
The configuration table for the functional site with the google base feed installed however, shows rows 567 to 604 filled with correct configuration_group_id of 31. So for some reason this table did not get filled on install.
I’ve edited table data for a long time using my trusty Navicat MySQL GUI, but only for products and pricing, I have never done it for the configuration tables.
Would a fix to this install problem be to just copy the data from the table of the functioning site, and paste it to the non working site/table?? Or would that cause more problems that it’s worth?
Just remove the rows for this module that are showing a configuration_group_id = 0 and any of the rows that were installed properly and then re-run the SQL installation file from the latest version.
Re: Google Base Feeder Support Thread
Thanks much numinix, that did the trick.
Re: Google Base Feeder Support Thread
Hi
I seem to be having trouble again with the uploading of my items, I changed the PASV to false and it uploaded it last time but this time it won't.
Here is the error -
Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2008/11/28 14:26:06
Feed file - /home/daisymay/public_html/feed/domain_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /
Upload failed...
Any ideas?
Phil
I have another shop which I also changed PASV to false and that uploads fine.:frusty:
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
confused_aswell
Hi
I seem to be having trouble again with the uploading of my items, I changed the PASV to false and it uploaded it last time but this time it won't.
Here is the error -
Google Base Feeder v.1.7.0 09.019.2008 17:38:59 started 2008/11/28 14:26:06
Feed file - /home/daisymay/public_html/feed/domain_products.xml
Processing: Feed - No, Upload - Yes
Upload started...
Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /
Upload failed...
Any ideas?
Phil
I have another shop which I also changed PASV to false and that uploads fine.:frusty:
You'll have to upload it manually. But, if it works sometimes, why not just set a nightly cron and every few days that it works it shoud update unless your products change titles, descriptions, and prices on a daily basis...
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
Alex Clarke
Does anyone know if this contribution will allow you to specificy different feeds for target countries?
According to the Google Base help (
http://base.google.com/support/bin/a...er=54611&hl=en), a UK, US and German version exist.
It would be great if these 3 different feeds could be created and uploaded at once.
Does anyone have the answer to this?
Thanks.
Re: Google Base Feeder Support Thread
The google feed creator is only processing three out of the seven hundred or so products? Anyone have any ideas?
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
tj1
Does anyone have the answer to this?
Thanks.
I've heard nothing about different feeds for target countries yet and believe this isn't possible with the latest version of this contribution.
It would be a great addition and I think many people (especially those who trade worldwide) would benefit form it.
Re: Google Base Feeder Support Thread
Quote:
Originally Posted by
46and2
The google feed creator is only processing three out of the seven hundred or so products? Anyone have any ideas?
Maybe you are missing some attributes for the items? Google will not add items unless they have a description. So if you have a bunch of items without a description they will not be processed.