Zen Cart Logo
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]

Views: 153,448

Results 21 to 40 of 505
7 May 2012, 1:58 AM
#21
dnwmarket avatar

dnwmarket

New Zenner

Join Date:
Sep 2010
Location:
Tampa, Fl.
Posts:
66
Plugin Contributions:
0

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

Hi if anyone is on now please can you give me some advice or point me in the right direction. I have installed the latest Google merchant Feeder for v1.5 but I am having problems. One when I try to upload my items only 58 out of 381 is uplaoded. Now when I try to view my feed I get Feed Error Code.

Please help

10 May 2012, 8:50 PM
#22
gerjan avatar

gerjan

New Zenner

Join Date:
Dec 2007
Posts:
74
Plugin Contributions:
0

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

Hi All! I searched here, on the 1.3.x and Numinix forum but can't find an answer (althought the problem has been mention there :( )

Here's my debug:

[10-May-2012 22:09:37] PHP Warning:  fopen(/***/public_html/module_version/google_merchant_center_feeder.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in ***/public_html/includes/classes/google_base.php on line 81
[10-May-2012 22:09:37] PHP Warning:  filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /***/public_html/module_version/google_merchant_center_feeder.txt in /***/public_html/includes/classes/google_base.php on line 82
[10-May-2012 22:09:37] PHP Warning:  fread(): supplied argument is not a valid stream resource in /***/public_html/includes/classes/google_base.php on line 82
[10-May-2012 22:09:37] PHP Warning:  fclose(): supplied argument is not a valid stream resource in /***/public_html/includes/classes/google_base.php on line 83

From what I understand it says that "public_html/module_version/google_merchant_center_feeder.txt" is missing. But this file can not be found in the downloaded package (both ZC and Numinix downloads).

Forgive me if I did not see the answer if it's already somewhere....

22 May 2012, 12:28 PM
#23
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

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

I am having this problem

Zen 1.50 running 1.13.0

Files were trying to be generated so it just hangs.
So I tried making smaller file. It worked.
Called my Server company. Aparently they say the process took so much resources
that they shut down my cpu usage when it runs.
Someone suggested I optimize my database ( so I did)
When I ran the program again. It gave me an error

[22-May-2012 03:27:04 UTC] PHP Warning: fopen(/public_html/module_version/google_merchant_center_feeder.txt) [<a href='function.fopen'>function.fopen</a>]: failed to open stream: No such file or directory in /includes/classes/google_base.php on line 81
[22-May-2012 03:27:04 UTC] PHP Warning: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for /public_html/module_version/google_merchant_center_feeder.txt in /public_html/includes/classes/google_base.php on line 82
[22-May-2012 03:27:04 UTC] PHP Warning: fread() expects parameter 1 to be resource, boolean given in /public_html/includes/classes/google_base.php on line 82
[22-May-2012 03:27:04 UTC] PHP Warning: fclose() expects parameter 1 to be resource, boolean given in /public_html/includes/classes/google_base.php on line 83
[22-May-2012 03:27:04 UTC] PHP Fatal error: 1054:Unknown column 'p.products_condition' in 'field list' :: 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_condition
FROM products p
LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN products_description pd ON (p.products_id = pd.products_id)
LEFT JOIN 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
AND (
p.products_image IS NOT NULL
OR p.products_image != ''
OR p.products_image != 'no_picture.gif'
)
GROUP BY pd.products_name
ORDER BY p.products_id ASC; in /public_html/includes/classes/db/mysql/query_factory.php on line 101

22 May 2012, 12:37 PM
#24
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

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

PHP Warning: fopen(/public_html/module_version/google_merchant_center_feeder.txt)

Ok 1st I dont seem to have this file.... Is this included? Or a conflict?

22 May 2012, 1:20 PM
#25
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

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

milobloom:

Ok 1st I dont seem to have this file.... Is this included? Or a conflict?

I have yet to find an answer to that question and I've dealt directly with the people who wrote it.

22 May 2012, 3:24 PM
#26
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

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

laurelsstitchery:

I have yet to find an answer to that question and I've dealt directly with the people who wrote it.
Just a suggestion to all who've reported this error.. Have you tried creating this file, and uploading it to the place where it's expected to be based on the error??? I would think that a simple text file with the version number in it is all that's needed. Because when I do a Google search for "module_version/google_merchant_center_feeder.txt", I was able to see these files on other sites..

22 May 2012, 6:00 PM
#27
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

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

DivaVocals:

Just a suggestion to all who've reported this error.. Have you tried creating this file, and uploading it to the place where it's expected to be based on the error??? I would think that a simple text file with the version number in it is all that's needed. Because when I do a Google search for "module_version/google_merchant_center_feeder.txt", I was able to see these files on other sites..

Ok I tried doing that. It looks like that error went away.

Now I get this one:

[22-May-2012 17:38:12 UTC] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant in /home/XXXX/public_html/XXXXX/includes/functions/admin_access.php on line 39

22 May 2012, 6:13 PM
#28
milobloom avatar

milobloom

Totally Zenned

Join Date:
Feb 2004
Posts:
1,267
Plugin Contributions:
1

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

Oh I forgot to add that I do get the same error when trying to run a product feed.

Then I went to the cache folder and saw

[22-May-2012 17:38:12 UTC] PHP Warning: constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant in /home/XXXX/public_html/XXXXX/includes/functions/admin_access.php on line 39

27 May 2012, 10:37 AM
#29
torvista avatar

torvista

Totally Zenned

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

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

In 1.13.0 a call was added to a function to add additional images into the feed.

After quite some time seeing 404 errors in my server logs while googlebot was looking for images in the images root instead of subdirectories, I eventually find the problem here.

So, for those of you with additional images (most people I imagine) have a look at your feed to see if the image path is correct for additional images. It should be already correct for the base image.

If you find the additional images link to be pointing to /images/myimage01.jpg instead of /images/mysubdirectory/myimage_01.jpg (deliberate underscore: http://www.zen-cart.com/content.php?100), here is my fix.

Rather than just fix what was broke, I took at look at the whole function and tried to improve it, and add comments for the terminally curious like me.

So, in /classes/google_base.php at the start of the file, replace the entire function:

function additional_images($products_image) {
      if ($products_image != '') {
        $images_array = array();
        // prepare image name
        $products_image_extension = substr($products_image, strrpos($products_image, '.'));
        $products_image_base = str_replace($products_image_extension, '', $products_image);

        // if in a subdirectory
        if (strrpos($products_image, '/')) {
          $products_image_match = substr($products_image, strrpos($products_image, '/')+1);
          $products_image_match = str_replace($products_image_extension, '', $products_image_match) . '_';
          $products_image_base = $products_image_match;
        }

        $products_image_directory = str_replace($products_image, '', substr($products_image, strrpos($products_image, '/')));
        if ($products_image_directory != '') {
          $products_image_directory = DIR_WS_IMAGES . str_replace($products_image_directory, '', $products_image) . "/";
        } else {
          $products_image_directory = DIR_WS_IMAGES;
        }

        // Check for additional matching images
        $file_extension = $products_image_extension;
        $products_image_match_array = array();
        if ($dir = @dir($products_image_directory)) {
          while ($file = $dir->read()) {
            if (!is_dir($products_image_directory . $file)) {
              if (substr($file, strrpos($file, '.')) == $file_extension) {
                if(preg_match("/" . $products_image_base . "/i", $file) == 1) {
                  if ($file != $products_image) {
                    if ($products_image_base . str_replace($products_image_base, '', $file) == $file) {
                      $images_array[] = $this->google_base_image_url($file);
                      if (count($images_array) >= 8) break;
                    } else {
                      //  no match
                    }
                  }
                }
              }
            }
          }
          $dir->close();
        }
        return $images_array;
      } else {
        // default
        return false;
      }
    }

with this

    function additional_images($products_image) {//eg. image_subdirectory/myimage.jpg
      if ($products_image != '') {
        $images_array = array();
        // prepare image name
        $products_image_extension = substr($products_image, strrpos($products_image, '.'));//get the extension
		$products_image_base = str_replace($products_image_extension, '', $products_image);//strip extension to get the (optional path and) base filename
		$products_image_directory = str_replace(substr($products_image, strrpos($products_image, '/')), '',$products_image);//get the subdirectory path
		
		 if (strrpos($products_image_base, '/')) {//is the image in a subdirectory?
		 	$products_image_base = substr($products_image_base, strrpos($products_image, '/')+1).'_';//strip the path and add the underscore: see http://www.zen-cart.com/content.php?100
		 	$products_image_directory = $products_image_directory.'/';
        }

        $products_image_match_array = array();
        if ($dir = @dir(DIR_WS_IMAGES . $products_image_directory)) {
          while ($file = $dir->read()) {
          if (!is_dir(DIR_WS_IMAGES . $products_image_directory . $file)) {
            if ($file != $products_image) {//ignore the primary image
			 if (preg_match("/" . $products_image_base . "/i", $file) == 1) {//does this filename contain the image base filename?
			  if ($products_image_base . str_replace($products_image_base, '', $file) == $file) {//does this filename start with image base_?
				if (substr($file, strrpos($file, '.')) == $products_image_extension) {//does it have the same extension as the image base? 
					$file = $products_image_directory.$file;//add subdirectory path to filename for subsequent function call
					if (GOOGLE_PRODUCTS_DEBUG == 'true') {echo 'google_base 36:additional image found $file='.$file.'<br />';}//debug
					$images_array[] = $this->google_base_image_url($file);//this function needs image_subdirectory/myimage.jpg
                      if (count($images_array) >= 8) break;//only 10 images allowed by Google
                    } else {
                      //  no match
                    }
                  }
                }
              }
            }
          }
          $dir->close();
        }
        return $images_array;
      } else {
        // default
        return false;
      }
    }
5 Jun 2012, 12:54 AM
#30
webkat avatar

webkat

Zen Follower

Join Date:
Jan 2012
Location:
New England
Posts:
238
Plugin Contributions:
0

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

When I manually go in and create the file it is there, then I can download it and manually upload it to Google, but the part where it sends it to Google like it did when I first installed it seems to not work now... when I created the new feed it didn't show up in the list--only the first one I ever did is in the list--and my cron job seems to not be working either... if someone is willing to help me I'll post details (tell me what details you need)

14 Jun 2012, 1:27 PM
#31
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

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

Deleted............

14 Jun 2012, 1:28 PM
#32
countrycharm avatar

countrycharm

Totally Zenned

Join Date:
Jul 2007
Posts:
2,179
Plugin Contributions:
2

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

The free Google Product search is going by, by. Just another way for Google to make Billions off Businesses. No Offense to anyone.
I'm not interested in paying for a ton of products to be included in their search results. Just another way to hurt the small business owner.

Google Shopping

First, we are starting to transition Google Product Search in the U.S. to a purely commercial model built on Product Listing Ads. This new product discovery experience will be called Google Shopping and the transition will be complete this fall. We believe that having a commercial relationship with merchants will encourage them to keep their product information fresh and up to date. Higher quality data—whether it’s accurate prices, the latest offers or product availability—should mean better shopping results for users, which in turn should create higher quality traffic for merchants.

We’re giving merchants a few months to transition to this new model, and we’re also offering some incentives:

  • All merchants who create Product Listing Ads by August 15, 2012 will automatically receive a monthly credit for 10% of their total Product Listing Ad spend through the end of 2012; and
  • Existing Google Product Search merchants can receive $100 AdWords credit toward Product Listing Ads if they fill out a form before August 15, 2012.

To learn more and get started merchants can visit: www.google.com/ads/shopping

Ranking in Google Shopping, when the full transition is complete this fall, will be based on a combination of relevance and bid price--just like Product Listing Ads today. This will give merchants greater control over where their products appear on Google Shopping. Over time they will also have the opportunity to market special offers such as “30% off all refracting telescopes.”

In addition, merchants who want to stand out from the crowd can choose to participate in our new Google Trusted Stores program. Google Trusted Stores is a badge for e-commerce sites which gives users background on merchants—whatever their size—including ratings for on-time shipping and customer service. Google stands behind merchants that have earned the Google Trusted Stores badge with a $1,000 lifetime purchase protection guarantee per shopper.

14 Jun 2012, 4:17 PM
#33
webkat avatar

webkat

Zen Follower

Join Date:
Jan 2012
Location:
New England
Posts:
238
Plugin Contributions:
0

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

countrycharm:

The free Google Product search is going by, by. Just another way for Google to make Billions off Businesses. No Offense to anyone.
I'm not interested in paying for a ton of products to be included in their search results. Just another way to hurt the small business owner.

WHAAAAT???? Oh man that is so screwed up. What a lame change.

3 Jul 2012, 8:29 PM
#34
chava1106 avatar

chava1106

New Zenner

Join Date:
Jun 2012
Posts:
21
Plugin Contributions:
0

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

hi,

Im not sure what i did wrong!

when i click in the backend conf. then the google tab it comes up but it is totally blank
then when i click tools and the google tab it cant find that page...

the thing that i think i messed up on is the boxes folder i didnt have a boxes folder so i just droped the whole boxes folder into
my admin -> includes folder was that the right thing to do...
I downloaded them all in the admin folder but the others i put the documents in the right folders (or else they would be duplicates..)

Can anyone help at all with any of the problems!

3 Jul 2012, 8:40 PM
#35
discoverytdi avatar

discoverytdi

Totally Zenned

Join Date:
May 2011
Location:
Sunny Rossendale (not)
Posts:
562
Plugin Contributions:
0

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

Oh Bummer :shocking: not, don't know what is like over the pond but most UK listings are from Ebay will they be signing up. can see there point in a way but paying just cause someone clicks on a link to your product (er don't think so) now if it was a yearly subscription maybe

14 Jul 2012, 1:04 AM
#36
sw1138lr avatar

sw1138lr

New Zenner

Join Date:
Jun 2012
Posts:
94
Plugin Contributions:
0

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

Hi,

I'm using "Google Merchant Feeder" version 1.13.0. The URL it created in the XML <LINK> gives a 404 page not found.

Example:
<link>http://www.mywebsite.com/index.php?main_page=product_info&products_id=8982&currency=USD</link>

Is there a way to use the product model in place of the products_id ? or some other fields that will make the URL work?

Thanks
Kevin

14 Jul 2012, 4:49 PM
#37
sw1138lr avatar

sw1138lr

New Zenner

Join Date:
Jun 2012
Posts:
94
Plugin Contributions:
0

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

sw1138lr:

Hi,

I'm using "Google Merchant Feeder" version 1.13.0. The URL it created in the XML <LINK> gives a 404 page not found.

Example:
<link>http://www.mywebsite.com/index.php?main_page=product_info&products_id=8982&currency=USD</link>

Is there a way to use the product model in place of the products_id ? or some other fields that will make the URL work?

Thanks
Kevin

I've discovered the issue with the LINK is the value amp;

Anyone know how to remove this from the creation of the Google Feeder?

31 Jul 2012, 3:08 AM
#38
dkhoward avatar

dkhoward

New Zenner

Join Date:
May 2009
Posts:
15
Plugin Contributions:
0

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

Couple of questions.

Is anyone getting any feedback at the Numiniz Forum. I posted a message a couple of days ago and I haven't gotten anything?

I installed a fresh install of GMC into a fresh clean install of ZC1.5.0. I have a very limited number of products in the store right now so it is easy to test.

When I run the feeder program it starts, starts to build the file, gets through 68 products and just quits. It doesn't write a file, it doesn't give any error codes, it doesnt write and error file. It just quits.

If I set up to do just one category, it parses through every product in the file and excludes every record with the message that it didn't meet user criteria.

I have wasted about 3 days trying to get this thing to work. Frustration is setting in especially since I cant get any feed back from the people that are supposed to be supporting it.

ANyone got any answers?

1 Aug 2012, 6:36 AM
#39
torvista avatar

torvista

Totally Zenned

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

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

Frustration is setting in especially since I cant get any feed back from the people that are supposed to be supporting it.
Bear in mind it's free...they don't have to support it, but their forum is surprisingly neglected, not good publicity.

Are there no debug logs in your cache?

1 Aug 2012, 11:45 PM
#40
dkhoward avatar

dkhoward

New Zenner

Join Date:
May 2009
Posts:
15
Plugin Contributions:
0

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

torvista:

Bear in mind it's free...they don't have to support it, but their forum is surprisingly neglected, not good publicity.

Are there no debug logs in your cache?

None. It simply ceases to run as far as I can tell.