Blog posts by Sanjay Katiyar

Blog posts by Sanjay Katiyar2025-04-28T10:57:39.0000000Zhttps://world.optimizely.com/blogs/sanjay-katiyar/ Optimizely World Optimizely Product Recommendation TroubleshootingIn today’s fast-paced digital landscape, personalization is everything. Customers expect relevant, tailored experiences whenever they interact with a brand — and meeting that expectation can make or break your success. That’s where Optimizely's Product Recommendation feature shines. What is Optimizely Product Recommendation? Optimizely’s Product Recommendation feature is a powerful, AI-driven tool designed to help brands offer hyper-personalized product suggestions to their customers. It’s built into the Optimizely Commerce platform and integrates seamlessly with both Commerce Cloud and Customized Commerce (formerly Episerver Commerce). Instead of relying on static product lists, Optimizely uses machine learning algorithms and real-time customer behavior to dynamically surface the right products to the right audience at the right time. Why Product Recommendations Matter? <ul> <li class="MsoNormal">Boost Conversion Rates Relevant product suggestions keep customers engaged and help them discover products they might not have found otherwise, leading to increased sales.</li> <li class="MsoNormal">Enhance Customer Experience When users feel like a site “understands” them, they’re more likely to stay, browse, and buy.</li> <li class="MsoNormal">Increase Average Order Value Smart cross-selling and upselling through recommendations can encourage customers to add more to their cart.</li> <li class="MsoNormal">Reduce Bounce Rates Presenting enticing alternatives or related items keeps visitors on your site longer.</li> </ul> Troubleshooting During the implementation, we faced a few challenges, which I have outlined here. Compatible Package Before starting, ensure you verify the Commerce version you are using and identify the compatible versions of related packages. For example, in my case, I was using EPiServer.Commerce 13.33.0, so I installed EPiServer.Personalization.Commerce and EPiServer.Tracking.Commerce version 3.2.37. Configuration  If you are using a single catalog, follow the single-site configuration; otherwise, use the multi-site configuration approach. Since I was working with a multi-site, channel-based setup, I made a mistake during the configuration — I used Web instead of web, and similarly Mobile instead of mobile. Please note that these values are case-sensitive, so ensure you use the correct lower-case terms to avoid configuration issues. Single Site  <pre class="language-html"><code><add key="episerver:personalization.BaseApiUrl" value="https://mysite.uat.productrecs.optimizely.com" /> <add key="episerver:personalization.Site" value="MySite" /> <add key="episerver:personalization.ClientToken" value="MyClientToken" /> <add key="episerver:personalization.AdminToken" value="MyAdminToken" /></code></pre> Multi-Site: The multi-site configuration is scope-based. If you are using more than one catalog, you need to set up the configuration in a repeated form as shown below. <pre class="language-html"><code><add key="episerver:personalization.ScopeAliasMapping.MyScope" value="SiteId"/> <add key="episerver:personalization.CatalogNameForFeed.MyScope" value="CatalogName"/> <add key="episerver:personalization.BaseApiUrl.MyScope" value="https://sitename.uat.productrecs.episerver.net" /> <add key="episerver:personalization.Site.MyScope" value="sitename" /> <add key="episerver:personalization.AdminToken.MyScope" value="MyAdminToken" /> <add key="episerver:personalization.ClientToken.MyScope.web" value="MyWebToken" /> <add key="episerver:personalization.ClientToken.MyScope.mobile" value="MyMobileToken" /></code></pre> Sync Specific Pricing (Group Price) The 'Product Export Job' syncs only the 'All Customers' pricing group. To sync prices for a specific pricing group, use IEntryPriceService to fetch the price for that group. e.g. <pre class="language-csharp"><code>public class DefaultEntryPriceService : IEntryPriceService { private readonly IPromotionEngine _promotionEngine; private readonly IMarketService _marketService; private readonly IPriceService _priceService; private readonly bool _calculateDiscountPrices; private readonly IPricingService _pricingService; public DefaultEntryPriceService(IPromotionEngine promotionEngine, IMarketService marketService, IPricingService pricingService) { _promotionEngine = promotionEngine; _marketService = marketService; _pricingService = pricingService; _calculateDiscountPrices = !bool.TryParse(ConfigurationManager.AppSettings["episerver:personalization.CalculateDiscountPrices"], out _calculateDiscountPrices) || _calculateDiscountPrices; } public IEnumerable<EntryPrice> GetPrices(IEnumerable<EntryContentBase> entries, DateTime validOn, string scope) { CustomEntryPriceService entryPriceService = this; List<CatalogKey> catalogKeys = entries .Where(x => x is IPricing) .Select(new Func<EntryContentBase, CatalogKey>(entryPriceService.GetCatalogKey)) .ToList(); Dictionary<string, ContentReference> codeContentLinkMap = entries.ToDictionary(c => c.Code, c => c.ContentLink); IEnumerable<IMarket> source1 = entryPriceService._marketService.GetAllMarkets().Where(x => x.IsEnabled); List<IPriceValue> source2 = new List<IPriceValue>(); foreach (IMarket market in source1) { foreach (CatalogKey key in catalogKeys) { //Read price for specific group from your service var price = _pricingService.GetConsumerListPricing(key.CatalogEntryCode, market); source2.Add(new PriceValue { CatalogKey = key, MarketId = market.MarketId, UnitPrice = new Money(price ?? decimal.Zero, market.DefaultCurrency) }); } } foreach (var priceValue in source2.GroupBy(c => new { c.CatalogKey, c.UnitPrice.Currency }).Select(g => g.OrderBy(x => x.UnitPrice.Amount).First()).ToList()) { ContentReference contentLink; if (codeContentLinkMap.TryGetValue(priceValue.CatalogKey.CatalogEntryCode, out contentLink)) { Money salePrice = priceValue.UnitPrice; if (entryPriceService._calculateDiscountPrices) { var market = _marketService.GetMarket(priceValue.MarketId); //Read Discounted Price var discountPrice = _pricingService.GetConsumerDiscountPricing( priceValue.CatalogKey.CatalogEntryCode, market) ?? decimal.Zero; salePrice = discountPrice == 0 ? priceValue.UnitPrice : new Money(discountPrice, market.DefaultCurrency); } yield return new EntryPrice(contentLink, priceValue.UnitPrice, salePrice); } } } private CatalogKey GetCatalogKey(EntryContentBase entryContent) { return new CatalogKey(entryContent.Code); } }</code></pre> Target Specific Markets: When targeting products for specific markets, use ICatalogItemFilter to filter the products from your catalog before syncing the feed into product recommendations. In our case, for one of the sites, we are targeting more than 16 markets. However, we encountered an issue syncing the feed for the China market, as the Unicode product URLs were not compatible with the product recommendations feed (Optimizely need to fix the Unicode issue). As a result, we decided to launch this feature for specific markets only. e.g.   <pre class="language-csharp"><code> public class DefaultCatalogItemFilter : ICatalogItemFilter { private readonly IPublishedStateAssessor _publishedStateAssessor; private List<string> languages = new List<string>() { "en", "en-CA", "fr-CA" }; public DefaultCatalogItemFilter(IPublishedStateAssessor publishedStateAssessor) { _publishedStateAssessor = publishedStateAssessor; } public bool ShouldFilter(CatalogContentBase content, string scope) { if (_publishedStateAssessor.IsPublished(content, PublishedStateCondition.None) && languages.Any(x => string.Equals(x, content.Language.Name, StringComparison.InvariantCultureIgnoreCase))) { return false; } return !_publishedStateAssessor.IsPublished(content, PublishedStateCondition.None); } }</code></pre>   Sync Specific Attributes in the Product Feed To target specific attributes for syncing into the feed for catalog entries, use IEntryAttributeService. This service helps you apply certain rules to control how products are displayed in the recommendation area. In our case, we are using a single codebase for over 14 catalogs. However, the products and variants have some uncommon properties that cannot be included in the feed for other sites. <pre class="language-csharp"><code>public class DefaultEntryAttributeService : IEntryAttributeService { private readonly CatalogFeedSettings _catalogFeedSettings; private readonly IVariantAttributeService _variantAttributeService; public DefaultEntryAttributeService(CatalogFeedSettings catalogFeedSettings, IVariantAttributeService variantAttributeService) { _catalogFeedSettings = catalogFeedSettings; _variantAttributeService = variantAttributeService; } public bool CanBeRecommended(EntryContentBase content, decimal stock, string scope) { return stock > 0M; } public IDictionary<string, string> GetAttributes(EntryContentBase content, string scope) { List<string> userMetaFieldNames = GetUserMetaFields(content).ToList(); Dictionary<string, string> attributes = new Dictionary<string, string>(); if (!userMetaFieldNames.Any()) return attributes; // Read attributes from your list that you would like to exclude from feed _catalogFeedSettings.ExcludedAttributes = RecommendationHelper.ExcludeAttributes; HashSet<string> excludedAttributes = new HashSet<string>(_catalogFeedSettings.ExcludedAttributes, StringComparer.OrdinalIgnoreCase); foreach (PropertyData propertyData in content.Property.Where(x => IsValidContentProperty(x, userMetaFieldNames, excludedAttributes))) { attributes.Add(propertyData.Name, propertyData.Value.ToString()); } if (content is MyVariant variant) { foreach (var attr in RecommendationHelper.IncludeAttributes) // Include specific attributes { if (attributes.Any(x => string.Equals(x.Key, attr, StringComparison.OrdinalIgnoreCase))) continue; // Read the value for attribute if exists in catalog entries var value = _variantAttributeService.GetAttributeValueByName(attr, variant); if (!string.IsNullOrWhiteSpace(value)) { attributes.Add(attr, value); } } } return attributes; } public string GetDescription(EntryContentBase entryContent, string scope) { return entryContent[_catalogFeedSettings.DescriptionPropertyName]?.ToString(); } public string GetTitle(EntryContentBase entryContent, string scope) { return !string.IsNullOrEmpty(entryContent.DisplayName) ? entryContent.DisplayName : entryContent.Name; } private bool IsValidContentProperty( PropertyData property, IEnumerable<string> userMetaFieldNames, HashSet<string> excludedAttributes) { return userMetaFieldNames.Any(x => x.Equals(property.Name)) && !property.Name.Equals("_ExcludedCatalogEntryMarkets") && !property.Name.Equals("DisplayName") && !property.Name.Equals("ContentAssetIdInternal") && !property.Name.StartsWith("Epi_") && property.Value != null && !excludedAttributes.Contains(property.Name); } public IEnumerable<string> GetUserMetaFields(EntryContentBase content) { var metaClass = Mediachase.MetaDataPlus.Configurator.MetaClass.Load(new MetaDataContext() { UseCurrentThreadCulture = false, Language = content.Language.Name }, content.MetaClassId); return metaClass != null ? metaClass.GetUserMetaFields().Select(x => x.Name).ToList() : null ?? Enumerable.Empty<string>(); } }</code></pre> Product Page Tracking Use the product code instead of the variant code to track the product. <img src="/link/47871e11ed3048428b9f49763a18a8d0.aspx" width="591" height="275" />   If you're encountering any challenges with the native implementation, feel free to reach out for assistance. Cheers!2025-04-28T10:57:39.0000000Z

Blog post

