Google XML Sitemap SEO

[Eim2]

@@Jack_mcs

 

You say it, a non issue. No problems at all as indeed Google sees the files without errors

and with a little tweaking through unix sed the missing special characters are added easily in no time.

 

Thanks a lot

[Jack_mcs]

IMPORTANT: If your shop is using the mobile addon, you can't use V 1.11 because the lack of the use of defined filenames will cause the urls for the mobile sitemaps to be incorrect. Use V 1.1.0 instead.

[Dj-Viper]

Hi,

 

I'm at a los...

 

I have the shop end SSL - the admin end not.

 

I have Ultimate SEO V 2.2 - 14 installed for the search friendly urls.

 

But the links in the XML Sitemap are http:// and old id paths.

 

??

 

Greetings, Anne

[Jack_mcs]

@@Dj-Viper It depends on a number of things. Are you using the latest version of Ultimate SEO and this addon? If so, have you tried backing up your version as I mentioned above? What version of oscommerce are you using? What php version?

[Dj-Viper]

Hi,

 

XML 1.11

2.2 - 14 of the ultimate, version 16 is for edge i have gold.

2.3.4 gold

 

Have no mobile addon.

 

Php 5.3 active.

 

Greetings , Anne

[Jack_mcs]

I don't see a version 16 for Ultimate SEO - maybe that was a typo. But I suggest you install V15. There's nothing in it to cause it to fail with the Gold version. But all that is needed to upgrade it is to replace the includes/classes/seo.class.php file. If the upgrade causes a failure, just replace that file with the original. Or, you could use V10 of this addon.

[Dj-Viper]

I don't see a version 16 for Ultimate SEO - maybe that was a typo. But I suggest you install V15. There's nothing in it to cause it to fail with the Gold version. But all that is needed to upgrade it is to replace the includes/classes/seo.class.php file. If the upgrade causes a failure, just replace that file with the original. Or, you could use V10 of this addon.

 

Did mean 15 but dit the upgrade from that only the seo.class file and it worked. 

 

Greetings, Anne

[Jack_mcs]

Great. I'm glad to hear it worked. :)

[Guest]

Got the latest version installed on a 2.3.4 shop and was wondering how do I update the xml files on my database manually?

The older version for 2.2 had a section in the admin to manually update the various files.

[Jack_mcs]

Nothing has changed in that regard. If it is a new install, you have to make the changes to the tools file. Sounds like you missed that step.

[Psytanium]

Hi,

I receive a mail from cron job every day saying CONGRATULATIONS! All files generated successfully ...

should I click the link to submit the sitemap every time i receive this email ?

thanks

[Jack_mcs]

No, that isn't necessary. Once the search engines are aware of the maps they will look at them automatically. Just be sure you have added them to your google and Bing webmaster accounts. But if you want to click on the links, it won't hurt anything.

[Cary]

On 4/27/2015 at 6:28 PM, phi148 said:

 

Jack

 

I have SEO URLS 5 by FWD Media installed.  Do you know how to modify this update (1.8) to have proper SEO URLS?

 

I added the above, and that got all my sitemaps created, yet all my links are not SEO URL formatted.

 

Any clues?

 

Thanks!!!

Bill

Anyone get Google XML Sitemap to work with SEO URLs 5? XML links are not SEO URL formatted.

[Psytanium]

In Google Webmaster Tools I have many duplicates

 e.g.

/product_info.php/targus-bag-tss588us-156-black-p-6437
/product_info.php?products_id=6437

is it because Google XML Sitemap is not compatible with SEO URLs 5  ??

[frankl]

@Cary  @Psytanium

This is the contents of my SiteMapProducts.php sitemap (note the php extension, enter it exactly like that in Google Webmaster Tools).

I am using USU5 and it works perfectly.

<?php
  header('Content-type: application/xml');
 
  include ('includes/application_top.php');
 $products_query = tep_db_query("select products_id from products where products_status = '1' order by products_id DESC");
 
  $output = '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
  $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . "\n";
  echo $output;
?>
<?php
  while ($products = tep_db_fetch_array($products_query)) {
    $str = $products['products_id'];
    $exclude_list = array(); // add any product ids you wish to exclude with a comma separating each i.e. 12,28,36
    if(!in_array($str, $exclude_list)) {
    ?>
<url>
  <loc><?php echo tep_href_link('product_info.php', 'products_id=' . (int)$products['products_id'], 'NONSSL', false); ?></loc>
</url>
<?php
    }
  }
 ?>
</urlset>

 

[Psytanium]

On 6/23/2017 at 9:12 AM, frankl said:

@Cary  @Psytanium

This is the contents of my SiteMapProducts.php sitemap (note the php extension, enter it exactly like that in Google Webmaster Tools).

I am using USU5 and it works perfectly.

<?php
  header('Content-type: application/xml');
 
  include ('includes/application_top.php');
 $products_query = tep_db_query("select products_id from products where products_status = '1' order by products_id DESC");
 
  $output = '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
  $output .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . "\n";
  echo $output;
