[OLD] Google Merchant module Version 1.12.0 by Numinix

This is the NEW thread for the latest version of Numinix Google Merchant Version: 1.12.0

1. If you have any prior version of GM installed you must un-install by using the sql un-install located in the file.
2. Install the NEW sql patch.
3. Upload all NEW files.
4. Make sure the feed/goolge file is chmod at 755 or 777

Google Requirements:

1. Basic Product Information

A .id [id]- An identifier of the item
B. title [title] - Title of the item
C. description [description] - Description of the item
D. google product category [google_product_category] - Google's category of the item
E. product type [product_type] - Your category of the item
F. link [url] - URL directly linking to your item's page on your website
G. image link [image_link] - URL of an image of the item
H. additional image link [additional_image_link] - Additional URLs of images of the item
I. condition [condition] - Condition or state of the item

All of these conditions should be automatic if everything is set-up correctly with your Zen-Cart.

Troubleshooting:

D. google product category [google_product_category] - Google's category of the item

This is a must. You have to follow Google's cateogry tree. I had to change all of my categories to match theirs.
How I did it (and it took me a full day to do it) is I made the required categories for my products and moved my items to the right categories. If anyone knows a better way, then please post it.

Here's their category tree:

catergory tree here

Example: If I sell shoes, then my categories would be the following:

Shoes - Main category

Sub categories:

Athletics Shoes

Boots

Flats

High Heel Shoes

Loafers & Moccasins

Outdoor Shoes

Sandals

Slippers

Trainers

2. Availability & Price

A. availability [availability] - Availability status of the item

1. Your Zen-Cart must have "show quantity stock set to 1.
2. Your GM config must have Show Quantity (true) & Default Quantity (1)

B. price [price] - Price of the item
C. sale price [sale_price] - Advertised sale price of the item
D. sale price effective date [sale_price_effective_date] - Date range during which the item is on sale

3. Unique Product Identifiers

A. brand [brand] - Brand of the item
B. gtin [gtin] - Global Trade Item Number (GTIN) of the item
C. mpn [mpn] - Manufacturer Part Number (MPN) of the item

These are the most common problems. Please read first before posting.

For more information Product Feed Specification

click here

Hi,
I have zen 1.3.8a with gm 1.12.0 with numix prod mod.

My configuration is ok.
I have GMF in the tools menu BUT WHEN I CLICK ON IT I'm taken out to the ADMIN home screen.

I uninstalled patches from 1.9.0 til present and reinstalled them but still go to ADMIN home screen!!

What is missing??

Thanks

marvin:

Hi,
I have zen 1.3.8a with gm 1.12.0 with numix prod mod.

My configuration is ok.
I have GMF in the tools menu BUT WHEN I CLICK ON IT I'm taken out to the ADMIN home screen.

I uninstalled patches from 1.9.0 til present and reinstalled them but still go to ADMIN home screen!!

What is missing??

Thanks

Marvin, did you completely un-install it and re-install the new version?

Here is a fix for the Shipping Country problem:

You can fix this by editing your admin/includes/functions/extrafunctions/googlefroogle.php

if (!function_exists('google_cfg_pull_down_country_list')){
	function google_cfg_pull_down_country_list($countries_id, $key = '') {
		global $db;
		$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
		$countries = $db->execute("select countries_id, countries_iso_code_3 from " . TABLE_COUNTRIES);
		$countries_array = array();
		while (!$countries->EOF) {
			$countries_array[] = array('id' => $countries->fields['countries_id'],
				'text' => $countries->fields['countries_iso_code_3']);
			$countries->MoveNext();
		}
		return zen_draw_pull_down_menu($name, $countries_array, $countries_id);
	}
}

Make sure you add it above:

?>

PinkLeopard:

Marvin, did you completely un-install it and re-install the new version?

Are you talking about the 1.12.0 mod or the sql file?

