Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

i updated to from 1.3 to 1.4 and notice the link in the admin menu disappeared so i ran the SQL again.

Now the admin menu is showing 2 of the same things

 

 

Sitemap file Standard

Enable Manufacturers Map false Info

Enable Manufacturers Map false Info

Enable Specials Map false Info

Enable Specials Map false Info

Enable Standard Pages Map false Info

Enable Standard Pages Map false Info

Enable Diagnostic Output false Info

Enable Diagnostic Output false Info

Exclude these pages Info

Exclude these pages Info

 

 

How do fix this?

Link to comment
Share on other sites

Thanks for this great Add-On.

 

I just installed Google XML Sitemap SEO v1.4, and when running it, I received warnings.

 

I find the '/' missing between store and xml file names (I installed Oscommerce under store folder, not root folder), /public_html/storesitemapproducts.xml.

 

I updated sitemap.class.php line 263 to $this->savepath = DIR_FS_CATALOG . "/"; It fix my problems and generate the sitemap files.

Link to comment
Share on other sites

  • 2 weeks later...

Jack,

 

I'm running the latest version of this contribution and also the latest version of your SEO_URLs. Php 5.3.0, four languages. I'm experiencing the following:

 

1/ googlesitemap/index.php shows these errors:

 

Notice: Constant SEO_ADD_CPATH_TO_PRODUCT_URLS already defined in /hosting/www/mysite.com/www/includes/classes/seo.class.php on line 387... quite a few of these and a lot of these:

Notice: Undefined variable: cName in /hosting/www/mysite.com/www/includes/classes/seo.class.php on line 1001

 

Trying the alternate class gives the above plus these errors (it is therefore better to use standard):

 

Warning: fopen(/sitemapproducts.xml): failed to open stream: Permission denied in /hosting/www/mysite.com/www/googlesitemap/sitemap.class.php on line 354

ERROR: Google Product Sitemap Generation FAILED!

 

2/ sitemapspecials.xml

I have two products in category specials, however sitemapspecials.xml shows four identical links for each product, 8 links in total, categories and products are OK - one link per category and one link per product.

Edited by mr_absinthe

Absinthe Original Liquor Store

Link to comment
Share on other sites

You'll have to manually edit the database to remove those extra items.

 

 

I believe I posted how to remove those with the sql needed earlier in the thread.

 

yep, here

http://www.oscommerce.com/forums/topic/330175-google-xml-sitemap-seo/page__view__findpost__p__1435150

 

and Evanisms more elegant solution

http://www.oscommerce.com/forums/topic/330175-google-xml-sitemap-seo/page__view__findpost__p__1438125

Link to comment
Share on other sites

Thanks for this great Add-On.

 

I just installed Google XML Sitemap SEO v1.4, and when running it, I received warnings.

 

I find the '/' missing between store and xml file names (I installed Oscommerce under store folder, not root folder), /public_html/storesitemapproducts.xml.

 

I updated sitemap.class.php line 263 to $this->savepath = DIR_FS_CATALOG . "/"; It fix my problems and generate the sitemap files.

What happens when you try the alternate file or the test function?

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'm running the latest version of this contribution and also the latest version of your SEO_URLs. Php 5.3.0, four languages. I'm experiencing the following:

 

1/ googlesitemap/index.php shows these errors:

 

Notice: Constant SEO_ADD_CPATH_TO_PRODUCT_URLS already defined in /hosting/www/mysite.com/www/includes/classes/seo.class.php on line 387... quite a few of these and a lot of these:

Notice: Undefined variable: cName in /hosting/www/mysite.com/www/includes/classes/seo.class.php on line 1001

php will outpit a lot of warnings like that. They are usually suppressed but some servers are setup to where they show. You can turn off error checking and they will not show but neither will actual errors. But you can safely ignore them in this case. The only thing that matters is if the scripts are generated. You may need to go back to the alternate to get that to happen.

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'm still getting the below error.

I try replacing the XML with blank files.

I try checking the sitemap.class.php but both solution did not resolve this problem.

the admin/configuration has disappeared when this error occur.

The only way to get it back is to run the SQL comment again. The Admin link will reappear but show a duplicate of everything.

 

I initially ran the script as Alternate with diagnostic output, thats where i was getting the errors you were. However, once i changed to Standard and generated the file i had no problems!

