A privately labeled office supplies company used Excel formulas to set daily SKU prices, but needed a more automated, data-driven way to optimize price versus profit using historical trends and have results ready before business hours. Synoptek built a central database to sync data from multiple digital marketplaces, performed exploratory analysis and data cleaning, and trained regression models including Random Forest to predict SKU-level optimal prices and set min/max price bands. The solution reduced manual data extraction and enabled flexible intra-day pricing experiments, with outputs delivered in Excel plus price-versus-profit graphs per SKU. Outcomes included about 3 hours saved per day for analysts, 70% higher productivity, 80% reduction in manual processes, and 30% increase in tot

Join for free to read