Odoo studio Limitations

Odoo studio allows you to customize the user interface with very limited programming knowledge. It allows to write some Python code as well but a very limited portion of features can be customized from there. Here are the areas and industries where it will not work or somehow will create hurdles,

  • Nothing you do in odoo studio can be used in the community edition of odoo.
  • for all many enhancement to odoo 12, there are major weaknesses associated with recording custom odoo applications.
  • Because of the way you develop with odoo studio, it can again be very tough to control processes inside production installations.

Highly Customized business process

If your current business process if highly customized or proprietary to your owned business then generic ERP process may not work for you well and can turn into confusion for your employees.

Manufacturing Process

This is the main area where the Odoo studio will not work because of complicated processes. E.g. if you are looking to execute the work order in different stages and at the similar time you need some task order to go to the near stage after a real amount of time, it should be possible to customize

Import/Export of data

The migration will really not useful on this area, we have recently viewed an issue of importing work order and so the customer has had to change to the on-premise odoo
When you migrate from another system, your import process requires a high degree of customization and for that, you will need a full path to the Odoo backend system to write Python code.

Same way, you can not customize the export process very well.

Crons and Schedulers

Because you have restricted access to the Python//backend system, you can’t write crons very well and can’t automate many methods you want.

Ownership of the Data

The hosted answer limits the control of your data to the Odoo itself. However, they have a reliable cloud but if you want to keep the data completely, you will have to sort of premise Odoo that means, self-hosted Odoo. That doesn’t expect that you will have to choose some odoo partner to host your odoo on their support, you can have your private leased server from any provider and you can host it there.

At Silent Infotech we recommend going for either On-premise community or on-premise Enterprise. It’s a myth that it is hard to manage the on-premise odoo instance. We have Odoo special cloud and infrastructure in place to host on-premise odoo with the full power of customization.

We are a leading provider of ERP/CRM services, we provide advance initiative technology

Our team of experienced and dedicated developers has enough talent tons of experience in developing software products and solutions.

Odoo Community VS Odoo Enterprise

In the starting phase, odoo familiar as OpenERP is a set of open source enterprise management applications.

The large companies, small business, associations and many different types of organizations used odoo for control, automate, measure and optimize their operations, finance and projects.

In the odoo version 6,7, & 8 there are no technical variations between community and enterprise version and it has changed in V9.

Features of Odoo Community:

The Odoo Community Association is the non-profitable organization which promotes the global use of odoo and assists the synergetic development of odoo feature.

It provides financial, organizational and legal assistance to the larger odoo open source community. It is also provided as an independent legal entity where community member can subscribe the code, funding, and other resources with knowledge and their subscription will be maintained for public benefits.

Odoo software can be used, modified and distributed by anyone.

The source code, bug reports pull requests are hosted by GitHub to access anyone.

Features of Odoo Enterprise:

If the user applies for the proprietary license he/she only can use the odoo enterprise subscription.

  • Modifications are allowed.
  • Distribution only to odoo enterprise subscribers.

All odoo projects are fully hosted on GitHub and access to all partners and customers who have an odoo subscription.

The whole database and back-end applications, without limitations, are in Odoo Community.

  • Basic Functionality is in Odoo Community.
  • Migration to the next version by Odoo SA engineers is in Odoo Enterprise.
  • Several Functionalities are in Odoo Enterprise.
  • Support of the non-customized Odoo Enterprise by Odoo SA Engineers.
  • Apps from Odoo Store.

Odoo Enterprise is a combination of “odoo community + additional functional modules”

The difference between two editions Community version &Enterprise version.

LayerCommunity version Enterprise version 
Required hardwareFrom 2 CPU/ @ RAMFrom 2 CPU/ @ RAM
ScalabilityThe same load balancingThe same load balancing
FlexibilityThe same modular architectureThe same modular architecture
Community and Store AppCan Install any moduleCan Install any module
Enterprise AppNot availableIncluded in the package
LocalizationThe same localizationThe same localization
Out-of-the-boxRequires more customizationIncludes nice UI and more functionality
Access rightsThe same configurationThe same configuration
UIStandard interfaceNice and fast navigation
Support and upgradeNot includedIncluded by vendor
PriceNo licence cost20 EUR/user/month
Development accessIt can be utilized by the developers.To access enterprise you will have to purchase LGPL(Lesser General public license) which has been published by free software foundation.
ControlYou can install any module via community and store appsYou can not install any module directly.
Mobile supportNot availableAvailable
UniquenessCommunity edition does not contain all the features of the enterprise.Enterprise edition does contain all the features of the community.

