- Products Sub-Module
 

(Core of the Product Report System)
 

The Products sub-module is the foundation of the entire Product Report.
Every order, document, storage movement, supplier record, and sales report depends on the data defined here.

- What This Module Represents
 

Think of Products as the single source of truth for everything related to items you sell, store, insure, or subscribe.

Once a product exists here, it becomes globally usable across the system.


- Visual Placement in System


Product Report
│
├──  Products  ← (YOU ARE HERE – CORE)
│
├── Product Categories
├── Product Groups
├── Orders
├── User Sales
├── Customer Sales
├── Storage
├── Suppliers
├── Insurance


 No other sub-module can work without Products


 

- What Happens When a Product Is Created
 

- Immediately After Clicking “Save”
 

✔ Product gets a unique system ID
✔ Appears in Orders, Invoices, Storage, Reports
✔ Becomes selectable everywhere
✔ Status = Active
✔ Ready for business use

There is no duplication — all modules reference the same product ID.


- Product Lifecycle (Visual Flow)

Create Product
     ↓
Assign Category & Price
     ↓
(Optional) Bind to Storage
     ↓
Used in Orders / Documents
     ↓
Stock & Sales Auto-Updated
     ↓
Reports Generated
     ↓
Deactivate (Archive) if needed


 

- What a “Product” Really Is in the System
 

A product is NOT just a name and price.
 

A product is a business object that contains:
 

• Identity (name, SKU, internal SKU)

• Classification (category, sub-category, groups)

• Financial rules (price, tiers, discounts)

• Inventory behavior (stock, left, sold)

• Operational logic (storage, supplier)

• Lifecycle rules (active, inactive, archived)

• Behavioral rules (subscription vs one-time)

Once created, this object becomes immutable history for reporting.


 

- Pricing Intelligence (Business-First)
 

Each product defines pricing rules, not just a number.
 

The system understands:
 

• base selling price

• multiple alternative prices

• discounts (fixed or percentage)

• subscription pricing timelines
   

When a product is used in a document:

➡️ the price is locked at that moment
➡️ future price changes do not affect history
 

This protects:
 

• invoices

• accounting

• tax records

• audits
  
   

  - Product Types (Why It Matters)
   

  - Regular Product
   

  Used when:

• item is sold once

• stock must decrease

• revenue is immediate
   

• - Subscription Product
   

  Used when:
   

• billing repeats

• time-based logic applies

• stock may not apply
   

• Subscription products behave differently:

• charge cycles
   

• Yet they still live inside Products, because:

  the system treats everything sellable as a product.

  ---

  - How Other Modules “See” Products
  
  Other modules never redefine products.
  They only reference them.
  
  
  Order → Product ID
  Invoice → Product ID
  Storage → Product ID
  Report → Product ID
  
  
  This ensures:
  
  ✔ no duplication
  ✔ consistent reporting
  ✔ clean data relationships

- Product + Storage Relationship (Mental Model)
 

A product can exist:
 

• without storage

• with one storage

• with multiple storages
   

Storage controls:
 

• quantity

• movement

• availability
   

Product controls:
 

• identity

• price

• logic
   

They are linked, not merged.

 

- Supplier Relationship (Conceptual)
 

Suppliers are metadata providers, not owners.
 

A product can:
 

• have one supplier

• have many suppliers

• have none
   

Supplier affects:
 

• cost reference

• purchasing workflow
   

Supplier does NOT affect:
 

• selling price

• inventory logic

• reports visibility
  
   

  - Permissions & Safety Design
   

  The Products module is intentionally locked down.

  Why?
  
  Because mistakes here affect everything.
   

  Examples:
   

• Cost price hidden from sales users

• Delete blocked once product is used

• This ensures:
  
  ✔ financial safety
  ✔ historical integrity
  ✔ audit readiness
  
   

  - Deletion Philosophy (Important)
   

  The system follows this rule:
  
   

  “Business data is never destroyed — only retired.”

  
  So:

• Products used in documents cannot be deleted

• They can only be marked Inactive

• Inactive products:

• disappear from new orders

• remain visible in reports

• preserve accounting truth
  
  
   

  - Import & ? Export (Why It Exists)
   

  Import
   

  Used for:

• initial system setup

• migration from other systems

• bulk updates
   

  Export
   

  Used for:

• audits

• external analysis

• backups

• compliance
   

• Both respect:
   

• permissions

• visibility rules

• custom fields
  
  
   

  - Final Definition (Strong Statement)
   

  The Products sub-module is the foundational business engine of the Product Report system.
  It defines sellable entities, controls pricing logic, governs inventory behavior, and
  enables  all operational and analytical workflows across the platform.