Use the Data Assist wizard to create the Search, Results and Details pages.
for the search page setting, set it to Search the ProductSKU SKU column
after the pages are created, open the results page, and go to the Server Behaviors panel. Double Click the Data Assist Search server behavior. Edit the Criteria that was created by the wizard, and change it to a Key Word criteria type, and add the ProductName column to the selection of columns to search.