Skip to main content

Step-by-Step: Format End of Life Treatment of Sold Products Data

How to upload your end of life treatment of sold products data

Clare avatar
Written by Clare
Updated over 3 weeks ago

The End of Life Treatment of Sold Products category refers to the emissions associated with the waste disposal of your products at the end of their life.

There are four calculation methods currently available for end of life treatment of sold products.

  • Weight per type of product sold uses the weight of the amount of waste per waste type (i.e. glass, paper, plastics, organic, residual, textile).

  • End-of-life treatment of fashion products and packaging calculates emissions emerging from the disposal of your fashion products and packaging using data on the quantity of products sold, their weight, and the type of waste generated.

  • Bring Your Own Emissions (BYOE) allows you to upload your own pre-calculated emissions to the Plan A platform.

  • Bring Your Own Emission Factors (BYOEF) allows you to upload your own emission factors with your activity to calculate emissions. It is your responsibility to ensure the emission factors align with your reporting needs.

Step-by-step: Format Weight per type of product sold data

There are several ways to enter your data. Regardless of which method you choose, you must include all required information to ensure accurate emissions calculations. Below, we’ve listed the key data points you need to include. The column order doesn't matter as long as all required data is included.

Column A: start_date

  • The first day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • This field is mandatory.

Column B: end_date

  • The last day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • It can be the same as the start date if you are entering data for just one day.

  • This field is mandatory.

Column C: location

Column D: facility_name

  • The facility that the respective emissions should be allocated to.

  • Make sure to apply exactly the same names you set in ‘Organisational Data’.

Column E: value

  • Waste weight: The waste weight for all waste types.

  • Format: Enter numeric values only and use a period as the decimal separator (e.g. 25634.20).

  • This field is mandatory.

Column F: value.unit

  • Select the unit for waste weight:

    • kg (kilogram)

    • lb (pound)

    • t (metric tonne = 1000 kgs)

    • ton (short ton = 2000 lbs)

  • This field is mandatory.

Column G: waste_type

  • The type of waste.

  • Choose from:

    • plastic

    • paper

    • organic

    • glass

    • residual

    • textile

  • This field is mandatory.

Optional tags

  • As always, you can add optional columns for company specific tags.

  • Learn more about how tags work: Tag Your Data.

Step-by-step: Format End-of-life treatment of fashion products and Packaging Data

There are several ways to enter your data. Regardless of which method you choose, you must include all required information to ensure accurate emissions calculations. Below, we’ve listed the key data points you need to include. The column order doesn't matter as long as all required data is included.

Column A: start_date

  • The first day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • This field is mandatory.

Column B: end_date

  • The last day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • It can be the same as the start date if you are entering data for just one day.

  • This field is mandatory.

Column C: location

  • The ISO-3166 alpha-2 code of the country where the product was sold. (e.g., DE).

  • The country code must be the same for all rows that correspond to the same SKU.

  • This field is mandatory.

Column D: facility_name

  • The facility that the respective emissions should be allocated to.

  • Make sure to apply exactly the same names you set in ‘Organisational Data’.

  • This field is mandatory.

Column E: value

  • The weight of the selected waste type per SKU unit.

  • Format: Enter numeric values only and use a dot as a decimal separator (e.g. 25643.20).

  • This field is mandatory.

Column F: value.unit

  • The measurement unit used.

  • Choose from:

    • kg

    • lb

    • t (Metric tonne = 1000 kilograms)

    • ton (Short ton = 2000 pounds)

  • This field is mandatory.

Column G: waste_type

  • The type of waste. Choose from:

    • textile

    • paperboard

    • metal

    • rubber

    • plastic

    • leather

  • The waste type here is not differentiated between materials used in clothing products and packaging separately. The waste type can be used interchangeably for either product categories.

  • This field is mandatory.

Column H: quantity

  • The quantity of goods sold per SKU.

  • Numbers should be formatted using numeric values only and using a dot as the decimal separator (e.g. 25634.20).

  • This field is mandatory.

Column I: sku

  • The SKU of the product or packaging sold.

  • You can list the same SKU across multiple rows if the SKU has multiple waste types.

  • This field is optional but recommended.

Optional tags

  • As always, you can add optional columns for company specific tags.

  • We recommended adding product_category and product_type as customer tags as it can help give you additional insights on the emissions per product sold.

    • product_category could be as simple as ‘Product’ and ‘Packaging’, or it can be as complex as you want based on the insights you want to derive.

  • Learn more about how tags work: Tag Your Data.

