Introduction
This article explains how to correctly configure the cost price update mode when importing products into TRAEDE. Depending on your choice, TRAEDE will either create new cost price sets or update existing ones — and optionally set a default.
Use this guide to understand which mode to choose based on whether you're adding, updating, or replacing cost prices.
Cost price update modes explained
When importing cost prices, you must specify a cost price update mode. This determines how TRAEDE should handle the cost price data for each product. Here's a breakdown of each available mode:
| Mode name | Creates new cost price set | Sets cost price set as default |
|---|---|---|
USE_DEFAULT_COST_PRICE_SET |
Only if none exists | ✅ Uses existing default |
CREATE_NEW_COST_PRICE_SET |
✅ Yes | ❌ No |
CREATE_NEW_COST_PRICE_SET_AND_SET_DEFAULT |
✅ Yes | ✅ Yes |
USE_COST_PRICE_SET_WITH_SAME_CURRENCY |
Only if none exists | ❌ No |
USE_COST_PRICE_SET_WITH_SAME_CURRENCY_AND_SET_DEFAULT |
Only if none exists | ✅ Yes |
Overview of when to use each mode
🟢 USE_DEFAULT_COST_PRICE_SET
Use this if:
-
You want to reuse the default cost price set already in TRAEDE
-
You only want to create a new cost price set if none exists
-
You want to avoid duplication
Best for simple updates where a default cost price already exists.
🟡 CREATE_NEW_COST_PRICE_SET
Use this if:
-
You want to always create a new cost price set
-
You don’t want to change the current default
Best for adding cost prices without affecting existing setups.
🟢 CREATE_NEW_COST_PRICE_SET_AND_SET_DEFAULT
Use this if:
-
You want to create a new cost price set
-
You want this new set to become the default
Best when you're doing a full cost price update and want your new prices to replace the existing default set.
🔵 USE_COST_PRICE_SET_WITH_SAME_CURRENCY
Use this if:
-
You want to reuse an existing cost price set that matches the currency
-
You want to avoid creating new sets unnecessarily
A good option if you maintain currency-specific pricing logic.
🔵 USE_COST_PRICE_SET_WITH_SAME_CURRENCY_AND_SET_DEFAULT
Use this if:
-
You want to reuse a matching currency cost price set
-
You also want to set it as the new default
Use this when you want to make a specific cost price set with matching currency the default for the product.
How to use in your import file
Add a column to your import sheet called:cost_price_update_mode
In each row, use one of the exact values from the table above based on your intent. For example:
| SKU | Item number | Cost price | cost_price_update_mode |
|---|---|---|---|
| 12345-BL-S | 12345 | 50 | CREATE_NEW_COST_PRICE_SET |
| 12345-BL-M | 12345 | 52 | CREATE_NEW_COST_PRICE_SET |
TRAEDE will handle each row according to the mode specified.