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 81 to 100 of 567
This thread is locked. New replies are disabled.
24 Oct 2011, 2:09 AM
#81
mgwirelessllc avatar

mgwirelessllc

New Zenner

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

[OLD] Google Merchant module Version 1.12.0 by Numinix

all experts:

I got an issue after I installed the new GM 1.12.1 (zencart 1.3.9h), google merchant center gave me "missing unique product identifiers..." even though All of my products have upc code! when I went to GM configuration, change upc/isbn/aen from "false" to "true", none of my products can be inserted AND I got the folllowing:

1054 Unknown column 'p.products_ean' in 'field list'
in:
[SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_upc, p.products_isbn, p.products_ean FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1 AND p.products_type <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 GROUP BY pd.products_name ORDER BY p.products_id ASC;]

Why is that?

I have to change it back to "false", then UPC won't show up in the domain_products_en.xml.

I got a notice from google saying my account will be suspended if I have missing Unique Product Identifiers!!!

Any help? :cry:

24 Oct 2011, 3:51 AM
#82
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

am I the only one who has this problem?!:frusty:

24 Oct 2011, 4:25 AM
#83
saplanet avatar

saplanet

New Zenner

Join Date:
Jun 2008
Location:
Singapore, Australia, America
Posts:
97
Plugin Contributions:
0

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

Installed the latest version 1.12.1.

I checked on the debug log and found one problem:

PHP Warning: file_put_contents() expects parameter 3 to be long, string given in /includes/classes/google_base.php on line 74

Anyone has this problem?

24 Oct 2011, 7:50 AM
#84
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

changes 1.12.0->1.12.1

Since Numinix don't put a changelog anywhere:

  1. the repeated code for the google product category as detailed in my previous post has been removed from googlefroogle.php.
    However this does not fix the problem.

So for those who want to stop this issue, comment out the code in google_base.php. This is a hack as I can't be bothered to second-guess how it should be.

```php

/*steve, causes repeated category
if ($google_product_category_check == false && GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY != '') {
$google_product_category = $dom->createElement('g:google_product_category');
$google_product_category->appendChild($dom->createCDATASection($default_google_product_category));
$item->appendChild($google_product_category);
} */


3) minor text change in the admin config: no need to uninstall/install

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

24 Oct 2011, 8:36 AM
#85
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:

changes 1.12.0->1.12.1

Since Numinix don't put a changelog anywhere:

  1. the repeated code for the google product category as detailed in my previous post has been removed from googlefroogle.php.
    However this does not fix the problem.

So for those who want to stop this issue, comment out the code in google_base.php. This is a hack as I can't be bothered to second-guess how it should be.

```php

/*steve, causes repeated category
if ($google_product_category_check == false && GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY != '') {
$google_product_category = $dom->createElement('g:google_product_category');
$google_product_category->appendChild($dom->createCDATASection($default_google_product_category));
$item->appendChild($google_product_category);
} */

> 
> 3) minor text change in the admin config: no need to uninstall/install

Kudos to Steve! :yes:

However, I finally....got mine to work so for now I am somewhat afraid to upgrade.

For me...and trust me...I am no expert...but I believe the doubling issue was due to attributes not being added.

Thanks to everyone one who has contributed. :bigups:
24 Oct 2011, 1:04 PM
#86
garethrooney avatar

garethrooney

New Zenner

Join Date:
Apr 2009
Posts:
54
Plugin Contributions:
0

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

Have any of you lot that have got it working can you send me a link to your xml feed. Getting dissaproved or invalid on all my products.

Regards

Gareth

24 Oct 2011, 1:17 PM
#87
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

mgwirelessllc:

all experts:

I got an issue after I installed the new GM 1.12.1 (zencart 1.3.9h), google merchant center gave me "missing unique product identifiers..." even though All of my products have upc code! when I went to GM configuration, change upc/isbn/aen from "false" to "true", none of my products can be inserted AND I got the folllowing:

1054 Unknown column 'p.products_ean' in 'field list'
in:
[SELECT distinct(pd.products_name), p.products_id, p.products_model, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, p.products_priced_by_attribute, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, p.products_date_available, m.manufacturers_name, p.products_quantity, pt.type_handler, p.products_weight, p.products_upc, p.products_isbn, p.products_ean FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id)WHERE p.products_status = 1 AND p.products_type <> 3 AND p.product_is_call <> 1 AND p.product_is_free <> 1 AND pd.language_id = 1 GROUP BY pd.products_name ORDER BY p.products_id ASC;]

Why is that?

I have to change it back to "false", then UPC won't show up in the domain_products_en.xml.

