Quote Originally Posted by Ajeh View Post
If you want it as long as it is in the products table and don't care if when you delete the Product you cannot see the Product description and it just reading NOT FOUND vs Today's products_description then you can just use a quick look up ...
This one, totally.

We keep records of all orders in a separate inventory and accounting system (as only a small percentage of our orders come from our website). The thing that my coworkers are unhappy with is that our data feed (over which I have no control...damnit) has stupid, non-descript titles like "Cholestech Accessories" (this title is the same for at least 70 different products). I know, I know, it's clunky and awful. I would just fix the data feed myself, but it's too large to work with manually (60,000 products in our store). Sorry...that turned out to be more like whining than I intended. Thanks a lot for your response.