Shopify
GARAN labels for Shopify
Shopify’s product export gives you a CSV with the vendor and SKU already in it. Add the guarantee duration, map three columns, and batch-generate all labels.
Export a product CSV from Shopify
Use the built-in export in the Products area of your admin.
-
1
In your Shopify admin, go to Products.
-
2
Click Export, then choose which products (all, current page, or a selection).
-
3
Select the plain CSV file option and export; you receive the CSV by download or email.
-
4
Open the file in a spreadsheet.
-
5
Keep the Vendor and SKU (or Handle) columns and add a duration column.
Match the columns to duration, brand and model
The Shopify export already contains the brand and a model identifier. Add the guarantee duration yourself.
| GARAN column | Where it comes from |
|---|---|
| duration | Not a standard Shopify column. Add a "duration" column with the guaranteed years (from a product metafield export, or typed in). |
| brand | The "Vendor" column. Rename it to "brand". |
| model | The "Variant SKU" or "Handle" column. Rename it to "model". |
Good to know
- The raw Shopify export has one row per variant; keep one row per product you want to label.
- If you track guarantee years in a metafield, include it in the export and rename it to "duration".
- Extra Shopify columns are fine; the generator ignores any column that is not duration, brand or model.
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
Prefer automation? Generate labels straight from your product data over the REST API instead of exporting a CSV.
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).