Midelco connector

Use your Midelco data for reporting, automation and AI.

Data Panda brings your Midelco data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your team uses every day.

Data Panda Reporting Automation AI Apps
Midelco logo
About Midelco

Where size, colour and shop all matter on the same article.

Midelco is the kassa-software that Dirmacom (Puurs) has been building since 1987 for Belgian fashion boutiques and shoe retailers. It is the system behind a hundred-plus shops across Flanders: chains like Manexco, Van Loock, Lenaerts, Delaere, Enoks and others. The product is built around the data structure that the sector needs: an article that lives in seasons, brands, maingroups, subgroups, themes, colours and subcolours, with stock kept per shop and per article and a per-shop sales line for every till transaction.

That is a rich operational picture: articles, article links, article matrices, EAN codes, brands, suppliers, shops, customers, card registrations, seasonal pricing, web action codes for the linked webshop. The reports a fashion buyer, a shop manager and the boekhouder need sit on top of that data and on top of accounting, marketing and the webshop. Midelco runs the till and the reservation flow well, but the answers about margin per brand per shop, like-for-like per season and dead-stock by colour live one layer up. Pulling Midelco into a warehouse is where those answers stop being a Dirmacom export plus an Excel.

What your Midelco data is for

What you get once Midelco is connected.

Fashion and footwear reporting

Margin, stock and sales rolled up the way the sector reads them: brand, season, colour and shop.

  • Margin per brand, season and shop
  • Sell-through and dead stock per colour and size
  • Like-for-like per season versus the same week last year

Process automation

Turn till sales and per-shop stock into action in the rest of the stack instead of an end-of-month catch-up.

  • Daily till totals posted to Exact Online or Yuki with the right VAT split
  • Transfers between shops triggered by sell-through imbalance
  • Reservation pickups pushed to the customer over Klaviyo flows

AI workflows

Use seasons, sizes, colours and customer history to sharpen buying and clienteling.

  • Size-curve forecasting per brand and per shop
  • Markdown timing per colour on traag-roterende stock
  • Clienteling prompts for staff on what a returning customer is likely to try

Custom apps on your data

Buyer and shop-floor tools that replace the export-and-mail-around routine in Midelco.

  • Buyer dashboards with margin, sell-through and supplier lead time per brand
  • Shop-manager apps that show today against plan per category
  • Customer 360 on the floor with size, colour and brand affinity
Use cases

Use cases we deliver with Midelco data.

A list of concrete reports, automations and AI features we have built on Midelco data. Pick the one that matches your situation.

Margin per brandSelling price minus landed cost per article, rolled up per brand and shop.
Sell-through per seasonUnits sold against units bought, per season and per maingroup.
Dead stock by colourArticle-colour combinations that have not sold for N days, ranked by tied-up cash.
Size-curve coverageWhich sizes are out of stock per shop while others are overstocked.
Like-for-like per seasonComparable revenue versus the same week last year, excluding new shops.
Shop-to-shop driftWhere the same article-colour-size sells in one shop and gathers dust in another.
End-of-day totalsTill totals, payment-type splits and refunds per shop and per workstation.
Supplier performanceLead time, fill rate and short-delivery rate per supplier and per brand.
Reservation flowTime from reservation to pickup, per shop, with the abandonment rate.
Card-registration valueLoyalty-card holders ranked by basket size, frequency and brand affinity.
Markdown impactRevenue and margin effect of seasonal markdowns per maingroup.
Webshop versus shopSame article-colour-size sold via the linked webshop versus over the till.
Real business questions

Answers you will finally get.

Which brands make money per shop?

Sales lines joined to article cost and current landed cost, rolled up per brand and per shop. Shows which brands carry the boetiek and which ones move volume but leave nothing once the leverancier-factuur is in.

Where is the same article-colour-size selling in one shop and gathering dust in another?

Per-shop stock against per-shop sell-through on the article-colour-size key. Surfaces the SKU that runs in Antwerp and sits in Hasselt, so a transfer goes out instead of a fresh purchase order.

Does the day-end reconcile to the boekhouding without exporting from Midelco?

Workstation totals, payment-type splits and refunds pushed daily into Exact Online or Yuki as journaalposten with the correct VAT split. The bookkeeper opens a clean day, not a tab full of Midelco-exports.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Daily till reconciliation with the boekhouding instead of an end-of-month catch-up. Real margin per brand and per shop after supplier invoices and seasonal markdowns, ready on the first.

For sales leaders

Buyers see margin, sell-through and supplier lead time per brand on one screen. Shop managers see today against plan per category before the after-school rush hits.

For operations

Inventory drift between shops, dead stock per colour and supplier fill rate surface before they hurt. Transfers replace a second purchase order when the same article-colour-size already sits in another shop.

Ideas

What you can automate with Midelco.

Pair with Exact Online

Post the daily Midelco till totals to Exact Online

Workstation totals, payment-type splits and refunds from Midelco land daily in Exact Online as journal entries with the right VAT split per shop. The end-of-day reconciles on its own and the bookkeeper stops chasing Midelco-exports to close the month.

Pair with Shopify

Run a single omnichannel view with Shopify

For a fashion or footwear retailer running Midelco in the shop and Shopify online, Data Panda stitches the same customer, article-colour-size and order across both. Sales, returns and loyalty reporting hold up at group level instead of living in two disconnected dashboards.

Pair with Klaviyo

Feed Midelco purchase history and reservations into Klaviyo

Card-registration purchases and reservation events from Midelco flow into Klaviyo as profile properties and triggers. Shop customers receive size-and-brand campaigns based on what they bought in the shop, and a flow goes out the moment a reservation is ready for pickup.

Pair with Akeneo

Push Akeneo product content into the Midelco article catalogue

Enriched article records from Akeneo flow into Midelco articles, brands, maingroups and colour-size variants, with the descriptions, attributes and media the linked webshop already uses. Staff on the floor see the same product story the customer saw online and catalogue updates stop being a double data-entry job.

Data model

Tables we make available.

These are the 31 tables we currently pull from Midelco into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Article Bullets
  • Article Links
  • Article Model Links
  • Article Prices
  • Article Sales
  • Articles
  • Brands
  • Bullet Details
  • Bullet Groups
  • Card Registrations
  • Cities
  • Colors
  • Countries
  • Customers
  • Eancodes
  • Groups
  • Maingroups
  • Parameter Types
  • Parameters
  • Sales Period
  • Seasons
  • Shops
  • Stocks By Article
  • Stocks Per Shop
  • Subcolors
  • Subgroups
  • Suppliers
  • Themes
  • Web Action Codes
  • Web Group Subtypes
  • Web Retour Reasons

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your Midelco data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From Midelco to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • Midelco connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Who builds Midelco?

Midelco is built by Dirmacom, based in Puurs, Belgium. They have been writing the product since 1987 specifically for the Belgian fashion and footwear retail market, with more than a hundred shops on it today.

How are size and colour variants handled?

Articles, their colour-size matrices and EAN codes land in the warehouse with the relationships intact, so a parent article and every colour-size SKU sit together. Margin and sell-through reports roll up per brand or per maingroup and drill down to the exact colour-size that is making or losing money.

We run several shops on one Midelco install. How does that come across?

Each shop is a first-class entity in the model and stock, sales and customers are joined to the right shop. Group reporting, transfers and like-for-like comparisons are ordinary queries in the warehouse instead of a manual merge job.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your Midelco setup and the systems around it. Together we pick the first thing worth building.