?>
<?php
  while ($products = tep_db_fetch_array($products_query)) {
    $str = $products['products_id'];
    $exclude_list = array(); // add any product ids you wish to exclude with a comma separating each i.e. 12,28,36
    if(!in_array($str, $exclude_list)) {
    ?>
<url>
  <loc><?php echo tep_href_link('product_info.php', 'products_id=' . (int)$products['products_id'], 'NONSSL', false); ?></loc>
</url>
<?php
    }
  }
 ?>
</urlset>

 

Where is the SiteMapProducts.php  file located ?

[frankl]

@Psytanium

 You need to create it in the same directory as your store.

[sudhara429]

hi how to remove images sub folder links from image sitemap bcoz  google search console get crawl error 

/images/Tedy

Googlebot couldn't crawl this URL because it points to a non-existent page. Generally, 404s don't harm your site's performance in search, but you can use them to help improve the user experience.

[Jack_mcs]

There isn't any code in place to limit the images. But the links are built by reading in the products and their images so I don't understand how the product could not exist.

[sudhara429]

2 hours ago, sudhara429 said:

hi how to remove images sub folder links from image sitemap bcoz  google search console get crawl error 

/images/Tedy

Googlebot couldn't crawl this URL because it points to a non-existent page. Generally, 404s don't harm your site's performance in search, but you can use them to help improve the user experience.

not a image name its sub folder name on image folder

 

[Jack_mcs]

If there is a directory as part of the image name in the database and it is not correct, you need to edit that product to remove the directory name.

[intertech]

Hi There,

I have successfully installed your contribution and it generates the XML sitemaps for me, however it does NOT generate SEO URL's for the sitemap. 

For Example: 

This is what is generated in the sitemap:    

http://devsite.garrettspecialties.com/index.php?cPath=21

This is what is what the URL Should be

http://devsite.garrettspecialties.com/automotive-products-auto-water-bottles-c-2_1265.html

 

Any help on this would be much appreciated!

[Jack_mcs]

Last I checked this addon is not compatible with SEO 5 so if you are using that addon, that is probably the reason.

[intertech]

Hi Jack. Thanks for the quick reply!

I just upgraded my store to :

Ultimate SEO 2-2.2d-15

The Sitemap now has the the SEO URL's in it. I just need to fix some issues with .htaccess and I should be good. I was using 2.1 and I belive that was the issue.

I will post back here when i have everything working.

[Guest]

Hi Jack

 

I know there has been an answer posted somewhere for my prob, I can't for the  life of me find it. When I type www.XXXXXXX.co.nz/sitemapindex.xml in  the browser the following is what I get. Apparently the installation was correctly completed.  Here's the disagnostics

Not sure how to correct.

Appreciate any comments.

Many thanks

Grandpa

 

Opening   /home/xxxxx/public_html/sitemapproducts.xml

FS_CAT    /home/xxxxx/public_html/

Server    https://www.xxxxxxxx.co.nz

Save Path /home/xxxxx/public_html/

WS_CAT    /

Write /home/xxxxxx/public_html/sitemapproducts.xml
Generated Google Product Sitemap Successfully

Opening   /home/xxxxx/public_html/sitemapcategories.xml

FS_CAT    /home/xxxxxx/public_html/

Server    https://www.xxxxxxx.co.nz

Save Path /home/xxxxxxx/public_html/

WS_CAT    /

Write /home/xxxxxx/public_html/sitemapcategories.xml
Generated Google Category Sitemap Successfully

Opening   /home/xxxxxxx/public_html/sitemapmanufacturers.xml

FS_CAT    /home/xxxxxxxx/public_html/

Server    https://www.xxxxxx.co.nz

Save Path /home/xxxxxxx/public_html/

WS_CAT    /

Write /home/xxxxxx/public_html/sitemapmanufacturers.xml
Generated Google Manufacturers Sitemap Successfully

Opening   /home/xxxxxxx/public_html/sitemappages.xml

FS_CAT    /home/xxxxxx/public_html/

Server    https://www.grandpas.co.nz

Save Path /home/xxxxxxx/public_html/

WS_CAT    /

Write /home/xxxxxxx/public_html/sitemappages.xml
Generated Google Pages Sitemap Successfully

Opening   /home/xxxxxx/public_html/sitemapspecials.xml

FS_CAT    /home/xxxxxx/public_html/

Server    https://www.grandpas.co.nz

Save Path /home/xxxxxxx/public_html/

WS_CAT    /

Write /home/xxxxxx/public_html/sitemapspecials.xml
Generated Google Specials Sitemap Successfully

Opening   /home/xxxxxx/public_html/sitemapindex.xml

FS_CAT    /home/xxxxxxx/public_html/

Server    https://www.xxxxxxxx.co.nz

Save Path /home/xxxxxxx/public_html/

WS_CAT    /

Write /home/xxxxxxxx/public_html/sitemapindex.xml
Generated Google Sitemap Index Successfully

The following is what is produced

Google Sitemap https://www.XXXXXXX.co.nz/sitemapindex.xml

Number of sitemaps in this Google sitemap index: 0

Click on the table headers to change sorting.

Sitemap URL

Last modification date