> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://doc.kahero.co/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How To Reset Item Stocks

Most common question regarding stocks is "how can we turn all our negative stocks to positive or into 0".

_${color}[#f40101](Note): The reason why you have negative stocks is when you check the box of "Allow Negative Stock" of the **Warehouse Settings** under **General Settings**._

![Allow Negative Stock](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/f11_hjx6jt.png)

# How to reset or turn your negative stocks to zero (0).

To start, you have to **Export** your **Stocks**. Go to [Back Office](https://app.kahero.co/) and login your account.

Click **Item Stocks** under **Inventory Management** and select the warehouse where you want to update your stocks.

![Inventory Management > Item Stocks](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/f21_1e6ioll.png)

Click **Export**, you will update your stocks using **Excel**. Once done exporting, open the file.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/f31_123eyt8.png)

The below is a sample of having Items with negative stocks. 

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-19-_19nxe6x.png)

Select row **1** then click **Filter** or use shortcut **CRTL+Shift+L**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-19-_wvaqei.png)

Click the dropdown under **Qty**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-19-_ohhm1c.png)

Unselect all and input negative sign (-) on the box, then click **OK**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_1cmt1qj.png)

This is to show all your stocks items that only have negative quantities, like the sample below.

Drag or select all then copy and paste it to a new spreadsheet.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_rsihlh.png)

Once done, select column **D**, then click **Find & Replace** or use shortcut **CTRL+H**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_1isqp8t.png)

Input negative sign **(-)** in find, and click **Replace All**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_17kp3s9.png)

All the negative numbers under **Qty** will turn to positive. 

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_8q20yq.png)

Save your file then go to  [Back Office](https://app.kahero.co/) to import your file.

Select **Item Stocks** under **Inventory Management** then click **Import**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_1highwv.png)

Select **Browse** and upload your file and click **OK**.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_1hxm0go.png)

When done importing all your negative stocks on hand will reset back to zero **(0)**, like the sample below.

![](https://storage.crisp.chat/users/helpdesk/website/fea84a7e8a4bd000/screenshot-from-2021-12-20-20-_2xgmcm.png)