How to upload product dimensions from an Excel file

Uploading dimensions from an Excel file helps update the height, width, and depth of several products at once without editing each one separately. Accurate dimensions ensure correct product placement on the planogram and correct calculation of facings and stock. In this article, we will look at how to prepare and upload the file and fix possible errors.

How to upload product dimensions from an Excel file

To upload product dimensions using an Excel file:

1. Click "Upload product dimensions" on the top toolbar:

2. The "Product sizes upload" modal window opens;
3. To create the file correctly, click "Download Excel file template" and open it;
4. For each product, fill in the following columns:
5. • Articles/Barcodes — the article or barcode of the product (they must not be repeated in the file);
   • Product height, m — product height;
   • Product width, m — product width;
   • Product depth, m — product depth.
5. Drag the prepared document into the designated area or select it from your computer. 

After the file is uploaded, a preview modal window opens where you can fix any errors found. 

The number of errors is displayed in the upper left corner. Click it to show the errors in a list.

Possible errors:

• It`s impossible to load sizes for two or more identical products — occurs when an article is duplicated in the file. To remove all duplicates, click "Remove duplicates" in the upper right corner;
• Product with article number not found — occurs when the file contains an article that is not in the PlanoHero assortment. To fix it, click the cell, enter the correct article, and press Enter;
• Invalid product size — occurs when the size is negative or equal to zero. To fix it, click the cell, enter the correct value, and press Enter.

To complete the upload, click "Upload".

Updated on: 04/11/2026