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.
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 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).