Select a site

IMPORTANT: This version of Sitefinity CMS is out of support and the respective product documentation is no longer maintained and can be outdated. Use the version selector to view a supported product version.

Products do not show in both the frontend and backend

In Sitefinity CMS 6.0 Ecommerce, a product life cycle is introduced. You can have a product in draft (master) and live mode. This is a breaking change with respect to how you manage Products. If products are not showing up in both the frontend and the backend, probably an error has occurred during the upgrade process. Please use the following script to recover your products:

using System;
using System.Collections.Generic;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Telerik.Sitefinity.Ecommerce.Catalog.Model;
using Telerik.Sitefinity.Modules.Ecommerce.Catalog;
using Telerik.OpenAccess;
using Telerik.Sitefinity.Services;
using Telerik.Sitefinity.GenericContent.Model;
namespace Telerik.Sitefinity.Documentation.CodeSnippets.DevGuide.ChangesAndBackwardCompatibility.BreakingChangesSF6_0.ECommerce
{
public partial class EcommerceBreakingChangesSF6_0
{
private void UpdateExistingProductsWithoutLifecycleSupport()
{
List<Guid> inactiveProducts = CreateMasterProductsFromLiveOnes();
PublishAllMasterProducts();
UnpublishTheNotActiveProducts(inactiveProducts);
}
private void UnpublishTheNotActiveProducts(List<Guid> inactiveProducts)
{
using (var catalogManager = CatalogManager.GetManager())
{
var products = catalogManager.GetProducts().Where(p => p.Status == ContentLifecycleStatus.Live);
int skip = 0;
int take = 100;
int currentCount = 0;
int totalCount = products.Count();
while (currentCount < totalCount)
{
var chunkedProducts = products.Skip(skip).Take(take);
skip = skip + take;
currentCount = skip;
foreach (var productLive in chunkedProducts)
{
try
{
//all inactive old versions should be made invisible.
if (inactiveProducts.Contains(productLive.OriginalContentId))
{
var publishedTranslations = new List<string>(productLive.PublishedTranslations.ToList());
if (publishedTranslations.Count() > 0) //unpublish for each translation
{
foreach (var publishedTranslation in publishedTranslations)
{
catalogManager.Lifecycle.Unpublish(productLive, new CultureInfo(publishedTranslation));
catalogManager.Provider.FlushTransaction();
}
}
else //unpublish invariant only
{
catalogManager.Lifecycle.Unpublish(productLive, SystemManager.CurrentContext.AppSettings.DefaultFrontendLanguage);
catalogManager.Provider.FlushTransaction();
}
catalogManager.SaveChanges();
}
}
catch (Exception innerEx)
{
}
}
}
}
}
private void PublishAllMasterProducts()
{
using (var catalogManager = CatalogManager.GetManager())
{
var products = catalogManager.GetProducts().Where(p => p.Status == ContentLifecycleStatus.Master);
int skip = 0;
int take = 100;
int currentCount = 0;
int totalCount = products.Count();
while (currentCount < totalCount)
{
var chunkedProducts = products.Skip(skip).Take(take);
skip = skip + take;
currentCount = skip;
foreach (var productMaster in chunkedProducts)
{
try
{
var publishedTranslations = productMaster.PublishedTranslations;
if (publishedTranslations.Count() > 0) //publish for each translation
{
foreach (var publishedTranslation in publishedTranslations)
{
catalogManager.Lifecycle.Publish(productMaster, new CultureInfo(publishedTranslation));
catalogManager.Provider.FlushTransaction();
}
}
else //publish for default
{
catalogManager.Lifecycle.Publish(productMaster, SystemManager.CurrentContext.AppSettings.DefaultFrontendLanguage);
catalogManager.Provider.FlushTransaction();
}
catalogManager.SaveChanges();
}
catch (Exception innerEx)
{
}
}
}
}
}
private List<Guid> CreateMasterProductsFromLiveOnes()
{
List<Guid> notActiveProducts = new List<Guid>();
Guid currentUserId = Telerik.Sitefinity.Security.SecurityManager.GetCurrentUserId();
using (var catalogManager = CatalogManager.GetManager())
{
var products = catalogManager.GetProducts().Where(p => p.Status == Telerik.Sitefinity.GenericContent.Model.ContentLifecycleStatus.Live && p.OriginalContentId == null); // yes it should be null not Guild.Empty
foreach (Product productLive in products)
{
productLive.Status = Telerik.Sitefinity.GenericContent.Model.ContentLifecycleStatus.Master;
var isActiveLegacy = productLive.FieldValue<bool>("isActive");
//we cannot use reflection because open access has not populated the field yet so (bool)typeof(Product).GetField("isActive", BindingFlags.NonPublic | BindingFlags.Instance).GetValue(productLive) will always return false
if (!isActiveLegacy) //TODO use the internal method because the property IsActive now uses lifecycle
{
notActiveProducts.Add(productLive.Id);
productLive.ApprovalWorkflowState = "Unpublished";
}
else
{
productLive.ApprovalWorkflowState = "Published";
}
if (currentUserId != Guid.Empty)
{
productLive.Owner = currentUserId;
productLive.OriginalOwner = currentUserId;
}
}
catalogManager.SaveChanges();
}
return notActiveProducts;
}
}
}
view raw ProductsVisibilityFrontendAndBackend.cs hosted with ❤ by GitHub

Back To Top

Next: Publish menu does not show up when creating or editing a product