How are the product search results configured and can they be tweaked to include info that is in the product description in addition to the product name (i.e. author name in addition to book title)?

If you open up stored procedure "Smith_ListproductByFilter" and add the filter condition highlighted in yellow below it will search on product description:

ALTER procedure [dbo].[dnn_Smith_ListproductByFilter]
@Page int,
@RecsPerPage int,
@Filter varchar(50),
@searchText varchar(50) ,
@tabModuleId int,
@PortalId int
as

CREATE TABLE #TempItems
(
ProductAutoID int IDENTITY,
ProductID int
)
DECLARE @SearchSQL varchar(5000)

IF(@Filter='All')
SELECT @SearchSQL ='INSERT INTO #TempItems (ProductID) select p.ProductID from dnn_Smith_Products p
WHERE ( p.TabModuleId = ' + CAST ( @tabModuleId AS VARCHAR(10)) + ' OR p.Share = 1 ) AND p.modelName LIKE ''%'+ @searchText+'%'''
ELSE
SELECT @SearchSQL ='INSERT INTO #TempItems (ProductID) SELECT p.ProductID from dnn_Smith_Products p inner join '+
' dnn_Smith_CategoryProduct c ON '+
' c.ProductID=p.ProductID WHERE ( p.TabModuleId = ' + CAST ( @tabModuleId AS VARCHAR(10)) + ' OR p.Share = 1 ) AND c.CategoryID='''+@Filter+''' and p.modelName like ''%'+ @searchText+'%''' and p.description like ''%'+ @searchText+'%'''

--SET @SearchSQL = @SearchSQL + ' AND P.LogicallyDeleted !=''1'' AND Archived != 1 '
SET @SearchSQL = @SearchSQL + ' AND P.LogicallyDeleted !=''1'' AND Archived != 1 AND p.MasterBundleID = 0 order by P.SortOrder'

EXECUTE(@SearchSQL)
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)

SELECT *,TotalRecords=(
SELECT COUNT(*)
FROM #TempItems TI),
MoreRecords =
(
SELECT COUNT(*)
FROM #TempItems TI
WHERE TI.ProductAutoID >= @LastRec
)
FROM dnn_Smith_Products B (nolock) RIGHT OUTER JOIN
#TempItems T (nolock) ON B.ProductID = T.ProductID
WHERE ProductAutoID > @FirstRec AND ProductAutoID < @LastRec and b.PortalID = @PortalId
Order By B.SortOrder

---

Scott Kelly
Project Manager

From the dnn - host - module definitions if you edit the productdetails user control and check the box for "iSearchable" it will make the product description searchable using the standard dnn search. We will look at this stored proc this week and see if we can tweek it to do a wild card search on the product description.

---

At your service,
Dave Smith

Sorry about that it looks like we would need to program the isearchable into the module itself. I will send this into programming to see if they can implement the product description search.

-Scott

---

Scott Kelly
Project Manager

You can see the updates in all the cart releases in the change log here http://www.smith-consulting.com/products/dotnetnukemodules/shoppingcartmodule/smithcartchangelog.aspx . Including the discounts in the invoice that opens when you click the print invoice button on the manage orders screen did not make it into the latest release v2.96 I will ask programming to include in the next build.

-Scott

---

Scott Kelly
Project Manager

Changing the product search to search on product description will most likely just be a stored proc fix so no dll hotfix required.

-Scott

---

Scott Kelly
Project Manager

We did this and it works properly now but has somehow duplicated the number of search records (went from 1180 to 2360) even though there are only 1180 products still listed in the "Manage Products" section. Any idea how we can fix this?

Just installed 2.96 and it's still got the same problem.