Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Google XML Sitemap SEO


Jack_mcs

Recommended Posts

  • 3 weeks later...

Hello @Jack_mcs

I have been having problems with the older version of xml so I have replaced all the files with your new version.

Do I need to delete the old files from phpMyadmin before I import the new sql?

Regards Shaun

Link to comment
Share on other sites

It has to be done by editing the database directly. That is usually done using the phpmyadmin program which most hosts have installed. You need to

- Select your database in phpmyadmin.

- Make a backup of your database (export tab).

- Select the configuration_group table.

- Find the Google XML line and note its ID. Then delete it from that table.

- Select the configuration table.

- In the sql tab, enter this command after changing the XX to the above ID you noted:

delete from configuration where configuration_group_id = XX

That should do it.

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

Thanks Jack I was able to delete the files stated, however the new sql has an error :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '. HTTPS_CATALOG_SERVER . '/googlesitemap/index.php" target="new" style="color:bl' at line 2

Regards

 

Link to comment
Share on other sites

Download the database file that wHiTeHaT provided above. I haven't had a chance to test it but I looked at the changes and they appear to be correct.

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

  • 3 weeks later...

Hi @Jack_mcs

Yes sorry, me again!

How can I check to see if XML is working?

When I go to http://YOUR_DOMAIN/googlesitemap/index.php, I get a bunch of files, all seem to look OK, and there is CONGRATULATIONS! All files generated successfully.

 

All of the below files again seem to generate my files

 

sitemapindex.xml

sitemapproducts.xml

sitemapcategories.xml

sitemapimages.xml

sitemappages.xml

 

However I am not seeing any traffic to my site.

I have also recently added a robots.txt file, does this look OK to you?  (I copied this from one of the forums on here although I have added and removed some items).

 

# Robots.txt

User-agent: *

Disallow: /download

Disallow: /includes

Disallow: /oscommerce-templates

Disallow: /pub

Disallow: /temp

Disallow: /view_counter_badbottrap

Disallow: /account.php

Disallow: /account_edit.php

Disallow: /account_edit_process.php

Disallow: /account_history.php

Disallow: /account_history_info.php

Disallow: /account_newsletters.php

Disallow: /account_notifications.php

Disallow: /account_password.php

Disallow: /add_checkout_success.php

Disallow: /address_book.php

Disallow: /address_book_process.php

Disallow: /addtocart.php

Disallow: /checkout_confirmation.php

Disallow: /checkout_payment.php

Disallow: /checkout_payment_address.php

Disallow: /checkout_paypalipn.php

Disallow: /checkout_process.php

Disallow: /checkout_shipping.php

Disallow: /checkout_shipping_address.php

Disallow: /checkout_success.php

Disallow: /cookie_usage.php

Disallow: /create_account.php

Disallow: /create_account_process.php

Disallow: /create_account_success.php

Disallow: /download.php

Disallow: /info_shopping_cart.php

Disallow: /login.php

Disallow: /logoff.php

Disallow: /password_forgotten.php

Disallow: /popup_coupon_help.php

Disallow: /popup_image.php

Disallow: /popup_search_help.php

Disallow: /product_notifications.php

Disallow: /redirect.php

Disallow: /shopping_cart.php

Disallow: /shopping_cart_help.php

Disallow: /tell_a_friend.php

Disallow: /quotes.php

Disallow: /quotes-closed.php

Disallow: /user.css

 

sitemap: https://www.retro-antiques-curios.co.uk/RAC_Shop/sitemapindex.xml

 

Any help will be much appreciated.

 

Regards Shaun

Edited by Shaun1d
Link to comment
Share on other sites

Having a sitemap on the site doesn't guarantee more traffic, though it usually will result in that. The best thing to do is to look in your google webmaster tools account. First, if you have added at least the sitemapindex.xml map to the account, you need to do that. Once you do look in the sitemap section to see if there are any errors and also look to see how many links have been processed.  Google won't list the links until they check them. On a busy, established, site that can be done in less than a day. On new or less-visited sites, it could be a month or more. Bing also has such a panel so you should check it too.  If it is god in google then it is probably good in Bing but they do check different things so it is best to look.

While in the above account, run the robots checker to see if any problems are reported. I see two below.

You shouldn't have these two items unless they actually exist on your site. It won't hurt to have them but it doesn't help either.

Disallow: /oscommerce-templates 
Disallow: /view_counter_badbottrap 

Also, any entry for a directory needs to end in a /, so disallow: /includes should be disallow: /includes/

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 thanks for that, I have now logged in to my original account.

I have now signed up for the Google web master account.

I ran the robots.txt checker and get this :

robots.txt fetch failed
You have a robots.txt file that we are currently unable to fetch. In such cases we stop crawling your site until we get hold of a robots.txt, or fall back to the last known good robots.txt file.
 
I removed the two entries and added a / after the includes entry as you suggested.
 
Is it worth cutting the robots.txt file right down?
 
I also attempt to add the sitemapindex.xml but it does not find it, I have checked and it is there.
 
