E-commerce Packaging Waste Audit
This dataset provides detailed records of packaging waste generated from e-commerce orders, including product details, packaging types, material sustainability, and disposal methods. It enables analysts to identify high-waste products, optimize packaging choices, track ESG compliance, and monitor supply chain sustainability across geographic regions.
Sample rows
preview · 8 of 120 rows · all 24 columns| audit_idstring | packaging_typestring | packaging_weight_gramsfloat | is_biodegradableboolean | shipping_statestring | order_idstring | audit_datedate | product_idstring | product_namestring | product_categorystring | quantity_orderedinteger | packaging_materialstring | packaging_volume_cm3float | is_recyclableboolean | supplier_idstring | supplier_namestring | customer_idstring | shipping_street_addressstring | shipping_citystring | shipping_postal_codestring | shipping_countrystring | esg_compliance_flagboolean | waste_disposal_methodstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AUD001 | biodegradable pouch | 18.2 | true | MA | ORD1001 | 2022-12-05 | PRD-APP-0011 | Eco Cotton T-Shirt | apparel | 2 | biodegradable | 95 | false | SUP-101 | GreenTex Supplies | CUS-3001 | 451 Maple Ave | Boston | 02118 | USA | true | composted | Certified compostable pouch; customer praised minimal packaging |
| AUD002 | plastic blister pack | 34.5 | false | WA | ORD1002 | 2023-01-13 | PRD-ELE-0022 | Wireless Mouse Pro | electronics | 1 | plastic | 120 | false | SUP-103 | TechNova | CUS-3002 | 78 River St | Seattle | 98108 | USA | false | landfill | Plastic packaging not recyclable; customer requested alternatives |
| AUD003 | cardboard box | 820.6 | false | ENG | ORD1003 | 2024-03-21 | PRD-HOM-0033 | Ceramic Vase Medium | home goods | 12 | cardboard | 5400 | true | SUP-110 | HomeCraft Ltd | CUS-3003 | 24 Queen St | London | EC2A 4AA | UK | true | recycled | Bulk shipment; packaging fully recyclable |
| AUD004 | paper envelope | 22.6 | false | ON | ORD1004 | 2023-07-12 | PRD-APP-0012 | Organic Denim Jeans | apparel | 1 | paper | 110 | true | SUP-101 | GreenTex Supplies | CUS-3004 | 9 Market Lane | Toronto | M5T 1A1 | Canada | true | recycled | Paper envelope recyclable; minimal packaging used |
| AUD005 | plastic wrap | 28.1 | false | CO | ORD1005 | 2023-10-09 | PRD-ELE-0023 | Bluetooth Speaker Mini | electronics | 2 | plastic | 85 | false | SUP-105 | SoundWorks | CUS-3005 | 1205 Franklin Rd | Denver | 80205 | USA | false | landfill | Plastic wrap not recyclable; ESG compliance failed |
| AUD006 | cardboard box | 510.8 | false | NSW | ORD1006 | 2024-01-07 | PRD-HOM-0034 | Bamboo Serving Tray | home goods | 6 | cardboard | 4980 | true | SUP-112 | Bambu Goods | CUS-3006 | 132 High St | Sydney | 2000 | Australia | true | recycled | Efficient cardboard packaging; meets ESG standards |
| AUD007 | biodegradable wrap | 12.6 | true | IL | ORD1007 | 2023-04-18 | PRD-APP-0013 | Athletic Socks Set | apparel | 3 | biodegradable | 52 | false | SUP-101 | GreenTex Supplies | CUS-3007 | 3427 South St | Chicago | 60616 | USA | true | composted | Biodegradable wrap certified; compostable |
| AUD008 | plastic wrap | 15.7 | false | TX | ORD1008 | 2022-10-29 | PRD-ELE-0024 | Smartphone Stand Pro | electronics | 1 | plastic | 45 | false | SUP-103 | TechNova | CUS-3008 | 87 Main Street | Dallas | 75201 | USA | false | landfill | Plastic wrap not recyclable; customer left negative feedback |
| AUD009 | cardboard box | 380.4 | false | ENG | ORD1009 | 2023-09-03 | PRD-HOM-0035 | Glass Tumblers 6-Pack | home goods | 6 | cardboard | 3900 | true | SUP-110 | HomeCraft Ltd | CUS-3009 | 15 George St | Manchester | M1 2FF | UK | true | recycled | All packaging recyclable; supplier certified |
| AUD010 | biodegradable wrap | 17.3 | true | BC | ORD1010 | 2022-08-15 | PRD-APP-0014 | Recycled Poly Hoodie | apparel | 1 | biodegradable | 65 | false | SUP-101 | GreenTex Supplies | CUS-3010 | 692 Oxford St | Vancouver | V6B 1J4 | Canada | true | composted | Biodegradable wrap meets ESG standards |
| AUD011 | cardboard box | 1020.7 | false | blank | ORD1011 | 2023-05-22 | PRD-ELE-0025 | LED Desk Lamp | electronics | 12 | cardboard | 10820 | true | SUP-103 | TechNova | CUS-3011 | 15 Harbour St | Hong Kong | 999077 | Hong Kong | true | recycled | Bulk order; all packaging recyclable and certified |
| AUD012 | plastic wrap | 19.8 | false | WA | ORD1012 | 2023-11-16 | PRD-HOM-0036 | Silicone Baking Mat | home goods | 3 | plastic | 65 | false | SUP-113 | KitchenPro | CUS-3012 | 102 King St | Perth | 6000 | Australia | false | landfill | Plastic wrap; not recyclable |
| AUD013 | paper envelope | 16.9 | false | NY | ORD1013 | 2024-03-05 | PRD-APP-0015 | Merino Wool Scarf | apparel | 1 | paper | 71 | true | SUP-101 | GreenTex Supplies | CUS-3013 | 221 Park Ave | New York | 10016 | USA | true | recycled | Paper envelope recyclable; minimal waste |
| AUD014 | plastic wrap | 8.7 | false | TX | ORD1014 | 2023-03-14 | PRD-ELE-0026 | USB-C Charging Cable | electronics | 2 | plastic | 24 | false | SUP-103 | TechNova | CUS-3014 | 478 Elm St | Austin | 78701 | USA | false | incinerated | Plastic wrap; ESG compliance failed |
| AUD015 | biodegradable pouch | 21.5 | true | VIC | ORD1015 | 2022-11-30 | PRD-HOM-0037 | Organic Cotton Towels | home goods | 2 | biodegradable | 105 | false | SUP-112 | Bambu Goods | CUS-3015 | 57 Pine St | Melbourne | 3000 | Australia | true | composted | Biodegradable pouch certified; compostable |
| AUD016 | paper envelope | 19.6 | false | AB | ORD1016 | 2023-08-18 | PRD-APP-0016 | Summer Linen Dress | apparel | 1 | paper | 62 | true | SUP-102 | PureWear | CUS-3016 | 303 King St | Edmonton | T5J 1A1 | Canada | true | recycled | Paper envelope recyclable; ESG standards met |
| AUD017 | hard plastic case | 142.3 | false | blank | ORD1017 | 2024-02-22 | PRD-ELE-0027 | Noise-Cancelling Headphones | electronics | 1 | plastic | 340 | false | SUP-105 | SoundWorks | CUS-3017 | 19 Fifth Ave | Singapore | 238836 | Singapore | false | landfill | Hard plastic case not recyclable |
| AUD018 | cardboard box | 320.7 | false | CA | ORD1018 | 2023-06-19 | PRD-HOM-0038 | Wooden Salad Bowl | home goods | 4 | cardboard | 1880 | true | SUP-110 | HomeCraft Ltd | CUS-3018 | 81 Broadway | San Francisco | 94133 | USA | true | recycled | Cardboard box recyclable; meets ESG |
| AUD019 | plastic wrap | 7.5 | false | FL | ORD1019 | 2022-09-24 | PRD-APP-0017 | Classic Polo Shirt | apparel | 1 | plastic | 18 | false | SUP-102 | PureWear | CUS-3019 | 44 Queen Rd | Miami | 33132 | USA | false | landfill | Plastic wrap not recyclable; complaint about excessive packaging |
| AUD020 | bubble mailer | 48.2 | false | CA | ORD1020 | 2023-02-11 | PRD-ELE-0028 | Laptop Sleeve | electronics | 1 | plastic | 175 | false | SUP-104 | UrbanTech | CUS-3020 | 7 Green St | Los Angeles | 90012 | USA | false | landfill | Plastic bubble mailer not recyclable |
What the 120 rows show
from the 120-row sampleBiodegradable pouch (packaging type) stands out: 20 of its 20 rows have is_
- 24%is_
biodegradable = true - 19.8median packaging_
weight_ grams - 3product categories
- 4packaging materials
- 4waste disposal methods
- 6shipping countries
Median 19.8, from 5.8 to 1,300.
- string 17
- integer 1
- float 2
- date 1
- boolean 3
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
audit_id | string | Unique identifier for each packaging waste audit recordunique | AUD001 |
order_id | string | Unique identifier for the e-commerce order associated with the audit | ORD1001 |
product_id | string | Unique identifier for the product included in the order | PRD-APP-0011 |
product_name | string | Name of the product included in the order | Eco Cotton T-Shirt |
product_category | string | Category of the product (e.g., electronics, apparel, home goods)3 categories | apparel |
packaging_type | string | Type of packaging used (e.g., cardboard box, plastic wrap, bubble mailer)8 types | biodegradable pouch |
packaging_material | string | Material of the packaging (e.g., cardboard, plastic, paper, biodegradable)4 materials | biodegradable |
supplier_id | string | Unique identifier for the supplier or vendor of the productoptional | SUP-101 |
supplier_name | string | Name of the supplier or vendoroptional | GreenTex Supplies |
customer_id | string | Unique identifier for the customer who placed the order | CUS-3001 |
shipping_street_address | string | Street address for the shipping destinationoptional | 451 Maple Ave |
shipping_city | string | City for the shipping destinationoptional | Boston |
shipping_state | string | State or province for the shipping destinationoptional | MA |
shipping_postal_code | string | Postal code for the shipping destinationoptional | 02118 |
shipping_country | string | Country for the shipping destination6 countries · optional | USA |
waste_disposal_method | string | Method used for disposing of packaging waste (e.g., recycled, landfill, composted)recycled · landfill · composted · incinerated · unknown · optional | composted |
notes | string | Additional notes or observations from the auditoptional | Cardboard box recyclable |
| Numbers 3 columns | |||
quantity_ordered | integer | Number of units of the product in the order1 or more | 2 |
packaging_weight_grams | float | Weight of packaging used for the order, in grams0 or more | 18.2 |
packaging_volume_cm3 | float | Volume of packaging used for the order, in cubic centimeters0 or more · optional | 95 |
| Dates and times 1 column | |||
audit_date | date | Date when the packaging waste audit was performed | 2022-12-05 |
| True or false 3 columns | |||
is_recyclable | boolean | Indicates if the packaging material is recyclable | false |
is_biodegradable | boolean | Indicates if the packaging material is biodegradable | true |
esg_compliance_flag | boolean | Indicates if the packaging for this order complies with ESG (Environmental, Social, Governance) requirements | true |
Use it for
An e-commerce dashboard
The is_
biodegradable rate, packaging_ weight_ grams by packaging_ type and a breakdown of shipping_ state. Excel, Power BI or Tableau. Why do 29 of 120 rows have is_
biodegradable = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Audits120AUD00118.2biodegra…AUD00234.5plastic …AUD00712.6biodegra…
A software demo
Believable audits with order_
id, audit_ date and product_ id to fill a screen in front of a buyer.
blueprint · e-commerce-packaging-waste-audit
Behind this dataset
Same schema. As many rows as you need.
These 120 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 represents one completed shipment
- Include packaging type, weight, and recyclability
- Flag orders with excessive or non-compliant packaging
- Calculate cumulative waste per product category
- Identify suppliers with highest average packaging waste
- Link packaging choices to delivery method (standard, express, eco)
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- e-commerce-packaging-waste-audit