Jump to content



Photo
- - - - -

Google XML Sitemap SEO


  • Please log in to reply
1367 replies to this topic

#1181   lyonsperf

lyonsperf
  • Members
  • 333 posts
  • Real Name:Matt
  • Gender:Male
  • Location:CT

Posted 13 June 2012 - 13:45

Hi Jack,
I received notice from google that they plan to change the way product feeds are handled via upload files starting July 1. Have you had a chance to look into this?
I believe they are moving away from the free product feed for the merchant center and are now focusing on adwords for submission to their shopping section.
Will there be an update for this mod and the google product feed mod?
If you need a copy of the email, I can post it here.
Thanks,
Matt
If the only tool you have is a hammer, all your problems look like nails

#1182 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 13 June 2012 - 15:26

This contribution doesn't have anything to do with the google product feed.

#1183   shiry

shiry
  • Members
  • 6 posts
  • Real Name:Euseb

Posted 28 June 2012 - 23:26

Hi Jack,
Please help me to solve the following:-

ERROR: Google Pages Sitemap Generation FAILED!

All the other pages are being generated ok except for one- sitemappages.xml.
im using oscommerce 2.3. i have set permissions to all .xml files to 777.

Thank you,

Shiry.

#1184 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 29 June 2012 - 00:45

Hi Jack,
Please help me to solve the following:-

ERROR: Google Pages Sitemap Generation FAILED!

All the other pages are being generated ok except for one- sitemappages.xml.
im using oscommerce 2.3. i have set permissions to all .xml files to 777.

Thank you,

Shiry.

I don't know why that may be failing. My only guess is that there is some file in your root and/or languages directory that is confusing the code. You should remove any file, like index.php_bak, that shouldn't be there and see if that helps.

#1185   shiry

shiry
  • Members
  • 6 posts
  • Real Name:Euseb

Posted 29 June 2012 - 08:37

Thanks Jack, i have checked all my files. i don't have such files like index.php_bak. Any ideas for what else could be causing the error?

Regards,
Shiry.

#1186   aquapet

aquapet
  • Members
  • 1 posts
  • Real Name:pete martin

Posted 08 July 2012 - 10:36

Hi - Another great contribution!

I have installed this and it all works fine, but when I look at sitemappages.xml it only shows one page which is:

<loc>http://www <domain>/catalog/popup_coupon_help.php</loc>

Should it have more pages, such as contact.php, shipping.php, etc?

Thanks
Pete

#1187 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 08 July 2012 - 13:21

You, you should see the other pages. Though I don't recommend using that option for now if it is listing the popup files since they should not be listed. This is known and scheduled to fixed in the next version.

#1188   BlakeBG

BlakeBG
  • Members
  • 22 posts
  • Real Name:Georgi
  • Gender:Male
  • Location:Bulgaria

Posted 28 July 2012 - 13:14

Nvm i fixed it i think :)

Edited by BlakeBG, 28 July 2012 - 13:16.


#1189   BlakeBG

BlakeBG
  • Members
  • 22 posts
  • Real Name:Georgi
  • Gender:Male
  • Location:Bulgaria

Posted 28 July 2012 - 14:11

Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapproducts.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapproducts.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Write /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapproducts.xml
Generated Google Product Sitemap Successfully

Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapcategories.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapcategories.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Write /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapcategories.xml
Generated Google Category Sitemap Successfully

Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapmanufacturers.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapmanufacturers.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Write /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapmanufacturers.xml
Generated Google Manufacturers Sitemap Successfully

Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapspecials.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapspecials.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Write /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapspecials.xml
Generated Google Specials Sitemap Successfully

ERROR: Google Pages Sitemap Generation FAILED!

Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapindex.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Opening /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapindex.xml
FS_CAT /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
Server http://www.vagina-bg.com
Save Path /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/
WS_CAT /shop/
Write /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapindex.xml
Generated Google Sitemap Index Successfully

Array
(
[QUERY] => Array
(
[PRODUCTS] => Array
(
[STATUS] => success
[NUM_ROWS] => 148
)

[CATEOGRY] => Array
(
[STATUS] => success
[NUM_ROWS] => 136
)

[MANUFACTURERS] => Array
(
[STATUS] => success
[NUM_ROWS] => 6
)

[SPECIALS] => Array
(
[STATUS] => success
[NUM_ROWS] => 1
)

)

[SAVE_FILE_XML] => Array
(
[0] => Array
(
[file] => /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapproducts.xml
[status] => success
[file_exists] => true
)

[1] => Array
(
[file] => /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapcategories.xml
[status] => success
[file_exists] => true
)

[2] => Array
(
[file] => /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapmanufacturers.xml
[status] => success
[file_exists] => true
)

[3] => Array
(
[file] => /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapspecials.xml
[status] => success
[file_exists] => true
)

[4] => Array
(
[file] => /var/www/html/vhosts/flamingo-toys.com/public_html/vagina-bg/shop/sitemapindex.xml
[status] => success
[file_exists] => true
)

)

)

