Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

Did not get this error when installing. I realized I was not getting my cron email because I had my cron set up wrong by accident (lack of sleep). So I pointed by browser to the /googlesitemap/index.php file manually that the cron points too. Here is what I got. Top of the page says error. Maybe its nothing Im not sure just wanted to find out.

It looks like your products site map is not being created for some reason. Be sure the sitemapproducts.xml file exists on the server and that it has the correct permissions settings. Also check to make sure that the other files are being updated, just to be sure there isn't some other problem.

 

Jack

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

Everything else is updating fine except for the products. Permissions were wrong but even after I fixed the permissions it still returns the error on /googlesitemap/index.php and products do not update. It did however function correctly and update upon installation.

Link to comment
Share on other sites

Hmm, that's a strange one and I can't think of anything that would cause it. But if it did work at one point, then something must have changed to cause it to fail so all I can suggest is that you review whatever changes were made since it was initially installed.

 

Jack

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

Well nothing I have tried works. I tried fresh files. Tried using the alternate class though I knew that was not what was going on but I tried it anyway.

 

The only thing I think I've added since this mod is Header Tags, Links Manager II, and Store Open/Closed/Maintenance. I don't see how adding new stuff would effect Google sitemap anyway though cause it does not edit any files.

Link to comment
Share on other sites

Well nothing I have tried works. I tried fresh files. Tried using the alternate class though I knew that was not what was going on but I tried it anyway.

 

The only thing I think I've added since this mod is Header Tags, Links Manager II, and Store Open/Closed/Maintenance. I don't see how adding new stuff would effect Google sitemap anyway though cause it does not edit any files.

 

Any other avenues you can think of I should approach?

Link to comment
Share on other sites

Jack,

 

i just noticed that there is a sitemap on my website after so many weeks. haha..... well, here it is (located under the information box labeled as "BOX_INFORMATION_SITEMAP_SEO") here's a screenshot.

3369504852_351be93148_o.jpg

 

 

 

but then when u click on it, this is what it shows (with errors) :

3368679455_30df4d12bb_o.jpg

Link to comment
Share on other sites

i check /includes/functions/sitemap.php as per the error, this is what i get

 

line 25 : if (GetFilesArray($path, &$lines))

line 132 : if (GetFilesArray($path, &$lines))

 

may i know whats wrong with this 2 lines?

Edited by uniquexme
Link to comment
Share on other sites

Jack, may i ask where shd i get help on this pls?

The support thread is listed on the contribution page as well as in the documentation.

 

Jack

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

Hi Jack, installed the contrib all appears fine except the following error on submission, ! Line Status Details

3 URL not allowed

This url is not allowed for a Sitemap at this location. Help URL:

Problem detected on: http://www.doorsteppetfood.co.ukDIR_WS...C...-15kg-p-47.html

Mar 20, 2009

9 URL not allowed

This url is not allowed for a Sitemap at this location. Help URL:

Problem detected on: http://www.doorsteppetfood.co.ukDIR_WS_HTT...gear-p-198.html

Mar 20, 2009

Line Status Details

Can you point me where to look to correct,

 

Thanks again

Link to comment
Share on other sites

I currently have the "Ultimate Seo Urls v2.6 (18 Aug 2008) + bug fix Full package" installed... should I downgrade the version I have to your 2.1d so that Google like my sitemaps?

 

And if so should I just follow the upgrade process for 2.1x as documented in install file?

 

Andy

 

 

 

It is probably due to your version of Ultimate SEO. Try installing the 2.1d version I uploaded.

 

Jack

Link to comment
Share on other sites

Hi Jack, installed the contrib all appears fine except the following error on submission, ! Line Status Details

3 URL not allowed

This url is not allowed for a Sitemap at this location. Help URL:

http://www.doorsteppetfood.co.ukDIR_WS...C...-15kg-p-47.html[/url]

http://www.doorsteppetfood.co.ukDIR_WS_HTT...gear-p-198.html[/url]

The capital letters in the link, DIE_WS..., indicate an improperly setup configure file. You should post your confiugre file, without the login data, in a new thread in the general forum (it will be ignored here), state the problem and someone should help with it.

 

Jack

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 currently have the "Ultimate Seo Urls v2.6 (18 Aug 2008) + bug fix Full package" installed... should I downgrade the version I have to your 2.1d so that Google like my sitemaps?

 

And if so should I just follow the upgrade process for 2.1x as documented in install file?

 

Andy

If the links in your sitemap are not correct, then, yes, you should. It is a simple change of one file so it is an easy test to see if it makes a difference.

 

Jack

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

Google is reporting priority errors to all urls

 

All the URLs in your Sitemap have the same priority.

All the URLs in your Sitemap are set to the same priority (not the default priority). Priority indicates the importance of a particular URL relative to other URLs on your site, and doesn't impact your site's performance in search results. If all URLs have the same priority, Google can't tell which are more important.

can someone advise if there is a default priority that should set somewhere

(not the default priority)

New osCommerce Learner

Old & Slow

Link to comment
Share on other sites

What sitemap are they referring to? Have you looked in the sitemap file to see if they are all the same? If it is the products sitemap and they are all the same, then it is probably because they products were all modified at the same time. Try modiying a few of them and re-running the script.

 

