How to add PCU conversion factor via Excel

See here how the conversion factor can be calculated: How to Calculate Conversion Factors (PCU)

From the Home page, select the box Items and modules with validation issues and deficiencies

image-20250903-134244.png

Click the number of products missing PCU conversion factor.

image-20250903-134354.png

Select all products and click the Export button.

Choose the attribute group Packaging, and select Conversion factors.

image-20230306-135527.png

Export products.

Select Price comparison unit from the dropdown in column G — the product group's price comparison unit(s) available for the relevant product group.

Select Conversion factor for PCU in column H — The example shown is where the price unit is PCS and the price comparison unit is square meters (M2). The value 4.5 means that you need 4.5 pieces to get one square meter of panel.

image-20230307-063715.png

Save the file on your PC.

Import the saved Excel file into NOBB Supplier by selecting the file or using the drag-and-drop function.

Note! Change the option What do you want to do? to Update existing products from Excel.

image-20230307-065649.png

After import, the following will be shown:

image-20230307-070057.png

Note! The file with the conversion factor will not be imported if there are errors in it. You must correct the import file and upload it again.

Remember to send products for publishing (approval).

See here:What needs to be done after uploading from Excel (import)