Brazil E-Commerce Market is Segmented by Business Model (B2C, B2B), Device Type (Smartphone / Mobile, Desktop and Laptop, and More), Payment Method (Credit / Debit Cards, Digital Wallets, and More), B2C Product Category (Beauty and Personal Care, Consumer Electronics, Fashion and Apparel, Food and Beverages, and More). The Market Forecasts are Provided in Terms of Value (USD).

I imported the two Olist Kaggle datasets into an SQLite database. I modified the original table names to make them shorter and easier to understand. Here's the Entity-Relationship Diagram of the resulting SQLite database:

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F2473556%2F23a7d4d8cd99e36e32e57303eb804fff%2Fdb-schema.png?generation=1714391550829633&alt=media" alt="Database Schema">

Data sources:

https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce

https://www.kaggle.com/datasets/olistbr/marketing-funnel-olist

I used this database as a data source for my notebook:

SQL Challenge: E-commerce data analysis

Brazilian E-Commerce Public Dataset by Olist

Welcome! This is a Brazilian ecommerce public dataset of orders made at Olist Store. The dataset has information of 100k orders from 2016 to 2018 made at multiple marketplaces in Brazil. Its features allows viewing an order from multiple dimensions: from order status, price, payment and freight performance to customer location, product attributes and finally reviews written by customers. We also released a geolocation dataset that relates Brazilian zip codes to lat/lng coordinates.

This is real commercial data, it has been anonymised, and references to the companies and partners in the review text have been replaced with the names of Game of Thrones great houses.

Join it With the Marketing Funnel by Olist

We have also released a Marketing Funnel Dataset. You may join both datasets and see an order from Marketing perspective now!

Instructions on joining are available on this Kernel.

Context

This dataset was generously provided by Olist, the largest department store in Brazilian marketplaces. Olist connects small businesses from all over Brazil to channels without hassle and with a single contract. Those merchants are able to sell their products through the Olist Store and ship them directly to the customers using Olist logistics partners. See more on our website: www.olist.com

After a customer purchases the product from Olist Store a seller gets notified to fulfill that order. Once the customer receives the product, or the estimated delivery date is due, the customer gets a satisfaction survey by email where he can give a note for the purchase experience and write down some comments.

Attention

1. An order might have multiple items.
2. Each item might be fulfilled by a distinct seller.
3. All text identifying stores and partners where replaced by the names of Game of Thrones great houses.

Example of a product listing on a marketplace

https://i.imgur.com/JuJMns1.png" alt="Example of a product listing on a marketplace">

Data Schema

The data is divided in multiple datasets for better understanding and organization. Please refer to the following data schema when working with it: https://i.imgur.com/HRhd2Y0.png" alt="Data Schema">

Classified Dataset

We had previously released a classified dataset, but we removed it at Version 6. We intend to release it again as a new dataset with a new data schema. While we don't finish it, you may use the classified dataset available at the Version 5 or previous.

Inspiration

Here are some inspiration for possible outcomes from this dataset.

NLP:
This dataset offers a supreme environment to parse out the reviews text through its multiple dimensions.

Clustering:
Some customers didn't write a review. But why are they happy or mad?

Sales Prediction:
With purchase date information you'll be able to predict future sales.

Delivery Performance:
You will also be able to work through delivery performance and find ways to optimize delivery times.

Product Quality:
Enjoy yourself discovering the products categories that are more prone to customer insatisfaction.

Feature Engineering:
Create features from this rich dataset or attach some external public information to it.

Acknowledgements

Thanks to Olist for releasing this dataset.

Brazilian e-commerce recorded around *** million checkouts in 2024, five percent more than the *** million orders registered one year before. In 2020, online orders first surpassed the *** million mark.

Dataset

This dataset was created by Khakim Hidayad

Contents

