Systems and methods for dynamic SKU generation in distribution management
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.
1. A system for automating SKU management, the system comprising:
a user interface configured to receive, from a user, catalog files in two or more diverse formats;
a Catalog Transformation module configured to transform the catalog files into a standard format, predicting categorization and attribute mapping for at least one catalog item, wherein the Catalog Transformation module proposes categorization and attribute mapping utilizing iterative learning, wherein the Catalog Transformation module generates SKUs for each of the at least one catalog item, wherein each catalog item represents one or more non-transactional products, enabling the one or more products to be added to a customer cart using a Dynamic SKU Creation module, wherein the Catalog Transformation Module determines real-time pricing for the catalog item using a Global Pricing Engine (GPE), and wherein the GPE dynamically determines the real-time pricing of the at least one catalog item based on one or more of: vendor price files, market trends, and historical pricing data;
a Real-Time Data Mesh (RTDM) module for ensuring real-time data exchange and synchronization across the system components, wherein the RTDM module facilitates real-time interactions between the user and the system, wherein the RTDM module dynamically adjusts the synchronization intervals for catalog transformations and SKU creations based on detected latency variations;
a Master Data Governance (MDG) module for validating the transformed catalogs and communicating any errors back to vendors;
a Global Data Repository (GDR) for storing the validated catalogs and maintaining data integrity of the stored catalogs;
a Search Platform for indexing and retrieving the stored catalogs.
2. The system of claim 1 , wherein the user interface is a Single Pane of Glass User Interface (SPoG UI).
3. The system of claim 1 , further comprising a Dynamic SKU Creation module for generating SKUs in an ERP system for the catalog item, wherein the catalog item represents one or more non-transactional products, and wherein generating SKUs permits the one or more products to be added to a customer cart.
4. The system of claim 1 , where the GDR integrates with the RTDM module to support real-time data synchronization across the system.
5. The system of claim 1 , wherein the MDG module generates an indication to denote one or more errors occurring in a catalog transformation process associated with one or more transformed catalogs.
6. The system of claim 1 , further comprising a Global Pricing Engine (GPE) for determining real-time pricing for the catalog item.
7. The system of claim 6 , where the GPE determines the price for a product based on one or more of: vendor price files, market trends, and historical pricing data.
8. A computerized method for automating SKU management, the method comprising:
receiving, from a user, catalog files in two or more diverse formats through a user interface;
transforming the catalog files into a standard format, predicting categorization and attribute mapping for at least one catalog item utilizing iterative learning using a Catalog Transformation module;
ensuring real-time data exchange and synchronization across the system components and facilitating real-time interactions between the user and the system using a Real-Time Data Mesh (RTDM) module, wherein the RTDM module dynamically adjusts the synchronization intervals for catalog transformations and SKU creations based on detected latency variations;
validating the transformed catalogs and communicating any errors back to vendors using a Master Data Governance (MDG) module;
storing the validated catalogs and maintaining data integrity of the stored catalogs using a Global Data Repository (GDR);
indexing and retrieving the stored catalogs using a Search Platform;
generating SKUs in an ERP system for the catalog item, wherein the catalog item represents one or more non-transactional products, enabling the one or more products to be added to a customer cart using a Dynamic SKU Creation module;
determining real-time pricing for the catalog item using a Global Pricing Engine (GPE), wherein the GPE dynamically determines the real-time pricing of the at least one catalog item based on one or more of: vendor price files, market trends, and historical pricing data.
9. The computerized method of claim 8 , wherein the user interface is a Single Pane of Glass User Interface (SPoG UI).
10. The computerized method of claim 8 , further including generating SKUs in an ERP system for the catalog item, wherein the catalog item represents one or more non-transactional products, and wherein generating SKUs permits the one or more products to be added to a customer cart.
11. The computerized method of claim 8 , where the Global Data Repository (GDR) integrates with the Real-Time Data Mesh (RTDM) module to support real-time data synchronization across the system.
12. The computerized method of claim 8 , wherein the Master Data Governance (MDG) module generates an indication to denote one or more errors occurring in a catalog transformation process associated with one or more transformed catalogs.
13. The computerized method of claim 8 , further including determining real-time pricing for the catalog item using a Global Pricing Engine (GPE).
14. The computerized method of claim 13 , where the GPE determines the price for a product based on one or more of: vendor price files, market trends, and historical pricing data.
15. A non-transitory computer-readable medium having stored thereon a plurality of instructions, the plurality of instructions when executed by a processor, cause the processor to perform operations of:
receiving, from a user, catalog files in two or more diverse formats through a user interface;
transforming the catalog files into a standard format, predicting categorization and attribute mapping for at least one catalog item utilizing iterative learning using a Catalog Transformation module;
ensuring real-time data exchange and synchronization across the system components and facilitating real-time interactions between the user and the system using a Real-Time Data Mesh (RTDM) module, wherein the RTDM module dynamically adjusts the synchronization intervals for catalog transformations and SKU creations based on detected latency variations;
validating the transformed catalogs and communicating any errors back to vendors using a Master Data Governance (MDG) module;
storing the validated catalogs and maintaining data integrity of the stored catalogs using a Global Data Repository (GDR);
indexing and retrieving the stored catalogs using a Search Platform;
generating SKUs in an ERP system for the catalog item, wherein the catalog item represents one or more non-transactional products, enabling the one or more products to be added to a customer cart using a Dynamic SKU Creation module;
determining real-time pricing for the catalog item using a Global Pricing Engine (GPE), wherein the GPE dynamically determines the real-time pricing of the at least one catalog item based on one or more of: vendor price files, market trends, and historical pricing data.
16. The CRM of claim 15 , wherein the user interface is a Single Pane of Glass User Interface (SPoG UI).
17. The CRM of claim 15 , further including generating SKUs in an ERP system for the catalog item, wherein the catalog item represents one or more non-transactional products, and wherein generating SKUs permits the one or more products to be added to a customer cart.
18. The CRM of claim 15 , where the Global Data Repository (GDR) integrates with the Real-Time Data Mesh (RTDM) module to support real-time data synchronization across the system.
19. The CRM of claim 15 , wherein the Master Data Governance (MDG) module generates an indication to denote one or more errors occurring in a catalog transformation process associated with one or more transformed catalogs.
20. The CRM of claim 15 , further including determining real-time pricing for the catalog item using a Global Pricing Engine (GPE), and wherein the GPE determines the price for a product based on one or more of: vendor price files, market trends, and historical pricing data.