I got a notice from google saying my account will be suspended if I have missing Unique Product Identifiers!!!

Any help? :cry:

How did you put the UPC codes in? With a Numinix mod? I believe that is what is intended - the error message is saying that you don't have the necessary field from one of his mods.

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

24 Oct 2011, 1:19 PM
#88
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

garethrooney:

Have any of you lot that have got it working can you send me a link to your xml feed. Getting dissaproved or invalid on all my products.

Regards

Gareth

If google is not approving your products and you are not getting error messages in your google account, contact them to find out why.

If you do have warnings about serious errors, those have to be corrected.

Looking at someone else's xml feed will not tell you anything.

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

24 Oct 2011, 1:31 PM
#89
garethrooney avatar

garethrooney

New Zenner

Join Date:
Apr 2009
Posts:
54
Plugin Contributions:
0

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

delia:

If google is not approving your products and you are not getting error messages in your google account, contact them to find out why.

If you do have warnings about serious errors, those have to be corrected.

Looking at someone else's xml feed will not tell you anything.

From reading the various forums posts on the google base forum I am coming to the same conclusion. These forums are pure comedy gold if anyone is interested!!!

No errors what so ever all just disapproved or invalid.

I've requested them to look at it again to see what happens

I've developed a real strong dislike for google trying to get this working!

Regards

Gareth

24 Oct 2011, 1:39 PM
#90
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

Google does have rules and they have changed. One of my customers didn't have any problems for a long time and suddenly his feed was disapproved last summer. We tracked it to certain products on his site that were not steroids but must have had some text in them that made the google bot think so. He had them look at it again and he is finally back in business.

Just remember it is a free service - and it comes with strings.....

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

24 Oct 2011, 1:44 PM
#91
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

saplanet:

Installed the latest version 1.12.1.

I checked on the debug log and found one problem:

PHP Warning: file_put_contents() expects parameter 3 to be long, string given in /includes/classes/google_base.php on line 74

Anyone has this problem?

Do you mean that this shows while you are exporting - or is that a cache error message? There is not a debug log to my knowledge.

I couldn't duplicate that anywhere.

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

24 Oct 2011, 4:35 PM
#92
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

One final question.
Does this version replace all the spaces in the image names with %20 as per googles requirements or is this something I need to address?
None of my images are showing even though I have the setting to my http://www.candlewithcare.co.uk/images/ folder as this.
It has been over 72 hours now as well

https://www.candlewithcare.co.uk
Luxury Scented
Candles at great prices!

24 Oct 2011, 5:22 PM
#93
rescoccc avatar

rescoccc

Totally Zenned

Join Date:
May 2010
Location:
WA State
Posts:
1,700
Plugin Contributions:
2

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

mgwirelessllc:

all experts:

I got an issue after I installed the new GM 1.12.1 (zencart 1.3.9h), google merchant center gave me "missing unique product identifiers..." even though All of my products have upc code! when I went to GM configuration, change upc/isbn/aen from "false" to "true", none of my products can be inserted AND I got the folllowing:

1054 Unknown column 'p.products_ean' in 'field list'

Why is that?

I have to change it back to "false", then UPC won't show up in the domain_products_en.xml.

I got a notice from google saying my account will be suspended if I have missing Unique Product Identifiers!!!

Any help? :cry:

Are you using Numinix Product Fields or the UPC/ISBN mod from software addons? If the latter, that is likely the problem. You need to use the former.

The best way to learn is to try stuff. But, back it up first.

24 Oct 2011, 8:44 PM
#94
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

In post #84 I recommended commenting out some code in google_base to stop the creation of two <g:google_product_category> after each item.

I found that by doing that, the few items I have with attributes were not assigned this field.

So, I've commented out the code in googlefroogle.php instead and that seems to work for both simple and attributed products.

 /*if (GOOGLE_PRODUCTS_DEFAULT_PRODUCT_CATEGORY != '') {//steve commented out to stop duplication
                  $google_product_category = $dom->createElement('g:google_product_category');
                  $google_product_category->appendChild($dom->createCDATASection($default_google_product_category));
                  $item->appendChild($google_product_category);
                }*/

Steve
github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

24 Oct 2011, 9:56 PM
#95
spawnie69 avatar

spawnie69

Totally Zenned

Join Date:
Sep 2005
Location:
Ocala, FL
Posts:
527
Plugin Contributions:
0

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

I had the previous version installed and uninstalled sql patches and installed the new one and then uploaded the new files and I am able to create my googlebase XML file using the Google Merchant Center Feeder.

