Executive Summary

Olist is a national marketplace powered by concentrated seller hubs. Customer demand appears across Brazil, but seller supply is much more concentrated in Sao Paulo and the South/Southeast.

The main operating tension is distance. Only 12.3% of geo-linked item rows are within 50 km, while 26.9% travel more than 750 km. Delivery time and freight rise materially as distance increases.

The best opportunity is regional supply development. Olist should keep using Sao Paulo as the main seller engine, but prioritize seller recruitment and logistics improvements in high-demand, under-supplied states and cities.

Main Question

Main business question: Is Olist’s seller supply located close enough to where customer demand is, or is the marketplace relying too much on a few seller hubs to serve the whole country?

Decision question: Where should Olist recruit regional sellers or improve logistics to reduce long-distance shipping pressure?

Customer/Seller Index Definition

Index formula: customer demand item rows / seller supply item rows.

  • Index greater than 1: customer-heavy. Local demand is larger than local seller supply.
  • Index below 1: seller-heavy. Local seller supply is larger than local customer demand.
  • Index equals Inf: demand exists, but seller supply is zero in that state or city in this dataset.

State Map: Index Labels Only

Insight: Most states are customer-heavy, while only a few states are seller-heavy or close to balanced. Sao Paulo has a 0.59x index and Parana has 0.66x, meaning seller supply exceeds local demand. Santa Catarina is almost balanced at 1.02x. By contrast, many North and Northeast states have very high demand/supply indexes, including PA at 100x+, AM at 55x, PI at 44.92x, and several demand-only states marked Inf.

So what: The map shows that Olist demand is national, but local seller supply is not. This points to regional seller recruitment as the clearest business lever.

Map preview

City Map: Customer/Seller Index Areas

Insight: City-level ratios show the same structural pattern at a more detailed grain. Sao Paulo is seller-heavy, while Rio de Janeiro, Belo Horizonte, Brasilia, Salvador, Fortaleza, Belem, Manaus, Recife, and other cities show demand ahead of local seller supply.

So what: Use the city map to identify concrete places for seller recruitment or fulfillment partnerships, not just broad regional imbalance.

Map preview

Chart 1: Supply Is More Concentrated Than Demand

Insight: Seller supply is much more concentrated in Sao Paulo than customer demand. SP has 42.2% of customer item rows, but 71.3% of seller-origin item rows.

So what answer: Sao Paulo concentration helps Olist scale nationally because it creates a dense seller base, but it also creates a regional supply bottleneck when distant states depend on SP sellers.

Chart 1: Seller supply is more concentrated in Sao Paulo than customer demand.

Chart 1: Seller supply is more concentrated in Sao Paulo than customer demand.

Chart 2: Olist Is Not Mostly Local Commerce

Insight: Only 12.3% of orders are within 50 km, while 26.9% travel more than 750 km.

So what answer: Olist depends heavily on long-distance logistics, not just local buyer-seller matching. Delivery performance and freight economics are core to the marketplace model.

Chart 2: Most geo-linked item rows travel beyond local distance.

Chart 2: Most geo-linked item rows travel beyond local distance.

Chart 3: Distance Creates Cost And Speed Pressure

Insight: Delivery rises from 6.2 days at 0-50 km to 20.5 days at 1500+ km. Freight rises from BRL 11.48 to BRL 35.78.

So what answer: Olist should prioritize the distance bands above 750 km, especially 1500+ km routes, because those routes carry the clearest delivery-time and freight penalties.

Chart 3: Longer customer-seller distances increase delivery time and freight cost.

Chart 3: Longer customer-seller distances increase delivery time and freight cost.

Chart 4: The Largest Lanes Radiate From Sao Paulo

Insight: SP -> SP has 36,136 item rows, far above SP -> RJ with 9,661 and SP -> MG with 8,676.

So what answer: Olist should keep optimizing Sao Paulo because it is the main engine, but also build more regional supply near large demand markets like RJ, MG, BA, PE, CE, PA, and AM.

Chart 4: The highest-volume lanes are anchored in Sao Paulo.

Chart 4: The highest-volume lanes are anchored in Sao Paulo.

Chart 5: Long-Distance Pressure Is Mostly SP To North/Northeast

Insight: The hardest long-distance lanes are mostly Sao Paulo to North/Northeast. SP -> PA averages 2,321 km and 23.4 delivery days.

So what answer: These lanes need either regional sellers, better routing, or clearer delivery promises. The highest-priority lanes are the ones with both high volume and long delivery time.

Chart 5: Long-distance lanes show where operational pressure is highest.

Chart 5: Long-distance lanes show where operational pressure is highest.

Chart 6: City Ratios Reveal Local Mismatches

Insight: Belem and Maceio are demand-only examples, while Ibitinga has 7,723 supply items and only 24 demand items.

So what answer: Demand-heavy cities are candidates for seller recruitment. Supply-heavy cities are export hubs whose role is to serve demand elsewhere.

Chart 6: City-level imbalances separate demand-heavy markets from seller-export hubs.

Chart 6: City-level imbalances separate demand-heavy markets from seller-export hubs.

State Index Table For Presentation

Customer/seller index by state. Index = customer demand item rows / seller supply item rows.
State State name Customer demand items Seller supply items Index Interpretation
AC Acre 91 1 91x Demand-heavy (4x+)
AL Alagoas 443 0 Inf Demand only
AM Amazonas 165 3 55x Demand-heavy (4x+)
AP Amapa 82 0 Inf Demand only
BA Bahia 3,777 638 5.92x Demand-heavy (4x+)
CE Ceara 1,468 93 15.78x Demand-heavy (4x+)
DF Distrito Federal 2,212 855 2.59x Demand-skewed
ES Espirito Santo 2,244 372 6.03x Demand-heavy (4x+)
GO Goias 2,319 518 4.48x Demand-heavy (4x+)
MA Maranhao 819 403 2.03x Demand-skewed
MG Minas Gerais 13,087 8,744 1.5x Demand-skewed
MS Mato Grosso do Sul 817 49 16.67x Demand-heavy (4x+)
MT Mato Grosso 1,049 145 7.23x Demand-heavy (4x+)
PA Para 1,077 8 100x+ Demand-heavy (4x+)
PB Paraiba 596 38 15.68x Demand-heavy (4x+)
PE Pernambuco 1,801 447 4.03x Demand-heavy (4x+)
PI Piaui 539 12 44.92x Demand-heavy (4x+)
PR Parana 5,715 8,649 0.66x Supply-skewed
RJ Rio de Janeiro 14,523 4,803 3.02x Demand-skewed
RN Rio Grande do Norte 527 56 9.41x Demand-heavy (4x+)
RO Rondonia 275 14 19.64x Demand-heavy (4x+)
RR Roraima 52 0 Inf Demand only
RS Rio Grande do Sul 6,215 2,191 2.84x Demand-skewed
SC Santa Catarina 4,167 4,071 1.02x Balanced
SE Sergipe 384 10 38.4x Demand-heavy (4x+)
SP Sao Paulo 47,338 79,975 0.59x Supply-skewed
TO Tocantins 313 0 Inf Demand only

Slide Story Order

  1. Start with the main question: is supply close enough to demand?
  2. Show the state index map to prove the national imbalance.
  3. Show the city map to make the opportunity concrete.
  4. Use Chart 1 to show seller supply concentration.
  5. Use Charts 2 and 3 to prove that distance creates operating pressure.
  6. Use Charts 4 and 5 to identify the biggest and hardest lanes.
  7. Close with Chart 6 and the business action: recruit sellers where demand is ahead of supply.

Caveats