The category is id the master_categories_id of your product. Be sure this field is set correctly in the products table. (If it's a linked product, it may not be what you think it is.)

http://www.thatsoftwareguy.com/zenca...ry_issues.html