Link to comment
Share on other sites

Hello Jack,

 

I need help determining the reason why the categories sitemap file is not generating. When I run the index file in my browser I get this for the categories sitemap:

 

ERROR: Google Category Sitemap Generation FAILED!

 

All the rest of the sitemaps generated successfully. I've changed the permissions to that of the images directory but no success.

 

If you can, give me other things or to check. I'm lost.

 

Thanks in advance.

Link to comment
Share on other sites

Jack,

 

This is the results when I run with the dianostic option:

 

Opening   /home/discxpre/public_html/sitemapproducts.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts.xmlOpening   /home/discxpre/public_html/sitemapproducts1.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts1.xmlOpening   /home/discxpre/public_html/sitemapproducts2.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts2.xmlOpening   /home/discxpre/public_html/sitemapproducts3.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts3.xmlOpening   /home/discxpre/public_html/sitemapproducts4.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts4.xmlOpening   /home/discxpre/public_html/sitemapproducts5.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts5.xmlOpening   /home/discxpre/public_html/sitemapproducts6.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts6.xmlOpening   /home/discxpre/public_html/sitemapproducts7.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts7.xmlOpening   /home/discxpre/public_html/sitemapproducts8.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts8.xmlOpening   /home/discxpre/public_html/sitemapproducts9.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts9.xmlGenerated Google Product Sitemap Successfully

ERROR: Google Category Sitemap Generation FAILED!

Opening   /home/discxpre/public_html/sitemapindex.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapindex.xmlGenerated Google Sitemap Index Successfully

Array
(
   [QUERY] => Array
       (
           [PRODUCTS] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 452105
               )

           [CATEOGRY] => Array
               (
                   [sTATUS] => false
                   [NUM_ROWS] => 0
               )

       )

   [sAVE_FILE_XML] => Array
       (
           [0] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts.xml
                   [status] => success
                   [file_exists] => true
               )

           [1] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts1.xml
                   [status] => success
                   [file_exists] => true
               )

           [2] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts2.xml
                   [status] => success
                   [file_exists] => true
               )

           [3] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts3.xml
                   [status] => success
                   [file_exists] => true
               )

           [4] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts4.xml
                   [status] => success
                   [file_exists] => true
               )

           [5] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts5.xml
                   [status] => success
                   [file_exists] => true
               )

           [6] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts6.xml
                   [status] => success
                   [file_exists] => true
               )

           [7] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts7.xml
                   [status] => success
                   [file_exists] => true
               )

           [8] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts8.xml
                   [status] => success
                   [file_exists] => true
               )

           [9] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts9.xml
                   [status] => success
                   [file_exists] => true
               )

           [10] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapindex.xml
                   [status] => success
                   [file_exists] => true
               )

       )

)

Edited by discxpress
Link to comment
Share on other sites

This is the results when I run with the dianostic option:

I don't see an attempt to create the categories file in that output and I don't know why that would be though. You can try the alternate module but since some of the map files are being created, that is probably not going to make a difference. Also double check that the permissions on the sitemapcategories.xml file are the same as on the others.

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 don't see an attempt to create the categories file in that output and I don't know why that would be though. You can try the alternate module but since some of the map files are being created, that is probably not going to make a difference. Also double check that the permissions on the sitemapcategories.xml file are the same as on the others.

 

I checked the permissions. It is the same as the others. Is there some code in the sitemap class file that I need to check? Or is there some other way or temporary workaround that will allow SE bots to crawl the categories?

 

Thanks for your help.

Link to comment
Share on other sites

I don't see an attempt to create the categories file in that output and I don't know why that would be though. You can try the alternate module but since some of the map files are being created, that is probably not going to make a difference. Also double check that the permissions on the sitemapcategories.xml file are the same as on the others.

The permission of sitemapcategories.xml is the same as the others. Is there some code that I should check? Is there a workaround I can use to get SE bots to crawl the categories until I resolve this issue?

 

Thanks.

Link to comment
Share on other sites

The permission of sitemapcategories.xml is the same as the others. Is there some code that I should check? Is there a workaround I can use to get SE bots to crawl the categories until I resolve this issue?

 

Thanks.

