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 overselling.
Each Inventory SKU is linked to a product.
Before sales of any product occur, the inventory SKU should be created and linked to the product, and beginning inventory counts added to each location that has inventory.
Permission Required: To access the inventory settings, your user account must be enabled with two permissions:
- Primary access to the Product menu
- The permission to access the sub-menu option for Inventory
Contact your eCellar User Manager for assistance.
Create an Inventory SKU
In the Admin Control Panel (ACP) navigate to Products > Inventory > Admin > SKUs.
Select to Add New Inventory item link.
Complete the appropriate fields then Save the SKU.
NOTE:
- Once the SKU field is entered and saved, it cannot be edited.
- Once an Inventory SKU is saved, it cannot be deleted.
Required fields for wine products are highlighted.
| SKU: | Follow your internal SKU format |
| TTB ID: | Label ID supplied by the government |
| Active: | Allows the SKU to be assigned to product and sold |
| Allow Negative: | Allows inventory to deplete beyond a zero count |
| Description: | This is the product name (i.e. 2011 Yountville Cabernet Sauvignon 750ml) |
| COGS: | Cost of Goods: Not required but is available in some reports |
| Unit Volume: | Select from dropdown |
| Bottles in Case: | How many bottles (units) are in each case |
| Supplier SKU: | Optional: May the same as the SKU field, or other |
| Alcohol %: | This data is available in compliance/data exports |
| Varietal: | Select from dropdown |
| Vintage: | Year harvested |
| Terroir: | Pptional |
| Release Date: | Optional: Used to track pre and post release revenue |
| Organic: | Optional |
| Notes: | Optional |