Bulk Editing Material Costs and Markups

💵 Bulk Editing Material Costs and Markups
 

Overview

Material costs fluctuate due to supplier changes, market conditions, or internal strategy. Ontraccr makes it easy to update pricing across multiple items at once using bulk edit tools — no spreadsheets or manual edits required.

This article covers how to apply mass updates to material cost and material markup.

🛠 How to Bulk Edit Material Costs

1. Go to the Materials Page.
2. Use checkboxes to select one or more materials.
3. From the action bar, click “Change Material Cost.”
4. Enter a dollar amount (e.g., “+1.00”).
5. Click Submit.

💡 What it does:

• Adds the specified amount to each selected item's current cost.
• Does not affect markup or sale price unless recalculated manually.

📌 Use Case: Material vendor increased prices by $1 across the board.

📈 How to Bulk Edit Material Markup

1. Select one or more materials.
2. Click “Change Material Markup.”
3. Enter a percentage (e.g., “10%”).
4. Click Submit.

💡 What it does:

• Increases the markup rate for each selected item by the specified percentage.
• Automatically recalculates the sale price.

📌 Use Case: Apply a 10% markup to all metal parts due to new tariffs.

🧠 Real Scenarios

• Vendor price hikes across multiple SKUs
• Strategic price increase for a category (e.g., seasonal or regional adjustment)
• Margin corrections during quarterly reviews