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