Skip to content

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

  1. Overview
  2. Configuration
  3. Managing Products
  4. Creating Quotations
  5. Quotation Templates
  6. Confirming Sales Orders
  7. Pricelists
  8. Discounts
  9. Invoicing
  10. Down Payments
  11. Field Reference
  12. Troubleshooting

Overview

The Sales module in OpenEduCat enables educational institutions to sell:

Product CategoryExamples
Course MaterialsTextbooks, lab kits, art supplies, study guides
Uniforms & ApparelSchool uniforms, sports jerseys, graduation gowns
MerchandiseBranded items, stationery, bags, water bottles
Event TicketsConcerts, sports events, graduation ceremonies
PublicationsYearbooks, newsletters, research journals
ServicesTutoring 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

  1. Go to Sales > Configuration > Settings
  2. Configure the following options:
SettingDescriptionRecommended for Education
Quotation TemplatesCreate reusable quote templatesEnable for standard product bundles
Online SignatureRequest signature to confirmEnable for high-value orders
Online PaymentRequest payment to confirmEnable for event tickets, merchandise
Default Quotation ValidityDays before quote expires15-30 days
Lock Confirmed SalesPrevent edits after confirmationEnable for audit compliance
Pro-Forma InvoiceSend preliminary invoicesEnable for international sales
  1. Click Save

Step 2: Configure Invoicing Policy

Choose how products are invoiced:

PolicyWhen to UseEducational Example
Invoice what is orderedImmediate billingEvent tickets, digital materials
Invoice what is deliveredBill after deliveryTextbooks, uniforms, equipment

Navigate to Sales > Configuration > Settings > Invoicing to set the default policy.


Managing Products

Create Educational Products

  1. Go to Sales > Products > Products
  2. Click Create
  3. Fill in product details:
FieldWhat to EnterExample
Product NameDescriptive name”Chemistry Lab Kit - Grade 10”
Product TypeStorable/Consumable/ServiceStorable Product
Sales PriceBase selling price75.00
CostPurchase/production cost45.00
Can be SoldEnable for salesChecked
Invoicing PolicyOrdered/Delivered quantitiesOrdered quantities
Internal ReferenceSKU code”LAB-CHEM-G10”
  1. Click Save

Product Variants

Use variants for products with multiple options (sizes, colors):

Example: School Uniform Polo Shirt

  1. Go to Sales > Configuration > Attributes
  2. Create attributes:
AttributeValuesDisplay Type
SizeXS, S, M, L, XL, XXLPills
ColorNavy Blue, White, GrayColor
  1. On the product form, go to Attributes & Variants tab
  2. Add attributes and select values
  3. System generates all variant combinations automatically

Product Categories

Organize products by category:

CategoryProducts
Course MaterialsTextbooks, workbooks, lab supplies
UniformsShirts, pants, shoes, accessories
EventsTickets, registrations, booth spaces
MerchandiseBranded items, gifts, souvenirs
ServicesTutoring, certifications, rentals

Creating Quotations

Step 1: Start a New Quotation

  1. Go to Sales app (main dashboard)
  2. Click New button
  3. The quotation form opens

Step 2: Enter Customer Information

FieldRequiredDescriptionExample
CustomerYesSelect or create customer”John Smith (Parent)“
Invoice AddressYesBilling addressAuto-filled from customer
Delivery AddressYesShipping addressAuto-filled from customer
ExpirationNoQuote validity date2026-01-21
PricelistNoSpecial pricing rules”Student Discount”
Payment TermsNoPayment conditions”30 Days”

Step 3: Add Products

In the Order Lines tab:

Option A: Add Individual Products

  1. Click Add a product
  2. Select product from dropdown
  3. Adjust quantity if needed
  4. Repeat for additional products

Option B: Use Product Catalog

  1. Click Catalog button
  2. Browse or search products
  3. Click Add on desired items
  4. 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.00

Step 5: Configure Other Options

Go to Other Info tab:

Sales Section:

FieldDescription
SalespersonAssigned staff member
Sales TeamDepartment/team
Online SignatureRequire signature
Online PaymentRequire payment %
TagsOrganization labels

Delivery Section:

FieldDescription
Shipping PolicyWhen to ship
Delivery DateExpected delivery

Step 6: Send Quotation

  1. Click Send by Email
  2. Review email content and recipients
  3. Click Send
  4. Status changes to “Quotation Sent”

Quotation Templates

Create reusable templates for common orders.

Create a Template

  1. Go to Sales > Configuration > Quotation Templates
  2. Click New
