Dacs

Thanks, so are you saying that if we don't use 'Sale', but something like 'ForSale' we shouldn't have the issue...

hi I download the database and import into my own SQL server so I can produce reports etc from the 'shop' Recently, I have noticed that NOT ALL products appear with ALL of their category id's. eg. from time to time we add a sale category (make it a visible Category) to some items - when this is done, the shop shows those items if we select 'Sale' category but it is not in the Category index table... The category appears as selected for the product but does not appear in the Category index table. So, where can I find the definitive list of categories used for a product. As the product displays the 'missing' category, where is it getting that from? Am I missing the point of the Category_index table? Is it possible to recreate the Category index table? if so, how. Regards