No, there's nothing in the code that would prevent just the categories part from working. The search engines will crawl your categories as long as there is a link to them. The default categories menu won't do that so you need to install an on-site sitemap contribution. For that, see Sitemap SEO in My Addons.

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 permission of sitemapcategories.xml is the same as the others. Is there some code that I should check? Is there a workaround I can use to get SE bots to crawl the categories until I resolve this issue?

 

Thanks.

I just installed this for someone and had the same problem as you described. The problem in my case was due to a mistake in a code change I made for the Quotes contribution and this one. I didn't upload that but did post it so if you have that applied, that is the problem. But to find out either way, open the googlesitemap/sitemap.class file you are using (standard or alternate) and find this line

function GenerateCategorySitemap(){

Then, a few lines down, find this line

if ( $categories_query = $this->DB->Query($sql) ){

Then add this line above that one

echo $sql;

Run the script and post the result, if you don't see a problem with it. That should isolate the cause of the failure.

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

Yahoo and MSN sitemaps?

Hello Jack, first of all, thank you and Chemo for this great contribution! I installed it today with no hassles.

Regarding Yahoo and MSN search engines, I have only seen one yahoo contribution with almost no questions in its forum and nothing about MSN. Is it because those engines rely on the google version? or they do not use sitemaps as much as google? What do you suggest to have my site properly crawl by these 2?

My site is new and have not sell anything yet so I have the time now to maintain manually sitemaps if necessary.

best regards,

Link to comment
Share on other sites

They can read these sitemaps but if you want to have them track the information like google does, you need to create accounts in each of them. Yahoo charges, or at least used to, for that option so few people use it, which is why you don't see much on it. MSN only recently started offerring that through Bing. It is free and there is an option in the account settings to use this sitemap.

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

Yahoo and MSN sitemaps?

Hello Jack, first of all, thank you and Chemo for this great contribution! I installed it today with no hassles.

Regarding Yahoo and MSN search engines, I have only seen one yahoo contribution with almost no questions in its forum and nothing about MSN. Is it because those engines rely on the google version? or they do not use sitemaps as much as google? What do you suggest to have my site properly crawl by these 2?

My site is new and have not sell anything yet so I have the time now to maintain manually sitemaps if necessary.

best regards,

You can go to Yahoo!'s siteexplorer and setup a free account where you can submit sitemaps. You can set up a free webmaster tools account for MSN search which is now Bing here. If you already have a LIVE.COM or Hotmail account you can use that account. They don't give you as much information in reports as Google but it will get them to notice you. Sitemaps are sort of standard so they can read your Google sitemaps with no problem.

 

I hope this helps.

Link to comment
Share on other sites

I just installed this for someone and had the same problem as you described. The problem in my case was due to a mistake in a code change I made for the Quotes contribution and this one. I didn't upload that but did post it so if you have that applied, that is the problem. But to find out either way, open the googlesitemap/sitemap.class file you are using (standard or alternate) and find this line

function GenerateCategorySitemap(){

Then, a few lines down, find this line

if ( $categories_query = $this->DB->Query($sql) ){

Then add this line above that one

echo $sql;

Run the script and post the result, if you don't see a problem with it. That should isolate the cause of the failure.

Jack,

Thanks for the reply. Here's the result from the test:

Opening   /home/discxpre/public_html/sitemapproducts.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts.xmlOpening   /home/discxpre/public_html/sitemapproducts1.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts1.xmlOpening   /home/discxpre/public_html/sitemapproducts2.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts2.xmlOpening   /home/discxpre/public_html/sitemapproducts3.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts3.xmlOpening   /home/discxpre/public_html/sitemapproducts4.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts4.xmlOpening   /home/discxpre/public_html/sitemapproducts5.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts5.xmlOpening   /home/discxpre/public_html/sitemapproducts6.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts6.xmlOpening   /home/discxpre/public_html/sitemapproducts7.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts7.xmlOpening   /home/discxpre/public_html/sitemapproducts8.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts8.xmlOpening   /home/discxpre/public_html/sitemapproducts9.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapproducts9.xmlGenerated Google Product Sitemap Successfully

SELECT categories_id as cID, date_added, last_modified as last_mod 
		    FROM categories 
			ORDER BY parent_id ASC, sort_order ASC, categories_id ASCERROR: Google Category Sitemap Generation FAILED!

Opening   /home/discxpre/public_html/sitemapindex.xmlFS_CAT    /home/discxpre/public_html/Server    http://www.discxpress.comSave Path /home/discxpre/public_html/WS_CAT    / Write /home/discxpre/public_html/sitemapindex.xmlGenerated Google Sitemap Index Successfully

Array
(
   [QUERY] => Array
       (
           [PRODUCTS] => Array
               (
                   [sTATUS] => success
                   [NUM_ROWS] => 452106
               )

           [CATEOGRY] => Array
               (
                   [sTATUS] => false
                   [NUM_ROWS] => 0
               )

       )

   [sAVE_FILE_XML] => Array
       (
           [0] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts.xml
                   [status] => success
                   [file_exists] => true
               )

           [1] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts1.xml
                   [status] => success
                   [file_exists] => true
               )

           [2] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts2.xml
                   [status] => success
                   [file_exists] => true
               )

           [3] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts3.xml
                   [status] => success
                   [file_exists] => true
               )

           [4] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts4.xml
                   [status] => success
                   [file_exists] => true
               )

           [5] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts5.xml
                   [status] => success
                   [file_exists] => true
               )

           [6] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts6.xml
                   [status] => success
                   [file_exists] => true
               )

           [7] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts7.xml
                   [status] => success
                   [file_exists] => true
               )

           [8] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts8.xml
                   [status] => success
                   [file_exists] => true
               )

           [9] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapproducts9.xml
                   [status] => success
                   [file_exists] => true
               )

           [10] => Array
               (
                   [file] => /home/discxpre/public_html/sitemapindex.xml
                   [status] => success
                   [file_exists] => true
               )

       )

)

 

