PHP SQL search bug fix

Hello

We run a ecom website delivering frozen food to customers in and around the uk.

Our inventory store has a few bugs we need to repair.

Bug Scenario:

In Seller admin panel, when a seller searches for their own products in their inventory, it will return other products listed with the same search keyword in their search results from other sellers.

Example:

Seller A searches for Fish in their store.

Results will return products with keyword 'fish' from seller B.

Seller A can only search for products listed by seller A.

This search fix needs to be automatically in place for when NEW sellers register on the store.

Thank you