Skip to main content
Preparing your product data

What data is required for Pickler, where should you start and how accurate should your data be?

Daan van Hal avatar
Written by Daan van Hal
Updated over a week ago

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:

  1. What data is needed?

  2. Do I need all data to start?

  3. What data should I focus on?

  4. How accurate should the data be?

  5. 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:

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

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


Did this answer your question?