Skip to main content

Item Categories

Audience: Business stakeholders, product managers, operations team

Overview​

Item categories are a way to organize and classify inventory items into logical groups. Categories help you find items quickly, analyze inventory by product type, and generate meaningful reports.

Our system supports hierarchical categories—categories can contain subcategories, creating a multi-level classification tree.

What is an Item Category?​

Definition​

A category is a classification group that items belong to based on shared characteristics, purpose, or business function.

Examples​

  • Raw Materials - Components used in manufacturing
  • Finished Goods - Products ready to sell
  • Packaging - Boxes, bottles, labels
  • Fragrances - Essential oils, perfume concentrates
  • Luxury Items - High-end products

Why Categories Matter​

  1. Organization: Find items faster in a large catalog
  2. Reporting: Analyze sales or inventory by category
  3. Pricing: Apply category-level pricing rules
  4. Permissions: Restrict access to certain categories
  5. Planning: Plan purchasing or production by category

Hierarchical Categories​

Categories can have parent-child relationships, creating a tree structure.

Simple Hierarchy Example​

Levels​

  • Level 1 (Top): All Items
  • Level 2: Finished Goods, Raw Materials, Packaging
  • Level 3: Perfumes, Gift Sets | Fragrances, Chemicals | Bottles, Boxes
  • Level 4: Men's Perfumes, Women's Perfumes

Real-World Category Structures​

Example 1: Perfume Company​

Example 2: By Product Line​

How Categories Work​

Category Properties​

Each category has:

  1. Code - Short identifier (e.g., "FG-PERF-WOMEN")
  2. Name - Display name (e.g., "Women's Perfumes")
  3. Description - Detailed explanation
  4. Parent Category - Which category this belongs to (if any)
  5. Child Categories - Subcategories under this one

Item Assignment​

Each item can belong to one category.

Example:

  • Item: Midnight Rose Eau de Parfum 50ml
  • Category: Finished Goods → Eau de Parfum → Women's EDP
  • Full Path: Finished Goods / Eau de Parfum / Women's EDP

Category Paths​

The system tracks the full path from root to item's category:

Examples:

  • Raw Materials / Fragrances / Floral Oils
  • Finished Goods / Gift Sets
  • Packaging Materials / Bottles & Caps

Business Scenarios​

Scenario 1: Finding Items​

Question: "Show me all women's perfumes"

Without Categories:

  • Search through 5,000 items manually
  • Rely on item names containing "women"
  • Miss items with unclear names

With Categories:

  • Navigate to: Finished Goods → Eau de Parfum → Women's EDP
  • See all 150 women's EDP items instantly

Benefit: Fast, accurate filtering

Scenario 2: Sales Reporting​

Question: "What were sales by product line last quarter?"

Report:

Luxury Line:        $450,000 (45%)
Everyday Line:      $350,000 (35%)
Seasonal Collections: $200,000 (20%)

Sub-Report for Luxury:

Luxury Women's: $280,000 (62% of luxury)
Luxury Men's:   $170,000 (38% of luxury)

Benefit: Strategic insights by category

Scenario 3: Inventory Valuation​

Question: "How much raw material inventory do we have?"

Without Categories:

  • Manually identify which items are raw materials
  • Calculate values individually

With Categories:

  • Filter by "Raw Materials" category
  • System sums all items in that category and subcategories

Result:

Raw Materials Total: $125,000

  Breakdown:
  - Fragrances:        $75,000 (60%)
  - Alcohol & Solvents: $30,000 (24%)
  - Fixatives:         $20,000 (16%)

Benefit: Instant category-level valuation

Scenario 4: Purchasing Workflows​

Rule: "Raw material purchases require quality inspection"

Setup:

  • Items in "Raw Materials" category → auto-route to Quarantine location
  • Items in "Packaging" category → direct to warehouse
  • Items in "Finished Goods" → direct to finished goods area

Benefit: Automated workflows based on category

Category Hierarchy Benefits​

Roll-Up Reporting​

When you query a parent category, you get all child categories automatically.

Example:

  • Query: "Finished Goods" inventory value
  • Result: Includes Perfumes + Gift Sets + all subcategories
  • No need to query each subcategory separately

Drill-Down Analysis​

Start broad, then narrow down:

Path:

  1. View all "Finished Goods" → $500,000
  2. Drill into "Eau de Parfum" → $300,000
  3. Drill into "Women's EDP" → $180,000
  4. See individual items

Flexible Organization​

Categories can evolve without breaking structure:

Add New Subcategory:

  • Create "Teen Line" under "Everyday Line"
  • Existing reports still work
  • New category shows up in drill-downs

Business Rules​

Rule 1: Each Item Has One Category​

Valid:

  • Item belongs to "Women's EDP"

Invalid:

  • Item belongs to both "Women's EDP" and "Luxury Line"

Solution: Choose the most specific category. Use tags or custom fields for additional classification.