Hi
Installed v 1.12.0 1.39h cart
no previous versions installed. new fresh install

Feeds producing double google categories:

<g:google_product_category><![CDATA[Arts & Entertainment > Collectibles]]></g:google_product_category>

<g:google_product_category><![CDATA[Arts & Entertainment > Collectibles]]></g:google_product_category>

Regarding availability setting, I have a question

I want to include Zero Quantity item in the feed and availability will be marked as <g:availability>out of stock</g:availability>

I found that only non-zero quantity item have availability included
<g:availability>in stock</g:availability>

However, Zero Quantity item will not create <g:availability>

Can anyone help?

Thanks

mikebr:

Hi
Installed v 1.12.0 1.39h cart
no previous versions installed. new fresh install

Feeds producing double google categories:

<g:google_product_category><![CDATA[Arts & Entertainment > Collectibles]]></g:google_product_category>

<g:google_product_category><![CDATA[Arts & Entertainment > Collectibles]]></g:google_product_category>

This is just a guess:

Do you have this twice on your product page?

<meta http-equiv="imagetoolbar" content="no" />
<meta http-equiv="imagetoolbar" content="no" />

pe1234ter:

Regarding availability setting, I have a question

I want to include Zero Quantity item in the feed and availability will be marked as <g:availability>out of stock</g:availability>

I found that only non-zero quantity item have availability included
<g:availability>in stock</g:availability>

However, Zero Quantity item will not create <g:availability>

Can anyone help?

Thanks

If I understand you correctly you want to create "out of stock".

To the best of my knowledge I don't think Google will allow that. Items must be in stock.

PinkLeopard:

If I understand you correctly you want to create "out of stock".

To the best of my knowledge I don't think Google will allow that. Items must be in stock.
I checked in Google, they accept <g:availability>out of stock</g:availability>
http://www.google.com/support/merchants/bin/answer.py?hl=en&answer=188494#other

However, I don't really know the search results will include 'out of stock' items or not.

The reason to include 'out of stock' items in the feed, is to let customers know items may back in stock later.

I will try another <g:availability> value 'preorder', just using find and replace with some text editor.
Let see search results will include 'preorder' items or not.

pe1234ter:

I checked in Google, they accept <g:availability>out of stock</g:availability>
http://www.google.com/support/merchants/bin/answer.py?hl=en&answer=188494#other

However, I don't really know the search results will include 'out of stock' items or not.

The reason to include 'out of stock' items in the feed, is to let customers know items may back in stock later.

I will try another <g:availability> value 'preorder', just using find and replace with some text editor.
Let see search results will include 'preorder' items or not.

What happens when you confirm and read your .xml file?

What does it say?

PinkLeopard:

What happens when you confirm and read your .xml file?

What does it say?

The data feed status is all items inserted when I have some items <g:availability>out of stock</g:availability>

However, seems I cannot find it in Google shopping search result for those out of stock items.

Now I changed them to <g:availability>available for order</g:availability>

This is also accepted according to their Four predefined values accepted:

* 'in stock'
* 'available for order'
* 'out of stock'
* 'preorder'

My solution is using text editor and find <g:quantity>0</g:quantity>

replace it with

<g:quantity>0</g:quantity><g:availability>available for order</g:availability>

pe1234ter:

The data feed status is all items inserted when I have some items <g:availability>out of stock</g:availability>

However, seems I cannot find it in Google shopping search result for those out of stock items.

Now I changed them to <g:availability>available for order</g:availability>

This is also accepted according to their Four predefined values accepted:

* 'in stock'
* 'available for order'
* 'out of stock'
* 'preorder'

My solution is using text editor and find <g:quantity>0</g:quantity>

replace it with

<g:quantity>0</g:quantity><g:availability>available for order</g:availability>

Hummmm not sure if 0 is a good idea.

You can leave it at available for order if that is what you choose.

You have confirmed, uploaded to google and everything is ok except attribute availability?

