Articles on: Common issues

How to upload product data on the Lite plan

To start creating planograms in PlanoHero, you first need to upload product data. In this article, you will learn how to do this and prepare everything needed to work with planograms.



Contents

How to upload data from an Excel file
How to upload product images



How to upload data from an Excel file

To upload product data:

  1. Open the Home page;
  2. In the "Data solutions" block, five catalogs are displayed: brands, categories, suppliers, products, and product images, as well as the upload status of each one. 



If the data for a catalog has already been uploaded, you will see the "Open" button. Click it to view, update, or remove records. 


Please note! Removing data will lead to the deactivation or modification of planograms.



The "Download" button indicates the catalogs that have no data. Click it to open the upload page.



Data is uploaded using an Excel file. To avoid creating it from scratch, download the ready-made template and fill it in:

  1. For brands, specify a unique ID, that is, a number the system uses to distinguish one brand from another (for example, 1000, 1001, 1002), and the name;


  1. For categories, specify the ID and name. If a category is nested, that is, part of a broader category, also fill in the parent category ID in the parent_id field;


For example! The category "Non-food products" has ID 1000 and is a top-level category. "Household chemicals" is its subcategory, so in the parent_id field we enter 1000. In turn, "Laundry" is a subcategory of "Household chemicals", so in parent_id for "Laundry" we enter the ID of "Household chemicals", that is, 1001. 


  1. For suppliers, specify the ID and name;


  1. For products, specify the ID, name, code, barcode (multiple values can be separated by commas), category, price, and supplier. The product brand, its dimensions, and a flag indicating that the product is weighting are optional and can be specified if needed. For a weighting product, enter 1, and for a packaged product, enter 0.


Please note! The category, brand, and supplier of a product must be uploaded before importing products. The system uses this data to correctly link the product to the corresponding category, brand, and supplier.



Completed file:

  1. Drag it into the highlighted area or select it on your computer;
  2. After the upload is complete, click "Go to mapping";
  3. On the left, the data from your table is displayed; on the right are the fields for which you need to select the required columns. To keep only the selected columns, enable "Show only selected columns";
  4. Click "Check data". The system will automatically scan the file and, if it finds errors, highlight the problem rows in red, so you can quickly find them;
  5. If there are errors, edit the file and upload it again. If there are no errors, click "Upload".



After that, the "Upload from Excel" page opens automatically, where you can view the status, the date of the last change, and the user who made it.


You can also always open this page manually via Connector.




How to upload product images

Images help visually control product placement and instantly recognize products on the planogram. 


An Excel file is not required for this — images are uploaded directly.


The name of each file must match one of the product parameters:

  • Id — product ID;
  • Code — product code;
  • Barcode — product barcode.


For example! If an image is named 123456.png and 123456 is the product barcode, select the Barcode parameter.


To upload images:

  1. Select the parameter that the file names correspond to.
  2. Drag the images into the highlighted area or select them on your computer.


Upload limits:

  • up to 100 images at a time;
  • the size of one image is up to 2.5 MB;
  • PNG, JPEG, TIFF, and WEBP formats.


Updated on: 16/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!