SKU Numbering Best Practices

SKU Numbering Best Practices

SKU assignment should follow a standard of organization that follows a hierarchy of category based menus.

Standards:

F&B

Menu Categories: By following this best practice, menu categories will be identified by single digit integers (i.e. 1001001- the one in the middle marks the category)

***Note the transition of numbers and categories

We suggest starting your 7 digit SKU number with the following when creating menu items;

1 - Food

2 - Beer

3 - Wine

4 - Liquor

5 - Non-alcoholic beverages

6 - ?

7 - Retail

8 - Miscellaneous

9 - Modifiers

Item Categories: Item categories will be identified by four digit integers where the first digit is the menu category to which it is associated. We should use the Canopy Display Name to include the number identifier for the category.

1000 - Entrees

1001 -

1002 - Snacks

1003 - Candy

For Modifiers we should the following case:

9001 - Food mods that start with letter A (i.e. Avocado)

9002 - Food mods that start with letter B

...

9026 - Food mods that start with letter Z

9050 - Drink mods that start with A

...

9075 - Drink mods that start with Z

You can also further separate modifiers by adding the main category the modifier is attached to, with the 2nd digit. Then continue with 3rd and 4th digit applying to alphabetical representation.

9101 - entree modifier (with letter A)

9226 - beer modifier (with letter Z)

9323 - wine modifier (with letter W)

Items: Items will be identified with a 9 digit SKU where the first 4 digits represent the item category to which they belong

Merchandise:

Menu Categories: Menu categories will be identified by two digit integers and the following categories should be adhered to in general.

10 - Apparel

11 - Souvenirs

19 - Consignments

Item Categories: Item categories will be identified by three digit integers where the first two digits are the menu category to which it is associated. We should use the Canopy Display Name to include the number identifier for the category.

100 - Men’s Apparel

101 - Women’s Apparel

102 - Children’s Apparel

103 - Hats

Items: Items will be identified with a 7 digit SKU where the first 3 digits represent the item category to which they belong