Integration Bynder (DAM) with OptimizelyBynder is a comprehensive digital asset management (DAM) platform that enables businesses to efficiently manage, store, organize, and share their digital content and branding assets, including images, videos, documents, and other media files. For more information, visit <a href="https://www.bynder.com/en/">Bynder</a>. This blog will guide you through integrating Bynder with the Optimilzey platform, ensuring a smooth development process, and leveraging Bynder's extensive features to meet your project needs To integrate Bynder with Optimizely, follow these steps: <div class="flex flex-grow flex-col max-w-full"> <div class="min-h-[20px] text-message flex w-full flex-col items-end gap-2 whitespace-pre-wrap break-words [.text-message+&]:mt-5 overflow-x-auto"> <div class="flex w-full flex-col gap-1 empty:hidden first:pt-[3px]"> <div class="markdown prose w-full break-words dark:prose-invert light"> <ol> <li> Contact Bynder Support: <ul> <li>Contact your Customer Success Manager or Bynder support at <a>support@bynder.com</a> to learn more about the Optimizely integration and request the integration package.</li> </ul> </li> <li> Obtain the Installation Package: <ul> <li>You will receive an installation package after discussing your needs with Bynder support.</li> </ul> </li> <li> Review the Documentation: <ul> <li>Check the <code>readme.md</code> file included in the package for detailed installation and configuration instructions.</li> </ul> </li> <li> Installation and Configuration: <ul> <li>Since the Bynder package is unavailable on nuget.org, follow the steps outlined in the <code>readme.md</code> file to manually install and configure the integration.</li> </ul> </li> </ol>        For additional information and support, visit the <a href="https://support.bynder.com/hc/en-us/articles/360015350220-Optimizely-Integration">Bynder Optimizely Integration Guide</a>. </div> </div> </div> </div> <div class="mt-1 flex gap-3 empty:hidden ml-3"> <div class="items-center justify-start rounded-xl p-1 z-10 -mt-1 bg-token-main-surface-primary md:absolute md:border md:border-token-border-light flex"> <div class="flex items-center"></div> </div> </div> Installation Step 1: Add the provided Bynder.x.x.x.nupkg package by support into the project. Step 2: Click on the ‘Package Manager Console’ setting icon and add the package source for Bynder from the physical project directory location. Step 3: Add the Bynder package relative folder path reference into nuget.config because when you start the build and deployment nuget package picks the package location from the given soruce. Step 4: Run command: Install-Package Bynder <img src="/link/defe49e98cf04e54a7e7d84ec8f92367.aspx" width="686" height="314" /> Configuration: Step 1: Register the Bynder into Startup.cs <img src="/link/6272b96493c041508173edc17f5594c5.aspx" width="685" height="304" /> Note:  <ul> <li><code>appsettings.json</code>: For environment-specific settings, this file is commonly used. It’s a good place to store configuration values like <code>BaseUrl</code>, <code>ClientId</code>, and <code>ClientSecret</code>.</li> <li>Workflow Files: If you prefer, you can also manage these settings in workflow files, depending on your deployment or CI/CD setup.</li> <li>The recommendations in this article we simplified for demonstration purposes. For production, make sure to follow security best practices, such as storing secrets securely and using environment-specific configurations</li> </ul> Step 2: Login into CMS area --  Add-ons -- Bynder Step 3: To integrate Bynder with Optimizely and manage assets, follow these steps: <ol> <li> Get Authorization Token: <ul> <li>Click on ‘Get Token’ to initiate the authorization process. This token will allow you to add items from Bynder DAM into Optimizely.</li> </ul> </li> <li> Whitelist Redirect URL: <ul> <li>Ensure that your ‘RedirectUrl’ is whitelisted in Bynder. This step is crucial for successful authentication and authorization.</li> </ul> </li> <li> Troubleshooting: <ul> <li>If you encounter issues with adding Bynder assets, try deleting the existing token and generating a new one. This often resolves authorization problems.</li> </ul> </li> </ol> <img src="/link/26ef027898fa46f0b760d0d3c4780117.aspx" width="685" height="303" /> Step 4: To configure <code>AllowedTypes</code> and <code>UIHints</code> for Bynder and Optimizely assets at the property level, you would typically do this in your code where you define asset properties. Here’s how you might set this up: <pre class="language-csharp"><code>[Display(GroupName = GroupNames.Content,Order = 10)] [AllowedTypes(typeof(VideoFile), typeof(BynderVideoAsset))] public virtual ContentReference? Video { get; set; } [Display(GroupName = GroupNames.Content, Order = 10)] [UIHint(UIHint.Image)] [AllowedTypes(typeof(ImageFile), typeof(BynderImageAsset))] public virtual ContentReference? Image { get; set; } </code></pre> AllowedTypes: <ul> <li>VideoFile: Use this if you want to optimize or make changes to existing video assets in Optimizely, without removing any current functionality.</li> <li>ImageFile: Use this for optimizing or updating existing image assets in Optimizely.</li> <li>BynderVideoAsset: Use this to refer to or use video assets stored in Bynder, rather than those uploaded directly to Optimizely's media folder.</li> <li>BynderImageAsset: Use this to refer to or use image assets stored in Bynder, rather than those uploaded directly to Optimizely's media folder.</li> </ul> UIHints - You can use one of the UIHints from below to display the thumbnail image. <ul> <li>[UIHint(UIHint.Image)] – This will display a thumbnail image for both types of assets—Bynder and Optimizely. It's a general UI hint that applies to any asset type you specify as an image.</li> <li>[UIHint(Bynder.UIHints.Bynder)] – This will specifically display a thumbnail image only for Bynder assets. It won't affect Optimizely assets.</li> </ul>       Note: If you are unable to see the thumbnail image for the Bynder image asset then Login into the Bynder portal and edit the image with permission ‘Mark as public’      <img src="/link/cdf4ea66993944b49edf57759fcad524.aspx" /> Step 5: Upload Your Assets from Bynder or Optimizely media asset and test. <img src="/link/2e296e3ba0404fc6b441d5a90d5269dc.aspx" width="413" height="299" /> Step 6: Bynder Jobs to sync and update the contents. <img src="/link/9c3301aebb194589a75245f001d1c1ff.aspx" /> Here is some additional help to understand the model type and rendering for other Bynder media assets: Model: <pre class="language-csharp"><code>public class BynderBlock : BlockData { [AllowedTypes(typeof(BynderImageAsset))] [Display(GroupName = GroupNames.Content, Order = 10)] [UIHint(Bynder.UIHints.Bynder)] public virtual ContentReference? BynderImage { get; set; } [AllowedTypes(typeof(BynderAudioAsset))] [Display(GroupName = GroupNames.Content, Order = 20)] public virtual ContentReference? BynderAudio { get; set; } [AllowedTypes(typeof(BynderVideoAsset))] [Display(GroupName = GroupNames.Content, Order = 30)] public virtual ContentReference? BynderVideo { get; set; } [AllowedTypes(typeof(BynderDocumentAsset))] [Display(GroupName = GroupNames.Content, Order = 40)] public virtual ContentReference? BynderDocument { get; set; } } </code></pre> Rendering: <pre class="language-csharp"><code>@Html.PropertyFor(x => x.CurrentBlock.BynderImage) OR var url= Model.CurrentBlock.BynderImage.GetUrl() <img src="@url" alt ="Bynder asset" /></code></pre> To create an extension method that reads the image URL from Bynder media asset types, you can follow these steps: <ol> <li>Create a static class to hold the extension method.</li> <li>Define the extension method to extract the URL from the media asset type.</li> </ol> Here's an example of how you might implement such an extension method: <pre class="language-csharp"><code>public static string GetUrl(this ContentReference contentReference) { if (!string.equals(contentReference.ProviderName, "bynder-assets-provider")) { return _urlResolver.GetUrl(contentReference); } IBynderAsset assetData = _contentLoader.Get<IBynderAsset>(contentReference); if (assetData != null && assetData.AssetType.Equals("image")) { return assetData.ImageUrl; } else if (assetData != null && assetData.AssetType.Equals("video")) { var videoAsset = assetData as BynderVideoAsset; return videoAsset?.VideoPreviewURLs.FirstOrDefault() ?? string.Empty; } else if (assetData != null && assetData.AssetType.Equals("document")) { var documentAsset = assetData as BynderAssetData; return documentAsset?.TransformBaseUrl ?? documentAsset?.Original ?? string.Empty; } else if (assetData != null && assetData.AssetType.Equals("audio")) { var audioAsset = assetData as BynderAssetData; return audioAsset?.TransformBaseUrl ?? audioAsset?.Original ?? string.Empty; } return string.Empty; }</code></pre>   Hope this guide helps you set up the basic configuration for integrating Bynder with Optimizely. Please leave your feedback in the comment box. Thanks for your visit!2024-07-22T06:33:02.0000000Z

Blog post

Remove a segment from the URL in CMS 12Problem: I have created thousands of pages dynamically using schedule jobs with different templates (e.g. one column, two columns, etc..) and stored them under one of the specific container page templates but some of the page’s URLs were renamed. So, I have two problems: <ol> <li>How to ignore the container page name segment from the URL,</li> <li>Redirect to the new page without using any Add-ons or mapping the old one to the new URL.</li> </ol> <table> <tbody> <tr> <td> Page Hierarchy </td> <td> Name in URL </td> <td> New URL (simple address url) </td> <td> Expected result </td> </tr> <tr> <td> Start Page -> Container Page -> One col page </td> <td> study </td> <td> students/study </td> <td> - Remove the ‘container-page’ segment from URL. - Apply 301 redirection for New URLs without adding any Add-Ons </td> </tr> <tr> <td></td> <td> https://local.alloy.com/container-page/study </td> <td>  https://local.alloy.com/students/study </td> <td> https://local.alloy.com/study https://local.alloy.com/students/study </td> </tr> <tr> <td></td> <td></td> <td></td> <td></td> </tr> </tbody> </table> Solution: To fix the above problem we need to add the simple address for new URLs in each page and implement custom 301 redirections. Register middleware into startup.cs file to bypass the container page segment from the URL <pre class="language-csharp"><code> public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IConfiguration configuration) { app.UseMiddleware<SkipContainerPageMiddleware>(); }</code></pre> Create the container page middleware to read the simple address and apply 301 redirection: <pre class="language-csharp"><code>public class SkipContainerPageMiddleware { private readonly RequestDelegate _next; private readonly ISettingsService _settingsService; private readonly IContentLoader _contentLoader; public SkipContainerPageMiddleware(RequestDelegate next, ISettingsService settingsService, IContentLoader contentLoader) { _next = next; _settingsService = settingsService; _contentLoader = contentLoader; } public async Task Invoke(HttpContext context) { //Create a content reference type property in GlobalPageSettings or HomePage to read the container page location where all pages created var folderLocation = _settingsService.GetSiteSettings<GlobalPageSettings>()?.OEmbedFolderLocation ?? ContentReference.EmptyReference; var folderName = "/" + _contentLoader.Get<IContent>(folderLocation).Name; if (context.Request.Path.StartsWithSegments(folderName, StringComparison.OrdinalIgnoreCase)) { context.Request.Path = context.Request.Path.HasValue ? context?.Request?.Path.Value.Substring(folderName.Length) : string.Empty; if (context != null) { var url = GetSimpleAddress(folderName, context); if (url != null) { var newURl = $"{context.Request.Scheme}://{context.Request.Host}/{url.Trim('/')}"; context.Response.Redirect(newURl, true); return; } } } if (context != null) await _next(context); } private string? GetSimpleAddress(string parentSegment, HttpContext context) { var parentPage = _contentLoader .GetChildren<ContainerPage>(ContentReference.StartPage) .FirstOrDefault(x => string.Equals(parentSegment.Trim('/'), x.URLSegment, StringComparison.InvariantCultureIgnoreCase))? .ContentLink ?? ContentReference.EmptyReference; var url = context.Request.Path.HasValue ? context?.Request.Path.Value.Trim('/') : string.Empty; if (string.IsNullOrWhiteSpace(url) || parentPage == ContentReference.EmptyReference) return default; PageData? page = null; foreach (var item in url.Split('/')) { page = RecursivePageBySegment(parentPage, item); if (page != null) parentPage = page.ContentLink; } return page?.ExternalURL ?? url; } private PageData? RecursivePageBySegment(ContentReference parentPage, string urlSegment) { var children = _contentLoader.GetChildren<PageData>(parentPage); if (children.Count() == 0) { return _contentLoader.Get<PageData>(parentPage); } var page = children.FirstOrDefault(page => page.URLSegment.Equals(urlSegment, StringComparison.OrdinalIgnoreCase)); return page ?? default; } }</code></pre> I hope this blog helps you achieve similar type functionality!  2024-06-21T04:58:46.0000000Z

