3.1.2. Enter products with Excel

On this page it is explained how you can enter products with Excel in your Ecochain company account. If you want to enter products manually, click here.

Navigate to the products tab

In the picture below it is shown how you can navigate to the products tab. 

Adding products

In order to add all your products using Excel, take the following steps:

• Click ‘Export’;
• The download starts, as indicated in the top-right of the screen;

• Open the Excel-file on your personal computer;

• Enter the product name(s);
• Optional: enter the English product name, internal reference (code) or product number (columns B, C and D);

• Enter the product type in column E. Use one of the following product types: “Goods and services”, “Energy”, “Transport” or “Waste” (recommended: Goods and services);
• Define the product unit, for example: “1 twelve-pack” or “1 tonne”;
• Enter the weight per product unit, for example: “7 kilograms” or “1 tonne”;

• Enter the production amount per year per product;
• Optional: enter the price (Euro) and the volume per product;

• When finished, save the Excel-file on your personal computer;
• Go to the ‘Products’ tab and click ‘Import’;
• Click ‘Select an xls file’;
• Select the saved file from your local computer;
• Click ‘Preview Changes’;

• Click ‘Save changes’.

The picture below shows the bottom section of the ‘Products’ tab, which appears once your products have been added. Under the advanced settings (see picture above) it is also possible to enter the volume of a product and a suggested price. In case these product characteristics are entered into the application, they are displayed in the ‘Volume’ and ‘Selected price’ columns.

To edit a product, click on the  icon.  To remove products from the products page, click on the  icon.

Excel errors

It is important to realise that the Import/Export function adheres to strict formatting, without which the Ecochain application cannot process the data correctly. The easiest way to ensure that this is the case is to base the imported data on an exported format.

The Excel-format should:

• Adhere to the pre-configured format of Ecochain data at that specific stage of the process. This means that no changes can be made in either the number of columns or column titles
• Not contain any formulas. If the cell value was determined by a formula, please ensure that it is pasted as a value if it is to be imported into Ecochain (use the ‘paste special’ option of Excel);
• Not contain any values that derive from cells that are not within the boundaries of the table. The ‘Look Up’ or referral functions should not be used, as Ecochain will not be able to follow that reference.