Step-by-step: Format BYOE data

There are several ways to enter your data. Regardless of which method you choose, you must include all required information to ensure accurate emissions calculations. Below, we’ve listed the key data points you need to include. The column order doesn't matter as long as all required data is included.

Column A: start_date

  • The first day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats articleto see a full list of formats you can use.

  • This field is mandatory.

Column B: end_date

  • The last day of your data period. It can be the same as the start date if you are entering data for just one day.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats articleto see a full list of formats you can use.

  • This field is mandatory.

Column C: location

Column D: facility_name

  • The facility that the respective emissions should be allocated to.

  • Make sure to apply exactly the same names you set here to all the other templates asking for a "facility_name" input.

Column E: value

  • Your own emissions in kg CO₂e.

  • Format: Enter numeric values only and use a period as the decimal separator (e.g. 25634.20).

  • This field is mandatory.

Optional tags

  • As always, you can add optional columns for company specific tags.

  • Learn more about how tags work: Tag Your Data.

Reminder: It is not Plan A’s responsibility to ensure the calculation of those 3rd parties are in accordance with the GHG Protocol. There is no verification or validation of BOYE emissions through Plan A.


Step-by-step: Format BYOEF data

There are several ways to enter your data. Regardless of which method you choose, you must include all required information to ensure accurate emissions calculations. Below, we’ve listed the key data points you need to include. The column order doesn't matter as long as all required data is included.

Column A: start_date

  • The first day of your data period.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • This field is mandatory.

Column B: end_date

  • The last day of your data period. It can be the same as the start date if you are entering data for just one day.

  • The suggested date format is YYYY-MM-DD, but check the Accepted Formats article to see a full list of formats you can use.

  • This field is mandatory.

Column C: location

  • The ISO-3166 alpha-2 code of the country associated with these emissions (e.g., DE).

  • This field is mandatory.

Column D: facility_name

  • The facility that the respective emissions should be allocated to.

  • Make sure to apply exactly the same names you set here to all the other templates asking for a "facility_name" input.

Column E: value

  • This field is for the data associated with the sold product, such as weight, volume, or any other metric relevant to your emission factor.

  • Enter data for a single unit of a purchased product or service.

  • Format: Numbers using periods as decimal separators.

  • This field is mandatory.

Column F: value.unit

  • The measurement unit for your activity data. Choose from:

    • Mass: kg, t, ton, lb

    • Volume: l, m³, gal, bbl

    • Distance: km, mi

    • Surface: m², ft²

    • Generic: quantity

  • The unit must belong to the same unit family as the data in the 'emission_factor.unit' column.

  • This field is mandatory.

Column G: emission_factor.unit

  • The measurement unit of the emission factor. Choose from:

  • Mass: kgCO2e/kg, kgCO2e/t, kgCO2e/ton, kgCO2e/lb

  • Volume: kgCO2e/l, kgCO2e/m³, kgCO2e/gal, kgCO2e/bbl

  • Distance: kgCO2e/km, kgCO2e/mi

  • Surface: kgCO2e/m², kgCO2e/ft²

  • Generic: kgCO2e/quantity

  • This field is mandatory.

Column H: emission_factor

  • The emission factor you want to apply to your activity data in kgCO2e.

  • Ensure the emission factor is per unit of the product to guarantee accurate calculations.

  • Please note it is your responsibility to ensure the emission factors align with your reporting needs.

  • This field is mandatory.

Column I: quantity

  • As the 'value' column represents a single unit of a sold product, specify the corresponding quantity here.

  • Format: Numbers using periods as decimal separators.

  • This field is mandatory.

Column J: product_category

  • If you use product categorisation, you can optionally enter the product category in this field.

  • This is recommended to give you deeper insights into your emissions.

Column K: product_subcategory

  • If you use product categorisation, you can optionally enter product subcategories in this field.

  • This is recommended to give you deeper insights into your emissions.

Column L: product_name

  • The name of the sold product.

  • This field is optional but recommended to give you deeper insights into your emissions.

Column M: product_reference

  • The product reference of the sold product.

  • This field is optional but recommended to give you deeper insights into your emissions.

Column N: source_file_name

  • The source file from which your activity data or emission factor was derived from.

  • This is recommended as emission factor sources may be requested from auditors.

Did this answer your question?