Olist Geolocation Story
How a Sao Paulo-centered seller network shapes national reach, freight, and delivery speed
- So-What Question
- Load And Prepare Data
- Chart 1: Supply Is More Sao Paulo-Centered Than Demand
- Chart 2: Olist Is A National Marketplace, Not Mostly Local Commerce
- Chart 3: Distance Creates Real Cost And Speed Pressure
- Chart 4: The Largest Lanes Radiate Out From Sao Paulo
- Chart 5: North And Northeast Routes Are The Long-Distance Challenge
- Leaflet Map: Demand And Supply Hubs
- Leaflet Map: Customer/Seller Index Areas
- Static Backup: Highest Demand/Supply Imbalances
- Recommended Slide Story
- Caveats
So-What Question
How does Olist’s Sao Paulo-centered seller network affect delivery speed, freight cost, and national reach?
This question turns geolocation from a map exercise into a business story. The evidence below shows that Olist demand is national, but seller supply is much more concentrated in Sao Paulo. That creates reach, but also distance, cost, and customer-experience tradeoffs.
Load And Prepare Data
| metric | value |
|---|---|
| Customer ZIP coverage | 99.7% |
| Seller ZIP coverage | 99.8% |
| Item rows with both customer and seller coordinates | 99.5% |
Chart 1: Supply Is More Sao Paulo-Centered Than Demand
What this says: customer demand is concentrated in Sao Paulo, but seller supply is even more concentrated. That imbalance is the root of the logistics story.
Chart 2: Olist Is A National Marketplace, Not Mostly Local Commerce
What this says: the typical customer-seller leg is hundreds of kilometers. Local fulfillment exists, but it is not the dominant pattern.
Chart 3: Distance Creates Real Cost And Speed Pressure
What this says: longer routes are not just geographically interesting. They are slower and more expensive.
Chart 4: The Largest Lanes Radiate Out From Sao Paulo
What this says: the network is anchored in SP. The biggest lanes are SP to SP and SP to major nearby states.
Chart 5: North And Northeast Routes Are The Long-Distance Challenge
What this says: the long-distance problem is specific enough to act on. It is mostly SP sellers shipping to North/Northeast destinations.
Leaflet Map: Demand And Supply Hubs
What this says: the largest seller hubs are tightly clustered in Sao Paulo, while demand is spread across more cities. Use the map to introduce the geography, then use the bar charts to prove the operating impact.
Leaflet Map: Customer/Seller Index Areas
What this says: smooth areas show where customer demand is stronger than local seller supply and where seller hubs dominate. The detailed city layer is clustered and can be toggled on for exact city lookup.
Static Backup: Highest Demand/Supply Imbalances
What this says: the map is best for exploration, but a ranked table helps the audience remember the specific cities. Demand-heavy cities are places where customer volume is high relative to local seller activity. Supply-heavy cities are seller hubs that ship outward.
Recommended Slide Story
- Start with the so-what question: how does SP-centered supply affect reach, cost, and speed?
- Show the hub map: demand is national; seller hubs are clustered.
- Show the city demand/supply ratio map: identify where demand exceeds local supply and where seller hubs ship outward.
- Show supply versus demand by state: SP is much more dominant as an origin than as a destination.
- Show distance distribution: this is not mostly local commerce.
- Show distance pressure: longer routes increase freight and delivery days.
- Close with lanes: the largest and hardest lanes point to concrete logistics opportunities.
Caveats
- Distance uses ZIP-prefix centroid to ZIP-prefix centroid, not exact address or road distance.
- Seller origin is the registered seller ZIP code, not necessarily the physical warehouse used for fulfillment.
- Delivery timing is order-level; in multi-item orders, the same delivery timestamp is repeated across item rows.
- Late delivery depends on the estimated delivery promise. Long-distance routes can be slow without always being late if the estimate is conservative.