Out of stock report bug

  • Resolved silcarus

    (@silcarus)


    7 years, 9 months ago

    Hi,

    I had some products and made some orders for testing. I’ve deleted the orders and the products, but the report shows two out of stock products that don’t even have a name.

    stock report when management activated

    If I click on the pencil icon to edit the product, I got a message that says that what I’m trying to edit doesn’t exist and that it might have been deleted.

    All the testing products are now completely deleted but this happened even before I moved them to trash.

    If I deactivate the stock management option in Woocommerce settings, all I get is this:

    stock report when management deactivated

    I plan on keeping the stock management option deactivated and I all I want is the status box in the dashboard reporting I have 0 products out of stock instead of 2 “ghost” products. How can I remove them for good?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter silcarus

    (@silcarus)

    Is there no way to delete those two records?

    – check the bin, and if the products are in the bin, empty it

    – go to Dashboard > WooCommerce > System Status > Tools and click the two clear transients buttons

    – if the problem persists, you may need to edit the database. Back it up first. Go to the wp_posts table. Your products all have post_type = ‘product’, delete the two ghost ones.

    Thread Starter silcarus

    (@silcarus)

    I had already done the first option. I did the second, but no luck.
    I jumped to the database and looked for the products with post_type = ‘product’. There were 30, exactly the products I have in the store, everyone had their name, no ghosts.
    I went through the wp_postmeta table to look for the information related to the stocks and noticed that there were a couple of post IDs that were a low number, meaning they were old products. These IDs had post_type = ‘product_variation’, meta key ‘_stock_status’ and meta value ‘instock’, and meta key ‘_stock’ and meta value ‘0.000000’. I believe they were variations of a product that was no longer on the database.
    Anyway, thanks for your response, it led me to the solution.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Out of stock report bug’ is closed to new replies.