Dynamic SKU Generation Through Real-Time Catalog Governance

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

The global distribution industry faces challenges in managing a vast number and diversity of SKUs, including inefficiencies in creating, categorizing, pricing, and integrating virtual SKUs, manual processes leading to errors and delays, and difficulties in handling diverse data formats and vendor collaborations, which hinder operational efficiency and customer satisfaction.

Innovation Solution

A real-time and synchronous solution is provided through the Single Pane of Glass (SPoG) and Real-Time Data Mesh (RTDM) integration, offering a centralized platform for SKU generation, real-time tracking, and predictive analytics, ensuring data consistency and compliance across multiple sources.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If manual processes are used for SKU creation, categorization, and pricing, then flexibility and customization are improved, but productivity and accuracy deteriorate due to errors, inconsistencies, and delays

Engineering Contradiction:

ImproveflexibilityVSAvoidoperational efficiency

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The system performs preliminary actions by pre-defining product templates, categories, and pricing rules before actual SKU creation. This allows automated generation of SKUs based on predefined parameters, significantly improving productivity while maintaining consistency and reducing manual intervention errors

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The platform enables self-service capabilities where vendors can autonomously create and manage their own product catalogs and SKUs through standardized interfaces. This automated self-service approach improves operational efficiency while maintaining the flexibility needed for customization through configurable parameters

Inventive Principle:

Principle #25Self-service

2Adaptability or versatility

If the number of SKUs is increased to accommodate diverse vendor products, then adaptability and customer choice are improved, but device complexity and data management difficulty worsen

Engineering Contradiction:

Improveproduct diversityVSAvoidsystem complexity

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The system segments the vast SKU database into hierarchical categories, product families, and individual items. This segmentation allows the platform to manage diverse product portfolios efficiently by organizing SKUs into manageable groups with shared attributes, reducing the perceived complexity while maintaining high adaptability

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The platform implements universal data structures and standardized schemas that can accommodate diverse product types across multiple vendors. This multi-functional framework allows the same system infrastructure to handle various product categories, reducing overall system complexity while supporting extensive product diversity

Inventive Principle:

Principle #6Universality (Multi-functionality)

3Productivity

If real-time updates and synchronous processing are implemented for SKU transitions, then productivity and customer experience are improved, but use of energy and computational resources worsen

Engineering Contradiction:

Improveprocessing speedVSAvoidcomputational resources

Core Design Contradiction:

ProductivityVSUse of energy by moving object

Solution Approach 1:

The system implements periodic batch processing for certain SKU updates rather than continuous real-time processing. This approach maintains productivity for critical path operations while reducing computational resource consumption for non-critical updates, balancing speed with resource efficiency through selective real-time processing

Inventive Principle:

Principle #19Periodic action

Solution Approach 2:

The platform dynamically adjusts processing modes based on operational context, switching between real-time synchronous processing for critical SKU transitions and asynchronous batch processing for routine updates. This dynamic resource allocation optimizes both productivity and computational efficiency by matching processing intensity to actual business needs

Inventive Principle:

Principle #15Dynamics

Data Source

PatentUS20250328862A1Systems and methods for dynamic SKU generation in distribution management

Publication Date: 2025.10.23 INGRAM MICRO INC

AI summary

System and methods are provided for automated SKU management. Embodiments include a user interface for receiving diverse catalog files, a Catalog Transformation module, a Real-Time Data Mesh (RTDM) module, a Master Data Governance (MDG) module, a Global Data Repository (GDR), and a Search Platform. The Catalog Transformation module, through iterative learning, transforms catalog files to a standard format and predicts categorization and attribute mapping. The RTDM module is configured to perform real-time data exchange. The MDG module validates the transformed catalogs. The GDR stores validated catalogs, Embodiments can include a Dynamic SKU Creation module and a Global Pricing Engine for real-time pricing. Embodiments improve data accuracy and SKU management, facilitating integrated order processing and fulfillment.