Odoo ERP Tutorials

Odoo Hospital Management System

Odoo HMS is a state-of-the-art integrated healthcare management solution built on Odoo ERP. It comes with powerful modules for Hospital Management, Patient Records, Appointments, Billing & Invoicing, Pharmacy, Laboratory, Radiology, Nursing, Surgery, Inventory, POS, Sales, CRM, Accounts, Fixed Assets, Purchase, and Helpdesk.

Whether you run a clinic, dispensary, or a Level 3 to Level 5 hospital, Odoo HMS helps automate your healthcare facility, ensuring smooth operations across all departments, reducing paperwork, and minimizing delays.

Below are the key Modules in Odoo HMS:
1.) Hospital Management
Patients
Families
Prescriptions
Deceased Patients
Vaccinations
Patient Evaluations
Physicians
Appointments

2.) Inpatient Administration
Patient Hospitalization
Patient ICU Info
APACHE II Score
ECG
GCS

3.) Pharmacy
Medication

4.) Clinical Services
Imaging
Laboratory
Surgery
Ambulance
Pediatric
Blood Donations

5.) Finance
Insurance

https://youtu.be/oXsn2u_MhyY

Odoo ERP for Hardware Shop

Odoo ERP is a suite of integrated business management software with modules for POS, Sales, Purchase, Inventory, Accounts, E-commerce, CRM, Manufacturing, and Project Management.

The below are the key features for Odoo in a Hardware Shop:
1.) Purchase Management
2.) Inventory Management
3.) Re-order Management
4.) Multi-Unit Sales (Boxes, Packets, Pcs, Mtrs)
5.) Customer Loyalty Programs
6.) Email and Whatsapp Integration
7.) eCommerce & Website Orders
8.) POS on Tablet & Mobile
9.) Bill of Materials
10.) Integrated Accounting and Reporting
11.) Dashboard & Analytics

https://youtu.be/HjS124HEcYI

How to Reset an Odoo User Password using PgAdmin

In case you have forgotten your password to access Odoo you can use the below method using pgAdmin.

PgAdmin is a database management tool for PostgreSQL that can be used to:
1.) View and explore Odoo’s database tables
2.) Run SQL queries on Odoo’s data
3.) Monitor database performance
4.) Backup or restore your Odoo database
5.) Troubleshoot database-level issues (like looking into bad data or verifying migrations).

https://youtu.be/YyEBe8TETyg

How to Manage your Restaurant in Odoo ERP

Odoo ERP includes a powerful Point of Sale (POS) module for Restaurants designed for seamless order management, efficient billing, and enhanced customer experience.

The below are the key features in the Restaurant Module:
1.) Real-Time Stock Monitoring using Recipes
2.) Custom Floor Plans
3.) Table Booking/Transfers
4.) Kitchen Display System
5.) Kitchen Order Notes/Kitchen Order Tickets (KOT)
6.) Self-Ordering via QR Code/ Kiosk Integration
7.) Combo Meal Creation
8.) Bill Splitting/ Bill Printing
9.) Multiple Payment Methods
10.) Credit Limits
11.) Tipping Page
12.) Customer Loyalty Program
13.) Tablet & Mobile Compatibility
14.) Offline Mode

https://youtu.be/jmUdGI0ih4I

How to Set Up a Complete Company in Odoo

We have covered the below subtopics in this tutorial for How to Set Up a Complete Company in Odoo V18:

• Download and Installation of Odoo Enterprise V18
• Setup Company Details
• Setup of Master Data: Chart of Accounts, Journals, Banks
• Setup of Master Data: Products
• Setup of Master Data: Customers
• Setup of Master Data: Vendors
• Setup of Master Data: Users
• Purchase Process
• Inventory Process
• Sales Process
• POS Process

https://youtu.be/QK9f08aiM9c

How to do Bank Reconciliation in Odoo

We have covered the below subtopics in this tutorial for bank reconciliation:

• Introduction to Bank Reconciliation in Odoo
• Setting Up Bank and Cash Accounts
• Reconciliation Models
• Posting Receipts and Payments
• Importing and Reconciling Bank Statements
• Inserting Bank Balances
• Internal Bank Transfers

Odoo ERP for Salon & SPA

Automate your Salon & SPA with Odoo ERP and Maximize Your Profits.

Salon & SPA Master is a state of the art solution for Salons & SPAs with modules for Salon, SPA, Inventory, Sales, POS, Purchase, Accounts, CRM

• Salon & SPA Master System Features:
• Salon Products
• SPA Products
• Chairs/Rooms
• Employees/Beauticians
• Commissions
• Bookings
• Customers
• Vendors
• Reports

