Generate SKU for New Variant
As a Product Manager, I need to efficiently generate unique Stock Keeping Units (SKUs) for new product variants. I need to combine the 'Base SKU', 'Color Code', and 'Size Identifier' to create a comprehensive SKU that accurately reflects the product's attributes for inventory management and product cataloging.
=CONCATENATE(A2,"-",B2,"-",C2) How it works: The CONCATENATE function allows you to join multiple text strings or cell values into a single, cohesive string. By combining the base SKU, color code, and size identifier with hyphens as separators, Product Managers can quickly create unique and descriptive SKUs for new product variants. This ensures consistency and accuracy in inventory management, product cataloging, and sales tracking, preventing manual errors and saving time.
Data Setup
| Base SKU | Color Code | Size Identifier |
|---|---|---|
| PROD123 | BLU | L |
| PROD124 | RED | M |
| PROD125 | GRN | S |
Step-by-Step Guide
Identify the cells containing the individual components of your SKU (e.g., Base SKU in A2, Color Code in B2, Size Identifier in C2).
In the cell where you want the combined SKU to appear (e.g., D2), type `=CONCATENATE(`.
Select the first component (e.g., cell A2 for Base SKU), then type `,`.
Add any desired separators in double quotes (e.g., `"-"` for a hyphen), then type `,`.
Continue selecting components and adding separators until all parts of the SKU are included (e.g., `B2,"-",C2`).
Close the parenthesis and press Enter (e.g., `=CONCATENATE(A2,"-",B2,"-",C2)`).
Drag the fill handle (the small square at the bottom-right of the cell) down to apply the formula to all new product variants in your list.