FieldDescriptionExample
Quotation TemplateTemplate name”New Student Package”
Quotation ValidityDays valid30
Confirmation MailEmail on confirmation”Order Confirmation”
Online SignatureRequire signatureChecked
Online PaymentRequire payment %50%

Add Products to Template

In the Lines tab:

  1. Click Add a product
  2. Select products included in the package
  3. Set quantities
  4. Add sections and notes as needed

Optional Products

In the Optional Products tab, add cross-sell items:

TemplateOptional Products
New Student PackageExtra uniform set, Backpack, Water bottle
Event TicketVIP upgrade, Parking pass, Meal voucher
Textbook BundleStudy 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 confirmation

Use Template in Quotation

  1. Create new quotation
  2. Select template in Quotation Template field
  3. Products and settings auto-populate
  4. Customize as needed

Confirming Sales Orders

Confirm via Back-Office

  1. Open the quotation
  2. Click Confirm button
  3. Status changes to “Sales Order”
  4. Proceed to invoicing

Confirm via Customer Portal

If Online Signature/Payment enabled:

  1. Customer receives quotation email
  2. Customer clicks link to view quote
  3. Customer reviews order details
  4. Customer signs and/or pays online
  5. 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

  1. Go to Sales > Configuration > Settings
  2. Enable Pricelists in Pricing section
  3. Click Save

Create a Pricelist

  1. Go to Sales > Products > Pricelists
  2. Click New
FieldDescriptionExample
Pricelist NameDisplay name”Student Discount”
CurrencyPricing currencyUSD
Country GroupsGeographic scopeUnited States

Price Rules

In the Price Rules tab, add discount rules:

Apply ToPrice TypeValueExample
All ProductsDiscount10%10% off everything
Category: UniformsFixed Price25.00Flat price for uniforms
Product: TextbookFormula5% + round to $0.99Complex pricing

Educational Pricelist Examples

PricelistTargetRules
Student DiscountCurrent students15% off merchandise, 10% off materials
Faculty/StaffEmployees20% off all products
AlumniGraduates10% off merchandise only
Bulk OrderGroups > 10 items25% off uniforms

Apply Pricelist to Customer

  1. Open customer record
  2. Go to Sales & Purchase tab
  3. Select pricelist in Pricelist field
  4. Click Save

Apply Pricelist to Quotation

  1. On quotation form
  2. Select pricelist in Pricelist field
  3. Prices recalculate automatically

Discounts

Enable Discounts

  1. Go to Sales > Configuration > Settings
  2. Enable Discounts in Pricing section
  3. Click Save

Apply Line Discounts

In the quotation Order Lines tab:

  1. Find the Disc.% column
  2. Enter discount percentage for each line
  3. Total recalculates automatically
ProductUnit PriceQtyDisc.%Total
Textbook$100.00110%$90.00
Lab Kit$50.0010%$50.00

Discount Button Options

Click Discount button at bottom of order lines:

OptionDescriptionUse Case
On All Order LinesSame % on all itemsStore-wide sale
Global DiscountSingle discount linePromotional discount
Fixed AmountDollar amount offCoupon/voucher

Example: Apply 10% Event Discount

  1. Click Discount
  2. Enter 10 in Discount field
  3. Select Global Discount
  4. Click Apply

Invoicing

Invoicing Policies

PolicyDescriptionBest For
Ordered QuantitiesInvoice immediately upon confirmationDigital products, event tickets
Delivered QuantitiesInvoice after delivery/pickupPhysical goods, shipped items

Create Invoice from Sales Order

  1. Open the sales order
  2. Click Create Invoice
  3. Choose invoice type:
TypeDescription
Regular InvoiceFull amount or remaining balance
Down Payment (percentage)Partial payment as %
Down Payment (fixed amount)Specific dollar amount
  1. Click Create Draft Invoice
  2. Review draft invoice
  3. Click Confirm to post invoice
  4. Click Pay to register payment

Invoice Workflow

Sales Order Confirmed
|
v
Create Invoice (Draft)
|
v
Confirm Invoice (Posted)
|
v
Register Payment
|
v
Invoice Paid

Down Payments

Collect partial payment upfront for high-value orders.

When to Use Down Payments

ScenarioSuggested Down Payment
Custom uniform orders50%
Event bookings25-50%
Equipment purchases50%
Large textbook orders30%

