Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

I have a multilanguage website with Ultimate SEO URLS 5 and Header Tags SEO, and when i generate my sitemap (using version 1.5) I only get the pages for my default language.

The code only works for the default language. There are some changes for languages mentioned not too long ago that can get around that but they require editing the files.

Edited by Jack_mcs

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 checked Google Webmaster Tools (https://www.google.com/webmasters/tools/sitemap-list?hl=en&siteUrl=http://www.ourwebsite.com/ and noticed three alerts for the following XML files:

 

sitemapindex.xml

sitemapmanufacturers.xml

sitemapproducts.xml

 

Could someone point me in the right direction to fix?

Your account has the reasons for the alerts. You have to look to see what they say.

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,

I have installed the Sitemap and SEO URLS,

 

both work independantly, for exmaple if I turn off the SEO function the the sitemap works well.

 

If I turn SEO URL on the URL is

 

/catalog/canon-7580-p-118.html

 

But Sitemap SEO give google this

 

<loc>http://www.xxxx.com/catalog/product_info.php?products_id=118</loc>

 

Google recognise this as a redirect, how can I get over this problem?

 

Many thanks in advance

Link to comment
Share on other sites

I have installed the Sitemap and SEO URLS,

 

both work independantly, for exmaple if I turn off the SEO function the the sitemap works well.

 

If I turn SEO URL on the URL is

 

/catalog/canon-7580-p-118.html

 

But Sitemap SEO give google this

 

<loc>http://www.xxxx.com/catalog/product_info.php?products_id=118</loc>

 

Google recognise this as a redirect, how can I get over this problem?

If you are using Ultimate SEO V2.2, be sure you have the latest version installed. If you are using some other url contribution, you'll need to ask in its support thread.

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,

I have installed the Sitemap and SEO URLS,

 

both work independantly, for exmaple if I turn off the SEO function the the sitemap works well.

 

If I turn SEO URL on the URL is

 

/catalog/canon-7580-p-118.html

 

But Sitemap SEO give google this

 

<loc>http://www.xxxx.com/catalog/product_info.php?products_id=118</loc>

 

Google recognise this as a redirect, how can I get over this problem?

 

Many thanks in advance

I'm having the same problem and am getting replies that I'm posting in the wrong threads. I've had this Sitemap contribution installed for quite some time. I just installed Ultimate SEO URLs a few weeks ago and am getting alerts, such as this:

 

URLs not followed

When we tested a sample of URLs from your Sitemap, we found that some URLs redirect to other locations. We recommend that your Sitemap contain URLs that point to the final destination (the redirect target) instead of redirecting to another URL.

 

It references this under details:

 

HTTP Error: 301

URL:

http://www.wolfftanning.com/index.php?manufacturers_id=11

Problem detected on: Aug 8, 2010

 

It seems I need to do some sort of reconfiguring but am not sure where to go to do this.

Link to comment
Share on other sites

I'm having the same problem and am getting replies that I'm posting in the wrong threads. I've had this Sitemap contribution installed for quite some time. I just installed Ultimate SEO URLs a few weeks ago and am getting alerts, such as this:

 

URLs not followed

When we tested a sample of URLs from your Sitemap, we found that some URLs redirect to other locations. We recommend that your Sitemap contain URLs that point to the final destination (the redirect target) instead of redirecting to another URL.

 

It references this under details:

 

HTTP Error: 301

URL:

http://www.wolfftanning.com/index.php?manufacturers_id=11

Problem detected on: Aug 8, 2010

The urls in the sitemaps are not being created in the rewritten form, as can be seen here: http://www.wolfftanning.com/sitemapcategories.xml. You don't state which version of Ultimate SEO you have installed but if it is 2.2d then it should work fine.

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 urls in the sitemaps are not being created in the rewritten form, as can be seen here: http://www.wolfftanning.com/sitemapcategories.xml. You don't state which version of Ultimate SEO you have installed but if it is 2.2d then it should work fine.

This is the version installed: Ultimate_SEO_URLSv22d_10. I'm still researching but haven't been able to figure out where to fix.

Link to comment
Share on other sites

This is the version installed: Ultimate_SEO_URLSv22d_10. I'm still researching but haven't been able to figure out where to fix.

That version and this contribution work perfectly together and don't require any special setting changes. But you do have to create the sitemaps after installing Ultimate SEO, which it appears you didn't do. I just ran it and if you look at the sitemap files now, you will see the links are correct.

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

That version and this contribution work perfectly together and don't require any special setting changes. But you do have to create the sitemaps after installing Ultimate SEO, which it appears you didn't do. I just ran it and if you look at the sitemap files now, you will see the links are correct.

I see. Do we create the sitemap files within the store admin or in Google Webmaster Tools? Thanks.

Link to comment
Share on other sites

I got everything figured out except I still have the Google alert (yellow triangle with exclamation mark) next to my sitemapindex.xml file. When I click on it in Google Webmaster Tools, it displays three XML files, all with green check marks. With that being the only XML file with issues, should I switch to alternate class?

Link to comment
Share on other sites

I got everything figured out except I still have the Google alert (yellow triangle with exclamation mark) next to my sitemapindex.xml file. When I click on it in Google Webmaster Tools, it displays three XML files, all with green check marks. With that being the only XML file with issues, should I switch to alternate class?

Never mind. All is well. Hopefully when I circle back to this in six months, I'll know where to find the instructions.

Link to comment
Share on other sites

Hi Jack, I got following message at my catalog/googlesitemap/index.php page:

 

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

And the following is captured in the error_log:

[19-Aug-2010 15:08:26] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0

 

Any idea what's going on? Appreciated.

Link to comment
Share on other sites

And the following is captured in the error_log:

[19-Aug-2010 15:08:26] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion in Unknown on line 0

As the error says, it is a server error. You will need to contact your host about it.

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

As the error says, it is a server error. You will need to contact your host about it.

Thanks man! I contacted my host earlier and it seemed resolved. But now I get this on the xml pages:

 

 

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://usave.com.sg/shop/sitemapproducts.xml'.

Link to comment
Share on other sites

Thanks man! I contacted my host earlier and it seemed resolved. But now I get this on the xml pages:

 

 

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://usave.com.sg/shop/sitemapproducts.xml'.

It sounds like you may have missed one of the files when uploading. You may also want to search back through this thread for that problem since I think it has been addressed before.

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´ve just a question, how is it done in the xml generating script, that you get oscid/session id free product links?

That happens automatically if your shop is setup correctly. Try clicking around your shop, if the session ID shows in the url, then your shop is not configured correctly. There are threads in the forums that deal with that. If they are not there and you are using a url rewriter, you may not be using the recommended one - Ultimate SEO V2.2d. In that case, you need to ask in the support thread of your rewriter.

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 you may have missed one of the files when uploading. You may also want to search back through this thread for that problem since I think it has been addressed before.

Jack, I've searched through. The previous post (#350) was because the gss file for forgotten. Other posts #53,75,83 didn't help too as all my xml files has the same error message.

I've also tried replacing all the xml files and set the permissions correctly without success. All my files are in place and permissions given correctly to all xml files.

 

What else do you think I've missed?

Link to comment
Share on other sites

Jack, I've searched through. The previous post (#350) was because the gss file for forgotten. Other posts #53,75,83 didn't help too as all my xml files has the same error message.

I've also tried replacing all the xml files and set the permissions correctly without success. All my files are in place and permissions given correctly to all xml files.

 

What else do you think I've missed?

It sounds like you did everything right. When all else fails, google is a good thing to try.

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

Try this. In googlesitemap/index.php, change

if ($google->GenerateCategorySitemap()){

to

if ($google->GenerateCategorySitemap($languages_id)){

And in googlesitemap/sitemap.class.php (or sitemap.class_Alternate.php) change

	function GenerateCategorySitemap(){
       $quotes = (defined('QUOTES_CATEGORY_NAME') ? " where cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : '');
	$sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
		    FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id
               " . $quotes . "
			ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC";

to

	function GenerateCategorySitemap($languages_id){
     $quotes = (defined('QUOTES_CATEGORY_NAME') ? " and cd.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' " : '');
	$sql = "SELECT c.categories_id as cID, c.date_added, c.last_modified as last_mod
		    FROM " . TABLE_CATEGORIES . " c left join " . TABLE_CATEGORIES_DESCRIPTION . " cd on c.categories_id = cd.categories_id
		    where cd.language_id = " . (int)$languages_id . "
               " . $quotes . "
			ORDER BY c.parent_id ASC, c.sort_order ASC, c.categories_id ASC";

The products and manufacturers section will probably need to be changed in the same way, though you didn't mention duplicates for those.

Jack, could you please provide the change for the manufacturers sql query in googlesitemap/sitemap.class.php?

Absinthe Original Liquor Store

Link to comment
Share on other sites

Jack, does the code have an option to add to the robots.txt file? Maybe I just missed it. Like...

 

Sitemap: http://www.example.tld/sitemapindex.xml

Sitemap: http://www.example.tld/sitemapcategories.xml

Sitemap: http://www.example.tld/sitemapmanufacturers.xml

Sitemap: http://www.example.tld/sitemapspecials.xml

Sitemap: http://www.example.tld/sitemapproducts.xml

Sitemap: http://www.example.tld/sitemappages.xml

 

 

 

That way the sitemaps would be available to any other bot.

Community Bootstrap Edition, Edge

 

Avoid the most asked question. See How to Secure My Site and How do I...?

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...