Smart Edit: ProductCarouselComponent not showing products in smartedit editor for custom language isocode(en_GB)

[former_member698003]

Hi All,

I'm trying to add products to ProductCarouselComponent from smart edit editor, but products dropdown showing empty list. When I debug, it tries to execute Named Query from DefaultNamedQueryServiceProductSearchService.getNamedQueryForProductSearch() and it always taking "en" as language ISO code. We don't have any "en" localization for a name, description as we have en_GB as default language and localizations are available for en_GB only. Does anyone face this problem? Please help.

Hybris version: 6.7

Named Query: "SELECT {pk} FROM {Product} WHERE ( LOWER({name}) LIKE LOWER(?name) OR LOWER({description}) LIKE LOWER(?description) OR LOWER({code}) LIKE LOWER(?code)) AND {catalogVersion} = ?catalogVersion"

SELECT {pk} FROM {Product} WHERE ( LOWER({name}) LIKE LOWER('%%') OR LOWER({description}) LIKE LOWER('%%') OR LOWER({code}) LIKE LOWER('%%')) AND {catalogVersion} = '8796093121113'

Above query working when I add localizations for name and description in "en". Also tried executing above query from hac by changing the iso code. Please refer screen prints below.

Thanks

[arvind-kumar_avinash]

I am not able to figure out your code flow but I know that DefaultNamedQueryServiceProductSearchService.getNamedQueryForProductSearch() takes a parameter of type, CatalogVersionModel and CatalogVersionModel has a method, setLanguages(java.util.Collection<LanguageModel> value). If you have a way to set the catalogVersion, you should be able to achieve what you want.

[former_member698003]

Hi Arvind,

Thanks for your response.

Catalog version is already having languages in it. As per my understanding, the query is taking session language and session language is always "en" in my case. We don't have English localizations for Name and description and hence the query is not fetching the results.

Flow : When we edit the product carousel from smart edit, below screen will appear to add the product and categories to carousel component. When we select the catalog and click on products, below rest api will invoke to fetch the list of products available. api: https://localhost:9002/cmssmarteditwebservices/v1/productcatalogs/{catalogId}/versions/{versionId}/p...

This api returning blank as we do not have English localization for name and description.

[Former Member]

Hi,

Did you try changing the language to GB while login through smartedit?

[former_member698003]

Hi ,

Yes. I changed the language to GB before login through smart edit. In fact, we are showing only GB language in the dropdown. Please refer screen below.

[former_member681238]

We are facing a similar issue for product search in smart edit when we are trying to create Product restrictions. Does anyone have any solution for this? it is hitting the same query:

SELECT {pk} FROM {Product} WHERE ( LOWER({name}) LIKE LOWER(?name) OR LOWER({description}) LIKE LOWER(?description) OR LOWER({code}) LIKE LOWER(?code)) AND {catalogVersion} = ?catalogVersion

[former_member724521]

Hi, im having the same issue, if you find the solution please let us know :)

[former_member724521]

Another condition you have note, that is the products need to be syncronized and approved correctly (green icon on backoffice). However that solution dont work in all cases.