sorry for double posting , but the problem apperead again on my other site and i cant solve it now .

#1190 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 28 July 2012 - 16:44

sorry for double posting , but the problem apperead again on my other site and i cant solve it now .

I can't see anything wrong with it. Are you sure you installed it in the shop directory? Did you try the alternate setting?

#1191   queenzukie

queenzukie
  • Members
  • 621 posts
  • Real Name:Rachael
  • Gender:Female
  • Location:USA

Posted 06 August 2012 - 23:06

I have this up and running after playing with it for a while. Now I have SEO URLS Pro 5 (or something like that) installed and the xml files are showing the standard urls, not the SEO urls. How do I fix this?

#1192   queenzukie

queenzukie
  • Members
  • 621 posts
  • Real Name:Rachael
  • Gender:Female
  • Location:USA

Posted 06 August 2012 - 23:44

I have this up and running after playing with it for a while. Now I have SEO URLS Pro 5 (or something like that) installed and the xml files are showing the standard urls, not the SEO urls. How do I fix this?


Found this:
Google XML Sitemap SEO compitable with Ultimate SEO URL by FWR Media


and its working now.

#1193   ErikMM

ErikMM
  • Members
  • 314 posts
  • Real Name:Erik M
  • Gender:Male

Posted 10 August 2012 - 20:32

I don't know why that may be failing. My only guess is that there is some file in your root and/or languages directory that is confusing the code. You should remove any file, like index.php_bak, that shouldn't be there and see if that helps.

this "ERROR: Google Pages Sitemap Generation FAILED!" refers to a problem that's been going on for some time with apparent frequency as the thread indicates

I checked back here:
a. http://forums.oscomm...ost__p__1375792
and here:
b. http://forums.oscomm...ost__p__1376309

a. but line 299 is now like 681?
b. lines 263-266 are now "* @author Bobby Easland * @version 1.0"

By the way, I am looking at catalog/googlesitemap/sitemap.class.php. I noticed you referring to sitemap_class (link "a") not sitemap.map, but I can't locate the former one with the add-on.

*Anyway, it appears the reason the "ERROR: Google Pages Sitemap Generation FAILED!" keeps occurring is that the xml file sitemappages is empty...0 bytes, not a thing in it. Same for the sitemapspecials xml people are having issues with.

should those files be empty, or...

What exactly are the "pages" by the way? all the pages at my site, the info pages, or...

I have no errors except the pages sitemap, like a lot of people posting here. I can't seem to locate the fix per the two links above either. Is it because the xml sitepages file is empty.

Edited by ErikMM, 10 August 2012 - 20:42.


#1194   ErikMM

ErikMM
  • Members
  • 314 posts
  • Real Name:Erik M
  • Gender:Male

Posted 10 August 2012 - 23:39

I see the xml files are "dummy files" so they are empty at first

talked to my provider:

Did you give the script the proper information to access the database required for it to generate those other optional data files? If not it will fail because it cannot get the data to create them. It has to pull data from your database to create those sitemap files. If the proper database and/or tables do not exist in your installation it will have no way to do this. It appears this is a tool to go with osCommerce so your database must match what this tool needs to work.

Since we don't know anything else about the scripts specific details we cannot be of too much direct help on what exactly it requires or what steps are necessary to make it work, but the initial impression is that your database must not have all the information this tool is looking for. OR the failure messages are a false error.


Any thoughts or different suggestions that the ones in the post above at links a and b?

#1195 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 10 August 2012 - 23:55

*Anyway, it appears the reason the "ERROR: Google Pages Sitemap Generation FAILED!" keeps occurring is that the xml file sitemappages is empty...0 bytes, not a thing in it. Same for the sitemapspecials xml people are having issues with.

should those files be empty, or...

What exactly are the "pages" by the way? all the pages at my site, the info pages, or...

I have no errors except the pages sitemap, like a lot of people posting here. I can't seem to locate the fix per the two links above either. Is it because the xml sitepages file is empty.

They will be empty if you don't enable the setting for them. In that case, you shouldn't add those as sitemap entries in your google account.

#1196   geoffreywalton

geoffreywalton

    Available for Hire

  • Community Sponsor
  • 8,212 posts
  • Real Name:Geoffrey Walton
  • Gender:Male
  • Location:Norfolk, UK (close to the centre of the universe)

