Contributors mailing list archives
Re: Stock label printing solutionby
Elico Corp, Eric Caudal
We have developed a similar system and used a similar approach
with docx instead of py3o but the idea is the same.
|| 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:
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.