1. Home
  2. Iris X
  3. Getting started
  4. Data Checks

Data Checks

ModuleInput FileData Checks
MastersStore Master1. 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
MastersAttributes Master1. 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
MastersStyle Master1. 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)
MastersCategory Size Sets Master1. 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
MastersSKU Master1. 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
MastersSales Master1. 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 SplitAOP1. 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
DistributionStore Planogram1. 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
DistributionStore Stock1. All Store IDs should be present in Store Master
2. All SKUs should be present in SKU masters
3. Qty can not be -ve
DistributionWarehouse Stock1. All SKUs should be present in SKU masters
2. Qty can not be -ve
DistributionCategory Style Size Quantity1. There should be no duplicates across each Brand- Cat -Subcat -Gender combination
2. Min Size Qty inputs can not be -ve
DistributionKey Size Override1. 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
DistributionParent Child SKU Mapping1. All Parent SKUs should be unique and present in SKU Master
2. All Child SKUs should be present in SKU Master as well
Regional Utilization1. Attributes
2. Styles
3. SKUs
Refer to Master file Checks
Regional UtilizationRU Sales1. 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 UtilizationPartner Pincode-Warehouse Map1. All Partners should be present in Store Master
2. Check for spelling errors for Warehouse ID inputs
3. Pincode Values should be correct
Regional UtilizationRegional Warehouse Capacity1. 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 UtilizationRegional Warehouse Stock1. 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 UtilizationMother Warehouse Stock1. All SKUs should be present in SKU masters
2. Qty can not be -ve
BI ModuleReturns1. 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 ModuleHistorical AOP1. 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 AnalyticsOnline Analytics1. 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
Was this article helpful to you? Yes No

How can we help?