Forums / All Other Contributions/Addons / [OLD] Google Merchant module Version 1.12.0 by Numinix

[OLD] Google Merchant module Version 1.12.0 by Numinix

Locked

Started by pinkleopard on 20 Oct 2011, 1:25 AM · Views: 113,657

Results 61 to 80 of 567
This thread is locked. New replies are disabled.
22 Oct 2011, 2:12 AM
#61
pinkleopard avatar

pinkleopard

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

22 Oct 2011, 3:06 AM
#62
buildingblocks avatar

buildingblocks

Totally Zenned

Join Date:
Jun 2008
Posts:
629
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

22 Oct 2011, 4:10 AM
#63
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

NOTHING ELSE!!!!!

tOOLS/GOOGLE MERCHANT CENTER TAKES ME OUT TO THE ADMIN HOME PAGE!!!!

Help please.
How do I get out of this dillema

22 Oct 2011, 6:33 AM
#64
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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
22 Oct 2011, 11:36 AM
#65
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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.
22 Oct 2011, 3:38 PM
#66
buildingblocks avatar

buildingblocks

Totally Zenned

Join Date:
Jun 2008
Posts:
629
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

22 Oct 2011, 4:11 PM
#67
sash avatar

sash

New Zenner

Join Date:
Jul 2010
Posts:
99
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

22 Oct 2011, 5:01 PM
#68
candleman avatar

candleman

Zen Follower

Join Date:
May 2008
Posts:
183
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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!

22 Oct 2011, 7:38 PM
#69
mgwirelessllc avatar

mgwirelessllc

New Zenner

Join Date:
Apr 2011
Posts:
29
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

[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:

22 Oct 2011, 8:12 PM
#70
candleman avatar

candleman

Zen Follower

Join Date:
May 2008
Posts:
183
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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!

23 Oct 2011, 12:15 AM
#71
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

23 Oct 2011, 5:19 PM
#72
torvista avatar

torvista

Totally Zenned

Join Date:
Aug 2007
Location:
Gijón, Asturias, Spain
Posts:
2,880
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

Just to summarise what I have found, (in case Numinix reads this)..when adapting this to cope with both english and spanish.

Bugs

  1. 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 
```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...

23 Oct 2011, 10:00 PM
#73
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

torvista:

Just to summarise what I have found, (in case Numinix reads this)..when adapting this to cope with both english and spanish.

Bugs

  1. 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:
23 Oct 2011, 10:11 PM
#75
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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..

23 Oct 2011, 10:14 PM
#76
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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

23 Oct 2011, 10:15 PM
#77
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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!

23 Oct 2011, 10:18 PM
#78
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

No, there are no database changes.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

23 Oct 2011, 10:23 PM
#79
pinkleopard avatar

pinkleopard

Zen Follower

Join Date:
Jun 2009
Posts:
383
Plugin Contributions:
0

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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!

23 Oct 2011, 10:28 PM
#80
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

Re: [OLD] Google Merchant module Version 1.12.0 by Numinix

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