Hi
Do you also happen to know, is your website built on a custom platform or did they use some common/opensource, such as magento or oscommerce or others ? Also, do you have that type of "stock by attributes" system, where the stock is kept not at a product level, but at the attribute level (eg. color, size etc) ?
Regards
Dragos