Bulk Material Replacement

Replace a Material Across Every Affected Record

Find every Recipe, Build, and Product that uses a Material, review the cost and conversion impact, and apply approved replacements without editing each record one at a time.

Review affected records before applying any change.

app.costfoundry.com
OriginalReplacementAffectedCost Impact

Bulk Material Replacement Overview

Original, replacement, affected records, conversions, and cost impact

costfoundry-bulk-material-replacement-overview.webp

One Material change can require dozens of manual updates

When a Material becomes unavailable, changes supplier, is reformulated, or needs to be replaced, it may appear across many Recipes, Builds, and Products.

Many Affected Records

The same Material may be used throughout the workspace across numerous Recipes, Builds, and Products.

Conversion Differences

The replacement may use a different unit, pack, density, or quantity than the original.

Cost Uncertainty

A replacement may increase or reduce Product Cost, and the impact is not always obvious.

Manual Editing Risk

Updating records one by one can create inconsistencies or missed replacements.

Review the full impact before making the swap

CostFoundry identifies affected records, compares the original and replacement Materials, validates units and conversions, and lets the user choose exactly where the replacement should be applied.

No replacement should be applied until the user reviews and confirms the change.

How Bulk Material Replacement works

1

Choose the Original Material

Select the Material that needs to be replaced.

2

Find Affected Records

Identify all linked Recipes, Builds, and Products.

3

Choose the Replacement

Select the new Material from the workspace.

4

Review Units and Conversions

Confirm quantity, unit compatibility, yield, density, or Material-specific conversions.

5

Compare Cost Impact

See how the replacement changes Batch Cost, Cost per Unit, and Product profitability.

6

Apply Selected Replacements

Choose the affected records and confirm the update.

Replace everywhere—or only where it makes sense

Users can select exactly which affected records should be updated, so a replacement is applied only where it makes sense for the business.

  • All affected records
  • Specific Recipes or Builds
  • Specific Products
  • Records using a certain unit
  • Records from a selected category
  • Records with no conversion warnings

A Product may be affected directly through a Material or indirectly through a linked Recipe or Build.

app.costfoundry.com
SelectReviewConfirm

Selective Replacement

Choose which records to update

costfoundry-material-replacement-selection.webp

Protect the calculation when the replacement is different

CostFoundry validates unit compatibility and flags issues before any replacement is applied. States are shown with both text and color so the status is always clear.

Compatible Units

LB to LB

Ready

Standard Conversion

OZ to LB

Ready

Material-Specific Conversion

Volume to weight using density

Review Needed

Incompatible Units

EA to GAL without a valid custom conversion

Blocking Issue

Yield Difference

The new Material may have a different usable yield

Review Needed

Pack Difference

Different purchase pack or case size

Review Needed

Replace Materials with control and traceability

Affected Record Search

Find linked Recipes, Builds, and Products that use the original Material.

Selective Application

Choose exactly which records should be updated.

Cost Comparison

Compare current and replacement cost side by side.

Conversion Validation

Verify standard, custom, and Material-specific conversions.

Yield Review

Account for differences in usable yield between Materials.

Quantity Adjustment

Update quantities when the replacement is not one-to-one.

Warning Review

Block replacements with unresolved calculation issues.

Change Summary

Show exactly what will change before confirmation.

Version Support

Create or preserve Version History when affected records are updated.

Audit Trail

Record who made the replacement and when, where supported.

Review one replacement across several Products

An industry-neutral example showing how replacing one Material affects multiple records and Product profitability.

Original Material
Standard Foam Insert
$0.84 per EA
Replacement Material
Recycled Foam Insert
$0.96 per EA+$0.12
Affected Records
Protective Packaging BuildShipping Case ProductPremium Installation Kit ProductRetail Sample Box Product
Premium Installation Kit
Original Cost/Unit
$31.20
New Cost/Unit
$31.56
Current Sale Price
$68.00
Gross Margin
54.1%53.6%

See every affected record before applying changes

Review the original Material's details, including supplier, pack size, and current Cost per Unit.

app.costfoundry.com

Original Material

CostFoundry interface preview

costfoundry-replacement-original-material.webp

Make large updates without losing control

Find every affected record

Reduce repetitive manual editing

Validate conversions before replacing

Compare cost and margin impact

Apply changes selectively

Preserve a clear update history

Bulk Material Replacement FAQ

CostFoundry searches the workspace for Recipes, Builds, and Products that use the selected Material. This includes Recipes and Builds that reference the Material directly and Products connected through those Recipes or Builds or that use the Material directly.

Ready to update Materials without editing every record?

Find affected Recipes, Builds, and Products, review conversions and cost impact, and apply approved replacements.