If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Admin Tools / Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Started by divavocals on 1 Apr 2012, 11:10 PM · Views: 153,737

Results 201 to 220 of 505
27 Jul 2014, 7:59 PM
#201
boxcar avatar

boxcar

New Zenner

Join Date:
Jun 2007
Posts:
47
Plugin Contributions:
0

Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Looks like Google Merchant Center Feeder will need to be update because of change to "availability" attribute in this announcement from Google for changes going into effect on 9/30/14.

https://support.google.com/merchants/answer/3097504?hl=en

"We are simplifying the ‘availability’ attribute by merging ‘in stock’ with ‘available for order’ and removing ‘available for order’. All items that can be shipped in a timely manner can now simply use the ‘in stock’ value. In addition, we are now offering an ‘availability date’ attribute that you can use to let shoppers know when pre-ordered products will be available for delivery."

4 Aug 2014, 5:40 PM
#202
toomanyknots avatar

toomanyknots

Zen Follower

Join Date:
Jun 2014
Location:
hamilton, ohio
Posts:
100
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

So I moved my site to a different host, and re-did a good amount of my site. Now I am getting this error for some reason when I try to upload a feed:


"Invalid URL in attribute: link

We couldn't understand the URL you submitted. Please check the format of your URL. Learn more.
Examples:
Item ID Line Nr. Value
1 21 http://208.76.85.155/~jrvihfnf/newftp/index.php?main_page=product_info&products_id=1&currency=USD Show Item
3 69 http://208.76.85.155/~jrvihfnf/newftp/index.php?main_page=product_info&products_id=3&currency=USD Show Item
10 190 http://208.76.85.155/~jrvihfnf/newftp/index.php?main_page=product_info&products_id=10&currency=USD Show Item
12 238 http://208.76.85.155/~jrvihfnf/newftp/index.php?main_page=product_info&products_id=12&currency=USD Show Item
15 310 http://208.76.85.155/~jrvihfnf/newftp/index.php?main_page=product_info&products_id=15&currency=USD Show Item"***

So I am not sure how to fix this. I think they are redirects that work in the browser, but google doesn't like it for some reason. Is there anyway I can fix this by tinkering with zencarts or google merchant feeders settings? I wasn't getting these errors a week ago so I would think it was something I changed within my zencart, or something that got changed when I moved my site? Should I re-install google merchant feeder?

4 Aug 2014, 5:46 PM
#203
toomanyknots avatar

toomanyknots

Zen Follower

Join Date:
Jun 2014
Location:
hamilton, ohio
Posts:
100
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Is there a way to make google merchant feeder not show the &currency=USD redirect link, and instead use the main link? Or Could id be invalid because I moved hosts and am using a temp url instead of my domain name (until I get my domain transferred) ?

4 Aug 2014, 6:18 PM
#204
toomanyknots avatar

toomanyknots

Zen Follower

Join Date:
Jun 2014
Location:
hamilton, ohio
Posts:
100
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Well i called google, and they said it was just because I am using a temp url, which makes sense. So please disregard, :).

15 Aug 2014, 12:28 PM
#205
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Invalid additional images.

When looking at the data quality in the merchant centre, it shows i have over 500 items with errors on additonal images.

any ideas??


1 Sep 2014, 3:46 PM
#206
izar74 avatar

izar74

Zen Follower

Join Date:
Mar 2009
Location:
Italy
Posts:
155
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Hi all,

after many try i've found a solutions to add a field to the feeder (I needed the GTIN code as well as MPN code).

  1. First of all You need to add the filed to your database, in my case i added "products_gtin" to the "products" table.
  2. You need to modify the ..\classes\google_base.php adding a statement to add the field to the XML file as follow:
  • Around line 393 find: ```php
    if ($products->fields['products_model'] != '') {
    $mpn = $dom->createElement('g:mpn');
    $mpn->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_model'])));
    $item->appendChild($mpn);
    }
 -immediaty after add the following code: ```php
