Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

I'm having an issue that I haven't been able to solve by reading through any of the forums.

 

Google has accepted both my:

sitemapcategories.xml and my

sitemapindex.xml

 

but there are errors with my sitemapproducts.xml

 

The error says:

 

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

 

 

--------------------------------------------------------------------------------

 

A semi colon character was expected. Error processing resource 'http://www.bella-blanca.com/sitemapproducts.xml'. Line 130...

 

<loc>http://bella-blanca.com/product_info.php?cPath=63&products_id=192</loc>

----------------------------...

 

 

Here is what the file looks like... am I simply missing a semi colon?

 

Thanks in advance :)

 

 

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=194</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>1.0</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=179</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=188</loc>
	<lastmod>2008-06-23</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=190</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=196</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=201</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=203</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=204</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=206</loc>
	<lastmod>2008-09-10</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=195</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=178</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=191</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=193</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=183</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=182</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=186</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=180</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=192</loc>
	<lastmod>2008-06-23</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=200</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
<url>
	<loc>http://bella-blanca.com/product_info.php?products_id=176</loc>
	<lastmod>2008-06-24</lastmod>
	<changefreq>weekly</changefreq>
	<priority>0.1</priority>
</url>
</urlset>

Link to comment
Share on other sites

I'm having an issue that I haven't been able to solve by reading through any of the forums.

 

Google has accepted both my:

sitemapcategories.xml and my

sitemapindex.xml

 

but there are errors with my sitemapproducts.xml

 

The error says:

 

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

 

 

--------------------------------------------------------------------------------

 

A semi colon character was expected. Error processing resource 'http://www.bella-blanca.com/sitemapproducts.xml'. Line 130...

 

<loc>http://bella-blanca.com/product_info.php?cPath=63&products_id=192</loc>

----------------------------...

My guess is that you have the Search Engine Friendly option turned on in admin since the format of the links don't match.

That option should not be used.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

So Jack, how can I fix this?

 

Thanks!

It doesn't apply to this contribution. This one just creates url's from what it is given. If something is being added, it is because of some setting or code change in your shop, not because of the contribution. Without being able to look at the problem, your settings and files, I can't even guess at what the problem might be.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Jack, i have just submitted my sitemap to google under the webmaster tool. i was wondering how many sites should i submit? coz i submit this only :

http://www.hobby-asia.com/sitemapindex.xml

 

do i still need to submit the other like :

http://www.hobby-asia.com/sitemapcategories.xml

http://www.hobby-asia.com/sitemapmanufacturers.xml

http://www.hobby-asia.com/sitemapproducts.xml

http://www.hobby-asia.com/sitemapspecials.xml

 

thanks. for the cron job, i think i m not able to do it. so i guess i will do w/o it. thanks

Link to comment
Share on other sites

Hmm, that's strange about sitemap.class_Alternate.php since the file isn't called anywhere so it shouldn't be an issue. I don't have an answer for that one.

 

For the gss file, yes, that is correct. I did add it to the original list of files but forgot to mention to upload it.

 

Jack

Hi Jack

 

FYI, and to clarify, the original sitemap_class.php has on line 291

 

