Zen Follower
- Join Date:
- Jun 2009
- Posts:
- 383
- Plugin Contributions:
- 0
[OLD] Google Merchant module Version 1.12.0 by Numinix
buildingblocks:
No the item is a piece of furniture.
Lucky you! :D
Started by pinkleopard on 20 Oct 2011, 1:25 AM · Views: 113,657
Zen Follower
buildingblocks:
No the item is a piece of furniture.
Lucky you! :D
Totally Zenned
buildingblocks:
Another thing that is happening is there is one product that consistently has the product type tag omitted but the rest of the products in the feed include the product type tag. This is the only thing keeping the feed from being perfect in merchant center.
The product type tag can be added manually but most shop owners will not want to deal with that.
I just went and copied the product then deleted the original. Now the product type tag is being included for the product. I don't get it but the feed now has no warnings or errors in merchant center and my quest for a perfect feed is now complete (for about 2 minutes). LOL
Zen Follower
OK i've just about pulled out all of my hiar which at my age i'm losing it anyway.
Zen 1.3.7 (i dont think that has anything to do with it (?)
I have installed the 1.2.0 version 6 or 7 times. The last 3 times after uninstalling the sql files at least 3 times each.
Each time I have the following problems:
The sql patch comes back with a 1062 message of dupkicate key:
1062 Duplicate entry 'GOOGLE_PRODUCTS_DEBUG' 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, 'Debug', 'GOOGLE_PRODUCTS_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Google Merchant Center FTP Username', 'GOOGLE_PRODUCTS_USERNAME', 'ftp_username', 'Enter your Google Merchant Center FTP username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Google Merchant Center FTP Password',
ETC, ETC, ETC
The following shows in the configuration:
Configuration Catalog Modules Customers Localization Reports Tools Gift Certificate/Coupons Extras
Google Merchant Center Feeder Configuration
Title Value Action
tOOLS/GOOGLE MERCHANT CENTER TAKES ME OUT TO THE ADMIN HOME PAGE!!!!
Help please.
How do I get out of this dillema
Zen Follower
marvin, what do you mean ```html
tOOLS/GOOGLE MERCHANT CENTER TAKES ME OUT TO THE ADMIN HOME PAGE!!!!
do you mean if you click on **confirm** a separate window pops up? not sure what exactly you mean that GM takes you out of the admin home page. i know when i click on confirm...(run debug) a separate window pops open and then when i check my .xml another separate window pops open.
BUT if you're version is 1.3.7 yes you do need to upgrade. Trust me we have all been there. You might be having a compatibility issue.
i am not an expert but any means and i, like others, are struggling with GM too.
not sure what to tell you on the duplication....try searching (yes it works) the forum.
hope that helps
Zen Follower
PinkLeopard:
marvin, what do you mean ```html
tOOLS/GOOGLE MERCHANT CENTER TAKES ME OUT TO THE ADMIN HOME PAGE!!!!
>
> do you mean if you click on **confirm** a separate window pops up? not sure what exactly you mean that GM takes you out of the admin home page. i know when i click on confirm...(run debug) a separate window pops open and then when i check my .xml another separate window pops open.
>
> BUT if you're version is 1.3.7 yes you do need to upgrade. Trust me we have all been there. You might be having a compatibility issue.
>
> i am not an expert but any means and i, like others, are struggling with GM too.
>
> not sure what to tell you on the duplication....try searching (yes it works) the forum.
>
> hope that helps
-------------------------------------------------------
I mean that when I go to tools and click on "GM center feeder " I go to the Admin home page:
----------------------------------------------------------------------------------------------------------------------------------------------------
Fri, 21 Oct 2011 22:49:07 -0500GMT [69.126.183.26 ] Admin Home | Online Catalog | Support Site | Version | Logoff
Configuration Catalog Modules Customers Locations / Taxes Localization Reports Tools Gift Certificate/Coupons Extras
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Yes, I have searched both the new & old forums for GM and have tried all the sql deletes and re-patch suggestions to no avail.
As to compatability - was hoping to hold off until 1.5 is debugged and ready.
Totally Zenned
marvin:
The sql patch comes back with a 1062 message of dupkicate key:
1062 Duplicate entry 'GOOGLE_PRODUCTS_DEBUG' 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, 'Debug', 'GOOGLE_PRODUCTS_DEBUG', 'false', 'Turn on simple debug?', @configuration_group_id, 0, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Google Merchant Center FTP Username', 'GOOGLE_PRODUCTS_USERNAME', 'ftp_username', 'Enter your Google Merchant Center FTP username', @configuration_group_id, 1, NOW(), NULL, NULL), (NULL, 'Google Merchant Center FTP Password',
ETC, ETC, ETCa
If running the uninstall sql numerous times doesn't remove it then you'll need to delete it manually from the configuration table
New Zenner
buildingblocks:
If running the uninstall sql numerous times doesn't remove it then you'll need to delete it manually from the configuration table
this worked for me , if its the same issue you have..
http://www.zen-cart.com/forum/showpost.php?p=1072828&postcount=3412
oops for Marvins issue lol
Zen Follower
I have managed now to be able to open the feed file and I dont think this is a Google thing. The feed itself is only showing the 72 items even though it says it is processing 108 items with no errors.
some are in stock and some are out of stock
https://www.candlewithcare.co.uk
Luxury Scented
Candles at great prices!
New Zenner
[QUOTE=PinkLeopard;1073421]This is the NEW thread for the latest version of Numinix Google Merchant Version: 1.12.0
Strangely, after I upload 1.10.0 version, my .xml feed file is not there any more?! what happened?:cry:
Zen Follower
CandleMan:
I have managed now to be able to open the feed file and I dont think this is a Google thing. The feed itself is only showing the 72 items even though it says it is processing 108 items with no errors.
some are in stock and some are out of stock
Just for information, I turned on the Advanced XML Sanitization and all is now working great.
https://www.candlewithcare.co.uk
Luxury Scented
Candles at great prices!
Zen Follower
CandleMan:
Just for information, I turned on the Advanced XML Sanitization and all is now working great.
Excellent! :clap:
Thanks for the information and good luck with your store. :D
Totally Zenned
Just to summarise what I have found, (in case Numinix reads this)..when adapting this to cope with both english and spanish.
Bugs
if (!function_exists('google_cfg_pull_down_country_list')){
function google_cfg_pull_down_country_list($countries_id, $key = '') {//steve was google_cfg_pull_down_country_iso3_list
```This has been mentioned above but I would like to point out its a bug.
2) the options for automatically adding the product types based on your category path.
"bottom" is incorrectly coded in googlefroogle.php.
Correction:
```php
$bottom_level = $product_type[sizeof($product_type) - 1]; // sets last category in array as bottom-level, steve bug was +1
```3) in the same location, the category names go through the htmlentities function to encode special characters (as per google feed specs). This garbles utf-8 as php defaults to iso-8859 so the correct code should be:
```php
$product_type = htmlentities($bottom_level, ENT_QUOTES,'UTF-8');
```However, when the accented characters are represented correctly in the feed, Google still complains of invalid format.
So, get rid of the function altogether in the three instances, for example:
```php
$product_type = $product_type[0];//steve removed htmlentities, Google no like
} elseif (GOOGLE_PRODUCTS_PRODUCT_TYPE == 'bottom') {
$bottom_level = $product_type[sizeof($product_type) - 1]; // sets last category in array as bottom-level, steve bug was +1
$product_type = $bottom_level;//steve removed htmlentities, Google no like
} elseif (GOOGLE_PRODUCTS_PRODUCT_TYPE == 'full') {
$full_path = implode(",", $product_type);
$product_type = $full_path;//steve removed htmlentities, Google no like
```4) Duplicated <g:google_product_category> after each item.
There is duplicated code in both googlefroogle and/classes/ google_base to deal with attributes. I did not investigate this fullly as I don't use attributes.
I chose to comment out the code in google_base, this may not be the correct solution for your store.
In any case search for g:google_product_category to find the repeated code.
I have added code to the mod to be able to generate each feed with its own store description, currency, and default google category. If anyone wants it for their dual language store, pm me.
Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...
Zen Follower
torvista:
Just to summarise what I have found, (in case Numinix reads this)..when adapting this to cope with both english and spanish.
Bugs
- for the country pulldown list in the admin.
The function call as named by the sql install and the actual function name are not the same. Probably easiest to rename the function
if (!function_exists('google_cfg_pull_down_country_list')){
function google_cfg_pull_down_country_list($countries_id, $key = '') {//steve was google_cfg_pull_down_country_iso3_list
>
> 2) the options for automatically adding the product types based on your category path.
> "bottom" is incorrectly coded in googlefroogle.php.
>
> Correction:
> ```php
$bottom_level = $product_type[sizeof($product_type) - 1]; // sets last category in array as bottom-level, steve bug was +1
```3) in the same location, the category names go through the htmlentities function to encode special characters (as per google feed specs). This garbles utf-8 as php defaults to iso-8859 so the correct code should be:
> ```php
$product_type = htmlentities($bottom_level, ENT_QUOTES,'UTF-8');
```However, when the accented characters are represented correctly in the feed, Google still complains of invalid format.
> So, get rid of the function altogether in the three instances, for example:
> ```php
$product_type = $product_type[0];//steve removed htmlentities, Google no like
} elseif (GOOGLE_PRODUCTS_PRODUCT_TYPE == 'bottom') {
$bottom_level = $product_type[sizeof($product_type) - 1]; // sets last category in array as bottom-level, steve bug was +1
$product_type = $bottom_level;//steve removed htmlentities, Google no like
} elseif (GOOGLE_PRODUCTS_PRODUCT_TYPE == 'full') {
$full_path = implode(",", $product_type);
$product_type = $full_path;//steve removed htmlentities, Google no like
```4) Duplicated <g:google_product_category> after each item.
> There is duplicated code in both googlefroogle and/classes/ google_base to deal with attributes. I did not investigate this fullly as I don't use attributes.
> I chose to comment out the code in google_base, this may not be the correct solution for your store.
> In any case search for g:google_product_category to find the repeated code.
>
>
> I have added code to the mod to be able to generate each feed with its own store description, currency, and default google category. If anyone wants it for their dual language store, pm me.
Steve, you are amazing! :clap:
Thanks for all the updates too. :bigups:
Totally Zenned
Numinix released a new version yesterday - nothing major but does include a bug fix - don't know what.
http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Zen Follower
delia:
Numinix released a new version yesterday - nothing major but does include a bug fix - don't know what.
http://www.numinix.com/zen-cart-modules/marketing/google-merchant-center-feeder
You rock Delia...:clap:
Hopefully some of the major bugs are fixed....keeping my fingers crossed..
Totally Zenned
PinkLeopard:
Hopefully some of the major bugs are fixed....keeping my fingers crossed..
Only one and he doesn't say what.
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Zen Follower
delia:
Only one and he doesn't say what.
Ok.
Just for the folks here and myself...do you recommend un-installing and re-installing the new version?
Thanks!
Totally Zenned
No, there are no database changes.
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Zen Follower
delia:
No, there are no database changes.
Great!
Also, as I have searched the other forum too...do you have any idea on how to fix that double entry for product category?
Thanks!
Totally Zenned
I haven't seen it happen myself. Would need access to the cart where it's happening before I could figure it out.
The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo
Tell staff why this post should be reviewed.