Executive Summary

The beauty and wellness industry thrives on precision. Managing thousands of SKUs across platforms like Amazon, Target, and Ulta demands consistency. This case study explores how Actowiz Solutions helped a major retailer align 50,000 SKUs with 99% accuracy, unifying product data for top brands such as Olay, Neutrogena, and The Ordinary.

Objective: Map and verify 50K SKUs across marketplaces.

Outcome: 99% attribute accuracy, unified taxonomy, enhanced analytics, and faster updates.

Industry Background

As beauty products flood digital shelves, inconsistencies in names, attributes, and pack sizes can hurt discoverability and trust. Retailers need uniform taxonomy and structured data to manage product listings efficiently.

Actowiz Solutions enables retailers to achieve this through data harmonization, SKU standardization, and marketplace scraping intelligence, ensuring clarity and accuracy across all digital touchpoints.

2. Project Overview

Client: A U.S.-based beauty retailer active on Amazon, Target, and Ulta.

Challenge: Fragmented and inconsistent product listings, duplicates, and missing attributes.

The client needed a centralized master catalog for better visibility and analysis.

3. Objectives

Goal	Description
SKU Mapping	Identify and align 50K products across marketplaces
Attribute Accuracy	Achieve 99% consistency across platforms
Taxonomy Standardization	Create a unified product structure
Real-Time Monitoring	Enable dynamic updates for price and stock
Competitive Insights	Benchmark listings for pricing and brand compliance

Actowiz Approach

Phase 1: Data Collection

Extracted structured datasets from each marketplace:

Amazon: Title, ASIN, Brand, Price, Rating, Reviews
Target: DPCI, UPC, Category, Price, Availability
Ulta: SKU ID, Brand, Product Family, Volume, Reviews

Sample Extracted Fields:

Marketplace	Product ID	Brand	Product Name	Size	Price	Rating
Amazon	B0C12345	Olay	Regenerist Micro-Sculpting Cream	50 ml	$24.99	4.7
Target	002-15-6789	Olay	Micro-Sculpting Face Moisturizer	50 ml	$25.00	4.6
Ulta	2584721	Olay	Regenerist Micro-Sculpting Cream	1.7 oz	$24.99	4.7

Phase 2: Attribute Normalization

Actowiz's Product Mapping Engine (PME) standardized product names, pack sizes, and features using:

Cosine similarity & Levenshtein distance
Attribute harmonization for units & packaging
Category alignment (Skincare > Face Creams)

Result: 4,000 duplicate SKUs removed and taxonomy standardized.

Phase 3: Enrichment & Validation

AI and manual verification filled missing fields (size, color, variant). Enriched datasets reached 97% completeness.

Phase 4: Data Matching & Integration

Linked SKUs using UPCs and name similarity.

Field	Example
Master SKU	OLY-RMC-50
Unified Title	Olay Regenerist Micro-Sculpting Cream 50ml
Amazon ASIN	B0C12345
Target ID	002-15-6789
Ulta ID	2584721

Phase 5: Real-Time Monitoring Setup

Automated crawlers and dashboards were developed to track:

Price updates
Stock changes
Review trends
Attribute shifts

Dashboard Metrics: Unified price view, stock alerts, and accuracy score.

5. Sample Data Snapshot

SKU	Brand	Marketplace	Price	Availability	Rating	Match %
OLY-RMC-50	Olay	Amazon	$24.99	In Stock	4.7	100%
OLY-RMC-50	Target	-	$25.00	In Stock	4.6	98%
NTR-HCL-100	Neutrogena	Amazon	$11.49	In Stock	4.5	99%
ORD-SRS-30	The Ordinary	Ulta	$9.99	Limited	4.8	97%

Challenges & Solutions

Challenge 1: Disparate IDs (ASIN vs DPCI vs Ulta SKU)

Solution: Cross-linked with UPC and brand normalization.

Challenge 2: Attribute gaps (size, formulation)

Solution: AI-driven enrichment + secondary brand scraping.

Challenge 3: Naming variations

Solution: NLP synonym mapping achieved 99% accuracy.

Challenge 4: Duplicate SKUs

Solution: Similarity clustering eliminated 4,000+ duplicates.

Results

Metric	Before	After (with Actowiz)
SKU Accuracy	72%	99%
Duplicate Entries	4,100	0
Catalog Update Time	3 Days	8 Hours
Data Refresh Cycle	Monthly	Bi-Weekly

Business Impact:

80% reduction in manual audits
Unified pricing visibility
Better conversion from consistent data

Technologies Used

Python + Scrapy for scraping
AWS Lambda, S3 for pipelines
PostgreSQL, MongoDB for data storage
AI/ML Models for product similarity
Power BI for reporting and dashboards

Business Outcomes

1. Optimized Pricing: Found price gaps >8%, improved margin by 4.5%.

2. Faster SKU Onboarding: Time reduced by 70%.

3. Improved Brand Consistency: Synchronized descriptions & visuals.

4. Better SEO Visibility: Structured data boosted search rankings.

10. Benefits of Cross-Marketplace Mapping

Benefit	Description
Data Uniformity	Improves analytics and decision-making accuracy
Competitive Benchmarking	Compare attributes and prices efficiently
Time Savings	Automated audits reduce manual effort
Better CX	Consistent listings improve buyer confidence
Inventory Planning	Enhanced visibility across sales channels

Conclusion

Actowiz Solutions delivered complete cross-marketplace alignment, empowering the retailer to act on real-time insights with clean, consistent data. This case shows how intelligent automation transforms product management across platforms, improving both efficiency and performance.

About Actowiz Solutions

Actowiz Solutions is a global leader in web scraping, product mapping, and retail data intelligence, offering real-time insights across 150+ online platforms. Our solutions help retailers, manufacturers, and D2C brands automate pricing, product analytics, and competitive intelligence.

Hear It Directly from Our Clients

Watch how businesses like yours are using Actowiz data to drive growth.

▶

1 min

★★★★★

"Actowiz Solutions offered exceptional support with transparency and guidance throughout. Anna and Saga made the process easy for a non-technical user like me. Great service, fair pricing!"

Thomas Galido

Co-Founder / Head of Product at Upright Data Inc.

▶

2 min

★★★★★

"Actowiz delivered impeccable results for our company. Their team ensured data accuracy and on-time delivery. The competitive intelligence completely transformed our pricing strategy."

Iulen Ibanez

CEO / Datacy.es

▶

1:30

★★★★★

"What impressed me most was the speed — we went from requirement to production data in under 48 hours. The API integration was seamless and the support team is always responsive."

Febbin Chacko

-Fin, Small Business Owner