Blog post

Custom promotion - Buy at least X items from catalog entries and get a discount on related catalog entries.Problem: Buy at least X items from catalog entries and get related catalog entries at a discount that satisfy the below formula.  or Create a custom promotion to ‘Buy Products for Discount from Other Selections’ and apply the below formula to get a discount on other selections. <h3>Formula = m x n,  then get the discounts on n items.</h3> m = Spend at least X items n = Multiplier e.g. m = 2 n = 1, 2,3…… <table> <tbody> <tr> <td>CART</td> <td></td> </tr> </tbody> </table> <table> <tbody> <tr> <td>Main Product SKU Qty.</td> <td>Other Selection SKU Qty.</td> <td>Eligible Discount Qty.</td> </tr> <tr> <td>2 x 1</td> <td>1</td> <td>1</td> </tr> <tr> <td>2 x 2</td> <td>2</td> <td>2</td> </tr> <tr> <td>2 x 3</td> <td>4</td> <td>3</td> </tr> <tr> <td>2 x 4</td> <td>5</td> <td>4</td> </tr> <tr> <td>....</td> <td>....</td> <td>....</td> </tr> <tr> <td>m x n</td> <td>....</td> <td>n</td> </tr> </tbody> </table> If you notice the above table ‘Other Selection SKU Qty.’ column, customer added more than the eligible discounted qty in the cart. So, we need to make sure the discount is only eligible for 'Eligible Discount Qty.' not for all ‘Other Selection SKU Qty.’. Solution: <ol> <li>Create a custom entry promotion</li> </ol> <pre class="language-csharp"><code> [ContentType( GUID = "CB99C622-A170-4EF6-B28D-077B18BAFD81", GroupName = "Custom - Promotions", DisplayName = "Custom - Buy products for discount from other selection", Description = "Buy at least X items from catalog entries and get related catalog entries at a discount e.g. (2 + 1), (4 + 2), (6 + 3) ... ", Order = 30000)] [PromotionSettings(FixedRedemptionsPerOrder = 1)] [ImageUrl("~/Static/Img/CustomBuyQuantityGetItemDiscount.png")] public class CustomBuyQuantityGetItemDiscount : EntryPromotion, IMonetaryDiscount { [Display(Order = 10)] [PromotionRegion("Condition")] public virtual PurchaseQuantity Condition { get; set; } [Display(Order = 20)] [PromotionRegion("Reward")] public virtual DiscountItems DiscountTarget { get; set; } [Display(Order = 30)] [PromotionRegion("Discount")] public virtual MonetaryReward Discount { get; set; } } </code></pre> 2. Create custom discount processor and override following methods: <ul> <li>GetPromotionItems <ul> <li>Return promotion conditions and reward items.</li> </ul> </li> <li>RewardDescription <ul> <li>Read all discounted SKUs with the max eligible qty for discounts.</li> <li>Create Redemption Description into GetRedemptions.</li> </ul> </li> </ul> <pre class="language-csharp"><code>public class CustomBuyQuantityGetItemDiscountProcessor : EntryPromotionProcessorBase<CustomBuyQuantityGetItemDiscount> { private readonly IContentLoader _contentLoader; public CustomBuyQuantityGetItemDiscountProcessor( RedemptionDescriptionFactory redemptionDescriptionFactory, IContentLoader contentLoader) : base(redemptionDescriptionFactory) { _contentLoader = contentLoader ?? throw new ArgumentNullException(nameof(contentLoader)); } protected override PromotionItems GetPromotionItems(CustomBuyQuantityGetItemDiscount promotionData) { return new PromotionItems( promotionData, new CatalogItemSelection(promotionData.Condition.Items, CatalogItemSelectionType.Specific, true), new CatalogItemSelection(promotionData.DiscountTarget.Items, CatalogItemSelectionType.Specific, true)); } protected override RewardDescription Evaluate( CustomBuyQuantityGetItemDiscount promotionData, PromotionProcessorContext context) { var allLineItems = this.GetLineItems(context.OrderForm)? .Where(x => !x.IsGift)? .ToList(); if (promotionData?.DiscountTarget?.Items == null || promotionData?.Condition?.Items == null || promotionData?.Condition?.RequiredQuantity == 0 || allLineItems.Count() == 0) { return RewardDescription.CreateNotFulfilledDescription( promotionData, FulfillmentStatus.NotFulfilled); } //Read all excluded variants var excludedVariants = new List<string>() { }; if (promotionData.ExcludedItems != null && promotionData.ExcludedItems.Count > 0) { foreach (ContentReference item in promotionData.ExcludedItems) { if (_contentLoader.TryGet(item, out NodeContent content)) { excludedVariants.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(content.ContentLink) .Select(x => x.Code) .ToList()); } else if (_contentLoader.TryGet(item, out ProductContent productContent)) { excludedVariants.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(productContent.ContentLink) .Select(x => x.Code) .ToList()); } else { excludedVariants.Add(_contentLoader.TryGet<VariationContent>(item)?.Code); } } } //Read all condition variants var conditionSkus = new List<string>() { }; foreach (ContentReference item in promotionData.Condition.Items) { if (_contentLoader.TryGet(item, out NodeContent content)) { conditionSkus.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(content.ContentLink) .Select(x => x.Code) .ToList()); } else if (_contentLoader.TryGet(item, out ProductContent productContent)) { conditionSkus.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(productContent.ContentLink) .Select(x => x.Code) .ToList()); } else { conditionSkus.Add(_contentLoader.TryGet<VariationContent>(item)?.Code); } } //Read all discounted variants var discountSkus = new List<string>() { }; foreach (ContentReference item in promotionData.DiscountTarget.Items) { if (_contentLoader.TryGet(item, out NodeContent content)) { discountSkus.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(content.ContentLink) .Select(x => x.Code) .ToList()); } else if (_contentLoader.TryGet(item, out ProductContent productContent)) { discountSkus.AddRange( _contentLoader.GetDescendantsOfType<VariationContent>(productContent.ContentLink) .Select(x => x.Code) .ToList()); } else { discountSkus.Add(_contentLoader.TryGet<VariationContent>(item)?.Code); } } //remove the discounted SKUs if exist in the excluded list. if (excludedVariants.Count() > 0) { discountSkus = discountSkus.Where(x => !excludedVariants.Contains(x)).ToList(); conditionSkus = conditionSkus.Where(x => !excludedVariants.Contains(x)).ToList(); } var totalPurchasedQty = allLineItems.Where(x => conditionSkus.Contains(x.Code)).Sum(x => x.Quantity); var maxDiscountedQty = Math.Floor(totalPurchasedQty / promotionData.Condition.RequiredQuantity); if (promotionData.DiscountTarget.MaxQuantity != null && maxDiscountedQty > promotionData.DiscountTarget.MaxQuantity) { maxDiscountedQty = (decimal)promotionData.DiscountTarget.MaxQuantity; } if (maxDiscountedQty == decimal.Zero) { return RewardDescription.CreateNotFulfilledDescription( promotionData, FulfillmentStatus.InvalidCoupon); } var discountedLineItems = allLineItems .Where(x => discountSkus.Contains(x.Code)) .OrderByDescending(x => x.PlacedPrice) .ThenBy(x => x.Quantity) .ToList(); return RewardDescription.CreateMoneyOrPercentageRewardDescription( FulfillmentStatus.Fulfilled, GetRedemptions(promotionData, context, discountedLineItems, maxDiscountedQty), promotionData, promotionData.Discount, context.OrderGroup.Currency, promotionData.Name); } private IEnumerable<RedemptionDescription> GetRedemptions( CustomBuyQuantityGetItemDiscount promotionData, PromotionProcessorContext context, List<ILineItem> discountedLineItems, decimal maxQty) { List<RedemptionDescription> redemptionDescriptionList = new List<RedemptionDescription>(); var applicableCodes = discountedLineItems.Select(x => x.Code); decimal val2 = GetLineItems(context.OrderForm).Where(li => applicableCodes.Contains(li.Code)).Sum(li => li.Quantity); decimal num = Math.Min(GetMaxRedemptions(promotionData.RedemptionLimits), val2); for (int index = 0; index < num; ++index) { AffectedEntries entries = context.EntryPrices.ExtractEntries(applicableCodes, Math.Min(maxQty, val2), promotionData); if (entries != null) { redemptionDescriptionList.Add(this.CreateRedemptionDescription(affectedEntries: entries)); } } return redemptionDescriptionList; } } </code></pre> Wishing you a year full of blessing and filled with a new adventure. Happy new year 2023! Cheers🥂2023-01-03T16:05:53.0000000Z

Blog post

Delete unused properties and content types in CMS 12The purpose of this blog is to delete unused properties, content references, and content types programmatically and keep clean content. Problem: I have created a block type (e.g. TeaserBlock) and using this block created multiple contents and used it in different places, but after some time the requirement was changed and I removed this block type completely from the code. So for cleanup, we need to remove this block type from the Admin --> Content Types area in CMS because it no longer exists. But when I tried to delete it, we got content reference warnings because we already created content using a specific block type and added those references at many places (e.g. Main Content Area of other pages). Then the question comes to mind how to delete it? So I tried the following solution and fixed it. <img src="/link/80aa19bf006d491caf7e754c575e93f5.aspx" /> Solution:  We have two options two remove the missing content type and its references: <ol> <li>Remove all references from each content type and then delete it from the Admin -> Content Types area. - This is a time-consuming activity because you need to visit and delete each content type (moving and emptying the Trash folder).</li> <li>Write the code and clean up it programmatically.</li> </ol> I am using the second (2) option to achieve this. Where do you write the code? I will suggest in the Initialization Module or create a Schedule Job to delete the unused properties and content types. It’s totally up to you  :) Delete the missing properties which are no longer exist in the code for Content Type (PageType/BlockType): (e.g. TeaserBlock -> Sub Title) <pre class="language-csharp"><code> private void DeleteUnUsedProperties() { var pageTypeRepository = ServiceLocator.Current.GetInstance<IContentTypeRepository<PageType>>(); var propertyDefinitionRepository = ServiceLocator.Current.GetInstance<IPropertyDefinitionRepository>(); foreach (var type in pageTypeRepository.List()) { foreach (var property in type.PropertyDefinitions) { if (property != null && !property.ExistsOnModel) { propertyDefinitionRepository.Delete(property); } } this.DeleteContentType(type); } var blockTypeRepository = ServiceLocator.Current.GetInstance<IContentTypeRepository<BlockType>>(); foreach (var type in blockTypeRepository.List()) { foreach (var property in type.PropertyDefinitions) { if (property != null && !property.ExistsOnModel) { propertyDefinitionRepository.Delete(property); } } this.DeleteContentType(type); } }</code></pre> Delete the content references and missing content type (e.g. TeaserBlock) <pre class="language-csharp"><code> private void DeleteContentType(ContentType contentType) { if (contentType.ModelType != null) { return; } if (contentType.Saved != null && contentType.Created.HasValue && contentType.Created.Value.Year > 2021 && contentType.IsAvailable) { // Find and deletes the content based on type. var contentModelUsage = ServiceLocator.Current.GetInstance<IContentModelUsage>(); var contentUsages = contentModelUsage.ListContentOfContentType(contentType); var contentReferences = contentUsages .Select(x => x.ContentLink.ToReferenceWithoutVersion()) .Distinct(); var contentRepository = ServiceLocator.Current.GetInstance<IContentRepository>(); foreach (var contentItem in contentReferences) { contentRepository.Delete(contentItem, true, EPiServer.Security.AccessLevel.NoAccess); } // Delete type of content. var contentTypeRepository = ServiceLocator.Current.GetInstance<IContentTypeRepository>(); if (contentType.ID > 4) { contentTypeRepository.Delete(contentType.ID); } } }</code></pre> Note: CotentType.ID > 4 means this will exclude the system/predefined page types e.g. Root Page. Please leave your feedback in the comment box. Thanks for your visit!2022-10-08T03:22:33.0000000Z

Blog post

Create a new Optimizely Commerce 14 ProjectThe purpose of blog to create a new Optimizely commerce project in version 14.x using dotnet-episerver CLI and helps to remember the steps for developer to create a new commerce project. I have also mentioned few errors solution which I experienced during the project setup. Before to jump on steps make sure the <a href="/link/b351930dd81d451ba795ac042b56a63c.aspx">development environment</a> & <a href="/link/15a45be2c1664fde9b1c588592fa99f6.aspx">system requirement</a> is ready. Step 1: <ul> <li>Install EPiServer templates:</li> </ul> <pre class="language-csharp"><code>dotnet new -i EPiServer.Net.Templates --nuget-source https://nuget.optimizely.com/feed/packages.svc/ --force</code></pre> --force: forces the modification and overwriting of required files for installation if required files exist. <ul> <li> Install EPiServer CLI:</li> </ul> <pre class="language-csharp"><code>dotnet tool install EPiServer.Net.Cli --global --add-source https://nuget.optimizely.com/feed/packages.svc/</code></pre> Step 2: Open the Visual Studio and click on Create a new project link and search “episerver”, you will see EPiServer installed templates for both CMS and Commerce. We are going to create a commerce project so choose “Episerver Commerce Empty Project” and click on next. <img src="/link/3f2fc87e526f4cb6ad90fcfe07fabe03.aspx" width="752" height="271" /> Enter the project name e.g. QuickDemo and create. <img src="/link/3c807a16ed7a4c18bd1574ec82163997.aspx" width="337" height="338" /> Step 3:  Create database with admin user. Open the package manager console in visual studio and select default project. OR If you are using other command prompt, then reach out the project location using cd command e.g., ‘C:\Optimizely\QuickDemo’ and type EPiServer cli commands as mentioned below. <ul> <li>CMS Database:</li> </ul> <pre class="language-csharp"><code>dotnet-episerver create-cms-database QuickDemo.csproj -S [ServerName] -U [ServerLoginUserName] -P [ServerLoginPassword] -dn QuickDemoCms -du [DataBaseUserName] -dp [DataBasePassword]</code></pre> <ul> <li> Commerce Database:</li> </ul> <pre class="language-csharp"><code>dotnet-episerver create-commerce-database QuickDemo.csproj -S [ServerName] -U [ServerLoginUserName] -P [ServerLoginPassword] -dn QuickDemoCommerce -du [DataBaseUserName] -dp [DataBasePassword]</code></pre> <ul> <li>Add admin user</li> </ul> <pre class="language-csharp"><code>dotnet-episerver add-admin-user QuickDemo.csproj -u admin -p Episerver123! -e admin@example.com -c EcfSqlConnection</code></pre> Note:  -c = connection string name is the case sensitive so make sure the name is same as in your appsetting.json -S: Database server name -U: Database server login username -P: Database server login password -dn: Database name e.g. epiCms -du: Database username e.g. sa -dp: Database password -u: Admin user username/loginname e.g. admin or email -p: Admin user password -e: Admin user email -c: connection string name e.g. EcfSqlConnection Step 4: Setup the launch browser for empty site in debug mode and press ctr+f5 or f5 (in windows) to run the site. <ul> <li>For login use /util/login</li> <li>For CMS view type: /episerver/cms</li> </ul> <img src="/link/1ce516ddbb4d48d49b743e0f33ba86ce.aspx" width="625" height="344" /> Step 5: Enable Commerce Tab: Once you login into the CMS area then make sure the <img src="/link/070fdf6e1ce64b989a9beba7a0862c1b.aspx" />  icon is visible for you if not exist then follow up the below steps and enable it <ul> <li>Add new Administrators group:</li> </ul> Admin --> Access Rights --> Administer Groups --> And create a new Administrators group <img src="/link/8e15dde184b94fc9a746f303442dc2b5.aspx" width="583" height="214" /> <ul> <li>Assign the Administrators group to the created user:</li> </ul> Admin --> Access Rights --> Admin Users --> Click on the username <img src="/link/ce504e1b5301405b918be0c89928f7d5.aspx" width="495" height="446" /> <ul> <li>Now logout and login again then you will see the missing dotted icon on top navigation.</li> </ul> <img src="/link/2d8fde655c5746a088d826dc73c867e3.aspx" width="577" height="112" /> Okay, now time to visit into the commerce area so click on the dotted icon and select the commerce tab and you will see the new features of commerce 14.x. --- [Optional] During the commerce empty project setup I faced below errors which is highlighted with the solution. Error 1: <ul> <li>Are you getting “Something Went Wrong” error when entering in commerce area?</li> </ul> <img src="/link/53d7bb6e95b548acb89fa3e9a4af4ebf.aspx" width="519" height="259" />      Solution: <ul> <li>Set the access rights for catalog root node.</li> </ul> <pre class="language-csharp"><code>public class EnableCatalogRoot { private readonly IContentLoader _contentLoader; private readonly ReferenceConverter _referenceConverter; private readonly IContentSecurityRepository _contentSecurityRepository; public EnableCatalogRoot( IContentLoader contentLoader, ReferenceConverter referenceConverter, IContentSecurityRepository contentSecurityRepository) { _contentLoader = contentLoader; _referenceConverter = referenceConverter; _contentSecurityRepository = contentSecurityRepository; } public void SetCatalogAccessRights() { if (_contentLoader.TryGet(_referenceConverter.GetRootLink(), out IContent content)) { var contentSecurable = (IContentSecurable)content; var writableClone = (IContentSecurityDescriptor)contentSecurable.GetContentSecurityDescriptor().CreateWritableClone(); writableClone.AddEntry(new AccessControlEntry(Roles.Administrators, AccessLevel.FullAccess, SecurityEntityType.Role)); writableClone.AddEntry(new AccessControlEntry(Roles.WebAdmins, AccessLevel.FullAccess, SecurityEntityType.Role)); writableClone.AddEntry(new AccessControlEntry(EveryoneRole.RoleName, AccessLevel.Read, SecurityEntityType.Role)); _contentSecurityRepository.Save(content.ContentLink, writableClone, SecuritySaveType.Replace); } } }</code></pre> <ul> <li>Register the class into Startup.cs </li> </ul> e.g. services.AddSingleton<EnableCatalogRoot>(); <ul> <li>Call the SetCatalogAccessRights() method into the SiteInitialization.</li> </ul> <img src="/link/18202b811ade427c9097a8333d914e1d.aspx" width="585" height="129" /> Now error is no more after the running the site. Error 2:  “An error occurred while starting the application”  <img src="/link/0aefa5824e0342b38b8967a812d42c53.aspx" /> Solution: Upgrade or downgrade Configuration.ConfigurationManager according to your version 5.0.0.0 or 6.0.0.0 in my case I used 5.0.0.0 version. Merry Christmas!!!2021-12-16T10:48:08.0000000Z

Blog post

Optimizely Developers Meetup India - 26th JulyMonday, July 26, 2021, 11:30 AM to 12:30 PM (IST)  RSVP: <a href="https://www.meetup.com/Optimizely-formerlyEpiserver-Meetup-India/events/279586090/">https://www.meetup.com/Optimizely-formerlyEpiserver-Meetup-India/events/279586090/</a> Agenda: Welcome and introductions. Optimizely commerce walkthrough Commerce 14.x highlights  Your presence will be highly appreciated.  2021-07-21T14:18:11.0000000Z

Blog post

Update GeoIP2 database automaticallyThe purpose of the blog to update the latest GeoIP2 database automatically. Because the GeoLite2 Country, City, and ASN databases are updated weekly, every Tuesday of the week. So we required to update the database up to date, which we can accomplish through the schedule job. About GeoIP2: MaxMind GeoIP2 offerings provide IP geolocation and proxy detection for a wide range of applications including content customization, advertising, digital rights management, compliance, fraud detection, and security. The GeoIP2 Database MaxMind provides both binary and CSV databases for GeoIP2. Both formats provide additional data not available in our legacy databases including localized names for cities, subdivisions, and countries.   Requirement: In one of my current projects, we required to read the zip code/postal code on basis of the client IP Address and populate into the address area. Similarly, you can retrieve the Country, City Name, Latitude & Longitude, Metro Code etc. Solution: <ol> <li>Create the schedule job and download GeoLiteCity.dat.gz.</li> <li>Uncompressed the file and copy the GeoLite2-City.mmdb database file on physical location which you have define in basePath.</li> <li>Read the client IP Address.</li> <li>Read the downloaded GeoLite2-City.mmdb database through DatabaseReader and search the IP address into city database and retrieve zip code/postal code.</li> </ol>   Okay, so let's do some coding for achieving the above approaches: Step1: Create the schedule job. <pre class="language-csharp"><code>public class GeoIp2DataBaseUpdateJob : ScheduledJobBase { private bool _stopSignaled; private const string GeoLiteCityFileDownloadUrl = "https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-City&suffix=tar.gz"; public GeoIp2DataBaseUpdateJob() { this.IsStoppable = true; } /// <summary> /// Called when a user clicks on Stop for a manually started job, or when ASP.NET shuts down. /// </summary> public override void Stop() { base.Stop(); _stopSignaled = true; } /// <summary> /// Called when a scheduled job executes /// </summary> /// <returns>A status message to be stored in the database log and visible from admin mode</returns> public override string Execute() { // 1. Download file var result = DownloadFile() // 2. Unzip file .Bind(UnzipFile) // 3. Replace at physical location .Bind(ReplaceCurrentFile) .Match( right => $"👍 GeoIP2 database updated successfully.", left => $"👎 GeoIP2 database update failed."); if (_stopSignaled) { return "Stop of job was called"; } return result; } private static Either<Exception, string> DownloadFile() { var licenseKey = ConfigurationManager.AppSettings["Geolocation.LicenseKey"]; var uri = new Uri(GeoLiteCityFileDownloadUrl + $"&license_key={licenseKey}"); return Prelude.Try( () => { using (var client = new WebClient()) { var tempDir = Path.GetDirectoryName(Path.GetTempPath()); var localFile = Path.Combine(tempDir, "MaxMind/GeoLite2-City.tar.gz"); var maxMindFolderPath = Path.GetDirectoryName(localFile); if (!Directory.Exists(maxMindFolderPath) && !string.IsNullOrWhiteSpace(maxMindFolderPath)) { Directory.CreateDirectory(maxMindFolderPath); } client.DownloadFile(uri, localFile); return localFile; } }) .Succ(localFile => Prelude.Right<Exception, string>(localFile)) .Fail(ex => Prelude.Left<Exception, string>(ex)); } private static Either<Exception, string> ReplaceCurrentFile(string unzippedFileName) { return Prelude.Try( () => { var maxMindDbFilePath = Path.Combine(EPiServerFrameworkSection.Instance.AppData.BasePath, "MaxMind/GeoLite2-City.mmdb"); File.Copy(unzippedFileName, maxMindDbFilePath, true); //Delete extracted folder var dir = Path.GetDirectoryName(unzippedFileName); if (Directory.Exists(dir)) { Directory.Delete(dir, true); } return unzippedFileName; }) .Succ(fileName => Prelude.Right<Exception, string>(fileName)) .Fail(ex => Prelude.Left<Exception, string>(ex)); } private static Either<Exception, string> UnzipFile(string downloadedFileName) { return Prelude.Try( () => { var dir = Path.GetDirectoryName(downloadedFileName); FileInfo tarFileInfo = new FileInfo(downloadedFileName); DirectoryInfo targetDirectory = new DirectoryInfo(dir ?? string.Empty); if (!targetDirectory.Exists) { targetDirectory.Create(); } using (Stream sourceStream = new GZipInputStream(tarFileInfo.OpenRead())) { using (TarArchive tarArchive = TarArchive.CreateInputTarArchive(sourceStream, TarBuffer.DefaultBlockFactor)) { tarArchive.ExtractContents(targetDirectory.FullName); } } var filePath = Directory.GetFiles(dir ?? string.Empty, "*.mmdb", SearchOption.AllDirectories)?.LastOrDefault(); //Delete .tar.gz file if (File.Exists(downloadedFileName)) { File.Delete(downloadedFileName); } return filePath; }) .Succ(fileName => Prelude.Right<Exception, string>(fileName)) .Fail(ex => Prelude.Left<Exception, string>(ex)); } } </code></pre> Step 2: Update the web.config settings <ol> <li>Set the database file path for geolocation provider if you are using for personalization.</li> <li>Add the basePath for updating the file on a given physical location.</li> <li>Set MaxMind license key</li> </ol> <pre class="language-markup"><code><episerver.framework> ... <geolocation defaultprovider="maxmind"> <providers> <add databasefilename="C:\Program Files (x86)\MaxMind\GeoLite2-City.mmdb" name="maxmind" type="EPiServer.Personalization.Providers.MaxMind.GeolocationProvider, EPiServer.ApplicationModules"> </add></providers> </geolocation> <appData basePath="C:\Program Files (x86)\MaxMind" /> </episerver.framework> <appSettings> ... <add key="Geolocation.LicenseKey" value="{YourLicenseKey}" </appSettings></code></pre> Step 3: Run the job and make sure the file is updating, if the code cause the error then update accordingly. Step4: Create the GeoLocationUtility class and read the database file for client IP Address. <pre class="language-csharp"><code> public class GeoLocationUtility { private static string _maxMindDatabaseFileName = "GeoLite2-City.mmdb"; public static GeoLocationViewModel GetGeoLocation(IPAddress address, NameValueCollection config) { string text = config["databaseFileName"]; if (!string.IsNullOrEmpty(text)) { _maxMindDatabaseFileName = VirtualPathUtilityEx.RebasePhysicalPath(text); config.Remove("databaseFileName"); } if (string.IsNullOrWhiteSpace(_maxMindDatabaseFileName) || !File.Exists(_maxMindDatabaseFileName) || address.AddressFamily != AddressFamily.InterNetwork && address.AddressFamily != AddressFamily.InterNetworkV6) { return null; } var reader = new DatabaseReader(_maxMindDatabaseFileName); try { var dbResult = reader.City(address); var result = GeoLocationViewModel.Make(dbResult); return result; } catch { //ignore exception } finally { reader.Dispose(); } return null; }</code></pre> Step 5: Finally, call the utility method where you want to get the zip code/postal code value such as: <pre class="language-csharp"><code> var maxMindDbFilePath = Path.Combine(EPiServerFrameworkSection.Instance.AppData.BasePath, "MaxMind/GeoLite2-City.mmdb"); var config = new NameValueCollection { {"databaseFileName", maxMindDbFilePath} }; var postalCode= GeoLocationUtility.GetGeoLocation(ipAddress, config)?.PostalCode;</code></pre> I hope you found this informative and helpful, Please leave your valuable comments in the comment box. Thanks for your visit!2021-05-04T06:49:16.0000000Z

Blog post

Extends order status in Episerver CommerceThe purpose of the blog to create a new custom order status into the Episerver commerce and display that order status into commerce manager area for purchase order. Typically, EPiServer commerce provides some default order status e.g., OnHold, PartiallyShipped, InProgress, Completed, Cancelled and AwaitingExchange but in one of my project we need to create a new order status with the name of ‘Open’ and display that order status into commerce area after the order submit or convert from cart to purchase order (_orderRepository.SaveAsPurchaseOrder(cart)). Note: The extendable order status is available in Episerver Commerce Version 13 <img src="/link/614f99ac5756479699256279b768207d.aspx" width="1016" height="352" /> Ticket Reference: The same issue has been reported in this ticket. <a href="/link/fa763174b6114902847607de46244fd6.aspx">https://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2020/1/changing-order-status-away-from-a-custom-order-status/</a> Okay, So let's solve the problem with help of below steps... Step 1: Create an order status custom helper class. <pre class="language-csharp"><code>public static class OrderStatusCustom { public static readonly OrderStatus Open = new OrderStatus(1001, "Open"); }</code></pre> Step 2:  Register the new order status into Episerver commerce initialization process. <pre class="language-csharp"><code> [InitializableModule] [ModuleDependency(typeof(EPiServer.Web.InitializationModule))] [ModuleDependency(typeof(EPiServer.Commerce.Initialization.InitializationModule))] public class CustomOrderStatusInitialization : IInitializableModule { public void Initialize(InitializationEngine context) { var customOrderStatus = OrderStatusCustom.Open; OrderStatus.RegisterStatus(customOrderStatus); } } </code></pre> Step 3: Set the custom order status for the purchase order and save it on the order submit action. <pre class="language-csharp"><code>var orderRepository = ServiceLocator.Current.GetInstance<IOrderRepository>(); var po = _orderRepository.Load<IPurchaseOrder>(orderLink.OrderGroupId); po.OrderStatus = OrderStatusCustom.Open; orderRepository.Save(purchaseOrder);</code></pre> From the step 1 to 3 we have changed the purchased order status from 'InProgress' (default) to 'Open'. Now times to display the custom order status in the commerce manager for the purchase order detail and list. Step 4: Add the order status string into the listed localization files in the format OrderStatus_[CustomOrderStatusName] <ul> <li>App_GlobalResources\Orders\OrderStrings.resx </li> <li>App_GlobalResources\SharedStrings.resx e.g.</li> </ul> Key: OrderStatus_Open  Value: Open Step 5:  The order status display process in commerce area is like a hacking process where we need to change some existing files and place their own code. <img src="/link/e6a2f579aa5348efa37a2ecf6835ce28.aspx" /> <ul> <li>Include the /Apps/Order/CustomPrimitives/OrderStatusTitle.ascx & /Apps/Order/GridTemplatesOrderStatusTemplate.ascx files into the CommerceManager project.</li> <li>Create OrderStatusTitle.cs and GridTemplatesOrderStatusTemplate.cs file and replace the code.</li> </ul> OrderStatusTitle.cs  <pre class="language-markup"><code>public class OrderStatusTitle : UserControl, IFormDocumentControl { protected Label Label8; protected Label lblOrderStatus; protected Label Label1; protected Label lblCouponCode; public void LoadControlValues(object Sender) { IOrderGroup orderGroup = (IOrderGroup)Sender; if (orderGroup == null) return; var status = (string)this.GetGlobalResourceObject("OrderStrings", typeof(OrderStatus).Name + "_" + ((OrderGroup)orderGroup).Status); if (string.IsNullOrEmpty(status)) { status = (string)this.GetGlobalResourceObject("OrderStrings", typeof(OrderStatus).Name + "_" + OrderStatusManager.GetOrderGroupStatus(orderGroup)); } this.lblOrderStatus.Text = status; } public void SaveControlValues(object Sender) { } }</code></pre> GridTemplatesOrderStatusTemplate.cs <pre class="language-csharp"><code>public class OrderStatusTemplate : Mediachase.Commerce.Manager.Apps.Order.GridTemplates.OrderStatusTemplate { protected void Page_Load(object sender, EventArgs e) { string str1 = this.DataItem is DataRowView ? "" : "[undefined]"; string str2 = string.Empty; IOrderGroup dataItem = this.DataItem as IOrderGroup; if (dataItem != null) { str1 = (string)this.GetGlobalResourceObject("OrderStrings", typeof(OrderStatus).Name + "_" + ((OrderGroup)dataItem).Status); if (string.IsNullOrEmpty(str1)) { str1 = (string)this.GetGlobalResourceObject("OrderStrings", typeof(OrderStatus).Name + "_" + OrderStatusManager.GetOrderGroupStatus(dataItem)); } List<string> source = new List<string>(); if (dataItem is IPurchaseOrder purchaseOrder) { if (purchaseOrder.HasAwaitingStockReturns()) source.Add((string)this.GetGlobalResourceObject("OrderStrings", "OrderStatus_HaveAwaitingStockReturns")); if (purchaseOrder.HasAwaitingReturnCompletable()) source.Add((string)this.GetGlobalResourceObject("OrderStrings", "OrderStatus_HaveAwaitingReturnCompletable")); if (source.Count<string>() > 0) str2 = "(" + string.Join(",", source.ToArray()) + ")"; } } this.label1.Text = str1; if (string.IsNullOrEmpty(str2)) return; this.divAdditionalStatus.Visible = true; this.label2.Text = str2; } }</code></pre> <ul> <li>Now open the OrderStatusTitle.ascx file and change the 'XXXXXXX' Inherits from the qualified namespace of commerce project e.g. QuickSilver.Commerce.Apps.Order.CustomPrimitives.OrderStatusTitle</li> </ul>          <code><%@ Control Language="C#" AutoEventWireup="true" CodeBehind="OrderStatusTitle.ascx.cs" Inherits="XXXXXXX.Apps.Order.CustomPrimitives.OrderStatusTitle" %></code> <ul> <li>Repeat the same process for GridTemplatesOrderStatusTemplate.acsx</li> </ul> RESULT : Purchase order List: <img src="/link/1653f96b80c6484192db435877eab02e.aspx" width="1001" height="173" /> Purchase order Detail: <img src="/link/c3f2635f2270473882255a3d196c2b8a.aspx" width="992" height="454" /> Enjoy the coding and share your thoughts 😊 Thanks for your visit!2021-02-22T07:09:30.0000000Z

Blog post

Multilingual cart validation message The purpose of this blog to display the cart validation messages market's language specific and make it user-friendly to the customer for the better understanding.  About the Market in Episerver Commerce? Market is a central of Episerver Commerce. A single site can have multiple markets, each with its own product catalog, language, currency, and promotions. Classes in this topic are available in the <code>Mediachase.Commerce</code> or <code>Mediachase.Commerce.Markets</code> namespaces. Problem: In one of my site, I have implemented multi-market functionality and managed the content accordingly but there is no feature to display the cart validation message in readable format to the customer for market language specific. e.g. <ul> <li>United State (en) : Display the cart validation message in English language.</li> <li>France (fr) : Display the cart validation message in French language. </li> </ul> Solution: Episerver provides a class method <code>OrderValidationService.ValidateOrder(cart)</code> to validate your cart before to save, using <code>IOrderRepository.Save(cart)</code> method. With the help of this method we make sure the cart has enough quantity, prices are correct and up-to-date, and any promotions are applied correctly. The <code>ValidateOrder(cart)</code> method returns <code>IDictionary<ILineItem, IList<ValidationIssue>> </code>validation issue per ILineItem but  <code>ValidationIssue</code> is an enum type that returns validation message in below formats which are not user-friendly and market language specific. <ul> <li>CannotProcessDueToMissingOrderStatus</li> <li>RemovedDueToCodeMissing</li> <li>RemovedDueToNotAvailableInMarket</li> <li>RemovedDueToUnavailableCatalog</li> <li>...</li> </ul> So let’s make cart validation message user-friendly in the simple way. Step 1: Create an XML file language specific and place the all possible cart validation message like below and placed into the lang folder under the site root. <pre class="language-markup"><code><?xml version="1.0" encoding="utf-8" standalone="yes"?> <languages> <language name="English" id="en"> <cart> <validation> <CannotProcessDueToMissingOrderStatus>Cannot process due to missing order status.</CannotProcessDueToMissingOrderStatus> <RemovedDueToCodeMissing>The catalog entry code that maps to the line item has been removed or changed.</RemovedDueToCodeMissing> <RemovedDueToNotAvailableInMarket>Item has been removed from the cart because it is not available in your market.</RemovedDueToNotAvailableInMarket> <RemovedDueToUnavailableCatalog>Item has been removed from the cart because the catalog of this entry is not available.</RemovedDueToUnavailableCatalog> <RemovedDueToUnavailableItem>Item has been removed from the cart because it is not available at this time.</RemovedDueToUnavailableItem> <RemovedDueToInsufficientQuantityInInventory>Item has been removed from the cart because there is not enough available quantity.</RemovedDueToInsufficientQuantityInInventory> <RemovedDueToInactiveWarehouse>Item has been removed from the cart because the selected warehouse is inactive.</RemovedDueToInactiveWarehouse> <RemovedDueToMissingInventoryInformation>Item has been removed due to missing inventory information.</RemovedDueToMissingInventoryInformation> <RemovedDueToInvalidPrice>Item has been removed due to an invalid price.</RemovedDueToInvalidPrice> <RemovedDueToInvalidMaxQuantitySetting>Item has been removed due to an invalid setting for maximum quantity.</RemovedDueToInvalidMaxQuantitySetting> <AdjustedQuantityByMinQuantity>Item quantity has been adjusted due to the minimum quantity threshold.</AdjustedQuantityByMinQuantity> <AdjustedQuantityByMaxQuantity>Item quantity has been adjusted due to the maximum quantity threshold.</AdjustedQuantityByMaxQuantity> <AdjustedQuantityByBackorderQuantity>Item quantity has been adjusted due to backorder quantity threshold.</AdjustedQuantityByBackorderQuantity> <AdjustedQuantityByPreorderQuantity>Item quantity has been adjusted due to the preorder quantity threshold.</AdjustedQuantityByPreorderQuantity> <AdjustedQuantityByAvailableQuantity>Item quantity has been adjusted due to the available quantity threshold.</AdjustedQuantityByAvailableQuantity> <PlacedPricedChanged>This item's price has changed since it was added to your cart.</PlacedPricedChanged> <RemovedGiftDueToInsufficientQuantityInInventory>Gift item has been removed from the cart because there is not enough available quantity.</RemovedGiftDueToInsufficientQuantityInInventory> <RejectedInventoryRequestDueToInsufficientQuantity>The inventory request for item has been rejected because there is not enough available quantity.</RejectedInventoryRequestDueToInsufficientQuantity> </validation> </cart> </language> <language name="French" id="fr"> <cart> <validation> <CannotProcessDueToMissingOrderStatus>Il ne peut pas être traité en raison d'un statut de commande manquant.</CannotProcessDueToMissingOrderStatus> <RemovedDueToCodeMissing>Le code d'entrée de catalogue qui correspond à l'élément de campagne a été supprimé ou modifié.</RemovedDueToCodeMissing> <RemovedDueToNotAvailableInMarket>L'article a été retiré du panier car il n'est pas disponible sur votre marché.</RemovedDueToNotAvailableInMarket> <RemovedDueToUnavailableCatalog>L'article a été retiré du panier car le catalogue de cette entrée n'est pas disponible.</RemovedDueToUnavailableCatalog> <RemovedDueToUnavailableItem>L'article a été retiré du panier car il n'est pas disponible pour le moment.</RemovedDueToUnavailableItem> <RemovedDueToInsufficientQuantityInInventory>L'article a été retiré du panier car la quantité disponible est insuffisante.</RemovedDueToInsufficientQuantityInInventory> <RemovedDueToInactiveWarehouse>L'article a été retiré du panier car l'entrepôt sélectionné est inactif.</RemovedDueToInactiveWarehouse> <RemovedDueToMissingInventoryInformation>L'article a été supprimé en raison d'informations d'inventaire manquantes.</RemovedDueToMissingInventoryInformation> <RemovedDueToInvalidPrice>L'article a été supprimé en raison d'un prix non valide.</RemovedDueToInvalidPrice> <RemovedDueToInvalidMaxQuantitySetting>L'article a été supprimé en raison d'un paramètre non valide pour la quantité maximale.</RemovedDueToInvalidMaxQuantitySetting> <AdjustedQuantityByMinQuantity>La quantité d'articles a été ajustée en raison du seuil de quantité minimale.</AdjustedQuantityByMinQuantity> <AdjustedQuantityByMaxQuantity>La quantité d'articles a été ajustée en raison du seuil de quantité maximale.</AdjustedQuantityByMaxQuantity> <AdjustedQuantityByBackorderQuantity>La quantité d'articles a été ajustée en raison du seuil de quantité de commandes en souffrance.</AdjustedQuantityByBackorderQuantity> <AdjustedQuantityByPreorderQuantity>La quantité d'articles a été ajustée en raison du seuil de quantité de précommande.</AdjustedQuantityByPreorderQuantity> <AdjustedQuantityByAvailableQuantity>La quantité d'articles a été ajustée en raison du seuil de quantité disponible.</AdjustedQuantityByAvailableQuantity> <PlacedPricedChanged>Le prix de cet article a changé depuis qu'il a été ajouté à vos favoris.</PlacedPricedChanged> <RemovedGiftDueToInsufficientQuantityInInventory>L'article cadeau a été retiré du panier car la quantité disponible est insuffisante.</RemovedGiftDueToInsufficientQuantityInInventory> <RejectedInventoryRequestDueToInsufficientQuantity>La demande d'inventaire pour l'article a été rejetée car la quantité disponible n'est pas suffisante.</RejectedInventoryRequestDueToInsufficientQuantity> </validation> </cart> </language> </languages></code></pre> Step 2: Create a model class that will hold the error message and variant code. <pre class="language-csharp"><code>public class CartValidationIssue { public string Message { get; set; } public string Code{ get; set; } public bool IsBlank => string.IsNullOrWhiteSpace(this.Message); public static CartValidationIssue Make(string message, string code) { return new CartValidationIssue { Message = message, Code = code, }; } } </code></pre> Step 3: Create described methods where you are validating your cart and returns the validation messages in the list format after reading from XML file and show on the cart page or mini-cart area. <ol> <li>Use <code>ICurrentMarket</code> interface and get the current market culture</li> <li>Make sure you have selected correct default language for the current market in commerce manager for e.g. France choose default language francais</li> </ol>  <img src="/link/1fa2f9c7ab8a4d1fa01689b17e515a0d.aspx" width="556" height="222" /> <pre class="language-csharp"><code>public List<CartValidationIssue> ValidateCart(ICart cart) { var validationResult = _orderValidationService.ValidateOrder(cart); var errors = validationResult ?.Select(lineItemIssueEntry => new { LineItemIssues = lineItemIssueEntry.Value .Select(validationIssue => new { ValidationIssueMessage = this.GetCartValidationMessage(validationIssue), LineItemCode = lineItemIssueEntry.Key.Code, }) .ToList(), }) .SelectMany(lineItemIssueGroup => lineItemIssueGroup.LineItemIssues) .Select(x => CartValidationIssue.Make(x.ValidationIssueMessage, x.LineItemCode)) .Where(x => !x.IsBlank) .ToList() ?? new List<CartValidationIssue>(); return errors; }</code></pre> <pre class="language-csharp"><code> private string GetCartValidationMessage(ValidationIssue issue) { var market = _currentMarket.GetCurrentMarket(); var cultureInfo = market.DefaultLanguage; switch (issue) { default: case ValidationIssue.None: return null; case ValidationIssue.CannotProcessDueToMissingOrderStatus: return LocalizationService.Current.GetStringByCulture("/cart/validation/CannotProcessDueToMissingOrderStatus", "It cannot process due to missing order status.", cultureInfo); case ValidationIssue.RemovedDueToCodeMissing: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToCodeMissing", "The catalog entry code that maps to the line item has been removed or changed.", cultureInfo); case ValidationIssue.RemovedDueToNotAvailableInMarket: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToNotAvailableInMarket", "The catalog entry code that maps to the line item has been removed or changed.", cultureInfo); case ValidationIssue.RemovedDueToUnavailableCatalog: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToUnavailableCatalog", "The catalog entry code that maps to the line item has been removed or changed.", cultureInfo); case ValidationIssue.RemovedDueToUnavailableItem: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToUnavailableItem", "Item has been removed from the cart because it is not available at this time.", cultureInfo); case ValidationIssue.RemovedDueToInsufficientQuantityInInventory: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToInsufficientQuantityInInventory", "Item has been removed from the cart because there is not enough available quantity.", cultureInfo); case ValidationIssue.RemovedDueToInactiveWarehouse: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToInactiveWarehouse", "Item has been removed from the cart because the selected warehouse is inactive.", cultureInfo); case ValidationIssue.RemovedDueToMissingInventoryInformation: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToMissingInventoryInformation", "Item has been removed due to missing inventory information.", cultureInfo); case ValidationIssue.RemovedDueToInvalidPrice: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToInvalidPrice", "Item has been removed due to an invalid price.", cultureInfo); case ValidationIssue.RemovedDueToInvalidMaxQuantitySetting: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedDueToInvalidMaxQuantitySetting", "Item has been removed due to an invalid setting for maximum quantity.", cultureInfo); case ValidationIssue.AdjustedQuantityByMinQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/AdjustedQuantityByMinQuantity", "Item quantity has been adjusted due to the minimum quantity threshold", cultureInfo); case ValidationIssue.AdjustedQuantityByMaxQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/AdjustedQuantityByMaxQuantity", "Item quantity has been adjusted due to the maximum quantity threshold.", cultureInfo); case ValidationIssue.AdjustedQuantityByBackorderQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/AdjustedQuantityByBackorderQuantity", "Item quantity has been adjusted due to backorder quantity threshold.", cultureInfo); case ValidationIssue.AdjustedQuantityByPreorderQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/AdjustedQuantityByPreorderQuantity", "Item quantity has been adjusted due to the preorder quantity threshold.", cultureInfo); case ValidationIssue.AdjustedQuantityByAvailableQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/AdjustedQuantityByAvailableQuantity", "Item quantity has been adjusted due to the available quantity threshold.", cultureInfo); case ValidationIssue.PlacedPricedChanged: return LocalizationService.Current.GetStringByCulture("/cart/validation/PlacedPricedChanged", "This item's price has changed since it was added to your favorites.", cultureInfo); case ValidationIssue.RemovedGiftDueToInsufficientQuantityInInventory: return LocalizationService.Current.GetStringByCulture("/cart/validation/RemovedGiftDueToInsufficientQuantityInInventory", "Gift item has been removed from the cart because there is not enough available quantity.", cultureInfo); case ValidationIssue.RejectedInventoryRequestDueToInsufficientQuantity: return LocalizationService.Current.GetStringByCulture("/cart/validation/RejectedInventoryRequestDueToInsufficientQuantity", "The inventory request for item has been rejected because there is not enough available quantity.", cultureInfo); } }</code></pre> Result: e.g. The validation message display for France(fr) market in the French language. <img src="/link/a09257ddf81f44d08058111b8f53f13c.aspx" width="668" height="307" /> Enjoy the coding and share your thoughts 😊 Thanks for your visit!2021-02-01T05:49:54.0000000Z

Blog post

Customize order management in commerce managerThe purpose of the blog to customize the order management UI in the commerce manager and handle out-of-box functionality.  In this blog I am going to cover two scenarios: <ol> <li>Display the Customer Name into the Customer Information section from the shipping address (First Name + Last Name) if the order placed by an anonymous/guest user.<img src="/link/e369a023eee4410ca7c98eed7dd61b0e.aspx" /></li> <li>Add a complete order button within the order summary section and trigger the button event.</li> </ol>         <img src="/link/86b9c45f55824a5e9c160d678c7451b0.aspx" width="653" height="265" /> The customization is based on the QuickSilver solution but you can try the recommended file and code changes in your solution. <img src="/link/5bef62b679e04d6bb48ae82a57c3dcb6.aspx" width="349" height="535" /> So, Let’s get start coding fun 😊 <h4></h4> <h3>- Display the Customer Name into the Customer Information section from the shipping address (First Name + Last Name) if the order placed by an anonymous/guest user.</h3> <ul> <li>Goto the EPiServer.Reference.Commerce.Manager site and expand the all folder as above screen and visit the folder.</li> </ul>        Folder Path: ..\EPiServer.Reference.Commerce.Manager\Apps\Order\CustomPrimitives <ul> <li>Include the OrderCustomer.ascx and add a new class with the same name e.g. ‘OrderCustomer.cs’.</li> </ul> <img src="/link/8832d4c684ab4fd1a680dcfafa26df12.aspx" width="411" height="416" /> <ul> <li>Open OrderCustomer.ascx and copy the highlighted Inherits tag value (Mediachase.Commerce.Manager.Apps.Order.CustomPrimitives.OrderCustomer)and create the OrderCustomer.cs class and derived from the inherits value.<img src="/link/a6b02b07da2045a59d26d09da1426e27.aspx" /></li> <li>Override the OnPreRender(EventArgs e) method and fetch the purchase order shipping address detail using the order helper class <pre class="language-csharp"><code>using System; using EPiServer.Commerce.Order; using Mediachase.Commerce.Manager.Apps_Code.Order; namespace EPiServer.Reference.Commerce.Manager.Apps.Order.CustomPrimitives { public class OrderCustomer : Mediachase.Commerce.Manager.Apps.Order.CustomPrimitives.OrderCustomer { protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); if (string.IsNullOrEmpty(this.lblCustomerName.Text)) { var purchaseOrder = this.OrderGroupId > 0 ? OrderHelper.GetPurchaseOrderById(this.OrderGroupId) : null; var address = purchaseOrder?.GetFirstShipment()?.ShippingAddress; if (address != null) { this.lblCustomerName.Text = $@"{address.FirstName} {address.LastName}"; } } } } } </code></pre> </li> </ul> <ul> <li>And in the last re-place the Inherits attribute value from your created class including full qualified namespace + class name.<img src="/link/a67714cd51e348c58b933b2ed1462214.aspx" /> </li> </ul> Result (1): Now refresh the purchase order and see the changes. <img src="/link/36a49e0d58fd45f8b5d88d74d2ade13b.aspx" /> <h3>- Add a complete order button within the order summary section and trigger the button event:</h3> <ul> <li>Goto the EPiServer.Reference.Commerce.Manager site and expand all folder and open the folder.\</li> </ul>         Folder path: …\EPiServer.Reference.Commerce.Manager\Apps\Order\Config\View\Forms. <ul> <li>Include the PurchaseOrder-ObjectView.xml in your solution, If you notice in this file you will find numbers are buttons are already added and display in the order summary section, so similarly add a new button with the command name ‘btn_CompleteOrderBtn’ and permissions.<img src="/link/f93ed9fef2de4074bdd01d4a3f3e288a.aspx" width="1046" height="318" /></li> </ul> Create the CompletePurchaseOrderHandler class and inherit it from the TransactionCommandHandler and override the DoCommand method. <img src="/link/64da555f1fad424c800c7eab3c8bd8d1.aspx" width="440" height="366" /> You can choose a transaction command handler on basis of the requirements e.g. purchase order, payment plan, and return form handler, etc... <ul> <li>Commerce.Manager.Order.CommandHandlers.PurchaseOrderHandlers</li> <li>Commerce.Manager.Order.CommandHandlers.PaymentPlanHandlers</li> <li>Commerce.Manager.Order.CommandHandlers.ReturnFormHandlers</li> </ul> And also enable or disable the button on basis of requirement in the given example the IsCommandEnable method enables the button if the order status is InProgress. <pre class="language-csharp"><code>namespace EPiServer.Reference.Commerce.Manager.Features.Orders.OrderProcessing.Handlers { public class CompletePurchaseOrderHandler: TransactionCommandHandler { protected override void DoCommand(IOrderGroup order, CommandParameters commandParameters) { order.OrderStatus = OrderStatus.Completed; var purchaseOrder = order as IPurchaseOrder; var shipments = purchaseOrder.GetFirstForm()?.Shipments?.ToList(); if (shipments != null) { this.ShipmentProcessor.CompleteShipment(purchaseOrder, shipments); } this.SavePurchaseOrderChanges(purchaseOrder); } protected override bool IsCommandEnable(IOrderGroup order, CommandParameters cp) { // Enable button if return order.OrderStatus.Equals(OrderStatus.InProgress) ; } } }</code></pre> <ul> <li>Register the newly created button into the commands and add a handler and confirmation text that will ask for the confirmation before performing the action.<img src="/link/5912abba34e9464b877fcfd828f9dee6.aspx" /></li> </ul> Result (2): Now build your solution and visit in the commerce area and refresh the purchase order screen, you will see a new button with the name ‘Complete Order’ and when the user clicks on the button then the order will be mark as complete. <img src="/link/11148cc0dd6447d4be2ae846de7d0422.aspx" width="925" height="383" /> Enjoy the coding and share your thoughts 😊2020-10-07T13:51:37.0000000Z

Blog post

Exclusion of the partial routed folder/category from the Geta.Seo.SitemapsPurpose of the blog to exclude routed commerce catalog folder/category content Urls from the Geta.Seo.Sitemaps sitemap.xml before to it generates. This is out of box functionality in the current Geta.Seo.Sitemaps version thus we have customized it using the`CommerceSitemapXmlGenerator` or `CommerceAndStandardSitemapXmlGenerator` class in my current project for the solution. Introduction:  This tool allows you to generate XML sitemaps for search engines to better index your EPiServer sites with some additional specific features.   <ul> <li>sitemap generation as a scheduled job</li> <li>filtering pages by virtual directories</li> <li>ability to include pages that are in a different branch than the one of the start page</li> <li>ability to generate sitemaps for mobile pages</li> <li>it also supports multi-site and multi-language environments</li> </ul>   <table> <tbody> <tr> <td><img src="/link/278b1fe0add64c2d820a201defa9dcf0.aspx" width="317" height="239" /></td> <td><img src="/link/b16fb2e5f2814c5db139cf11faccf6a8.aspx" width="783" height="385" /></td> </tr> </tbody> </table> Problem: The Geta.Seo.Sitemaps is not able to avoid the 'Services' folder Urls from the sitemap.xml because the folder is partially routed using the IPartialRouter interface. And in the URLs, the folder name does not exist like <a href="https://www.xyz.com/services/laundry/dry-clean">https://www.xyz.com/services/laundry/dry-clean</a>, <a href="https://www.xyz.com/service/laundary/normal-clean">https://www.xyz.com/service/laundary/normal-clean</a> However, the ServiceFolderPage is already inherited from IExcludeFromSitemap as below, but still not able to avoid/exclude content from the sitemap.xml. <pre class="language-csharp"><code>public class ServiceFolderPage : NodeContent, IExcludeFromSitemap { }</code></pre> Solution:  Avoid Urls e.g.  <a href="https://www.xyz.com/dry-clean">https://www.xyz.com/dry-clean</a>, <a href="https://www.xyz.com/normal-clean">https://www.xyz.com/normal-clean</a> from the generated sitemap.xml because these are services folder content URLs. 1. Create a utility class like CustomCatalogUrlFilter and pass the current language content and avoid folders list into the IsUrlFiltered method. <pre class="language-csharp"><code> public class CustomCatalogUrlFilter { private readonly IContentLoader _contentLoader; public CustomCatalogUrlFilter(IContentLoader contentLoader) { _contentLoader = contentLoader ?? throw new ArgumentNullException(nameof(contentLoader)); } /// <summary> /// Gets whether the current content should be filtered out of the Sitemap. /// </summary> public bool IsUrlFiltered(IContent page, IList<string> avoidPaths) { // If the inputs are bad, do nothing. if (page == null || avoidPaths?.Any() != true) return false; // Get the URL segments of the current page and all its ancestors. var ancestorsAndSelfRouteSegments = _contentLoader .GetAncestorsAndSelf(page) ?.OfType<IRoutable>() .Select(x => x.RouteSegment) .Where(x => string.IsNullOrWhiteSpace(x) == false) .ToList(); // If there are no route segments then something. Return false to be safe. if (ancestorsAndSelfRouteSegments?.Any() != true) return false; // Combine the route segments into a path: string pagePathUpper = string.Join("/", ancestorsAndSelfRouteSegments).ToUpperInvariant(); // Check to see whether any path to avoid exists within the current page's path. foreach (string avoidPathUpper in avoidPaths) { if (string.IsNullOrWhiteSpace(avoidPathUpper)) continue; // If the page's path contains a path to avoid, then the page should be filtered out. Return true. if (pagePathUpper.Contains(avoidPathUpper.ToUpperInvariant())) return true; } return false; } }</code></pre> 2. Create a custom sitemap XML generator class and derived from the`CommerceSitemapXmlGenerator` or `CommerceAndStandardSitemapXmlGenerator` and override `AddFilteredContentElement` method. <pre class="language-csharp"><code> public class CustomCommerceCatalogSitemapXmlGenerator : CommerceSitemapXmlGenerator { private readonly CustomCatalogUrlFilter _customCatalogUrlFilter; public CustomCommerceCatalogSitemapXmlGenerator( ISitemapRepository sitemapRepository, IContentRepository contentRepository, UrlResolver urlResolver, ISiteDefinitionRepository siteDefinitionRepository, ILanguageBranchRepository languageBranchRepository, ReferenceConverter referenceConverter, IContentFilter contentFilter, CustomUrlFilter customCatalogUrlFilter) : base( sitemapRepository, contentRepository, urlResolver, siteDefinitionRepository, languageBranchRepository, referenceConverter, contentFilter) { _customCatalogUrlFilter = customCatalogUrlFilter ?? throw new ArgumentNullException(nameof(customCatalogUrlFilter)); } protected override void AddFilteredContentElement(CurrentLanguageContent languageContentInfo, IList<XElement> xmlElements) { if (ContentFilter.ShouldExcludeContent(languageContentInfo, SiteSettings, SitemapData)) { return; } var content = languageContentInfo.Content; string url; var localizableContent = content as ILocalizable; if (localizableContent != null) { string language = string.IsNullOrWhiteSpace(this.SitemapData.Language) ? languageContentInfo.CurrentLanguage.Name : this.SitemapData.Language; url = this.UrlResolver.GetUrl(content.ContentLink, language); if (string.IsNullOrWhiteSpace(url)) { return; } // Make 100% sure we remove the language part in the URL if the sitemap host is mapped to the page's LanguageBranch. if (this.HostLanguageBranch != null && localizableContent.Language.Name.Equals(this.HostLanguageBranch, StringComparison.InvariantCultureIgnoreCase)) { url = url.Replace(string.Format("/{0}/", this.HostLanguageBranch), "/"); } } else { url = this.UrlResolver.GetUrl(content.ContentLink); if (string.IsNullOrWhiteSpace(url)) { return; } } url = GetAbsoluteUrl(url); var fullContentUrl = new Uri(url); if (this.UrlSet.Contains(fullContentUrl.ToString()) || UrlFilter.IsUrlFiltered(fullContentUrl.AbsolutePath, this.SitemapData)) { return; } // Custom code added to make sure Folder Pages are not ignored when handling paths to avoid: if (_customCatalogUrlFilter.IsUrlFiltered(content, this.SitemapData.PathsToAvoid)) return; XElement contentElement = this.GenerateSiteElement(content, fullContentUrl.ToString()); if (contentElement == null) { return; } xmlElements.Add(contentElement); this.UrlSet.Add(fullContentUrl.ToString()); } }</code></pre> Note: I am assuming the routing is already done for the folder/category content which you want to exclude from the sitemap.xml. Enjoy!2020-08-02T19:57:19.0000000Z

Blog post

Episerver A/B testing and visitor group (personalization) metadata into an analytics payload for consumption with the Google AnalyticsThe purpose of this blog post is to retrieve the real-time A/B testing and visitor group (personalization) details and feed into the Google Analytics for tracking real-time content item progress on your website. <h4></h4> <h3>A/B TESTING</h3> A/B Testing is the variations of content items and that compares which variation performs best. When A/B testing running then majors number the conversions for the A and B version, one the gets the best result then wins. Episerver CMS and Episerver Commerce each have own three conversion goals and developer can define custom conversion goals using KPI interface. A/B testing is distributed as free AddOn which you can download from NuGet but you need to add <a href="http://nuget.episerver.com/feed/packages.svc/">http://nuget.episerver.com/feed/packages.svc/</a> in Nuget package manager before download. The name of NuGet package that installs under the ~/module folder is EPiServer.Marketing.Testing after installation you need to update Episerver database schema. Episerver CMS Conversions Goals: <ol> <li>Landing page: The goal for the visitor to navigate the specify page and only click is counted as a conversion.</li> <li>Site Stickiness: The A/B test counts a conversion if a visitor goes from the target page to any other page on the site during the set time period (1-60 minutes).</li> <li>Time on Page: Visitors spend some time on the page for specifying numbers second.</li> </ol> Episerver Commerce Conversions Goals: <ol> <li>Add to cart: Create a visitor group for the specific product and then the visitor adds that product to a cart, it is counted as a conversion.</li> <li>Purchase product: If a site visitor buys the added products on the cart, then it is counted as a conversion.</li> <li>Average order: The conversion goal to track completed orders on each of the test pages. The conversion goal totals up the values of all Episerver Commerce carts created by visitors included in the A/B test. The test determines which page variant creates the highest average value for all those carts when picking a winner. If a visitor creates multiple carts, all the (purchased) carts are included in the total, which means that the visitor can “convert” many times in the test duration. On Episerver Commerce websites using different currencies, the test converts all carts to the same currency.</li> </ol> Note: <ul> <li>Developers can create own custom conversions which known as KPI (Key performance indicator)</li> <li>For the Commerce-related conversion goals, you required Episerver Commerce and then you can create commerce-related visitor groups criteria for personalization</li> </ul> <h3>PERSONALIZATION</h3> Personalization in Episerver target the website content to selected visitor groups. The personalization feature is based on customized visitor groups that you create based on a set of personalization criteria. Episerver provides two types of criteria one for CMS and another for commerce. List of CMS and Commerce visitor group criteria, you can see the difference in both. <img src="/link/bc54870ebf1b453081f56996bae0ab02.aspx" width="793" height="567" /> Let's create visitor groups (personalization) for the CMS and Commerce following the below steps. Episerver CMS visitor group <ul> <li>Go to visitor group area and click to create button</li> <li>Tap on Time and Place criteria options and drag `Time on Site` from the right section in `Drop new creation here` in the left section.</li> <li>Enter specific time in seconds e.g. 10</li> <li>Enter the visitor group name e.g. Time On-Site Visitor Group</li> <li>Click to Save.</li> </ul> <img src="/link/a6ab301b3794464d8252db15f4f8bd05.aspx" width="798" height="304" /> <h4>Episerver Commerce visitor group</h4> <ul> <li>Go to visitor group area and click to create button</li> <li>Tap on Commerce criteria options and `Product in Cart or Wish List` from the right section in `Drop new creation here` in the left section.</li> <li>Enter the specific product codes. e.g. 123456</li> <li>Enter visitor group name e.g. Add to cart visitor group</li> <li>Click to Save.</li> </ul> <img src="/link/ddf28d1fd211485695171200277f5465.aspx" width="816" height="362" /> The below screenshot is an example of the cart page AB testing where you can see CMS and Commerce related conversion goals with personalization. <img src="/link/cbd1e34ec6bf43fbbe066bd339ebb35b.aspx" width="818" height="596" /> <img src="/link/6f50a0380c004467972e95f8f09c38a3.aspx" width="814" height="531" /> <h3>CODE</h3> Using the below code you can retrieve the real-time A/B testing and visitor group (personalization) details. I have divided the code into four main part.  <ul> <li>View Model</li> <li>Factory or Service</li> <li>Controller</li> <li>Assign the payload result into Google Analytics</li> </ul> <h5>View Model</h5> Create two view models with the name AnalyticsViewModel and VisitorGroupViewModel. The AnalyticsViewModel view model is the payload response view model that returns the real-time A/B testing and personalization details into the response of payload. <pre>public class AnalyticsViewModel {      public bool AbTestRunning { get; set; }      public string AbTestId { get; set; }      public string AbTestVariant { get; set; }      public bool PersonalizationRunning { get; set; }      public string PersonalizationId { get; set; }      public string PersonalizationType { get; set; } } </pre> The VisitorGroupViewModel view model that helps to get the visitor group details into the created factory class. <pre>public class VisitorGroupViewModel { public string Id { get; set; } public string Name { get; set; } }</pre> <h5>Factory or Service</h5> Create a factory class with name AnalyticsViewModelFactory within this factory you need to inject the following dependency that I listed below which helps to get visitor group (personalization) and A/B testing variation details for the current session and feed into the payload response. <ul> <li>IVisitorGroupRepository</li> <li>IVisitorGroupRoleRepository</li> <li>ITestManager</li> </ul> <pre>public class AnalyticsViewModelFactory { private readonly IVisitorGroupRepository _visitorGroupRepository; private readonly IVisitorGroupRoleRepository _visitorGroupRoleRepository; private readonly ITestManager _testManager; public AnalyticsViewModelFactory( IVisitorGroupRepository visitorGroupRepository, IVisitorGroupRoleRepository visitorGroupRoleRepository, ITestManager testManager) { _visitorGroupRepository = visitorGroupRepository ?? throw new ArgumentNullException(nameof(visitorGroupRepository)); _visitorGroupRoleRepository = visitorGroupRoleRepository ?? throw new ArgumentNullException(nameof(visitorGroupRoleRepository)); _testManager = testManager ?? throw new ArgumentNullException(nameof(testManager)); } public AnalyticsViewModel Create(HttpContextBase httpContext) { var visitorGroups = this.GetVisitorGroupsByCurrentUser(httpContext); var visitorIds = visitorGroups?.Select(x => x.Id).ToList(); var visitorNames = visitorGroups?.Select(x => x.Name).ToList(); var activeTests = _testManager?.GetActiveTests(); var variantNames = activeTests?.Select(x => x.Title).ToList(); var testIds = activeTests?.Select(x => x?.Id.ToString()).ToList(); return new AnalyticsViewModel { AbTestRunning = activeTests?.Count > decimal.Zero, AbTestId = string.Join(",", testIds ?? new List<string>()), AbTestVariant = string.Join(",", variantNames ?? new List<string>()), PersonalizationRunning = visitorIds?.Count > decimal.Zero, PersonalizationId = string.Join(",", visitorIds ?? new List<string>()), PersonalizationType = string.Join(",", visitorNames ?? new List<string>()) }; } private List<VisitorGroupViewModel> GetVisitorGroupsByCurrentUser(HttpContextBase httpContext) { var visitorGroupList = new List<VisitorGroupViewModel>(); var user = httpContext.User; var visitorGroups = _visitorGroupRepository.List(); foreach (var visitorGroup in visitorGroups) { if (_visitorGroupRoleRepository.TryGetRole(visitorGroup.Name, out var virtualRoleObject)) { if (virtualRoleObject.IsMatch(user, httpContext)) { var viewModel = new VisitorGroupViewModel { Id = visitorGroup.Id.ToString(), Name = visitorGroup.Name }; visitorGroupList.Add(viewModel); } } } return visitorGroupList; } }</pre> <h5>Controller</h5> Create an endpoint v1/google/analytics using a controller with the name of AnalyticsController where you will inject the factory/service to load the data into the payload. <pre>  [RoutePrefix("v1/google/analytics")]   public class AnalyticsController : Controller   {         private readonly AnalyticsViewModelFactory _analyticsViewModelFactory;         public AnalyticsController(AnalyticsViewModelFactory analyticsViewModelFactory)         {             _analyticsViewModelFactory = analyticsViewModelFactory ?? throw new ArgumentNullException(nameof(analyticsViewModelFactory));         }         [HttpGet]         public JsonResult GetAnalytics()         {             return this.JsonNet(_analyticsViewModelFactory.Create(this.HttpContext));         }   }</pre> <h5>Assign the payload result into Google Analytics</h5> When you will hit the v1/google/analytics endpoint then you get a result similar like below and then pass into the Google Analytics script datalayer properties. <pre>{ "abTestRunning": true, "abTestId": "a0a77ae9-31ec-4d74-8952-32a082535bb1,29de7423-f6ba-4212-a913-34e0517ffda3", "abTestVariant": "Cart A/B Test, AboutUs A/B Test", "personalizationRunning": true, "personalizationId": "adb342d2-8ebb-4430-a305-e403c549452a", "personalizationType": "Time On Site Visitor Group" }</pre> Thanks for visiting my blog! <h5><code></code><code></code></h5>2020-03-30T08:38:05.0000000Z

Blog post