<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Muhammad Abdullah Arif on Medium]]></title>
        <description><![CDATA[Stories by Muhammad Abdullah Arif on Medium]]></description>
        <link>https://medium.com/@smuhabdullah?source=rss-b6eb7c13697a------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*NDIEoqfmBnWViFsZt-bueg.png</url>
            <title>Stories by Muhammad Abdullah Arif on Medium</title>
            <link>https://medium.com/@smuhabdullah?source=rss-b6eb7c13697a------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 17:39:04 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@smuhabdullah/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[My Experience Deploying Odoo on Hostinger]]></title>
            <link>https://smuhabdullah.medium.com/my-experience-deploying-odoo-on-hostinger-4d0dd52ede1a?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/4d0dd52ede1a</guid>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[hosting]]></category>
            <category><![CDATA[hostinger]]></category>
            <category><![CDATA[odoo-hosting]]></category>
            <category><![CDATA[odoo-development]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Wed, 26 Aug 2026 08:24:46 GMT</pubDate>
            <atom:updated>2026-08-26T08:24:46.264Z</atom:updated>
            <content:encoded><![CDATA[<h4>A Practical VPS Setup That Just Works</h4><p>If you are running <strong>Odoo</strong> for a real business, one question eventually<br>comes up:</p><blockquote><strong><em>Where should I host it?</em></strong></blockquote><p>Cloud hosting, managed Odoo hosting, Odoo.sh, AWS, DigitalOcean,<br>Hetzner, local servers, VPS providers, there are plenty of choices.</p><p>As someone who works with <strong>Odoo deployments, custom modules, Docker,<br>PostgreSQL, server configuration, and production environments</strong>, I have<br>worked with different hosting setups.</p><p>One option that has given me a particularly good experience for<br>practical <a href="http://www.odoo.com/">Odoo</a> deployments is <a href="https://www.hostinger.com/pk?REFERRALCODE=PWNMABDULBE3"><strong>Hostinger VPS</strong></a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*uyzLiRp3o36tSjwe.jpg" /></figure><p>This is not a</p><blockquote>“Hostinger is perfect for everyone”</blockquote><p>article.</p><p>It is simply a practical look at <strong>why I have found Hostinger useful for deploying Odoo</strong>, especially when I want control over the server without making infrastructure unnecessarily complicated.</p><h3>Why Odoo Hosting Is Different From Normal Website Hosting</h3><p>Odoo isn’t just a website.</p><p>An Odoo deployment can involve:</p><ul><li>Odoo application servers</li><li>PostgreSQL databases</li><li>Custom addons</li><li>Enterprise modules</li><li>Third-party modules</li><li>Filestore and attachments</li><li>Background jobs</li><li>Email configuration</li><li>Reverse proxy</li><li>SSL certificates</li><li>Cron jobs</li><li>Backups</li><li>Database maintenance</li><li>Docker containers</li><li>Monitoring and logs</li></ul><p>This is why traditional shared hosting is usually not the right<br>environment for a serious Odoo implementation.</p><p>For Odoo, I generally prefer a <strong>VPS</strong>, because you get much more<br>control over the server environment.</p><p>Hostinger’s Odoo VPS offering provides VPS resources, root access, NVMe<br>storage, backups, and options that are suitable for running and scaling<br>Odoo workloads.</p><h3>Why I Like Hostinger for Odoo</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/742/0*FAxmLn_ShVw1BacD" /></figure><h3>1. Full VPS Control</h3><p>One of the biggest advantages for me is <strong>root access</strong>.</p><p>When you’re developing and maintaining Odoo, you often need to do things<br>that simply aren’t possible on shared hosting.</p><p>For example:</p><pre>docker ps<br>docker logs &lt;container&gt;<br>docker exec -it &lt;container&gt; bash</pre><p>You may need to:</p><ul><li>Install packages</li><li>Configure Docker</li><li>Manage PostgreSQL</li><li>Configure Nginx</li><li>Install fonts for PDF reports</li><li>Configure SSL</li><li>Deploy custom addons</li><li>Inspect Odoo logs</li><li>Restart services</li><li>Tune server resources</li></ul><p>Having control of the VPS makes these tasks much easier.</p><h3>2. Docker Makes Odoo Deployment Cleaner</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/0*8YAsUuxfwsXQvkzQ.jpeg" /></figure><p>For my Odoo deployments, I particularly like using <strong>Docker</strong>.</p><p>A typical architecture can look something like this:</p><pre>Internet<br>                       |<br>                       v<br>                  +---------+<br>                  |  Nginx  |<br>                  +---------+<br>                       |<br>                       v<br>                +-------------+<br>                | Odoo Docker |<br>                |  Container  |<br>                +-------------+<br>                       |<br>                       v<br>              +-----------------+<br>              | PostgreSQL      |<br>              | Docker Container|<br>              +-----------------+<br>                       |<br>                       v<br>                  Odoo Filestore</pre><p>Docker helps keep the application environment isolated and makes it<br>easier to reproduce the same setup across development, staging, and<br>production.</p><p>For example, instead of installing everything directly on Ubuntu, you<br>can manage the application using a docker-compose.yml file.</p><p>A simplified setup might look like:</p><pre>services:</pre><pre>  odoo:<br>    image: odoo:18<br>    depends_on:<br>      - db<br>    ports:<br>      - &quot;8069:8069&quot;<br>    volumes:<br>      - ./addons:/mnt/extra-addons<br>      - ./odoo-data:/var/lib/odoo</pre><pre>  db:<br>    image: postgres:16<br>    environment:<br>      POSTGRES_DB: postgres<br>      POSTGRES_USER: odoo<br>      POSTGRES_PASSWORD: your_password</pre><p>The exact configuration depends on your Odoo version, deployment<br>architecture, security requirements, and whether you’re running<br>Community or Enterprise.</p><p>The important part is the architecture:</p><p><strong>Odoo + PostgreSQL + persistent storage + reverse proxy + backups.</strong></p><p>Hostinger also provides Docker-oriented VPS options, which makes this<br>workflow convenient.</p><h3>3. Easy Server Scaling</h3><p>One thing I like about VPS hosting is that you don’t have to decide your<br>entire infrastructure architecture on day one.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*G5IOvTRIYQ6CMj28.png" /></figure><p>You might start with a smaller server.</p><p>Then your Odoo implementation grows.</p><p>Maybe you go from:</p><p><strong>5 users → 20 users → 50 users → 100+ users</strong></p><p>Your workload can also increase because of:</p><ul><li>More transactions</li><li>More inventory operations</li><li>More accounting entries</li><li>More reports</li><li>More scheduled actions</li><li>More integrations</li><li>More custom modules</li><li>More concurrent users</li></ul><p>At that point, having the option to increase CPU, RAM, and storage is<br>extremely useful.</p><p>Of course, simply increasing VPS resources isn’t a magic performance<br>solution. Odoo performance also depends heavily on PostgreSQL<br>configuration, workers, modules, queries, indexes, scheduled jobs, and<br>overall architecture.</p><p>But having the ability to scale the VPS gives you a much better starting<br>point.</p><h3>4. Backups Matter More Than Hosting</h3><p>This is something I would strongly recommend to every Odoo developer and business owner:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/298/0*EOJdLSxr8mq1jjRr.jpg" /></figure><blockquote><strong><em>Never treat your hosting provider as your backup strategy.</em></strong></blockquote><p>Your Odoo data can include:</p><ul><li>Customer records</li><li>Accounting data</li><li>Sales orders</li><li>Purchase orders</li><li>Inventory</li><li>Employees</li><li>Documents</li><li>Attachments</li><li>Product information</li></ul><p>A server failure is one problem.</p><p>A bad deployment is another.</p><p>A developer accidentally deleting data is another.</p><p>A corrupted database is another.</p><p>That’s why I prefer having a proper backup strategy.</p><p>Hostinger offers automatic weekly backups on its Odoo VPS plans, but for<br>business-critical Odoo systems, I would still recommend maintaining an<br>additional backup strategy appropriate to your recovery requirements.</p><p>For example:</p><pre>Production VPS<br>      |<br>      +---- Database Backup<br>      |<br>      +---- Filestore Backup<br>      |<br>      +---- Off-site Backup<br>      |<br>      +---- Recovery Testing</pre><p>The most important part isn’t just <strong>“Do I have a backup?”</strong></p><p>It is:</p><blockquote><strong><em>“Can I actually restore it?”</em></strong></blockquote><h3>5. Custom Odoo Modules Are Not a Problem</h3><p>This is probably one of the biggest reasons I prefer VPS hosting for<br>development-heavy Odoo projects.</p><p>Real Odoo implementations rarely stay 100% standard.</p><p>Businesses often need customizations such as:</p><ul><li>Custom sales workflows</li><li>Custom reports</li><li>Custom dashboards</li><li>Industry-specific modules</li><li>Accounting customizations</li><li>Inventory automation</li><li>API integrations</li><li>Payment integrations</li><li>WhatsApp integrations</li><li>Custom portal functionality</li><li>Custom approval workflows</li></ul><p>With VPS + Docker, you have the flexibility to mount your custom addons<br>into the Odoo container.</p><p>For example:</p><pre>volumes:<br>  - ./custom-addons:/mnt/extra-addons</pre><p>Then your Odoo configuration can include the custom addons directory.</p><p>This makes the development and deployment workflow much more flexible.</p><h3>6. You Don’t Need to Be an Infrastructure Expert</h3><p>This is another thing I appreciate about Hostinger.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/547/0*ZsS5tUXgZDBy0eYt" /></figure><p>You can choose between a more manual Docker-based deployment or a<br>pre-configured Odoo environment.</p><p>Hostinger provides an Odoo VPS template that can simplify the initial<br>setup.</p><p>If you want more control, you can also use an Ubuntu/Docker VPS and<br>build your own Odoo architecture.</p><p>That gives you two approaches:</p><h3>Beginner-friendly approach</h3><pre>Hostinger VPS<br>      ↓<br>Odoo Template<br>      ↓<br>Initial Configuration<br>      ↓<br>Odoo Running</pre><h3>Developer approach</h3><pre>Hostinger VPS<br>      ↓<br>Ubuntu<br>      ↓<br>Docker<br>      ↓<br>Docker Compose<br>      ↓<br>Odoo + PostgreSQL<br>      ↓<br>Nginx<br>      ↓<br>SSL<br>      ↓<br>Custom Addons<br>      ↓<br>Production</pre><p>As a developer, I generally prefer the second approach when I need<br>complete control over the environment.</p><h3>7. Great Combination for Odoo Development</h3><p>One of my preferred workflows looks like this:</p><pre>Local Development<br>       |<br>       v<br>     Git<br>       |<br>       v<br>    Staging<br>       |<br>       v<br>Production VPS<br>       |<br>       +---- Odoo<br>       +---- PostgreSQL<br>       +---- Custom Addons<br>       +---- Nginx<br>       +---- SSL<br>       +---- Backups</pre><p>This is much better than manually editing production servers every time<br>you need to change something.</p><p>You can develop locally, test your changes, push them through Git, test<br>on staging, and then deploy to production.</p><h3>What About Performance?</h3><p>Performance is always a combination of <strong>hardware + configuration +<br>software architecture</strong>.</p><p>Don’t expect any VPS provider to automatically make a poorly configured<br>Odoo instance fast.</p><p>For production Odoo, I pay attention to things such as:</p><ul><li>CPU</li><li>RAM</li><li>PostgreSQL configuration</li><li>Odoo workers</li><li>Database indexes</li><li>Custom module quality</li><li>Slow queries</li><li>Scheduled actions</li><li>Large reports</li><li>Filestore storage</li><li>Reverse proxy configuration</li><li>Number of concurrent users</li></ul><p>A properly configured VPS can provide a very solid foundation.</p><p>And NVMe storage is particularly useful for database-heavy applications<br>because disk I/O matters.</p><h3>Hostinger + Odoo: When Does It Make Sense?</h3><p>In my opinion, Hostinger VPS is particularly attractive if you are:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/739/0*d7wAezov3qR9SdsT" /></figure><ul><li>A small or medium business</li><li>An Odoo developer</li><li>An Odoo implementation company</li><li>Building a custom Odoo solution</li><li>Running multiple Odoo environments</li><li>Looking for root access</li><li>Using Docker</li><li>Migrating an existing Odoo installation</li><li>Running custom modules</li><li>Looking for a relatively straightforward VPS experience</li></ul><p>It is also useful when you don’t want to jump immediately into a more<br>complex cloud infrastructure setup.</p><h3>When I Would Consider Something Else</h3><p>To be fair, Hostinger isn’t automatically the best choice for every<br>organization.</p><p>If you have very complex infrastructure requirements, massive workloads,<br>strict enterprise compliance requirements, or an organization that<br>already has a mature cloud infrastructure team, you may want to evaluate<br>providers such as AWS, Azure, Google Cloud, or specialized Odoo hosting<br>options.</p><p>The right hosting platform depends on:</p><ul><li>Number of users</li><li>Expected transactions</li><li>Required uptime</li><li>Compliance requirements</li><li>Budget</li><li>DevOps expertise</li><li>Backup requirements</li><li>Disaster recovery requirements</li><li>Geographic requirements</li><li>Integration architecture</li></ul><p>Don’t choose hosting purely because it is cheap.</p><p>Choose it because it fits the workload.</p><h3>My Practical Odoo VPS Checklist</h3><p>Before putting an Odoo system into production, I recommend checking:</p><pre>[ ] VPS resources selected according to workload<br>[ ] Ubuntu configured<br>[ ] Docker installed<br>[ ] Docker Compose configured<br>[ ] PostgreSQL configured<br>[ ] Odoo configured<br>[ ] Custom addons mounted<br>[ ] Persistent volumes configured<br>[ ] Nginx configured<br>[ ] SSL enabled<br>[ ] Firewall configured<br>[ ] Strong passwords configured<br>[ ] Database backups configured<br>[ ] Filestore backups configured<br>[ ] Backup restoration tested<br>[ ] Odoo workers configured<br>[ ] Logs monitored<br>[ ] Staging environment available<br>[ ] Domain configured<br>[ ] Email configured<br>[ ] Production deployment tested</pre><p>This checklist is often more important than the hosting brand itself.</p><h3>My Experience in One Sentence</h3><p>If I had to summarize my experience:</p><blockquote><strong><em>Hostinger VPS gives me a practical balance between cost, control,<br>simplicity, and flexibility for many Odoo deployments.</em></strong></blockquote><p>I particularly like the combination of:</p><p><strong>VPS + Ubuntu + Docker + PostgreSQL + Odoo + Nginx</strong></p><p>because it gives me control without forcing me to build an unnecessarily<br>complicated infrastructure stack.</p><p>And for developers who are comfortable with Linux and Docker, it is a<br>very practical environment.</p><h3>Want Help Deploying Odoo?</h3><p>If you’re planning to:</p><ul><li>Deploy Odoo on a VPS</li><li>Migrate Odoo from another server</li><li>Configure Docker</li><li>Install Odoo Community or Enterprise</li><li>Deploy custom Odoo modules</li><li>Configure Nginx and SSL</li><li>Optimize an existing Odoo server</li><li>Set up staging and production</li><li>Configure backups</li><li>Troubleshoot Odoo deployment issues</li></ul><p>Feel free to reach out.</p><p><strong>Free consultation:</strong><br>📧 <a href="/service/mailto:abdullah@devpii.com"><strong>abdullah@devpii.com</strong></a></p><p>I work on <strong>Odoo implementation, customization, development, deployment, and technical consulting</strong> through <a href="http://www.devpii.com/">DevPii</a>.</p><h3>Get Hostinger for Your Odoo VPS</h3><p>If you want to try Hostinger, you can use my referral link:</p><p>👉 <a href="https://www.hostinger.com/pk?REFERRALCODE=PWNMABDULBE3"><strong>Get Hostinger VPS</strong></a></p><p>Using my referral link may give you an additional discount depending on<br>the current Hostinger offer and plan.</p><p>Before purchasing, check the current pricing, renewal rates, available<br>VPS resources, and applicable promotions.</p><h3>Final Thoughts</h3><p>Hosting Odoo doesn’t have to be complicated.</p><p>You need a reliable foundation, enough resources for your workload,<br>proper backups, security, and a deployment architecture that you can<br>actually maintain.</p><p>For many of the Odoo projects I work with, <strong>Hostinger VPS + Docker</strong><br>has been a good combination.</p><p>It gives me the freedom to configure the server the way I need, deploy<br>custom Odoo modules, manage containers, work with PostgreSQL, and scale resources as the project grows.</p><p>If you’re an Odoo developer or business owner looking for a practical<br>place to start, it’s definitely an option worth evaluating.</p><p><strong>Have you deployed Odoo on Hostinger or another VPS provider?</strong></p><p>I’d love to hear about your experience.</p><p><strong>About the Author</strong></p><p><a href="http://smuhabdullah.github.io/"><strong>Muhammad Abdullah</strong></a> is an Odoo developer and the Founder &amp; CTO of<br><strong>DevPii Pvt. Ltd.</strong>, working on Odoo implementation, customization,<br>development, integrations, and deployment.</p><p>📧 <a href="/service/mailto:abdullah@devpii.com"><strong>abdullah@devpii.com</strong></a></p><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4d0dd52ede1a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[6# How to Execute SQL Queries in Odoo]]></title>
            <link>https://smuhabdullah.medium.com/how-to-execute-sql-queries-in-odoo-1a2e69317085?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/1a2e69317085</guid>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[development]]></category>
            <category><![CDATA[odoo-development]]></category>
            <category><![CDATA[erp]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Thu, 30 Jan 2025 09:14:03 GMT</pubDate>
            <atom:updated>2025-01-30T09:35:19.853Z</atom:updated>
            <content:encoded><![CDATA[<p>Odoo 18 introduces several improvements in database interactions, but sometimes, you may need to execute raw SQL queries to achieve specific requirements efficiently. In this blog, we will explore different ways to execute SQL queries in Odoo 18, covering both best practices and common use cases.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QEkQeNn8wojixVXB4i4QcA.png" /><figcaption><a href="https://www.youtube.com/@smuhabdullah/">https://www.youtube.com/@smuhabdullah/</a></figcaption></figure><h3>Why Use SQL Queries in Odoo?</h3><p>While Odoo provides a robust ORM (Object-Relational Mapping) for handling database operations, certain scenarios may require raw SQL queries, such as:</p><ul><li>Bulk data updates or inserts</li><li>Complex aggregations or joins</li><li>Performance optimization for large datasets</li><li>Running database maintenance tasks</li></ul><h3>Methods to Execute SQL Queries in Odoo</h3><h3>1. Using self.env.cr (Cursor)</h3><p>Odoo provides a cursor object self.env.cr, which allows developers to execute raw SQL queries directly.</p><h4>Example: Selecting Data</h4><pre>class ResPartnerInherit(models.Model):<br>    _inherit = &#39;res.partner&#39;<br>    <br>    def get_partner_data(self):<br>        self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE customer = TRUE&quot;)<br>        result = self.env.cr.fetchall()<br>        return result</pre><h3>2. Executing Queries with Parameters</h3><p>To prevent SQL injection, always use parameterized queries.</p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE id = %s&quot;, (partner_id,))<br>result = self.env.cr.fetchall()</pre><h3>3. Inserting or Updating Data</h3><p>For bulk operations, you can use SQL queries to improve performance.</p><pre>self.env.cr.execute(&quot;UPDATE res_partner SET is_company = TRUE WHERE country_id = %s&quot;, (country_id,))</pre><h3>4. Using self.env.cr.dictfetchall() for Dictionary Output</h3><p>By default, fetchall() returns a list of tuples. Use dictfetchall() to retrieve results as dictionaries.</p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner&quot;)<br>result = self.env.cr.dictfetchall()<br>for row in result:<br>    print(row[&#39;id&#39;], row[&#39;name&#39;])</pre><h3>Common Methods of self.env.cr</h3><h3>1. execute(query, params=None)</h3><p>Executes an SQL query with optional parameters.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE active=%s&quot;, (True,))</pre><h3>2. fetchone()</h3><p>Retrieves a <strong>single record</strong> from the last executed query.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE id=%s&quot;, (1,))<br>record = self.env.cr.fetchone()<br>print(record)  # Output: (1, &#39;Customer Name&#39;)</pre><h3>3. fetchall()</h3><p>Retrieves <strong>all results</strong> from the last executed query.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE active=%s&quot;, (True,))<br>records = self.env.cr.fetchall()<br>print(records)  # Output: [(1, &#39;Customer A&#39;), (2, &#39;Customer B&#39;)]</pre><h3>4. fetchmany(size)</h3><p>Retrieves a <strong>specified number of records</strong>.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner WHERE active=%s&quot;, (True,))<br>records = self.env.cr.fetchmany(5)  # Fetch only 5 records</pre><h3>5. commit()</h3><p>Saves the transaction permanently to the database.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;UPDATE res_partner SET active=%s WHERE id=%s&quot;, (False, 1))<br>self.env.cr.commit()</pre><blockquote><strong><em>Note:</em></strong><em> Be cautious when using </em><em>commit(), as it bypasses Odoo’s transaction management.</em></blockquote><h3>6. rollback()</h3><p>Reverts any uncommitted changes in case of an error.</p><p><strong>Example:</strong></p><pre>try:<br>    self.env.cr.execute(&quot;UPDATE res_partner SET active=%s WHERE id=%s&quot;, (False, 1))<br>    raise Exception(&quot;Something went wrong&quot;)  # Simulating an error<br>    self.env.cr.commit()<br>except Exception:<br>    self.env.cr.rollback()  # Undo changes</pre><h3>7. rowcount</h3><p>Returns the <strong>number of affected rows</strong> by the last SQL query.</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;UPDATE res_partner SET active=%s WHERE active=%s&quot;, (False, True))<br>print(self.env.cr.rowcount)  # Output: Number of affected rows</pre><h3>8. description</h3><p>Returns <strong>metadata</strong> about the last executed query (column names, types, etc.).</p><p><strong>Example:</strong></p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner&quot;)<br>print(self.env.cr.description)</pre><h3>Final Thoughts</h3><p>Understanding self.env.cr methods can help you unlock more flexibility when working with Odoo databases. While raw SQL queries can be powerful, use them wisely to maintain data consistency and performance.</p><p>Do you have any questions or need help optimizing your Odoo queries? Feel free to ask in the comments!</p><p>📌 **Follow for more Odoo deve</p><h3>CRUD Operations with SQL in Odoo</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rVOq7xJ2eLm4bwzL.png" /></figure><h4>1. Create (Insert Data)</h4><p>To insert records into a database table, use the following SQL statement:</p><pre>class ResPartnerInherit(models.Model):<br>    _inherit = &#39;res.partner&#39;<br>    <br>    def insert_partner(self, name, email):<br>        self.env.cr.execute(&quot;&quot;&quot;<br>            INSERT INTO res_partner (name, email, company_type, create_date)<br>            VALUES (%s, %s, &#39;company&#39;, NOW())<br>        &quot;&quot;&quot;, (name, email))<br>        self.env.cr.commit()</pre><h4>2. Read (Select Data)</h4><p>Fetching records from a table:</p><pre>class ResPartnerInherit(models.Model):<br>    _inherit = &#39;res.partner&#39;<br>    <br>    def get_partner_data(self):<br>        self.env.cr.execute(&quot;SELECT id, name, email FROM res_partner WHERE customer = TRUE&quot;)<br>        result = self.env.cr.fetchall()<br>        return result</pre><p>For dictionary output:</p><pre>self.env.cr.execute(&quot;SELECT id, name FROM res_partner&quot;)<br>result = self.env.cr.dictfetchall()<br>for row in result:<br>    print(row[&#39;id&#39;], row[&#39;name&#39;])</pre><h4>3. Update Data</h4><p>Updating existing records:</p><pre>self.env.cr.execute(&quot;&quot;&quot;<br>    UPDATE res_partner <br>    SET is_company = TRUE <br>    WHERE country_id = %s<br>&quot;&quot;&quot;, (country_id,))<br>self.env.cr.commit()</pre><h4>4. Delete Data</h4><p>Removing records from the database:</p><pre>self.env.cr.execute(&quot;DELETE FROM res_partner WHERE id = %s&quot;, (partner_id,))<br>self.env.cr.commit()</pre><h3>Best Practices When Using SQL Queries in Odoo 18</h3><ul><li><strong>Use ORM whenever possible</strong>: Odoo’s ORM is safer, more efficient, and maintains data integrity.</li><li><strong>Always use parameterized queries</strong>: This prevents SQL injection vulnerabilities.</li><li><strong>Avoid hardcoded table names</strong>: Use self.env[&quot;model.name&quot;]._table to get the correct table name dynamically.</li><li><strong>Optimize for performance</strong>: Use indexes and LIMIT clauses where applicable.</li><li><strong>Commit transactions when needed</strong>: If your SQL query modifies data outside ORM, you may need to commit changes explicitly.</li></ul><pre>self.env.cr.commit()</pre><h3>Conclusion</h3><p>Executing SQL queries in Odoo can be powerful when used correctly. While the ORM should be your primary tool, direct SQL queries can be beneficial for specific use cases like bulk updates, reporting, and performance tuning. Always follow best practices to ensure data integrity and security.</p><p>By mastering these techniques, you can enhance your Odoo development skills and optimize your applications efficiently!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hqmGMS1U_RfM6wMjUdlOgQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Tlry90oG0nO0tgadA1sHlQ.png" /><figcaption><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></figcaption></figure><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1a2e69317085" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5# How to Create Graph View in Odoo]]></title>
            <link>https://smuhabdullah.medium.com/5-how-to-create-graph-view-in-odoo-dbd458654a45?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/dbd458654a45</guid>
            <category><![CDATA[erp]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[odoo-implementation]]></category>
            <category><![CDATA[odoo-development]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Tue, 28 Jan 2025 06:48:16 GMT</pubDate>
            <atom:updated>2025-01-28T06:48:16.388Z</atom:updated>
            <content:encoded><![CDATA[<h4>Bar Chart, Line Chart, and Pie Chart Tutorial</h4><p>In this comprehensive tutorial, you will learn how to create and customize graph views in Odoo, including bar charts, line charts, and pie charts. Additionally, we will explore different test cases, supported graphs, and useful operations for various scenarios.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fybztCDwzhjN5Efwx-9zhA.png" /></figure><h3>What is Graph View in Odoo?</h3><p>Graph view in Odoo is a powerful visualization tool that allows users to represent data in graphical formats such as bar charts, line charts, and pie charts. It provides an interactive way to analyze data trends, summaries, and patterns directly within Odoo’s interface.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/740/0*PCGnaX-lH-DDlUPp.png" /></figure><h3>How to Create Graph View in Odoo?</h3><p>To create a graph view in Odoo, follow these steps:</p><ol><li><strong>Define the XML View</strong>:</li></ol><pre>&lt;record id=&quot;view_graph_example&quot; model=&quot;ir.ui.view&quot;&gt;     <br>    &lt;field name=&quot;name&quot;&gt;Example Graph View&lt;/field&gt;     <br>    &lt;field name=&quot;model&quot;&gt;model.name&lt;/field&gt;     <br>    &lt;field name=&quot;arch&quot; type=&quot;xml&quot;&gt;         <br>        &lt;graph string=&quot;Example Graph&quot; type=&quot;bar&quot;&gt;             <br>            &lt;field name=&quot;field_x&quot; type=&quot;row&quot;/&gt;             <br>            &lt;field name=&quot;field_y&quot; type=&quot;measure&quot;/&gt;         <br>        &lt;/graph&gt;     <br>    &lt;/field&gt; <br>&lt;/record&gt;</pre><ol><li><strong>Add the View to an Action</strong>: Link the graph view to an action in your module for accessibility.</li><li><strong>Customize as Needed</strong>: Modify fields and settings based on the type of graph and use case.</li></ol><h3>How Many Types of Graphs Are Available in Odoo?</h3><p>Odoo supports the following graph types:</p><ol><li><strong>Bar Chart</strong>: Ideal for comparing quantities across categories.</li><li><strong>Line Chart</strong>: Best for showing trends over time.</li><li><strong>Pie Chart</strong>: Suitable for displaying proportions or percentages.</li></ol><p>These graph types can be defined in the type attribute of the &lt;graph&gt; tag.</p><h3>What Are Measures in Graph View?</h3><p>In Odoo graph views, measures represent the numerical fields used for computation or aggregation (e.g., sum, average, count). These fields are defined using the type=&quot;measure&quot; attribute in the graph view XML.</p><h3>How to Change the Format of Date and Datetime Fields?</h3><p>To customize the date or datetime field format in graph views:</p><ol><li>Use Odoo’s date_format or datetime_format attributes in the XML.</li><li>Define specific formatting in the backend using Python.</li><li>Ensure the user’s timezone is accounted for using pytz.</li></ol><h3>How to Change the Default Graph in Odoo?</h3><p>Set the default graph type in the type attribute of the &lt;graph&gt; tag, such as type=&quot;bar&quot;, type=&quot;line&quot;, or type=&quot;pie&quot;.</p><h3>How to Set Default Measure in Graph View?</h3><p>Define the default measure by marking the field with type=&quot;measure&quot;. For example:</p><pre>&lt;field name=&quot;sales&quot; type=&quot;measure&quot; default=&quot;1&quot;/&gt;</pre><p>This ensures the measure is preselected when the graph loads.</p><h3>How to Set Default Date or Datetime Field with Different Formats?</h3><p>Set a default date or datetime field in the graph view by:</p><ol><li>Using the default attribute in the &lt;field&gt; tag.</li><li>Applying the desired date format in the backend using Python.</li><li>Ensuring compatibility with the user’s timezone and locale.</li></ol><h3>How to Order the Current Graph View by Ascending or Descending Order?</h3><p>You can specify the sorting order of the graph view by:</p><ol><li>Adding an order attribute to the &lt;graph&gt; tag in XML.</li><li>Implementing ordering logic in the model’s Python methods.</li></ol><p>Example:</p><pre>&lt;graph string=&quot;Example Graph&quot; type=&quot;bar&quot; order=&quot;field_y desc&quot;&gt;</pre><h3>How to Stash or Unstash in the Backend?</h3><p>Stashing and unstashing in Odoo’s backend involves managing state changes for records, often linked to temporary storage or filtering. To implement this:</p><ol><li>Define a stash/unstash button in the form view.</li><li>Implement a method in the model to handle the logic for stashing or unstashing records.</li></ol><p>Example Python Code:</p><pre>@api.model<br>def stash_record(self):<br>    self.write({&#39;stashed&#39;: True})<br>def unstash_record(self):<br>    self.write({&#39;stashed&#39;: False})</pre><p>This guide covered essential aspects of creating and customizing graph views in Odoo, providing insights into various scenarios and configurations. With these tips, you can enhance your Odoo applications and deliver meaningful data visualizations.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hqmGMS1U_RfM6wMjUdlOgQ.png" /><figcaption>Ready to see how Odoo ERP can transform your business? <a href="https://www.devpii.com/">Get in touch today</a> to schedule a demo or explore customized solutions tailored to your industry.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Tlry90oG0nO0tgadA1sHlQ.png" /></figure><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dbd458654a45" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlock the Perfect Odoo ERP Consultant for Your Business]]></title>
            <link>https://smuhabdullah.medium.com/unlock-the-perfect-odoo-erp-consultant-for-your-business-12ad3af14bb2?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/12ad3af14bb2</guid>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[erp-software]]></category>
            <category><![CDATA[consulting]]></category>
            <category><![CDATA[consultant]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Mon, 27 Jan 2025 16:46:58 GMT</pubDate>
            <atom:updated>2025-01-27T16:46:58.085Z</atom:updated>
            <content:encoded><![CDATA[<h4>Key Tips for Success</h4><p>Choosing the right Odoo ERP consultant is essential for a successful ERP implementation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/750/0*nmPg0IVyaPw5dvfF.jpg" /></figure><p>Here’s a comprehensive guide to help you make the right decision:</p><h3>1. Look for Expertise in Odoo Versions</h3><p>A good consultant should have in-depth knowledge of the specific version of Odoo you plan to use. Odoo is constantly evolving, so it’s vital to find someone who stays up-to-date with the latest versions, features, and updates. Check their experience in handling both older and newer versions of Odoo to ensure they can handle migrations or upgrades if needed.</p><h3>2. Customization and Integration Capabilities</h3><p>One of Odoo’s strengths is its flexibility, so your consultant should be adept at customizing the platform to meet your unique business requirements. Beyond customization, they should also be proficient in integrating Odoo with third-party applications you may use, such as CRM, payment gateways, or other business systems. Ask for examples of past integrations they’ve handled to assess their capability.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*xAExTj-Yc_aBwLUd.png" /></figure><h3>3. Experience in Your Industry</h3><p>Every industry has unique workflows and requirements. A consultant with specific experience in your sector will better understand your needs and provide tailored solutions. Whether it’s manufacturing, retail, healthcare, or any other industry, consultants with relevant experience can design a more efficient system for you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*UQxS_q3msyicyEIl" /></figure><h3>4. Clear Communication and Support</h3><p>An Odoo consultant needs to communicate clearly and offer ongoing support after implementation. ERP systems often require continuous monitoring, updates, and support. Ensure the consultant provides post-launch services such as bug fixes, updates, and user training. A consultant who can articulate complex issues in simple terms is a major asset.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/557/0*FJYKbGXL3L28yKDd.jpg" /></figure><h3>5. Client Testimonials and Reviews</h3><p>Reviews are a window into the consultant’s working style and success rate. Look for client testimonials, case studies, or references to understand how past projects were managed. Don’t hesitate to ask the consultant for references you can speak to directly for more insights into their services.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/0*7No2m6mfFSh6xmfN.jpg" /></figure><h3>6. Budget and Timelines</h3><p>It’s important to set clear expectations regarding the budget and project timeline. A reliable consultant should provide a transparent breakdown of costs and a realistic project schedule. Avoid consultants who offer unrealistic deadlines or pricing that seems too good to be true.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Jn1xw4aPNTM6E8NB.jpg" /></figure><h3>7. Ongoing Training and Documentation</h3><p>Implementation is just the start — your team will need proper training to maximize the system’s capabilities. A great consultant should offer comprehensive training sessions and detailed documentation to ensure your team can operate the system independently.</p><figure><img alt="" src="https://cdn-images-1.medium.com/proxy/1*b31hiO4ynbDLRrXWEFF4aQ.png" /></figure><h3>Conclusion</h3><p>Choosing the right Odoo ERP consultant is a strategic decision that can make or break your ERP success. Prioritize consultants who demonstrate technical expertise, industry experience, and strong communication skills. By following this guide, you can ensure a smooth implementation that aligns perfectly with your business needs.</p><p><strong>Need help with your Odoo ERP implementation? DM us now and let’s get started!</strong></p><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=12ad3af14bb2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Install Odoo on Windows]]></title>
            <link>https://smuhabdullah.medium.com/how-to-install-odoo-17-on-windows-a-comprehensive-guide-19f225843483?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/19f225843483</guid>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[odoo-developer]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[how-to]]></category>
            <category><![CDATA[odoo-development]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Sun, 26 Jan 2025 13:13:35 GMT</pubDate>
            <atom:updated>2025-01-26T13:51:01.477Z</atom:updated>
            <content:encoded><![CDATA[<h4>A Comprehensive Guide of installation of Odoo on Windows</h4><p>Odoo is a powerful open-source ERP system that offers a wide range of business management tools. While it is commonly used in Linux environments, installing Odoo on Windows is a practical solution for users who prefer the familiarity of Windows. This guide will walk you through the step-by-step process of installing Odoo 17 on Windows, enabling you to take full advantage of this versatile platform.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mEi_bAqz7H_ZUjRBiQEmYA.png" /></figure><h3>Why Install Odoo on Windows?</h3><p>While Linux is often the go-to choice for hosting Odoo due to its stability and performance, many users are more comfortable with Windows. Installing Odoo on Windows allows businesses to benefit from its robust features without requiring a Linux setup, making it more accessible to a wider audience.</p><h3>Step-by-Step Installation Guide</h3><h3>1. Install Python</h3><p>Before starting, check if Python is already installed on your system. Open the Command Prompt and type:</p><pre>python --version</pre><p>If Python is not installed or the version is below 3.10, download and install the latest version of Python from <a href="https://www.python.org/downloads/">Python’s official website</a>. During installation, select the <strong>Custom Installation</strong> option and check the “Add Python to PATH” box.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*X0_XUaeW5ubn3BVy.png" /></figure><h3>2. Install PostgreSQL</h3><p>PostgreSQL is the database system used by Odoo. Download PostgreSQL (version 13 or later) from <a href="https://www.enterprisedb.com/downloads/postgres-postgresql-downloads">the official website</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MWV32BIKGYVmehkz.png" /></figure><p>During installation:</p><ul><li>Check all components on the “Select Components” page.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/686/0*S3QnHb2HypYvPiHo.png" /></figure><ul><li>Set a superuser password and note it down for later.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/691/0*VAuMvduWsLimDMyh.png" /></figure><ul><li>After installation, complete the Stack Builder wizard to add database drivers.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/760/0*Kjkg7-u6zm4X0_ur.png" /></figure><h3>3. Configure pgAdmin and PSQL</h3><p>pgAdmin is a GUI tool for managing PostgreSQL databases. Open pgAdmin, log in with your superuser password, and:</p><ol><li>Expand the “Servers” option in the Object Explorer.</li><li>Create a new role under “Login/Group Roles.”</li><li>Set a name, password, and privileges for the new role.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*BFYWPF3c07jK9rJF.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/784/0*3Ey4rPu-6BSIi-6O.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/0*I_zBVeMTRIET9bnb.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/786/0*wZhrq9hlfDAYS5B-.png" /></figure><h3>4. Install the C++ Build Tools</h3><p>Odoo requires C++ build tools for some dependencies. Download the installer from <a href="https://visualstudio.microsoft.com/visual-cpp-build-tools/">Microsoft’s website</a> and install the “Desktop Development with C++” workload. Restart your system once the installation is complete.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*tXyZs4Wom_A4ULPQ.png" /></figure><h3>5. Download Odoo 17</h3><p>Visit <a href="https://github.com/odoo/odoo/tree/17.0">Odoo’s GitHub repository</a> and search for the Odoo project. Ensure you select the branch for version 17. Download the ZIP file, extract it, and save it in a safe location.</p><h3>6. Install PyCharm or VS Code</h3><p>PyCharm or VS Code is an IDE that simplifies Python development. Download the community edition from <a href="https://www.jetbrains.com/pycharm/download/">JetBrains</a>. Follow the installation steps and ensure your system meets the minimum requirements (e.g., 4GB RAM, modern CPU).</p><h3>7. Set Up the Development Environment in PyCharm</h3><ol><li>Open PyCharm and select <strong>Open Existing Project</strong>.</li><li>Navigate to the extracted Odoo 17 folder and open it.</li><li>Create an odoo.conf file inside the project folder with the following content:</li></ol><pre>[options]<br>admin_passwd = admin<br>db_host = localhost<br>db_port = 5432<br>db_user = &lt;your_pg_user&gt;<br>db_password = &lt;your_pg_password&gt;<br>addons_path = &lt;path_to_odoo_addons&gt;<br>xmlrpc_port = 8017</pre><p>Replace &lt;your_pg_user&gt;, &lt;your_pg_password&gt;, and &lt;path_to_odoo_addons&gt; with your PostgreSQL username, password, and the addons folder path, respectively.</p><p>4. Configure the Python interpreter in PyCharm by navigating to <strong>Settings &gt; Project Settings &gt; Python Interpreter</strong>. Add the system interpreter and ensure it points to the installed Python version.</p><p>or create a virtual environment using below command</p><pre>pip install virtualenv</pre><pre>python&lt;version&gt; -m venv &lt;virtual-environment-name&gt;</pre><p>Like So 👇</p><pre>mkdir projectA<br>cd projectA<br>python3.8 -m venv env</pre><p>5. Create a run configuration for Odoo by selecting <strong>Edit Configurations</strong>, clicking the <strong>+</strong> icon, and choosing <strong>Python Interpreter</strong>. Set the script path to odoo-bin and save the configuration.</p><p>and on the script parameter</p><pre>-c &lt;path of odoo.conf&gt;</pre><p>On the VS Code</p><p>after activating the virtual environment using</p><pre>source env/bin/activate</pre><p><strong>After Activating the Virtual Environment whether Via Pycharm or VS Code Install the Packages</strong></p><pre>pip install -r requirements.txt</pre><p>To run Odoo write command in your terminal</p><pre>./odoo-bin -c &lt;path of odoo.conf&gt;</pre><p><strong>Missing package Alternate package for install</strong></p><pre>pip install psycopg2<br>pip install psycopg2-binary<br>pip install pillow<br>pip install PIL-Tools<br>pip install dateutils<br>pip install infi.win32service<br>pip install pypiwin32</pre><p>After adding the missing packages, run the instance once again open the browser and paste the “localhost:8017” address.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*HiD1eF3mc3BiKLA8.png" /></figure><h3>Wrapping Up</h3><p>By following these steps, you’ll have Odoo 17 installed and running on your Windows system. This setup allows you to develop, test, and use Odoo without relying on a Linux environment, offering convenience and flexibility. Whether you’re a developer or a business owner, installing Odoo on Windows opens up a world of possibilities for managing your operations effectively.</p><p>Got any questions or need further assistance? Drop a comment below or reach out to us!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=19f225843483" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Mastering XPath Expressions in Odoo QWeb Attributes]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://smuhabdullah.medium.com/mastering-xpath-expressions-in-odoo-qweb-attributes-aade4f78963a?source=rss-b6eb7c13697a------2"><img src="https://cdn-images-1.medium.com/max/1000/0*U1_cJpP2h6Z9TS2T" width="1000"></a></p><p class="medium-feed-snippet">A Developer&#x2019;s Guide</p><p class="medium-feed-link"><a href="https://smuhabdullah.medium.com/mastering-xpath-expressions-in-odoo-qweb-attributes-aade4f78963a?source=rss-b6eb7c13697a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://smuhabdullah.medium.com/mastering-xpath-expressions-in-odoo-qweb-attributes-aade4f78963a?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/aade4f78963a</guid>
            <category><![CDATA[programming-tips]]></category>
            <category><![CDATA[development]]></category>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Fri, 04 Oct 2024 13:41:42 GMT</pubDate>
            <atom:updated>2024-10-04T13:41:42.221Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Top 10 Reasons to Choose Odoo ERP for Your Business]]></title>
            <link>https://smuhabdullah.medium.com/top-10-reasons-to-choose-odoo-erp-for-your-business-fdac958592cd?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/fdac958592cd</guid>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[buisness]]></category>
            <category><![CDATA[erp]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Mon, 23 Sep 2024 11:47:51 GMT</pubDate>
            <atom:updated>2024-09-23T11:47:51.613Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1000/0*0MpHaTLacAMvf0GP.png" /></figure><p>In today’s competitive landscape, businesses must adopt the right tools to streamline operations, enhance productivity, and scale effectively. Enterprise Resource Planning (ERP) systems are at the heart of modern business operations, and among the most popular choices is <strong>Odoo ERP</strong>. Odoo is an all-in-one business management software that offers a suite of applications tailored to a variety of industries and business needs. Whether you’re a small startup or a large enterprise, here are the <strong>top 10 reasons</strong> why you should choose Odoo ERP for your business.</p><h4>1. Comprehensive All-in-One Solution</h4><p>Odoo provides an integrated suite of over 30 modules that handle every facet of your business — whether it’s sales, CRM, accounting, HR, inventory, project management, or e-commerce. This means you don’t have to manage multiple disconnected software systems. Odoo consolidates all your processes into a single, easy-to-manage platform, offering end-to-end visibility of your operations.</p><h4>2. Highly Customizable</h4><p>Unlike other ERP systems, Odoo offers unparalleled customization. Each module can be tailored to fit the unique needs of your business. With an open-source core, developers have the flexibility to create custom workflows, fields, and integrations, making Odoo adaptable to businesses of any size or complexity.</p><h4>3. User-Friendly Interface</h4><p>Odoo’s intuitive and modern user interface is designed to make it easy for non-technical users to navigate and manage. Whether you’re a tech-savvy user or a business owner with little experience in ERP systems, Odoo’s interface ensures a smooth learning curve. This user-centered design leads to higher employee adoption rates and faster implementation.</p><h4>4. Scalable for Growing Businesses</h4><p>As your business grows, so do your ERP needs. Odoo grows with you, providing the ability to add new modules, users, or processes without disruption. This scalability ensures that Odoo can serve as the foundation for your business at every stage of growth, from startup to enterprise-level operations.</p><h4>5. Cost-Effective</h4><p>Odoo offers a pricing model that makes it affordable for businesses of all sizes. For small businesses, the <strong>Odoo Community Edition</strong> is free and open source, while the <strong>Odoo Enterprise Edition</strong> offers additional features at a competitive price. Compared to other ERPs like SAP or Oracle, Odoo is an economical option that doesn’t sacrifice functionality or scalability.</p><h4>6. Open-Source Flexibility</h4><p>One of Odoo’s standout features is its open-source architecture. This allows businesses to access the source code and customize the system as needed. The large Odoo community actively contributes to the platform, ensuring continuous improvement and a wide variety of available integrations, plugins, and third-party apps.</p><h4>7. Integrated E-Commerce and Website Builder</h4><p>For businesses looking to manage both their physical operations and online presence, Odoo offers built-in e-commerce capabilities. Its integrated <strong>Website Builder</strong> and <strong>E-commerce</strong> modules allow you to create a full-fledged online store that’s seamlessly connected to inventory, sales, and accounting — everything is managed from a single platform.</p><h4>8. Strong Community and Support</h4><p>With over <strong>7 million users</strong> and a strong developer community, Odoo has an extensive support ecosystem. Whether you need custom solutions, help with implementation, or just troubleshooting, you’ll find resources from official partners, forums, and a wealth of documentation. Additionally, Odoo offers direct support through its enterprise plans, ensuring you’re never left without assistance.</p><h4>9. Advanced Reporting and Analytics</h4><p>Odoo provides robust reporting tools that offer actionable insights into your business performance. From sales reports to inventory forecasts, Odoo’s customizable reports allow you to track KPIs, monitor processes, and make data-driven decisions. Additionally, its integrated analytics tools help you spot inefficiencies and optimize workflows across departments.</p><h4>10. Seamless Integration with Third-Party Tools</h4><p>Odoo’s modular design means you can integrate it with a variety of third-party applications such as payment gateways, marketing tools, shipping solutions, and other business software. Whether you’re using external CRM tools, payment platforms like PayPal, or shipping carriers like FedEx, Odoo offers seamless integration to ensure a unified business environment.</p><h3>Conclusion</h3><p>Odoo ERP stands out as one of the most comprehensive, customizable, and cost-effective solutions available today. Its all-in-one nature, coupled with open-source flexibility and powerful integrations, makes it an ideal choice for businesses across industries. Whether you’re looking to streamline operations, improve efficiency, or enhance customer experiences, <strong>Odoo ERP</strong> provides the tools you need to succeed.</p><p>If you’re ready to take your business to the next level, Odoo ERP is the solution you need to grow smarter, not harder.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/851/1*tsrG-fWXZSEVZ7dYkDVyvQ.png" /><figcaption><a href="https://www.devpii.com/">https://www.devpii.com/</a></figcaption></figure><h3>Call to Action</h3><p>Ready to see how Odoo ERP can transform your business? <a href="https://www.devpii.com/">Get in touch today</a> to schedule a demo or explore customized solutions tailored to your industry.</p><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fdac958592cd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Finding the Perfect Odoo ERP Consultant]]></title>
            <link>https://smuhabdullah.medium.com/finding-the-perfect-odoo-erp-consultant-2e0992a7036e?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/2e0992a7036e</guid>
            <category><![CDATA[erp-software]]></category>
            <category><![CDATA[consulting]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[odoo-development]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Fri, 13 Sep 2024 10:19:54 GMT</pubDate>
            <atom:updated>2024-09-13T10:49:25.149Z</atom:updated>
            <content:encoded><![CDATA[<h4>Key Tips for Success</h4><p>Choosing the right Odoo ERP consultant is essential for a successful ERP implementation.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kCKTJuJYVyWQYK0pp36lEw.png" /></figure><p>Here’s a comprehensive guide to help you make the right decision:</p><h3>1. Look for Expertise in Odoo Versions</h3><p>A good consultant should have in-depth knowledge of the specific version of Odoo you plan to use. Odoo is constantly evolving, so it’s vital to find someone who stays up-to-date with the latest versions, features, and updates. Check their experience in handling both older and newer versions of Odoo to ensure they can handle migrations or upgrades if needed.</p><h3>2. Customization and Integration Capabilities</h3><p>One of Odoo’s strengths is its flexibility, so your consultant should be adept at customizing the platform to meet your unique business requirements. Beyond customization, they should also be proficient in integrating Odoo with third-party applications you may use, such as CRM, payment gateways, or other business systems. Ask for examples of past integrations they’ve handled to assess their capability.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*xAExTj-Yc_aBwLUd.png" /></figure><h3>3. Experience in Your Industry</h3><p>Every industry has unique workflows and requirements. A consultant with specific experience in your sector will better understand your needs and provide tailored solutions. Whether it’s manufacturing, retail, healthcare, or any other industry, consultants with relevant experience can design a more efficient system for you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*UQxS_q3msyicyEIl" /></figure><h3>4. Clear Communication and Support</h3><p>An Odoo consultant needs to communicate clearly and offer ongoing support after implementation. ERP systems often require continuous monitoring, updates, and support. Ensure the consultant provides post-launch services such as bug fixes, updates, and user training. A consultant who can articulate complex issues in simple terms is a major asset.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/557/0*FJYKbGXL3L28yKDd.jpg" /></figure><h3>5. Client Testimonials and Reviews</h3><p>Reviews are a window into the consultant’s working style and success rate. Look for client testimonials, case studies, or references to understand how past projects were managed. Don’t hesitate to ask the consultant for references you can speak to directly for more insights into their services.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/980/0*7No2m6mfFSh6xmfN.jpg" /></figure><h3>6. Budget and Timelines</h3><p>It’s important to set clear expectations regarding the budget and project timeline. A reliable consultant should provide a transparent breakdown of costs and a realistic project schedule. Avoid consultants who offer unrealistic deadlines or pricing that seems too good to be true.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Jn1xw4aPNTM6E8NB.jpg" /></figure><h3>7. Ongoing Training and Documentation</h3><p>Implementation is just the start — your team will need proper training to maximize the system’s capabilities. A great consultant should offer comprehensive training sessions and detailed documentation to ensure your team can operate the system independently.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*YxDRktRQphExTjVe.jpg" /></figure><h3>Conclusion</h3><p>Choosing the right Odoo ERP consultant is a strategic decision that can make or break your ERP success. Prioritize consultants who demonstrate technical expertise, industry experience, and strong communication skills. By following this guide, you can ensure a smooth implementation that aligns perfectly with your business needs.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*r1oPk4vgRrSe7xjM.jpg" /></figure><p><strong>Need help with your Odoo ERP implementation? DM us now and let’s get started!</strong></p><p>Click on the link below to discover a wealth of knowledge and explore a variety of engaging topics.</p><p>Medium Profile: <a href="https://smuhabdullah.medium.com/">Muhammad Abdullah Arif — Medium</a></p><p><a href="https://smuhabdullah.medium.com/subscribe">Stay Up-to-Date with Muhammad Abdullah Arif’s Latest Publications — Subscribe Now! (medium.com)</a></p><p>If you wish to offer your support, kindly click on the link below to treat me to a coffee! ☕️😊</p><p><a href="https://www.buymeacoffee.com/smuhabdullah">https://www.buymeacoffee.com/smuhabdullah</a></p><p>I wish you all the best in your future endeavours.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2e0992a7036e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[4# Mastering Odoo Design Patterns]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://smuhabdullah.medium.com/4-mastering-odoo-design-patterns-f754de8dcd93?source=rss-b6eb7c13697a------2"><img src="https://cdn-images-1.medium.com/max/1001/0*RUppe_Yo4LSat5SM.png" width="1001"></a></p><p class="medium-feed-snippet">Key Patterns and Practical Examples</p><p class="medium-feed-link"><a href="https://smuhabdullah.medium.com/4-mastering-odoo-design-patterns-f754de8dcd93?source=rss-b6eb7c13697a------2">Continue reading on Medium »</a></p></div>]]></description>
            <link>https://smuhabdullah.medium.com/4-mastering-odoo-design-patterns-f754de8dcd93?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/f754de8dcd93</guid>
            <category><![CDATA[odoo]]></category>
            <category><![CDATA[odoo-erp]]></category>
            <category><![CDATA[tutorial]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[development]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Fri, 30 Aug 2024 11:53:10 GMT</pubDate>
            <atom:updated>2024-08-30T11:53:53.393Z</atom:updated>
        </item>
        <item>
            <title><![CDATA[Advanced Django Models]]></title>
            <description><![CDATA[<div class="medium-feed-item"><p class="medium-feed-image"><a href="https://medium.com/django-unleashed/advanced-django-models-53b651d3845a?source=rss-b6eb7c13697a------2"><img src="https://cdn-images-1.medium.com/max/1400/0*5QpyV0YCaijafsCT.png" width="1400"></a></p><p class="medium-feed-snippet">Tips and Tricks for Power Users</p><p class="medium-feed-link"><a href="https://medium.com/django-unleashed/advanced-django-models-53b651d3845a?source=rss-b6eb7c13697a------2">Continue reading on Django Unleashed »</a></p></div>]]></description>
            <link>https://medium.com/django-unleashed/advanced-django-models-53b651d3845a?source=rss-b6eb7c13697a------2</link>
            <guid isPermaLink="false">https://medium.com/p/53b651d3845a</guid>
            <category><![CDATA[developer-tools]]></category>
            <category><![CDATA[development]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[orm]]></category>
            <category><![CDATA[django]]></category>
            <dc:creator><![CDATA[Muhammad Abdullah Arif]]></dc:creator>
            <pubDate>Fri, 30 Aug 2024 06:40:45 GMT</pubDate>
            <atom:updated>2024-08-30T11:06:48.410Z</atom:updated>
        </item>
    </channel>
</rss>