How do I import and export energy labels as CSV?
Energy labels > Labels > Export CSV downloads every label. Import CSV adds and updates labels from the same format.
Columns
| Column | Import |
|---|---|
product_id |
The product’s ID, or leave empty and use product_handle |
product_handle |
The product’s handle, used when product_id is empty |
variant_id |
Optional. A variant of the product; empty means the whole product |
product_title, variant_title |
Ignored, for reading only |
source |
Optional. eprel or manual; the export fills it in |
eprel_registration_number |
The EPREL number or link. Either this or energy_class is needed |
energy_class |
For a label entered by hand, for example B or A++ |
scale |
A_G, APPP_D (A+++ to D), APP_E (A++ to E), AP_F (A+ to F) or A_E |
label_image_url, label_pdf_url, pis_url |
Full https:// links, for labels entered by hand |
missing |
Ignored, the export lists what each label lacks |
A row with a registration number becomes an EPREL label and is read from EPREL after the import, unless its source is manual: then it stays a label entered by hand and keeps the number for reference. A row without a number becomes a label entered by hand. An exported file imports back unchanged. An EPREL label keeps the scale you chose for it in the app.
Import
- Click Import CSV and pick the file (up to 2 MB and 2,000 rows).
- The app checks the file first and shows how many labels are new and how many are updated. Rows that need a fix are listed with their line number and the reason; nothing is imported until every row is valid.
- Click Import.
If the products changed between the check and the import, choose the file again.