Magento / Adobe Commerce
GARAN labels for Magento
Magento’s built-in export produces a product CSV with SKU and manufacturer. Add the guarantee duration, map three columns, and batch-generate every label.
Export a product CSV from Magento
Use System → Data Transfer → Export in the Admin.
-
1
In the Admin, open System → Data Transfer → Export.
-
2
Set Entity Type to "Products" and Export File Format to "CSV".
-
3
Optionally filter the attributes or products you want to include.
-
4
Run the export and download the CSV.
-
5
Open it in a spreadsheet to prepare the three columns.
Match the columns to duration, brand and model
Magento exports the SKU and, if set, the manufacturer attribute. Add the guarantee duration.
| GARAN column | Where it comes from |
|---|---|
| duration | Not a default Magento attribute. Add a "duration" column with the guaranteed years (from a custom product attribute export, or typed in). |
| brand | The "manufacturer" attribute column. Rename it to "brand". |
| model | The "sku" column (or another model identifier). Rename it to "model". |
Good to know
- If you keep the guarantee years in a custom product attribute, include it in the export and rename it to "duration".
- Magento exports many columns; you only need three, and the generator ignores the rest.
- Large catalogues can be split into files of up to 500 rows each.
The CSV the generator expects
The generator reads a plain three-column file. Whatever your shop exports, the goal is a table with these columns.
- Three columns named duration, brand and model.
- A header row is optional. With one, the column order does not matter and any extra columns are ignored.
- Comma or semicolon separated, so German spreadsheet exports work as is.
- Guarantee duration greater than two years, whole or half years (for example 3 or 4.5, dot or comma).
- UTF-8 encoded, up to 500 rows per file.
| duration | brand | model |
|---|---|---|
| 5 | ACME | X-100 |
| 2.5 | Gizmo | Y-200 |
| 8 | Contoso | Z-300 |
A ready-made template CSV is available on the upload page once you are signed in.
Prefer to automate it? Use the API
On Adobe Commerce with frequent catalogue changes? Generate labels over the REST API from your product feed instead of manual CSV exports.
Other shop systems
At scale
Generate hundreds of labels automatically
A free account lets you generate GARAN labels in a batch or over the API, instead of one at a time. You only pay once you scale.
- Batch generation from a CSV, up to 500 rows per file, returned as a ZIP.
- REST API for your PIM, online shop, or build pipeline.
- All five formats and three variants from a single request.
- Saved library, billed once per unique label (prepaid or pay as you go).