How to refine search in Big Commerce when looking for a pipe. What is re-creatable and what is sold. What can I sell my customer.

You can add these filters on top to remove all of the items that are not re-creatable:

If it has an image that says “SOLD” then it’s not recreatable, re-creatable pieces get their own image, like this: