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

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

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

To start, you have to Export your Stocks. Go to Back Office 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

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



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



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



Click the dropdown under Qty.



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



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.



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



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



All the negative numbers under Qty will turn to positive.



Save your file then go to Back Office to import your file.

Select Item Stocks under Inventory Management then click Import.



Select Browse and upload your file and click OK.



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

Was this article helpful?
Cancel
Thank you!