Google Base Feeder Support Thread [OLD]

stedman:

Got it! Working. Only error with google now is
attribute product categoy missing. Not sure how to fix this one.
Thanks

That's the new Google Product Category requirement. Go to their taxonomy:

http://www.google.com/support/merchants/bin/answer.py?answer=160081

Select a category/sub-category that best fits your site. Click it and it will create the correct entry for you. Use the xml entry it creates and put that in Default Product Category in your feeder configuration.

For example, one of my sites is collectibles, so the Google taxonomy is Arts & Entertainment > Collectibles and the actual entry I added was Arts & Entertainment > Collectibles.

Edit: That goes in Default Product Category in the configuration, NOT Default Product Type.

FGold:

Does anyone know how to make the attributes on the actual product pages "hidden"? I'm not thrilled with how they look on my site and don't actually need them there except for Google Feed. I have no choices so seems kind of lame to have attributes on the product pages.

Admin/catalog/product types/product-general/edit layout.

You've been a great help. I can't thank you enough. I can't seem to find default product category. Do you mean Included categories?

Scroll down further. Default Product Category is right above Display Tax.

uh oh, I don't have that. Above display tax I have use cpath in url, enable may pricing, and use meta title. Do I not have the correct info?
Thanks

stedman:

uh oh, I don't have that. Above display tax I have use cpath in url, enable may pricing, and use meta title. Do I not have the correct info?
Thanks

That's weird. What version of the feeder do you have installed?

Maybe my sql 1.10.2 update in not going in. I'm trying to insert it through the patches but I keep getting 1062 duplicate entry message.

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 'unq_config_key_zen'
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 Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @configuration_group_id, 60, 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.

This is what I'm getting but the Default Product option is not showing up in the feed configuration.

I have just tried 1.11.2 and my feed is getting double attributes generated. i.e. I have a t-shirt with different sizes and colours. I am getting the following in my feed:

<item> <g:item_group_id>002</g:item_group_id> <g:id>002-17</g:id> <g:color><![CDATA[red]]></g:color> <g:size><![CDATA[6-12 months]]></g:size> <g:price>15.36</g:price> <title><![CDATA[T-Shirt Green 12-18 months Blue Red 0-6 months 6-12 months]]></title> <g:brand><![CDATA[No Added Sugar]]></g:brand> <g:condition>New</g:condition> <g:product_type>Clothes,T-shirts</g:product_type> <g:mpn><![CDATA[002]]></g:mpn> <description><![CDATA[T-shirt and play suits from ....]]></description> <g:color><![CDATA[blue]]></g:color> <g:color><![CDATA[green]]></g:color> <g:color><![CDATA[red]]></g:color> <g:size><![CDATA[0-6 months]]></g:size> <g:size><![CDATA[12-18 months]]></g:size> <g:size><![CDATA[6-12 months]]></g:size> </item>

(if you are seeing smilies - accept my apologies they are there from the code in the feed and I could not work out how to turn them off.)

You can see that this product has the colour attribute and size attribute 4 times and it is being rejected by google for duplicating attributes in a feed.

you can also see the title of the product seems to reflect this error as well.

Can anyone help? thank you.

stedman:

Maybe my sql 1.10.2 update in not going in. I'm trying to insert it through the patches but I keep getting 1062 duplicate entry message.

Yeah, you would get a duplicate error mesaage if you already installed it. That doesn't hurt anything, though.

I don't have a friggin' clue why you would have all the other options in configuration and not have the Default Product Category option.

stedman:

Maybe my sql 1.10.2 update in not going in. I'm trying to insert it through the patches but I keep getting 1062 duplicate entry message.

PS: Have you tried running the install.sql patch again?

Yea, about three or four times and I get the same message. I also tried the uninstall and started back a couple of installs until I got to the 1.10.2

Hi All,

simple question but I do need some help.

in Google Merchant Center - what is the fetch url ?

is it FTP://domain/ADMIN/filename.XML

file name being the output file name designated in the configuration.

aside from this aspect all else seems ok to this point.

thanks in advance.
Mike

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 'unq_config_key_zen'
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 Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @configuration_group_id, 60, 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.

Anyone want to take a stab at how I can fix this?
Thanks

Originally Posted by FGold View Post
Does anyone know how to make the attributes on the actual product pages "hidden"? I'm not thrilled with how they look on my site and don't actually need them there except for Google Feed. I have no choices so seems kind of lame to have attributes on the product pages.

Admin/catalog/product types/product-general/edit layout.

There is no setting there to make them hidden on the product pages. :(

FGold:

Originally Posted by FGold View Post
Does anyone know how to make the attributes on the actual product pages "hidden"? I'm not thrilled with how they look on my site and don't actually need them there except for Google Feed. I have no choices so seems kind of lame to have attributes on the product pages.

There is no setting there to make them hidden on the product pages. :(

Just change the value for the attribute you want hidden from 1 to 0.

stedman:

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 'unq_config_key_zen'
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 Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @configuration_group_id, 60, 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.

Anyone want to take a stab at how I can fix this?
Thanks

There is nothing to fix. That message simply means that it has already been installed.

shags38:

Hi All,

simple question but I do need some help.

in Google Merchant Center - what is the fetch url ?

is it FTP://domain/ADMIN/filename.XML

file name being the output file name designated in the configuration.

aside from this aspect all else seems ok to this point.

thanks in advance.
Mike

The fetch url would be http://www.yoursite.com/yourfeedfolder/yourfilename.xml.

Ok, I figured that's the case. How can I get the default product category to show in the feed configuration. Whithout this, all elso is lost. I won't get my feed approved in the merchant feed.

stedman:

1062 Duplicate entry 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY' for key 'unq_config_key_zen'
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 Product Category', 'GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY', '', 'Enter a default product category from the Google Category Taxonomy or leave blank:', @configuration_group_id, 60, 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.

Anyone want to take a stab at how I can fix this?
Thanks

Try this but always backup your database before you start.

countrycharm:

Actually there is a way to get rid of all the configurations by running these 3 SQL scripts in admin/tools/install_sql+patches.

Run these first

DELETE FROM configuration WHERE configuration_key LIKE 'GOOGLE_BASE%';
DELETE FROM configuration WHERE configuration_key LIKE 'GOOGLE_FROOGLE%';

> 
> ```php
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id =  @configuration_group_id AND configuration_group_id != 0;
```Then  install whatever version of google base you are trying to  install.