How to update or create cost prices via import

  • Updated

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.

Was this article helpful?

0 out of 0 found this helpful