The Challenge: Bridging Odoo Data with Physical Retail Hardware
For premium retail brands, consistency is everything. From product quality to branding, every detail matters. Handful Saffron, a specialty food brand with a prominent retail presence at the Mall of Oman, mastered its product quality but faced a significant operational bottleneck. Their product catalog, including prices, weights, and descriptions, was meticulously managed in Odoo 19 Enterprise. However, their in-store shelf label printers—specialized Budry TM-xA price computing scales—operated on a completely different planet.
The Budry scales required a proprietary file format: a `.TMS` file with exactly 69 data fields for each product. This meant that every time the Handful Saffron team needed to update a price, add a new product, or change a product's weight, they had to perform a painstaking manual process:
- Update the product information in Odoo.
- Open a separate, complex template file for the Budry scales.
- Manually re-enter the same information into the correct 69 fields, ensuring precise formatting.
- Export the `.TMS` file and upload it to the scales.
This double-entry process was not just inefficient; it was a major source of errors. A single typo could lead to incorrect pricing on the shelf, frustrating customers and creating accounting discrepancies. The brand needed a way to make their master data in Odoo the single source of truth for their physical store labels.
The Solution: A Custom Odoo-to-TMS Integration Script
Handful Saffron approached SynthoERP with this unique challenge. Instead of proposing a costly hardware change, we focused on bridging the gap between their existing systems. The solution was a custom Python script, `excel_to_tms.py`, designed to serve as a data translator between Odoo and the Budry scales.
The workflow is elegantly simple:
- Export from Odoo: The script begins by taking a standard product data export from Odoo in an Excel format. This file contains all the necessary information: product name, price, barcode, weight, etc.
- Data Transformation: The Python script reads the Excel file and programmatically maps the Odoo data to the corresponding 69 fields required by the `.TMS` format. It handles all the specific formatting requirements, including the crucial detail of encoding the final file with a UTF-8 BOM (Byte Order Mark), which the Budry scales required to read the data correctly.
- Generate .TMS File: The script outputs a perfectly formatted `.TMS` file, ready to be uploaded directly to the scales.
The Result: Zero Double Entry and Perfect Consistency
With this custom integration, the Handful Saffron team's workflow was revolutionized. The tedious, error-prone manual data entry process was eliminated entirely. Now, the process is simple and foolproof:
Update a price in Odoo once → Run the script → The physical scale labels are ready to update automatically.
This change delivered significant benefits:
- Time Savings: What used to take hours of careful manual work each week now takes minutes. -Error Elimination: Pricing and product information on the physical labels are now guaranteed to match the master data in Odoo.
- Operational Agility: The team can run promotions or update prices across their entire product line with confidence and speed.
Unifying Physical and Digital Retail
Beyond the scale integration, SynthoERP also implemented Odoo's eCommerce module for Handful Saffron. This crucial step unified their product catalog across both their physical and online stores. Now, a product updated in the Odoo back-end is instantly updated for the in-store scales, the POS system at the Mall of Oman, and the eCommerce website. This single, unified catalog ensures perfect consistency in pricing and product availability, no matter how the customer chooses to shop.
This project demonstrates the true power of Odoo's flexibility. It's not just an out-of-the-box ERP; it's a platform that can be extended and integrated to solve the unique, real-world challenges that Omani businesses face. You don't always need to replace expensive hardware; sometimes, a smart script is all it takes.
Are you facing a similar challenge with integrating your business software and specialized hardware? Let's talk. SynthoERP specializes in creating these kinds of custom solutions. Contact us on WhatsApp at wa.me/96871150483 for a free, no-obligation discussion about your business needs.
Ready to Implement Odoo in Oman?
Get a free consultation with a certified Odoo consultant in Muscat. No commitment required.
Book Free Consultation →