if ($fp = fopen($filename, 'w+')){

 

and this was the cause of the error (my webhost has banned fopen, which causes me much grief).

 

When I renamed sitemap.class_Alternate.php to sitemap_class.php all worked.

 

One tiny thing. I receive email notifications of 404 errors. In summary:

Error Code: 404

Requested URL: http://domainname/gss.css

Referer: http://domainname/sitemapindex.xml

 

This occurs on all of the sitemaps, but the sitemaps still generate ok (I guess).

Edited by Coopco
Link to comment
Share on other sites

Jack, i have just submitted my sitemap to google under the webmaster tool. i was wondering how many sites should i submit? coz i submit this only :

http://www.hobby-asia.com/sitemapindex.xml

 

do i still need to submit the other like :

You should add them all.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hi Jack

 

FYI, and to clarify, the original sitemap_class.php has on line 291

 

if ($fp = fopen($filename, 'w+')){

 

and this was the cause of the error (my webhost has banned fopen, which causes me much grief).

 

When I renamed sitemap.class_Alternate.php to sitemap_class.php all worked.

 

One tiny thing. I receive email notifications of 404 errors. In summary:

Error Code: 404

Requested URL: http://domainname/gss.css

Referer: http://domainname/sitemapindex.xml

 

This occurs on all of the sitemaps, but the sitemaps still generate ok (I guess).

Both files use fopen so I don't understand how one can work and not the other.

 

For the 404 error, try removng this line from the gss.xml file

		<link href="gss.css" type="text/css" rel="stylesheet"/>

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Both files use fopen so I don't understand how one can work and not the other.

 

For the 404 error, try removng this line from the gss.xml file

		<link href="gss.css" type="text/css" rel="stylesheet"/>

 

Jack

Hi Jack

 

Thanks for the 404 error fix, no more errors.

 

It is weird. You are correct about the fopen in both files, I should have checked, but I did say it causes me grief.

 

I just copied the original back and I get

 

Warning: fopen(/hsphere/local/home/domainnamestuff/googlesitemapsitemapproducts.xml): failed to open stream: Permission denied in /hsphere/local/home/domainnamestuff/googlesitemap/sitemap.class.php on line 291

ERROR: Google Product Sitemap Generation FAILED!

 

etc for the remaining sitemaps.

 

When I do the rename stuff, I get

 

Write /hsphere/local/home/domainnamestuff/sitemapproducts.xmlGenerated Google Product Sitemap Successfully

 

etc for the remaining sitemaps.

 

Will have another look tomorrow and see if I can come up with a solution.

Link to comment
Share on other sites

My guess is that you have the Search Engine Friendly option turned on in admin since the format of the links don't match.

That option should not be used.

 

Jack

 

 

"Use Search engine safe URL's" has always been set to false in admin

 

Is there any other reasons why the format of the links doesn't match? I'm not sure what you mean by this as well

 

Cheers!

Link to comment
Share on other sites

Warning: fopen(/hsphere/local/home/domainnamestuff/googlesitemapsitemapproducts.xml): failed to open stream: Permission denied in /hsphere/local/home/domainnamestuff/googlesitemap/sitemap.class.php on line 291

ERROR: Google Product Sitemap Generation FAILED!

This is failing because /hsphere/local/home/domainnamestuff/googlesitemapsitemapproducts.xml isn't valid, specifically googlesitemapsitemapproducts.xml. It should be googlesitemap/sitemapproducts.xml. The two files return the same result so there is no reason to use one over the other. The one that is failing for you is trying to account for differences in configure file setups. It's is difficult to code for since I don't have a configure file that will break it like that. But if the other file works for you, there's no reason to use the alternate one.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

It sounds like they haven't processed the maps yet. But be sure to check that the maps are available by going to your shop (url's are on the page that creates the sitemaps). Also check the last downloaded. Maybe the couldn't find the file.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

This is failing because /hsphere/local/home/domainnamestuff/googlesitemapsitemapproducts.xml isn't valid, specifically googlesitemapsitemapproducts.xml. It should be googlesitemap/sitemapproducts.xml. The two files return the same result so there is no reason to use one over the other. The one that is failing for you is trying to account for differences in configure file setups. It's is difficult to code for since I don't have a configure file that will break it like that. But if the other file works for you, there's no reason to use the alternate one.

 

Jack

The sitemap.class_Alternate.php allows the use of

 

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

 

in the configure.php file.

 

When I use

define('DIR_FS_CATALOG', 'fullpathname');

the original sitemap.class.php file works.

Link to comment
Share on other sites

Greetings,

I have installed the googlexml_sitemap_seo_v_1.1 and it's great! Many thanks for your brilliance and help. One question, when I view the xml files in ie it's perfect, but when I use firefox I get this message

Error loading stylesheet: An XSLT stylesheet does not have an XML mimetype:

http://jerrys-music.com/catalog/gss.xsl

Is there anything I need to change in the stylesheet to make it work?

Jerry

Link to comment
Share on other sites

I do not use or have any manufacturers. Is there an easy way to turn this off or where could I comment it out in the code?

 

I might have to add some temp manufactures, but would perfer not to do this.

 

Thank you,

Link to comment
Share on other sites

jack, i m still having the same problem, google saying that :

http://www.hobby-asia.com/sitemapindex.xml - error

 

but there rest are fine :

sitemapcategories.xml - ok

sitemapmanufacturers.xml - ok

sitemapproducts.xml - ok

sitemapspecials.xml - error (this is ok because i dun have special product)

It seems it would have to be a problem with your google account since your sitemaps look fine. if you go to the sitemaps section, what is listed in the columns:

Filename Format Last Downloaded Status URLs submitted

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

The sitemap.class_Alternate.php allows the use of

 

define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']));

 

in the configure.php file.

 

When I use

define('DIR_FS_CATALOG', 'fullpathname');

the original sitemap.class.php file works.

Yes, that is what the code was added for and it works for me with shops that have different configure files but doesn't for everyone, it seems.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Greetings,

I have installed the googlexml_sitemap_seo_v_1.1 and it's great! Many thanks for your brilliance and help. One question, when I view the xml files in ie it's perfect, but when I use firefox I get this message

Error loading stylesheet: An XSLT stylesheet does not have an XML mimetype:

http://jerrys-music.com/catalog/gss.xsl

Is there anything I need to change in the stylesheet to make it work?

Jerry

Thanks, but the majority of the credit goes to Chemo. As for the error, it is most likely due to your server not recognizing the file type. Try adding this line to the .htaccess file in the root directory
AddType application/xml .xsl

You will need to check with your host if that doesn't work, or even before trying it, since that syntax will vary with the way the server is setup.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I do not use or have any manufacturers. Is there an easy way to turn this off or where could I comment it out in the code?

 

I might have to add some temp manufactures, but would perfer not to do this.

 

Thank you,

In googlesitemap/index.php, replace this section of code

$showManufacturers = true;
if ($google->GenerateManufacturerSitemap()){
echo 'Generated Google Manufacturers Sitemap Successfully' . "\n\n";
} else {
 $manufacturers_query = tep_db_query("select manufacturers_id from " . TABLE_MANUFACTURERS . " limit 1");
 if (tep_db_num_rows($manufacturers_query) > 0)
 {
$submit = false;
  echo 'ERROR: Google Manufacturers Sitemap Generation FAILED!' . "\n\n";
 }
 else 
 {
$showManufacturers = false;
  echo 'Google Sitemap Manufacturers not generated - no Manufacturers found!' . "\n\n";
 } 
}

with this line

$showManufacturers = false;

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Thank you Jack for updating and supporting this contribution. ;)

 