Rule 2: Categories Can Have Multiple Children​

Valid:

Finished Goods
  ├── Eau de Parfum
  ├── Eau de Toilette
  ├── Eau de Cologne
  └── Gift Sets

Benefit: Flexible hierarchy

Rule 3: No Circular References​

Invalid:

  • Category A is parent of Category B
  • Category B is parent of Category A

Why: Creates infinite loops in reporting

System: Prevents circular relationships

Rule 4: Parent Categories Can't Be Deleted If They Have Children​

Scenario: Try to delete "Finished Goods" category

Result: Error—it has child categories (Perfumes, Gift Sets)

Solution:

  1. Move or delete all child categories first
  2. Then delete parent

Category Hierarchy Visualization​

Full Category Path​

Full Path: Root / Finished Goods / Perfumes / Women's Perfumes

Item: Midnight Rose 50ml belongs to "Women's Perfumes"

Sibling Categories​

Siblings: Women's, Men's, and Unisex are all children of "Perfumes"

Common Questions​

Q: Can I move an item to a different category later?​

A: Yes, items can be recategorized. However:

  • Historical reports may show the old category
  • Consider impact on reporting and analytics
  • Document why the change was made

Q: How deep can the category hierarchy go?​

A: Technically unlimited, but 3-5 levels is practical:

  • Level 1: Division (Finished Goods)
  • Level 2: Product Type (Perfumes)
  • Level 3: Gender (Women's)
  • Level 4: Sub-type (Eau de Parfum)
  • Level 5: Collection (Luxury Line)

Deeper = more complex, harder to navigate

Q: Can categories overlap?​

A: No. Categories are mutually exclusive—an item belongs to one category only.

Alternative: Use custom fields or tags for cross-cutting classifications (e.g., "Organic", "Vegan", "Seasonal")

Q: What if I don't want a hierarchy?​

A: Create all categories at the top level (no parent categories). They'll work as a flat list.

Example:

  • Perfumes
  • Gift Sets
  • Raw Materials
  • Packaging

No hierarchy, just a simple list.

Q: Should I create categories before items or vice versa?​

A: Create categories first, then assign items to them.

Why: Helps plan your organizational structure before data entry

Best Practices​

1. Plan Your Hierarchy​

Before Creating Categories:

  • Map out your product structure on paper
  • Align with how your business thinks about products
  • Keep it simple (3-4 levels maximum)
  • Get input from stakeholders (sales, operations, finance)

2. Use Meaningful Names​

Poor:

  • Category 1
  • Group A
  • Misc

Better:

  • Finished Goods
  • Luxury Line
  • Seasonal Products

3. Create Categories Based on Business Function​

Good Criteria:

  • Product type (Perfume vs Gift Set)
  • Production method (Manufactured vs Purchased)
  • Business line (Luxury vs Everyday)
  • Sales channel (Retail vs Wholesale)

Poor Criteria:

  • Warehouse location (changes over time)
  • Supplier (not inherent to the item)
  • Temporary status

4. Keep "Miscellaneous" to a Minimum​

Problem: "Miscellaneous" category becomes a dumping ground

Solution:

  • Create specific categories for common items
  • Reserve "Miscellaneous" for truly one-off items
  • Review quarterly and create new categories as needed

5. Use Consistent Naming Conventions​

Examples:

  • Finished Goods → Perfumes → Women's Perfumes (noun phrases)
  • FG → PERF → WOMEN (short codes)

Pick one style and stick with it

Reporting and Analytics​

Inventory by Category​

Report: Current inventory value by category

Category                    Qty     Value
────────────────────────────────────────
Finished Goods            5,000   $500,000
  ├─ Perfumes            3,500   $400,000
  │   ├─ Women's         2,000   $250,000
  │   ├─ Men's           1,200   $120,000
  │   └─ Unisex            300    $30,000
  └─ Gift Sets           1,500   $100,000

Raw Materials             8,000   $125,000
  ├─ Fragrances          2,000    $75,000
  └─ Chemicals           6,000    $50,000

Packaging                15,000    $35,000

Sales by Category​

Report: Year-to-date sales by category

Category              Revenue      % of Total
────────────────────────────────────────────
Perfumes            $1,200,000         75%
Gift Sets             $300,000         19%
Accessories           $100,000          6%

Profitability by Category​

Report: Gross margin by category

Category         Revenue    COGS      Margin    Margin %
──────────────────────────────────────────────────────
Luxury Line      $450,000  $180,000  $270,000      60%
Everyday Line    $350,000  $210,000  $140,000      40%
Seasonal         $200,000  $140,000   $60,000      30%

Integration with Other Concepts​

Items​

Relationship: Every item belongs to one category

See: Stockable Items

Inventory Transactions​

Impact: Transactions can be filtered and reported by category

See: Inventory Transactions

Financial Reporting​

Impact: GL accounts may be linked to categories for automated posting

See: Finance Integration

Last Updated: 2025-10-28