Skip to content
Last updated

Importing product price allows you to efficiently update prices and related data in bulk. There are two main import types, each suited for different scenarios.

Import types

Import typeDescription
ProductImports one price list per product, along with other product data. Best for updating products with complex data.
Product pricesImports multiple price lists and prices for the same product, supports multiple currencies.

Note: Product import only supports one price list per product. Use product prices import to update several price lists at once.

Prices with VAT

The Product prices import does not support prices including VAT, but accepts price fields with up to 4 decimal places. To import VAT-inclusive prices, first convert to VAT-exclusive, round to 4 decimals, and then import.

Required columns

ColumnDescription
PartNoProduct number. Unique together with PriceListCode.
PriceListCodeIdentifier for the price list. Unique together with PartNo.
PriceSaleSale price. If included, sets price rule to "fixed price" and ignores PriceRule.
PriceRecommendedRecommended price.
PriceCatalogCatalog price.
PricePreviousPrevious price. Not used anymore.
PriceRuleOverrides price list rules for the product. Ignored if PriceSale is included.
CostPurchasePurchase cost.
CostUnitInventory value.
CurrencyCodeCurrency for the row. Must be the currency set on the price list. When left out, the import will ask for currency
IsPriceDiscountableFlags the price as discountable by promotion functionality.
PriceIsActiveIndicates if the price is active. When exporting, the column is named IsActive and must be mapped manually.

Note: You cannot have different currencies for different fields in the same row.

Handling duplicates

If two rows with the same price list and different fields are imported, Norce cannot determine which update will win. Updates are asynchronous, so in large files, duplicates may not be detected and the last update may win (which can be any of them).

Tip: Use Excels built in functionality to check for duplicates.

Common import examples

ExampleDescription
PartNo, PriceListCode, PriceSaleSimple import, import sale price (currency selected during import).
PartNo, PriceListCode, CostUnitImport cost for later use in price list cost price rule.
PartNo, PriceListCode, PriceRule, PriceRecommendedUse recommended price rule and pass in recommended price.