Jack

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 Everyone and Jack,

 

Our webiste is little different then most, and we would like to change the priority setting to use "Products Viewed" (like the products viewed report value) rather then "Products Ordered". Although I can code a little, I am not that great at it. Would someone help with this please? I don't want mess up the function GenerateProductsSitemap. I know this is where the change needs to take place, just could really use some help.

 

Thank you,

Jon

Link to comment
Share on other sites

Hello Everyone and Jack,

 

Our webiste is little different then most, and we would like to change the priority setting to use "Products Viewed" (like the products viewed report value) rather then "Products Ordered". Although I can code a little, I am not that great at it. Would someone help with this please? I don't want mess up the function GenerateProductsSitemap. I know this is where the change needs to take place, just could really use some help.

 

Thank you,

Jon

In the sitemap_class.php file, change this code

		$sql = "SELECT products_id as pID, products_date_added as date_added, products_last_modified as last_mod, products_ordered
			FROM " . TABLE_PRODUCTS . " 
			WHERE products_status='1' 
			ORDER BY products_ordered DESC";

to this

		$sql = "SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered, pd.products_viewed as viewed
			FROM " . TABLE_PRODUCTS . " p left join " .
			   TABLE_PRODUCTS_DESCRIPTION . " pd on (p.products_id = pd.products_id  
			WHERE products_status='1' 
			ORDER BY products_ordered DESC";

and this line

$lastmod = $this->NotNull($result['last_mod']) ? $result['last_mod'] : $result['date_added'];

to this

$lastmod = $this->NotNull($result['viewed']) ? $result['viewed'] : $result['date_added'];

 

I haven't tested the above but it should be close to what you need.

 

Jack

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,

 

Thank you for your help. I made a couple of other changes because I am getting an error. Would you take a look at the function below and see if you can see what is wrong please?

 

Thanks Again!

Jon

 

	function GenerateProductSitemap(){
       $sql = "SELECT p.products_id as pID, p.products_date_added as date_added, p.products_last_modified as last_mod, p.products_ordered, pd.products_viewed as viewed
       FROM " . TABLE_PRODUCTS . " p left join " .
       TABLE_PRODUCTS_DESCRIPTION . " pd on (p.products_id = pd.products_id  
       WHERE p.products_status='1' 
       ORDER BY p.products_viewed DESC";
	if ( $products_query = $this->DB->Query($sql) ){
		$this->debug['QUERY']['PRODUCTS']['STATUS'] = 'success';
		$this->debug['QUERY']['PRODUCTS']['NUM_ROWS'] = $this->DB->NumRows($products_query);
		$container = array();
		$number = 0;
		$top = 0;
		while( $result = $this->DB->FetchArray($products_query) ){
			$top = max($top, $result['viewed']);
			$location = $this->hrefLink(FILENAME_PRODUCT_INFO, 'p.products_id=' . $result['pID'], 'NONSSL', false);
			$lastmod = $this->NotNull($result['viewed']) ? $result['viewed'] : $result['date_added'];
			$changefreq = GOOGLE_SITEMAP_PROD_CHANGE_FREQ;
			$ratio = $top > 0 ? $result['viewed']/$top : 0;
			$priority = $ratio < .1 ? .1 : number_format($ratio, 1, '.', ''); 

			$container[] = array('loc' => htmlspecialchars(utf8_encode($location)),
			                     'lastmod' => date ("Y-m-d", strtotime($lastmod)),
								 'changefreq' => $changefreq,
								 'priority' => $priority
			                     );
			if ( sizeof($container) >= 50000 ){
				$type = $number == 0 ? 'products' : 'products' . $number;
				$this->GenerateSitemap($container, $type);
				$container = array();
				$number++;
			}
		} # end while
		$this->DB->Free($products_query);			
		if ( sizeof($container) > 1 ) {
			$type = $number == 0 ? 'products' : 'products' . $number;
			return $this->GenerateSitemap($container, $type);
		} # end if			
	} else {
		$this->debug['QUERY']['PRODUCTS']['STATUS'] = 'false';
		$this->debug['QUERY']['PRODUCTS']['NUM_ROWS'] = '0';
	}
} # end function

Edited by projman
Link to comment
Share on other sites

Jack,

 

Here is the error I am getting. Sorry I forgot to list it with the last reply:

 

ERROR: Google Product Sitemap Generation FAILED!

Write /sitemapcategories.xmlGenerated Google Category Sitemap Successfully

Write /sitemapspecials.xmlGenerated Google Specials Sitemap Successfully

Write /sitemapindex.xmlGenerated Google Sitemap Index Successfully

Array

(

[QUERY] => Array

(

[PRODUCTS] => Array

(

[sTATUS] => false

[NUM_ROWS] => 0

)

 

[CATEOGRY] => Array

(

[sTATUS] => success

[NUM_ROWS] => 64

)

 

[sPECIALS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 24

)

 

)

 

[sAVE_FILE_XML] => Array

(

[0] => Array

(

[file] => /sitemapcategories.xml

[status] => success

[file_exists] => true

)

 

[1] => Array

(

[file] => /sitemapspecials.xml

[status] => success

[file_exists] => true

)

 

[2] => Array

(

[file] => /sitemapindex.xml

[status] => success

[file_exists] => true

)

)

)

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