WooCommerce
GARAN labels for WooCommerce
WooCommerce ships a product CSV exporter. Export your catalogue, add the guarantee duration, and generate every GARAN label in one batch.
Last updated July 24, 2026
Export a product CSV from WooCommerce
The exporter lives in the Products area of wp-admin.
-
1
In the WordPress admin, go to Products → All Products.
-
2
Click "Export" at the top of the product list.
-
3
Choose the columns to export (or all of them) and export the CSV.
-
4
Open the downloaded file in a spreadsheet.
-
5
Keep the SKU and your brand column and add a duration column.
Match the columns to duration, brand and model
WooCommerce exports the SKU natively. Brand comes from your brand attribute; the duration is added by you.
| GARAN column | Where it comes from |
|---|---|
| duration | Not a native WooCommerce field. Add a "duration" column with the guaranteed years (from a custom field/attribute export, or typed in). |
| brand | Your brand attribute column (for example a "pa_brand" attribute). Rename it to "brand". |
| model | The "SKU" column. Rename it to "model". |
Good to know
- Core WooCommerce has no dedicated brand field; if you use a brand attribute, include that column and rename it to "brand".
- Variable products export as several rows; keep the rows you actually want a label for.
- The export is UTF-8; the generator strips the byte-order mark automatically.
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
Automating with WordPress? Generate labels over the REST API from your product data instead of exporting a CSV by hand.
Other shops & marketplaces
Free account
Unlock PDF, WebP and your label library
A free account adds PDF and WebP and saves every label you make to a personal library. It also lets you scale with batch CSV or the API, with 5 trial credits to start.
- PDF and WebP formats, on top of the free SVG, PNG and JPG.
- A saved label library: re-download anything you have made, any format or variant, free.
- 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, with 5 trial credits to start.