The Brazilian e-commerce market, valued at $52.87 billion in 2025, is experiencing robust growth, projected to expand at a Compound Annual Growth Rate (CAGR) of 18.91% from 2025 to 2033. This expansion is fueled by several factors. Rising internet and smartphone penetration across the country have significantly broadened the consumer base accessing online marketplaces. A young and increasingly digitally savvy population readily embraces online shopping, further driving market growth. The burgeoning middle class with increased disposable income contributes significantly to the spending power within the e-commerce sector. Moreover, significant investments in logistics infrastructure, including improved delivery networks and payment systems, enhance consumer trust and experience, reducing a significant barrier to online adoption. Competitive pricing strategies from established players like Magazine Luiza, Amazon, and Casas Bahia, alongside the rise of innovative smaller e-commerce businesses, ensures a dynamic and competitive market landscape benefiting consumers. Segment-wise, the growth is spread across categories, with Beauty & Personal Care, Fashion & Apparel, and Consumer Electronics showing particularly strong performance, driven by both increased purchasing power and convenience-seeking behaviors. However, challenges persist. Economic volatility and inflation can impact consumer spending, potentially slowing growth. Concerns about data security and online fraud can deter some potential online shoppers. Furthermore, the significant regional disparities in internet access and digital literacy across Brazil necessitate sustained efforts in infrastructure development and digital inclusion initiatives to unlock the full potential of the market. Competition is fierce, necessitating continuous innovation in technology, logistics, and customer service to maintain market share. Future growth hinges on addressing these challenges while leveraging Brazil's significant growth potential in its expanding digital economy. The forecast period of 2025-2033 anticipates continued growth based on these underlying trends. Recent developments include: June 2024: Podean, an award-winning marketplace marketing agency, launched in Brazil. With a team of over 140 specialists, Podean boasts a robust history of propelling brands into new territories. Their expertise spans retail management, advanced media planning, and content optimization., December 2023: Shopee, an eCommerce firm under the umbrella of Singapore's Sea, is bolstering its foothold in Latin America by acquiring the local credit division of Brazilian FinTech, Blu. With Brazil’s antitrust regulator CADE giving its preliminary nod, this strategic move positions Shopee to extend direct credit offerings to its customers in Brazil.. Key drivers for this market are: Growing Contactless Forms of Payment, Penetration of Internet and Smartphone Usage. Potential restraints include: Growing Contactless Forms of Payment, Penetration of Internet and Smartphone Usage. Notable trends are: Penetration of Internet and Smartphone Usage is Expected to Drive Brazil E-commerce Market.

In August 2025, Mercado Livre's website (known in the rest of Latin America as Mercado Libre) received around *** million visits in Brazil, making it the most visited e-commerce portal in the country. Amazon's Brazilian site (amazon.com.br) came in second with about *** million visits. Regional e-commerce powerhouses While Mercado Livre maintains its stronghold in Brazil, the company faces stiff competition across Latin America. In Mexico, for instance, Amazon's local site outperforms Mercado Libre with ***** million monthly visits compared to Mercado Libre's *** million. This regional competition has contributed to Mercado Libre's brand value soaring to ***** billion U.S. dollars in 2024, a ** percent increase from the previous year. However, the company has experienced a decline in unique active users, dropping to *** million in 2024 from *** million the year before. Shifting retail landscape The rise of e-commerce is reshaping Brazil's retail sector, with traditional brick-and-mortar stores adapting to the digital era. In the first half of 2024, pure online players generated over ** percent of e-commerce revenue in Brazil, while brick-and-click stores accounted for more than a quarter of sales.

The number of e-commerce users in Brazil has increased consistently in recent years. According to estimates, online shoppers in the South American country will exceed ****million by 2025. According to Digital Market Insights, forecasts suggest this figure will grow to ******million by 2029.

Brazil E-Commerce Transactions: Average Order Value (AOV) data was reported at 244.807 USD in 10 May 2025. This records an increase from the previous number of 243.539 USD for 09 May 2025. Brazil E-Commerce Transactions: Average Order Value (AOV) data is updated daily, averaging 158.782 USD from Dec 2018 (Median) to 10 May 2025, with 2324 observations. The data reached an all-time high of 718.941 USD in 30 Apr 2022 and a record low of 56.929 USD in 31 Mar 2020. Brazil E-Commerce Transactions: Average Order Value (AOV) data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Brazil – Table BR.GI.EC: E-Commerce Transactions: by Category.