How to Customize Odoo V18 in Windows – Part 2 of 7 Understanding Odoo Architecture

1.) Overview of Odoo’s modular architecture
2.) Core components: Models, Views, and Controllers
3.) Addons directory structure explained
4.) Database structure and ORM layer
5.) The role of configuration files in Odoo modules
6.) Understanding workflow of Odoo requests and response
7.) Introduction to XML-RPC and API integrations

How to Customize Odoo V18 in Windows

This will be a 7 part series covering the below:

1.) Introduction to Odoo Architecture and Development Setup

2.) Understanding Odoo Modules

3.) Creating and Installing a Custom Module

4.) Customizing Models and Database Schema

5.) Customizing Views and User Interfaces

6.) Adding Business Logic with Python

7.) Debugging, Testing, and Best Practices

Odoo ERP for Stationery & Bookshop

Automate your Stationery & Bookshop with Odoo ERP and Maximize Your Profits.

Odoo ERP is a suite of integrated business management software with modules for POS, Sales, Purchase, Inventory, Accounts, E-commerce, CRM, Manufacturing, and Project Management.

Odoo ERP Features:
– Point of Sale Module
– e-Commerce Integration
– Multiple Pricelists
– Inventory Management
– Accounting Module
– Warehouse Management
– SMS & Mpesa Integration
– Loyalty Points
– Mobile Phone Access (Android / iOS)
– Customer Relationship Management
– Purchase Management
– Barcode Scanning

https://youtu.be/J92ApZtiH4g

How to install nginx and setup a reverse proxy for Odoo

i.) Add a DNS record and redirect your sub domain to the IP

You can check if the record has propagated and available for the public via the sub domain and IP from https://www.dnswatch.info/

ii.) Install nginx and setup a reverse proxy
sudo apt install nginx

iii.) Remove the default files for nginx
sudo rm /etc/nginx/sites-enabled/default
sudo rm /etc/nginx/sites-available/default

iv.) Create and edit the nginx configuration file
sudo nano /etc/nginx/sites-available/odoo.conf

upstream odoo {
server 127.0.0.1:8069;
}

upstream odoochat {
server 127.0.0.1:8072;
}

server {
listen 80;
server_name odoo.softiqtechnologies.co.ke;

access_log /var/log/nginx/odoo.access.log;
error_log /var/log/nginx/odoo.error.log;

proxy_read_timeout 720s;
proxy_connect_timeout 720s;
proxy_send_timeout 720s;
proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
proxy_set_header X-Real-IP $remote_addr;

location / {
proxy_redirect off;
proxy_pass http://odoo;
}

location ~* /web/static/ {
proxy_cache_valid 200 90m;
proxy_buffering on;
expires 864000;
proxy_pass http://odoo;
}

gzip_types text/css text/less text/plain text/xml application/xml application/json application/javascript;
gzip on;
}

v.) Create a symbolic link of the nginx conf file

sudo ln -s /etc/nginx/sites-available/odoo.conf /etc/nginx/sites-enabled/odoo.conf

vi.) Check the configuration and Restart nginx
sudo nginx –t
systemctl restart nginx

vii.) Run odoo using sub domain

How to Upgrade Odoo 17 Community to Enterprise in Ubuntu

Steps on How to Upgrade Odoo 17 Community to Enterprise on Ubuntu 22.04 for Production

1.) For this example we will be using the Odoo Documentation:

https://www.odoo.com/documentation/17.0/administration/on_premise/community_to_enterprise.html

2.) Backup your Community Database

Go to the database manager and take a backup

3.) Stop the odoo service and download the enterprise addons

systemctl stop odoo
systemctl status odoo

git clone git@github.com:odoo/enterprise.git –depth 1 –branch 17.0 /opt/odoo/odoo/enterprise

In case you get an error “Permission denied (publickey)” you need to create a new GitHub SSH Key:

i.) Generating a new SSH key:
ssh-keygen -t ed25519 -C xxx@gmail.com

ii.) Adding your SSH key to the ssh-agent:
eval “$(ssh-agent -s)”

iii.) Add your SSH private key to the ssh-agent:
ssh-add ~/.ssh/id_ed25519

iv.) Adding a new SSH key to your GitHub account
cat ~/.ssh/id_ed25519.pub

4.) Update the –addons-path parameter of your odoo.conf file

nano /etc/odoo.conf

/opt/odoo/odoo/enterprise

5.) Start the odoo service

systemctl odoo start
systemctl status odoo

