If you do not have an account in Webgains affiliate network create it.
Create a product feed.
Select the Programs, Categories, etc.
Copy the generated URL at the bottom of the page.
All products from datafeed will be added to local database of your site. Then, you can search products by keywords inside your local database.
If the feed does not load, make sure your memory limit value is larger than the size of the unzipped feed:
CE plugin will update local database one time per day automatically.
What will be if product is not existed after database update?
Stock status of product will be set as Out of Stock.
Recomended PHP extentions.
You should have next extensions on server (you can check them with your hosting provider):