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.

    ```sql
    -- 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