Sales Management
Sales Management
Manage sales operations for educational institutions including selling course materials, uniforms, merchandise, event tickets, and publications through quotations, orders, and invoicing.
Time Required: 10-30 minutes per transaction Module: Sales User Role: Sales User, Sales Manager
Table of Contents
- Overview
- Configuration
- Managing Products
- Creating Quotations
- Quotation Templates
- Confirming Sales Orders
- Pricelists
- Discounts
- Invoicing
- Down Payments
- Field Reference
- Troubleshooting
Overview
The Sales module in OpenEduCat enables educational institutions to sell:
| Product Category | Examples |
|---|---|
| Course Materials | Textbooks, lab kits, art supplies, study guides |
| Uniforms & Apparel | School uniforms, sports jerseys, graduation gowns |
| Merchandise | Branded items, stationery, bags, water bottles |
| Event Tickets | Concerts, sports events, graduation ceremonies |
| Publications | Yearbooks, newsletters, research journals |
| Services | Tutoring sessions, certification exams, facility rentals |
Key Features
- Create and send professional quotations
- Convert quotations to sales orders
- Flexible pricing with pricelists and discounts
- Multiple invoicing options (ordered vs. delivered quantities)
- Down payment support for high-value items
- Online payment and signature integration
Configuration
Step 1: Enable Sales Settings
- Go to Sales > Configuration > Settings
- Configure the following options:
| Setting | Description | Recommended for Education |
|---|---|---|
Quotation Templates | Create reusable quote templates | Enable for standard product bundles |
Online Signature | Request signature to confirm | Enable for high-value orders |
Online Payment | Request payment to confirm | Enable for event tickets, merchandise |
Default Quotation Validity | Days before quote expires | 15-30 days |
Lock Confirmed Sales | Prevent edits after confirmation | Enable for audit compliance |
Pro-Forma Invoice | Send preliminary invoices | Enable for international sales |
- Click Save
Step 2: Configure Invoicing Policy
Choose how products are invoiced:
| Policy | When to Use | Educational Example |
|---|---|---|
| Invoice what is ordered | Immediate billing | Event tickets, digital materials |
| Invoice what is delivered | Bill after delivery | Textbooks, uniforms, equipment |
Navigate to Sales > Configuration > Settings > Invoicing to set the default policy.
Managing Products
Create Educational Products
- Go to Sales > Products > Products
- Click Create
- Fill in product details:
| Field | What to Enter | Example |
|---|---|---|
Product Name | Descriptive name | ”Chemistry Lab Kit - Grade 10” |
Product Type | Storable/Consumable/Service | Storable Product |
Sales Price | Base selling price | 75.00 |
Cost | Purchase/production cost | 45.00 |
Can be Sold | Enable for sales | Checked |
Invoicing Policy | Ordered/Delivered quantities | Ordered quantities |
Internal Reference | SKU code | ”LAB-CHEM-G10” |
- Click Save
Product Variants
Use variants for products with multiple options (sizes, colors):
Example: School Uniform Polo Shirt
- Go to Sales > Configuration > Attributes
- Create attributes:
| Attribute | Values | Display Type |
|---|---|---|
| Size | XS, S, M, L, XL, XXL | Pills |
| Color | Navy Blue, White, Gray | Color |
- On the product form, go to Attributes & Variants tab
- Add attributes and select values
- System generates all variant combinations automatically
Product Categories
Organize products by category:
| Category | Products |
|---|---|
| Course Materials | Textbooks, workbooks, lab supplies |
| Uniforms | Shirts, pants, shoes, accessories |
| Events | Tickets, registrations, booth spaces |
| Merchandise | Branded items, gifts, souvenirs |
| Services | Tutoring, certifications, rentals |
Creating Quotations
Step 1: Start a New Quotation
- Go to Sales app (main dashboard)
- Click New button
- The quotation form opens
Step 2: Enter Customer Information
| Field | Required | Description | Example |
|---|---|---|---|
Customer | Yes | Select or create customer | ”John Smith (Parent)“ |
Invoice Address | Yes | Billing address | Auto-filled from customer |
Delivery Address | Yes | Shipping address | Auto-filled from customer |
Expiration | No | Quote validity date | 2026-01-21 |
Pricelist | No | Special pricing rules | ”Student Discount” |
Payment Terms | No | Payment conditions | ”30 Days” |
Step 3: Add Products
In the Order Lines tab:
Option A: Add Individual Products
- Click Add a product
- Select product from dropdown
- Adjust quantity if needed
- Repeat for additional products
Option B: Use Product Catalog
- Click Catalog button
- Browse or search products
- Click Add on desired items
- Click Back to Quotation
Step 4: Organize with Sections and Notes
- Click Add a section to group related items
- Click Add a note to add explanatory text
- Drag and drop to reorder items
Example Quotation Structure:
[Section] Course Materials - Fall 2026 - Introduction to Biology (Textbook) $85.00 - Biology Lab Manual $25.00 - Dissection Kit $35.00[Note] All materials required for BIO-101
[Section] Uniform Package - School Polo (Navy Blue, M) $28.00 - Khaki Pants (32x32) $35.00Step 5: Configure Other Options
Go to Other Info tab:
Sales Section:
| Field | Description |
|---|---|
Salesperson | Assigned staff member |
Sales Team | Department/team |
Online Signature | Require signature |
Online Payment | Require payment % |
Tags | Organization labels |
Delivery Section:
| Field | Description |
|---|---|
Shipping Policy | When to ship |
Delivery Date | Expected delivery |
Step 6: Send Quotation
- Click Send by Email
- Review email content and recipients
- Click Send
- Status changes to “Quotation Sent”
Quotation Templates
Create reusable templates for common orders.
Create a Template
- Go to Sales > Configuration > Quotation Templates
- Click New
| Field | Description | Example |
|---|---|---|
Quotation Template | Template name | ”New Student Package” |
Quotation Validity | Days valid | 30 |
Confirmation Mail | Email on confirmation | ”Order Confirmation” |
Online Signature | Require signature | Checked |
Online Payment | Require payment % | 50% |
Add Products to Template
In the Lines tab:
- Click Add a product
- Select products included in the package
- Set quantities
- Add sections and notes as needed
Optional Products
In the Optional Products tab, add cross-sell items:
| Template | Optional Products |
|---|---|
| New Student Package | Extra uniform set, Backpack, Water bottle |
| Event Ticket | VIP upgrade, Parking pass, Meal voucher |
| Textbook Bundle | Study guide, Online access code |
Terms & Conditions
In the Terms & Conditions tab, add standard text:
Terms & Conditions:- All sales are final for opened/used items- Returns accepted within 14 days for unopened items- Uniform exchanges available within 30 days- Payment due upon order confirmationUse Template in Quotation
- Create new quotation
- Select template in Quotation Template field
- Products and settings auto-populate
- Customize as needed
Confirming Sales Orders
Confirm via Back-Office
- Open the quotation
- Click Confirm button
- Status changes to “Sales Order”
- Proceed to invoicing
Confirm via Customer Portal
If Online Signature/Payment enabled:
- Customer receives quotation email
- Customer clicks link to view quote
- Customer reviews order details
- Customer signs and/or pays online
- Order auto-confirms upon completion
After Confirmation
- Quotation becomes a Sales Order
- Delivery order created (if physical products)
- Invoice can be created
- No further editing (if Lock Confirmed Sales enabled)
Pricelists
Enable Pricelists
- Go to Sales > Configuration > Settings
- Enable Pricelists in Pricing section
- Click Save
Create a Pricelist
- Go to Sales > Products > Pricelists
- Click New
| Field | Description | Example |
|---|---|---|
Pricelist Name | Display name | ”Student Discount” |
Currency | Pricing currency | USD |
Country Groups | Geographic scope | United States |
Price Rules
In the Price Rules tab, add discount rules:
| Apply To | Price Type | Value | Example |
|---|---|---|---|
| All Products | Discount | 10% | 10% off everything |
| Category: Uniforms | Fixed Price | 25.00 | Flat price for uniforms |
| Product: Textbook | Formula | 5% + round to $0.99 | Complex pricing |
Educational Pricelist Examples
| Pricelist | Target | Rules |
|---|---|---|
| Student Discount | Current students | 15% off merchandise, 10% off materials |
| Faculty/Staff | Employees | 20% off all products |
| Alumni | Graduates | 10% off merchandise only |
| Bulk Order | Groups > 10 items | 25% off uniforms |
Apply Pricelist to Customer
- Open customer record
- Go to Sales & Purchase tab
- Select pricelist in Pricelist field
- Click Save
Apply Pricelist to Quotation
- On quotation form
- Select pricelist in Pricelist field
- Prices recalculate automatically
Discounts
Enable Discounts
- Go to Sales > Configuration > Settings
- Enable Discounts in Pricing section
- Click Save
Apply Line Discounts
In the quotation Order Lines tab:
- Find the Disc.% column
- Enter discount percentage for each line
- Total recalculates automatically
| Product | Unit Price | Qty | Disc.% | Total |
|---|---|---|---|---|
| Textbook | $100.00 | 1 | 10% | $90.00 |
| Lab Kit | $50.00 | 1 | 0% | $50.00 |
Discount Button Options
Click Discount button at bottom of order lines:
| Option | Description | Use Case |
|---|---|---|
| On All Order Lines | Same % on all items | Store-wide sale |
| Global Discount | Single discount line | Promotional discount |
| Fixed Amount | Dollar amount off | Coupon/voucher |
Example: Apply 10% Event Discount
- Click Discount
- Enter 10 in Discount field
- Select Global Discount
- Click Apply
Invoicing
Invoicing Policies
| Policy | Description | Best For |
|---|---|---|
| Ordered Quantities | Invoice immediately upon confirmation | Digital products, event tickets |
| Delivered Quantities | Invoice after delivery/pickup | Physical goods, shipped items |
Create Invoice from Sales Order
- Open the sales order
- Click Create Invoice
- Choose invoice type:
| Type | Description |
|---|---|
| Regular Invoice | Full amount or remaining balance |
| Down Payment (percentage) | Partial payment as % |
| Down Payment (fixed amount) | Specific dollar amount |
- Click Create Draft Invoice
- Review draft invoice
- Click Confirm to post invoice
- Click Pay to register payment
Invoice Workflow
Sales Order Confirmed | vCreate Invoice (Draft) | vConfirm Invoice (Posted) | vRegister Payment | vInvoice PaidDown Payments
Collect partial payment upfront for high-value orders.
When to Use Down Payments
| Scenario | Suggested Down Payment |
|---|---|
| Custom uniform orders | 50% |
| Event bookings | 25-50% |
| Equipment purchases | 50% |
| Large textbook orders | 30% |
Create Down Payment Invoice
- On confirmed sales order, click Create Invoice
- Select Down payment (percentage) or Down payment (fixed amount)
- Enter amount/percentage
- Click Create Draft Invoice
- Confirm and collect payment
Complete Order Payment
After down payment is collected:
- Return to sales order
- Down payment appears in Order Lines under “Down Payments” section
- Click Create Invoice again
- Select Regular Invoice
- System invoices remaining balance
- Confirm and collect final payment
Example: 50% Down Payment Flow
| Step | Amount | Running Total |
|---|---|---|
| Order Total | $500.00 | - |
| Down Payment (50%) | $250.00 | $250.00 paid |
| Final Invoice | $250.00 | $500.00 paid |
Field Reference
Quotation/Sales Order Fields
| Field Name | Technical Name | Type | Required | Description |
|---|---|---|---|---|
| Customer | partner_id | Many2one | Yes | Customer/contact |
| Invoice Address | partner_invoice_id | Many2one | Yes | Billing address |
| Delivery Address | partner_shipping_id | Many2one | Yes | Shipping address |
| Quotation Template | sale_order_template_id | Many2one | No | Pre-defined template |
| Expiration | validity_date | Date | No | Quote expiry date |
| Pricelist | pricelist_id | Many2one | No | Pricing rules |
| Payment Terms | payment_term_id | Many2one | No | Payment conditions |
| Order Lines | order_line | One2many | Yes | Products ordered |
Order Line Fields
| Field Name | Technical Name | Type | Required | Description |
|---|---|---|---|---|
| Product | product_id | Many2one | Yes | Item being sold |
| Description | name | Text | Auto | Product description |
| Quantity | product_uom_qty | Float | Yes | Amount ordered |
| Unit Price | price_unit | Float | Auto | Sale price |
| Discount | discount | Float | No | Percentage discount |
| Taxes | tax_id | Many2many | Auto | Applicable taxes |
| Subtotal | price_subtotal | Float | Computed | Line total |
Order States
| Technical Value | Display Name | Description |
|---|---|---|
draft | Quotation | Initial draft |
sent | Quotation Sent | Emailed to customer |
sale | Sales Order | Confirmed order |
done | Locked | Completed and locked |
cancel | Cancelled | Order cancelled |
Invoice States
| Technical Value | Display Name | Description |
|---|---|---|
draft | Draft | Not yet posted |
posted | Posted | Confirmed invoice |
cancel | Cancelled | Invoice cancelled |
Troubleshooting
Cannot Create Invoice
Problem: “Create Invoice” button not visible or disabled.
Solutions:
- Ensure order is confirmed (Sales Order status)
- Check invoicing policy - if “Delivered quantities”, deliver items first
- Verify you have Sales Manager permissions
- Check if previous invoices cover full amount
Pricelist Not Applying
Problem: Prices not updating when pricelist selected.
Solutions:
- Verify pricelist is saved and active
- Check price rules match products in order
- Ensure date falls within rule validity period
- Check minimum quantity requirements
- Re-select products after changing pricelist
Customer Cannot Pay Online
Problem: Online payment option not appearing for customer.
Solutions:
- Enable Online Payment in Settings
- Configure payment provider (Stripe, PayPal, etc.)
- Check Online Payment checkbox on quotation
- Verify customer has valid email address
- Ensure quotation was sent (not just saved)
Discount Column Missing
Problem: Cannot add discounts to order lines.
Solutions:
- Go to Sales > Configuration > Settings
- Enable Discounts in Pricing section
- Click Save
- Refresh quotation page
Down Payment Deduction Not Working
Problem: Final invoice not deducting down payment.
Solutions:
- Check invoicing policy is “Ordered quantities”
- Verify down payment invoice is Posted and Paid
- For “Delivered quantities” policy, ensure delivery is validated
- Check order total exceeds down payment amount
Quotation Template Products Not Loading
Problem: Selecting template doesn’t add products.
Solutions:
- Verify template has products in Lines tab
- Check products are active (not archived)
- Ensure products are marked “Can be Sold”
- Verify you have access to all products in template
Cannot Edit Confirmed Order
Problem: Unable to modify sales order after confirmation.
Solutions:
- Check if “Lock Confirmed Sales” is enabled
- Use “Unlock” option if available (requires permission)
- Cancel order and create new one
- For invoiced orders, cancel invoices first
Best Practices for Educational Sales
Product Naming Conventions
Use consistent naming for easy searching:
[Category] Product Name - Variant - Grade/YearExamples:
- [UNIFORM] Polo Shirt - Navy Blue - Grade 9-12
- [TEXTBOOK] Introduction to Chemistry - 2026 Edition
- [EVENT] Spring Concert 2026 - VIP Ticket
- [SUPPLY] Art Kit - Beginner - Grades 1-5
Quotation Templates by Use Case
| Template | Products | Optional Products |
|---|---|---|
| New Student Welcome | Uniform set, Basic supplies | Extra uniform, Backpack |
| Course Registration | Required textbooks | Study guides, Online access |
| Event Package | Ticket + Parking | VIP upgrade, Merchandise |
| Graduation Bundle | Cap & Gown rental | Announcements, Photos |
Seasonal Pricing
Use pricelists with validity dates:
| Pricelist | Valid Period | Discount |
|---|---|---|
| Back to School Sale | Aug 1-15 | 20% off uniforms |
| Holiday Special | Dec 1-25 | 15% off merchandise |
| End of Year Clearance | May 15-31 | 30% off supplies |
Related Topics
Last updated: January 2026