if ($products->fields['products_gtin'] != '') {
        $gtin = $dom->createElement('g:gtin');
        $gtin->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_gtin'])));
        $item->appendChild($gtin);
      }
  1. Modify the "googlefroogle.php" file addiing the definition of your new field:
    -Line 152 add the fields you create to the query: ```php
    $products_query = "SELECT distinct(pd.products_name), p.products_id, p.products_model, p.products_gtin,...
  -Line 227 add a "case":```php
case 'gtin':
                  if ($products->fields['products_gtin']) {
                    $id = $google_base->google_base_xml_sanitizer($products->fields['products_gtin']);
                    break;
                  }

Now you should have a new field added to the feed :-)

12 Sep 2014, 7:38 PM
#207
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

leviathan:

If you are still looking for help here, I have a small code edit you can do to get this working. The code edit is simple (about 4 lines) and will insert the identifier_exists = false element into the XML output. It will ONLY insert this if you DO NOT have UPC/ISBN/EAN set for your products. You will have to have the "UPC/ISBN/EAN" configuration option set to true in the google merchant configuration area, and this does require numinix product fields being installed.

STEP 0: BACK UP your_catalog/includes/classes/google_base.php
Step 1: Open your_catalog/includes/classes/google_base.php
Step 2: Go to ~ line 409
Step 3: Replace the following:

} elseif ($products->fields['products_ean'] != '') {$ean = $dom->createElement('g:ean');$ean->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_ean'])));$item->appendChild($ean);} }

> 
> with
> 
> ```php
} elseif ($products->fields['products_ean'] != '') {$ean = $dom->createElement('g:ean');$ean->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_ean'])));$item->appendChild($ean);} else {$identifier_exists = $dom->createElement('g:identifier_exists');$identifier_exists->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer('False')));$item->appendChild($identifier_exists);}}

Step4: Save the file.

You can verify that the feed is correct by viewing the xml source and searching for identifier_exists. Any product without UPC/ISBN/EAN should have this field set.

Enjoy!

Lev

Code has not impact on my output xml. There is no EAN field and there is no EAN:False

before http://www.solarcamper.com.au/domain_products_en_before.xml
after http://www.solarcamper.com.au/domain_products_en_after.xml

===========================================
I want to use this to value False on EAN(GTIN) and brand, and see if that helps my failing submission (rather than using attributes controller to add all of them).

Brand:```php
if ($products->fields['manufacturers_name'] != '') { $manufacturers_name = $dom->createElement('g:brand'); $manufacturers_name->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['manufacturers_name']))); $item->appendChild($manufacturers_name);
// same as above ?
} else {$identifier_exists = $dom->createElement('g:identifier_exists');$identifier_exists->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer('False')));$item->appendChild($identifier_exists); }





===========================================
My Error: Insufficient product identifiers: Missing two out of three attributes [GTIN, brand, mpn]22 errors.
 
Google requires GTIN, I am hoping they see EAN as the same. 
 
My MPN's are not missing but incorrect. 



Google says: *if the required data does not currently exist then the **item may be submitted with an identifier_exists and **a value of FALSE*
 
*if the data exists but is not submitted then that is **grounds for disapproval or suspension at any time; **invalid or self-assigned data is not allowed.*
 
So because Brand and EAN probably exist but are not entered I may still get errors using value False, so maybe I do need to enter them but first I would like to test the false value without needing to add it in attributes controller if possible.
12 Sep 2014, 8:31 PM
#208
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

vandiermen:

Code has not impact on my output xml. There is no EAN field and there is no EAN:False
I installed numinix product fields, and optional_fields\upc_isbn which has the EAN field. I can now add the EAN field directly to items but still no default false

12 Sep 2014, 8:41 PM
#209
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

if anyone has made a numinix product field for brand, can you send it to me or post it here... Oh I forget: the Manufacturers (admin> catalog> Manufacturers) are used for brand... ignore this question.

12 Sep 2014, 8:55 PM
#210
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

vandiermen:

Code has not impact on my output xml. There is no EAN field and there is no EAN:False

I fixed it, what I did wrong was not follow the simple instructions of leviathan.
"You will have to have the "UPC/ISBN/EAN" configuration option set to true in the google merchant configuration area"
Sorry for posting.

