Our work

Software projects we built for real clients. Each case study shows what the site does, which technologies we used and how we solved the technical challenges.

Filter by technology MySQL ▼

Applications / Software

PriceFlow

PriceFlow

Richiedi informazioni →

What it is. A cross-platform desktop application developed in-house by MontMara S.r.l. to manage prices, discounts and margins on PrestaShop e-commerce stores. Currently in production on Orologin.com and Luxislife.store for automated pricing rule application.

What it does:

  • Native multi-store support: each PrestaShop site is a profile with independent database, domain, VAT rate and commission configuration
  • Parametric discounts by category, brand and supplier, with batch application to selected rows
  • Combined filters on product status, discount condition, category and supplier, with live search across all columns
  • Automatic margin calculation accounting for marketplace fees (PayPal, Klarna, Stripe) and per-country VAT
  • "Time-limited products" category management for temporary discount campaigns, with a dedicated removal action
  • Configuration import/export in JSON between installations: moving the setup between PCs takes seconds
  • Google Analytics GA4 integration for real-time discount/sales correlation

The technical challenge. On catalogues with thousands of products, applying discounts via PrestaShop Webservice would take hours. PriceFlow bypasses the webservice and operates directly on the MySQL database with batch transactions, reducing the operation to minutes. Margin calculation accounts for payment fees and marketplace sales, consistent with the multi-store configuration.

Tech stack: Python 3, PySide6 (Qt Framework), MySQL connector, Google Analytics Data API integration, QSettings for local profile storage, PyInstaller for desktop distribution, JSON configuration export.

Menu digitale QR

Menu digitale QR

What it is. A digital menu for restaurants, built for Ristorante Il Rinascente: guests open it by scanning a QR code at the table, with nothing to install. Behind it, a back office lets the restaurant update dishes, prices, categories, allergens and languages on its own.

What it contains:

  • responsive public menu, readable on any smartphone
  • several menus active at once: daily menu, pizzas, seasonal menu
  • expandable categories with icons, allergens highlighted on every dish
  • multilingual: 3 languages, 5 menus, 12 categories, 134 dishes

What we built:

  • back office with dashboard and records for menus, categories, dishes, allergens and languages
  • QR codes to print on tables, always pointing to the current menu
  • instant publishing: every change goes live with nothing to reprint
  • custom look based on the restaurant's colours

Tech stack: PHP, MySQL, responsive Bootstrap, authenticated back office, QR codes, allergen management compliant with EU Reg. 1169/2011.