"Google Merchant Center Feeder v1.12.1 started 2011/10/24 15:54:24
Feed file - /XXXXX/XXXXXX/public_html/feed/google/XXXXXX_products_en_2.xml
Processing: Feed - Yes, Upload - No
Google Merchant Center File Complete In 0.095126 Seconds 2 of 2 Records"

Then when i click the created file I get the following message "Internet Explorer cannot display this feed” Feed error code. Do you guys know why I am getting this error message? I believe I'm supposed to see the actual xml file showing me all the products with pics and description. If anyone can shed some light on this for me, I would great appreciate it.

24 Oct 2011, 11:34 PM
#96
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

garethrooney:

Have any of you lot that have got it working can you send me a link to your xml feed. Getting dissaproved or invalid on all my products.

Regards

Gareth

After several attempts and working on it endlessly...YES...I have mine working and my items are now searchable with Google

You have to follow all of Google's Guidelines. See the link below.

read this

24 Oct 2011, 11:37 PM
#97
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:

Google does have rules and they have changed. One of my customers didn't have any problems for a long time and suddenly his feed was disapproved last summer. We tracked it to certain products on his site that were not steroids but must have had some text in them that made the google bot think so. He had them look at it again and he is finally back in business.

Just remember it is a free service - and it comes with strings.....

Perfectly said :smartalec:

25 Oct 2011, 3:37 AM
#98
dolleface avatar

dolleface

New Zenner

Join Date:
Jan 2011
Posts:
15
Plugin Contributions:
0

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

My feeder wasn't uploading at all. I used this post and managed to get 21 items from 309 to upload but they have errors and are not searchable. I am pasting the first few lines of my .xml. Please help I ma desperate as i am not getting traffic at all. It seems everything is messed up. My feeder was downloaded by numinix and it has never worked. The 21 items that uploaded i had to go in and change the info one by one. This thing was suppose to auto populate but it seems it is not. Is there a way i can write one code and it will apply to the entire website and auto populate? If someone can help i am willing to reinstall the whole thing.
I have paid to have this installed twice and they both are not working!!! please help

<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0"> <channel> <title><![CDATA[MissDiza.com]]></title> <link>http://missdiza.com</link> <description>fashion jewley<![CDATA[]]></description> <g:expiration_date>2011-11-01</g:expiration_date> <g:availability>In Stock</g:availability> <g:condition>new</g:condition> <g:product_type>jewelry<![CDATA[Trendy - Necklaces]]></g:product_type> <item>
25 Oct 2011, 2:46 PM
#99
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

dolleface:

My feeder wasn't uploading at all. I used this post and managed to get 21 items from 309 to upload but they have errors and are not searchable. I am pasting the first few lines of my .xml. Please help I ma desperate as i am not getting traffic at all. It seems everything is messed up. My feeder was downloaded by numinix and it has never worked. The 21 items that uploaded i had to go in and change the info one by one. This thing was suppose to auto populate but it seems it is not. Is there a way i can write one code and it will apply to the entire website and auto populate? If someone can help i am willing to reinstall the whole thing.
I have paid to have this installed twice and they both are not working!!! please help

I don't think it's the module not working. What are the error messages you get in your google merchant admin? Are you saying that it exports 309 but google stops at 21?

If so, then look to google to find out why. My guess is that you have invalid characters in your descriptions or you have used an ampersand in one of your image names.

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

26 Oct 2011, 5:56 AM
#100
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

dolleface:

My feeder wasn't uploading at all. I used this post and managed to get 21 items from 309 to upload but they have errors and are not searchable. I am pasting the first few lines of my .xml. Please help I ma desperate as i am not getting traffic at all. It seems everything is messed up. My feeder was downloaded by numinix and it has never worked. The 21 items that uploaded i had to go in and change the info one by one. This thing was suppose to auto populate but it seems it is not. Is there a way i can write one code and it will apply to the entire website and auto populate? If someone can help i am willing to reinstall the whole thing.
I have paid to have this installed twice and they both are not working!!! please help

<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:g="http://base.google.com/ns/1.0"> <channel> <title><![CDATA[MissDiza.com]]></title> <link>http://missdiza.com</link> <description>fashion jewley<![CDATA[]]></description> <g:expiration_date>2011-11-01</g:expiration_date> <g:availability>In Stock</g:availability> <g:condition>new</g:condition> <g:product_type>jewelry<![CDATA[Trendy - Necklaces]]></g:product_type> <item>

Delia is correct. Read her post. This happened to me several times and I had to correct each one within my store. Then I would confirm again and check to see if there were anymore errors. It takes time to make the corrections but it is well worth it. Good luck.