Home / Case Studies / Tools Retailer

/ Case Study · Retail

A Magento Enterprise Store with PIM Integration. Faster Orders, Fewer Returns.

/ The engagement

Magento 2.3.3, Integrated with an Informatics PIM.

An upgrade of an established tools retailer's site to Magento Enterprise version 2.3.3, integrated with the Informatics PIM system. The build replaces an old Yahoo site, pulls product information from PIM through XML feeds, defines a firm data structure for every entity, and adds a deals page, so orders fulfil faster and returns fall.

Magento EnterprisePIM IntegrationXML FeedsDeals Page
MagentoEnterprise 2.3.3
PIMIntegrated
XMLProduct feeds
FasterOrder fulfilment

/ About the client

Tools Retailer

The client is an established tools retailer that has supplied the community with power tools, hand tools, woodworking tools, and machinery. They wanted to get rid of their Yahoo site and integrate with PIM and ERP to fulfil orders faster and reduce returns.

Brainvire, as a Magento partner, upgraded the client's existing site to Magento Enterprise version 2.3.3 and integrated it with the Informatics PIM system, so product information flows in cleanly and the store runs on a modern, maintainable base.

/ The approach

Design, architecture, and features, shipped as one program.

/01Import

Orders from CSV

The client wanted to import orders from files with no product information, so the team built an order import that reads CSV files reliably.

/02Structure

Every entity defined

Product information had to import in a synchronized way, so the team defined a data structure for each entity, from categories and products to attributes and promotions.

/03Deals

A dedicated page

The client wanted a deals page, so the team created one to showcase promotions and pull shoppers to the best offers.

/04Migration

Off Yahoo, onto Magento

The client wanted rid of the old Yahoo site, so the team built a new store on Magento Enterprise 2.3.3 and moved them across.

/ What stood in the way

Four problems, solved without a maintenance window.

Select a challenge to see how it shaped the build.

/01 Importing orders from CSV files →
/02 Defining the PIM data structure →
/03 Building the deals page →
/04 Changing the Yahoo site →

Importing orders from CSV files

The client wanted to import orders from files without product information. We built an order import that reads CSV files reliably into the store.

Defining the PIM data structure

The client wanted product information imported in a synchronized way. We defined a firm data structure for every entity brought in from PIM.

Building the deals page

The client wanted a deals page. We created one to showcase promotions and guide shoppers to the best available offers.

Changing the Yahoo site

The client wanted rid of their old Yahoo site. We built a new store on Magento Enterprise version 2.3.3 and migrated them onto it.

/ Product screens

The delivered experience.

The interface people actually use.

Tools Retailer delivered interface, screen 1/01Home
Tools Retailer delivered interface, screen 2/02Catalog
Tools Retailer delivered interface, screen 3/03Product
Tools Retailer delivered interface, screen 4/04Deals
Tools Retailer delivered interface, screen 5/05PIM Sync

/ The results

What changed, in numbers.

Direct Database entry Brainvire created a script to enter product information directly into the database.
Definite Data structure The team built a definite structure for categories, products, attributes, attribute sets, and promotions.
Synced Product information The team fetched product information from the PIM through XML feeds into the Magento store.
New Magento site The development team delivered a new store for the client on Magento Enterprise version 2.3.3.

/ Next step

Ready for a redesign like this on your platform?

A 30-minute working session with a Brainvire architect: your current stack, your constraints, and where a rebuild actually pays off. No sales deck.

Book a Working Session →