6.) Install the web_enterprise module

7.) Purchase Enterprise license

How to install Odoo 17 for Production in Ubuntu 22 04

Steps on How to Install Odoo 7 Community on Ubuntu 22.04 for Production

i.) Purchase a Cloud VPS on Ubuntu 22.04
ssh root@xxx.xxx.xxx.xxx

ii.) Update & Upgrade Ubuntu Packages
sudo apt update
sudo apt upgrade

iii.) Install python dependencies and create new user
sudo apt install build-essential wget git python3.11-dev python3.11-venv libfreetype-dev libxml2-dev libzip-dev libsasl2-dev node-less libjpeg-dev zlib1g-dev libpq-dev libxslt1-dev libldap2-dev libtiff5-dev libopenjp2-7-dev libcap-dev

iv.) Create new system user for Odoo
/usr/sbin/adduser –system –shell /bin/bash –gecos ‘Odoo’ –group –home /opt/odoo odoo

v.) Install Postgresql and create new user for postgresql
sudo apt install postgresql
su – postgres -c “createuser -s odoo”

We need to install wkhtml for converting html data to pdf format

sudo apt install wkhtmltopdf

vi.) Download Odoo Files and create python venv
su – odoo
git clone https://www.github.com/odoo/odoo –depth 1 –branch 17.0 odoo

python3.11 -m venv odoo-venv
source odoo-venv/bin/activate

vii.) Install Odoo and configure odoo files
pip3 install wheel setuptools pip –upgrade
pip3 install -r odoo/requirements.txt

Then we create a new directory for the custom odoo addons and log file:
mkdir /opt/odoo/odoo/custom

Exit from user odoo by typing: exit

mkdir /var/log/odoo
sudo touch /var/log/odoo/odoo.log

viii.) Create odoo config file
nano /etc/odoo.conf

[options]
admin_passwd = admin1234
db_host = False
db_port = False
db_user = odoo
db_password = False
addons_path = /opt/odoo/odoo/addons,/opt/odoo/odoo/custom
logfile=/var/log/odoo/odoo.log

ix.) Create odoo service
nano /etc/systemd/system/odoo.service

[Unit]
Description=odoo
Requires=postgresql.service
After=network.target postgresql.service

[Service]
Type=simple
SyslogIdentifier=odoo
PermissionsStartOnly=true
User=odoo
Group=odoo
ExecStart=/opt/odoo/odoo-venv/bin/python3 /opt/odoo/odoo/odoo-bin -c /etc/odoo.conf
StandardOutput=journal+console

[Install]
WantedBy=multi-user.target

x.) Enable odoo service

systemctl daemon-reload
systemctl enable odoo

sudo systemctl enable odoo
sudo systemctl status odoo

xi.) Open Odoo
http://publicip:8069

How to install Odoo 17 for Development on Ubuntu

Steps to install Odoo 17 for Development on Ubuntu 23.10:
1.) Task 1: Update & Upgrade Ubuntu Packages
sudo apt update
sudo apt upgrade

2.) Task 2: Install Git and download git repositories
sudo apt install git
git –version
git clone https://www.github.com/odoo/odoo –depth 1 –branch 17.0 odoo17

3.) Task 3: Install Python
python3 -m pip –version
sudo apt install python3-pip

4.) Task 4: Install PostgreSQL
sudo apt install postgresql postgresql-client
sudo su – postgres -c “createuser -s odoo17”
sudo su postgres
psql
ALTER ROLE odoo17 WITH PASSWORD ‘odoo17’;

5.) Task 5:Create python virtual environment and install dependencies
sudo apt install python3.11-venv
python3.11 -m venv venv
source venv/bin/activate
sudo apt install python3-pip libldap2-dev libpq-dev libsasl2-dev
python3.11 -m pip install -r requirements.txt

6.) Task 6: Edit the odoo config file and create a databse
python3.11 odoo-bin -c debian/odoo.conf
locate pg_hba.conf
sudo apt install plocate
sudo nano /etc/postgresql/15/main/pg_hba.conf
sudo /etc/init.d/postgresql restart
python3.11 odoo-bin -c debian/odoo.conf

7.) Task 7: Open Odoo
http://localhost:8069/

How to install multiple Odoo instances on a single machine on windows

1. Odoo V17 enterprise
2. Odoo V17 community

Odoo Error Missing Required Account on Accountable Line

How to resolve the Odoo Error Missing Required Account on Accountable Line on Odoo V17.

Download and Installation of Odoo ERP V16 on Windows

How to download and install Odoo ERP V16 on Windows