Import component prices in bulk from Excel

When prices change for many components at once (a start-of-year list refresh, a supplier price update, a VAT change), editing one component at a time doesn't scale. Reonic gives you an Excel round-trip: export your catalog's current prices, edit the file in Excel or Google Sheets, upload it in the Import prices modal, check the preview and apply. Each change creates a new component version, so issued offers stay as they were. If your company has Photovate or Weclapp connected, the same modal pulls prices from there and skips the spreadsheet step.

Before you start

• You need the admin role or higher and the components permission. Below admin, the Excel drop zone in the modal is disabled. The Overwrite Prices user right covers price changes inside offers and planning and plays no part in this import.
• The import updates components you already have. A row that matches no component is listed as Unmatched and skipped. To add new components, import them from the master database or add them by hand first, then set their prices here.
• Decide what you're updating: sales price, VAT, purchase price, article number or GTIN. Those are the only fields the import touches. Technical specs, descriptions, documents and show-to-customer settings stay exactly as they were.
• Have Excel, Google Sheets, or a similar spreadsheet tool ready. The file format is .xlsx.

Export your current price list

1. Open Settings > Components.
2. Filter and sort the list if you only want to update some components. The export contains the list as it is currently filtered and sorted.
3. Open the More actions menu and choose Export prices.
4. Save the .xlsx file locally.

The exported file has one row per component, with the columns id, name, brand, articleNr, price, vatPercentage, purchasePrice and gtin. It is the exact template the import reads. id, name and brand are locked columns that identify each row. The purchasePrice column is filled in only if you have the view purchase price and margin right.

Edit the Excel file

Open the file in Excel or Google Sheets. The columns you may change are:

• price (sales price): the default unit price that planning pulls into an offer.
• purchasePrice (purchase price): what you pay your supplier.
• vatPercentage (VAT): VAT as a percentage. Enter 19 for 19%.
• articleNr (article number): your supplier's article number.
• gtin: the component's GTIN / EAN.

Save the file as .xlsx when you're done. The import reads the first sheet only. A hint in brackets after a header is ignored, so price (in EUR) still matches price.

Re-import the file

1. Open Settings > Components.
2. Open the More actions menu and choose Import prices. The modal opens.
3. Drop your edited .xlsx file on the drop zone. The preview runs at once.

If the file can't be read, the modal shows "Invalid excel file, no valid headers found", or "Invalid excel file, no data found" when the file has headers but no rows.

Review the preview and apply

The preview shows up to four sections, each only when it has entries:

• Faulty (n): rows with errors, shown in red. Expanded.
• Changed (n): rows that match a component and change at least one value. A row that clears a purchase price, article number or GTIN also counts here. Expanded.
• Unmatched (n): rows that match no component, with name, article number, GTIN/EAN and id. These are skipped. Collapsed.
• Unchanged (n): rows that match a component and change nothing. Collapsed.

Changed and Unchanged rows show Selling price, Purchase price, VAT, Article number and GTIN/EAN as old → new. A rise is tinted green, a drop red, and a newly added value blue. A missing value reads "no value", which is how a cleared purchase price, article number or GTIN shows up.

1. Check the Changed section, especially for values that turn into "no value".
2. If something looks wrong, click Back, fix your file and drop it again.
3. Click the apply button. It shows the number of changes and is disabled when nothing changed.
4. Confirm.

The changes are applied, the modal closes and the components list refreshes.

Sync prices from Photovate or Weclapp

If your company connects to Photovate or Weclapp, you can pull the latest prices directly instead of exporting to Excel:

1. Check that the integration is connected under Settings > Company settings > Integrations > Offers. For Photovate that's your Photovate client id plus an API key. Weclapp needs a connected Weclapp account and a default sales channel.
2. Open Settings > Components.
3. Open the More actions menu and choose Import prices.
4. Click Import prices from Photovate or Import prices from Weclapp. The Photovate button appears only when Photovate is connected. The Weclapp button is enabled when your company has Weclapp. The Photovate sync pages through your entire catalogue automatically.
5. Review the preview and apply, as described in Review the preview and apply.

How matching works

Reonic matches each row to one component in your catalog. The order depends on the source:

• Excel: component id first, then GTIN, then article number.
• Photovate: the Photovate article id is matched to the component's article number.
• Weclapp: article number.

A row that matches nothing lands in Unmatched and is skipped. If your supplier changed an article number upstream, the component no longer matches and shows under Unmatched. Fix the article number on the component first (a single edit), or match by id or GTIN in Excel, then re-run the import.

Things to know

• Each price change creates a new component version, attributed to you, the same as a manual edit. The component's Show edit history lists it.
• Issued offers never silently re-price. Each offer line item keeps its own price, VAT and component version, so a catalog change never rewrites an existing offer. Changing a price inside an offer changes only that offer's line item, so set lasting prices in the catalog.
• Bulk VAT changes for existing components go through Excel. The default VAT under Settings > Planning & offer > Planning > Standard components VAT applies only to newly created or imported components. Existing components change one by one or through the Excel import.
• Imported master components arrive with a sales price of 0. A price import right after a master-database import is the quick way to fill them in.
• The Unmatched section is your data-hygiene signal. A long Unmatched list usually means article numbers drifted between your supplier system and Reonic. Walking that list once a quarter keeps the import reliable.
• An empty cell clears the value for purchase price, article number, and GTIN. A missing column leaves a field untouched, but a present column with an empty cell blanks that field on the matched component. It's deliberate (it's how you remove a purchase price via import), but a half-filled spreadsheet can silently wipe data you meant to keep. Sales price and VAT are required and can't be cleared this way. Read the Changed section in the preview carefully before applying.

Last updated on November 9, 2026