Troubleshooting: Product Upload Template

In this error message, you can see that it says "products[1]" is at fault. In relation to your uploaded file, this is equal to the product in row number 3. The first row is dedicated to headers and titles (Fx. ID, Product name, etc.), with the first count starting from line item 2. This is because binary counting starts at 0, and not 1. So, "products[1]" = product #3 in your Excel file.

Knowing this, you can open your product Excel sheet and work on changing all the products that have been highlighted in the error message - fx. products[3] = product 5 in your upload file.

To fix the issue, go to the "Components, Quantities, Materials, Shares, Production location, Production process" column. See below as an example:

The total material distribution, when you add them all together, should be equal to 100. If it doesn't it is typically one of the last decimals is off by a single digit - in the case above it's 31,250001 - this needs to be 31,250000. Changing this, depending on whether the rounding is one decimal too high or too low, will fix the issue. You don't need to shorten it; simply adjusting it will do the trick.

This is also why the original product template file won't catch this. It works with grams. However, once you validate and export your file, it will jump to shares (which is causing the issue). Fixing the issue by doing what I outlined above will take care of it all

This type of issue is related to when a material has a listed weight of 0 in shares. In the case below, it is the material LDPE

To fix this, you go to the exported file and check if it needs to a) be part of the product, or b) hasn't received the proper weight distribution - if this shouldn't be the case, you change it to accurately reflect the weight of the material; alternatively, you remove the material as it has no measurable purpose of being in the product

If you try to upload the file, and it gives you the rounding-of-shares error, then you will follow the steps above to fix it