Database Query...

[designwerks]

Jamie,

Can you tell me how to do a database query to show all inventory levels that are at zero?

Or does the tables "show all" display this?

Second, could a database query be written to show all inventory levels that are say 5 or less?

I'm not very good at database query...

John

[Jamie]

Hi John,

You should be able to get that info in the control panel:

1. Catalog > Products > Manage
2. Change "View" to "Products - with stock total"
3. Sort by the Total Stock column. Products with no stock will have that column blank

If you still need the queries let me know and I'll write them.

[designwerks]

Yes, your right...

I never think about the tables as much as I should!

Happy Thanksgiving (in Canada)!

[Jamie]

Happy Thanksgiving (in Canada)!

You too! We have a ways to go for our Thanksgiving in the US (11/24). Halloween is coming up soon. We will be going to Salem MA a few days before. It's about a 2 hour drive.