The Pickler Product Data Template is designed to help you create new products, update existing ones, and manage product data in bulk. It complements the Product Form inside Pickler and the Pickler API, and contains the full dataset of all primary product data you can supply.
Because the template includes all available data fields, it can look extensive. This guide explains how it works, what every tab means, and how to use color coding to focus only on what matters most.
Understanding the Color Codes for Footprint Data Entry
Every column header in the template includes a color code to guide you:
🔴 Red — Mandatory
Required to create a product and provide minimal footprint data.🟠 Orange — Important primary data
Strongly improves footprint accuracy, but can be temporarily replaced with Pickler’s conservative default values.🟡 Yellow — Additional primary data
Not required for a footprint calculation, but improves representativeness and data quality.
Tip: Start with red and orange columns. You can always enrich your dataset later.
What to use the template for
1. Creating New Products
Always add new products in the Product General Data tab.
Formulas automatically pull products into the other tabs.To create a product in Pickler, an ID is mandatory.
2. Updating Existing Products
You may freely edit existing products — except the ID, which cannot be changed.
When uploading updates:
Empty cells do not overwrite existing data in Pickler.
Only filled-in data replaces what is already in your account.
3. Deleting Products
Deleting products is not possible through the template.
Delete products directly from your Pickler account instead.
Do not delete rows in the template—just leave unwanted products untouched. Importing them won’t change anything unless you edit data.
4. Deleting Tabs
Not recommended, but allowed.
Tabs you delete simply won’t import, and your existing products stay unchanged.
It’s usually easier to ignore the tabs you don’t need rather than removing them.
Uploading Your File Into Pickler
Log in to Pickler.
Ensure you have Manager or Owner permissions.
Navigate to the Import Page.
Upload your completed Excel file.
After uploading, Pickler shows you a validation summary so you can check for errors before confirming the import.
Tab-by-Tab Explanation & Best Practices
1. Product General Data
This is the core of your product information.
It includes:
Product ID (mandatory to create products)
Product status (draft/live)
Scenarios (e.g., dummy products)
Whether to automatically fill data gaps with Pickler default values
Best practice:
Start here every time. New products must always be added in this tab.
2. Product Components (1–6)
A component is a part of your product manufactured or processed independently at a unique location—for example, a separate lid.
For each component, you can add:
Materials
Processing details (location and method)
Optional primary data on energy mix and energy use
Best practice:
Use components only when your product truly consists of different parts from different production steps.
For most packaging products, components are not needed.
3. Pack, Case, and Pallet
These tabs describe secondary and tertiary packaging used to distribute your product, such as:
Polybags
Transport cases
Pallets and pallet wrap
They work the same way as materials and processing tabs.
Best practice:
Go for a simple description of the main materials.
The impact of additional packaging is often negligible compared to the main product, so investing time in precise details usually isn’t necessary.
4. Transport Legs
Transport legs describe the distance between production steps and the final destination.
What you need:
Distance travelled
Transport method
You may split steps by A → B → C for traceability, but for footprint calculations the total distance per transport method is what matters.
You can choose between:
Automatic distance calculation (Pickler suggests the distance—validation recommended)
Manual entry (you enter the distance yourself)
Optional fields:
Pallet width, length, height, and gross weight
→ These allow Pickler to determine whether your shipment is weight-based or volume-based.
5. End of Life
Defines how your product is discarded, including:
End-of-life region
Percentage of your product that ends up in this region
Best practice:
If unsure, select:
Region: Europe
Share: 100%
⚠️ Important:
Enable custom end-of-life scenarios only with verified data.
Assumptions such as “recyclable” without evidence of real recycling can be considered greenwashing.