12 Sep 2014, 9:23 PM
#211
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

If you use the code from leviathan you will get

<g:identifier_exists><=!=[=C=D=A=T=A=[False]=]=></g:identifier_exists>

simply change identifier_exists to ean or gtin
and you will get

<g:gtin><=!=[=C=D=A=T=A=[False]=]=></g:gtin>

Change

elseif ($products->fields['products_ean'] != '') {
          $ean = $dom->createElement('g:ean');
          $ean->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_ean'])));
          $item->appendChild($ean);    } 
 

to

elseif ($products->fields['products_ean'] != '') {
          $ean = $dom->createElement('g:ean');
          $ean->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['products_ean'])));
          $item->appendChild($ean); 
   } else {$identifier_exists = $dom->createElement('g:gtin');
$identifier_exists->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer('False')));
$item->appendChild($identifier_exists);        }  
 

And if you want to create a default Brand value as False:

Change

      if ($products->fields['manufacturers_name'] != '') {
        $manufacturers_name = $dom->createElement('g:brand');
        $manufacturers_name->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['manufacturers_name'])));
        $item->appendChild($manufacturers_name);
      }

to

if ($products->fields['manufacturers_name'] != '') {
        $manufacturers_name = $dom->createElement('g:brand');
        $manufacturers_name->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['manufacturers_name'])));
        $item->appendChild($manufacturers_name);
     } else {$identifier_exists = $dom->createElement('g:brand');
$identifier_exists->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer('False')));
$item->appendChild($identifier_exists);        }  

==========================
Before update my error was:
Insufficient product identifiers: Missing two out of three attributes [GTIN, brand, mpn]22 errors.

After update:
Invalid GTIN value 22 errors.
Please make sure the value is a valid UPC-A (GTIN-12), EAN/JAN (GTIN-13), or GTIN-14. Learn more
Examples:...

I am working on the new error. But thankfully half has been fixed.

12 Sep 2014, 9:49 PM
#212
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

My code was incorrect,
incorrect: <g:gtin><=!=[=C=D=A=T=A=[False]=]=></g:gtin> This is giving a displayable value of False to GTIN
correct: <g:identifier_exists><=!=[=C=D=A=T=A=[False]=]=></g:identifier_exists>This is giving a the correct invisible value of False to GTIN and Brand
So follow leviathan original code.

Either way google does not accept it, and requires Brand or GTIN and/or MPN (2 of 3 I think. GTIN is optional if you have Brand I think)

12 Sep 2014, 10:18 PM
#213
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

p.s.
Adding Brand alone fixed GTIN and MPN errors.

Because I do not know what the brand name is I used the Business name as default (I hope google don't disqualify me for this, but it is working for now)

I added default brand name by editing ..\classes\google_base.php

```
if ($products->fields['manufacturers_name'] != '') { $manufacturers_name = $dom->createElement('g:brand');
$manufacturers_name->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['manufacturers_name'])));
$item->appendChild($manufacturers_name);

  }
">
to 

```
        if ($products->fields['manufacturers_name'] != '') {        $manufacturers_name = $dom->createElement('g:brand');
        $manufacturers_name->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer($products->fields['manufacturers_name'])));
        $item->appendChild($manufacturers_name);
     } else {$identifier_exists = $dom->createElement('g:brand');
$identifier_exists->appendChild($dom->createCDATASection($this->google_base_xml_sanitizer('MY BRAND NAME HERE')));

$item->appendChild($identifier_exists);        }

Most products have a brand name so you're better off adding it in the Zencart Admin Manufactures (this works and will fix your GTIN and Brand error).

20 Sep 2014, 8:08 PM
#214
wiccanwitch420 avatar

wiccanwitch420

Zen Follower

Join Date:
Nov 2008
Posts:
196
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

boxcar:

Looks like Google Merchant Center Feeder will need to be update because of change to "availability" attribute in this announcement from Google for changes going into effect on 9/30/14.

https://support.google.com/merchants/answer/3097504?hl=en

