Quote Originally Posted by Dzy View Post
Hi,

I am using Stock by Attribute mod, which is great because its for a store selling clothing so it obviously needs different sizes. I don't want to show the total amount of stock but the amount of stock of each size and to not show the sizes that are out of stock. How do I do that? I can do PHP editting and some MySQL so if you could tell me how to fetch it/which tables (no phpMyAdmin here) that would be great!

Thanks
Provided size is the only attribute that you are using this can be done using the method that has been discussed several times already in this thread. I'm afraid I can't be more specific as I've never actually done it myself.

If you have multiple attributes then it gets a lot more complicated and you would need to use javascript to dynamically display (or not) the attribute combinations that visitors are choosing.

Which tables you need to access would depend upon the complexity of your store setup and which approach you wanted to take to display this reduced information. There is a schema for the product tables that would include all those that you are likely to need.