Product 'DRAFT' Status vs SOH Report

[Sianb22]

I'm looking for a report that will show me a products status (ie. Draft or Active) and it's current SOH. Naturally. anything with SOH we want set to active so it is visible to sell online however for a number of reasons some of our products have been drafted and I'd like to avoid having to check each individual item manually. Thanks

[levian211]

To get this report, go to your Shopify admin, then navigate to Products. From there, you can use the Export button to download a CSV file that contains all your product details. The exported file should have columns like "Status" (showing if the product is Active or Draft) and "Quantity" (which represents your Stock on Hand).

Once you have the file, you can open it in Excel or Google Sheets to filter the products that are "Draft" but still have stock, so you can update those to "Active" and make them visible for sale online

[BetterReports-K]

Hi @Sianb22,

Keanna here from Better Reports—just wanted to introduce you to our app, Better Reports, which could be a great solution for your reporting needs!

With Better Reports, you can create a custom report showing product status and stock on hand. We can filter it to identify products that have stock but are not active online, making it easier for you to identify and resolve these cases.

In addition to custom reports, Better Reports offers over 80 pre-built reports designed for common merchant needs, with options to schedule reports for automated delivery to your email or Google Drive, or export in CSV, Excel, HTML, or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?