Skip to main content

Uploading XML files

Follow these steps to upload XML files to the system.

Step 1: Prepare and upload files​

  1. Select the file type: Make sure XML is selected as the file type.
  2. Upload files: Drag one or more XML files into the corresponding field. For example, you can upload a file with products and a file with prices. You can also add images or other files. The upload order matters: upload the main product file first.
  3. Specify data locations: For each file, specify where the data is. The system automatically splits the files into tables by attribute set.
  4. Work with tables:
    • Each table is a set and shows its number of records.
    • If keys and values are swapped, select the Swap keys and values in the file checkbox.
    • For catalogs with nested categories, specify where the categories are and which column to look them up for. If needed, set a regular expression (by default, the search is configured for uuid).
    • Remove attributes you don't need. Attributes present in all sets are highlighted in green and can be used to merge sets.
    • To merge product groups, remove non-essential parameters. For example, if all tables have a name, SKU, and category and you don't need the other attributes, remove them to get a single merged set.

Step 2: Configure attributes​

  1. Select and edit attributes:
    • In the first table, select attributes and edit their names and markers.
    • For the "Category" field, specify whether a category tree should be built.
    • Set types for other attributes:
      • "Color": type "list".
      • "Description": type "text".
      • Image: type "image". Specify the path to the image and select a preview template.
    • Explicitly mark "Name" as the product name and "SKU" as the SKU.
  2. Link tables: Link the tables by SKU to get prices from another file. Repeat this for the second and third tables.
  3. Configure the price table:
    • Set the price field type to "Float".
    • Mark it as the product price.

Step 3: Select a category for upload​

Specify the category the data will be uploaded to.

Step 4: Start the import​

  1. Check records: This step shows the number of records that will be added.
  2. Process all data sets: This checkbox indicates that all data sets will be processed, rather than only the master table's set.
  3. Clear group names: If needed, select this checkbox to remove the group names set in step 2 from the data sets (available if group names are set).
  4. Start the process: Click Start import.
  5. Result: When the process finishes, make sure that:
    • Categories and subcategories have been created.
    • The data has been indexed.
    • Images have been uploaded successfully.
    • All products are placed according to the structure.
    • Attributes are filled in correctly.