Create Down Payment Invoice

  1. On confirmed sales order, click Create Invoice
  2. Select Down payment (percentage) or Down payment (fixed amount)
  3. Enter amount/percentage
  4. Click Create Draft Invoice
  5. Confirm and collect payment

Complete Order Payment

After down payment is collected:

  1. Return to sales order
  2. Down payment appears in Order Lines under “Down Payments” section
  3. Click Create Invoice again
  4. Select Regular Invoice
  5. System invoices remaining balance
  6. Confirm and collect final payment

Example: 50% Down Payment Flow

StepAmountRunning 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 NameTechnical NameTypeRequiredDescription
Customerpartner_idMany2oneYesCustomer/contact
Invoice Addresspartner_invoice_idMany2oneYesBilling address
Delivery Addresspartner_shipping_idMany2oneYesShipping address
Quotation Templatesale_order_template_idMany2oneNoPre-defined template
Expirationvalidity_dateDateNoQuote expiry date
Pricelistpricelist_idMany2oneNoPricing rules
Payment Termspayment_term_idMany2oneNoPayment conditions
Order Linesorder_lineOne2manyYesProducts ordered

Order Line Fields

Field NameTechnical NameTypeRequiredDescription
Productproduct_idMany2oneYesItem being sold
DescriptionnameTextAutoProduct description
Quantityproduct_uom_qtyFloatYesAmount ordered
Unit Priceprice_unitFloatAutoSale price
DiscountdiscountFloatNoPercentage discount
Taxestax_idMany2manyAutoApplicable taxes
Subtotalprice_subtotalFloatComputedLine total

Order States

Technical ValueDisplay NameDescription
draftQuotationInitial draft
sentQuotation SentEmailed to customer
saleSales OrderConfirmed order
doneLockedCompleted and locked
cancelCancelledOrder cancelled

Invoice States

Technical ValueDisplay NameDescription
draftDraftNot yet posted
postedPostedConfirmed invoice
cancelCancelledInvoice cancelled

Troubleshooting

Cannot Create Invoice

Problem: “Create Invoice” button not visible or disabled.

Solutions:

  1. Ensure order is confirmed (Sales Order status)
  2. Check invoicing policy - if “Delivered quantities”, deliver items first
  3. Verify you have Sales Manager permissions
  4. Check if previous invoices cover full amount

Pricelist Not Applying

Problem: Prices not updating when pricelist selected.

Solutions:

  1. Verify pricelist is saved and active
  2. Check price rules match products in order
  3. Ensure date falls within rule validity period
  4. Check minimum quantity requirements
  5. Re-select products after changing pricelist

Customer Cannot Pay Online

Problem: Online payment option not appearing for customer.

Solutions:

  1. Enable Online Payment in Settings
  2. Configure payment provider (Stripe, PayPal, etc.)
  3. Check Online Payment checkbox on quotation
  4. Verify customer has valid email address
  5. Ensure quotation was sent (not just saved)

Discount Column Missing

Problem: Cannot add discounts to order lines.

Solutions:

  1. Go to Sales > Configuration > Settings
  2. Enable Discounts in Pricing section
  3. Click Save
  4. Refresh quotation page

Down Payment Deduction Not Working

Problem: Final invoice not deducting down payment.

Solutions:

  1. Check invoicing policy is “Ordered quantities”
  2. Verify down payment invoice is Posted and Paid
  3. For “Delivered quantities” policy, ensure delivery is validated
  4. Check order total exceeds down payment amount

Quotation Template Products Not Loading

Problem: Selecting template doesn’t add products.

Solutions:

  1. Verify template has products in Lines tab
  2. Check products are active (not archived)
  3. Ensure products are marked “Can be Sold”
  4. Verify you have access to all products in template

Cannot Edit Confirmed Order

Problem: Unable to modify sales order after confirmation.

Solutions:

  1. Check if “Lock Confirmed Sales” is enabled
  2. Use “Unlock” option if available (requires permission)
  3. Cancel order and create new one
  4. 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/Year

Examples:

  • [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

TemplateProductsOptional Products
New Student WelcomeUniform set, Basic suppliesExtra uniform, Backpack
Course RegistrationRequired textbooksStudy guides, Online access
Event PackageTicket + ParkingVIP upgrade, Merchandise
Graduation BundleCap & Gown rentalAnnouncements, Photos

Seasonal Pricing

Use pricelists with validity dates:

PricelistValid PeriodDiscount
Back to School SaleAug 1-1520% off uniforms
Holiday SpecialDec 1-2515% off merchandise
End of Year ClearanceMay 15-3130% off supplies


Last updated: January 2026