Posts

Showing posts with the label hybris

[Resolved] Cannot find CMSSite associated with current URL

Error "Cannot find CMSSite associated with current URL". This is because you are not telling Hybris which site you want to access. Let's first see all the possible solutions and then will go into other details. There are three ways to let Hybris know about the site you are trying to access 1. Pass the CMSSite ID as a request parameter
Simply pass your siteID as a request parameter(?site=SiteID) in your first request which helps the Hybris to understand which site you are trying to access. Let's say I'm trying to access the powertools site then URL would be https://localhost:9002/yacceleratorstorefront?site=powertools 2. Access site using http://<siteID>.local:9001/
Access site with siteID as DNS name. You can make 127.0.0.1 host with <siteID>.local. Let's say I want to access a powertools (It's CMSSite id for powertools), then add an entry like 127.0.0.1 powertools.local in your host file and then access your site usinghttp://powertools.local:90…

How to Integrate Google Enhanced Ecommerce with Hybris

How to implement Universal Analytics (UA) Enhanced Ecommerce features using Google Tag Manager on a Hybris?

We already have successfully implemented Enhanced E-commerce (Integrating Google Analytics) for many of Hybris sites.

This will be paid service.

contact@helphybris.com





Hybris flexible search query examples

Scenario1: Basic JOIN and IN query syntax Get the most recent order for each customer using flexible search. select {o.code} as orderCode, {c.name} as name, {a.cellphone} as cellphone from {order as o join Customer as c on {c.pk} = {o.user} join Address as a on {o.deliveryaddress} = {a.pk} } where {o.code} in ({{select max({code}) from {order} group by {user}}}) Note: This query is not optimized one. This is just the reference to the temporary table join syntax select t1.orderCode, t1.name, t1.cellphone from ({{ select {o.code} as orderCode, {c.name} as name,{a.cellphone} as cellphone from {order as o join Customer as c on {c.pk} = {o.user} join Address as a on {o.deliveryaddress} = {a.pk}} }}) as t1 Join ({{ select max({code}) as orderCode, {user} as user from {order} group by {user} }}) as t2 on t1.orderCode = t2.orderCode Scenario2: Temporary table and join between them