Sales by category report – category won’t show if products are draft

  • Hi there,

    I’ve stumbled across an issue which I can repeat on multiple sites running WooCommerce.

    If all products in a category are draft (effectively causing the category to think it contains 0 products), the category is not an option to select in Woo > Reports > Sales by category

    The data is there for the draft products, as if you visit Woo > Reports > Sales by product, the data for the draft products will show there.

    Use case:

    – Accountant pulls monthly reports of Sales by category
    – Website makes products draft when no longer relevant, which may include all products in a category
    – This causes the entire category to be missing from the accountant’s Sales by category report

    Is it possible to change the Sales by category report to include the option to filter by categories even where it thinks the category has 0 products (as when all products are draft it is showing as if 0, even though there is reportable data).

    Thanks!!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Thu P. a11n

    (@thup90)

    Hi there,

    Instead of making products drafts, you could change the product’s Catalog visibility to Hidden, this won’t hide the product from the category. Screenshot: https://d.pr/i/9sXCI9

    Thread Starter pennipick

    (@pennipick)

    Hi, thanks for the fast reply. Unfortunately we’ve had custom work done (we integrate with FooEvents) to have tickets (products) set to draft at a set expiry date (24 hours before an event). So we need to see sales data for draft products.

    Also we need the product not available for purchase. My understanding is hidden means it isn’t listed, but you could still reach the product and purchase it if you had access to the URL.

    • This reply was modified 4 years, 10 months ago by pennipick.
    • This reply was modified 4 years, 10 months ago by pennipick.
    Plugin Support Thu P. a11n

    (@thup90)

    Hi there,

    You could possibly use a workaround by creating a dummy product that is hidden in the category, so the category still shows up under the report.

    To make a category that contains only draft products show up in the report, I’d suggest putting your suggestion to the Ideas board, it’s where our developers look for ideas to improve our products: https://ideas.woocommerce.com/forums/133476-woocommerce

    Thread Starter pennipick

    (@pennipick)

    Wouldn’t the dummy product be indexable, and be purchasable? It feels like a weird workaround for what is essentially missing functionality.

    I’d suggest this is a bug/error rather than an upgrade. The data is there, you just can’t select a category if all products are draft. Is there any way to get this is to be looked at, as I’d hope it’s a pretty simple tweak that probably affects anyone who expires products by making them draft.

    • This reply was modified 4 years, 10 months ago by pennipick.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Sales by category report – category won’t show if products are draft’ is closed to new replies.