Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Stock label printing solution

by
Elico Corp, Eric Caudal
- 17/04/2019 08:39:58

We have developed a similar system and used a similar approach with docx instead of py3o but the idea is the same.


Elico
                Corp
Eric Caudal [Founder and CEO] - Shanghai Elico Limited
Odoo v12 Certified Consultant
Skype: elico.corp - Phone: + 86 186 2136 1670 (Cell) // + 86 21 6211 8017/27/37 (Office)
More information: https://www.elico-corp.com

Odoo Gold Partner // Best Odoo Partner APAC 2014, 2016 and 2018!

On 2019-04-15 11:47 a.m., Yoshi Tashiro wrote:
Hello,

We have a customer who would like to print stock labels for each serial number on label sticker sheets like this https://www.amazon.com/Address-Labels-Inkjet-Printers-Pack/dp/B0756VJNXG/ref=sr_1_3?qid=1555318480&s=gateway&sr=8-3.

I'd like to know what options are available for this request.

Here are some details:
- User expects to export PDF, and then prints on label sticker sheet from PDF.
- Each label should contain several icons and texts (these are fixed per product), together with some values pertaining to serial number (e.g. expiry date).
- Serial numbers in printed labels should be presented in QR code.
- Each product has specific labeling requirements, so we need to prepare quite a few number of templates.

I was looking into using https://github.com/OCA/reporting-engine/tree/12.0/report_py3o and thought it could handle the requirements with some additional coding and adjustments on .ods template if we worked around the following points:
- QR code generation -> we may generate QR code image when serial number is created, and use it in report print.
- horizontal loop of items -> as a preparatory step, we may generate label records with column id, and map each set of label data into the correct column defined in .ods template.

Would be nice to hear if this would be a valid approach when using report_py3o, and if there are simpler approaches to handle the requirement using other tools/modules.

-- 
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference