Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[CONTRIBUTION] Google XML Sitemap Feed - by Chemo


Guest

Recommended Posts

Hello Chemo! Until I can say congrats for the work you've done, please be kind and help with this error:

 

I installed the latest add-ons to your contrib from here,

http://www.oscommerce.com/community/contri...search,site+map

 

but i get this error when I make the first step

 

"INSTRUCTIONS:

 

STEP 1: Click [HERE] to create / update your site map.

 

NOTE: Please ensure that you or your web developer has registered with Google SiteMaps, and submitted your initial site map before proceeding to step 2. "

 

Warning: main(includes/languages/romanian/FILENAME_GOOGLE_SITEMAPS): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/maycon.ro/httpdocs/sitemaps.index.php on line 33

Warning: main(includes/languages/romanian/FILENAME_GOOGLE_SITEMAPS): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/maycon.ro/httpdocs/sitemaps.index.php on line 33

Warning: main(includes/languages/romanian/FILENAME_GOOGLE_SITEMAPS): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/maycon.ro/httpdocs/sitemaps.index.php on line 33

Fatal error: main(): Failed opening required 'includes/languages/romanian/FILENAME_GOOGLE_SITEMAPS' (include_path='.:/usr/local/psa/apache/share/pear') in /usr/local/psa/home/vhosts/maycon.ro/httpdocs/sitemaps.index.php on line 33

 

Any idea where this is coming from?

Sorry for my bad english language!

Link to comment
Share on other sites

Kool,

 

Thanks for the reply. I hate to sound like a nubie but what are articles?

 

Thanks,

Eric

 

Hi Eric,

 

I think you need to install other contribs to have articles (either that or they are the reviews in your system - im not quite sure).

 

Cheers,

Chris

Link to comment
Share on other sites

Just regarding these 5 new files to install.......

googleSitemapTopics

googleSitemapManufacturers

googleSitemapProducts

googleSitemapArticles

googleSitemapCategories

 

where in google site maps do I add my new url's? I only installed it 4 hours ago so maybe I have to wait to be approved first since it's still pending. Great contrib and next is the Chemo URL's contrib......oh the work I put into these sites.

 

Nigelman :thumbsup:

Link to comment
Share on other sites

Just regarding these 5 new files to install.......

googleSitemapTopics

googleSitemapManufacturers

googleSitemapProducts

googleSitemapArticles

googleSitemapCategories

 

where in google site maps do I add my new url's? I only installed it 4 hours ago so maybe I have to wait to be approved first since it's still pending. Great contrib and next is the Chemo URL's contrib......oh the work I put into these sites.

 

Nigelman :thumbsup:

 

Hey, If I understand you correctly, you have already submitted the sitemaps to Google Sitemaps, and they are in pending status? If so, that is fine and they should be approved shortly.

 

Also, with Chemo's Ultimate SEO URL's, install Chemo's official 2.1d that I put in the contrib area. I think it is the best one.

 

Cheers,

Chris

Link to comment
Share on other sites

Thank you Chemo (and Stonebridge) for the contribs - SEO Url's and the Google SiteMap contribs are as great as everyone is saying.

 

I've been watching this forum for a while now, hoping that someone is having the same problem that I am, but I just don't seem to see an answer. I initially used the XML sitemap contrib and recently switched to Chemo's latest php generator hoping that the problem would disappear. Google seems to be trying to crawl my site with regularity, but the only results that I am getting are Unreachable URLs (Network unreachable). Here is an example of the error listing:

 

bad_sitemap.jpg

 

I currently have over 1300 of these errors that are all relatively recent. If I click on any of the links, they work and go to the appropriate page. And, at least to me, they do it relatively quickly. I don't have any other google errors, like HTTP errors, Not found, URL not followed, etc.

 

As a result, I'm just not being indexed by them at all. So, what is causing google to choke when it is indexing my site? Any help that you all could provide would be greatly appreciated.

 

thanks in advance.

 

Tony

Link to comment
Share on other sites

