| Module | Input File | Data Checks |
| Masters | Store Master | 1. No 2 store IDs and names should be the same 2. All partners must have the same spelling (like amazon/amazon.com should not exist) 3. Correct list of active and inactive stores must be there 4. New Stores if present should be mentioned and enabled 5. Enable only active stores |
| Masters | Attributes Master | 1. Check for duplicates across Band- Cat -Subcat -Gender- MRP Buckets 2. Check for spelling errors across all fields( like Shorts,Short) 3. Grouping/Clustering of attributes is based on no of styles sold in the analysis period & revenue/qty sold in a particular Attribute group. Also, these attributes selected should be important for the business, should have less data missing, should not consider outliers |
| Masters | Style Master | 1. Check for duplicates and also if one style has more than one set of attributes 2. Each Brand-Cat-Subcat-Gender-MRP bucket combinations must be present in attribute masters 3. Check for 0 and -ve MRPs 4. Check for spelling errors across all fields (like Shorts, Short) |
| Masters | Category Size Sets Master | 1. Check if all sizes for a Brand-Cat-Subcat are in the same format (2D/UK sizing, S/M/L,Waist Sizes, etc.) 2. Check for size sequence 3. Check for duplicates 4. Convert cat size set column to string |
| Masters | SKU Master | 1. All skus should be unique (no 2 skus should have same Style + size combination) 2. Check for duplicates 3. All sizes should be present in Cat Size Sets 4. All styles must be present in Style masters |
| Masters | Sales Master | 1. All SKUs should be present in SKU masters 2. Revenue can not exceed MRP sales(MRP*Qty Sold) 3. Revenue and Qty can not be -ve or 0 4. All Store IDs should be present in Store Master 5. Date should be in yyyy-mm-dd format 6.Map new stores to reference stores (from analysis period) and add dummy sales for new stores if present |
| Revenue Split | AOP | 1. All Store IDs should be present in Store Master 2. Month should be in yyyy-mm format 3. Revenue can not be -ve or 0 4. Months should be forecast months (future months) 5. No of Forecast months should be same as no of rev split start & end date months |
| Distribution | Store Planogram | 1. All Store IDs should be present in Store Master 2. Planogram & Size Set values can not be -ve 3. All the Brand-Categories should be present in the attributes master 4. No duplicates should be present across Store – Brand – Category |
| Distribution | Store Stock | 1. All Store IDs should be present in Store Master 2. All SKUs should be present in SKU masters 3. Qty can not be -ve |
| Distribution | Warehouse Stock | 1. All SKUs should be present in SKU masters 2. Qty can not be -ve |
| Distribution | Category Style Size Quantity | 1. There should be no duplicates across each Brand- Cat -Subcat -Gender combination 2. Min Size Qty inputs can not be -ve |
| Distribution | Key Size Override | 1. All Store IDs should be present in Store Master 2. For each store there should be no duplicates across each Brand- Cat -Subcat -Gender combination 3. For an AG all sizes should be present in Cat Size Sets |
| Distribution | Parent Child SKU Mapping | 1. All Parent SKUs should be unique and present in SKU Master 2. All Child SKUs should be present in SKU Master as well |
| Regional Utilization | 1. Attributes 2. Styles 3. SKUs | Refer to Master file Checks |
| Regional Utilization | RU Sales | 1. Pincodes can not be blank 2. All SKUs should be in SKU masters 3. Revenue can not exceed MRP*qty Sold and cannot be 0 or -ve 4. Channel name should be consistent in Sales and Pincode -Warehouse mapping 5. Date should be in yyyy-mm-dd format |
| Regional Utilization | Partner Pincode-Warehouse Map | 1. All Partners should be present in Store Master 2. Check for spelling errors for Warehouse ID inputs 3. Pincode Values should be correct |
| Regional Utilization | Regional Warehouse Capacity | 1. Capacity can not be -ve 2. Warehouse ID should be consistent in Pincode -Warehouse mapping 3. All SKUs should be present in SKU masters |
| Regional Utilization | Regional Warehouse Stock | 1. All Warehouse IDs should be present in Partner Pincode-Warehouse Map 2. All SKUs should be present in SKU masters 3. Qty can not be -ve |
| Regional Utilization | Mother Warehouse Stock | 1. All SKUs should be present in SKU masters 2. Qty can not be -ve |
| BI Module | Returns | 1. All SKUs should be in SKU masters 2. All Store IDs should be present in Store Master 3. Revenue can not exceed MRP*qty Sold and cannnot be 0 or -ve 4. Date should be in yyyy-mm-dd format |
| BI Module | Historical AOP | 1. All Store IDs should be present in Store Master 2. Month should be in yyyy-mm format 3. Revenue can not be -ve or 0 4. Months should be historical months (past months) |
| Online Analytics | Online Analytics | 1. All Brand-Category combinations must be present in Attribute Master 2. Page views can not be -ve 3. Revenue can not exceed MRP*qty Sold and cannnot be 0 or -ve 4. Date should be in yyyy-mm-dd format |