Developer forum

Forum » Ecommerce - Standard features » Random behaviour products when filtering on manufacturer

Random behaviour products when filtering on manufacturer

Dan Lundgren
Reply

Hello.

I asked earlier in this thread if it was possible to filter on manufacturers from the homepage, which i got a reply to in this thread:
http://developer.dynamicweb.com/forum/ecommerce-standard-features/filter-manufacturers-on-homepage.aspx

For some reason when i use this, for alot of manufacturers it doesnt find any products, even though the searchfilters list that they have found the products.
If i try to filter on some manufacturers(both from the homepage and from search filters in the productlist), the products doesnt even show up, even though the searchfilter finds them.

What can i do here? Why does it find some products and not others, even though they look the same in the database?

Best regards
Dan

 


Replies

 
Adrian Ursu
Reply

Hi Dan,

I had a similar experience and after digging a lot, i have found out that the products that were not returned, had a productID that was interpreted and split as a text. Like 1234-PROD-235. The index tokenized this productID as it was a text value composed from 3 parts: 1234, PROD and 235.

That's why the product ws not returned. Not sure if that's the case for you.
I would look at PRODID's of the products that are not showed. If you have added the products through the interface, it should not be an issue.

Adrian

 
Dan Lundgren
Reply

Hello Adrian.

Thanks for the answer, the productids seems to be the problem.
We have a NAV-integration where the customer migrates their products from the previous webshop, and its alot of products, so i dont think its an option to either change the productids or add them through the interface.

Is there a possibility for a hotfix for this issue? If so, when can this be expected to be released?

Thanks in advance.

Best regards
Dan

 
Merethe Nielsen
Reply

Hi, all

We have had this issue for investigation before and the problem is that the Lucene Standard Analyzer which is used to index/quering the products can't treat the hyphen and we can't change that.

Kind regards,
Merethe

 
Adrian Ursu
Reply

Hi Merethe,

You can not tokenize the productID. It is useless because no search will use it as a facete.

Aparently, from what we have seen in the code, this can be done.

It is a nightmare this issue, especially when syncronizing the products with 3rd party systems. We have spent a couple of month trying to get to the bottom of this.

It is also annoying for product with variants when you want to retrive automatically the image for the parent model. Because you have to use ProductID (that denominates the model) and there are just a few options (hardcoded in the core of the application) for the fields you can use. ProductID, ProductNumber and ProductName.

Please consider this for future hotfixes.

Thanks,

Adrian

 
Dan Lundgren
Reply

Hi again.

For some reason we get the same problems for products that look like this: PRODID(no numbers or letters) now, even though its worked before.
The only difference from before is that the manufacturerid has a "ö".
I cant reproduce the issue in my local environment, since then im adding it through the interface(which works), it differs from the NAV-integration that we have on the server.

Our ProductID gets -at-SHOP1 added after the productnumber in our integration, which then becomes our productID.
It has worked for products with one hyphen and products without hyphens before, but now it doesnt seem to work all of a sudden.
Could the -at-SHOP1 in the productID be the problem here? Even though it works for products before the products that got added recently?
Its very hard to debug, since it still acts a bit random.

Thanks in advance.

Best regards
Dan
 

 
Adrian Ursu
Reply

Hi Dan,

I would speculate that -at-SHOP1 would be the cause. Maybe in conjunction with other causes.

Ourr findings showed that productID is tokenized. And if the system finds - treats them as stop words and actually splits the string into pieces.

I have also encountered cases where a single hyphen does not affect the bahavior. It might be related with a dictionary, but I am just guessing.

So far nobody seemed to care about this. I thought we are the only crazy people in DW world :)

 
Merethe Nielsen
Reply

Hi,

We can't change that Lucene Standard Analyzer which is used to index/quering the products can't treat the hyphen.

About the manufacturerID's (and other ID's): By default the ID's only allows A-Z, 1-9 so no special characters like ö. I guess that this is why you can't reproduce by a setup where you have used the UI.

If you have complicated issues that needs to be investigated we need a case with steps and a copy of your site with the problem. Then we can assign a developer for an investigation.


If there is a special request (other than change the  Lucene Standard Analyzer and hyphens that we can't change) that you need for your special case, you can buy hours for developing the special feature. This also requires a request through the case system on Engage.

Kind regards,
Merethe

 

You must be logged in to post in the forum