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 |