Data Model Overview

This page provides a high-level overview of how Product Fees data is structured.

Fee Types

A fee type defines reusable metadata such as:

• internal code
• customer-facing label
• calculation type (fixed/percent)
• taxable flag
• active status and sort order

Product Assignments

Fee types are assigned to products with website scope and amount values.

Sales Snapshots

When a customer checks out, fee details are stored as snapshots on sales items so the same fee breakdown can be reused in:

• orders
• invoices
• credit memos
• emails and PDFs

Why Snapshots Matter

Snapshots keep fee values stable for document history, even if fee setup changes later.

Note

This customer-facing KB intentionally avoids SQL instructions. Use admin workflows for setup and maintenance.