DMart Merchandiser Interview: Rounds, Questions and Preparation

What the job involves

A merchandiser in e-commerce, retail and D2C plans and manages product assortments to balance customer demand, sales targets and inventory health. Day to day, they analyse sales data, coordinate with vendors and internal teams, plan promotions or launches, and ensure products are priced and stocked competitively. At large retailers like DMart, the role focuses on high-volume categories, cost control and fast-moving inventory.

Role and sector knowledge

1. 1

   What does a merchandiser do differently in an e-commerce or D2C company compared to a brick-and-mortar retailer like DMart?

   Highlight online factors like digital shelf, search ranking, product content and returns, versus offline factors like planogram, footfall and shelf space.

2. 2

   How would you decide the ideal product mix for a new category launch on an online marketplace?

   Talk about demand research, competitor pricing, margin targets, assortment width vs depth, and test launches with small quantities.

3. 3

   Explain the term GMROI and why it matters for a merchandiser.

   Define Gross Margin Return on Inventory Investment and explain how it links profitability to inventory efficiency.

4. 4

   What are the key differences between private label and national brand merchandising?

   Cover margin advantages, control over pricing and supply, customer trust, and shelf or search placement strategies.

Technical and practical skills

1. 5

   A product has a cost price of Rs 200 and you want a 25 percent margin on selling price. What should be the selling price?

   Show calculation: SP = CP / (1 - margin). So 200 / 0.75 = Rs 266.67. Explain the difference between margin on cost and margin on selling price.

2. 6

   How would you use Excel to track slow-moving inventory across 50 stores?

   Mention pivot tables, conditional formatting, formulas like SUMIFS and VLOOKUP, and creating an ageing report with days of inventory.

3. 7

   What is planogram and how does it affect sales in a retail store?

   Define planogram as a visual layout of products on shelves and explain how placement impacts visibility, impulse buying and space productivity.

4. 8

   How do you calculate inventory turnover ratio and what does a low ratio indicate?

   Formula: Cost of goods sold divided by average inventory. Low ratio means slow sales, overstocking or poor assortment, leading to higher holding costs.

Scenario based questions

1. 9

   A best-selling product is suddenly out of stock across your top 10 online SKUs. What steps would you take?

   Cover immediate actions like checking supplier lead time, expediting replenishment, offering substitutes, and communicating with customers or updating listings.

2. 10

   Your category sales are declining by 15 percent month on month. How would you diagnose and fix it?

   Analyse data by SKU, price, competitor activity, seasonality and customer reviews. Suggest actions like price correction, promotion, assortment change or vendor switch.

3. 11

   A vendor increases prices by 10 percent just before a festive sale. How do you handle it?

   Negotiate on volume commitment, explore alternate vendors, adjust selling price or margin, and plan promotions to protect sales without hurting profitability.

4. 12

   You have limited shelf space but must add 20 new SKUs. How would you decide what to remove?

   Use sales velocity, margin contribution, customer demand and strategic importance. Remove low-turn, low-margin items and test new SKUs in limited stores or online first.

Behavioural and HR questions

1. 13

   Tell me about a time you had to convince someone to change their decision using data.

   Use STAR method: situation, task, action, result. Show how you presented numbers clearly and achieved a positive outcome.

2. 14

   Why do you want to work as a merchandiser in retail or e-commerce, and why our company?

   Connect your interest in product, data and customer behaviour to the company's scale, format or D2C model. Mention specific categories or recent initiatives.

3. 15

   This role often requires working on weekends and during festive sales. How do you manage pressure and deadlines?

   Give examples of handling multiple tasks, prioritising, staying calm and communicating proactively. Show willingness to adapt to retail peak seasons.

4. 16

   Describe a time you worked in a team to achieve a target. What was your contribution?

   Focus on your specific role, coordination with others, and measurable result. Avoid saying 'we' without clarifying what you personally did.