Hey, If I understand you correctly, you have already submitted the sitemaps to Google Sitemaps, and they are in pending status? If so, that is fine and they should be approved shortly.

 

Also, with Chemo's Ultimate SEO URL's, install Chemo's official 2.1d that I put in the contrib area. I think it is the best one.

 

Cheers,

Chris

 

I submitted my URL and that's it? do I have to do more for it to work or will google figure it all out regarding those other sitemaps? When I went to googlesitemaps it just asked for my URL and then said pending approval so I guess I just have to be patient at this point..... :thumbsup:

 

Next Chemo's Ultimate SEO URL's!

 

Nigelman B)

Link to comment
Share on other sites

Man I wish we could edit our comments after we make them....... anyways I figured out how add all my site maps now and I have the following error from google:

 

 Line:
3
Paths don't match 
We've detected that you submitted your Sitemap using a URL path that includes the www prefix (for instance, http://www.example.com/sitemap.xml). However, the URLs listed inside your Sitemap don't use the www prefix (for instance, http://example.com/myfile.htm).	[?]  Url:
http://tsurishopjapan.com/index.php?cPath=58

 

Next when I did the mysite.com/googlesitemap/index.php, I got this:

 

Generated Google Product Sitemap Successfully

Generated Google Category Sitemap Successfully

Generated Google Sitemap Index Successfully

CONGRATULATIONS! All files generated successfully.

If you have not already submitted the sitemap index to Google click the link below.
Before you do I HIGHLY recommend that you view the XML files to make sure the data is correct.

http://www.google.com/webmasters/sitemaps/ping?sitemap=http%3A%2F%2Ftsurishopjapan.com%2Fsitemapindex.xml

For your convenience here is the CRON command for your site:
php /home/fukuokaf/public_html/tsurishopjapan/googlesitemap/index.php

Here is your sitemap index: http://tsurishopjapan.com/sitemapindex.xml
Here is your product sitemap: http://tsurishopjapan.com/sitemapproducts.xml
Here is your category sitemap: http://tsurishopjapan.com/sitemapcategories.xml

 

But these bottom 3 don't work? I get this error:

 

XML Parsing Error: no element found
Location: http://www.tsurishopjapan.com/sitemapindex.xml
Line Number 1, Column 1:

 

The other ones are working ok:

http://www.tsurishopjapan.com/googleSitemapCategories.php

etc etc etc

 

What should I do?

 

Nigelman :o

Edited by Tsuri Japan
Link to comment
Share on other sites

Man I wish we could edit our comments after we make them....... anyways I figured out how add all my site maps now and I have the following error from google:

 

 Line:
3
Paths don't match 
We've detected that you submitted your Sitemap using a URL path that includes the www prefix (for instance, http://www.example.com/sitemap.xml). However, the URLs listed inside your Sitemap don't use the www prefix (for instance, http://example.com/myfile.htm).	[?]  Url:
http://tsurishopjapan.com/index.php?cPath=58

 

Next when I did the mysite.com/googlesitemap/index.php, I got this:

 

Generated Google Product Sitemap Successfully

Generated Google Category Sitemap Successfully

Generated Google Sitemap Index Successfully

CONGRATULATIONS! All files generated successfully.

If you have not already submitted the sitemap index to Google click the link below.
Before you do I HIGHLY recommend that you view the XML files to make sure the data is correct.

http://www.google.com/webmasters/sitemaps/ping?sitemap=http%3A%2F%2Ftsurishopjapan.com%2Fsitemapindex.xml

For your convenience here is the CRON command for your site:
php /home/fukuokaf/public_html/tsurishopjapan/googlesitemap/index.php

Here is your sitemap index: http://tsurishopjapan.com/sitemapindex.xml
Here is your product sitemap: http://tsurishopjapan.com/sitemapproducts.xml
Here is your category sitemap: http://tsurishopjapan.com/sitemapcategories.xml

 

But these bottom 3 don't work? I get this error:

 

XML Parsing Error: no element found
Location: http://www.tsurishopjapan.com/sitemapindex.xml
Line Number 1, Column 1:

 

The other ones are working ok:

http://www.tsurishopjapan.com/googleSitemapCategories.php

etc etc etc

 

What should I do?

 

Nigelman :o

 

Hi,

 

I am completely confused. You seem to be using BOTH versions of this contrib (both the one that needs cron jobs, and the on the fly one).

 

With the new version of the contribs, you ONLY use the ones called googleSitemapCategories.php, googleSitemapProducts.php etc. You do NOT use the one /googlesitemap/index.php, which outputs that information about "Generated Google Product Sitemap" etc.

 

So remove the old version, and just use the new version.

 

Cheers,

Chris

Link to comment
Share on other sites

Ok I hear yeah and maybe I installed the older version with the newer one........but it was so dam confusing which one and how to install this. I did the previous version from Chemo and then the newest addon.

 

Ok google site map I've added this url:

http://www.tsurishopjapan.com/googleSitemapManufacturers.php

 

but I get this error:

Paths don't match

We've detected that you submitted your Sitemap using a URL path that includes the www prefix (for instance, http://www.example.com/sitemap.xml). However, the URLs listed inside your Sitemap don't use the www prefix (for instance, http://example.com/myfile.htm). [?] Url:

http://tsurishopjapan.com/index.php?manufacturers_id=23

 

I don't get this at all?

 

Nigelman :thumbsup:

Link to comment
Share on other sites

Ok I hear yeah and maybe I installed the older version with the newer one........but it was so dam confusing which one and how to install this. I did the previous version from Chemo and then the newest addon.

 

Ok google site map I've added this url:

http://www.tsurishopjapan.com/googleSitemapManufacturers.php

 

but I get this error:

Paths don't match

We've detected that you submitted your Sitemap using a URL path that includes the www prefix (for instance, http://www.example.com/sitemap.xml). However, the URLs listed inside your Sitemap don't use the www prefix (for instance, http://example.com/myfile.htm). [?] Url:

http://tsurishopjapan.com/index.php?manufacturers_id=23

 

I don't get this at all?

 

Nigelman :thumbsup:

 

Hi,

 

This problem is because your website is set up mainly as http://tsurishopjapan.com instead of http://www.tsurishopjapan.com. That is why Google is having a problem with it.

 

My suggestion is to change your configure.php to make your site at http://www.tsurishopjapan.com

 

Regards,

Chris

Link to comment
Share on other sites

Hi all I'm A bit scared that google will give a bad ranking to my site when using this

Because

 

I'm useing SEO urls.

 

So the googleSitemapManufacturers.php

Gives this

 

<loc>http://www.mywebsite.com/Manufacturer-name/</loc>

 

then in there google will crawl around to find product-1 so google would see this as

 

http://www.mywebsite.com/Manufacturer-name/product-1/

 

But then googleSitemapProducts.php

Gives this

 

<loc>http://www.mywebsite.com/product-1/</loc>

 

Wich is exsacly the same as http://www.mywebsite.com/Manufacturer-name/product-1/

Its just the SEO contrabution wrighting it like that.

 

So when google sees 2 pages exacly the same with 2 different urls does it score my site less???

 

What do you guys think?

 

Cheers All

J

Edited by jaminunit
Link to comment
Share on other sites

Hi,

 

This problem is because your website is set up mainly as http://tsurishopjapan.com instead of http://www.tsurishopjapan.com. That is why Google is having a problem with it.

 

My suggestion is to change your configure.php to make your site at http://www.tsurishopjapan.com

 

Regards,

Chris

 

Awesome thanks for that heads up comment Stoney! I look foward to hopefully a higher page rank (now 3) and many more hits.

 

In my google account it now says no error and all is well.

googleSitemapCategories.php Sitemap Web 8 minutes ago 6 minutes ago OK

 

sorry for asking for so much help on this and thanks for all your help guys!

 

Nigelman :thumbsup:

Link to comment
Share on other sites

I also have another question. The googleSitemapProducts.php appears to call the includes/application_top.php.

 

How can I run to test to see if the script is actually getting called?

(Cause I suspect that might be the problem I'm having with the output of sitename.com instead of www.sitename.com )

Link to comment
Share on other sites

Solution: Apparently there are 2 configure.php files. One in includes, and the other in includes/local/

Fixing the one in includes/local/ appeared to have solved the issue.

 

Hmmm... interesting. I dont have a configure.php in includes/local/

Maybe you have done another mod or are using a different version??

 

Ah well... At least it is working for you now.

 

Cheers,

Chris :)

Link to comment
Share on other sites

  • 3 weeks later...

Hi there, i installed this contrib back in May and i think it's working ok. One thing that i had to do though was set up a cron job to copy the sitemap files to my root directory.

 

My shop is actually installed in www.chapelradiocontrol.com/shop so when i went to google i naturally added the url as www.chapelradiocontrol.com. When i tried to add the sitemaps it www.chapelradiocontrol.com/shop/sitemapindex.html it complained that it wasn't in the right place.

 

I had to add them to www.chapelradiocontrol.com/sitemapindex so decided to copy them.

 

My question is, is this ok as far as google is concerned, will it still crawl my site sucessfully?

 

Also, i see it's changed quite a bit since the release i installed.

 

What differences are there, and how easy is it to install the new one as there doesn't seem to be any instructions on how to remove a previous install and set the new one up

 

Thanks

 

Daz

Link to comment
Share on other sites

  • 2 weeks later...
  • 3 weeks later...

Just installed the latest version (2.1b) of this contrib, and I am having a problem. The products and categories XML files appear to be ok, and Google accepted them. However, my sitemapindex.xml file does not seem to be generating anything; it is practically blank, and Google does not like it:

 

<?xml version="1.0" encoding="UTF-8"?>
<sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.84">
</sitemapindex>

 

Any suggestions? I figure since all three files are generated, all three should be submitted to Google... correct?

 

Thanks,

-Mike

Link to comment
Share on other sites

Just installed the latest version (2.1b) of this contrib, and I am having a problem. The products and categories XML files appear to be ok, and Google accepted them. However, my sitemapindex.xml file does not seem to be generating anything; it is practically blank, and Google does not like it:

 

<?xml version="1.0" encoding="UTF-8"?>
<sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.84">
</sitemapindex>

 

Any suggestions? I figure since all three files are generated, all three should be submitted to Google... correct?

 

Thanks,

-Mike

 

Anyone figure the solution out for this, as I too am having the same issue...

Tony Mazz

Link to comment
Share on other sites

Hi All,

 

I had a problem with the categories file not working with ultimate SEO for categores below top level. I think I tracked down the problem and fixed it, but someone who's a bit more familiar with this contribution (and PHP) might want to cast their eye over it...

 

To save having to do comparisons, I've commented my changes pretty extensively.

 

Sorry for the long code snippet but I haven't worked out how to attach files in this forum yet.

 

Regards

HickoryDickory

 

<?php
/**
 * Google Sitemap Generator - Categories
 *
 * Script to generate a Google sitemap (categories) for osCommerce based stores
 *
 * @license http://opensource.org/licenses/gpl-license.php GNU Public License
 * @version 1.2
 * @link http://www.oscommerce-freelancers.com/ osCommerce-Freelancers
 * @copyright Copyright 2006, Bobby Easland
 * @author Bobby Easland	 
 * @filesource
 * modified to work for 2nd and lower level categories with Ultimate SEO 2.0b by Anton Juodvalkis, October 2006	 
 */

/*
 * Include the application_top.php script
 */
include_once('includes/application_top.php');

/*
 * Send the XML content header
 */
header('Content-Type: text/xml');

/*
 * Echo the XML out tag
 */
echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<?php

/*
 * Define the uniform node function
 */
function GenerateNode($data){
	$content = '';
	$content .= "\t" . '<url>' . "\n";
	$content .= "\t\t" . '<loc>'.trim($data['loc']).'</loc>' . "\n";
	$content .= "\t\t" . '<lastmod>'.trim($data['lastmod']).'</lastmod>' . "\n";
	$content .= "\t\t" . '<changefreq>'.trim($data['changefreq']).'</changefreq>' . "\n";
	$content .= "\t\t" . '<priority>'.trim($data['priority']).'</priority>' . "\n";
	$content .= "\t" . '</url>' . "\n";
	return $content;
} # end function

/*
 * Define the SQL for the categories query
 */
/*	$sql = "SELECT
				c.categories_id as cID,
				c.date_added as category_date_added,
				c.last_modified as category_last_mod,
				MAX(p.products_date_added) as products_date_added,
				MAX(p.products_last_modified) as products_last_mod
		FROM " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
			LEFT JOIN " . TABLE_PRODUCTS . " p
				ON (p2c.products_id = p.products_id)
		WHERE c.categories_id = p2c.categories_id
		GROUP BY cID
		ORDER BY
			category_date_added ASC,
			category_last_mod ASC,
			products_date_added ASC,
			products_last_mod ASC";

*/
//CUSTOMISATION BEGINS - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES
//FIND
//$sql = "SELECT categories_id as cID, date_added as category_date_added, last_modified as category_last_mod
//				FROM " . TABLE_CATEGORIES . "
//					ORDER BY parent_id ASC, sort_order ASC, categories_id ASC";
//REPLACE
$sql = "SELECT parent_id as ParID, categories_id as cID, date_added as category_date_added, last_modified as category_last_mod
			FROM " . TABLE_CATEGORIES . "
				ORDER BY parent_id ASC, sort_order ASC, categories_id ASC";
//CUSTOMISATION ENDS - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES					
/*
 * Execute the query
 */
$query = tep_db_query($sql);

/*
 * If there are returned rows...
 * Basic sanity check
 */
if ( tep_db_num_rows($query) > 0 ){
	/*
	 * Initialize the container
	 */
	$container = array();

//CUSTOMISATION BEGINS - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES					
//INSERT
$parentID = array();
//CUSTOMISATION ENDS - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES
	/*
	 * Loop query result and populate container
	 */
	while( $result = tep_db_fetch_array($query) ){
		$container[$result['cID']] = max( $result['category_date_added'],
																			$result['category_last_mod'],
																			$result['products_last_mod'],
																			$result['products_date_added']
																		 );

//CUSTOMISATION BEGINS  - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES
//INSERT																			 
  $parentID [$result['cID']] = $result['ParID'];
//CUSTOMISATION ENDS  - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES
	} # end while

	/*
	 * Free the resource...could be large
	 * ...clean as we go
	 */
	tep_db_free_result($query);

	/*
	 * Sort the container based on last mod date
	 */
	arsort($container);
} # end if

/*
 * Loop the result set
 * Basic sanity check
 */
if ( sizeof($container) > 0 ){
	$total = sizeof($container);
	$_total = $total;
	foreach( $container as $cID => $last_mod ){
//CUSTOMISATION BEGINS  - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES
//FIND
//			   $location = tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cID, 'NONSSL', false);
//REPLACE
  if ($parentID[$cID] == 0){
		   $location = tep_href_link(FILENAME_DEFAULT, 'cPath=' . $cID, 'NONSSL', false);
  } else {
		   $location = tep_href_link(FILENAME_DEFAULT, 'cPath=' . $parentID[$cID] . "_" . $cID, 'NONSSL', false);
  } # end if		
//CUSTOMISTION ENDS - XML SITEMAP FIX FOR LOWER LEVEL CATEGORIES

		$changefreq = 'weekly';
		$priority = max( number_format($_total/$total, 1, '.', ','), .1);
		$_total--;
		$container = array('loc' => htmlspecialchars(utf8_encode($location)),
											 'lastmod' => date ("Y-m-d", strtotime($last_mod)),
											 'changefreq' => $changefreq,
											 'priority' => $priority
											);
		/*
		 * Echo the generated node
		 */
		echo generateNode($container);
	} # end while
} # end if

/*
 * Close the urlset
 */
echo '</urlset>';

/*
 * Include the application_bottom.php script
 */
include_once('includes/application_bottom.php');
?>

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