How to Discontinue a Batch of Items

To discontinue a batch of items, they must first have their stock set to zero. Once that is done, a list of those items on an excel sheet must be imported in a format that sets them to discontinued.

First, go to Inventory > Inventory Adjustments and click the green plus to start a new one.

Then enter in all the items that are to be set as discontinued, set the new quantity to zero, and post it. For a larger batch of items, using a physical count worksheet with a count of zero for each item may be faster. More info on that can be found here: How to do a Physical Inventory

Then create an excel sheet and list the product IDs in the first column, under a header labeled “strProductID”. Then in the second column, label the header as “ysnDiscontinued”, and then put a “1” in those rows like the example below.

Once that has been completed, save the excel file. Then go to Inventory > Inventory Settings > Inventory Import

Then choose “Inventory”.

Then choose the file and select “Update existing Inventory only.”

After that, check a few items to ensure that they are marked as discontinued.