Too Many Product Variants? How SIX ERP Helps Manufacturers Deliver Choice Without Creating Chaos

Table of Contents

Give customers the options they want while keeping materials, production, quality, costing, and delivery dates under control.

“Customers see options. Your factory sees Bills of Materials, machine time, stock, quality rules, and delivery risk. A good ERP connects both views.”

Product variety can be a powerful sales advantage.

Customers want choice. They want the right size, color, material, finish, packaging, technical specification, firmware, label, accessory, and delivery option. In many industries, a standard product is no longer enough.

But more choice also creates more complexity.

A furniture manufacturer may offer one sofa in five fabrics, four leg designs, three sizes, two filling options, and several packaging choices. An industrial manufacturer may offer a machine with different motors, safety options, control panels, voltages, and customer-specific tests.

To the customer, this looks like one product with useful options.

Inside the factory, it can become hundreds or thousands of possible variants.

Without a connected ERP system, product variety quickly becomes production chaos.

Why Product Variants Create Hidden Costs

Many companies believe that variants increase revenue because they help win more orders.

That can be true. But variants also create hidden costs when they are not controlled.

Common problems include:

  • Sales teams promising options that are difficult or impossible to produce.
  • Engineers manually creating new specifications for every order.
  • Incorrect Bills of Materials.
  • Missing or outdated product drawings.
  • Material shortages caused by unexpected options.
  • Too many slow-moving components.
  • Incorrect pricing.
  • Confusing work instructions.
  • Production mistakes.
  • Quality failures.
  • Long changeovers.
  • Higher scrap and rework.
  • Late deliveries.
  • Margin loss that is discovered only after shipment.

The real problem is not variety itself.

The problem is offering variety without a system that can control it.

The Difference Between an Option, a Variant, and a Custom Product

Companies often use these words interchangeably, but they should be managed differently.

Product Option

An option is a controlled choice within a standard product.

For example:

  • Fabric color or type
  • Door handle.
  • Packaging type.
  • Label language.
  • Surface finish.
  • Standard accessory.
  • Power cable type.

The option is known in advance and follows approved business rules.

Product Variant

A variant is a defined version of a product created by combining approved options.

For example:

Three-seat sofa + grey fabric + oak legs + firm cushions.

or:

Industrial pump + 400V motor + stainless-steel housing + high-pressure seal.

Variants may have different materials, production times, prices, weights, quality requirements, and delivery times.

Configurable Product

A configurable product allows a salesperson, customer, or dealer to choose from a controlled set of options. The ERP uses configuration rules to create the correct product definition.

For example:

If the customer selects the 2.4-metre table, use table frame B.
If the customer selects outdoor use, use coating C.
If the customer selects high-voltage operation, add safety component D.

Custom or Engineered Product

A custom product goes beyond predefined rules. It may require new design work, engineering approval, a revised BOM, new drawings, new routing, testing, or special sourcing.

This is often described as Engineer-to-Order, or ETO.

The more a product moves from option to variant to custom engineering, the more control the business needs.

Why Excel Stops Working

Many manufacturers begin with a manageable number of products and variants. Excel works well enough at first.

Then the business grows.

A new customer asks for a different finish. Another customer needs new packaging. A retailer wants special labels. Sales offers a custom discount. Production changes a material. Purchasing finds an alternative supplier. Engineering updates a drawing.

Soon, the company has several versions of the truth:

  • One Excel file for pricing.
  • Another for BOMs.
  • A shared folder for drawings.
  • Email approvals for special options.
  • Printed work instructions on the factory floor.
  • Separate stock records in the warehouse.
  • An accounting system that only sees finished invoices.

At that point, the business is not managing products. It is managing exceptions.

Every new variant increases the chance that one department is working with outdated information.

ERP Turns Product Choice Into Controlled Production

A connected ERP system gives every department the same product logic.

Sales can configure the correct product. Purchasing sees the materials required. Planning sees capacity needs. Production receives the right instructions. Quality sees the correct test requirements. Finance sees the actual cost and margin.

The process becomes connected:

Customer choice → product configuration → Bill of Materials → routing → material planning → work order → quality checks → delivery → costing.

This is where SIX ERP creates value.

Instead of creating a different manual process for every variation, the company can define rules once and allow the system to apply them consistently.

Product Configuration Starts in Sales

The first control point is the sales process.

A salesperson should not be able to promise a product combination that engineering has not approved or production cannot deliver.

With SIX ERP, a configurable product can guide the sales user through approved choices.

For example, a furniture salesperson may choose:

  • Product model.
  • Size.
  • Material.
  • Colour.
  • Leg type.
  • Mattress type.
  • Packaging option.
  • Delivery market.
  • Optional accessories.

The system can then apply rules automatically.

For example:

  • A certain fabric may only be available for selected models.
  • A certain size may require a different frame.
  • A specific finish may increase production time.
  • Export packaging may be required for certain destinations.
  • A high-value material may require a higher deposit or longer delivery promise.
  • Certain combinations may need engineering approval.