E-commerce is the sector that Brazilian consumers are most likely to recommend to others, thanks to their satisfaction with the products and services in this segment. Amazon topped the rankings for the third consecutive year with a Net Promoter Score (NPS) of 78 in 2024.

When asked about "Most returned online purchases by category", most Brazilian respondents pick "Clothing" as an answer. 19 percent did so in our online survey in 2025. Looking to gain valuable insights about customers of online shops across the globe? Check out our reports about consumers of online shops worldwide. These reports offer the readers a comprehensive overview of customers of eCommerce brands: who they are; what they like; what they think; and how to reach them.

Brazil Revenue: E-Commerce Categories: Electronics data was reported at 10.400 % in 2024. This records a decrease from the previous number of 10.530 % for 2023. Brazil Revenue: E-Commerce Categories: Electronics data is updated yearly, averaging 11.450 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 17.300 % in 2009 and a record low of 7.480 % in 2004. Brazil Revenue: E-Commerce Categories: Electronics data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.

Dataset

This dataset was created by Icha Nugraha

Contents

Brazil Revenue: E-Commerce Categories: Culture data was reported at 1.400 % in 2024. This records an increase from the previous number of 1.010 % for 2023. Brazil Revenue: E-Commerce Categories: Culture data is updated yearly, averaging 2.020 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 18.780 % in 2003 and a record low of 0.880 % in 2022. Brazil Revenue: E-Commerce Categories: Culture data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.

Brazil Revenue: E-Commerce Categories: Computing data was reported at 11.200 % in 2024. This records a decrease from the previous number of 11.410 % for 2023. Brazil Revenue: E-Commerce Categories: Computing data is updated yearly, averaging 14.380 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 20.100 % in 2009 and a record low of 9.000 % in 2017. Brazil Revenue: E-Commerce Categories: Computing data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.

We asked Brazilian consumers about "Most popular online shops" and found that "Shopee.com.br" takes the top spot, while "Big.com.br" is at the other end of the ranking.These results are based on a representative online survey conducted in 2025 among 2,743 consumers in Brazil. Looking to gain valuable insights about customers of online shops across the globe? Check out our reports about consumers of online shops worldwide. These reports offer the readers a comprehensive overview of customers of eCommerce brands: who they are; what they like; what they think; and how to reach them.

Brazil Revenue: E-Commerce Categories: Telephony data was reported at 13.100 % in 2024. This records a decrease from the previous number of 13.460 % for 2023. Brazil Revenue: E-Commerce Categories: Telephony data is updated yearly, averaging 12.330 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 21.410 % in 2017 and a record low of 6.050 % in 2003. Brazil Revenue: E-Commerce Categories: Telephony data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.

Brazil Revenue: E-Commerce Categories: Food data was reported at 4.500 % in 2024. This records an increase from the previous number of 3.930 % for 2023. Brazil Revenue: E-Commerce Categories: Food data is updated yearly, averaging 1.080 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 4.500 % in 2024 and a record low of 0.500 % in 2010. Brazil Revenue: E-Commerce Categories: Food data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.

The penetration rate in the e-commerce market in Brazil was modeled to be **** percent in 2025. Between 2025 and 2030, the penetration rate will rise by **** percentage points, continuing its consistent upward trajectory.Further information about the methodology, more market segments, and metrics can be found on the dedicated Market Insights page on eCommerce.

Brazil Revenue: E-Commerce Categories: Games data was reported at 2.100 % in 2024. This records a decrease from the previous number of 2.130 % for 2023. Brazil Revenue: E-Commerce Categories: Games data is updated yearly, averaging 1.680 % from Dec 2000 (Median) to 2024, with 25 observations. The data reached an all-time high of 2.130 % in 2023 and a record low of 1.150 % in 2019. Brazil Revenue: E-Commerce Categories: Games data remains active status in CEIC and is reported by Brazilian Association of Eletronic Commerce. The data is categorized under Brazil Premium Database’s Domestic Trade – Table BR.HF001: E-commerce: Revenue.