Regards Shaun
 
 
Link to comment
Share on other sites

Be sure the account you are in is for your site (some shops have multiple accounts). Also, a link to your site can be https:// or http:// among others. Google calls these "properties". You have to be sure you are viewing the correct property in WMT or the result may not be accurate.

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 am soooo confused, exactly what properties does google want or need?

I know they want http & https, www and non www, but what else?

Is it just my main domain url, (retro-antiques-curios.co.uk)  or is it the full shop url, (retro-antiques-curios.co.uk/RAC_Shop) or both?

The robots.txt file and my shop folder are in my public_html folder, is this correct?

No matter what combination of properties I use, I am still getting this error message:

robots.txt fetch failed

You have a robots.txt file that we are currently unable to fetch. In such cases we stop crawling your site until we get hold of a robots.txt, or fall back to the last known good robots.txt file.

 

Without getting past my robots.txt file google will not crawl my site.

 

I even cut the robots.txt down to just the includes folder :

 

# Robots.txt

 

User-agent: *

Disallow: /includes/

 

But nothing, still the same error, what am I doing wrong?

I also have several google-site-verification codes, of two different numbers, how many should there be? do you get one for each property you set up?

I have tried following the help and tips on the google webmaster site, but these are too technical, is there an idiots guide?

I would rather not drop everything and spend a week trying to decipher the webmaster page, then still end up lost.

I have spent more time on this addon than I have all the rest of my addons put together, and am seriously wondering if it has just been a complete waste of time and effort on my part, not to mention wasting your time Jack!

Or do I just need a good slap around the face with a large wet slimy cod to bring me to my senses?

Link to comment
Share on other sites

When I visit your site, it loads. But when I try to view the robots file, it fails. This doesn't have anything to do with this addon. You've made some mistake in the robots file. You can uninstall this addon and the robots file would still fail. If the file is exactly as you posted it, then I don't know what might be causing it. See if there is an error_log file in the root of your shop and, if there is, look at it to see if there is mention of the robots file. If you can't figure it out, then you will need to ask your host to see why it is failing.

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

Fatal error: Cannot redeclare tep_session_is_registered() (previously declared in /home/user/public_html/includes/functions/sessions.php:120) in /home/user/public_html/googlesitemap/index.php on line 61

 

what could be the problem ? thank

Link to comment
Share on other sites

Please try this. In the googlesitemap/index.php file, change this line

if (defined('SEO_URLS') && SEO_URLS == 'true' || defined('SEO_ENABLED') && SEO_ENABLED == 'true' ) {

to

if (false) {

 

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

Sorry Jack, the reason sitemapindex page was not accessible seems to be due to a problem with my .htaccess file. When the .htaccess is removed https://www.retro-antiques-curios.co.uk/sitemapindex is accessible, however my site is then not redirected, so when I go to www.retro-antiques-curios.co.uk, I get the index of / page. The .htaccess file is also in my public_html folder, along with my shop and the robots.txt, along with a bunch of other files.

How do I get around this?

Link to comment
Share on other sites

I have had no joy in trying to get it all to work.

If I remove the last 5 lines, the robots.txt is seen, but then the homepage reverts back to the index of /

The .htaccess file is

RewriteEngine On
RewriteCond %{HTTPS} off [OR]
RewriteCond %{HTTP_HOST} !^www\. [NC]
RewriteRule ^(.*)$ https://www.retro-antiques-curios.co.uk/$1 [R=301,L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php?/$1 [L]
RewriteCond %{REQUEST_URI} !^/RAC_Shop [NC]
RewriteRule ^(.*)$ /RAC_Shop/$1

Any ideas?

 

Link to comment
Share on other sites

The lines are in pairs of rewritecond and rewriterule so if you are removing five lines, you are breaking a pair. Remove them in twos to test it.

Also, this problem is beyond the scope of this support thread since it doesn't have anything to do with the addon. That makes it difficult for those with addon-related problems to dins a solution. So please open a new thread in the general forum and we can continue there. You will also probably get more replies that way since not everyone will view this thread.

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

  • 4 weeks later...

Hi Jack,

Can it be that the SEO URLs when installed in oscommerce 2.3.4.1 Frozen, is blocking the Google SEO XML sitemap creation? I have several Oscommerce CE shops, only the ones with SEO URLs enabled fail to create the sitemaps. When disabled everything work great.

Link to comment
Share on other sites

It depends on what you mean by "SEO URLs". If you are referring to the Ultimate SEO addon, then it works fine with this one. See the post above regarding downloading an edited file. Depending upon your version of php, you may need that.
 

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

I have just set up a cron job through Cpanel, which seemed quite straight forward, however I have received an email error on first run :

/bin/sh: -c: line 0: syntax error near unexpected token `newline'
/bin/sh: -c: line 0: `<input name="textfield" type="text" value="php /retro-antiques-curios.co.uk/RAC_Shop/googlesitemap/index.php" size="50" />'

Any ideas?

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