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: 

  1. Primary access to the Product menu
  2. 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

Still need help? Contact Us Contact Us