Query product variations

Query a variation of a product by a property

To query a single variation, you must perform the following:

  1. Get an instance of the catalog manager.
    Get an instance of the CatalogManager object.
  2. Get the specified variation.
    To get the specified variation, you must either call the GetProductVariation method of the manager and pass the ID of the variation as an argument, or call the GetProductVariations method and filter the collection by one of the properties of the variation (e.g. Sku).

Use the following code samples to query a single variation by ID and by SKU:

Query variation by ID

using System;
using Telerik.Sitefinity.Ecommerce.Catalog.Model;
using Telerik.Sitefinity.Modules.Ecommerce.Catalog;
namespace SitefinityWebApp
{
public class GetVariationByID
{
public static ProductVariation GetProductVariationById(Guid id)
{
CatalogManager catalogManager = new CatalogManager();
ProductVariation variation = catalogManager.GetProductVariation(id);
return variation;
}
}
}

Query variation by SKU

using System.Linq;
using Telerik.Sitefinity.Ecommerce.Catalog.Model;
using Telerik.Sitefinity.Modules.Ecommerce.Catalog;
namespace SitefinityWebApp
{
public class GetVariationBySKU
{
public static ProductVariation GetProductVariationBySku(string sku)
{
CatalogManager catalogManager = new CatalogManager();
ProductVariation variation = catalogManager.GetProductVariations().Where(v => v.Sku == sku).SingleOrDefault();
return variation;
}
}
}

Query the variations of a product by the ID of the product

To query variations by a specified product, you must perform the following:

  1. Get an instance of the catalog manager.
    Get an instance of the CatalogManager object.
  2. Get the variations.
    To get the variations, you must call the GetProductVariations method and pass the ID of the product as an argument.

Use the following code sample:

using System;
using System.Collections.Generic;
using System.Linq;
using Telerik.Sitefinity.Ecommerce.Catalog.Model;
using Telerik.Sitefinity.Modules.Ecommerce.Catalog;
namespace SitefinityWebApp
{
public class GetVariationByProduct
{
public static List<ProductVariation> GetProductVariationsByProduct(Guid productId)
{
CatalogManager catalogManager = new CatalogManager();
List<ProductVariation> variations = catalogManager.GetProductVariations(productId).ToList();
return variations;
}
}
}

Query all variations

To query all variations, you must perform the following:

  1. Get an instance of the catalog manager.
    Get an instance of the CatalogManager object.
  2. Get the variations.
    To get the variations, you must call the GetProductVariations method.

Use the following code sample:

using System.Collections.Generic;
using System.Linq;
using Telerik.Sitefinity.Ecommerce.Catalog.Model;
using Telerik.Sitefinity.Modules.Ecommerce.Catalog;
namespace SitefinityWebApp
{
public class GetAllVariations
{
public static List<ProductVariation> GetProductVariations()
{
CatalogManager catalogManager = new CatalogManager();
List<ProductVariation> variations = catalogManager.GetProductVariations().ToList();
return variations;
}
}
}

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?