How to Add SKUs Using the SKU Generator
Overview
Before adding SKUs into the system, ensure the following items have been created for your collection:
- Season/Linelist Code
- Sizescale
- Pricelist
For Season Linelist Preparation, refer to the appropriate guide.
Step 1: Download and Prepare the SKU Generator Template
- Download the SKU Generator Template at the end of this article.
- Open the downloaded Excel file and select Enable Macros.
Step 2: Enter Product Details in the Template
- Go to the Template sheet.
- Fill in the product details in the appropriate columns.
- Column headers in red indicate mandatory fields for SKU creation.
- The SKU naming convention is style-colorcode-size.
- Do not use characters such as +, *, ^, ?, “, (, ).
- Tip: If all products belong to the same Season/Linelist, ensure the correct code is entered. If multiple seasons/linelists are included, add the details in an Additional column.
- For additional fields, go to Blast Ramp and select "Click here to view for more upload options."
Step 3: Clean Up the Template
- Delete any unused columns (Right-click the column header and select Delete).
Step 4: Generate SKUs
- Once satisfied with the template data, go to:
- View tab > Macros > Macros
- Tools > Macros > Macros
- Highlight "Create SKUs" and select Run.
📌 Note: Depending on your Excel version, the steps may vary slightly.
Copy SKU Data to Blast Ramp
- The system will generate a new worksheet called “Output.”
- Highlight all your data and copy it using:
- Mac: Command + C
- Windows: CTRL + C