JS Automation
References

From task to solution.

Explore workflows developed for FusionOil, BNF and Árki Baucentrum: the source data, the processing steps and the delivered outputs.

Back to the homepage

Projects by task

Reconciliation of transport data

FusionOil

Several spreadsheets were consolidated into monthly weight summaries, transport reports and reconciled partner lists.

Case study FusionOil
Retail and building materials

Árki Baucentrum

We delivered two connected product-data projects. The goal was to prepare a large volume of webshop content and to turn door products found in catalogues into structured website-ready data, complete with images and generated descriptions.

≈ 5,000products processed
2delivered projects
2 applicationsMetaMester and CatalogMester

Processed product data can serve as the starting point for an ecommerce build or a product page update.

Custom website development
01

Content enrichment for nearly 5,000 products from Excel

Starting point

Product data available in Excel needed consistent, webshop-ready content enrichment at a scale that would have made manual editing impractical.

Solution

MetaMester created a full product description and a short description for nearly 5,000 products, then assigned the primary product image.

Result

The product list could be prepared for webshop use with a consistent structure, uniform copy and a primary image for each processed item.

Excel product list
MetaMester processing
Full and short copy
Primary product image
02

Door products from supplier catalogues to the website

Starting point

Door product data and images were available in supplier catalogues, while the website required structured, reusable product content.

Solution

CatalogMester extracted and organised the doors, their data and images from the catalogues. MetaMester then generated consistent website product descriptions.

Result

The catalogue content became a website-ready product package enriched with product images and generated descriptions.

Door catalogue
Data and image extraction
Description generation
Website product content
Transport records

FusionOil

Excel-based workflows were developed to clean and consolidate transport data and reconcile shipments with contracted partner records.

A custom automation built around FusionOil’s source files and reconciliation rules.

Business automation
01

Cleaning and consolidating monthly Excel data

Data preparation

Starting point

Collected quantities were recorded across monthly Excel files and multiple sheets, with different table structures and intermediate summary rows.

Solution

The workflow standardised columns, removed empty and summary rows, and calculated monthly and period-wide weight totals for each partner from the shipment records.

Delivered output

A consolidated Excel report showed monthly quantities and period totals by partner.

Monthly Excel files
Cleaning and standardisation
Partner-level aggregation
Excel summary
02

Combining Minimo and PickNGo records

Transport summary

Starting point

Transport data from two sources needed a shared structure, with vehicle registration numbers associated with the drivers.

Solution

The workflow standardised the Minimo and PickNGo tables, matched drivers with registration numbers, and summed weights by date, vehicle and driver.

Delivered output

An Excel report presented collected quantities by date, vehicle registration and driver.

Minimo + PickNGo
Driver–vehicle matching
Grouping by date
Quantity report
03

Reconciling MOHU shipments with partner records

Data validation

Starting point

MOHU shipment records needed tax numbers and site addresses from the contracted partner register, while retaining individual shipment entries.

Solution

The workflow matched sources using partner IDs, company names and available address data. Missing or ambiguous values were flagged in a separate review list.

Delivered output

An itemised Excel register and a separate review list were produced. Uncertain addresses and tax numbers remained fields requiring verification.

MOHU shipment list
Partner reconciliation
Missing data and discrepancy flags
Itemised register
Pilot system

BNF

A pilot system was developed for BNF to assemble catalogue samples from Excel records, descriptions and images of building materials and tile products.

MetaMester prepared the product content, and FolioMester assembled several catalogue samples for review.

Business automation
01

Enriching Excel product data

MetaMester_AIPilot system

Starting point

Steel and concrete products, bricks and tiles were listed in Excel files. Descriptions and product images were also needed for catalogue preparation.

Solution

During the pilot, MetaMester processing added descriptions and primary product-image links to the lists. Images were also available as a separate asset collection.

Delivered output

Enriched Excel product lists and associated images were prepared for catalogue creation and pilot evaluation.

Excel product lists
Description enrichment
Product image matching
Prepared product content
02

PDF catalogue samples using a branded template

FolioMester_AIPilot system

Starting point

Product data and images needed to be arranged into clearly structured catalogue samples following BNF branding.

Solution

FolioMester arranged product records and images in a catalogue template. Several sample versions were produced to review page layouts and content presentation.

Delivered output

PDF catalogue samples with a branded cover and product pages were produced as part of the pilot system.

Product data and images
BNF branded template
Page assembly
PDF catalogue sample

Need a similar product-data workflow?

Show us the Excel file, catalogue or current webshop process, and we will assess how it can be automated safely.

Request a consultation