Products

Finished goods you price, stock, and sell to customers.


Products are the finished goods you price, stock, and sell to customers. They power sales orders, inventory, and reporting.

What a product is

A product includes the standard item fields (SKU, description, category, units, cost) plus:

FieldPurpose
Product typeControls workflow behavior: sale, service, shipping, credit, return, tax
Product lineOptional grouping for reporting, pricing, and commission/freight rules
MarginProfit margin
Unit valueThe default sell price

Product types

Every product has a type that determines how it behaves across workflows:

  • Sale: standard physical goods (the default type). Appears in orders, inventory, shipping, and invoicing.
  • Service: non-physical items like consulting or labor hours. No inventory impact, no shipping.
  • Shipping: represents shipping charges on an order. Tied to freight calculation.
  • Credit: represents credits or adjustments. Reduces the order total.
  • Return: represents returned goods. Triggers reverse inventory flow.
  • Tax: represents tax line items on an order.

Product lines

Product lines are a grouping for products. Each product line has:

  • Name (e.g., "Dress Socks", "Athletic Socks")
  • Unit group: determines which units are available for products in this line
  • Commission-exempt flag: products in this line are excluded from sales commission calculations
  • Freight-exempt flag: products in this line are excluded from freight cost calculations

Product lines drive reporting rollups and pricing rules across your catalog.

Product categories

Products use product categories (shared with parts, separate from material categories). A category defines the unit group, properties, and attributes: the same system used by materials with their own category type.

Categories drive reporting, pricing rules, and filtering across the products list.

How products are used

  • Sales orders: products are line items with quantities and pricing
  • Customer pricing: customer-specific prices, volume discounts, and discount codes reference products
  • Inventory: full tracking: receipts, issues, allocations, and available-to-promise
  • Purchasing: products can appear on purchase orders if you buy finished goods
  • Shipping & invoicing: what gets fulfilled and billed to customers
  • Analytics: revenue, volume, margins, and product-line performance

Creating a product

  1. Navigate to Products → Create Product
  2. Enter SKU (required)
  3. Select category (required)
  4. Optionally set: description, product line, unit value (sell price), unit cost
  5. Product type defaults to sale: change if needed
  6. Set attribute values for category properties
  7. Click Create

Bulk create: upload an Excel file to create multiple products at once. The system creates new products, updates existing ones (matched by SKU), and reports skipped rows with reasons.

Managing products

  • Card-based grid like materials and parts
  • Product line selector on each card (unique to products)
  • Unit value (sell price) field: editable inline
  • Search by SKU or description
  • Filter by category, product line, customer, date range, and attributes (customer and product line filters are unique to products)
  • Export to Excel
  • QR code generation per product
  • Discontinue (soft delete): the product remains in historical records but is no longer active

Typical lifecycle

  1. Create: define SKU, category, product line, and pricing
  2. Configure pricing: set customer-specific prices and volume discounts
  3. Use in orders: add to sales orders and quotes
  4. Track: monitor inventory, fulfillment, and margins
  5. Maintain: update pricing, metadata, and discontinue when needed

Next: Suppliers