dunchutch Posted March 10, 2007 Share Posted March 10, 2007 Hi - could someone give me an idea what to use to create a sitemap for my osCommerce site? I have a front page and then the site is in a folder called 'store' if that makes any difference. thanks duncan Duncan Hutchinson Link to comment Share on other sites More sharing options...
Gameprodigy Posted March 10, 2007 Share Posted March 10, 2007 well there are two that I know of, one for your actual customers and one for search engines. This is the search engine one http://www.oscommerce.com/community/contributions,2076 this one is the user friendly one http://www.oscommerce.com/community/contributions,2208 this one i used Sitemap MS2 -2.3 by Onkel Flo as it did not require any other contributions to install. you can see a my my stores look Here if you want to see how it looks, i like this as it automatically creates itself as you add your products. I have not installed the SEO sitemap yet. Link to comment Share on other sites More sharing options...
dunchutch Posted March 10, 2007 Author Share Posted March 10, 2007 well there are two that I know of, one for your actual customers and one for search engines. This is the search engine one http://www.oscommerce.com/community/contributions,2076 this one is the user friendly one http://www.oscommerce.com/community/contributions,2208 this one i used Sitemap MS2 -2.3 by Onkel Flo as it did not require any other contributions to install. you can see a my my stores look Here if you want to see how it looks, i like this as it automatically creates itself as you add your products. I have not installed the SEO sitemap yet. Hi Gregg - just installed the user friendly one - it looks good but there seems to be an error on one part of it. I was wondering if you could have a quick look at my website - www.supplementsavers.co.uk/store and click on the sitemap ? It comes up with an error but i havent a clue how to solve it! thanks duncan Duncan Hutchinson Link to comment Share on other sites More sharing options...
Gameprodigy Posted March 10, 2007 Share Posted March 10, 2007 well i can tell you what it means the error is saying that your database named suppscou_os1 is supposed to have a table called Pages probably for some contribution you installed. The reason usually being that when you installed the contribution you didnt add the table to the database manually or by using an .sql file to create the table. The table can be created however I don't know the exact structure of the table. This part of the error s.pages_title, s.pages_html_text from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.sort_order > 0 order by p.sort_order, s.pages_title this all the structure that is missing because the Table Pages does not exist. did you install the SEO Sitemap to or any other contributions recently?? Link to comment Share on other sites More sharing options...
Gameprodigy Posted March 10, 2007 Share Posted March 10, 2007 by the way the reason your seeing the error now is because the sitemap automatically generates so when it go the point of finding the information related to whatever contribution this is for, bam the table isnt there so it pops out the error. looking at the table structure i would say this either a contribution to make pages load faster, or some sort of conversion for search engine optimization Link to comment Share on other sites More sharing options...
dunchutch Posted March 10, 2007 Author Share Posted March 10, 2007 by the way the reason your seeing the error now is because the sitemap automatically generates so when it go the point of finding the information related to whatever contribution this is for, bam the table isnt there so it pops out the error. looking at the table structure i would say this either a contribution to make pages load faster, or some sort of conversion for search engine optimization Hi - the only other contribution I have added is easypopulate - but I will try to work out whats gone wrong. Thanks so much for your help! duncan Duncan Hutchinson Link to comment Share on other sites More sharing options...
Gameprodigy Posted March 10, 2007 Share Posted March 10, 2007 I have easy populate and I do not have a table in the database with this name so it must be for something else. Did you install header tags contribution or anything. Link to comment Share on other sites More sharing options...
Kidz Toyz Posted March 11, 2007 Share Posted March 11, 2007 I think I may have a similar problem. If you look at the sitemap on my website it comes up with this error, where it should have shipping/privacy etc. 1146 - Table 'kidztoyz_org_uk_1.TABLE_PAGES' doesn't exist select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.sort_order > 0 order by p.sort_order, s.pages_title [TEP STOP] I wandered if it could be because my information pages are no longer in a box ( they're now in my footer bar). I've just asked about this in contribution support so if anyone comes up with a solution, I'll post it here! nikki Link to comment Share on other sites More sharing options...
Jack_mcs Posted March 11, 2007 Share Posted March 11, 2007 Hi - could someone give me an idea what to use to create a sitemap for my osCommerce site? I have a front page and then the site is in a folder called 'store' if that makes any difference. thanks duncan The SEO sitemap mentioned should not be used. It breaks google policy. There are two sitemaps you should install: google sitemap, which is just for google, and the Dynamic Sitemap, which is for you customers and the search engines. 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 More sharing options...
Kidz Toyz Posted March 11, 2007 Share Posted March 11, 2007 The SEO sitemap mentioned should not be used. It breaks google policy. There are two sitemaps you should install: google sitemap, which is just for google, and the Dynamic Sitemap, which is for you customers and the search engines. Jack Ok. I'll give one of those a go. Thanks :thumbsup: nikki Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.