Author: Marc Raygoza

In SAP Hybris Commerce 6.x, the default database column length for an Itemtype Attribute String type is 255 characters.  A client recently asked to increase the database column length for the Orders table P_NAME column from the default 255 variable characters length to 500 variable characters length. In this tutorial, I will show you how to properly increase the database column in SAP Hybris Commerce. For this tutorial, I'm using the default Hybris database, HSQLDB. Open the <Your Hybris DIR>/ext/core/resources/core-items.xmll file using your preferred text file editor. Once the core-items.xml file is open, find the attribute qualifier="name" under AbstractOrder itemtype node. For …

I recently worked on a Hybris Commerce implementation where the DevOps role was managed by an external, cloud service provider.  In this externally managed DevOps situation, the Hybris development team were prevented from accessing the production Linux servers directly, and only the external DevOps team had direct access to the production servers. Sound familiar? This Hybris implementation, like most Hybris implementations, included third-party integrations to payment and tax web services. Each third-party integration's IP address or domain had to be whitelisted by the external DevOps team before the Hybris Commerce platform was able to connect with the third-party service successfully. On-premise services also had to …

This tutorial provides step by step instructions how to display base products that have variant products using Groovy. Step by Step Instructions 1. Goto to HAC in your Web browser. (If Hybris is running on your local machine, type https://localhost:9002/ in your Web browser URL) 2. Type your user name and password once HAC is displayed. (The following screenshot displays the HAC login page with username and password provided) 3. Once you've logged in successfully, click on Console -> Scripting Languages 4.  Copy and paste the following code into the Console window: import de.hybris.platform.servicelayer.search.FlexibleSearchService import de.hybris.platform.servicelayer.search.SearchResult; import de.hybris.platform.core.model.product.ProductModel import de.hybris.platform.variants.model.VariantProductModel; Map<String, Object> params …

This tutorial will provide step by step instructions to display a list of available catalogs in your Hybris Commerce implementation. Step by Step Instructions 1. Goto to HAC in your Web browser. (If Hybris is running on your local machine, type https://localhost:9002/ in your Web browser URL) 2. Type your user name and password once HAC is displayed. (The following screenshot displays the HAC login page with username and password provided) 3. Once you've logged in successfully, click on Console -> Scripting Languages 4.  Copy and paste the following code into the Console window: import de.hybris.platform.catalog.CatalogService; import de.hybris.platform.core.Registry; import de.hybris.platform.catalog.model.CatalogModel; CatalogService …

  # Currencies $usaCurrency=USD $ukCurrency=GBP $audCurrency=AUD $europeCurrency=EUR $chinaCurrency=CNY $canadaCurrency=CAD $norwayCurrency=NOK $swedenCurrency=SEK # Currencies INSERT_UPDATE Currency ;isocode[unique=true] ;conversion ;$usaCurrency ;1 ;$ukCurrency ;0.75 ;$audCurrency ;1.26 ;$europeCurrency ;0.85 ;$chinaCurrency ;6.59 ;$canadaCurrency ;1.25 ;$norwayCurrency ;7.89 ;$swedenCurrency ;8.10 The foreign exchange rates are stored in the Currency item type Conversion attribute.  In practice, you would create a Cron Job to update the foreign exchange rates in Hybris Commerce as often as required to effectively run your business.