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 type | Description |
---|---|
Product | Imports one price list per product, along with other product data. Best for updating products with complex data. |
Product prices | Imports 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.
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.
Column | Description |
---|---|
PartNo | Product number. Unique together with PriceListCode. |
PriceListCode | Identifier for the price list. Unique together with PartNo. |
PriceSale | Sale price. If included, sets price rule to "fixed price" and ignores PriceRule. |
PriceRecommended | Recommended price. |
PriceCatalog | Catalog price. |
PricePrevious | Previous price. Not used anymore. |
PriceRule | Overrides price list rules for the product. Ignored if PriceSale is included. |
CostPurchase | Purchase cost. |
CostUnit | Inventory value. |
CurrencyCode | Currency for the row. Must be the currency set on the price list. When left out, the import will ask for currency |
IsPriceDiscountable | Flags the price as discountable by promotion functionality. |
PriceIsActive | Indicates 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.
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.
Example | Description |
---|---|
PartNo, PriceListCode, PriceSale | Simple import, import sale price (currency selected during import). |
PartNo, PriceListCode, CostUnit | Import cost for later use in price list cost price rule. |
PartNo, PriceListCode, PriceRule, PriceRecommended | Use recommended price rule and pass in recommended price. |