sold out items

[Guest]

I'm using a plugin that displays sold items. It grays out the add to cart and the items are in the Sold Items category. Its wonderful but there's one thing the client noticed that I need to fix: The items should *only* show in the Sold Items category. The items shouldn't show on the main page, product pages, New Item sidebar, or anywhere else.

 

What I do know: I should be able to change the sql query to select all where category id does not equal the sold out category id

 

What I don't know: The exact syntax to add that. What the category id is for that category. Or all the files that need to be updated to accomplish this.

 

Any help for any part of this would be greatly appreciated.

 

Thanks in advance.

 

~jack

[Atrosh]

What you should do is log in on your phpmyadmin and look from there.. probably something like

SELECT * FROM categories c
INNER JOIN categories_description cd
ON c.categories_id = cd.categories_id
WHERE cd.categories_name = 'NAME_OF_THE_CATEGORY'

I'm not home at the moment so I can't check if that is correct but it should be something like that. Anyway, look around in your phpmyadmin (usually accessible from the admin page of your webhost).

 

Edit: I just remembered the simplest way to check the id of a category.. Just browse to the category you want and it should be apparent in the cPath what the category ID of the current category is!