Searching with ProductID or Variant ID

Question

Hi,

Is it possible to include searching with ProductID or Variant ID to the Search functionality in Starter site. That is on providing ProductId or VariantId, is it possible to get the corressponding products to the search results.

Regards,
Ginu

Answer 1

please check the following link for the similar quetion

http://social.msdn.microsoft.com/Forums/en-US/commserver2007/thread/518f1527-fd9b-4fa5-ac38-098b422a05ee


-Krishna Priya

Answer 2

Hi Krishna priya,

The link you provided is the Search issue with Catalog manager, but my issue is with the Search screen in the Starter site. I have one requierment like on giving productID/VariantID to the Serach text, it should show the result in the search screen.

Regards,
Ginu

Answer 3

Can you check whether ProductId and VariantId metadata - IsSearchable is set to true?

Regards,
-Ravi Kanth Koppala

---

http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)

Answer 4

Hi Ravi Kanth,

Thanks for the reply.

I am using the existing property definition - ProductId & VariantId in Catalog and Inventory schema manager. So the FreeTextSearchable property is disabled. So I have made it True through backend using 

update CatalogAttributes set IsFreeTextSearchable = '1' where propertyname = 'productId'

 

But still it is not able to get the serach results on searching with productId? Anythink else I have to do for this?

Regards,
Ginu  

Answer 5

After changes to commerce server, have you rebuild free text catlaogs in SQL Server? Regards, -Ravi Kanth Koppala

---

http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)

Answer 6

Hello,

We had the problem too, we wanted to search the catalog by productId or variantId. the only way we found is to create a product property which contains the productId and the variantid, and when you create it you can choose FreeTextSearchable.

Tell us if it works after the catalog rebuild.

hth,
Cyrebre

Answer 7

Hi,

After rebuilding the catalog Free text catalog indexes, it worked. Thanks Ravikanth.

Do we need to add the rebuilding free text indexes in the code? Dies it solve the slowness on searching first time?

Regards,
Ginu

Answer 8

Changes to Properties will not happen frequently - but make a note in your installation document that whenever any changes to properties schema, make sure you rebuild the indexes. 

Slowness on searching first time is not a big issue - to overcome this issue (my opinion), we can write small utility which rebuilds the indexes and execute a couple of commerce server search - by doing this we can make the application faster to the end user.

You can close this thread if your problem is resolved.

Regards,
-Ravi Kanth Koppala

---

http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)