Context
A traditional-foods retailer had a WooCommerce storefront with no working prices — the catalog existed, but the actual product data lived in a client-maintained Excel sheet that mixed two different pricing conventions across the same set of products.
The challenge
Some products priced per kilogram with whole-kilogram pack tiers (1 / 5 / 30 kg); others priced as a flat total for small gram-based packs (100 / 250 / 500 g) — same spreadsheet, same column headers, two different meanings. Loading it naively would have priced a 30 kg sack the same as a 30 g sachet.