Google Base Feeder Support Thread [OLD]

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.

Quote:

---

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

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

Quote:

---

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

PHP Code:

---

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


---

Then

PHP Code:

---

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.

---

Quote:

---

Originally Posted by stedman

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.

---

I'm stumped as to why the configuration would be there with all the other options and missing only Default Product Category.

yea, nothing is working to clear it up.

I have installed the add-on and configured the settings BUT there is no Google Merchant Feeder in the admin/TOOLS.

Any ideas as to why not?

cheers,
Mike