Hide archived/draft products from Month End Inventory Value Report

[S_P33]

Hey Folks, the month end inventory value report is counting archived and draft product inventory amounts, how can I hide/remove the archived and draft product amounts in the report?

Thanks

[mattsalsa · Accepted solution]

Hi there,

The best way I can think about filtering this out would be to apply a tag to all active products. The report is able to apply a filter for product tags like the one below:

Are you able to see this on your store?

[S_P33]

Perfect, I thought this was going to be daunting but with a couple clicks one can quickly add for example, the "active" tag by: selecting active tab on the product page, selecting all products, then add "x" tag to all selected products. Can rinse repeat for draft and archived products, thanks friend.

[MAD2017]

Let me understand you correctly, we (the customer) have to manually add a tag to all of our active products just so we can get an accurate report on our monthly-end inventory value?  I have over 10,129 products on this report and only 698 "active" products. I'm trying to sell my business while maintaining a busy retail storefront and Shopify wants me to do more work so I can pull a report?   I already need a magnifying glass to read most of the monthly reports and have used an incredible amount of printer ink for all the graphs that are unnecessary.  

Month-end inventory value