I have a little problem... I might have missed something so if you can kick me in the right direction I would appreciate it.

 

I had to rename the included file, sitemap.class_Alternate.php, to sitemap.class.php and all went well, almost!

 

Still receiving this error:

 

The XML page cannot be displayed

 

Cannot view XML input using style sheet. Please correct the error and

then click the Refresh button, or try again later.

 

XML document must have a top level element. Error processing resource

'http://handeshobbies.com/sitemapspecials.xml'.

 

:blink:

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

Thank you Jack for updating and supporting this contribution. ;)

 

I have a little problem... I might have missed something so if you can kick me in the right direction I would appreciate it.

 

I had to rename the included file, sitemap.class_Alternate.php, to sitemap.class.php and all went well, almost!

 

Still receiving this error:

 

The XML page cannot be displayed

 

Cannot view XML input using style sheet. Please correct the error and

then click the Refresh button, or try again later.

 

XML document must have a top level element. Error processing resource

'http://handeshobbies.com/sitemapspecials.xml'.

 

:blink:

If you go here, http://handeshobbies.com/googlesitemap/index.php, you'll see the sitemapspecials.xml file is not created. If you aren't going to have a specials sitemap file, it shouldn't be added to your sitemap list in google. Also notice the double //'s. That would be coming from your configure file, most likely. You should look at the datastamp on the files and make sure they are actually being updated.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

It seems it would have to be a problem with your google account since your sitemaps look fine. if you go to the sitemaps section, what is listed in the columns:

Filename Format Last Downloaded Status URLs submitted

 

Jack

 

Yes Jack, thats whats is listed

Link to comment
Share on other sites

If there isn't anything in those columns then you probably have the sitemaps listed incorrectly. You should contact google for help. They are pretty good at responding to such questions.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...