Skip to main content

Product Library

The Product Library collects all products (SKUs) for a given reporting year together with their bill-of-materials and sustainability calculation parameters. Each product must reference a manufacturer already in the Supplier Registry and materials already in the Material Library for the same reporting year.

The import file is structured in five logical sections, each covering a different aspect of the product. All five sections share the same sku_code as primary key and are imported in a single file.

Import order dependency: Material Library must be imported before Product Library for the same reporting year.

File sections​

Section prefixTopicMandatory cols
c_Calculation configuration (LCA type, framework, boundary)5
pi_Product information and bill-of-materials20
d_Downstream logistics (only if system boundary is C2Grave)8
up_Use phase (washing, ironing, drying — optional but impacts LCA)16
eol_End-of-life (take-back quantities and recycling data)9

Schema​

Section c — Calculation configuration​

Column [ID]MandatoryDefinitionRuleType
sku_code [c_1]YESUnique product identifierMax 255 chars · - _ # . allowedalphanumeric
bulk_calculation_action [c_2]YESImport action for this rowLOAD, DELETE, or IGNOREsingle select
lca_calculation_type [c_3]YESCalculation type: product LCA or AGEC complianceLCA, AGEC, or AGEC_LCAsingle select
lca_framework [c_4]YESLCA frameworkSelect from dropdownsingle select
lca_system_boundary [c_5]YES if c_3 is LCA or AGEC_LCASystem boundaryC2Gate if ISO; C2Grave if EPD or PEFsingle select

Section pi — Product information and bill-of-materials​

Column [ID]MandatoryDefinitionRuleType
bulk_calculation_action [pi_1]YESImport action for this rowLOAD, DELETE, or IGNOREsingle select
collection_category [pi_2]YESProduct category (e.g. ready_to_wear, footwear)Select from dropdownsingle select
collection_name [pi_3]NOName of the collectionSelect from existing collection listsingle select
sku_code [pi_4]YESUnique product identifierMax 255 chars · - _ # . allowedalphanumeric
product_type [pi_5]YESProduct type sub-class (e.g. dress, sneakers)Select from dropdownsingle select
product_name [pi_6]YESHuman-readable product nameMax 255 charsalphanumeric
product_quantity_value [pi_7]YESNumber of units produced in the reporting year1 ≤ x ≤ 1,000,000numeric
product_weight_value [pi_8]YESWeight of 1 item0.01 ≤ x ≤ 1,000,000 · 2 decimal digitsnumeric
product_weight_unit_of_measure [pi_9]YESUnit for product weightg or kgsingle select
manufacturer_code [pi_10]YESManufacturer code (TIER 1 supplier already in SBP)Select from dropdownsingle select
garment_dye [pi_11]NOWhether dyeing is performed at garment levelyes or nosingle select
garment_printing_method [pi_12]NOPrinting method applied at garment levelSelect from dropdownsingle select
garment_printing_percentage [pi_21]NOGarment printing surface percentageSelect from dropdownsingle select
waste_from_assembly_percentage [pi_13]NOWaste generated per unit during manufacturing1 ≤ x ≤ 100percentage
component_group [pi_14]YESComponent group for this material lineSelect from dropdownsingle select
material_code [pi_15]YESMaterial code from the Material LibraryMax 255 chars · must exist in Material Libraryalphanumeric
material_sub-code [pi_16]NOMaterial sub-code from the Material LibraryMax 255 charsalphanumeric
material_consumption_value [pi_17]YESMaterial weight consumed per 1 item1 ≤ x ≤ 10,000 · 2 decimal digitsnumeric
material_consumption_unit_of_measure [pi_18]YESUnit for material consumptiong, kg, mt, sqm, or usingle select
transportation_method [pi_19]YESTransport method for material deliverySelect from dropdownsingle select
truck_information_desc [pi_20]YES if pi_19 is roadTruck type for road transportSelect from dropdownsingle select

Section d — Downstream logistics​

Only required when lca_system_boundary (c_5) is C2Grave.

Column [ID]MandatoryDefinitionRuleType
sku_code [d_1]YESProduct identifier—alphanumeric
downstream_logistic_scenario [d_2]YES if C2GraveDownstream logistics scenariocompany_distribution_mix or pef_default_scenariosingle select
PEF_1a_percentage_by_plane [d_3]YES if C2Grave% of shipments by air (leg 1a)1 ≤ x ≤ 100 · no % symbolnumeric
PEF_2a1_percentage_by_plane [d_4]YES if C2Grave% by air (leg 2a1)1 ≤ x ≤ 100numeric
PEF_2a1_distance_by_plane_in_km [d_5]YES if C2GraveDistance by air (leg 2a1) in km0 ≤ x ≤ 100,000 · 2 decimal digitsnumeric
PEF_2a2_percentage_by_plane [d_6]YES if C2Grave% by air (leg 2a2)1 ≤ x ≤ 100numeric
PEF_2a2_distance_by_plane_in_km [d_7]YES if C2GraveDistance by air (leg 2a2) in km0 ≤ x ≤ 100,000 · 2 decimal digitsnumeric
PEF_3a_distance_by_plane_in_km [d_8]YES if C2GraveDistance by air (leg 3a) in km0 ≤ x ≤ 100,000 · 2 decimal digitsnumeric

