How to Cut the Cost of Keeping Marketplace Product Data Up to Date Using ESB

How Enterprise Service Bus (ESB) helps reduce business costs through automated data exchange and system integration

  • How routine manual operations make it harder to enter new marketplaces and more difficult to work with existing ones
  • How Polaris optimized marketplace operations with two implementations
  • Step one: organizing data with a PIM system
  • Step two: automating data transfer to marketplaces

About the Article

  1. Published: 29.5.2023 Reading time: 6 min. We explain how to reduce marketplace operating costs and improve information accuracy using IT tools, and we also look at these tools in a KT.Team client case.

  2. According to research by Data Insight, almost all online shoppers, more than 60% of Russians, prefer marketplaces for making purchases.

  3. Marketplace advantages include price levels, breadth of assortment, convenient order pickup, delivery speed, and more.

  4. However, each new platform is not only a new opportunity for a manufacturer and seller, but also additional costs: studying the platform documentation, extra integrations, constant monitoring of marketplace policy changes, keeping information up to date, and so on. In this article

  5. Andrey Putin, Managing Partner at KT.Team, explains how to cut marketplace operating costs and improve data accuracy with IT tools.

  6. We examine the use of these tools through the case of KT.Team client Polaris, a home appliance manufacturer.

How routine manual operations make it harder to enter new marketplaces and more difficult to work with existing ones

Let us set aside the purely legal side of contract signing and focus on the technical aspect of cooperation. The minimum required from the seller is to fill out the product card correctly and provide media files in the proper formats and sizes, assuming that all logistics questions are handled by the marketplace. The maximum is that you will need to set up integrations between your systems and the marketplace’s systems to send them information about current prices, stock levels, and delivery terms.

It looks like an expensive but still one-time effort. In reality...

Sources of recurring manual work when working with marketplaces

Product characteristics may change. For example, in 10 tea sets you might replace tieguanyin with luin lo.

You will have to update the descriptions and listings for these bundles, upload new media files, attach new instructions, adjust prices, and so on. The marketplace may also change its requirements for product listings or media files. For example, instead of 3:4 images, it may now require only 1:1 images.

Or product dimensions must be entered not in one general field, but in three separate ones for length, width, and height.

You would have to manually review every product card and check it against the new standards. The systems responsible for some aspect of marketplace operations may change or be updated. For example, the WMS system may be updated, and the related integrations will have to be fixed.

While integrations are being refined and debugged, stock information on the marketplace will be inaccurate. The marketplace itself may change or update its systems, and you will have to adjust the integrations again.

A mass of routine manual tasks

And their number grows in proportion to how many marketplaces you list your product assortment on.

The task becomes even more expensive if your digital assets and product marketing data are stored in a decentralized way.

Client: Polaris and the task of optimizing marketplace operations

Polaris is a Swiss home appliance brand

The company’s active catalog includes more than 700 items (the assortment exceeds 1,000 SKUs). Polaris ranks among the top names in CIS’s popularity rating in the small home appliance segment.

The brand's products are sold through retail chains, its own online store, and on four marketplaces: OZON, Yandex Market, Wildberries, and AliExpress.

Before Polaris turned to KT.Team for an IT solution, the data was entered manually through marketplace seller accounts. For each platform, the product manager filled out the listing information according to the standards set by that specific marketplace, then the marketplace manager checked the submitted data and entered it.

Each marketplace needed its own team.

All information was stored in 1C in five formats: for its own online store and for four marketplaces.

As a result, 1C became overcomplicated, overloaded, and was performing PIM system functions that were not its own.

Assess where AI can deliver impact in your process

Step one: organizing data with a PIM system

Imagine that the residents of five neighboring apartments give different descriptions of a birch tree, for example.

Some say it has green leaves, others say emerald ones.

Some specify height in meters, others in centimeters.

All these descriptions are consistent, but none of them can be called a source of truth.

The same was true of Polaris product data at the start of the project: there were at least five parallel versions of information for each product.

None of the options was a source of truth, so all changes were made in parallel by five content managers based on five inputs from product managers.

To reduce the number of manual operations, the first step was to create a single repository for the golden source of product information. We chose the Pimcore PIM system for this purpose.

Each product in Pimcore now has only one, but the most complete, listing.

This is where all product details are stored, from color and dimensions to package contents and technical specifications.

A product card is a master record.

It contains both universal fields required across all sales channels and unique fields whose data is needed only for Wildberries, Yandex Market, or some other marketplace. For example, multicooker control options for a product card on OZON are described using four fields, while on Wildberries only one is needed.

In substance, these records do not conflict, but each one meets the requirements of its own marketplace.

A separate set of attributes is created inside the PIM system for each marketplace.

These are child cards within the master record

A specific marketplace’s content manager works not with the full set of product information, but only with the data for their own sales channel.

It also checks, enriches, and validates the information for compliance with requirements.

Step two: automating data transfer to marketplaces through ESB

By implementing a PIM system, we eliminated the problem of multiple sources of truth.

But even from a single source, the information still has to get to marketplaces somehow. And the “Ctrl + C, Ctrl + V” option still did not look optimal: it was too time-consuming and prone to errors.

That is why the KT.Team team suggested that Polaris set up product data transfer to marketplaces through a middleware system, ESB.

Why did we not suggest direct integration?

At first glance, building a direct integration between systems takes not much more time than developing in an ESB graphical studio.

The same applies to designing the logic, converting the information into the required format, and mapping it to the correct fields.

But in the long run, maintaining direct integrations is more labor-intensive.

Any change in the requirements, structure, or code of connected systems triggers lengthy refactoring. ESB has an advantage, first of all, during development.

Mature ESB products such as WSO2 use a graphical interface for building integrations. They already include ready-made connectors to IT systems and modules for converting information into various formats.

In addition, ESB systems include built-in and pluggable monitoring services that track whether information was delivered to the right destination and, if not, at which stage the error occurred. Second, during support, WSO2, like other ESBs, helps save developers' time and respond to changes faster. For example, if the recipient system’s requirements change, the ESB team only needs to update the marketplace connector.

The logic of all the other integration components does not need to be changed.

How integration through WSO2 ESB works

We built integrations between the Polaris PIM system and marketplaces through an ESB layer. The WSO2 system pulls product information from the PIM; if needed, it converts it into the format required by the marketplace; and according to the mapping rules, it distributes the information from the product listing fields in the PIM into the product listing fields on the marketplace.

Bonus: lower integration costs

  1. Implementing an ESB system means not only less manual work for content managers today, but also more transparent and cost-effective work with sales channels tomorrow.

  2. If a product attribute changes on the Polaris side, the content manager only needs to update it in the PIM system. ESB will take the updated information, deliver it to the marketplace, and distribute it across the product listing fields.

  3. If the product listing structure or the system itself changes on the marketplace side, developers will not need to rewrite hundreds of lines of code. In the ESB graphical interface, it will be enough to adjust one or two blocks and replace the connector.

  4. According to KT.Team’s experience, the time savings are at least fourfold.

  5. If Polaris decides to sell products on another marketplace or online store, the IT team will be able to build a new integration easily by reusing the logic of the existing integrations in WSO2.

As of 2023

  1. Polaris has now moved to a stage of independent work with the ESB and technical support.

  2. Key managers were trained to work with the new systems.

  3. New product categories are published on marketplaces through the PIM system and service bus.

  4. All changes to product attributes appear automatically on marketplaces within a few hours after publication in the PIM.

Discuss the article: How to reduce maintenance costs...

Send via: