Tata Cliq Luxury Merchandiser Interview: Rounds, Questions and Preparation

What the job involves

A merchandiser in e-commerce, retail or D2C manages the product lifecycle from assortment planning to pricing, inventory and sell-through. Day to day you work with buying, marketing, operations and vendors to ensure the right stock is available at the right price and time, while tracking sales, margins and returns. In a luxury or premium online store, you also balance exclusivity, brand guidelines and customer experience with commercial targets.

Role and Technical Knowledge

1. 1

   What is Open To Buy (OTB) and how would you calculate it for a fashion category?

   Explain OTB as the budget for new inventory purchases over a period. Show the formula: planned sales + planned markdowns + planned ending inventory - beginning inventory - on order. Mention that in e-commerce you adjust for return rates.

2. 2

   How do you decide the ideal assortment mix for a luxury online store?

   Cover factors like customer profile, price bands, occasion, season, brand exclusivity and competitor gaps. Mention using historical sell-through and new arrivals to balance core and fashion.

3. 3

   What is sell-through and why is it important for a merchandiser?

   Define sell-through as units sold divided by units received over a period. Explain it shows product performance, helps decide reorders, markdowns and future buys. Give a small example.

4. 4

   How would you set the initial price for a new luxury handbag on your platform?

   Discuss cost-plus, competitor benchmarking, brand positioning and perceived value. Mention that luxury pricing often uses keystone or higher markups and avoids deep discounts to protect brand image.

Practical Scenarios

1. 5

   A top-selling shirt is out of stock online but has excess inventory in a different size. What do you do?

   Suggest checking size-wise sales, running targeted ads for available sizes, adjusting size curve for future buys, and coordinating with the brand for a quick replenishment of the missing size.

2. 6

   Your category has high returns because of size issues. How would you reduce returns?

   Propose better size charts, fit videos, customer reviews with fit feedback, and vendor discussions on consistent sizing. Also mention flagging high-return styles and adjusting assortment.

3. 7

   You need to clear slow-moving winter stock in February. What markdown strategy would you use?

   Outline a phased markdown plan: start with 20-30 percent off, bundle with other products, use email and app notifications, and finally clear via outlet or flash sale. Track sell-through and margin impact.

4. 8

   How would you plan inventory for a festive season sale like Diwali?

   Mention analyzing last year's festive data, forecasting demand by category, placing early orders with vendors, setting safety stock, and planning logistics for peak volumes. Also consider return and exchange policies.

Behavioural and Situational

1. 9

   Tell me about a time you had to negotiate with a vendor or team member to meet a deadline.

   Use STAR format. Highlight your communication, flexibility and focus on a win-win outcome. Show you can handle pressure and maintain relationships.

2. 10

   Describe a situation where you had to analyze data to make a decision.

   Pick an academic or internship example. Explain the data you used, how you interpreted it, and the action you took. Emphasize logical thinking and results.

3. 11

   How do you prioritize when you have multiple tasks like vendor calls, sales reports and customer queries?

   Talk about urgency versus importance, using tools like to-do lists or calendars, and communicating with stakeholders. Give an example of a busy day and how you managed it.

4. 12

   Give an example of a mistake you made and what you learned from it.

   Choose a real but not damaging mistake. Focus on what you learned, how you fixed it, and how you prevent it now. Show ownership and willingness to improve.

HR and Company Fit

1. 13

   Why do you want to work as a merchandiser in e-commerce or D2C retail?

   Connect your interest in fashion, business and data. Mention the fast-paced nature of e-commerce and the opportunity to influence product decisions. Avoid generic answers.

2. 14

   What do you know about our company and how does this role fit into it?

   Research the company's model, categories and recent launches. Explain how merchandising supports their goals like growth, customer experience or premium positioning.

3. 15

   Where do you see yourself in three to five years in merchandising?

   Show ambition to grow into category management or buying roles. Mention developing skills in analytics, vendor management and strategic planning. Align with the company's career path.

4. 16

   How would you handle working with a brand that insists on full-price sales while your targets require discounts?

   Demonstrate diplomacy and data-driven negotiation. Suggest finding alternative ways to drive sales like bundling, loyalty points or exclusive launches, while respecting brand guidelines.