Tag: Ecommerce

  • Our real time case study-When E-commerce Orders Were Failing, the Problem Was Inside the Stores

    Our real time case study-When E-commerce Orders Were Failing, the Problem Was Inside the Stores

    An international retail client came to us with a simple but serious problem:

    Their e-commerce business was growing, but they were not able to fulfil around 30% of the orders.

    The business had around 400 hypermarkets and supermarkets across the country.

    Customers could place orders through the company’s own e-commerce website as well as through other marketplace platforms.

    The stores were connected to these platforms and were expected to fulfil customer orders from their existing inventory.

    On paper, the model looked simple.

    In reality, it was creating a major operational problem.

    The same inventory was serving two customers:

    the customer standing inside the store and the customer ordering online.

    And the fulfilment rate was only around 70%.

    That meant roughly 3 out of every 10 orders were facing a fulfilment problem.

    The first question was not:

    “How do we increase inventory?”

    The first question was:

    “Where exactly is the problem happening?”

    We started with the data.

    We looked at four areas.

    1. Order fulfilment lead time

    We studied how much time the stores actually had to pick and service an online order.

    2. Demand forecast

    We checked the demand quantity being generated by the application and whether it reflected actual store-level demand.

    3. Inventory update frequency

    We examined the time gap between the physical inventory available in the store and the inventory quantity visible on the e-commerce platform.

    4. Store-level fulfilment

    We mapped which stores were servicing which platforms and where orders were getting missed.

    That analysis started showing us something important.

    The problem was not simply a lack of inventory.

    The bigger problem was inventory visibility and inventory accuracy.

    Different platforms were generating orders at different times.

    The company’s own website was generating orders.

    Customers were simultaneously buying from the physical stores.

    The store inventory was changing continuously.

    But the e-commerce platforms were not receiving inventory updates quickly enough.

    So the system could show a product as available online even when the store could no longer fulfil the order.

    That created an out-of-stock situation after the customer had already placed the order.

    Then we applied Pareto.

    We analysed the SKU-level data.

    The result was clear.

    Around 60–70% of the fulfilment problem was concentrated in the top-selling SKUs.

    That changed our approach.

    We did not try to fix hundreds or thousands of SKUs at once.

    We went after the SKUs that were creating the biggest impact.

    We worked with the stores to identify and correct ambiguous inventory quantities.

    We looked at the actual stock on the ground.

    We compared it with the system stock.

    And we focused on improving the connection between the store inventory and the e-commerce platforms.

    One important recommendation was technology-related.

    The ideal solution was real-time inventory synchronisation.

    But implementing a completely real-time system would have required additional technology changes and investment.

    So we looked at what was commercially practical.

    Our recommendation was:

    If real-time synchronisation is not immediately possible, reduce the inventory update cycle to around 10 minutes.

    That small change could significantly reduce the gap between:

    Physical Stock → System Stock → Online Availability

    The technology alone, however, was not enough.

    We went to the stores.

    This is where Gemba became important.

    Data can tell you where the problem is.

    But going to the actual workplace helps you understand why it is happening.

    We checked what was happening at store level.

    We looked at the actual inventory.

    We understood how orders were coming from different platforms.

    We checked how the store teams were responding.

    We compared system inventory with physical inventory.

    And we connected those observations back to the data.

    That combination gave us a much clearer picture.

    Technology showed us the symptom.

    Data showed us the concentration.

    Pareto showed us where to focus.

    Gemba showed us the operational reason.

    The result?

    The out-of-stock problem reduced from around 30% to approximately 11%.

    That took the fulfilment rate from around:

    70% → 89%

    in a relatively short period.

    More importantly, the client did not need to simply keep adding inventory to solve the problem.

    We improved the way existing inventory was being seen, updated and allocated for e-commerce fulfilment.

    The client subsequently took the process forward and continued following the improvements internally.

    What did we actually change?

    It was not one big technology project.

    It was a combination of several practical interventions:

    • Analysed fulfilment lead time

    • Studied demand forecasting logic

    • Mapped inventory update frequency

    • Identified store-level fulfilment gaps

    • Created SKU-level Pareto analysis

    • Focused on high-impact SKUs

    • Checked physical inventory against system inventory

    • Identified ambiguous inventory quantities

    • Recommended faster inventory synchronisation

    • Recommended approximately 10-minute inventory updates where real-time integration was not immediately practical

    • Conducted Gemba-level validation

    • Connected technology data with store operations

    And that is what made the difference.

    The bigger lesson for retailers

    Many retailers assume that e-commerce fulfilment problems can be solved by:

    “Keep more stock.”

    I don’t agree.

    Sometimes the inventory is already sitting inside the store.

    The problem is that the system does not know the right quantity at the right time.

    And when that happens, the customer sees:

    “Available”

    places the order,

    and then receives:

    “Sorry, this item is unavailable.”

    That is not just an inventory problem.

    It is a technology + data + process + store execution problem.

    For retailers operating an omnichannel model, the real question is not simply:

    “How much inventory do we have?”

    It is:

    “Do we know exactly where that inventory is, whether it is actually available, and how quickly can we make that information visible to the customer?”

    That is where e-commerce, store operations, data analytics and Gemba have to work together.

    And sometimes, a relatively simple change in the way inventory is updated can create a much bigger impact than simply adding more stock.

    From 70% fulfilment to 89%.

    Not by throwing more inventory at the problem.

    By finding the real problem first.

  • The ₹502 Customer: Why Digital Acquisition Is Breaking and How to Fix It

    The ₹502 Customer: Why Digital Acquisition Is Breaking and How to Fix It

    Eight years ago, a customer cost you ₹100. Today the same customer costs ₹322 — and converts no better. Globally, CAC has climbed roughly 222% over eight years, and 60% in the last five alone. Shopify’s 2026 data across 4.8 million merchants puts average CAC at $318, up 16% in a single year. In India, Meta-sourced CAC for D2C brands jumped from about ₹380 to ₹502 — 32% in twelve months.

    Here is the uncomfortable part: nobody is buying more customers. They are simply paying more for the same ones.

    A customer buying the product online

    Why the meter keeps running

    1. The auction got crowded — and richer. Ad inventory is finite; bidders are not. Google CPCs rose ~12.9% and Meta CPMs ~20% in 2025. Globally, deep-pocketed marketplaces bid on the same keywords as a 30-crore D2C brand. In India, every funded brand in skincare, coffee, supplements and fashion is buying the same 200 keywords and the same three lookalike audiences. Auction inflation is not a marketing problem — it is a supply-and-demand problem.

    2. Signal loss made targeting expensive. Post-ATT, only about a quarter of iOS users allow tracking. Cookies are dying. Platforms now need far more spend to learn who your buyer is, and you pay for that learning phase every single campaign.

    3. Search stopped sending traffic. Zero-click searches are now ~65% of all queries, and ~93% inside Google’s AI Mode. The free top-of-funnel that subsidised paid acquisition for a decade has quietly shut. Brands that were cited inside AI answers, however, saw 35% more organic clicks and 91% more paid clicks — visibility moved, it did not vanish.

    4. Quick commerce became a paid channel. Uniquely acute in India. Visibility on Blinkit, Zepto or Instamart can consume 10–15% of GMV in platform advertising and fees. Brands that entered q-commerce to escape Meta’s CAC discovered they had simply changed landlords.

    5. Retention neglect. When repeat rate is weak, every month starts at zero. High CAC is often a symptom, not the disease.

    What actually works

    Fix LTV before you fix CAC. CAC is only expensive relative to what a customer is worth. Doubling second-order rate does more for unit economics than a 10% CPM saving ever will. Measure CAC payback in months, not ROAS in a day.

    Rebuild the channel mix. Brands that moved to roughly 35–40% paid, 30% email/WhatsApp, 20% organic and community, 10% affiliate held CAC flat while LTV improved 12–18%. In India, target a blended CAC 30–40% below paid CAC. If your blended and paid CAC are the same number, you have no owned channel.

    Own the WhatsApp layer. Automated abandoned-cart recovery on WhatsApp recovers 30–40% of carts at ₹0.50–₹1.50 per message. Compare that to ₹502 to re-acquire the same person. This is the single highest-ROI intervention available to an Indian D2C brand today.

    Build for citation, not clicks. Structure content so AI engines quote you: clear entity definitions, comparison tables, FAQs, original data. Being the source inside an AI answer is the new page-one ranking.

    Use referral and community deliberately. Referred customers show 16% higher LTV and 37% better retention. Communities lift repeat purchase 40–60%. Both convert customers into an unpaid acquisition channel.

    Apply Six Sigma to the funnel. Most CAC problems are variation problems. Run a Pareto on CAC by SKU, geography and creative — typically 20% of campaigns burn 60% of waste. Kill them. Then attack conversion rate: a move from 1.4% to 2.1% cuts CAC by a third without touching ad spend.

    Negotiate q-commerce like a trade term, not a media buy. Tie visibility spend to guaranteed share-of-shelf and data access. Treat it as vendor negotiation, because it is.

    Case study: a personal care brand in NCR

    (Composite of client work, figures disguised.)

    A ₹42-crore ARR personal care D2C brand ran 78% of revenue through Meta and Google. CAC had gone from ₹410 to ₹640 in eighteen months. Contribution margin was negative on first order; the business survived on Series A cash.

    Diagnosis, not campaign tinkering:

    Pareto on 340 campaigns — 22% of spend produced 71% of profitable orders. The rest was switched off in week two.

    Repeat rate was 11% against a category benchmark of 26%. The leak was retention, not acquisition.

    A WhatsApp lifecycle engine was built: cart recovery, day-21 replenishment nudges, restock alerts.

    Assortment cut from 61 SKUs to 28, concentrating spend behind three hero products with the best AOV and repeat behaviour.

    Referral programme launched to existing buyers only.

    Nine months later: paid CAC ₹598 (barely moved — the auction was never going to be kind), but blended CAC ₹386, down 40%. Repeat rate 24%. LTV:CAC moved from 1.4:1 to 3.1:1. Contribution margin turned positive in month five.

    They did not win the auction. They stopped needing to.

    The lesson: in 2026, you cannot out-bid rising CAC. You can only out-retain it.


    Sources: Shopify Global Commerce Report 2026 (via Focus Digital), Indian D2C benchmark data 2026, zero-click search statistics 2026, q-commerce fee analysis 2026.