"We are simplifying the ‘availability’ attribute by merging ‘in stock’ with ‘available for order’ and removing ‘available for order’. All items that can be shipped in a timely manner can now simply use the ‘in stock’ value. In addition, we are now offering an ‘availability date’ attribute that you can use to let shoppers know when pre-ordered products will be available for delivery."

Has anyone figure this out yet??

20 Sep 2014, 11:00 PM
#215
vandiermen avatar

vandiermen

Totally Zenned

Join Date:
Feb 2007
Posts:
518
Plugin Contributions:
1

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

WiccanWitch420:

Has anyone figure this out yet??

It is already a part of the current version of Google Merchant Center Feeder for ZC v1.5.x

My XML : ```
<g:availability>in stock</g:availability>


Also in Google Merchant Center diagnosis shows availability field correctly specified for all my items
22 Sep 2014, 12:28 PM
#216
dp_web avatar

dp_web

New Zenner

Join Date:
Jan 2009
Posts:
25
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Hi,

Google is now checking for a mobile store/landing page of all products submitted.

We use a sniffer/redirect for mobile users which changes our URL's from:

www.sitename.com/index.php?main_page=product_info&products_id=309

to

www.sitename.com/mobile.php?main_page=product_info&products_id=309

... but Google now thinks this is incorrect / erroring (404) and rejecting the feed.

Is there a way to out put the new link into the correct tag for the feed to work? The <link> tag is fine, and Google wants the <mobile-link> too. I can't manually add these to the output file of 500+ products on a weekly basis. Can I automate it so that I get almost the same URL output, just with the link/mobile-link and the index.php/mobile.php changed?

Google spec: https://support.google.com/merchants/answer/188494

Any ideas?

23 Sep 2014, 6:57 AM
#217
insomn1azc avatar

insomn1azc

New Zenner

Join Date:
Jun 2014
Posts:
9
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Hi there,

just installed the module but cant figure out how exactly i get it to work. Installation worked fine without Errors. After setting up the configurationen i attempted to run this thing.
After a short peroid i get the message:

Google Merchant Center Feeder v1.14.3 started 2014/09/23 08:22:05

Feed file - XXX/feed/google/blabla.xml

Processing: Feed - Yes, Upload - Yes

Nothing happens after that. The XML doesnt show up in the /feed/google/ folder and/or in my Google Merchant Center...?! What am i doing wrong?

25 Sep 2014, 2:10 PM
#218
dp_web avatar

dp_web

New Zenner

Join Date:
Jan 2009
Posts:
25
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

boxcar:

Looks like Google Merchant Center Feeder will need to be update because of change to "availability" attribute in this announcement from Google for changes going into effect on 9/30/14.

https://support.google.com/merchants/answer/3097504?hl=en

"We are simplifying the ‘availability’ attribute by merging ‘in stock’ with ‘available for order’ and removing ‘available for order’. All items that can be shipped in a timely manner can now simply use the ‘in stock’ value. In addition, we are now offering an ‘availability date’ attribute that you can use to let shoppers know when pre-ordered products will be available for delivery."

With the ability to add a 'date expected' option into a Zen Cart product, the output file should change the 'availability' tag from 'in-stock' to 'pre-order' so that Google will still allow the feed, and know that you are taking pre-orders. The plug-in just outputs everything as 'in-stock' even if the 'date-available' option is used.

Can/will this get an update?

19 Oct 2014, 1:47 AM
#219
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

Installed latest version on 1.5. also have stock by attribute and each variant quantity entered (stock combination). Stock by attribute is selected in google merchant center feeder setting but still it does not include product with attribute in out put file.
Any idea how to fix this?

Thanks

27 Oct 2014, 3:33 PM
#220
jokkah avatar

jokkah

New Zenner

Join Date:
Aug 2014
Location:
Northern Virginia
Posts:
81
Plugin Contributions:
0

Re: Google Merchant Center Feeder for ZC v1.5.x [Support Thread]

So, is this plugin broken? I don't want to install it after seeing so many pages of problems people are running into. :(