Case Studies
AEM AS PIM (Product Information Management)
Background
Our Client, the largest electrical equipment companies in India was on Sitecore and wanted to migrate on to AEM. Client wanted to use AEM for Product Information Management along with Ecommerce.
Task
One of the major tasks was that they would like to manage their products and products metadata using AEM.
Client provided their products information in form of spreadsheets in MS Excel. They have arranged their products in categories, subcategories, products, variants of the products. Variants of the product was the actual products. Client was also not interested in creating pages for each and every category, sub-category, products, and variants. Requirement was that Client will upload Excel sheet in given structure using our system and pages will get populated as per uploaded data.
Solution
Our job was to provide a scalable solution which enables auto page creation according to requirement and if the user wants to add a new product he/she should be able to do that using AEM dashboard.
- For achieving this functionality, we used Catalogs feature of AEM. We created multiple scaffolds for different scenarios. We created multiple touch UI components and editable templates for these pages.
- We used AEM Tags feature for managing categories, sub-categories for products.
- We have created multiple workflows.
- We created a custom transport handler for publishing these products.
- Customize AEM coral UI to create a client dashboard.
- Created Index for better search of these products based on any value.
The final result was when an author uploads an excel sheet to our utility first it creates categories (if not exists), then it creates sub-categories (if not exists) and then creates products (if not exists) and adds final variants of the product. Once this task was executed successfully, admin got a task notification in his/her mailbox with an import success message.
Then Author goes to our catalog features and performs the rollout it creates all the pages (category, sub-category, products, and variants). Now the author can review these pages and activate based on his/her preferences.
