Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[CONTRIBUTION] Google XML Sitemap Feed - by Chemo


Guest

Recommended Posts

hello, I'm a new member on this forum and I have a problem with this contribution. Everything seems to work fine but when I access the php file (googleSitemapCategories.php, googleSitemapManufacturers.php, googleSitemapProducts.php) it generates a XML feed but with some errors. Instead of <priority>0.1</priority> (0 dot 1) tag, the tag look like <priority>0,1</priority> (0 comma 1), invalid markup. It only appears at some 0.1 values (values above that are correct, with a dot).

 

http://www.hwshop.ro/googleSitemapProducts.php

http://www.hwshop.ro/googleSitemapCategories.php

http://www.hwshop.ro/googleSitemapManufacturers.php

 

 

Can anyone help me?

Link to comment
Share on other sites

  • 2 weeks later...

Hi,

 

First i must say, that those two contibutions: the Ultimate SEO and the Google Sitemap are grrrrreat!!!

I and thank you for them.

 

I have three Q's for both SEO and sitmap pulishing it here since its sort of combined...

would appriciate any info regarding...

 

*Google sitemap:

 

1. I have installed the "+admin" section version - how can i add the "Articals" to the site map? (have searched here but nada)

 

2. While QA'ing the XML files, I saw that the Products and Categories are not showing with there SEO urls but with their ID:

i.e:

http://www.jjudaica.com/index.php?cPath=21,

http://www.jjudaica.com/product_info.php?products_id=2

 

How can i change it to the SEO ones (with the names)?

 

3. Ultimate SEO: the add category name to base url option, doesnt work (its suppose to be together with the product while drilling down...)

 

Many Many Many thanks, to whom that might help.

 

Sharon.

Installed contributions:

Ultimate_SEO, Article Manager 1.5, Dynamic SiteMap 2.0, Infopages, Google SiteMap XMl w/admin 2.1, HeaderTagControler 2.6.1, FCKosc 2.21, X-sell 2.3, Google Analytics Modul, All Products, Page Cache 1.5, EasyPopulate2.7d, Multi Product Manager 2.5, Define Main Page, and probably few others...

Link to comment
Share on other sites

  • 4 weeks later...

hi ,i get this running the http://hellasfon.com/e-shop/googlesitemap/index.php

look at the urls in red .why is this happennig?there is a "/" missing .i find it very strange

 

the permissions are ok ,also in the googlesitemap directory

 

take a look at it please cause this is a great contribution

any comments would be thankfull

 

 

