Optimize Shopify SKU System for Botanical Spirits InventoryOptimize Shopify SKU System for Botanical Spirits Inventory
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Henry's avatar
Henry Jay
• 1d
Shopify SKU Architecture: Inventory Data Optimization for Les Saintes Botanical Spirits
Les Saintes produces a premium range of organic, non-alcoholic botanical aperitifs. As the brand expanded from single-bottle offerings into multi-packs, sample sets, and corporate gift options, their Shopify backend began experiencing critical variant overlapping.
Mismatched naming conventions were leading to inventory discrepancies, making it impossible to pass clean data to automated inventory management apps and fulfillment software.
I stepped in as a Shopify Problem Solver to architect a highly scalable, logic-driven Alphanumeric SKU Naming Convention to standardize their catalog layer.
The Core Challenges
Overlapping Gift Variant Data: Gift boxes containing individual variations lacked a structured identifier, triggering manual counting errors.
Logistics & 3PL Inefficiencies: Multi-packs (e.g., 3-packs, 6-packs) were hardcoded incorrectly, causing fulfillment teams to accidentally ship single bottles instead of full packs.
Unreliable Stock Levels: The absence of a strict nested logic system created 'invisible stockouts' across different bottle sizes (e.g., 200ml mini vs 750ml standard).
The Solution: 4-Tier Alphanumeric SKU Matrix
I engineered a dynamic, standardized SKU convention based on a strict 4-part matrix:
[BRAND]-[PRODUCT LINE/FLAVOR]-[VOLUME]-[PACK TYPE]
eCommerce MarketingData AnalysisShopify DevelopmentShopify
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started