Q: How will projects be created, at company level or for different sales channels?
A: The concept of projects has been created to provide flexibility to the organization using IRIS. Projects can be created for different brands, different channels, regions, a combination of these or any other way
based on how the roles and responsibilities of the users are in the organization. The only caveat here is that by creating a lot of projects, an organization may lose the advantage of analyzing data at a central /
Q: Is primary sales good enough for the tool or is it important to upload the secondary sales?
What if we do not have secondary sales for some of our channels?
A: It is very important to have secondary sales as an input in IRIS as that gives the actual performance and is the correct input to use for predicting demand mix. Primary sales can be misleading and do not take into consideration the secondary sales that could not happen (dead stock, returns, etc.) which directly impacts the accuracy of IRIS outputs.
Q: Do you incorporate customer returns? Is there a size which is being returned a lot? We might
reduce producing it
A: In offline, the customer physically tried, tested a product before buying. The no. of returns are relatively low. Hence the sales data is far more meaningful for analysis as opposed to returns data. In online, the customer can return the product or multiple reasons –
- The physical product was not the same as shown in catalog.
- It was not of right size
- Product got damaged during transit
- Payment problems
- Customer was not available during delivery
All these reasons do not give any clue as to whether the product was desirable or not, from a consumer PoV. Hence the system algorithms focus on what consumers opted to buy as opposed to what they returned. If still needed, it is recommended to subtract returns from sales offline before uploading the transactions.
Q: How much transaction data is required for analysis?
A: It is good to have at least a year’s data as it covers the sale trends across all months (covering seasonality) and is helpful to choose different analysis periods from the same easily basis requirements.
Q: We do not have uniform SKU codes, there are multiple SKUs of the same product
A: There is no SKU mapping feature in IRIS (It’s there in IRIS enterprise), so it has to be made sure that each product’s SKU code is unique.
Q: How is IRIS better than Microsoft Excel?
A: IRIS works on a set of patent pending algorithms in the backend which have been made after years of research on the planning and distribution done by merchandisers. This was achieved by working directly with multiple brands’ merchandising team on IRIS enterprise and identifying key areas of improving accuracy of outputs and automation. IRIS incorporates all those learning and has been made with the vision of making life as simple for merchandisers as possible with high accuracy and speed. Not to mention, all calculations done in IRIS are at a very granular level – store + product attribute group, which becomes a challenge when done manually in Excel or a similar tool, esp. When the number of stores or
product attribute groups are high.
Q: Can you integrate to the partners via API or FTP for data to automatically flow in without need to upload?
A: No, as of now IRIS does not support system integrations and inputs must be uploaded directly on the tool before usage.
Q: Why are TSV files used instead of CSV?
A: CSV files run into problems when there are special characters like comma (,) or quotes (“) in the data. TSV files can handle special characters very gracefully. Following is a video on how to use TSV files
Q: How does IRIS ensure that duplicate sales entries are not uploaded? Does it aggregate the sales data during uploads?
A: Before uploading sales data, it is always recommended to review it once offline. On upload, IRIS will aggregate the sales quantity and revenue of all transactions on the same day for the same SKU in the same store (POS). Even after the upload, it is a good practice to quickly check the sales upload report in the output section to be sure that the data looks correct.
Q: Do you consider inventory? How do you correct for availability/exposure?
A: No, IRIS does not take daily historical inventory as an input. Availability/exposure is corrected in the algorithm via a statistical technique. However, store and warehouse inventory snapshots are taken as an input before running distribution.
Q: Are algorithms the same for all kinds of industries?
A: Algorithms have been made keeping the apparel industry in focus but have worked smoothly for other sectors like cosmetics, accessories, footwear, etc.
Q: I see lesser “Percentage of Revenue” cleaned
A: Say you gave 10% value for the Max Liquidation Cleanup Cutoff %, but now you see only 8% as Percentage of Revenue Cleaned. The reason for this is that the system intelligently buckets similarly discounted data, and either includes all or none (as they are similar). This is illustrated below
So, in the above example, there is not much different really in giving 35% discount or 40% discount (they are similarly discounted). So, either all such sales should be either cleaned up together, or not cleaned up. In order not to breach the 10% criteria, the system chooses not to clean up such data. Hence you would see only 8% revenue cleaned up
Q: How is IRIS going to work for online channels? Is it even useful on that front?
A: IRIS can be used for online channels as well. Each channel can be created as a store and sales transactions can be uploaded against the same. The tool does its job of identifying top sellers, recommending size rations, projecting sales mix, splitting revenue targets and providing sales projections. If required, it can also do replenishment for each channel.
Q: How does IRIS help in selection for scenarios where orders are placed by external buyers? For example, for Shoppers Stop stores where buyers over there decide what a brand gets to keep.
A: IRIS identifies top sellers for each partner and recommends the correct mix of attribute groups in which the merchandise should be bought for each store. Since this is a data driven insight, it is important to pass on the same to the buyers when they place orders, in order to influence their decision making to improve sales which is beneficial for both the parties.
Q: Can more attributes be added to get the idea of performance and direction on what to produce
A: IRIS currently supports brand, sub-brand, gender and price bucket as the only levels of attributes, but these can be used smartly to incorporate more attributes, for example in Denims, Fit can be incorporated by creating Slim fit Jeans as a sub category within Denims. If there is a requirement for more detailed accuracy – including more attributes, it is recommended to move to IRIS enterprise which is capable of handling up to 17 attributes
Q: Business does not have a concept of NOOS, is it mandatory to have NOOS or can we get predictions across fashion clusters only?
A: The tool can identify top sellers and it is recommended to reorder the same, but it is completely a
user’s call to take advantage of this insight.
Q: What if we changed the size measurements in between? For example, the size measurement is now a S size measurement?
A: In cases like these if the changes in size measurements are linkable from size to size, it is recommended to update the historical sizes as new sizes. If that is not possible, then there is a flexibility of selecting a specific analysis period where a user can choose a period where the new sizes are selling.
Q: Different brands and different categories have different pricing strategies (across EOSS/full price/online discounting). Then how does the liquidation strategy work?
A: IRIS works at an attribute group + store level which is more levels below the brand – category level. So, the liquidation cleanup of historical data analyzed also happens at those levels and the price bucket mix within a brand – category – sub-category is also given as an output which can be used to correct pricing strategies directionally. As far as different periods are concerned, IRIS gives the flexibility to the user to choose the analysis period for every output, so a person can choose a historical EOSS period for
future EOSS prediction and likewise for full price.
Q: Does this tool forecast demand for a new category to be launched?
A: No, the tool can only forecast for categories present historically.
Q: For how many months in the future should the AOP be uploaded?
A: For as many months the sales mix projection (revenue split) is required.
Q: Tool is quite relevant for brands that have their own EBOs as they can use it for distribution, as they will have complete control on what stocks to send to stores, and if they are doing it manually.
A: Yes, for one’s own store control on execution is 100% but even for external partners, IRIS is useful to keep a check and validate the allocations and replenishment. It has been helpful in the past to highlight gaps and course correct the stock situation even at partner stores of brands on IRIS.
Q: How does IRIS maintain correct merchandise assortment at stores while allocating/replenishing styles based on individual style performance? Is it possible that the last style allocated for a store-category due to planogram gap constraint is a lower ranked style instead of another available higher ranked style?
A: This is one of the USPs of IRIS where IRIS takes the planogram input from the user at a store-category level and intelligently breaks it down in the backend in the right assortment of product attribute groups. Due to this the planogram constraints work at a level below category. This ensures that if there are two styles of different sales performance, but one of them is more important to complete the recommended assortment, then that style is given priority for allocation. This check is dropped if the overall planogram input is still not met and the tool ensures that the stocks are ultimately fulfilled at a store-category level planogram.
Q: How to avoid allocation of old season styles?
A: Simply remove them from whstock (Warehouse Stock) file, before uploading it
Q: How to prevent broken styles during allocation?
A: The system tries its best to do allocation in a manner where only non-broken styles go first to the stores. If the stores remain empty, then it tries to allocate styles which have good quantity left in the warehouse, but have sizes missing. If you do not want your first allocation to contain any broken styles, you can simply remove these from the output.
Q: How can I create a planogram for online channels?
A: As online channels do not have any display constraints, creating a planogram is not based on physical constraint but based on forward inventory that the business wants to carry. So, for example a
subcategory of polo T-shirt, if you project to sell 300 pieces per month on the channel and you want to keep a forward cover of 3 months inventory with the channel. Then your planogram will be 300*3 = 900 pieces.
As a brand if you plan to keep 50 pieces in each style, this will become the size set for polo T-shirt.
Q: Does the tool support multi-warehouse set-up? For example, the demand of Haryana/Karnataka warehouses in terms of taste of customers/size ratios might be different. Can this tool help understand the demand across different warehouses?
A: IRIS does not support multi-warehouse distribution and warehouse to warehouse transfers. IRIS enterprise can handle a multi-warehouse to store distribution but that too has limitations on warehouse to warehouse transfers. As far as understanding demand patterns (attribute group mix and size) is concerned, that can be easily provided by IRIS, given that the inputs are also provided at the same level.
Q: Does the tool ensure that size continuity is maintained while allocation and broken styles are not allocated to the stores?
A: Yes, the tool automatically identifies through set logic if a style is healthy enough to be allocated and a minimum x number of key sizes are present and continuous.
Q: While distributing is there a feature for coordinates (sending a top/a skirt together) ?
A: No, such a feature is not there in the tool as it does all the distribution based purely on merit of individual styles and recommended assortment for each store.
Q: Does IRIS ever breah planogram in distribution?
A: No, IRIS will never exceed a store-category level planogram constraint.
Q: If we want to do a new allocation basis historical period and replenishment basis in-season, can we have two different analysis periods?
A: Yes, you have to select the analysis period in distribution for new allocation and replenishment period
for in-season replenishment before running distribution.
Q: Do you consider the expiry date of products? Does it handle the FIFO distribution?
A: No, IRIS does not take expiry dates of products as an input
Q: Will this work for primary replenishment (distributor to channel partners) and secondary replenishment (partners to end consumers)?
A: IRIS will work best where secondary sales data and store inventory is available. In most cases of distribution, this information is difficult to get – not to mention the stock visibility at the distributor’s warehouse is another complication which as of now IRIS does not handle.
Q: instead of the number of pieces, can we input DOH cover in a planogram?
A: no, currently the tool takes only quantity in pieces as the capacity constraint in the planogram. A user can convert the DOH cover in pieces and upload before running distribution. In case the user needs the tool to help create planogram basis DOH input, then that feature is available in the Enterprise version of IRIS.
Q: Apart from product outputs, are there reports where we can see the brand’s own data?
A: yes, there is a separate BI module in the product which where a set of reports are there for analyzing the brands’ actual sales data. These reports have been made keeping in mind the key insights a user would like to draw from the data uploaded on IRIS and cover most possible views of importance. In case a user feels there is a need for an additional view, he/she can reach out to IRIS customer support and if the team finds it as an important and doable view, it can be added.