Posted 11 August 2012 - 11:36

@ErikMM


I got caught be this one

"ERROR: Google Pages Sitemap Generation FAILED!"

Actually it can mean no pages were found to go in this file.

The test it does is for every file found in /includes/languages/english check and see if the file of the name name in the root of the shop contains the string <head> and is not in the list of files to exclude.

I got the same error message, this was caused by the IsViewable function, which checks for <head> coming back with a "false" result for every file.

In sitemap.class.php I changed it to

  function IsViewable($file)
  {
    if (is_readable($file)) {
		   return true;
	  }
    return false;
  }

On a 2.3.1 site, I also had to change lines lines 593 odd to

	    /*** ADD INFORMATION PAGES ***/
	    else if ($filename === 'information.php')
	    {
		  $sql = "SELECT information_id from " . TABLE_INFORMATION . " where information_id > '5' and visible = '1' and language_id = '" . (int)$languageID . "'";

Otherwise I got entries for the header text.

HTH

G
Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.

For links mentioned in old answers that are no longer here follow this link Useful Threads.

If this post was useful, click the Like This button over there ======>>>>>.

#1197   ErikMM

ErikMM
  • Members
  • 314 posts
  • Real Name:Erik M
  • Gender:Male

Posted 12 August 2012 - 22:24

@ErikMM


I got caught be this one

"ERROR: Google Pages Sitemap Generation FAILED!"

Actually it can mean no pages were found to go in this file.

The test it does is for every file found in /includes/languages/english check and see if the file of the name name in the root of the shop contains the string <head> and is not in the list of files to exclude.

I got the same error message, this was caused by the IsViewable function, which checks for <head> coming back with a "false" result for every file.


Thanks.

I figured I didn't have any "pages" file(s), and the other ones I was concerned about were ok: manufactures, product, and category

#1198   Logcbnfvr

Logcbnfvr
  • Members
  • 101 posts
  • Real Name:Kim ;-*
  • Gender:Female
  • Location:Arizona

Posted 12 October 2012 - 18:18

Hi! I get no errors with my sitemap and the cron job seems to be doing fine.... my only problems is the sitemaps have not changed since Oct. 22, 2011. Hundreds of things have changed in this year but it does not seem to be generating anything beyond it's very first time. Any ideas?
THX
Log Cabin Fever Gifts

#1199   bazmlb

bazmlb
  • Members
  • 8 posts
  • Real Name:Barry
  • Gender:Male

Posted 25 October 2012 - 16:16

I have installed it on 2.2 and getting "ERROR: Google Product Sitemap Generation FAILED!"

The files exist and are set to 777, tried both standard and alternate

The full error is:
Warning: fopen(/home8/asianus/public_html/sitemapproducts.xml) [function.fopen]: failed to open stream: No such file or directory in /home/asianus/public_html/googlesitemap/sitemap.class.php on line 345

ERROR: Google Product Sitemap Generation FAILED!



Warning: fopen(/home8/asianus/public_html/sitemapcategories.xml) [function.fopen]: failed to open stream: No such file or directory in /home/asianus/public_html/googlesitemap/sitemap.class.php on line 345

ERROR: Google Category Sitemap Generation FAILED!



Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/asianus/public_html/googlesitemap/sitemap.class.php on line 776

ERROR: Google Pages Sitemap Generation FAILED!



Warning: fopen(/home8/asianus/public_html/sitemapindex.xml) [function.fopen]: failed to open stream: No such file or directory in /home/asianus/public_html/googlesitemap/sitemap.class.php on line 345

ERROR: Google Sitemap Index Generation FAILED!

Array
(
[QUERY] => Array
(
[PRODUCTS] => Array
(
[STATUS] => success
[NUM_ROWS] => 16427
)

[CATEOGRY] => Array
(
[STATUS] => success
[NUM_ROWS] => 22
)

)

[SAVE_FILE_XML] => Array
(
[0] => Array
(
[file] => /home8/asianus/public_html/sitemapproducts.xml
[status] => failure
[file_exists] => false
)

[1] => Array
(
[file] => /home8/asianus/public_html/sitemapcategories.xml
[status] => failure
[file_exists] => false
)

[2] => Array
(
[file] => /home8/asianus/public_html/sitemapindex.xml
[status] => failure
[file_exists] => false
)

)

)

#1200 ONLINE   Jack_mcs

Jack_mcs
  • Members
  • 26,565 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 25 October 2012 - 17:47

The errors are saying the files can't be found. if you are sure they are there, then it is most likely a mistake in your configure file. See here.