How to Add SKUs in SUPPLY

SUPPLY is the source of truth for your case goods inventory.  In SUPPLY, the SKU represents the specific wine, format and grouping being tracked (e.g., 750ml bottle, 12-bottle case) across inventory locations. This article details:

• How to Add a SKU
• SKU Attributes
• How to Edit SKUs
• FAQ

How to Add a SKU

1. From the SKU Explorer, click on + Add SKU in the top right corner.
2. In the “Add SKU” window, enter all required SKU attributes.  
   SKU code (required), color (required), name (optional), style (required), Format (required), Group name (required), Weight per bottle (optional), Weight per case (optional), stage (required), price (optional) and COGS (optional)  can be updated after SKU creation. Users with the C7 integration may link at SKU creation, or after.
    
   Format, Group name and Tax class cannot be edited after SKU creation. To update an incorrect SKU after creation, you will need to delete and recreate the SKU.  
   
   
   
   
   
   
3. Click the Add SKU button in the bottom right corner to generate the SKU.

SKU Attributes

When creating a new SKU, you will need to set all the attributes associated to your SKU, including the new SKU code. Learn more about each attribute, and how it is used:

• SKU Code (Required): Enter a SKU code. The SKU code is the alphanumeric code (eg SB24MBV1A75012) and must be unique, meaning it cannot already be used for another SKU. The SKU code can contain numbers, letters, dashes and underscores. The system will not accept character accents such as ü in Gewürztraminer or ã in Tinto Cão. SKU codes have a character limit of 50. The code can be edited after SKU creation.
• SKU Name (optional): Enter a SKU name. The SKU name is text that makes it visibly easy to identify SKUs (eg 2024 Mockingbird Vista Sauvignon Blanc). SKU names do not need to be unique and have a character limit of 250. If no SKU name is entered, No name will display in the SKU Explorer and on the SKU details page. The name can be edited after SKU creation.
• Color (Required): Select a SKU color from the list. This can be edited after creation. 
• Style (Required): Select a wine style using the radio buttons - still or sparkling. You may edit the style after SKU creation. 
• Format (Required): Select a bottle format for the SKU from the list. This cannot be edited after SKU creation. 
• Group name (Required): Select a grouping for the SKU. The grouping describes the packaging of the selected format, and defines the number of individual units that are contained in a SKU item, such as a 3-pack, a 6-pack or a case (a "case" always contains 12 bottles). The Grouping name cannot be edited after SKU creation. 
  
     
• Weight per bottle: Set the item weight on a SKU to help calculate the BOL inventory weight when the BOL includes single bottles.
• Weight per case: Set the group weight on a SKU to help calculate the BOL inventory weight when the BOL includes cases/groups. This should include the weight of the box or insert, and is not calculated from the bottle weight. 
• Tax Class (Required): Select a tax class from the list. You may not edit the tax class after creating the SKU.
• Stage (Required): Select a stage from the list. Stages are helpful to generally classify where SKUs are in their lifecycle. You can filter by stage in the SKU Explorer and SKU Picker. You may edit the stage after creating the SKU. 
  
  • Stages have no bearing on compliance reports. Available stages include:
    • Pre-bottling - used if a SKU has been created but hasn't yet been bottled and doesn't have inventory
    • Pre-release - SKU has been bottled but isn't ready to be released/sold
    • Shiner - Bottled but not labeled
    • Labeled - Often used if the lot was previously shiners to now show it's been labeled
    • On Tirage - Relates to sparkling, if no sparkling production it's not relevant (in the US we recommend keeping en tirage in bulk wine tracking in MAKE for compliance purposes)
    • Aging - Bottled but needs to be bottle-aged before release
    • Ready for release - Finished aging and ready to be released
    • Released - SKU is released and available to be sold
    • Library - Inventory set aside for additional aging to be sold or tasted at a later date

• Price per bottle (Optional): Use this field to set a standard per-item price on a SKU. This price automatically populates the price field for the item when that SKU is added to an order.  Price may be entered at SKU creation or from the SKU details page.
• Price per case (Optional): Use this field to set a standard per-group price on a SKU. This price automatically populates the price field for the group when that SKU is added to an order. Price may be entered at SKU creation or from the SKU details page.
• COGS per bottle (Optional): Record the cost associated with producing or acquiring inventory for a given SKU. Set COGS at SKU creation or from the SKU details page
• COGS per case (Calculated): a calculated value derived from the COGS per bottle. 
• C7 Product (Optional): Check the box to link the SKU to a product in Commerce 7. Learn more about the C7 integration here. Link SKUs at creation, or from the SKU details page later.
  
  

How to Edit SKUs

You may edit many SKU properties and attributes after creation, including the SKU code, SKU name, color and style, and Commerce7 product.  You may not edit the format or grouping, or the tax class. 

To edit the SKU properties: code, name, color or style

Go to your SKU details page, and use the "More" menu at the top righthand corner. 

To edit the Commerce7 Product:

Go to your SKU details page, and use the "More" menu at the top righthand corner. Select "Edit C7 product."

To edit the SKU Stage, Price, Weight or COGS:

Go directly to the Attributes tile in the SKU details page and click on the blue pencil.

To update a SKU created in the wrong format, grouping or tax class, you will need to delete it and re-create it correctly. 

FAQ

Q: I added my SKU but how do I update the number of cases I have?

A: If you are onboarding current case goods inventory to bring SUPPLY up to date - use the "Onboard Inventory" action. This will populate the line "On hand at beginning of period" for in-bond products on the TTB export. Learn more about this action here.

If you are adding inventory to a bonded location in SUPPLY via a bond transfer or bottling - be sure to use the "Add Inventory" action which will allow you to specify the desired reason for adding the inventory, and properly populate the TTB export.  Learn more about this action here. 

Q: Can I delete or archive a SKU?

A: Find out how to archive or delete a SKU here!