I don't think I realized until recently that you have to mark items inactive AND mark the SKU inactive for something to be completely inactive. Ok, fine. I can create a query to pull all inactive merchandise items, but I can't find a way to indicate in the report whether or not the SKU is active.
I need to find where we've been inconsistent since some items are active with an inactive SKU and vice versa.
(Does anyone ever look this long forgotten Altru category of merchandise?)