Section up — Use phase​

All columns in this section are optional but affect the LCA score.

Column [ID]DefinitionRuleType
sku_code [up_1]Product identifier—alphanumeric
Apply PEF default value for the number of wears [up_2]Use PEF default wear count for this product typeYes or Nosingle select
Estimated Number of Wears [up_3]Declared number of wears1 ≤ x ≤ 1,000,000numeric
Can this product be washed? [up_4]Whether the product can be washedyes or nosingle select
hand_washed_flag [up_5]Whether hand washing is allowedyes or nosingle select
machine_washing_flag [up_6]Whether machine washing is allowedyes or nosingle select
dry_cleaned_flag [up_7]Whether dry cleaning is allowedyes or nosingle select
At what temperature should it be washed? [up_8]Machine wash temperaturedont_know, 30, 40, or 60single select
Can the product be tumble dried? [up_9]Whether tumble drying is allowedyes or nosingle select
At what temperature should be dried? [up_10]Tumble dry temperaturedont_know, low T, medium T, or High Tsingle select
Can the product be ironed? [up_11]Whether ironing is allowedyes or nosingle select
At what temperature should it be ironed? [up_12]Iron temperaturedont_know, low T, medium T, or High Tsingle select
Apply PEF default value for ironing time [up_13]Use PEF default ironing timeyes or nosingle select
For how long should the product be ironed? [up_14]Ironing duration1 ≤ x ≤ 1,000,000numeric
Can the product be steamed? [up_15]Whether steaming is allowedyes or nosingle select
At what temperature should it be steamed? [up_16]Steam temperaturedont_know, low T, medium T, or High Tsingle select

Section eol — End-of-life​

Column [ID]MandatoryDefinitionRuleType
sku_code [eol_1]YESProduct identifier—alphanumeric
bulk_calculation_action [eol_2]YESImport actionLOAD, DELETE, or IGNOREsingle select
How many products did you take back? [eol_3]YES if pi_2 is not footwearUnits taken back during the year (apparel)1 ≤ x ≤ product quantitynumeric
What is the percentage of the sold product that was returned? [eol_4]NO% of footwear taken back1 ≤ x ≤ 100 · no %numeric
Where are products returned? [eol_5]NOISO country code of return locationISO 3166-1 alpha-2single select
Where is the recycling facility located? [eol_6]NOISO country code of recycling facilityISO 3166-1 alpha-2single select
component_group [eol_7]NOComponent group that was recycled—single select
material_code [eol_8]YESMaterial code of the recycled materialFrom Material Librarysingle select
material_sub-code [eol_9]NOMaterial sub-code of the recycled material—alphanumeric

Glossaries​

bulk_calculation_action — 3 values: LOAD · DELETE · IGNORE

lca_calculation_type — 3 values: LCA · AGEC · AGEC_LCA

lca_framework — 3 values: EPD · ISO · PEF

lca_system_boundary — 2 values: C2Gate · C2Grave

downstream_logistic_scenario — 2 values: company_distribution_mix · pef_default_scenario

collection_category — 9 values

ready_to_wear · footwear · bags_&_backpacks · accessories · activewear_outerwear · knitwear · underwear · swimwear · Sportswear

product_type — 78 values

arm_warmers · backpack · beach_dress · beach_robe · beauty_case · bech_towel · belt · bikini · body_suit · boots · bow_tie · bra · bucket_bag · cap · cardigan · coat · crossbody · dress · earmuffs · espadrilla · evening_bag · fleece · foulard · gloves · hat · helmet · hobo · jacket · jeans · keychain · lace_up · lanyard · leg_warmer · leggins · loafer · long_johns · night_dress · one_piece · panties_bottoms · pareo · pencil_case · pijama · polo · poncho · pouch · pump_heels · robe · sandals · satchel · scarf · shirt · shopping_bag · shorts · skirt · slip_on · slippers · sneakers · socks · sport_sneakers · sweater_jumper · sweatpant · sweatshirt · swimwear_man · t_shirt · tie · top · tote_bag · training_suit · travel_bag · trousers · underwear_man · veil · vest · waistcoat · wallet · washbag · wind_breaker · wristlet_bag

product_weight_unit_of_measure — 2 values: g · kg

garment_printing_method — 4 values: garment_digital_printing · garment_ink_jet_printing · garment_screen_printing · garment_transfer_printing

garment_printing_percentage — 5 values: 1 · 5 · 20 · 50 · 80

component_group — 13 values: care_labels_and_brand_labels · embellishment · heel · lining · main_material · other_materials · outer_material · packaging · shoelaces · sole · straps_and_handles · trims · upper_material

material_consumption_unit_of_measure — 5 values: g · kg · mt · sqm · u

transportation_method — 5 values: sea · road · rail · air · dont_know

truck_information_desc — 5 values: diesel_3 · diesel_7 · diesel_16 · diesel_32 · biodiesel

supplier_code — dynamic, populated from platform data.

Cross-file dependencies​

ColumnReferences
manufacturer_codeSupplier Registry (supplier with TIER 1)
material_codeMaterial Library (same reporting year)
material_sub-codeMaterial Library (same reporting year)