If so, your search will be not be visible for about 24-48 hours.

im running version 1.3.8 zencart with merchant 1.12.0 and have an issue.
I have 109 products around 80 in stock and the rest out of stock.
The feed is uploading ok but with warnings but it is only uploading 73 items of which it is inserting only 72.
the items it is not inserting are in stock, there are items that are out of stock that have been inserted.

there is a feed level message and 2 warnings.

XML formatting error - Error
Our system encountered an error when processing your data feed.
Learn more.
Examples: Examples:

Line No. Column No.
2,023 23

Missing recommended attribute: google product category (72 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

Missing recommended attribute: brand (1 warning)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
Examples: Examples:

interestingly if I try and open the product feed through zencart I get the following error message.

An invalid character was found in text content.
Line: 2023 Character: 23

  <title><![CDATA[

CandleMan:

im running version 1.3.8 zencart with merchant 1.12.0 and have an issue.
I have 109 products around 80 in stock and the rest out of stock.
The feed is uploading ok but with warnings but it is only uploading 73 items of which it is inserting only 72.
the items it is not inserting are in stock, there are items that are out of stock that have been inserted.

there is a feed level message and 2 warnings.

XML formatting error - Error
Our system encountered an error when processing your data feed.
Learn more.
Examples: Examples:

Line No. Column No.
2,023 23

For this particular type of problem you will need to download your feed, open it up in an editor, view the error and fix it.

Once this error is resolved you will have to download a fresh copy each time an error appears because the lines & columns change.

I had this problem continuously until all my errors were fixed.

CandleMan:

im running version 1.3.8 zencart with merchant 1.12.0 and have an issue.
I have 109 products around 80 in stock and the rest out of stock.
The feed is uploading ok but with warnings but it is only uploading 73 items of which it is inserting only 72.
the items it is not inserting are in stock, there are items that are out of stock that have been inserted.

there is a feed level message and 2 warnings.

XML formatting error - Error
Our system encountered an error when processing your data feed.
Learn more.
Examples: Examples:

Line No. Column No.
2,023 23

Missing recommended attribute: google product category (72 warnings)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.

Missing recommended attribute: brand (1 warning)
While items missing recommended attributes will process successfully, we recommend including relevant attributes if they are available.
Examples: Examples:

interestingly if I try and open the product feed through zencart I get the following error message.

An invalid character was found in text content.
Line: 2023 Character: 23

  <title><![CDATA[

Your other two answers can be found here.

click here.

More important information for the Googler's:

exemptions are only for the
three global-trade attributes --
gtin, mpn, brand --
nothing else.

google_product_category
classifies the physical item --
regardless of age or condition --
and must be an exact google value.

a google_product_category value cannot
be changed, modified, or augmented in
any way whatsoever; you cannot change
any google_product_category value.

I have question that is sort of linked to the 'out of stock' issues some other posters have mentioned.

We have products that can only be purchased in store due to Sony's requirements. But we want these products to appear on Google Shopping so that customers who are interested can visit the showroom & purchase them.

Now we have set these products as 'call for price' via the admin section. On the page it does display the product price but simply has 'This product can only be bought in store' as the only option. You can view the product here .

The products are listed as in stock and have quantity assigned to them. Does anyone know how we can get these products to be generated by the Google Merchant Centre Feed?

Has anyone else noticed ```html
<g:product_type></g:product_type>

In version 1.12.00 we have one item that is missing the product type tag every time a feed is generated but all other 500+ items have the product type tag. I can't figure out why just the one item isn't getting it.

Maybe a stupid question, But even they need answered lol,,

Our site sells a variety of items of different descriptions,, in Google Taxonomy can i add more than one catergory because only choosing one from the tree master category wont include other items,,

for example if i had this items i could add this :

Arts & Entertainment > Collectables > Rocks & Fossils

then : Office Supplies > General Office Supplies > Labels & Tags