How to install Solr 9 in Hybris/SAP Commerce Cloud version 2211.16 or above in local environment

Install Solr 9 in your local environment. 1. Set property solrserver.solr.server.version=9.2.0 in local.properties 2. Go to Solr official site to download the file solr-9.2.0.tgz and decompress file solr-9.2.0.tgz and repackage it as file solr-9.2.0.zip 3. Install solr-9.2.0.zip to your local mvn repository with the following command 4. Run ant all 5. Start your Commerce Cloud to verify …

How to install Solr 9 in Hybris/SAP Commerce Cloud version 2211.16 or above in local environment Read More »

How to find duplicate cms component in Hybris

Sometimes during a hybris system update, an error may occur when duplicating CMS components. To fix this problem, we can run the following query to identify and remove the affected component from Hybris. SELECT p_uid, p_catalogversion, COUNT(p_uid) FROM cmscomponent GROUP BY p_uid, p_catalogversion HAVING COUNT(p_uid) > 1

How to get order count by order status in hybris or how to join order and order status?

As part of our daily operations and development, we need to determine the order count by order status to find out how many orders are in a particular status. By using the following query, we can obtain this information quickly in Hybris. SELECT {status.code} AS status_code, COUNT({o.code}) AS order_countFROM {Order AS o JOIN OrderStatus AS …

How to get order count by order status in hybris or how to join order and order status? Read More »

Batch operations on Impex

Sometime its required to update the value of few attributes for more than one instance (row in table). Note: Batch Mode can use only with Update/Remote Operation in impex. cant be use with insert_update in Impex.