Model product stock

Advanced license required

Features described on this page require the Xperience by Kentico Advanced license tier.

Product stock management is a critical component of any commerce system. This page covers key considerations for implementing a product stock model in Xperience by Kentico.

The product stock model manages the relationship between products and their available quantities. It provides functionality to track, update, and display stock levels while handling various business scenarios such as purchases, returns, and restocking. We recommend that you implement the product stock model as a custom module to ensure flexibility and maintainability.

This page provides basic requirements for implementing stock management. While the current text focuses on the basic architecture and design patterns, we’re working on expanding this documentation with code samples and more detailed scenarios.

Product stock module

Create a custom module to handle product stock information. The module should include the following fields:

  • Product SKU – unique identifier linking to the product
  • Product stock value – current quantity available for purchase

Depending on your requirements, you may use a simple implementation with just product SKU and product stock value, or a more complex model that also includes fields such as reserved stock for pending orders and minimum threshold value.

Management interfaces

Create the following UI pages to manage product stock:

  • Listing page – create a listing interface to display product stock information: product name, SKU, and current stock levels
  • Edit page – provide an interface for administrators to manage stock records

Product stock creation

Automatic stock creation

Consider implementing automatic stock creation when new products are added:

  • Set up event handlers for product creation
  • Initialize default stock values based on business rules
  • Ensure proper data consistency between products and stock

Manual stock creation

Provide administration interface for manual stock creation and management:

  • Create an interface where administrators can create new stock records
  • Consider adding bulk operations for mass stock updates

Business logic implementation

Purchase transactions

Handle stock reduction when products are purchased.

Returns and restocking

Implement logic for increasing stock levels when products are returned or restocked:

  • Handle product returns by adding quantities back to available stock
  • Process restocking operations with proper validation

Stock reservations

Consider managing temporary stock allocations for pending orders:

  • Reserve stock during the checkout process
  • Release reservations for abandoned carts
  • Convert reservations to actual purchases upon order completion

Validation and business rules

Implement product stock validation and business rules to ensure data integrity:

  • Negative stock prevention – ensure stock levels cannot go below zero
  • Threshold alerts – consider generating notifications when stock falls below minimum levels
  • Concurrent access handling – prevent race conditions during simultaneous stock updates
  • Data integrity checks – validate relationships between products and stock records

Display product stock

Display product stock information to customers on the live site:

  • In-stock indicators – display indication whether a product is available for purchase
  • Quantity selectors – prevent customers from selecting more items than are in stock
  • Low stock warnings – consider alerting customers when quantities are limited and encourage them to purchase soon