Shopify SKU Architecture: Inventory Data

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]