Prevent Reordering of Discontinued Products

[MeTP]

I was wondering if anyone could advise me on how to prevent WooPOS from advising me to reorder products that have sales records but which I no longer want to carry in my store.  I know I can set the reorder quantity to zero (which would prevent them from being added by the first Auto-Add process, but they would still show up under the second Auto-Add process (“Calculate Expected Sales and Stock Requirement based on history sales and advanced formula”).

I thought perhaps I could mark them inactive but then it occurred to me that I still have some of these products in stock and still need to sell them, so marking them inactive isn’t an option.  I’m not quite sure what to do other than this.  Any help would be appreciated.

[Benjamin]

You can set re-order-point to zero for the discontinued products. Then add a SQL command at bottom of advanced stock requirement formula:

DELETE #AutoOrderItems where QtyReorderPoint=0

We can help to set up a more advanced formula based on your expected sales, this normally involves some custom works.

[MeTP]

Thanks Benny.  I think this will work.  Appreciate it.