SKU Codes Decoded: Scent and Size with LEFT, FIND and MID – and New SKUs with TEXT
Lessons in this course
- Order Export Cleanup: Order Numbers, SKUs and Line TotalsFree
- Profit per Order after Payment Fees and Shipping Locked
- Product Margin Table: Which SKUs Earn Enough? Locked
- Pricing with a Target Margin (Not a Markup) Locked
- Ad Spend: ROAS, Cost per Order and Break-even ROAS Locked
- Discount Codes: What 15% Off Really Costs Locked
- Returns and Breakage: Return Rate and Cost per SKU Locked
- Inventory: Days of Stock and When to Reorder Locked
- Bestseller Ranking with SORT and LARGE Locked
- Monthly Sales by Channel with SUMIFS (Chart) Locked
- Customer Repeat Rate and Revenue from Returning Buyers Locked
- Half-Year Dashboard: Profit, Margin, Chart and Colour Scale Locked
- SKU Codes Decoded: Scent and Size with LEFT, FIND and MID – and New SKUs with TEXT Locked
- Joining Two Exports: Unit Costs into Order Lines with XLOOKUP and a «missing» Safety Net Locked
- Customer List Cleanup: Clean Emails, Duplicate Flags, Missing Countries & the Real Customer Count Locked
- Scent × Size Matrix: One SUMIFS with Mixed References and a Colour-Scale Heat Map Locked
- Order Values in Bands: COUNTIFS from–to, Median vs AOV and a Column Chart Locked
- Product Reviews by the Numbers: Average Stars, Low-Star Share and Review Rate per SKU Locked
- Growth over Time: Month-over-Month vs Year-over-Year and a 3-Month Average (Line Chart) Locked
- Final Project: Year-End Seller Report – Channels, Profit, Margin, Growth and a Stacked Chart Locked