Data introduction and preparation
To start with Pickler, you need to import product data to enable calculations. This is often a tough challenge, since you might not have all the data in place.
In this article, you will learn:
What data is needed?
Do I need all data to start?
What data should I focus on?
How accurate should the data be?
Where can I get this data?
What data is needed?
Pickler is designed to enable you to start small. Start with collecting data first that’s most important, often data from products that are sold most.
1.Prepare and collect your data
Now that you know what kind of data Pickler needs, it's time to collect.
What primary data is needed to get started?
What product data are we talking about to enable calculations?
Materials and the composition
Production locations
Warehouse locations
Where to find this data?
You probably already have most of this data in your ERP, whether it’s in your product specifications or procurement records. For missing details, you may need to reach out to suppliers for more specific information.
How Pickler helps if you dont have this data?
If you don’t have all the data at first, don’t worry—Pickler uses placeholder values to fill in the gaps. These placeholders are based on worst-case scenarios, ensuring that your sustainability claims remain transparent and realistic. As you gather more detailed data, you can update these placeholders with more accurate values.
Best Practice: Start Small
It’s important not to overwhelm yourself by trying to gather every piece of data at once. Start with your most critical products or those with the highest sales volumes. As you gain confidence in using Pickler, you can expand your data collection efforts to cover more products.
Effortless data entry
Pickler is built for packaging. So its easy to move data from your data sources to Pickler. This can be done via form, spreadsheet or API. Example why built for packaging: we adapt to data structure that is also used in GS1.
Data can be entered using our form, spreadsheet template and API.
Mapping your data
Once your data is in Pickler, calculations cant be done yet. Thats why the data needs to be mapped.
In Pickler, you’ll provide product data (primary data). This data is improted to Pickler, where it needs to be mapped LCI data.
1. What data do I need to use Pickler?
Before diving into Pickler, you’ll need to gather and organize your primary data—specific information about your products and their lifecycle. This data will be used to calculate your environmental impact. Some primary data is likely easy to collect, while other details may be more challenging or require outreach to suppliers.
Preparing Your Data
Before diving into Pickler, you’ll need to prepare your data. This includes collecting essential details about your products, such as:
Materials: What is your packaging made of?
Production: Where and how is it produced?
Transport: How does it get to your customers?
End-of-Life: What happens to it after use?
Best Practice: Start Small
It’s important not to overwhelm yourself by trying to gather every piece of data at once. Start with your most critical products or those with the highest sales volumes. As you gain confidence in using Pickler, you can expand your data collection efforts to cover more products.
2. How do I enter data in to Pickler?
Once your data is prepared, it’s time to enter it into Pickler. You have several options for doing this, depending on the size of your dataset:
Manual Entry: For a few products, you can enter data directly through Pickler’s user-friendly interface.
CSV Upload: For larger datasets, we recommend using the CSV template provided by Pickler. This allows you to upload product data in bulk, making it easier to organize and track.
API Integration: For larger companies with complex data management needs, you can integrate Pickler directly with your ERP system through our API.
Best Practice: Use the Template
For most users, the CSV template is the best way to get started. It ensures that you’re entering all the necessary data in the right format and makes it easy to upload large datasets quickly.
3. Mapping Your Data to Secondary Data (IDEMAT)
Once your data is in Pickler, the next step is to map it to secondary data from trusted environmental databases, such as IDEMAT. This is where Pickler shines: by connecting your product data to scientifically validated environmental data, you get an accurate footprint score.
Explain that you get hotspot analysis that is great to start with.
What Is Secondary Data?
Secondary data refers to data from established sources that provide average environmental impacts for materials and processes. In LCA terms, secondary data is part of your background system—it fills in the gaps when you don’t have specific, measured data for your products. Pickler uses IDEMAT, a highly trusted database, to provide this background information(
).
How Do You Map Your Data?
Pickler makes the mapping process simple. After uploading your data, you’ll be guided through the process of linking your product information (like materials and production methods) to corresponding values in the IDEMAT database.
How Pickler makes your life easy with Worst-Case Values
Pickler ensures that no data is left unmapped by using worst-case scenario values. If you’re missing information, Pickler will automatically map your product to these values, ensuring that you can’t make overly optimistic claims about your environmental impact. This approach prevents greenwashing while giving you a solid starting point for your reports.
4. Specify your data for more accurate impact calculations
Providing detailed product data allows you to move from using general secondary data to more accurate primary data, leading to more reliable and specific environmental impact reports. The more specific your data, the more accurately Pickler can calculate your product's real environmental footprint. By doing this, you’ll ensure your sustainability reports reflect actual operations and avoid any risk of overestimating your environmental impact.
How to specifiy your data
There are two main approaches to improving your data in Pickler:
Collect More Detailed Primary Data
This involves gathering real data from your own operations or supply chain. Some examples include:Production: Instead of using average energy consumption values, track the actual energy used in your factory per production cycle.
Materials: If your packaging is made of specific percentages of recycled materials, providing that exact breakdown is more accurate than using general assumptions.
End-of-Life: Rather than relying on assumptions about recycling rates, you can input the actual disposal methods in regions where your product is sold.
Transitioning from Secondary Data
If you don’t have access to all the specific data right away, you’ll initially rely on secondary data from Pickler’s environmental databases (like IDEMAT), which use worst-case scenario estimates. However, as you collect more primary data, you can replace those estimates with your actual numbers, resulting in a more favorable and accurate impact score.
How You Do It: Moving from Secondary Data to Primary Data
What’s Next?
To refine your reports, it’s crucial to start gathering more primary data. This process involves filling in any gaps where Pickler currently uses secondary data. Here’s how you can get started:
1. Continue Collecting Data
Look at the areas where you’re missing specific data and work to gather this information. Focus on key data points like:
Energy consumption for your production facilities.
Exact material breakdown for your packaging.
Specific transportation routes and distances.
End-of-life processes specific to each region or market.
2. Ask Suppliers for Data
Your suppliers can provide critical primary data for materials, production methods, or transportation. Here are some ways to get them involved:
Request Life Cycle Assessments (LCAs) from your suppliers, which detail the environmental impacts of their products.
Send surveys or data requests to gather specific energy usage, material sourcing, or disposal data.
Collaborate to ensure they can provide the most accurate information to fill in any gaps.
3. Map Missing Data Fields to Pickler’s Secondary Data
If you’re still missing some data, don’t worry—Pickler can continue to map those missing data fields to secondary data from trusted sources like IDEMAT. Use Pickler’s “Toggle Not Mapped” feature to see which data fields haven’t been mapped yet, and ensure they are linked to either primary or secondary data.
4. Specify Your Data
As you collect more primary data, update Pickler with this information to improve your environmental impact score. By replacing secondary data with primary data, you’ll get a more accurate picture of your packaging’s lifecycle and its true impact on the environment. Focus on:
Production-specific data like energy use and emissions from your facilities.
Material-specific data detailing exactly what’s used in your packaging, with any recycled content.
Transport details, including exact routes and methods.
Ideal way
General idea
Preparing data
What data do you need?
Where to collect? << likely that you have it. Otherwise collect from supplier.
How we fill thhe gaps when you dont have data
Best practice:
Dont start with collecting all data at once. We got you covered
Data entry in Pickler
Ways of importing data
Best practice; use the template
How this template works
Map to secondary data (IDEMAT)
What is secondary Data and what is IDEMAT?
How do you map
How we make it easy by mapping to worstcase (it prevents greenwashing)
Data is ready! First results can you see
What's next?
Continue with data collection of data you're missing
Ask supplier! > HOW?
Map any missing datafields to Pickler's secondary data
Toggle not mapped
Specifiy your data
Collect primary data