Create an Inventory SKU
The inventory SKU represents a single product unit, and tracks the depletion of SKU units as products are sold to prevent the overselling. Each Inventory SKU is linked to a product. Before sales of any product occur, the inventory SKU must be created and linked to the product, and beginning inventory counts added to each location.
Permission Required: To access the inventory settings, your user account must be enabled with two permissions:
1.) Primary access to the Product menu, and
2.) The permission to access the sub-menu option for Inventory
Contact your eCellar User Manager for assistance.
To create an inventory SKU begin at the Admin Control Panel (ACP) and navigate to Products > Inventory > Admin > SKUs. Select to Add New Inventory item link.
Complete the appropriate fields then Save the SKU. Once a SKU is created, it cannot be deleted. Be very careful!
Required fields for wine products are highlighted. For Merchandise you would enter sku, description and supplier sku only.
| SKU: | Follow your internal SKU format |
| TTB ID: | Should be the same as the SKU (required for wine) |
| Active: | Select to activate the SKU |
| Allow Negative: | Do not check this, unless you want to allow inventory to deplete beyond what is available |
| Description: | This is the product name (i.e. 2011 Yountville Cabernet Sauvignon 750ml) |
| COGS: | Not required but is available in cost reporting |
| Unit Volume: | Select from dropdown |
| Bottles in Case: | Enter how many bottles (units) are in each case |
| Supplier SKU: | Enter the same as the SKU field |
| Alcohol %: | Enter alcohol % if it's a wine product, this data is available in compliance/data exports |
| Varietal: | Select from dropdown |
| Vintage: | Enter vintage of product |
| Terroir: | optional |
| Release Date: | User to track pre and post release revenue |
| Organic: | optional |
| Notes: | optional |