Jump to content



Photo
- - - - -

Google XML Sitemap SEO


  • Please log in to reply
1367 replies to this topic

#1361   Roaddoctor

Roaddoctor
  • Members
  • 1,022 posts
  • Real Name:David Jennings
  • Gender:Not Telling
  • Location:Texas

Posted 16 June 2014 - 14:34

fixed - thank you!


-Dave

#1362   Jack_mcs

Jack_mcs
  • Members
  • 26,469 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 17 June 2014 - 00:28

A new version has been uploaded with these changes:

 

- Added code to set the last modified date if the date is 0. If this happens, it may mean there is a problem with the database.
- Added a bunch of files to the excludes list to prevent them from showing in the pages site map file.
- Added code to include reviews in the pages file.
- Changed code to handle the exclude list correctly.
- Changed mysql file so it works with newer versions of mysql.
- Removed extra showmanufacturers statement fron index.php - found by Melanie (mommaroodles ).



#1363   plazman65

plazman65
  • Members
  • 76 posts
  • Real Name:Michelle

Posted 11 July 2014 - 12:54

Hi! I have SPPC and Hidden Products installed. Does anyone know what changes I would need to make to exclude hidden products from showing up? Thanks for any help :)



#1364   RBA55

RBA55
  • Members
  • 9 posts
  • Real Name:Robin Bass

Posted 20 August 2014 - 11:04

My store has 2 languages, english and french. My admin is in english. The sitemaps are generated only in english. Is there a way to have sitemaps generated for both languages?



#1365   Jack_mcs

Jack_mcs
  • Members
  • 26,469 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 20 August 2014 - 13:41

There isn't an easy way. I started adding the code but never completed it. I think that if you change this line in googlesitemap/index.php

$languages_id = $lng->language['id'];

to this

$languages_id = XX;

where XX is the language ID of the other language, the files will be created in that language. This has to be done manually, of course, and the resulting sitemap files would have to be renamed since they would be overwritten when the other language is ran.



#1366   Roaddoctor

Roaddoctor
  • Members
  • 1,022 posts
  • Real Name:David Jennings
  • Gender:Not Telling
  • Location:Texas

Posted 20 August 2014 - 13:55

Hi! I have SPPC and Hidden Products installed. Does anyone know what changes I would need to make to exclude hidden products from showing up? Thanks for any help :)

 

you need to add

where p.products_status = '1'

or

WHERE c.categories_status = 1

at the appropriate places


-Dave

#1367   RBA55

RBA55
  • Members
  • 9 posts
  • Real Name:Robin Bass

Posted 20 August 2014 - 21:12

Thanks Jack, as I suspected. I'll take a look at the code myself and see if I can figure it out, just wanted to know if it had been done. I guess it's a good thing to do, no?



#1368   Jack_mcs

Jack_mcs
  • Members
  • 26,469 posts
  • Real Name:Jack York
  • Gender:Male
  • Location:Michigan

Posted 21 August 2014 - 00:14

As long as there is a link to the other language, like in a language box, the search engines will find the other url's. But the maps speeds that process up so they would help.


Edited by Jack_mcs, 21 August 2014 - 00:16.