---
title: Generating SKU Sheets
description: A step-by-step guide to duplicating, building, and quality-checking a SKU sheet for a uniform package — from setting up the classifier fields to submitting the final SKUs in HubSpot.
---

[Skip to content](https://help.signaturelocker.com/support/sku-sheet-creation#main-content)

English

Show submenu for translations

[![Signature Athletics Logo](https://help.signaturelocker.com/hs-fs/hubfs/Signature%20Athletics%20Logo.png?width=200&height=64&name=Signature%20Athletics%20Logo.png)](https://help.signaturelocker.com/migration/support?hsLang=en)

- [SALES](https://help.signaturelocker.com/migration/support/sales)
- [ACCOUNT MANAGER](https://help.signaturelocker.com/migration/support/account-manager)
- [TICKET MANAGEMENT](https://help.signaturelocker.com/migration/support/ticket-management)
- [DESIGN](https://help.signaturelocker.com/migration/support/design-team)
  
  Show submenu for DESIGN

    - [TEAM](https://help.signaturelocker.com/migration/support/design-team#main-content)
    - [CREATIVE](https://help.signaturelocker.com/migration/support/design-creative#main-content)
- [ECOM](https://help.signaturelocker.com/migration/support/ecom)
- [OPS](https://help.signaturelocker.com/migration/support/ops)
- [MARKETING](https://help.signaturelocker.com/migration/support/marketing)

Open main navigation

Close main navigation

- [SALES](https://help.signaturelocker.com/migration/support/sales)
- [ACCOUNT MANAGER](https://help.signaturelocker.com/migration/support/account-manager)
- [TICKET MANAGEMENT](https://help.signaturelocker.com/migration/support/ticket-management)
- [DESIGN](https://help.signaturelocker.com/migration/support/design-team)
  
  Show submenu for DESIGN

    - [TEAM](https://help.signaturelocker.com/migration/support/design-team#main-content)
    - [CREATIVE](https://help.signaturelocker.com/migration/support/design-creative#main-content)
- [ECOM](https://help.signaturelocker.com/migration/support/ecom)
- [OPS](https://help.signaturelocker.com/migration/support/ops)
- [MARKETING](https://help.signaturelocker.com/migration/support/marketing)
- English
  
  Show submenu for translations
- [Signature Locker](https://signaturelocker.com/)

[Signature Locker](https://signaturelocker.com/)

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.signaturelocker.com/support?hsLang=en)
2. [Account Manager](https://help.signaturelocker.com/support/account-manager?hsLang=en)
3. [SKU Sheets](https://help.signaturelocker.com/support/account-manager?hsLang=en#sku-sheets)

# Generating SKU Sheets

## A step-by-step guide to duplicating, building, and quality-checking a SKU sheet for a uniform package — from setting up the classifier fields to submitting the final SKUs in HubSpot.

[▶ Watch the video: Account Manager: SKU Sheet Creation](https://www.loom.com/share/b1555e50c92a4f3f95a5a159849e6e92)

---

### **What You'll Need Before You Start**

- The finalized uniform proof for the package you're SKUing (keep it open the whole time — you'll use it to confirm identifiers and piece details)
- Access to Google Drive and the current SKU Sheet template (confirm it has the SKU Quality Checker built in — always use the newest version)
- The team's HubSpot ticket open, so you can match ticket identifiers and later update the Pending Pieces properties
- The team's contract details on hand: client name, program type (e.g., SPP), and design season

---

### **Step 1: Open the Uniform Proof**

Before touching the SKU sheet, open the uniform proof for the package you're working on. Keeping it visible throughout the process lets you cross-check every identifier and piece as you go, so nothing gets mismatched.

### **Step 2: Duplicate the SKU Sheet Template**

Go to Google Drive and search for the SKU sheet template. Before duplicating it, confirm you have the correct, most current version — it should include the SKU Quality Checker. Once confirmed, go to **File \> Make a copy**.

Always duplicate the newest SKU sheet template. Using an outdated version means missing the built-in SKU Quality Checker.

### **Step 3: Set the Classifier Fields**

In your new copy, go to the classifier and set the **Area of Interest** field. From there:

- Select the correct client under **Clients Under Contract**
- Choose the applicable program type (e.g., SPP) and locate the team alphabetically
- Select the team, and confirm the ticket number on the sheet matches the ticket number on the uniform proof

Once selected, the sheet will move into the correct section automatically. Close out of the original SKU sheet copy once this is done — you won't need it again.

### **Step 4: Clean Up the Sheet**

Hide any sport templates you don't need, leaving only the sport for this package (e.g., lacrosse). This keeps the sheet clean and easy to work in.

- Rename the tab **V1**. If design or artwork changes come in later, create a **V2**, and so on — this keeps a clear version trail.
- Copy the ticket number to the top of the sheet so it's visible when you run the SKU Quality Checker later.

### **Step 5: Add the Required SKUs for Each Package**

Go back to the uniform proof and identify every piece in the package. Find each corresponding SKU in the template, and hide or delete anything you don't need. If a piece is brand new and doesn't already exist on the template (like a new short style), write it in manually with the correct name.

| Package | SKUs Used (Example: Newtown Lacrosse) | Notes |
| --- | --- | --- |
| Men's three-piece package | 1001, 1003, 2001, 2010, 3010 | Standard pieces already on the template |
| Women's / girls' package | 1106, 1111, 2209 | 2209 was a new short not yet on the template — written in manually |
| Sold separately | 1107 (Pro Sleeveless), 4111 (Men's Short Sleeve Tee) | 4111 was not on the template — written in manually |

### **Step 6: Update Identifiers with Find & Replace**

Use **Command/Ctrl + F** (Find and Replace) to update the sheet's identifiers. This is faster than editing manually, and it guarantees every instance — including individual SKUs and package-level SKUs — gets updated consistently.

- Replace the placeholder team name with the actual team name (e.g., "Newtown Youth Lacrosse")
- Replace the placeholder with the team's four-digit identifier (e.g., "1394")
- Replace the placeholder design season with the current season (e.g., "27-1")
- Replace the gender variant placeholder "MXX" with the correct code (e.g., "MYL")

Use **Replace All** for each field, and double check the sheet afterward to confirm nothing was missed.

Find and Replace is the best practice here — it's the easiest way to keep the sheet uniform and avoid missing an instance of an identifier.

### **Step 7: Set Customization Levels**

Go through each item individually and assign a customization level based on how it's personalized on the design:

| Code | Customization Type |
| --- | --- |
| 401 | Name and number |
| 201 | Number only |

Multiple items in the same package can share the same code (e.g., 401) as long as they have different SKUs. If two items with the *same* SKU both need customization, use sequential codes instead (401, 402, etc.).

Always check the actual design before assigning a customization level — don't assume based on piece type. This step feeds directly into the SKU Quality Checker, so getting it right here prevents mis-SKUing downstream.

### **Step 8: Run the SKU Quality Check**

Copy the SKU Quality Checker link, load your Google Sheet URL into it, and click **Run**. Confirm all SKUs pass before moving on. This is a required step in the process, in addition to your own manual QC of the sheet.

### **Step 9: Finish the HubSpot Ticket**

Copy the finished SKUs into the **Pending Pieces** properties on the HubSpot sidebar, adding the style numbers for each piece. Once that's done, go back to the ticket, click **Approved** on the SKU, and move it to the next stage.

Don't skip adding style numbers to the HubSpot sidebar. It doesn't affect the SKU sheet itself, but it's a required part of the ticket and is easy to forget.

---

#### **Best Practices**

- Always duplicate the newest SKU sheet template and confirm it includes the SKU Quality Checker before starting
- Keep the uniform proof open throughout the process to cross-check identifiers and pieces
- Use Find and Replace instead of manual edits for team name, identifier, design season, and gender variant codes
- Version your sheet (V1, V2, etc.) whenever design or artwork changes come in
- Check the actual design before assigning customization levels — don't assume based on piece type
- Run the SKU Quality Checker every time, even after your own manual QC
- Add style numbers to the HubSpot sidebar before submitting — it's a required step that's easy to miss

---

- [Sales](https://help.signaturelocker.com/support/sales?hsLang=en#main-content)

    - [Tools & Resources](https://help.signaturelocker.com/support/sales?hsLang=en#tools-resources)
    - [SOP's](https://help.signaturelocker.com/support/sales?hsLang=en#sops)
    - [Product Training](https://help.signaturelocker.com/support/sales?hsLang=en#product-training)
    - [HubSpot Tickets](https://help.signaturelocker.com/support/sales?hsLang=en#hubspot-tickets)
- [Account Manager](https://help.signaturelocker.com/support/account-manager?hsLang=en#main-content)

    - [SOP's](https://help.signaturelocker.com/support/account-manager?hsLang=en#sops)
    - [SKU Sheets](https://help.signaturelocker.com/support/account-manager?hsLang=en#sku-sheets)
    - [Resources](https://help.signaturelocker.com/support/account-manager?hsLang=en#resources)
    - [HubSpot Tickets](https://help.signaturelocker.com/support/account-manager?hsLang=en#hubspot-tickets)
    - [HubSpot Tasks](https://help.signaturelocker.com/support/account-manager?hsLang=en#hubspot-tasks)
    - [Ziflow](https://help.signaturelocker.com/support/account-manager?hsLang=en#ziflow)
    - [Off Menu Items](https://help.signaturelocker.com/support/account-manager?hsLang=en#off-menu-items)
    - [Shopify](https://help.signaturelocker.com/support/account-manager?hsLang=en#shopify)
- [Ticket Management](https://help.signaturelocker.com/support/ticket-management?hsLang=en#main-content)

    - [Resources](https://help.signaturelocker.com/support/ticket-management?hsLang=en#resources)
    - [HubSpot Ticket](https://help.signaturelocker.com/support/ticket-management?hsLang=en#hubspot-ticket)
    - [HubSpot Tasks](https://help.signaturelocker.com/support/ticket-management?hsLang=en#hubspot-tasks)
    - [Ziflow](https://help.signaturelocker.com/support/ticket-management?hsLang=en#ziflow)
- [Design | Team](https://help.signaturelocker.com/support/design-team?hsLang=en#main-content)

    - [Design Rules by Sport](https://help.signaturelocker.com/support/design-team?hsLang=en#design-rules-by-sport)
    - [Adobe CC Libraries](https://help.signaturelocker.com/support/design-team?hsLang=en#adobe-cc-libraries)
    - [0. Vectorized Logos](https://help.signaturelocker.com/support/design-team?hsLang=en#0-vectorized-logos)
    - [2. Team Store](https://help.signaturelocker.com/support/design-team?hsLang=en#2-team-store)
    - [3. Uniforms](https://help.signaturelocker.com/support/design-team?hsLang=en#3-uniforms)
    - [4. Off-Menu | Apparel Collection](https://help.signaturelocker.com/support/design-team?hsLang=en#4-off-menu-apparel-collection)
    - [Resources](https://help.signaturelocker.com/support/design-team?hsLang=en#resources)
    - [Onboarding](https://help.signaturelocker.com/support/design-team?hsLang=en#onboarding)
- [Design | Creative](https://help.signaturelocker.com/support/design-creative?hsLang=en#main-content)

    - [SOP](https://help.signaturelocker.com/support/design-creative?hsLang=en#sop)
    - [Media](https://help.signaturelocker.com/support/design-creative?hsLang=en#media)
- [Design | Masters](https://help.signaturelocker.com/support/design-masters?hsLang=en#main-content)

    - [Training & Tutorials](https://help.signaturelocker.com/support/design-masters?hsLang=en#training-tutorials)
    - [Building 1Ds](https://help.signaturelocker.com/support/design-masters?hsLang=en#building-1ds)
    - [Building 2Ds](https://help.signaturelocker.com/support/design-masters?hsLang=en#building-2ds)
    - [Building 3Ds](https://help.signaturelocker.com/support/design-masters?hsLang=en#building-3ds)
    - [0. Vectorized Logos](https://help.signaturelocker.com/support/design-masters?hsLang=en#0-vectorized-logos)
    - [2. Team Store](https://help.signaturelocker.com/support/design-masters?hsLang=en#2-team-store)
    - [3. Uniforms](https://help.signaturelocker.com/support/design-masters?hsLang=en#3-uniforms)
    - [6. Signature Duffle Bag](https://help.signaturelocker.com/support/design-masters?hsLang=en#6-signature-duffle-bag)
- [eCom](https://help.signaturelocker.com/support/ecom?hsLang=en#main-content)

    - [On-Boarding](https://help.signaturelocker.com/support/ecom?hsLang=en#on-boarding)
    - [Team Store Builds](https://help.signaturelocker.com/support/ecom?hsLang=en#team-store-builds)
    - [Sizing & Size Charts](https://help.signaturelocker.com/support/ecom?hsLang=en#sizing-size-charts)
    - [2. Team Store](https://help.signaturelocker.com/support/ecom?hsLang=en#2-team-store)
    - [Ziflow](https://help.signaturelocker.com/support/ecom?hsLang=en#ziflow)
    - [Off-Menu | Apparel Collection](https://help.signaturelocker.com/support/ecom?hsLang=en#off-menu-apparel-collection)
    - [SPP Kick-Back](https://help.signaturelocker.com/support/ecom?hsLang=en#spp-kick-back)
- [Ops](https://help.signaturelocker.com/support/ops?hsLang=en#main-content)

    - [Ziflow](https://help.signaturelocker.com/support/ops?hsLang=en#ziflow)
    - [Production](https://help.signaturelocker.com/support/ops?hsLang=en#production)
- [Marketing](https://help.signaturelocker.com/support/marketing?hsLang=en#main-content)

    - [E-mail](https://help.signaturelocker.com/support/marketing?hsLang=en#e-mail)
    - [Social Media](https://help.signaturelocker.com/support/marketing?hsLang=en#social-media)
- [HubSpot](https://help.signaturelocker.com/support/hubspot?hsLang=en#main-content)

    - [Process Updates](https://help.signaturelocker.com/support/hubspot?hsLang=en#process-updates)
    - [Deals](https://help.signaturelocker.com/support/hubspot?hsLang=en#deals)
    - [Tickets](https://help.signaturelocker.com/support/hubspot?hsLang=en#tickets)
    - [Tasks](https://help.signaturelocker.com/support/hubspot?hsLang=en#tasks)
- [Ziflow](https://help.signaturelocker.com/support/ziflow?hsLang=en#main-content)

    - [Process Updates](https://help.signaturelocker.com/support/ziflow?hsLang=en#process-updates)
    - [Tips & Tricks](https://help.signaturelocker.com/support/ziflow?hsLang=en#tips-tricks)
    - [0. Vectorized Logos](https://help.signaturelocker.com/support/ziflow?hsLang=en#0-vectorized-logos)
    - [3. Uniforms](https://help.signaturelocker.com/support/ziflow?hsLang=en#3-uniforms)
    - [4. Off-Menu](https://help.signaturelocker.com/support/ziflow?hsLang=en#4-off-menu)
    - [Troubleshooting](https://help.signaturelocker.com/support/ziflow?hsLang=en#troubleshooting)
- [Google Drive](https://help.signaturelocker.com/support/google-drive?hsLang=en#main-content)

    - [Tech & Systems](https://help.signaturelocker.com/support/google-drive?hsLang=en#tech-systems)
    - [Process Updates](https://help.signaturelocker.com/support/google-drive?hsLang=en#process-updates)
- [Slack](https://help.signaturelocker.com/support/slack?hsLang=en#main-content)

    - [Lists](https://help.signaturelocker.com/support/slack?hsLang=en#lists)
    - [Design](https://help.signaturelocker.com/support/slack?hsLang=en#design)
- [Resources](https://help.signaturelocker.com/support/resources?hsLang=en#main-content)

    - [Assets](https://help.signaturelocker.com/support/resources?hsLang=en#assets)
    - [Policies & Procedures](https://help.signaturelocker.com/support/resources?hsLang=en#policies-procedures)
    - [Signature Communication Policy](https://help.signaturelocker.com/support/resources?hsLang=en#signature-communication-policy)
    - [Trackers](https://help.signaturelocker.com/support/resources?hsLang=en#trackers)
- [Glossy & Terms](https://help.signaturelocker.com/support/glossy-terms?hsLang=en#main-content)

    - [F](https://help.signaturelocker.com/support/glossy-terms?hsLang=en#f)

- [SALES](https://help.signaturelocker.com/migration/support/sales)
- [ACCOUNT MANAGER](https://help.signaturelocker.com/migration/support/account-manager)
- [TICKET MANAGEMENT](https://help.signaturelocker.com/migration/support/ticket-management)
- [DESIGN](https://help.signaturelocker.com/migration/support/design-team)
- [ECOM](https://help.signaturelocker.com/migration/support/ecom)
- [OPS](https://help.signaturelocker.com/migration/support/ops)
- [MARKETING](https://help.signaturelocker.com/migration/support/marketing)

[![Chill listening crop-3](https://help.signaturelocker.com/hs-fs/hubfs/Signature%20Athletics%20Logo.png?width=150&height=48&name=Signature%20Athletics%20Logo.png "Chill listening crop-3")](https://help.signaturelocker.com/migration/support?hsLang=en)

For The Players. By The Players.

Copyright © 2026, Signature Athletics