Sales Prediction Based on Textual Features of Online Product Reviews

Hongyan Yu, Qiang Yang, Jiacheng Yang, Tianlan ZhouInternational Journal of Management Science Research 2025 · DOI

TL;DR

This paper introduces a novel approach to sales forecasting by incorporating textual features from online product reviews, moving beyond traditional time-series models. By leveraging Latent Dirichlet Allocation (LDA) for topic modeling, star ratings, and review usefulness, the authors build a more nuanced predictive model that achieves strong accuracy, outperforming a standard time-series method.

What Problem Does This Paper Address?

Accurate sales forecasting is crucial for efficient business operations, from inventory management to customer satisfaction. However, traditional time-series forecasting methods often struggle to adapt to rapidly changing market demands because they primarily rely on historical sales data and neglect external factors. While some research has explored incorporating machine learning, there's a significant gap in leveraging the rich, unstructured information contained within online product reviews for sales prediction. These reviews offer direct insights into consumer sentiment, perceptions, and market responses, which are vital for understanding demand dynamics.

Methods

The core of this research lies in innovative feature engineering and a robust regression model. The authors extract three categories of textual features from online product reviews:

  • Review Topics: Latent Dirichlet Allocation (LDA) is employed to automatically discover hidden thematic structures within the review text. This process identifies key topics discussed by consumers, such as price, taste, or ingredients.
  • Star Ratings: Aggregated star ratings are used, including the mean star rating, standard deviation of ratings, and the proportion of reviews at each star level. This captures both the overall product evaluation and the degree of consumer consensus.
  • Review Usefulness: A "Helpfulness Rate" (HR) is calculated, representing the ratio of helpful votes to total evaluations for a review. This metric aims to capture the perceived credibility and impact of reviews.

These engineered features, along with lagged sales data (sales from the previous period), are then fed into a Ridge Regression model. Ridge regression is chosen to handle potential multicollinearity among the features, a common issue when dealing with proportion-based variables. The model is tuned using a ridge trace plot to find an optimal regularization parameter.

Datasets

The study utilizes the Amazon open-source food review dataset. This dataset contains approximately 568,455 product reviews spanning from 1999 to 2013. For their analysis, the authors preprocessed the data by removing irrelevant information, handling missing values, and focusing on data from 2006 onwards to ensure sufficient sales volume. The data was converted to weekly intervals for analysis.

Key Insights and Ideas

  • Reviews as a Predictive Signal: The most significant insight is that textual features from online reviews are powerful predictors of sales, offering a richer understanding than historical sales data alone.
  • The Nuance of Star Ratings: Counterintuitively, the study found that while high ratings are generally positive, a lower average star rating combined with a higher standard deviation can actually amplify consumer interest. This suggests that divergent opinions and the presence of critical feedback can drive engagement.
  • Negative Reviews Can Be Beneficial: The coefficients for one-star and two-star reviews were found to be positive and significant. This implies that negative reviews, when perceived as authentic, can paradoxically boost sales by increasing consumer trust in the overall review ecosystem.
  • Polarization Drives Interest: Three-star (neutral) reviews have a negligible impact, indicating that consumers are more swayed by polarized sentiments (strongly positive or negative) than by lukewarm opinions.

Key Results

The proposed feature-engineering-based model demonstrated strong predictive accuracy:

  • Training Set R²: 0.88
  • Test Set R²: 0.78

When compared to a traditional Holt's linear trend method, the feature-engineering model achieved a significantly lower Mean Absolute Percentage Error (MAPE) of 0.0840 versus 0.1442 for Holt's method, highlighting its superior predictive performance.

Limitations and Future Work

The authors acknowledge several limitations and suggest future research directions:

  • Review Count as Sales Proxy: The study used the number of reviews as a proxy for sales volume. Future work should ideally use actual sales figures alongside review data for more direct validation.
  • Sentiment Intensity: While sentiment is implicitly captured through topics and ratings, future research could directly analyze the intensity of review sentiment (e.g., strongly positive vs. mildly positive) and its impact on sales.
  • Multimodal Data Fusion: Integrating other forms of user-generated content, such as images and videos, with textual reviews could further enhance sales prediction accuracy. This would require more advanced feature extraction and fusion techniques.

Summary updated

Abstract

Accurate sales forecasting is essential for effective enterprise decision-making. Reliable predictions not only optimize inventory management and reduce resource waste but also enhance customer experience. While prior research has primarily focused on improving traditional time series models, relatively limited attention has been given to forecasting sales based on textual features extracted from online product reviews. This study addresses this gap by incorporating consumer-generated reviews into a sales prediction framework. Using Amazon.com as a case study, we analyze the open-source Amazon food review dataset. Through feature engineering, three categories of textual variables are constructed: review topics (extracted via the Gensim library and Latent Dirichlet Allocation, LDA), star ratings, and review usefulness. These features, together with lagged sales, are used as inputs into a ridge regression model. Experimental results show that the proposed model achieves an R² of 0.88 on the training set and 0.78 on the test set, indicating both feasibility and strong predictive accuracy. Compared with traditional time series methods, the review-based approach leverages text mining to capture consumers’ genuine perceptions and market responses. This innovation enhances forecasting accuracy and offers theoretical as well as practical implications for enterprises, including improved sales planning, more adaptive market strategies, and more efficient warehouse and inventory management.
BibTeX
@article{yu2025sales,
  author = {Hongyan Yu and Qiang Yang and Jiacheng Yang and Tianlan Zhou},
  title = {{Sales Prediction Based on Textual Features of Online Product Reviews}},
  journal = {International Journal of Management Science Research},
  year = {2025},
  doi = {10.53469/ijomsr.2025.08(09).07},
}
Figure