Logistics
30 columns
123 rows
8 formats

E-commerce Product Journey Traceability

This dataset provides comprehensive, end-to-end traceability for e-commerce products, detailing their journey from supplier to customer and highlighting key sustainability touchpoints. It enables analysis of supply chain transparency, carbon impact, transport efficiency, and supplier compliance, empowering sustainability strategists to optimize eco-friendly logistics and sourcing decisions.

last updated 22 Jan 2026
by GoMask

The brief that made it

Analyzing and optimizing supply chain sustainability and transparency

Sample rows

preview · 8 of 123 rows · all 30 columns

product_journey_idstring	sustainability_certificationstring	estimated_carbon_kgfloat	eco_friendly_packagingboolean	destination_address_statestring	product_idstring	product_namestring	skustring	supplier_idstring	supplier_namestring	supplier_countrystring	origin_address_streetstring	origin_address_citystring	origin_address_statestring	origin_address_postal_codestring	origin_address_countrystring	destination_address_streetstring	destination_address_citystring	destination_address_postal_codestring	destination_address_countrystring	customer_idstring	order_idstring	shipment_idstring	shipment_start_datetimedatetime	shipment_end_datetimedatetime	transport_modestring	distance_kmfloat	compliance_scorefloat	last_updateddatetime	sustainability_touchpointsstring
PJ102345	Organic	74.5	true	CA	P-FOOD-8732A	Organic Blueberry Jam	FOOD-JAM-20230987	SPLR-1002	Green Valley Farms	USA	834 Berry Ave	Portland	OR	97203	USA	210 Market St	San Francisco	94105	USA	CUST-AB12345	ORD-20240401-001	SHIP-0001A	2024-04-01T09:25:00Z	2024-04-02T13:40:00Z	truck	1145.2	98.4	2024-04-02T16:00:00Z	local-sourcing,renewable-energy,local-farming
PJ102346	ISO 14001	2430.8	false	Greater London	P-TEXTILE-9921B	Bamboo Cotton T-Shirt	TEXTILE-SHIRT-20231230	SPLR-2011	EcoThreads Manufacturing	Bangladesh	45 Industrial Rd	Dhaka	blank	1209	Bangladesh	628 Oak Lane	London	SE15 2TP	UK	CUST-CD78901	ORD-20240515-002	SHIP-0002B	2024-05-15T10:00:00Z	2024-05-22T17:25:00Z	sea	11200.7	81.5	2024-05-23T08:30:00Z	carbon-offset,recycled-material,efficient-logistics
PJ102347	ISO 14001	3905.2	false	ON	P-ELECTRO-9811F	Refurbished Laptop Pro	ELECTRO-LAPTOP-REFURB-100123	SPLR-3055	RenewTech Solutions	China	88 Tech Park	Shenzhen	Guangdong	518000	China	1002 Hilltop Ave	Toronto	M5H 2N2	Canada	CUST-TX98374	ORD-20240602-003	SHIP-0003C	2024-06-02T13:30:00Z	2024-06-08T16:05:00Z	air	12000.6	72.4	2024-06-09T09:20:00Z	carbon-offset,recycled-electronics,efficient-logistics
PJ102348	FSC	39.7	true	blank	P-WOOD-7713K	FSC Certified Oak Table	WOOD-TABLE-20231200	SPLR-4102	ForestLine UK	UK	12 Timber Lane	Bristol	Somerset	BS1 4DJ	UK	2077 Maple Rd	Amsterdam	1012 AB	Netherlands	CUST-UK00923	blank	SHIP-0004D	2024-02-15T08:10:00Z	2024-02-17T18:55:00Z	rail	680	93.2	2024-02-18T10:20:00Z	recycled-material,chlorine-free,recycled-paper
PJ102349	Organic	54.9	true	AB	P-FOOD-9212V	Plant-Based Protein Bar	FOOD-BAR-20240009	SPLR-1003	Sunrise Nutrition	Canada	204 Healthy St	Vancouver	BC	V6K 4S2	Canada	42 Elm St	Calgary	T2P 2M5	Canada	CUST-CN10283	ORD-20240310-004	SHIP-0005E	2024-03-10T11:40:00Z	2024-03-11T18:35:00Z	electric-vehicle	970.3	99.8	2024-03-11T19:00:00Z	local-sourcing,renewable-energy,local-farming
PJ102350	Fair Trade	3455	false	blank	P-LUXFOOD-9021Z	Ecuadorian Single-Origin Chocolate	blank	SPLR-5020	Cacao Export S.A.	Ecuador	Av. de los Cerezos 134	Quito	Pichincha	170517	Ecuador	5 Orchard Rd	Singapore	238823	Singapore	CUST-SG20001	ORD-20240420-005	SHIP-0006F	2024-04-20T15:50:00Z	2024-05-03T09:20:00Z	sea	17800.1	78.9	2024-05-03T12:00:00Z	fair-trade,carbon-offset
PJ102351	blank	0	true	Île-de-France	P-BICYCLE-8543Q	Urban Delivery Bicycle	BICYCLE-DELIVERY-20241023	SPLR-6011	Dutch Bikes Co.	Netherlands	17 Fietsstraat	Rotterdam	blank	3011 AA	Netherlands	11 Rue d'Artois	Paris	75008	France	CUST-FR99834	blank	SHIP-0007G	2024-07-05T07:30:00Z	2024-07-06T12:15:00Z	bicycle	0	87.2	2024-07-06T12:30:00Z	zero-emissions,local-delivery
PJ102352	ISO 14001	2295.5	false	Greater Manchester	P-TOY-6112S	Recycled Plastic Toy Blocks	TOY-BLOCK-20241299	SPLR-7012	PlaySmart China	China	9 Toy Road	Shanghai	Shanghai	200040	China	67 King St	Manchester	M1 7AE	UK	CUST-UK20345	ORD-20240528-006	SHIP-0008H	2024-05-28T13:10:00Z	2024-06-04T09:00:00Z	sea	10560.3	76.9	2024-06-04T10:40:00Z	recycled-material,efficient-logistics
PJ102353	FSC	2510.3	true	ON	P-PAPER-4412D	Chlorine-Free Copy Paper	blank	SPLR-8012	Papermakers India	India	93 Paper St	Kolkata	West Bengal	700016	India	24 Parliament Hill	Ottawa	K1A 0A9	Canada	CUST-CA00987	ORD-20240418-007	SHIP-0009I	2024-04-18T08:25:00Z	2024-04-25T14:15:00Z	sea	11750.4	85.3	2024-04-25T17:00:00Z	recycled-paper,chlorine-free
PJ102354	Organic	25.8	true	GA	P-DAIRY-1230M	Organic Greek Yogurt	DAIRY-YOGURT-20240022	SPLR-1005	Blue Ridge Dairy	USA	110 Milk Rd	Asheville	NC	28806	USA	2320 Central Ave	Atlanta	30303	USA	CUST-GA00122	ORD-20240412-008	SHIP-0010J	2024-04-12T07:45:00Z	2024-04-12T19:30:00Z	truck	299.5	96.2	2024-04-13T08:00:00Z	local-sourcing,renewable-energy,local-farming
PJ102355	ISO 14001	2305.4	true	Scotland	P-TEXTILE-7920T	Organic Cotton Socks	TEXTILE-SOCKS-20231129	SPLR-2014	Bangla Textiles	Bangladesh	88 Cotton Rd	Dhaka	blank	1207	Bangladesh	212 Rose St	Glasgow	G3 7TT	UK	CUST-UK99321	ORD-20240427-009	SHIP-0011K	2024-04-27T11:20:00Z	2024-05-03T16:40:00Z	sea	10500.3	89.6	2024-05-03T17:10:00Z	carbon-offset,efficient-logistics,local-sourcing
PJ102356	ISO 14001	2145.8	false	NSW	P-ELECTRO-1982N	Smart Home Sensor	ELECTRO-SENSOR-20230678	SPLR-3057	SinoTech Electronics	China	112 Innovation Rd	Beijing	blank	100089	China	31 Pine Ave	Sydney	2000	Australia	CUST-AU09321	blank	SHIP-0012L	2024-05-20T10:15:00Z	2024-05-26T17:45:00Z	air	8930.7	70.2	2024-05-26T18:50:00Z	carbon-offset,efficient-logistics
PJ102357	Organic	89.1	true	CA	P-FOOD-8291L	Dairy-Free Cheese Slices	FOOD-CHEESE-20240021	SPLR-1007	Vegan Delights	USA	67 Green Way	Seattle	WA	98101	USA	1510 8th Ave	Los Angeles	90015	USA	CUST-LA00233	ORD-20240422-010	SHIP-0013M	2024-04-22T09:00:00Z	2024-04-23T19:15:00Z	electric-vehicle	1544.9	97.7	2024-04-24T08:00:00Z	local-sourcing,renewable-energy
PJ102358	FSC	41.2	true	Greater London	P-DIY-6612R	Recycled Wood Wall Panel	WOOD-WALLPANEL-20239999	SPLR-4115	DIY Woodworks	Germany	77 Holzstrasse	Berlin	Berlin	10115	Germany	401 Cedar St	London	WC2N 5DU	UK	CUST-UK10234	ORD-20240318-011	SHIP-0014N	2024-03-18T14:00:00Z	2024-03-20T18:30:00Z	rail	930.2	91.3	2024-03-20T20:00:00Z	recycled-material,recycled-paper
PJ102359	ISO 14001	1825.7	false	QLD	P-ELECTRO-9012P	Smartphone Eco Edition	ELECTRO-PHONE-20231201	SPLR-3059	Techwise Japan	Japan	2 Chome-3-1 Akihabara	Tokyo	Tokyo	101-0021	Japan	78 Queen St	Brisbane	4000	Australia	blank	ORD-20240601-012	SHIP-0015O	2024-06-01T11:30:00Z	2024-06-07T14:55:00Z	air	7200.9	67.9	2024-06-07T16:00:00Z	carbon-offset,efficient-logistics
PJ102360	Fair Trade	3871.5	false	NSW	P-FOOD-3012C	Fair Trade Coffee Beans	FOOD-COFFEE-20240123	SPLR-5023	Mountain Roasters	Ecuador	123 Coffee Hill	Loja	Loja	110107	Ecuador	19 College St	Sydney	2006	Australia	CUST-AU98456	ORD-20240322-013	SHIP-0016P	2024-03-22T10:00:00Z	2024-03-28T17:30:00Z	sea	16520.8	80.1	2024-03-28T18:10:00Z	fair-trade,carbon-offset
PJ102361	ISO 14001	2467.8	false	ON	P-TEXTILE-2211U	Recycled Polyester Jacket	TEXTILE-JACKET-20230999	SPLR-2015	Textile Innovations	China	67 Fabric St	Suzhou	Jiangsu	215000	China	55 St George St	Toronto	M5S 2E8	Canada	CUST-CA20987	ORD-20240501-014	SHIP-0017Q	2024-05-01T09:35:00Z	2024-05-07T14:50:00Z	sea	11320.5	77.6	2024-05-07T15:20:00Z	carbon-offset,recycled-material,efficient-logistics
PJ102362	Organic	98.2	true	CO	P-FOOD-9942A	Organic Almond Milk	FOOD-MILK-20230199	SPLR-1008	Pacific Organics	USA	148 Farm Rd	Sacramento	CA	95821	USA	1550 Pine St	Denver	80202	USA	blank	ORD-20240611-015	SHIP-0018R	2024-06-11T07:45:00Z	2024-06-12T18:30:00Z	truck	1582.4	96.9	2024-06-12T19:00:00Z	local-sourcing,renewable-energy
PJ102363	ISO 14001	1054.8	false	VIC	P-ELECTRO-9921F	LED Desk Lamp	ELECTRO-LAMP-20231213	SPLR-3060	EcoBright Singapore	Singapore	38 Science Park Dr	Singapore	blank	118260	Singapore	90 Swanston St	Melbourne	3000	Australia	CUST-AU00876	blank	SHIP-0019S	2024-05-05T10:00:00Z	2024-05-10T12:20:00Z	air	6030.3	70.8	2024-05-10T14:10:00Z	carbon-offset,efficient-logistics
PJ102364	Organic	13.2	true	TX	P-FOOD-1203W	Plant-Based Mayonnaise	FOOD-MAYO-20240908	SPLR-1009	Nature's Spread	USA	25 Harvest Dr	Houston	TX	77002	USA	121 Main St	Dallas	75201	USA	CUST-TX98765	ORD-20240613-016	SHIP-0020T	2024-06-13T08:20:00Z	2024-06-13T17:45:00Z	electric-vehicle	385.2	99.1	2024-06-13T18:10:00Z	local-sourcing,renewable-energy,local-farming

