Can a LARGE function ignore returning a value of zero and move to the next largest (which may be negative?)

Question

I have a function in cell P25:

=LARGE(D:D,8)

This would find, as anticipated, the eighth largest number. However, in this case I am returning zero (because some cells can have a zero value) and zero just happens to be the eighth largest number in this case.

I would, for all of the LARGE functions, ignore any zero value and print the next highest instead. In this case, the next highest would be a negative number. But also, this number is more valuable than zero as this is a product with some stock. All zero values are products that are completely removed from stock but I do not want them removed from the list as they're still important.

My cell adjacent looks for that "LARGE" number in P25 and prints the product name.

=INDEX(A:A,MATCH(LARGE(D:D,8),D:D,0))

So when P25 finds a negative number, I will need O25 to find the cell that has that value and print the respective product.

TIA.