Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
2 Odgovori
502 Prikazi
Avatar
Dan Cliff

I'm trying to create my own barcoded labels within Odoo 18.4 Online Studio. I've taken a look at some of the other solutions that used barcodes on their reports, but it's not really clear how the barcodes get added to the report.


I've been searching online, but everything I've found so far involves custom code, and unfortunately the Odoo online system doesn't allow for custom code.

Avatar
Opusti
Avatar
Jainesh Shah(Aktiv Software)
Best Answer

Hello Dan Cliff,

 

In Odoo Online (Studio environment), you don't have access to custom Python modules, but you can still add barcodes to your reports using QWeb XML directly inside Studio. The barcode images are generated dynamically by Odoo's built-in /report/barcode/ controller.

 

Here is how you can achieve it step by step:

  1. Open the Report in Studio
    • Go to the app and open the report you want to modify (eg, Sales Order ).
    • Click the Studio (wrench) icon to edit the layout.

  1. Insert a Field Area
    • Add a field, column, or block in the place where you want your barcode to appear.
    • This will create a space in the layout.

  1. Edit Report Sources (XML)
    • In Studio, click EDIT SOURCES .
    • This will open the underlying QWeb XML code.
  2. Insert the Barcode Snippet
    Add the following XML code where you want the barcode to display:

    """"""""""""""""""""""""""""""""
    <div>
    <div class="col-5">
    <span style="margin-left:-60px;">
    <img t-if="doc.client_order_ref"style="width:400px;height:70px;"t-att-src="'/report/barcode/?barcode_type=%s&value=%s&width=%s&height=%s' % ('EAN13', doc.client_order_ref, 265, 80)"/>
    </span>    
    <div style="margin-left:100px" t-field="doc.client_order_ref"/>
    </div>
    </div>    
    """""""""""""""""""""""""""""""""""""

 

  • Replace doc.client_order_ref with the field you want to encode as a barcode.
    Examples:
    • Sales Order Number → doc.name
    • Customer Reference → doc.client_order_ref
    • Invoice Number → doc.move_name
  1. Save and Preview
    • Click Save in Studio.
    • Preview or print the report.
    • You will now see both the reference text and a scannable barcode.

​

If you have any questions, feel free to reach out to us.

Hope this helps!


Thanks & Regards,

Email : odoo@aktivsoftware.com


Avatar
Opusti
Dan Cliff
Avtor

Thank you for that code, I've been trying it but keep getting an "error while rendering".

This is the full XML code block for my report.

<data>
<xpath expr="/t[@t-name='studio_report_document']/div/div" position="replace" meta-class="oe_structure"/>
<xpath expr="/t[@t-name='studio_report_document']/div" position="inside" meta-class="page">
<div class="oe_structure">
<br/>
</div>

<h2 class="oe_structure">
<span t-field="doc.name"/>
</h2>

<p>
<br/>
</p>
<br/>

<div>
<div class="col-5">
<span style="margin-left:-60px;">
<img t-if="doc.barcode"
style="width:400px;height:70px;"
t-att-src="'/report/barcode/?barcode_type=%s&amp;value=%s&amp;width=%s&amp;height=%s' % ('EAN13', doc.barcode, 265, 80)"/>
</span>
<div style="margin-left:100px;">
<span t-field="doc.client_order_ref"/>
</div>
</div>
</div>
</xpath>
</data>

Dan Cliff
Avtor

Ignore my last comment - I was able to get it working, was finally able to find a copy of the working xml code from a test database and could copy and paste it over.

Avatar
Abdul Sobur
Best Answer

Hello, I am trying to do the same thing.


Within studio I can produce the barcode or QR, but when I print the Sales Order it is not there. I am reading that its a rendering issue but not able to find a solution. Are you able to share what you found, i am also on Odoo 18.4 Online Studio.

XML for my report as below. Thanks in advance.


<!-- QR version - code at the bottom -->


<data>

  <xpath position="replace" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[3]" meta-class="oe_structure"/>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[4]" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[5]" meta-t-if="not doc.signature" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[7]" meta-t-if="( not doc.sale_order_option_ids or doc.state not in ['draft', 'sent'] or not any(not option.is_present for option in doc.sale_order_option_ids) )" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[8]/div" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="after" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[9]/p[@id='carrier_description']" meta-t-if="doc.carrier_id.carrier_description" meta-id="carrier_description">

    <xpath position="move" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[9]/p[@id='carrier_description']/div" meta-t-out="doc.carrier_id.carrier_description"/>

    <p><br/></p>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[9]/div[2]" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <xpath position="inside" expr="/t[@t-name='sale.report_saleorder_document']//t[@t-call='web.external_layout']/div/div[10]" meta-class="oe_structure">

    <br/>

  </xpath>

 

  <!-- Insert QR at the bottom of the page -->

<data>

  <xpath expr="//div[@class='page']" position="inside">

    <div class="barcode mt16" style="text-align:center;">

      <img

        t-att-src="'/report/barcode/?barcode_type=%s&amp;value=%s&amp;width=%s&amp;height=%s' % ('QR', doc.name or '', 200, 200)"

        alt="Sales Order QR"

        style="max-width:100%;"

      />

      <p style="text-align:center;">Sales Order: <t t-esc="doc.name"/></p>

    </div>

  </xpath>

</data>

</data>


Avatar
Opusti