Hardware & Scalability:

  • If we follow the hardware essence odoo can be estimated for companies of almost any size and odoo did it for 2000 global companies with vast terrestrial distribution but it recommended the breaking applications and database servers for 90 employees. The load balancing of application server would be used for a company who have 250+ employees.
  • There are 90% free and 10% paid applications are available in odoo app store.
  • Odoo Enterprise includes additional unique modules that will move the ERP experience to the next level.
  • Any localization can be installed as additional on both versions.

Flexibility in community and enterprise apps:

odoo have the modular structure, by this, you can customize through modules and database configuration.


How to install odoo 11 on UBUNTU 16.04

Hello Everyone, You must be aware about the odoo has released it’s most awaiting version odoo 11 with exiting new features. To know odoo 11 features click here

In this tutorial I will teach you how to install odoo 11 from debian package.

Step 1 : Download latest version


Step 2 : Install odoo

Before you proceed for this command make sure that your locale is setup properly if you are using VPS.

dpkg -i odoo_11.0.latest_all.deb

If you encounter the blow error during the installation

# dpkg -i odoo_11.0.latest_all.deb 
Selecting previously unselected package odoo.
(Reading database ... 26866 files and directories currently installed.)
Preparing to unpack odoo_11.0.latest_all.deb ...
Unpacking odoo (11.0.20171114) ...
dpkg: dependency problems prevent configuration of odoo:
 odoo depends on python3-babel; however:
 Package python3-babel is not installed.
 odoo depends on python3-dateutil; however:
 Package python3-dateutil is not installed.
 odoo depends on python3-decorator; however:
 Package python3-decorator is not installed.
 odoo depends on python3-docutils; however:
 Package python3-docutils is not installed.
 odoo depends on python3-feedparser; however:
 Package python3-feedparser is not installed.
 odoo depends on python3-gevent; however:
 Package python3-gevent is not installed.
 odoo depends on python3-html2text; however:
 Package python3-html2text is not installed.
 odoo depends on python3-jinja2; however:
 Package python3-jinja2 is not installed.
 odoo depends on python3-lxml; however:
 Package python3-lxml is not installed.
 odoo depends on python3-mako; however:
 Package python3-mako is not installed.
 odoo depends on python3-mock; however:
 Package python3-mock is not installed.
 odoo depends on python
dpkg: error processing package odoo (--install):
 dependency problems - leaving unconfigured
Processing triggers for systemd (229-4ubuntu12) ...
Errors were encountered while processing:

You can run,

apt-get install -f

This command will installed all the dependency libraries on the system.

Step 3 : Navigate to odoo web url

Congratulations you have completed odoo 11 installation, Wasn’t it too easy!!

http://localhost:8069 or http://<your computer ip>:8069

What is difference between Bitrix64 and Odoo CRM?

Here is a basic difference of any closed source CRM (Bitrix, MS Dynamics, ZOHO CRM, Suger CRM etc) & Open source CRM (e.g. Odoo, Orange etc)

Open Source CRM

  • There will be no licensing terms and you will own the system.
  • You’ll have to rent/own infrastructure and yourself will be responsible to manage it.
  • You have full rights to customize it as you will have the source code.
  • You can establish your own business process on rather than accepting already established process of some software.
  • TCO (Total Cost of Ownership) might be more than hosted ones. It might have bit more operational cost.
  • Export the data and migrate to some other software will be easy as you own that software.
  • Data privacy and confidentiality will be maintained.
  • You will have built in website already connected with CRM/backend (Tight coupling)
  • Extensibility of having accounting, sales, purchase, payroll, inventory on a single click installation without any extra cost.