What the 123 rows show

from the 123-row sample

Fair Trade (sustainability certification) stands out: mean estimated_carbon_kg is 5,251, against 1,075 for the rest.

63%eco_friendly_packaging = true
976.3median estimated_carbon_kg
6transport modes
7destination address countries
14supplier countries
14origin address countries

Mean estimated_carbon_kg by sustainability_certification108 rows

estimated_carbon_kg123 rows, in bands of 1,000

Median 976.3, from 0.0 to 8,901.

destination_address_state106 rows with a value · 17 left blank

ON22
Greater London16
NSW14
CA10
VIC8
Île-de-France6
QC5
Greater Manchester4
Scotland3
QLD3

30 columns by typefrom the column list below

string 23
float 3
datetime 3
boolean 1

Columns

30 columns in four groups

blueprint · 30 columns
column	type	description	example
Text 23 columns
`product_journey_id`	string	Unique identifier for each product journey instance from supplier to customer.unique	PJ102345
`product_id`	string	Unique identifier for the product being tracked.	P-FOOD-8732A
`product_name`	string	Name of the product.	Organic Blueberry Jam
`sku`	string	Stock Keeping Unit identifier for the product.optional	FOOD-JAM-20230987
`supplier_id`	string	Unique identifier for the supplier providing the product.	SPLR-1002
`supplier_name`	string	Name of the supplier.	Green Valley Farms
`supplier_country`	string	Country where the supplier is located.	USA
`origin_address_street`	string	Street address of the product's origin location.optional	834 Berry Ave
`origin_address_city`	string	City of the product's origin location.optional	Portland
`origin_address_state`	string	State or province of the product's origin location.optional	OR
`origin_address_postal_code`	string	Postal code of the product's origin location.optional	97203
`origin_address_country`	string	Country of the product's origin location.optional	USA
`destination_address_street`	string	Street address of the final customer delivery location.optional	210 Market St
`destination_address_city`	string	City of the final customer delivery location.optional	San Francisco
`destination_address_state`	string	State or province of the final customer delivery location.optional	CA
`destination_address_postal_code`	string	Postal code of the final customer delivery location.optional	94105
`destination_address_country`	string	Country of the final customer delivery location.7 countries · optional	USA
`customer_id`	string	Unique identifier for the customer receiving the product.optional	CUST-AB12345
`order_id`	string	Unique identifier for the order associated with this product journey.optional	ORD-20240401-001
`shipment_id`	string	Unique identifier for the shipment instance.optional	SHIP-0001A
`transport_mode`	string	Primary mode of transport used (e.g., truck, rail, air, sea, bicycle, electric-vehicle).7 values	truck
`sustainability_certification`	string	Sustainability certification held by the supplier or shipment (e.g., Fair Trade, FSC, Organic, ISO 14001).4 certifications · optional	Organic
`sustainability_touchpoints`	string	Comma-separated list of key sustainability touchpoints in the journey (e.g., renewable-energy, carbon-offset, local-sourcing).optional	fair-trade,carbon-offset
Numbers 3 columns
`distance_km`	float	Total distance covered in kilometers during the shipment.0 or more · optional	1145.2
`estimated_carbon_kg`	float	Estimated carbon footprint (in kilograms CO2e) for this product journey.0 or more · optional	74.5
`compliance_score`	float	Supplier compliance score (0-100) based on sustainability and traceability standards.0 to 100 · optional	98.4
Dates and times 3 columns
`shipment_start_datetime`	datetime	Date and time when the shipment started.	2024-04-01T09:25:00Z
`shipment_end_datetime`	datetime	Date and time when the shipment was delivered.	2024-04-02T13:40:00Z
`last_updated`	datetime	Timestamp of the last update to this record.	2024-04-02T16:00:00Z
True or false 1 column
`eco_friendly_packaging`	boolean	Indicates if eco-friendly packaging was used.optional	true

Use it for

A logistics dashboard
The eco_friendly_packaging rate, estimated_carbon_kg by sustainability_certification and a breakdown of destination_address_state. Excel, Power BI or Tableau.
Why do the 13 Fair Trade rows have a mean estimated_carbon_kg of 5,251?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Product journeys123
PJ10234574.5Organic
PJ1023462430.8ISO 14001
PJ10234839.7FSC
A software demo
Believable product journeys with product_id, product_name and sku to fill a screen in front of a buyer.

This dataset123 rows30 columns

Yours1,000 rows30 columnssupplier_country: UK only

blueprint · e-commerce-product-journey-traceability

Behind this dataset

Same schema. As many rows as you need.

These 123 rows came out of a blueprint — 30 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.

Rules it was built with

Each product record must include at least three supply chain stages (origin, warehouse, delivery).
Every journey stage logs associated carbon footprint (CO2e) values.
Include supplier sustainability certification status for source stage.
Track transportation method and corresponding efficiency rating per stage.
Flag any supply chain disruption or deviation from planned timeline.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

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-product-journey-traceability

What should your data show?

No signup. No card.

Sample rows

What the 123 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?