Skip to main content

OOTB Abandoned Cart Marketing Automation Campaigns Not Shown In The List

Hey All,

It has been little while now i wrote my last blog, i have so many pending blogs to write, i will commit myself to write those in coming months

But today, i will be sharing some small but useful information regarding marketing automation templates not showing even if all settings and installations are fine

Following is the whole scenario which i was facing and had no clue until i found the actual reason why those campaigns did not show up

Marketing Automation Campaign
Ok, so i had a task to modify and use existing OOTB Abandoned Cart Campaigns and utilize and change them to allow some customized business logic.

So generally when you install SXA tenant site with commerce they come installed by default and can be seen in the campaigns list.

But in our scenario everything was working but the campaigns were not coming in the lists, there was nothing in the log as technically there were not errors (which i came to know after troubleshooting which i will mention later in the blog)

Problem
Even if everything looked fine and all commerce abandoned cart templates were installed, still the OOTB campaigns were not seen in the list of campaigns in "Marketing Automation" list.

 

So i tried following things

  • I reinstalled those commerce campaign packages for my site tenant by removing them form the site and again installing it but no luck, it just did not show up, installation was fine, it was showing that they are installed
  • I tried running commerce installation script (partial script just to install that campaign packages script), but script was successful but no luck (My senior and multiple times sitecore MVP brijesh patel suggested me this, which was a good pointer to look into as well.)
  • Tried looking into marketing automation services logs,  Restarted it
  • Verified certificates but all things were fine
  • Checked config files for connection string to make sure the user is there and has access to marketing automation service and everything looked just good as otherwise all things of the sites were working just fine

Solution

After trying different things with no luck, i tried to see what AJAX call it is making to get the list and thought to see the DLL code from where it is getting the list.

If you observer the below screenshot, one thing caught my eyes were it was passing the culture with the AJAX request as en-US see below screenshot



And in one of our other environment it was showing the list, so i checked what parameters are being passed there, and surprisingly there was different language culture was being passed as "en" and not "en-US" like following

So just to try, i copied the URL in a browser and tried to hit it with only "en" as a culture and not "en-US" and it showed the json response with all the campaigns like following




So i concentrated my search around that to find from where it is passing that as that was the only difference i could figured out

and found out that it is the language setting of a user who is logged in, so i saw the setting in sitecore user manager for that user and surprisingly i found that for that only user the culture was "en-US"



I changed the setting to "Default" from "en-US" and saved and just refreshed the marketing campaigns list page and was happy to see the campaigns are back :)



As i said Small but very useful information

I hope if you come across something, this blog will at least save you some time

Comments

Popular posts from this blog

High CPU to completely normal CPU - SXA issue, SXA pages not loading in mobile device

  Hi Team, Today i am going to share one of the nightmarish issue with you all, We are having Sitecore 9.1.1 hosted in azure PaaS environment Our site was working just fine and no noise, but we have been working on a feature release where 7-8 months of development needed to be released to production, Big GO LIVE event right?  Also to make the development smoother we also introduced BLUE/GREEN deployment slots in the same release, so we can easily SWAP slots and go live Everything went well, we went live, we even did load and performance testing on our staging and pre-prod and we were confident enough of results Very next day we started getting "SITE DOWN" alerts, and also product owners and clients mentioned that site is very slow for them in US time and in our morning when we were accessing it, it was working lighting fast so we were clue less at start, but we started digging  1) First thing caught our eyes were HIGH CPU spikes, in US time, also without any traffic CPU u...

Error in Sitecore 10.3 XM with CDs - Could not find configuration node: database/database[@id='master']

Hi Team, Recently we came across two distinct scenarios with same error message.  1) We started getting below error when we try to hit our layout service API endpoint. If we hit end point of CM, it was working fine and when we try to hit end point of CD it was giving this error, It was clear there is something in backend expecting master DB instead of WEB DB In first scenario my colleague  Jatin  also got same issue while setting up docker instance for 10.3, and my friend  Akshay Barve  and I had the same observation. 2) Second scenario I was having the same exception, It was another project on 10.3 XM with CD, It was one of the migration project so we were migrating from 10.2 to 10.3, Older site was not giving any error but new site the moment we hit, it was giving same exception in the log Issue in second scenario was in site grouping there was only site and both CM and CD URLs were given in host name and had WEB db as database, so basically there was no previ...

Solved !!! - Integrate lotus notes to third parties APP using interop.domino.dll COM API using C#

First of all before writing anything about this integration, i would like to say, i tried...tried..tried...so many times using the COM but couldn't succeeded and there were lot of things which needed to be understood just to make it work, Also the question i had was there is no documentation on IBM for C# COM API, but a good documentation on JAVA and C , so i was also not sure if this DLL would work? or we need some other way like ODBC or xPages or Webservice etc? But i think "In IT, you should read your intuitions, that is where answer lies, because they are shouting from your experience.", Because i noticed that DLL has all the required classes and properties etc. and it has same methods as shown in JAVA docs on IBM, so i was sos sure this is the DLL that would 200% work (i went into this thought process because i tried for 3 days without any luck, and later i found domino also has a web service which can be generated from domino designer etc., if i would have gone o...