Import & export

Four jobs live here, all of them CSV:

1. Export claims – download every claim you've logged, for your records.
2. Import claims – bring claims over from another system.
3. Import repairability data – maintain the product page info for many products at once instead of one by one.
4. Export repairability data – download what you've maintained, edit it and import it back.

CSV basics

All CSV files of this extension follow the same rules:

Spreadsheet programs like Excel or LibreOffice Calc open and save CSV files. When saving, make sure you pick the "CSV (UTF-8)" format with semicolon as the separator.

Export claims

Step 1: Open Orders → Claims in the admin.

Step 2: Click Claims in the top right.

Step 3: Click Export CSV.

Step 4: Your browser downloads the file. The filename contains today's date, for example viove-repair-compliance-claims-2026-06-22.csv.

The file contains all claims, not just the ones currently filtered – good as a record or for analysis in a spreadsheet.

The columns of the export

The export file has these columns, in this order. It doubles as the basis for the claims import, so you can export, edit and import back (a round trip):

orderNumber;lineItemLabel;status;remedyChoice;eligible;reportedAt;infoProvidedAt;remedyChosenAt;repairCompletedAt;warrantyUntil;warrantyExtendedUntil;extensionApplied;comment;customerComment;affectedQuantity

Import claims

Use this to bring claims over from another system – your previous service software, for example. The import sits on the overview page of the module in the card Import claims (CSV).

Step 1 – Download the template. In the card Import claims (CSV), click Download template. You get a CSV with the correct header row.

Step 2 – Fill it in. One row per claim. Only the order number is mandatory; everything else is optional.

Step 3 – Pick your file. Select your filled-in file under CSV file.

Step 4 – Do a dry run (recommended). Tick Dry run (save nothing) first and click Import. The file is only checked, nothing is stored.

Step 5 – Read the error report. Below you get a result message and, if needed, a Rows with errors table with Row, Error type and Message. Fix those rows in your CSV (see the error table below).

Step 6 – Run the real import. Once the dry run is clean, untick Dry run and click Import again. Now the claims are actually created or updated.

After the import you get a message like "Import finished: 5 created, 2 updated, 1 skipped." In a dry run it reads "Dry run finished: 5 would be created, 2 updated, 1 skipped. Nothing was saved."

How the right order and line item are found

Every row has to be matched to a line item:

• The order is found by its order number (column orderNumber).
• The line item within that order is looked up in this order:
  1. Product number (productNumber) – checked first and the most reliable.
  2. Line item label (lineItemLabel) – if no product number is given.
  3. Position index (positionIndex, counted from 1) – when an order has several matching line items and only this tells them apart.

If several line items match and there's no unambiguous position index, the row is reported as ambiguous.

What happens if you import twice?

The import is built so you can repeat it safely. If a claim already exists for a line item, it is updated rather than created a second time. So re-importing the same file never produces duplicates. You'll see it in the number behind updated.

The columns of the claims import file

The import file has the same columns as the export plus two extra ones at the end for resolving the line item:

Error messages and how to fix them

Import repairability data

This is how you maintain the EmpCo product info – repairability score, spare-parts details, manufacturer repair page and so on – for many products at once. The import sits on the overview page of the module in the card Import repairability data (CSV).

Step 1: In the card Import repairability data (CSV), click Download template.

Step 2: Fill it in – one row per product. Only the product number is mandatory.

Step 3: Pick your file under CSV file and click Import.

Step 4: You get the message "Import finished: … imported, … skipped." Any errors are listed under Import errors.

The imported values land as custom fields directly on the products and – if enabled – appear on the product page. See Product page (EmpCo).

The columns of the repairability import file

Recommended values for repairabilitySource: manufacturer, french_repairability_index, eu_energy_label, own_assessment, other.

Allowed values for annex2Group: washing_machine, washer_dryer, tumble_dryer, dishwasher, refrigerating_appliance, electronic_display, welding_equipment, vacuum_cleaner, server_data_storage, mobile_phone, cordless_phone, tablet, light_transport_battery.

Error messages and how to fix them

Export repairability data

Download a CSV of everything you've maintained – handy for editing in a spreadsheet and importing back (export → edit → import):

Step 1: In the admin, open Orders → Claims → Data & import.

Step 2: In the Repairability data (EmpCo) card, click Export product data.

Step 3: Your browser downloads the file. The filename contains today's date, for example empco-product-data-2026-06-22.csv.

The export contains every product that has at least one EmpCo field maintained, in the same column order as the import:

productNumber;repairabilityScore;repairabilityScale;repairabilitySource;sparePartsInfo;manufacturerRepairUrl;warrantyInfo;annex2Group

As with the import, the repairability label image isn't included – it can't be represented as text.

Where the templates live

Both templates come from the Download template button in their respective card on the overview page of the module:

• Claims template – in the card Import claims (CSV).
• Repairability data template – in the card Import repairability data (CSV).