Google SitemapAdmin

Well I know that... that was what I meant... I just want the content from my 'Services' sidebox induded in the generated xml files.

Eg.

I only get sitemapproducts.xml, sitemapcategories.xml, sitemapezpages.xml.

However, I want it to generate sitemapservices.xml.

I think some of my sites define pages I have linked to in my sidebox have been indexed by google now so i imagine google found them by crawling as oppsed to my sitemap. But i still think it would be useful to be able to generate sitemapnameofsidebox.xml pages.

Anyone else with me?

I really like this mod, but have an odd need. Some background....
We have resellers that sell our products, and they can't have the badges that they order, get indexed and then their customer order from us instead of them. We also sell direct to customers, so our shop right now has mostly just customers. We want to add the resellers on-line, and have been using the hideCategories mod. It works well, and with no links those pages should be pretty secret, since most of the resellers customers don't know that they could get their badges from us, and probably aren't looking super hard. I understand it isn't perfect, but it seems like a workable solution for everyone. Where it falls apart is that this mod shows all categories even those that are hidden. I would really like some direction on finding where the SQL is or some hints on where to look to accomplish getting these not put in our sitemaps, both the categories and products that are hidden.

Thanks for your help, Matt

I am getting the following error when my sitemaps generate.

XML Parsing Error: not well-formed
Location: http://www.uniqueseason.com/sitemapezpages.xml
Line Number 23, Column 100:

This is in my sitemapezpages.xml. The other three sitemaps work just fine.

Any ideas as to why this might happen?

Hi Matt,

mdegrandis:

using the hideCategories mod.
E-mail me. SitemapXML v2 theoretically supported hideCategories, but we need to test.

russa2:

I am getting the following error when my sitemaps generate.

XML Parsing Error: not well-formed
Location: http://www.uniqueseason.com/sitemapezpages.xml
Line Number 23, Column 100:

This is in my sitemapezpages.xml. The other three sitemaps work just fine.

Any ideas as to why this might happen?

Yes, this is a bug in the module.

Hello,

I sent all the files to my root, then installed. sql, and had the following error:

Success 8 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

admin>tools>Google XML Sitemap Admin = work fine

but

admin>configuration>Google XML Sitemap = is a blank page

my zen cart is 1.3.8a and the sql is:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'),
(NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'),
(NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:<br />date - Complete date: YYYY-MM-DD (eg 1997-07-16)<br />full - Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('date', 'full'),'),
(NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'),
(NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);

Plz help me ASAP :)

thx.

Hi,
Try this install.sql:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:<br />date - Complete date: YYYY-MM-DD (eg 1997-07-16)<br />full -    Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'date\', \'full\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);

thx a lot, work fine. :clap:

could anyone give me a download link for this mod?

Found the link, went through the install...

a bit stuck...

i see Admin > Config > Google XML Sitemap menu

but i don't have

Admin > **Tools **> Google XML Sitemap

So, i can not generate the sitemap... any idea what this could be?

Agent_KGB
Did you copy the Googlesitemap.php into catalog directory not Admin?

I am also struggling to install this one.

I have 1.38a installed as new with one or two mods now installed - everything working fine to date.

Uploaded all files, instructions were a little garbled in txt file, but think I have it correct.

Copy and pasted INSTALL.SQL and 8 statements processed - now see Google XML Sitemap under Configuration menu but nothing under Tools.

Tried to copy and paste the 3x UPGRADE.SQL files but all report errors similar to those mentioned by Agent_KGB.

Tried the SQL content show above and reported 20 statements processed. Still nothing under Tools.

The Googlesitemap.php file is stored directly under Admin.

What am I doing wrong, do I need to do anything to the settings of the Google XML Sitemap bit under Admin (not touched them since install).

Any advice would be welcome.

i install the google sitempa
when comt to tools----google xml sitemap -----click here

can not creat the xml..

help assp......

Hi, have installed everything but when I try to add the mysql as instructed via copy and paste (not file upload) I just get logged out of my admin. File upload works I have been using it fine, paste doesn't.

I tried to run it instead via phpmyadmin and got:

#1146 - Table 'user_dbname.configuration_group' doesn't exist

Can you advise please?

Thanks

Just to add Full error message.

When I try to run the install via phpmyadmin I get:

SQL query:

SELECT (
@configuration_group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'Google XML Sitemap'
LIMIT 1 ;

MySQL said:
#1146 - Table 'user_dbname.configuration_group' doesn't exist

Please advise
Thanks

For those of you who don't like getting the Google warning,

"All the URLs in your Sitemap have the same priority.":

I have made a little hack that will alter the priority of the first 2 urls in each sitemap. It arbitrarily reduces the priority of the first 2 urls by .1. If your priority is set for .7, then the first 2 urls will have a priority of .6 and the rest will be .7. This will satisfy the google bot and eliminate the warning message.

It is also possible to open up your sitemap files and manually alter a couple of urls. This will also work. But I have mine set up to run daily as an automated task, so do not have this option. So I created a couple of lines of code to handle this for me.

In googlesitemap.php, the following is all original code, except for the part between "// begin kehrli mod:" and "// end kehrli mod". Just find that part of the code and insert the 3 new lines.

      $number++;
      $contentXML .= ' <url>' . "\n";
      $contentXML .= '  <loc>' . utf8_encode($url['loc']) . '</loc>' . "\n";
      if(isset($url['lastmod']) && $url['lastmod'] != '')
        $contentXML .= '  <lastmod>' . $this->LastMod($url['lastmod']) . '</lastmod>' . "\n";
      if(isset($url['changefreq']) && $url['changefreq'] != '')
        $contentXML .= '  <changefreq>' . $url['changefreq'] . '</changefreq>' . "\n";
      if(isset($url['priority']) && $url['priority'] != '')
// begin kehrli mod:
        if($number < 3)
          $contentXML .= '  <priority>' . ($url['priority'] - .1) . '</priority>' . "\n";
        else
// end kehrli mod
          $contentXML .= '  <priority>' . $url['priority'] . '</priority>' . "\n";
      $contentXML .= ' </url>' . "\n";
    

sowie09:

All set up fine and google is seeing my sitemaps, Problem is all 3 have got warnings, in google it says All the URLs in your Sitemap are marked as having dynamic content & All the URLs in your Sitemap have the same priority. my sitemaps arehttp://www.apollobuildingsupplies.co.uk/sitemapproducts.xml http://www.apollobuildingsupplies.co.uk/sitemapcategories.xml http://www.apollobuildingsupplies.co.uk/sitemapezpages.xml have i done somthing wrong??

I'm getting the same warning from google...

montanaquilter:

I'm getting the same warning from google...
For the dynamic content, that is normal, try a mod like Simple SEO URLs, look for support thread and download from author's site.
For the other issue, I believe solution is posted a couple posts above.

I just installed this Mod and I do believe it was installed correctly. And have things setup on Google's end.

When I try to create a Sitemap file, a small blank window pops up. What am I doing wrong?

montanaquilter:

All the URLs in your Sitemap have the same priority
I'm getting the same warning from google...
Yes, this is an error. There is no need to use the old module - use the latest version SitemapXML v.2. You can email me to get last version.