Furniture collection and product data management system

The product team handles furniture models, dimensions, materials and sets. The same information is used in catalogs and offers, and sales data helps to view collections.

Models, materials, colors, dimensions, images, packaging and codes are stored in different files or supplier systems. The catalog shows inaccurate data of models, materials or sets, suggestions are prepared slowly, and errors move to the order.

How the solution works

  1. The supplier's information is linked to the collection, model and exact set-up.
  2. Responsible employees check possible combinations, images, documents and packaging composition.
  3. Confirmed information is transmitted to sales and logistics channels and its reception is verified.
  4. The sales, balances, returns and other facts available are reported under the same product codes.
  5. The collection manager reviews the result and transmits an approved assortment or addition decision to the process that follows it.

Key challenges

  • Data on collections, models, materials and sets disaggregated
  • Packaging and gauge data insufficient
  • Results of collections and sets are seen too late

Solution capabilities

Collection and kit data

Defined models, materials and permitted combinations are linked to specific codes and appropriate images.

Description of the packages and set

Packages, dimensions, weight and transportation-related restrictions are indicated next to the set sold.

Approved version of publication

The channel receives verified product information; missing or conflicting data remains for review.

Collection sales results

Sales, discounts, returns and stocks are compared to specific products in the collection. Linked customer requests help to assess what they were interested in and what they did not ultimately buy.

Transfer of the commercial decision

The range change or replenishment need confirmed during the review is passed on to the team responsible for it, preserving the date of the data used.

Business context

Data on collections, models, materials and sets disaggregated
Models, materials, colors, dimensions, images, packaging and codes are stored in different files or supplier systems. The catalog shows inaccurate data of models, materials or sets, suggestions are prepared slowly, and errors move to the order.
Packaging and gauge data insufficient
The furniture or interior goods lack reliable packaging dimensions, weight and a list of parts of the set. The seller is not always able to check the transportation and unloading conditions. The delivery price is calculated inaccurately, and the chosen transport or method of unloading may not be suitable. Additional costs and new arrival time must be combined after the order has been accepted.
Results of collections and sets are seen too late
Sales, sample orders, requests, balances, discounts and returns data are analysed separately. Weak collections or sets are stopped too late, and marketable positions are added late.
The product is more easily delivered to the final buyer
The retailer needs a description of reliable photos, dimensions and materials to offer the furniture to their customer. The data in the prepared collection shortens the time from receiving the news to presenting it to trading. The exact set-up and packaging also allow for a prior explanation of the delivery conditions.

Core features

  • Collection and kit data
  • Description of the packages and set
  • Approved version of publication
  • Collection sales results
  • Transfer of the commercial decision

Key integrations

Enterprise resource planning system (ERP)
Product codes, prices and order connection.
Supplier Data Sources
Collections, configurations, terms and technical information.
Business customer portal
A catalogue is published for partners.
Warehouse Management System (WMS) / Logistics
Packaging and Completeness Data.
Sales and Stock Reporting Facility
Link sales, discounts, returns and residuals facts for collection review.
Customer relationship management system (CRM)
Product-linked queries and the submission of samples where such data are recorded reliably.

Potential impact (%)

The ranges indicate an illustrative relative change in the metric under the stated assumptions. Results depend on the starting position and actual use of the solution. Percentages for different metrics must not be added together.

Part of products repaired due to a published kit or packaging error

12–42%Decreasing

This illustrative scenario assumes that 30-60% of errors can be addressed through the data and rule checks described. That share is assumed to fall by 40-70%. Company data is needed to verify both the addressable share and the resulting change.

A confirmed set-up or packaging error results in a number of repaired products divided by all products published in the same sample of channels and multiplied by 100.

Active time to prepare collection review data

12–36%Decreasing

This illustrative scenario assumes that 30-60% of manual data entry and handover work can be addressed. That share is assumed to fall by 40-60%. Company data is needed to verify both the addressable workload and the resulting change.

The timing of preparation of the report and interpretation of discrepancies is compared, while specifying what part of the collection the data includes.

Part of the collection positions that added to the range of partners

5–18%Increasing

Sample starting part - 40%. Assumption: 15-30% of the remaining cases involve insufficient collection information; a solution would help resolve 20-40% of these cases.

The positions included in the range are divided by all the positions of the collection presented to that partner. Individually, positions not included due to lack of information are marked.

Conditional calculation scenarios. The assumptions have not been validated against client measurements.

When this solution is relevant

  • Sets are checked in multiple files
  • Images not linked to a specific commodity code
  • New collections are being prepared for partners for a long time
  • Lack of packaging data for logistics
  • Planned B2B Portal or other digital channel
  • Collection sales and balances are difficult to relate to specific sets

Implementation requirements

Collection data requires a harmonised structure of models, materials, packaging and channel code, and publication responsibilities. The available reporting tool separately assesses how to link these data to sales and balances; catalog maintenance does not have to create competing stock accounting.

Further development options

  • History of Collection Review Decisions
  • Verification of accepted versions of the directory by partners

Frequently asked questions

Adapting the solution to your business