Assigning product category factors

Assigning product category factors involves defining the 3-level product categories and mapping the L3 category to the appropriate emissions factor ID. Assign product category factors during initial system configuration, and update as necessary to reflect ongoing changes.

Before you begin

Download the following CSV template and enter your company's data. Verify that all the required values are entered.

CSV template link: Envizi-SCI-master-Product mapping.csv
Important: If you use Microsoft Excel to edit the CSV file, verify that you save it in the UTF-8 CSV file format. If you do not save the CSV file in the UTF-8 format, some special characters may be skipped or incorrectly interpreted during the data import process.

The following table outlines the required headers and associated information for preparing the CSV file.

Table 1. Product mapping CSV template headers
Column header Requirement Sample Description
Category L3 ID Required BULB Unique identifier of the third level of the product hierarchy.
Note: If no specific value is known or required, use 'All'.
Category L3 name Required (UI) Bulbs Name of the third level of the product hierarchy.
Category L2 ID Required Optical Unique identifier of the middle of the product hierarchy.
Note: If no specific value is known or required, use 'All'.
Category L1 ID Required Production Unique identifier of the top of the product hierarchy.
Note: If no specific value is known or required, use 'All'.
Emissions factor ID Required Electrical equipment, appliances, other Reference to the emissions factor group that is applied to this product category. For the list of allowed values, see Factor codes.
Factor codes
The Eora66 - MRIO (Multi-region Input-Output) factor set includes the following factor codes, which are available in Envizi™ Supply Chain Intelligence. Additionally, corresponding EPA factor codes are also available and align with the same Eora66 factor codes.
  • Accommodation
  • Administrative and support services
  • Air transportation
  • Ambulatory health care services
  • Amusements, gambling, and recreation
  • Apparel and leather and allied products
  • Broadcasting and telecommunications
  • Chemical products
  • Computer and electronic products
  • Computer systems design and related services
  • Construction
  • Data processing, internet publish, other IT
  • Educational services
  • Electrical equipment, appliances, other
  • Fabricated metal products
  • Farms
  • Fed Res banks, credit services, and other
  • Food and beverage and tobacco products
  • Food and beverage, general
  • Food services and drinking places
  • Forestry, fishing, and related activities
  • Funds, trusts, and other financial vehicles
  • Furniture and related products
  • General merchandise, general
  • Hospitals, general
  • Housing
  • Insurance carriers and related activities
  • Legal services, general
  • Machinery
  • Management of companies and enterprises
  • Mining, except oil and gas
  • Misc prof, scientific, technical services
  • Miscellaneous manufacturing
  • Motion picture, sound recording industries
  • Motor vehicle and parts dealers
  • Motor vehicles, bodies and trailers, parts
  • Nonmetallic mineral products
  • Nursing and residential care facilities
  • Oil and gas extraction
  • Other real estate, general
  • Other retail
  • Other services, except government
  • Other transportation and support activities
  • Other transportation equip., general
  • Paper products
  • Perf arts, spectator sports, museums, other
  • Petroleum and coal products
  • Pipeline transportation
  • Plastics and rubber products
  • Primary metals
  • Printing and related support activities
  • Publishing, excluding internet, inc software
  • Rail transportation
  • Rental, leasing ser, lessors intangible ass.
  • Securities, commodity contracts, investments
  • Social assistance
  • Support activities for mining
  • Textile mills and textile product mills
  • Transit and ground passenger transportation
  • Truck transportation
  • Utilities
  • Warehousing and storage
  • Waste management and remediation services
  • Water transportation
  • Wholesale trade
  • Wood products

Procedure

  1. From the side navigation menu, select Data management.
  2. On the Data management, select Import data.
  3. Click Add file and upload the Envizi-SCI-master-Product mapping.csv file.
  4. From the list of data mappings, select Master data - Product mapping (masterDataProductMapping).
  5. Optional: If your CSV file includes additional delimiters such as comma (,), colon (:), semicolon (;), or pipe (|), select the appropriate option from the Delimiter list to ensure the structured data is read correctly.
  6. Click Next and review the information.
  7. Click Import.
    The following message appears.

    New import job created Job {Job ID} has been successfully created.

  8. See the status of your import job on the Job Management page.
    Note: Depending on the size of the file, the import process might take some time to complete.

    If the status of your import job is Completed, then your data import job is successful.

    If the status of your import job shows CompletedWithErrors or Rejected,complete the following steps:
    1. Click the Job ID and check the errors in the Job details section.
    2. If errors are listed, then correct the highlighted errors in your CSV file and upload it again.
    3. If errors are not listed, then click Retry the import and check the status after a brief period.