The sales team receives freedom inside a safe framework.

Configurable Bills of Materials

The Bill of Materials, or BOM, is the product recipe.

For a simple product, the BOM may be fixed. Every unit uses the same materials.

For configurable products, the BOM must change according to the selected options.

A configurable BOM can define which materials, components, quantities, and sub-assemblies are needed for each variant.

For example:

Customer choice ERP effect
Larger table size Adds a longer frame, more surface material, and different packaging
Premium fabric Replaces standard fabric and updates cost
Outdoor version Adds weather-resistant coating and revised quality checks
Export market Adds export label, packaging, and documentation
High-voltage motor Adds the correct motor, safety component, cable, and testing step

This prevents one of the most expensive manufacturing mistakes: using the wrong materials because someone relied on an old spreadsheet or memory.

A correct configuration should create a correct BOM automatically.

Routings Must Change With the Product

The BOM shows what materials are needed. The routing shows how the product is made.

Different variants may require different operations.

For example, a standard product may need cutting, assembly, quality check, and packing. A premium variant may require additional coating, longer curing time, special testing, personalized labelling, or different packaging.

The ERP should adjust the routing based on the chosen configuration.

This helps planning teams understand:

  • Which machines are required.
  • How long each operation will take.
  • Which work centers may become bottlenecks.
  • Whether special tooling is needed.
  • Which quality checks apply.
  • Whether the product can meet the requested delivery date.

A variant is not only a different material list. It may be a different production process.

Pricing Must Reflect Real Complexity

A common mistake is to price a variant based only on material cost.

But a variant may also increase:

  • Setup time.
  • Labor time.
  • Machine time.
  • Quality-control effort.
  • Packaging cost.
  • Transport cost.
  • Warranty risk.
  • Engineering effort.
  • Inventory risk.
  • Supplier lead time.

For example, a customer may request a rare fabric or a special metal finish. The material cost may increase by only €20, but the product may require a separate production batch, special purchasing, a longer setup, and more quality control.

If the price only includes the material difference, the business may win the order and lose margin.

SIX ERP can support pricing that reflects the full product reality, including:

  • Base price.
  • Option price.
  • Material surcharge.
  • Labor and machine time.
  • Packaging cost.
  • Delivery-market cost.
  • Engineering fee.
  • Margin target.
  • Customer-specific discount.
  • Volume pricing.
  • Validity period.

A configurable product should also have configurable profitability.

Stock and Purchasing: Avoiding Variant Inventory Traps

Variants can create a major inventory problem.

If a company stocks every finished variation, it may quickly fill its warehouse with slow-moving products. If it holds too few materials, it may lose sales because it cannot produce the requested option quickly.

This is where Make-to-Order, Make-to-Stock, and hybrid planning become important.

Make-to-Stock for Common Parts

Common components can be produced or purchased for stock.

Examples include:

  • Standard frames.
  • Common housings.
  • Basic circuit boards.
  • Standard motors.
  • Standard fabrics.
  • Common packaging.
  • Shared accessories.

These materials support fast production and efficient purchasing.

Make-to-Order for Final Options

Customer-specific elements can be produced or added only after an order arrives.

Examples include:

  • Special colors.
  • Rare sizes.
  • Personalized labels.
  • Custom firmware.
  • Special coatings.
  • Unique packaging.
  • Customer-specific tests.

This reduces the risk of holding finished goods that may never sell.

Hybrid Planning

The strongest approach is often a hybrid.

The company keeps common sub-assemblies or base materials in stock, then completes final configuration after receiving the order.

This gives customers speed without forcing the business to stock every rare variant.

The Decoupling Point

The decoupling point is where the company changes from forecast-driven production to order-driven production.

Before the decoupling point, the company produces or purchases common items based on expected demand.

After the decoupling point, it completes the final customer-specific product only after receiving the order.

For example, a controller manufacturer may keep circuit boards, housings, and standard components in stock. When an order arrives, the company installs the required firmware, applies the correct label, completes the final test, and ships.

A furniture manufacturer may keep frames and standard components available, then apply the selected fabric, finish, packaging, and label after the customer order is confirmed.

The right decoupling point protects both lead time and inventory value.

Quality Control for Product Variants

Product variants can create quality problems when work instructions are unclear.

If operators do not know which version they are building, they may use the wrong material, label, test procedure, or packaging.

A connected ERP can ensure that the work order contains the correct information for that exact variant:

  • Product configuration.
  • BOM version.
  • Routing.
  • Drawings.
  • Digital work instructions.
  • Material list.
  • Approved substitutes.
  • Quality requirements.
  • Test limits.
  • Packaging instructions.
  • Customer-specific documentation.

The system can also record quality results against the correct production order, batch, or serial number.

The more variants a company offers, the more important it becomes to give operators one clear source of truth.

Traceability and Customer Service

Product variants also affect after-sales service.

When a customer reports an issue, the company must know exactly what was sold.

