Dynamic SKU Generation With Real-Time Catalog Validation

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing distribution platforms face challenges in managing a vast number and diversity of SKUs, leading to inefficiencies, errors, and delays in SKU creation, categorization, pricing, and integration, particularly in the context of diverse vendors and evolving consumer expectations, with a need for real-time and synchronous solutions.

Innovation Solution

The implementation of a Single Pane of Glass (SPoG) platform integrated with a Real-Time Data Mesh (RTDM) provides a centralized, user-friendly interface for real-time data exchange and analytics, enhancing supply chain visibility, inventory management, and compliance, leveraging predictive analytics and flexible, scalable design to adapt to changing business needs.

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:

Improveflexibility and customizationVSAvoidproductivity and accuracy

Core Design Contradiction:

Adaptability or versatilityVSProductivity

Solution Approach 1:

The system enables automated self-service for SKU creation, categorization, and pricing through AI/ML algorithms that automatically generate SKUs, categorize products, and compute prices without manual intervention, thereby maintaining flexibility while dramatically improving productivity and accuracy

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system dynamically changes parameters such as SKU attributes, categorization rules, and pricing factors in real-time based on market conditions and vendor data, allowing flexible adaptation while maintaining high productivity through automated parameter management

Inventive Principle:

Principle #35Parameter changes

2Adaptability or versatility

If the platform handles a vast number and diversity of SKUs, then adaptability and versatility are improved, but device complexity and data consistency deteriorate

Engineering Contradiction:

Improvehandling capacity for SKU diversityVSAvoidplatform complexity and data consistency

Core Design Contradiction:

Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The platform segments SKU management into modular components including virtual SKU generation, real-time validation, categorization modules, and pricing engines, allowing it to handle vast SKU diversity while maintaining manageable complexity through organized data structures and processing pipelines

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The system introduces intermediary layers including a data mesh architecture and AI/ML validation layers that mediate between diverse vendor data sources and the core platform, ensuring data consistency while handling extensive SKU diversity without proportionally increasing complexity

Inventive Principle:

Principle #24Intermediary (Mediator)

3Productivity

If real-time and synchronous solutions are implemented, then productivity and customer experience are improved, but use of energy and computational resources increase

Engineering Contradiction:

Improvereal-time processing capabilityVSAvoidcomputational resources and energy consumption

Core Design Contradiction:

ProductivityVSUse of energy by moving object

Solution Approach 1:

The system performs preliminary actions by pre-generating virtual SKUs, pre-validating data formats, and pre-computing pricing rules before actual transactions occur, enabling real-time responsiveness while reducing computational load during critical processing moments

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The platform implements periodic batch processing for non-critical updates alongside real-time processing for critical operations, optimizing resource utilization by handling different data types at appropriate frequencies rather than continuously

Inventive Principle:

Principle #19Periodic action

4Adaptability or versatility

If virtual SKUs are transitioned to actual SKUs upon order placement, then adaptability is improved, but reliability and data consistency deteriorate due to delays and inconsistencies

Engineering Contradiction:

Improvedynamic SKU transition capabilityVSAvoiddata consistency and processing reliability

Core Design Contradiction:

Adaptability or versatilityVSReliability

Solution Approach 1:

The system performs preliminary validation and preparation of virtual SKUs before order placement, pre-computing necessary data and validating formats in advance, ensuring that the transition to actual SKUs is reliable and consistent without delays

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The platform implements feedback mechanisms that continuously monitor the virtual-to-actual SKU transition process, detecting and correcting inconsistencies in real-time, thereby maintaining high reliability and data consistency while preserving adaptive transition capabilities

Inventive Principle:

Principle #23Feedback

Data Source

PatentUS12373786B2Systems and methods for dynamic SKU generation in distribution management

Publication Date: 2025.07.29 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.