Question: Clear Stock Of A Specific Warehouse

Clear Stock Of A Specific Warehouse

Hi there, I want to clear stock of a specific warehouse. How can i do that?

RH

Rafiqul Hasan

Asked

Hi there,

I want to clear stock of a specific warehouse. How can i do that?

  • MS

    Mian Saleem

    Answered

    Hello,

    There is no such option to clear stock of warehouse. You can only delete the warehouse, it will partially clear the products stock too.

    Thank you

  • RH

    Rafiqul Hasan

    Answered

    Will it remove all the sales reports?

  • RH

    Rafiqul Hasan

    Answered

    And will it affect the other warehouse?

  • MS

    Mian Saleem

    Answered

    Hello,

    No. It will not delete any sale or any other data except quantity data for the warehouse.

    Thank you

  • RH

    Rafiqul Hasan

    Answered

    Hi, i have removed a warehouse, but the stock is still there. How can I remove that?

  • MS

    Mian Saleem

    Answered

    May I know your version number? It is mention in the footer. Thanks

  • RH

    Rafiqul Hasan

    Answered

    (v3.4.37 )

  • RH

    Rafiqul Hasan

    Answered

    I have updated it to the latest version, but the problem is still there.

  • MS

    Mian Saleem

    Answered

    Hello,

    You will need to manually delete the product data from sma_warehouses_products table.

    -- replace X with the id of deleted warehouse
    DELETE FROM `sma_warehouses_products` WHERE `warehouse_id` = X; 
    

    Update to latest version won’t change any previous actions. But will only affect the future ones.

    Thank you

  • RH

    Rafiqul Hasan

    Answered

    Thank You.

  • Login to Reply