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?
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.
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.
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 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 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 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 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 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.
Recommended Business Message
Presentation takeaway: Olist has national customer
reach, but the seller network is still concentrated. That concentration
is useful because it creates scale in Sao Paulo, but it also pushes many
orders into long-distance logistics.
Business advice: Keep Sao Paulo as the main hub, but
invest in regional seller recruitment and logistics support in
customer-heavy states with meaningful demand. Prioritize by combining
four signals: customer/seller index, total demand volume, delivery days,
and freight cost.