Adjust - Enter a value into this cell to ADD units to the Inventory cell
Replace - Enter a value into this cell to completely REPLACE units in the Inventory cell
Inventory - Starting inventory count. Does NOT change as units are deducted. Can be edited directly or added to with Adjust Inventory cell.
Processing - Units in Processing (or "pending") orders, not yet deducted
Confirmed - These are units sitting in Complete orders. (Inventory - Confirmed = Available)
Available - Units available to be ordered, also the value displayed on the product. (Inventory minus Confirmed = Available).
Exported - units on their way out (any units in Exported orders)
Archived - units cleared, historic count (after updating Inventory, Exported units will move to Archived)