E-commerce Packaging Lifecycle Trace
This dataset provides end-to-end traceability for e-commerce packaging materials, capturing details from supplier sourcing and material composition through order fulfillment, delivery, and end-of-life disposition. It enables SMBs to analyze packaging sustainability, calculate environmental impact, and streamline compliance with extended producer responsibility regulations. The dataset is ideal for sustainability reporting, supply chain optimization, and regulatory audits.
Sample rows
preview · 8 of 60 rows · all 24 columns| order_idstring | packaging_typestring | material_weight_gramsfloat | is_reusableboolean | material_compositionstring | packaging_idstring | supplier_idstring | supplier_namestring | supplier_countrystring | date_supplieddate | date_packeddatetime | packed_by_employee_idstring | shipment_idstring | shipping_carrierstring | shipping_methodstring | delivery_datedate | customer_countrystring | end_of_life_actionstring | end_of_life_datedate | carbon_footprint_kgco2efloat | compliance_certificationstring | is_recycled_contentboolean | recycled_content_percentfloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD1001 | cardboard box | 320.5 | false | 100% recycled cardboard | PKG-001A | SUP-101 | EcoPack Solutions | Germany | 2024-03-05 | 2024-03-09T09:23:00 | EMP-201 | SHIP-901 | DHL | standard | 2024-03-15 | France | recycled | 2024-03-20 | 0.41 | FSC | true | 100 | Fully recycled, low-impact material. |
| ORD1002 | plastic mailer | 42.8 | false | LDPE plastic | PKG-001B | SUP-102 | PlastiServe | Poland | 2024-03-07 | 2024-03-10T13:45:00 | EMP-203 | SHIP-902 | FedEx | expedited | 2024-03-12 | Netherlands | landfill | 2024-03-19 | 0.32 | none | false | 0 | Single-use mailer, not recycled. |
| ORD1002 | bubble wrap | 99.5 | true | Polyethylene | PKG-001C | SUP-103 | BubbleGuard | Italy | 2024-03-06 | 2024-03-10T13:45:00 | EMP-203 | SHIP-902 | FedEx | expedited | 2024-03-12 | Netherlands | reused | 2024-03-25 | 0.38 | Cradle to Cradle | true | 15 | Bubble wrap reused for further shipments. |
| ORD1003 | paper envelope | 28.6 | false | Mixed recycled paper | PKG-002A | SUP-104 | PaperWay | France | 2024-03-08 | 2024-03-11T10:20:00 | EMP-205 | SHIP-903 | UPS | standard | 2024-03-16 | Belgium | recycled | 2024-03-19 | 0.09 | FSC | true | 85 | Envelope recycled by customer. |
| ORD1004 | cardboard box | 410.2 | false | Virgin cardboard | PKG-003A | SUP-101 | EcoPack Solutions | Germany | 2024-03-05 | 2024-03-11T14:17:00 | EMP-206 | SHIP-904 | DHL | standard | 2024-03-20 | Austria | recycled | 2024-03-27 | 0.55 | SFI | false | 0 | Box recycled locally. |
| ORD1005 | other | 22.3 | false | Biodegradable film | PKG-003B | SUP-105 | GreenFlex | Sweden | 2024-03-10 | 2024-03-12T11:04:00 | EMP-207 | SHIP-905 | PostNord | standard | 2024-03-17 | Denmark | composted | 2024-03-24 | 0.03 | none | true | 60 | Compostable packaging. |
| ORD1006 | plastic mailer | 55.4 | false | HDPE plastic | PKG-004A | SUP-102 | PlastiServe | Poland | 2024-03-07 | 2024-03-12T17:55:00 | EMP-208 | SHIP-906 | GLS | expedited | 2024-03-13 | Finland | landfill | 2024-03-18 | 0.42 | none | false | 0 | HDPE mailer, not recycled. |
| ORD1007 | bubble wrap | 120 | true | 100% recycled polyethylene | PKG-004B | SUP-103 | BubbleGuard | Italy | 2024-03-06 | 2024-03-13T09:10:00 | EMP-209 | SHIP-907 | FedEx | overnight | 2024-03-14 | Italy | unknown | 2024-03-22 | 0.46 | Cradle to Cradle | true | 100 | Bubble wrap, recycled content. |
| ORD1008 | paper envelope | 34.2 | false | Kraft paper | PKG-005A | SUP-104 | PaperWay | France | 2024-03-08 | 2024-03-13T15:40:00 | EMP-210 | SHIP-908 | UPS | standard | 2024-03-18 | Spain | recycled | 2024-03-24 | 0.11 | FSC | true | 75 | Envelope recycled. |
| ORD1009 | cardboard box | 395.8 | false | Mixed materials | PKG-005B | SUP-106 | PackValue | Czech Republic | 2024-03-09 | 2024-03-14T08:30:00 | EMP-211 | SHIP-909 | GLS | standard | 2024-03-19 | Slovakia | recycled | 2024-03-27 | 0.54 | SFI | true | 50 | Mixed materials box, partial recycled content. |
| ORD1010 | plastic mailer | 49.7 | false | LDPE plastic | PKG-006A | SUP-102 | PlastiServe | Poland | 2024-03-07 | 2024-03-14T11:25:00 | blank | SHIP-910 | DHL | standard | 2024-03-16 | Germany | landfill | 2024-03-23 | 0.37 | none | false | 0 | No recycled content. |
| ORD1011 | bubble wrap | 88.3 | true | Polyethylene | PKG-006B | SUP-103 | BubbleGuard | Italy | 2024-03-06 | 2024-03-15T14:27:00 | EMP-213 | SHIP-911 | FedEx | expedited | 2024-03-17 | Greece | unknown | 2024-03-25 | 0.34 | none | false | 0 | Bubble wrap, not recycled. |
| ORD1012 | paper envelope | 30.9 | false | 100% recycled paper | PKG-007A | SUP-104 | PaperWay | France | 2024-03-08 | 2024-03-15T16:08:00 | EMP-214 | SHIP-912 | UPS | standard | 2024-03-19 | Portugal | composted | 2024-03-24 | 0.08 | FSC | true | 100 | Envelope composted. |
| ORD1013 | cardboard box | 360 | false | 100% recycled cardboard | PKG-007B | SUP-101 | EcoPack Solutions | Germany | 2024-03-05 | 2024-03-15T18:51:00 | EMP-215 | SHIP-913 | GLS | standard | 2024-03-22 | Switzerland | recycled | 2024-03-28 | 0.44 | FSC | true | 100 | Box fully recycled. |
| ORD1014 | plastic mailer | 48.6 | false | HDPE plastic | PKG-008A | SUP-102 | PlastiServe | Poland | 2024-03-07 | 2024-03-16T09:02:00 | EMP-216 | SHIP-914 | FedEx | overnight | 2024-03-17 | Norway | landfill | 2024-03-22 | 0.36 | none | false | 0 | Mailer not recycled. |
| ORD1015 | bubble wrap | 110.7 | true | Mixed materials | PKG-008B | SUP-103 | BubbleGuard | Italy | 2024-03-06 | 2024-03-17T12:50:00 | EMP-217 | SHIP-915 | UPS | expedited | 2024-03-19 | Hungary | landfill | 2024-03-27 | 0.43 | none | true | 35 | Bubble wrap, some recycled content. |
| ORD1016 | paper envelope | 25 | false | Virgin paper | PKG-009A | SUP-104 | PaperWay | France | 2024-03-08 | 2024-03-18T10:13:00 | EMP-218 | SHIP-916 | GLS | standard | 2024-03-22 | Romania | recycled | 2024-03-29 | 0.07 | none | false | 0 | Envelope recycled. |
| ORD1017 | cardboard box | 410 | false | 100% recycled cardboard | PKG-009B | SUP-101 | EcoPack Solutions | Germany | 2024-03-05 | 2024-03-18T13:30:00 | EMP-219 | SHIP-917 | UPS | standard | 2024-03-25 | Luxembourg | recycled | 2024-03-31 | 0.53 | FSC | true | 100 | Box recycled. |
| ORD1018 | plastic mailer | 44.9 | false | LDPE plastic | PKG-010A | SUP-102 | PlastiServe | Poland | 2024-03-07 | 2024-03-19T09:01:00 | EMP-220 | SHIP-918 | DHL | standard | 2024-03-24 | Estonia | landfill | 2024-03-28 | 0.33 | none | false | 0 | LDPE mailer, disposed in landfill. |
| ORD1019 | bubble wrap | 75.5 | true | Polyethylene | PKG-010B | SUP-103 | BubbleGuard | Italy | 2024-03-06 | 2024-03-19T11:16:00 | EMP-221 | SHIP-919 | FedEx | expedited | 2024-03-21 | Slovenia | unknown | 2024-03-27 | 0.29 | none | false | 0 | Bubble wrap, unknown disposal. |
What the 60 rows show
from the 60-row sampleCardboard box (packaging type) stands out: mean material_
- 18%is_
reusable = true - 42.1median material_
weight_ grams - 4shipping methods
- 4compliance certifications
- 5end of life actions
- 7shipping carriers
Median 42.1, from 12.5 to 410.5.
- string 15
- float 3
- date 3
- datetime 1
- boolean 2
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
order_id | string | Unique identifier for the e-commerce order associated with the packaging lifecycle. | ORD1001 |
packaging_id | string | Unique identifier for the packaging unit or material tracked. | PKG-001A |
packaging_type | string | Type of packaging material (e.g., cardboard box, plastic mailer, bubble wrap).5 values | cardboard box |
material_composition | string | Primary material(s) used in the packaging (e.g., 100% recycled cardboard, LDPE plastic, mixed materials). | 100% recycled cardboard |
supplier_id | string | Unique identifier for the packaging supplier. | SUP-101 |
supplier_name | string | Name of the packaging supplier. | EcoPack Solutions |
supplier_country | string | Country where the packaging supplier is located.12 countries · optional | Germany |
packed_by_employee_id | string | Identifier for the employee who packed the order (if available).optional | EMP-201 |
shipment_id | string | Unique identifier for the shipment associated with the order and packaging.optional | SHIP-901 |
shipping_carrier | string | Name of the shipping carrier used to deliver the order.7 carriers · optional | DHL |
shipping_method | string | Type of shipping method (e.g., standard, expedited, overnight).standard · expedited · overnight · other · optional | standard |
customer_country | string | Country where the customer received the package.optional | France |
end_of_life_action | string | How the packaging was disposed of or processed at end-of-life (e.g., recycled, landfill, composted, reused, unknown).recycled · landfill · composted · reused · unknown · optional | recycled |
compliance_certification | string | Relevant compliance or sustainability certification(s) for the packaging (e.g., FSC, SFI, Cradle to Cradle, none).4 certifications · optional | FSC |
notes | string | Additional notes or comments about the packaging lifecycle or sustainability considerations.optional | Box recycled locally. |
| Numbers 3 columns | |||
material_weight_grams | float | Weight of the packaging material in grams.0 or more | 320.5 |
carbon_footprint_kgco2e | float | Estimated carbon footprint of the packaging material in kg CO2-equivalent.0 or more · optional | 0.41 |
recycled_content_percent | float | Percentage of recycled content in the packaging material (0-100).0 to 100 · optional | 100 |
| Dates and times 4 columns | |||
date_supplied | date | Date when the packaging was supplied to the business. | 2024-03-05 |
date_packed | datetime | Timestamp when the packaging was used to pack the order. | 2024-03-09T09:23:00 |
delivery_date | date | Date when the package was delivered to the customer.optional | 2024-03-15 |
end_of_life_date | date | Date when the packaging reached end-of-life (if known).optional | 2024-03-20 |
| True or false 2 columns | |||
is_reusable | boolean | Indicates if the packaging is designed to be reused. | false |
is_recycled_content | boolean | Indicates if the packaging contains recycled materials. | true |
Use it for
An e-commerce dashboard
The is_
reusable rate, material_ weight_ grams by packaging_ type and a breakdown of material_ composition. Excel, Power BI or Tableau. Why do the 15 cardboard box rows have a mean material_
weight_ grams of 251.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Orders60ORD1001320.5cardboar…ORD100299.5bubble w…ORD1007120bubble w…
A software demo
Believable orders with packaging_
id, packaging_ type and material_ composition to fill a screen in front of a buyer.
blueprint · e-commerce-packaging-lifecycle-trace
Behind this dataset
Same schema. As many rows as you need.
These 60 rows came out of a blueprint — 24 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each record links one e-commerce order to its packaging lifecycle events.
- Material types, volumes, and suppliers must be specified.
- Lifecycle stages include sourcing, use, recycling, and disposal.
- Include estimated carbon emissions per lifecycle stage.
- Compliance status with relevant regional packaging laws is required.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- e-commerce-packaging-lifecycle-trace