A leading global e-commerce marketplace wanted to improve inventory and pricing decisions within its luxury items category. The company lacked visibility into the optimal inventory mix, had limited insights into pricing competitiveness against other online marketplaces, and needed a data-driven way to guide sellers on pricing strategies and identify opportunities to improve sales and Gross Merchandise Value (GMV).
THE CHALLENGE
The luxury items segment had a fragmented product landscape, making it difficult to compare products and pricing consistently across marketplaces. The company had limited visibility regarding which brands and products were driving inventory performance and how individual listings compared with competitor prices. Sellers also lacked actionable guidance on where pricing adjustments were needed. To address these challenges, the organization needed an analytics-driven approach to identify key brands and products, standardize product-level comparisons, benchmark pricing competitiveness, and uncover inventory and pricing optimization opportunities.
THE SOLUTION
The Prescience team conducted exploratory data analysis to identify leading brands and sellers within the luxury items segment. Unique product-level inventory identifiers were created using key product attributes, enabling consistent comparison across listings and competitor platforms. The team mapped products to competitor listings for pricing benchmarking and applied IQR-based data cleansing to remove pricing outliers.
A standardized inventory-bucketing methodology was then developed to assess pricing competitiveness across products and brands. These insights were integrated into an inventory intelligence platform with Tableau dashboards, providing actionable visibility into inventory mix, pricing gaps, and market benchmarks.
Technologies used:
● Python
● Tableau
● SQL
THE IMPACT
The solution provided product- and brand-level visibility into pricing competitiveness across the luxury inventory. 20–30% of inventory was identified with pricing gaps, enabling targeted optimization opportunities. Sellers gained actionable guidance to make more informed pricing decisions, while the business gained better alignment with market benchmarks and improved visibility to optimize both sales and profitability.
