View stock according to order status

  • Resolved joelhindson

    (@joelhindson)


    3 years, 3 months ago

    I’m trying to do a physical inventory check, but it is very difficult to do so because the total stock quantity shown in Woocommerce already includes the ‘Processing’ and ‘On-hold’ stock.

    Is there a workaround or a plugin or ANYTHING to enable a user to view the total stock ORDERED, but not yet completed or cancelled?

    It seems like a huge problem if I’m being honest – how is a shop with hundreds of products ever supposed to do a physicial inventory check if there are hundreds of pending orders at all times?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support mcampal – a11n

    (@mcampal)

    Hi there,

    I’m sorry to hear that you are experiencing issues while performing a physical inventory check.

    If I understand correctly, the items corresponding to ‘Processing’ and ‘On-Hold’ orders haven’t been reduced on your WooCommerce stock, making it harder to perform the inventory check.

    Note that by default, the stock should be reduced when an order is set to ‘Processing’ or ‘On-Hold’:

    – On hold — Awaiting payment – stock is reduced, but you need to confirm payment.
    – Processing — Payment received (paid) and stock has been reduced; order is awaiting fulfillment.

    Here you have more information regarding the different order’s statutes: Managing Orders

    When the stock is reduced, a note is included in the ‘Order notes’ section of the order’s edit page. Can you confirm if the stock is being reduced for orders set to ‘Processing’ and ‘On-Hold’ on your site?

    Best,

    Thread Starter joelhindson

    (@joelhindson)

    No, it’s not that. The stock IS reducing for Processing and On-Hold orders. What I am looking for is a way to view total stock quantity that is IN Processing/On-Hold status, as distinct from stock quantity physically available.

    The reason for this is that all Processing/On-Hold orders are still physically present in our inventory until the order is shipped out and completed. So if doing a stock-check when there are pending orders, the WooCommerce stock quantities are inaccurate. I need to be able to see the quantity of ‘Processing/On-hold’ stock AS WELL as the standard WooCommerce stock quantities, in order to be able to calculate total physical inventory.

    Hi there!

    I understand that you would like to find the stock for products only for Confirmed orders (not Processing or On-Hold), so you are able to do a physical inventory.

    The reason behind WooCommerce doing that is because multiple users wouldn’t be able to try purchasing the same unit of the product at the same time, so it’s already considered out of stock from the moment that the order is initiated.

    Still, I can understand your use case and how that would be relevant for you.

    I don’t see a specific plugin or solution that would allow that, but I was wondering if maybe you could try to export the product sales and add filters for completed orders?

    Apart from that, you could also have a custom code for doing what you want. We are not able to provide custom code, but you could use the following as reference: https://developer.woocommerce.com/

    Also, if you are not a developer, an option is also to check our customizations page with some partners that can help you doing such services for you: https://woocommerce.com/customizations/`

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘View stock according to order status’ is closed to new replies.