Thanks

Link to comment
Share on other sites

Thanks for the reply. Here's the result from the test:

Unfortunately, that looks fine so the cuase is something else.

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

Hello Jack,

 

I got an error while updating from 1.4 to 1.5.

 

Should not the slashes pointing the same direction?

home\wihirt\www\catalog/sitemapindex.xml

 

Opening \home\wihirt\www\catalog/sitemapproducts.xml

FS_CAT \home\wihirt\www\catalog/

Server http://www.koolkatjazz.com

Save Path \home\wihirt\www\catalog/

WS_CAT /catalog/

 

 

Warning: fopen(\home\wihirt\www\catalog/sitemapproducts.xml) [function.fopen]: failed to open stream: No such file or directory in /home/wihirt/public_html/catalog/googlesitemap/sitemap.class.php on line 345

 

ERROR: Google Product Sitemap Generation FAILED!

 

SELECT categories_id as cID, date_added, last_modified as last_mod

FROM categories

ORDER BY parent_id ASC, sort_order ASC, categories_id ASCOpening \home\wihirt\www\catalog/sitemapcategories.xml

FS_CAT \home\wihirt\www\catalog/

Server http://www.koolkatjazz.com

Save Path \home\wihirt\www\catalog/

WS_CAT /catalog/

 

 

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

 

ERROR: Google Category Sitemap Generation FAILED!

 

 

 

Warning: Invalid argument supplied for foreach() in /home/wihirt/public_html/catalog/googlesitemap/sitemap.class.php on line 429

 

Opening \home\wihirt\www\catalog/sitemapindex.xml

FS_CAT \home\wihirt\www\catalog/

Server http://www.koolkatjazz.com

Save Path \home\wihirt\www\catalog/

WS_CAT /catalog/

 

 

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

 

ERROR: Google Sitemap Index Generation FAILED!

 

Array

(

[QUERY] => Array

(

[PRODUCTS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 465

)

 

[CATEOGRY] => Array

(

[sTATUS] => success

[NUM_ROWS] => 51

)

 

)

 

[sAVE_FILE_XML] => Array

(

[0] => Array

(

[file] => \home\wihirt\www\catalog/sitemapproducts.xml

[status] => failure

[file_exists] => false

)

 

[1] => Array

(

[file] => \home\wihirt\www\catalog/sitemapcategories.xml

[status] => failure

[file_exists] => false

)

 

[2] => Array

(

[file] => \home\wihirt\www\catalog/sitemapindex.xml

[status] => failure

[file_exists] => false

)

 

)

 

)

 

Thank you for a great contribution

 

Cheers

Edited by pederb
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...