Warning: fopen(/home/###/public_html/e-shopsitemapproducts.xml) [function.fopen]: failed to open stream: Permission denied in /home/###/public_html/e-shop/googlesitemap/sitemap.class.php on line 291

ERROR: Google Product Sitemap Generation FAILED!

 

 

Warning: fopen(/home/####/public_html/e-shopsitemapcategories.xml) [function.fopen]: failed to open stream: Permission denied in /home/###/public_html/e-shop/googlesitemap/sitemap.class.php on line 291

ERROR: Google Category Sitemap Generation FAILED!

 

 

Warning: fopen(/home/###/public_html/e-shopsitemapindex.xml) [function.fopen]: failed to open stream: Permission denied in /home/###/public_html/e-shop/googlesitemap/sitemap.class.php on line 291

ERROR: Google Sitemap Index Generation FAILED!

 

Array

(

[QUERY] => Array

(

[PRODUCTS] => Array

(

[sTATUS] => success

[NUM_ROWS] => 52

)

 

[CATEOGRY] => Array

(

[sTATUS] => success

[NUM_ROWS] => 19

)

 

[sAVE_FILE_XML] => Array

(

[0] => Array

(

[file] => /home/##/public_html/e-shopsitemapproducts.xml

[status] => failure

[file_exists] => false

)

 

[1] => Array

(

[file] => /home/##/public_html/e-shopsitemapcategories.xml

[status] => failure

[file_exists] => false

)

 

[2] => Array

(

[file] => /home/##/public_html/e-shopsitemapindex.xml

[status] => failure

[file_exists] => false

)

 

)

 

)

Link to comment
Share on other sites

hi ,i get this running the http://hellasfon.com/e-shop/googlesitemap/index.php

look at the urls in red .why is this happennig?there is a "/" missing .i find it very strange

 

the permissions are ok ,also in the googlesitemap directory

 

Delete that contrib, and install the On The Fly one. That is MUCH easier and better.

 

Cheers,

Chris

Link to comment
Share on other sites

Hi Chris,

 

Sorry this took so long to get back to you.

 

We tried adding the suggested 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_last_modified DESC,

products_date_added DESC,

products_ordered DESC

LIMIT 0,49999";

 

 

But when we tried it we got this error:

 

 

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

 

 

--------------------------------------------------------------------------------

 

End tag 'head' does not match the start tag 'link'. Error processing resource 'http://www.tanglewoodcollection.com/googleSi...

 

</head>

--^

 

Looks like it should be a simple fix but I am knowledeable enough to do it.

 

Thanks.

 

Bill

Bill Broadbent

Custom Avenue

Link to comment
Share on other sites

Hi Chris,

 

Sorry this took so long to get back to you.

 

We tried adding the suggested 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_last_modified DESC,

products_date_added DESC,

products_ordered DESC

LIMIT 0,49999";

But when we tried it we got this error:

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

 

End tag 'head' does not match the start tag 'link'. Error processing resource 'http://www.tanglewoodcollection.com/googleSi...

 

</head>

--^

 

Looks like it should be a simple fix but I am knowledeable enough to do it.

 

Thanks.

 

Bill

 

Hey,

 

You REALLY should just scrap that contrib and install the on-the-fly one that Chemo did. It works HEAPS better, and already has the code for articles.

 

Get the contrib from here: http://www.oscommerce.com/community/contri.../search,sitemap

and from there install the latest one that I put there on the 13th July 2006.

 

Regards,

Chris

Link to comment
Share on other sites

  • 2 weeks later...

Hi Folks

 

Please can I ask for help/guidance with the following problem

 

I have my web site sat on a CCGI server and I have installed Google XML Sitemap Feed up to and including

Fixed categories below top level for Ultimate SEO 2.0b (IIS version) HickoryDickory

(including all higgalls contributions)

 

I can run the pages from the browser and they seem perfectly ok and work fine

 

I can get Google to verify the site but when I advise Google of the site maps after an hour or so it comes back and tells me

 

Redirect error: Redirect error

We encountered an error while trying to access your Sitemap. Please ensure your Sitemap follows our guidelines and can be accessed at the location you provided and then resubmit. [?] HTTP Error:

302 (Moved temporarily) [?]

 

I have checked the code (particularly the config files) and as far as I can tell everything is in order. The only thing I can turn up is by using the Xenu link sleuth

 

List of redirected URLs

 

http://ccgi.xxxx.com/catalog/

redirected to: http://ccgi.xxxx.com/catalog/cookie_usage.php

status code: 302 (object temporarily moved)

linked from page(s):

 

http://ccgi.xxxx.com/catalog/cookie_usage.php

redirected to: http://ccgi.xxxx.com/catalog/cookie_usage.php

status code: 302 (object temporarily moved)

linked from page(s):

http://ccgi.xxxx.com/catalog/

 

 

I have trawled this forum and Google but cannot get to grips with what Google dislikes about the pages

 

Any guidance would be sincerely appreciated

 

Thank you

 

Nossum

Link to comment
Share on other sites

Hi, I have done this

 

domain.com/directory/sitemapproducts.xml

domain.com/directory/sitemapcategories.xml

domain.com/directory/sitemapindex.xml

 

however I get the error:

 

The XML page cannot be displayed

Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.

 

 

--------------------------------------------------------------------------------

 

XML document must have a top level element. Error processing resource 'http://www.jemcraftmemories.com/shop/sitemapproducts...

 

Can someone help?

Link to comment
Share on other sites

Also if I try to access http://www.yourdomain.com/{directory?}/goo...temap/index.php

In my case it is http://www.jemcraftmemories.com/shop/googlesitemap/index.php

 

I get the error

500 Internal Server Error

 

 

 

The server encountered an internal error and was unable to complete your request.

 

Error message:

 

Premature end of script headers: /usr/home/jemcscom/public_html/shop/googlesitemap/index.php

Link to comment
Share on other sites

  • 3 weeks later...
After disabling the 'includes application_bottom.php', the contribution works very nicely ...

N

 

 

I install On The Fly version. I had the same problem with Lucky Beau. error message on line 1 number 60 . After disabling the 'includes application_bottom.php' It works.

Link to comment
Share on other sites

  • 2 weeks later...
This is probably a really dumb question, but can this same sitemap feed be used with Yahoo? I see that they also support an XML sitefeed system but I can't tell if this solution works for that purpose too.

 

I did a little research that indicates that Google, Yahoo, and MSN should all be using the XML schema defined by sitemaps.org. Looking at the output of the On The Fly version of this contribution, it appears that the Google schema is indeed the same as sitemaps.org. Is there any reason why the output of this contribution could not be changed to show <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> instead of <urlset xmlns="http://www.google.com/schemas/sitemap/0.84"> so that the same sitemap can be used with any search engine specifying the sitemaps.org format?

 

As a follow-up, what controls the priority number provided in the output for the categories and products?

Link to comment
Share on other sites

I was just about to install this but found out that I had be able to do cron jobs to update the file (which I cant) and on the install to "on the fly" version it says "Submit your site to google" where do I submit my site?

 

Are you talking about Webmaster Tools? Because I already submited my main page there and if I try to just submit the file for example http://www.domain.com/googleSitemapProducts.php It will just refuse to add it.

 

Anyways I uploaded all the "on the fly" files :)

Edited by Dennis_gull
Link to comment
Share on other sites

Hi,

I have a newb question, and I am sorry if this sounds stupid

 

I have SEO URLS 2.1d installed and working

Also have XML Sitemap 1.3 installed

 

I was getting the error with seo_cache so I got rid of that file as it said on this forum...

 

The question:

 

Are the sitemaps supposed to have the SEO Names as in:

 

http://my domain.com/travelpro-walkabout-20-inch-expandable-carry-on-suiter-p-36.html

 

or are the sitemaps just supposed to have this:

 

http://my domain.com/product_info.php?products_id=36

 

Does it matter?????

 

Thank You,

 

Brian

Link to comment
Share on other sites

It matters because google will search for the name in the xml, for example if you sell "King kong" with SEO google would find king kong in the XML. If you search for king kong without SEO in the xml you would get product_info.php?product_id=...... so google wouldn't find it from your xml file at least.

And yes the xml sitemap is supposed have SEO names. Try the "on the fly" version, it works for me at least. But I use SEO 2.0 (its not the same code though)

Link to comment
Share on other sites

I have installed the contrib and get a cosmetic error.

 

When I generate the sitemaps and when I try to notify google of my new sitemap I do get a 404 page not found error.

Yes I have uploaded all the files but I have translated the english to swedish if that matters..

 

Anyone have an idea why?

 

would be nice to get the correct page, the sitemaps are generated and I guess google is notified to.

 

Any ideas are welcome!

 

//Talle

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