.htaccess Error?? - Products not showing up!

[doj464]

Hi Guys,

I just uploaded a .htaccess file to my clients site - www.westerndrugmedical.com, and it somehow completely wrecked the site. I removed the .htaccess file, and it's still all messed up.

I asked one of my web design partners about it, and he suggested that they are using a mod-rewrite from within the site.

I've got all of the database information, and I think it's possible to manually rewrite all of the product and category names, but I'd love some help from the community in fixing it up.

I'm not a programmer/developer by trade, just an SEO/SEM guy.

The cart I'm using is Squirrel Cart, and they have a pretty complex way of relating numerous databases, which is getting me lost.

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

The URL's that got rewritten on the site that don't work.

http://www.westerndrugmedical.com/Ba...-Equipment.php

This is a category URL that's already been rewritten.

There's also a rewritten product URL:

http://www.westerndrugmedical.com/50...on=show_detail

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

The ones that are in their "Pre SEO URL" state.

Category ??

Bath safety products, shower chairs, tub bars, transfer benches

This one works fine. So CRN stands for Category record number

Product

Guardian Easy Care Folding Walker

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

Databases:

1) There's a table called products with SEO'd URL's.

The product base has the following (relevant) columns:
record number
SEO URL (which contains the optimized URL)

2) There's a table with categories as well that has the SEO'd URL's.

3) There's a database tying the back the sub-categories to parent categories, and the products to the relevant categories.

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

I was thinking of creating a .htaccess file that redirects the original URL to the correct one by stringing the databases together in access, exporting it to excel, and concatenating everything...

but it's a bit over my head. Of course, all help would be appreciated. Hehe, if I could find the original settings, I would be a really happy man.

David

[imvain2]

I don't know the exact database structure, but that seems like over complicating things.

Have you tried doing the below for the products:

RewriteRule ^product/([\d\/]+)/([\d\/]+)/(.*) /store.php?crn=$1&rn=$2&action=show_detail [L,I]

so
http ://www.westerndrugmedical.com/store.php?crn=210&rn=389&action=show_detail

would become:

http ://www.westerndrugmedical.com/product/210/389/Guardian_Easy_Care_Folding_Walker

[SemAdvance]

I checked the site and the urls are fine....If I were you I'd leave things alone less you destroy the site and lose the client......

the last person to access about server routines is a designer....that would be like asking me to design a site

LOL
LOL
LOL

I'm actually great at stickman design ;->

[imvain2]

Actually I'm not a designer, and no the links don't work.

If the links worked, he wouldn't be posting and the beriatric link takes you to the home page and not the correct page.

So do all of the htaccessed' URLs not work, or just a few?

[edhan]

I have just tested the site, everything seems to be working fine. I am able to see the products and going through the shopping cart to checkout.

[Bernd]

Originally Posted by doj464

I removed the .htaccess file, and it's still all messed up.

Next time clear your browsercache and check whether the serverside software has a caching-function too. A SEO should know this.