BACK TO HOME

04 / DATABASES & BACKEND

One database. One truth.

Most companies run on Excel files copied across ten computers, each slightly different. We consolidate them into a single governed database on your server, connected to a web application — one copy, no anomalies, ready for every export you need.

THE TRANSFORMATION

From scattered copies to a single source.

Today: the Excel jungle

  • A copy of the file on every computer — nobody knows which is current
  • Ten authors, ten spellings for the same thing
  • Whole product descriptions crammed into one cell
  • Overwrites and conflicting edits with no history
  • Every export and translation is manual work, again

After: one governed database

  • A single copy on the server, edited through a web application
  • Locked vocabulary — every author uses the same terms
  • Data split into clean, separate columns
  • Every change tracked: who, what, when — reversible
  • Exports and translations generated automatically

WHAT WE DO WITH YOUR DATA

Cleaning, structuring, connecting.

We collect every version floating around the company, bring them to a common denominator, resolve the conflicts, and migrate the result into one database on your server. From that day, everyone works on the same data through the web application — producing anomalies through parallel copies becomes impossible.
"Inox", "stainless", "INOX steel" — the same material, three ways, three bugs. We define the allowed terms together with you and lock them into dropdowns and validation rules, so every author necessarily uses the same vocabulary. Filters, search and statistics suddenly work.
Every attribute gets a label, and every label gets its translations — once. From then on the same product record can print itself in Slovenian, English, German or any language you add: for the website, for price lists, for catalogs. Add a language, and the entire database already speaks it.
"Chair, oak, 45×45×90, natural oil, 12 kg" — one cell, five facts. We break such fields into separate columns (material, dimensions, finish, weight …), so each fact can be filtered, sorted, translated and exported on its own.
Tailored exports from the whole database: filtered Excel tables per market or product line, price lists in your exact layout, and structured files that flow straight into InDesign for catalog production — the catalog pulls live data instead of copy-paste.
  • Deduplication and merging of near-identical records
  • Validation rules that stop wrong entries at the source
  • Imports from suppliers' files on a schedule
  • Images and documents attached to records, resized automatically
  • Full change history and role-based access
  • Feeds for the webshop, marketplaces and partners
0
COPY OF THE DATA — ON THE SERVER
0
CONFLICTING VERSIONS
0
OF CHANGES TRACKED

Bring order to your data.