A service team may need to identify:

  • Product model.
  • Selected options.
  • Production date.
  • Serial number.
  • Material or component batch.
  • Firmware version.
  • Supplier information.
  • Warranty conditions.
  • Previous repairs.
  • Approved spare parts.

Without this information, service teams waste time searching through emails, old quotations, paper documents, and employee knowledge.

With SIX ERP, the customer record, sales order, product configuration, production history, warranty, and service records can be connected.

This improves:

  • Warranty handling.
  • Returns management.
  • Spare-parts selection.
  • Root-cause analysis.
  • Recall readiness.
  • Customer confidence.

A Practical Example: One Sofa, Hundreds of Variants

Imagine a furniture company selling one sofa model.

The customer can choose:

  • Two-seat, three-seat, or corner version.
  • Five fabric groups.
  • Twelve colors.
  • Two leg types.
  • Two cushion options.
  • Optional storage.
  • Standard or export packaging.

This creates hundreds of possible combinations.

Without ERP control, the business may need manual BOM changes, manual price calculations, separate drawings, and repeated questions between sales, engineering, production, and purchasing.

With a configurable product inside SIX ERP:

  • Sales selects approved customer options.
  • The system validates the combination.
  • The correct BOM is generated.
  • The correct routing is selected.
  • Material availability is checked.
  • The delivery date is calculated.
  • The correct price is applied.
  • The work order includes the correct fabric, frame, legs, cushions, labels, and packaging.
  • Quality receives the correct requirements.
  • Finance can see expected and actual margin.

The customer sees a customized sofa. The factory sees one controlled production process.

When Product Configuration Needs Engineering Approval

Not every customer request should become an automatic variant.

Some requests need engineering review.

Examples include:

  • A completely new size.
  • A structural change.
  • A new material.
  • A different load requirement.
  • A new safety feature.
  • A non-standard electrical configuration.
  • A special regulatory requirement.
  • A product combination not yet tested.
  • A request that may affect warranty conditions.

In these cases, SIX ERP can support a controlled approval process.

The sales user can create a request. Engineering reviews feasibility. Purchasing checks material availability. Production checks capacity. Finance reviews cost. Management approves pricing or commercial terms if needed.

Once approved, the new version can become part of the controlled product catalogue.

Good configuration gives sales speed. Good approval protects the business from uncontrolled complexity.

How to Reduce Variant Complexity

The answer is not always to offer fewer options.

The better answer is to manage options intelligently.

Manufacturers should review:

  • Which variants sell often.
  • Which options create the strongest margins.
  • Which combinations cause delays.
  • Which materials create stock risk.
  • Which variants generate quality issues.
  • Which products need too much manual engineering.
  • Which options are rarely sold.
  • Which variants create excessive changeovers.
  • Which options can share common components.
  • Which variants should become Make-to-Order.

This allows companies to simplify the product range without reducing customer value.

For example, a company may keep the most popular colors in stock but make rare colors only to order. It may standardize common sub-assemblies while keeping final finishing flexible. It may remove options that create frequent quality issues but little revenue.

The best product portfolio is not the one with the most options. It is the one with the best balance of customer value, operational control, and margin.

How SIX ERP Supports Variant Management

SIX ERP helps manufacturers manage product variety across the full business process.

The platform can support:

  • Configurable products and approved options.
  • Product variants and version control.
  • Bills of Materials.
  • Configurable routings.
  • Sales quotations and order validation.
  • Customer-specific pricing.
  • Inventory and material availability checks.
  • Make-to-Order, Make-to-Stock, and hybrid planning.
  • Work orders and digital manufacturing instructions.
  • Quality checks and certificates.
  • Batch, lot, and serial-number traceability.
  • Supplier and purchasing management.
  • Costing and margin analysis.
  • Warranty, service, returns, and spare parts.
  • Approval workflows and audit trails.

The result is a business that can offer variety without losing control.

Start With One Product Family

Do not try to configure every product at once.

Choose one important product family. Map the current options, BOMs, routings, prices, materials, and quality rules. Identify which combinations are standard, which need approval, and which create the most problems.

Then build the configuration rules inside SIX ERP.

Start with the variants that create the most sales, the most margin, or the most operational complexity. Test the process with sales, planning, production, quality, purchasing, and finance.

Once one product family works correctly, the model can be repeated across the business.

Product Choice Should Create Revenue—Not Chaos

Customers will continue to expect more choice.

The manufacturers that succeed will not be the ones that refuse variety. They will be the ones that turn variety into a controlled, profitable process.

With the right ERP foundation, every approved option can become a correct price, a correct BOM, a realistic delivery date, a clear work order, and a traceable finished product.

SIX ERP helps manufacturers deliver customer choice with factory control.

Read the full IDC solution brief

Get the full story in The Business Value of SIX Build for SIX Cloud ERP Customers.

Dr. Andreas Maier

Thinker, Problem Solver, Mentor, Dancer, and in my spare time Entrepreneur and Blogger.

Explore related content