You are here:  » mapped products sitemap

Active Forum Topics


mapped products sitemap

Submitted by philstone on Mon, 2017-12-04 09:06 in

Hi David

I was wondering, would it be possible to create a separate 'mapped products only' sitemap?

eg. sitemap-pm.php

thanks

Phil

Submitted by support on Mon, 2017-12-04 11:09

Hello Phil,

Sure - have a go with;

<?php
  require("includes/common.php");
  header("Content-Type: text/xml");
  print "<?xml version='1.0' encoding='UTF-8'?>";
  print "<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>";
  $sql = "SELECT name FROM `".$config_databaseTablePrefix."productsmap`";
  $link = mysqli_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,$config_databaseName);
  mysqli_set_charset($link,"utf8");
  mysqli_real_query($link,$sql);
  $result = mysqli_use_result($link);
  $sitemapBaseHREF = "http".(isset($_SERVER["HTTPS"])&&$_SERVER["HTTPS"]?"s":"")."://".$_SERVER["HTTP_HOST"];
  while($row = mysqli_fetch_assoc($result))
  {
    $row["normalised_name"] = tapestry_normalise($row["name"]);
    print "<url>";
    $sitemapHREF = tapestry_productHREF($row);
    print "<loc>".$sitemapBaseHREF.$sitemapHREF."</loc>";
    print "</url>";
  }
  print "</urlset>";
?>

Cheers,
David.
--
PriceTapestry.com

Submitted by philstone on Wed, 2017-12-13 09:01

Thanks David

Works great, just came accross a small problem though..

Your Sitemap contains too many URLs. Please create multiple Sitemaps with up to 50000 URLs each and submit all Sitemaps.

is there a solution for this?

Thanks

Phil

Submitted by support on Wed, 2017-12-13 11:07

Hello Phil,

Sure - here's a version that will initially return a sitemap index with links to individual sitemaps of up to 50,000 products (just like the main sitemap.php script)...

<?php
  require("includes/common.php");
  header("Content-Type: text/xml");
  print "<?xml version='1.0' encoding='UTF-8'?>";
  $sitemapBaseHREF = "http".(isset($_SERVER["HTTPS"])&&$_SERVER["HTTPS"]?"s":"")."://".$_SERVER["HTTP_HOST"].$config_baseHREF;
  $start = (isset($_GET["start"])?intval($_GET["start"]):FALSE);
  $limit = 50000;
  if ($start !== FALSE)
  {
    print "<urlset xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>";
    $sql = "SELECT name FROM `".$config_databaseTablePrefix."productsmap` ORDER BY id LIMIT ".$start.",".$limit;
    $link = mysqli_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,$config_databaseName);
    mysqli_set_charset($link,"utf8");
    mysqli_real_query($link,$sql);
    $result = mysqli_use_result($link);
    while($row = mysqli_fetch_assoc($result))
    {
      $row["normalised_name"] = tapestry_normalise($row["name"]);
      print "<url>";
      $sitemapHREF = tapestry_productHREF($row);
      print "<loc>".$sitemapBaseHREF.$sitemapHREF."</loc>";
      print "</url>";
    }
    print "</urlset>";
  }
  else
  {
    $sql = "SELECT COUNT(*) AS numProducts FROM `".$config_databaseTablePrefix."productsmap`";
    database_querySelect($sql,$rows);
    $numProducts = $rows[0]["numProducts"];
    print "<sitemapindex xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>";
    $start = 0;
    while($start < $numProducts)
    {
      print "<sitemap>";
      $sitemapHREF = "sitemap-pm.php?start=".$start;
      print "<loc>".$sitemapBaseHREF.$sitemapHREF."</loc>";
      print "</sitemap>";
      $start += $limit;
    }
    print "</sitemapindex>";
  }
?>

Cheers,
David.
--
PriceTapestry.com