Jump to content


Corporate Sponsors


Latest News: (loading..)

NodsDorf

Member Since 21 Aug 2004
Online Last Active Today, 00:43
*****

Topics I've Started

Where & How To Fix Google Fetching Non-Existing Pages

04 May 2012, 10:53

So I ran into Google Fetching 2 types of pages that shouldn't exist on our site, but appear to actually exist. I have no idea how google actually found them but I need to fix them as they serve no purpose.

The first one (not fixed) they are trying crawl is products that don't exist like...
catalog/productsname-p-2892.html

Which is serving a page, but not its the product_info.php product not found error. Shouldn't this be directed to 404 ?



The other one I think I fixed was the products_reviews.php page. We don't use them and removed all out buttons and links to them but somehow Google still found them and was dinging us for duplicate title tags.

Since I was running URL re-writer
# Begin Ultimate SEO V2.2d
Options +FollowSymLinks
RewriteEngine On

  # RewriteBase instructions
  # Change RewriteBase dependent on how your shop is accessed as below.
  # http://www.mysite.com = RewriteBase /
  # http://www.mysite.com/catalog/ = RewriteBase /catalog/  
  # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/

  # Change the following line using the instructions above  
 
RewriteBase /catalog/

RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}
RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING}
RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING}
#RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING}
# End Ultimate SEO V2.2d
I just commented out the following line..
#RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
Then added
ErrorDocument 404 /catalog/404.php

Which I just made by cloning the shipping.php page and naming it 404.php adding filename define and language info 404 page. That seemed to work now all product_reviews.php are sent to 404.php page.

But I can use some help fixing the pages being served for products that don't exist. Right now Google is seeing them as Soft 404, is there a way to send them all to our 404.php page?

Any help is appreciated.

Thank you

Can somebody check this SQL drawing a blank...

03 May 2012, 15:59

SELECT p.products_id,p.products_model,p.products_ordered, count(op.orders_products_id) AS Sales
 from products as p
INNER JOIN orders_products as op ON p.products_id=op.orders_products_id
where p.products_ordered >0 and p.products_model LIKE 'B%' ORDER BY p.products_ordered DESC

Just trying to see how many orders for these products have been placed. Not the total sold just unique orders...
products_id products_model products_ordered Sales NULL NULL NULL 0

Statement executes but no results which can't be correct.

I'm sure I'm missing something basic..

Any help is appreciated.

drawing a blank on a 301 redirect

13 April 2012, 00:24

Trying to just redirect an old product to a new product.

Old url
/catalog/neoprene-multi-convoluted-rubber-bellow-290mm-40mm-connector-48mm-p-8213.html

New url
/catalog/neoprene-multi-convoluted-rubber-bellow-290mm-40mm-connector-48mm-p-9280.html

My .htaccess method...
Redirect 301 /catalog/neoprene-multi-convoluted-rubber-bellow-290mm-40mm-connector-48mm-p-8213.html   http://www.OURSITE.com/catalog/neoprene-multi-convoluted-rubber-bellow-290mm-40mm-connector-48mm-p-9280.html

My Result
What I'm getting is the new url with the Product ID appended..
catalog/neoprene-multi-convoluted-rubber-bellow-290mm-40mm-connector-48mm-p-9280.html?products_id=8213

We are running Ultimate SEO V2.2d which also has the following in .htaccess
and I am assuming it is causing the conflict because I'm doing it wrong...

# Begin Ultimate SEO V2.2d
Options +FollowSymLinks
RewriteEngine On

  # RewriteBase instructions
  # Change RewriteBase dependent on how your shop is accessed as below.
  # http://www.mysite.com = RewriteBase /
  # http://www.mysite.com/catalog/ = RewriteBase /catalog/  
  # http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/

  # Change the following line using the instructions above  
 
RewriteBase /catalog/

RewriteRule ^(.*)-p-(.*).html$ product_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-c-(.*).html$ index.php?cPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-m-(.*).html$ index.php?manufacturers_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pi-(.*).html$ popup_image.php?pID=$2&%{QUERY_STRING}
RewriteRule ^(.*)-by-(.*).html$ all-products.php?fl=$2&%{QUERY_STRING}
RewriteRule ^(.*)-t-(.*).html$ articles.php?tPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-a-(.*).html$ article_info.php?articles_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-au-(.*).html$ articles.php?authors_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pr-(.*).html$ product_reviews.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pri-(.*).html$ product_reviews_info.php?products_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-f-(.*).html$ faqdesk_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fc-(.*).html$ faqdesk_index.php?faqPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fri-(.*).html$ faqdesk_reviews_info.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-fra-(.*).html$ faqdesk_reviews_article.php?faqdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-i-(.*).html$ information.php?info_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-links-(.*).html$ links.php?lPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-pm-([0-9]+).html$ info_pages.php?pages_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-n-(.*).html$ newsdesk_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nc-(.*).html$ newsdesk_index.php?newsPath=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nri-(.*).html$ newsdesk_reviews_info.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-nra-(.*).html$ newsdesk_reviews_article.php?newsdesk_id=$2&%{QUERY_STRING}
RewriteRule ^(.*)-po-([0-9]+).html$ pollbooth.php?pollid=$2&%{QUERY_STRING}
# End Ultimate SEO V2.2d


Anybody able to help me with the correct way to do an old product ID to a new one?
Thank you.

Commercial UPS addons or better ones at least?

28 March 2012, 17:08

Looking for the following features:
1.) Once a package ships the tracking number and details become available to the customer automatically.
-Like Amazon.com does.. "click to track" which returns the UPS information they would normally serve on their website
2.) Option to allow a business to "bill to their account" require UPS number, verify, then remove shipping cost add but still charge flat handling fee for packaging materials.

If you know a way to accomplish one or both of these requirements if they are free please provide a link, google gave me no love.

If they are commercial solutions please PM the info.

Thank you

Anybody else see the Google Analytic Live View Beta Thingy?

28 March 2012, 00:31

I know its not directly related to Osc but this tool is really impressive. I'd be nice to have that integrated into the Osc who's online page. :)

Log into your GA account and hit the home tab then hit the live view (beta) in the left navigation. Pretty neat.