Hosted CRM (Closed Source)

  • No/little setup cost
  • You don’t need to worry about infrastructure and maintenance.
  • You will not own the software and will need to accept the licensing terms.
  • Very small customization might be allowed.
  • You will need to adopt the business process (workflow) of that software.
  • Migration to other software in future might be difficult.
  • No TCO (Total cost of ownership) as you will not own the software.
  • You will need to write/develop middleware interface to connect with any website (Loose coupling)


How to use Office365 as an outgoing mail/smtp server with odoo?

If you are getting an error like “SMTPDataError:… SMTP; Client does not have permissions to send as this sender

It seems a normal scenario to use office 365 as a email server with Odoo but there are some known issues while you configure it.

  1. It will not directly allow you to use multiple FROM address or different FROM address then the sender address which is being used in authentication. E.g. you have configured alice@example.com and you would like to set no-reply@example.com as a FROM address. This will be needed when you want all your Odoo users to send emails using same FROM address.

As a solution, you have a couple of options,

  1. You can relay your outbound emails from an another MTA like Sendgrid and use the multiple sender addresses.
  2. You may create a security group and follow the steps below,
    1. Create a security group e.g. no-reply@example.com
    2. Add all email accounts to that group and give send as permission.
    3. Try sending an email and it should work!
  3. Check out reverse DNS settings of your domain name and make sure that its mapped to the return path properly.


Odoo won’t start after pysftp installed


  • UBUNTU 16.04
  • Odoo 9


Today I came across the situation where after installing pysftp suddenly I won’t be able to start odoo again. I have tried to do

service odoo restart
service odoo stop ; service odoo start

When I have tried to uninstall pysftp, I was having SSL_ST_INIT error

root@erp:~# pip uninstall pysftp
Traceback (most recent call last):
 File "/usr/bin/pip", line 9, in <module>
 from pip import main
 File "/usr/lib/python2.7/dist-packages/pip/__init__.py", line 13, in <module>
 from pip.exceptions import InstallationError, CommandError, PipError
 File "/usr/lib/python2.7/dist-packages/pip/exceptions.py", line 6, in <module>
 from pip._vendor.six import iteritems
 File "/usr/lib/python2.7/dist-packages/pip/_vendor/__init__.py", line 64, in <module>
 File "/usr/lib/python2.7/dist-packages/pip/_vendor/__init__.py", line 36, in vendored
 __import__(modulename, globals(), locals(), level=0)
 File "/usr/share/python-wheels/CacheControl-0.11.5-py2.py3-none-any.whl/cachecontrol/__init__.py", line 9, in <module>
 File "/usr/share/python-wheels/CacheControl-0.11.5-py2.py3-none-any.whl/cachecontrol/wrapper.py", line 1, in <module>
 File "/usr/share/python-wheels/CacheControl-0.11.5-py2.py3-none-any.whl/cachecontrol/adapter.py", line 3, in <module>
 File "/usr/share/python-wheels/requests-2.9.1-py2.py3-none-any.whl/requests/__init__.py", line 53, in <module>
 File "/usr/share/python-wheels/urllib3-1.13.1-py2.py3-none-any.whl/urllib3/contrib/pyopenssl.py", line 54, in <module>
 File "/usr/lib/python2.7/dist-packages/OpenSSL/__init__.py", line 8, in <module>
 from OpenSSL import rand, crypto, SSL
 File "/usr/lib/python2.7/dist-packages/OpenSSL/SSL.py", line 118, in <module>
AttributeError: 'module' object has no attribute 'SSL_ST_INIT'


Step 1: Backup existing directory on OpenSSL and pyOpenSSL from dist-packages folder.

cp -r /usr/lib/python2.7/dist-packages/OpenSSL /tmp/
cp -r /usr/lib/python2.7/dist-packages/pyOpenSSL-0.15.1.egg-info /tmp/

Step 2: Remove directory OpenSSL and pyOpenSSL from dist-packages folder and install pyopenssl module

# rm -rf /usr/lib/python2.7/dist-packages/OpenSSL 
# rm -rf /usr/lib/python2.7/dist-packages/pyOpenSSL-0.15.1.egg-info 
# sudo pip install pyopenssl

Step 3: Start odoo service.