Skip to main content

Uploading Excel Files

This guide will help you upload one or more Excel files, including images and categories, which can be stored in various formats.

First Case: Categories in Separate Indented Rows​

Step 1: Uploading Files​

  1. Upload one or more Excel files.
  2. If necessary, upload additional files or images for the products.
    • In this example, images are stored within the Excel file.
  3. Click the “Next” button and wait for processing.

Step 2: Configuring Tables​

  1. If multiple files are uploaded, select the main (master) table by moving it to the top.
  2. Expand the tables and mark the data for upload:
    • Images
    • Name
    • Category
    • Color
    • Price
    • Quantity
    • SKU (unique product code)
  3. Assign names to the attributes and select types for each:
    • Image group: configure the upload from the file and select a preview template.
    • Specify that the "Name" field is the product name.
    • The "Category" field will be used to form categories.
    • For color, select a multi-select list.
    • Set types: Price — “Float”, Quantity — “Integer”, SKU — “String”.
  4. Link the tables by SKU to add the "Description" field from the second table.

Step 3: Importing Categories​

  1. Specify the category for importing the catalog. If not specified, the catalog will go to the root.
  2. Check the number of products to be uploaded and change the value if necessary.
  3. Keep in mind that if the order of the tables has changed, saving the template will not be possible.

Click "Start import". After completion, check that categories and subcategories have been created, and products have been uploaded with images and data.

Second Case: Product Catalog as Values in a Column​

Step 1: Uploading the File​

  1. Upload a file where categories are separate indented rows.
  2. Select the columns for import.
  3. Fill in the attribute names, markers, and data types.
  4. Specify the fields for name and SKU.
  5. Upload the folder with images.

Step 2: Initializing Images​

  1. Clone the SKU column for uploading images.
  2. Set the name and select the type "Image".
  3. Specify the table field containing SKU to search for images by pattern.
  4. Choose a template for the preview.

Step 3: Importing Categories and Saving the Template​

  1. Specify that categories need to be gathered from the file content.
  2. Set the root category for importing the catalog.
  3. Save the export template to simplify future uploads.

Start the import. Check that categories and subcategories are gathered, and products have retained their hierarchy.