Skip to main content

How to Generate and Import a SuperTemplate

S
Written by Sam E.
Updated this week

How to Generate and Import a Super Template

This guide will walk you through the process of creating, editing, and importing a Super Template to manage your product data.

Before You Begin: Back Up Your Data

It is a critical best practice to back up your catalog before making any changes. This allows you to revert to a previous state if any errors occur.

  1. Navigate to Import/Export and select the Exports tab.

  2. Choose Catalog as the model and click Export to save a backup of your data.


Step 1: Generate the Super Template

First, you will generate the template file from your sales channel settings.

  1. Navigate to Admin > Integrations > Sales Channel > Posting Templates.

  2. Locate the desired template and click Edit.

  3. Select the Template Export tab.

  4. Configure your export by selecting the appropriate checkboxes.

    • Note: To create a template for new products, it is best to generate a blank Super Template by leaving all boxes unchecked. This ensures the image columns are included.

  5. Click Generate Super Template.

  6. Allow a few moments for the file to be created. When it is ready, a Download Super Template button will appear.

  7. Click the button to save the file in Microsoft Excel format.

Step 2: Review and Edit the Super Template

Next, open the downloaded file in Microsoft Excel and make your changes. The template uses color-coding to guide you.

Understanding the Formatting

  • Red Column Headers: Indicate required fields that must be filled.

  • Yellow Cells: Indicate missing values.

    • Warning: In rows where the group field is set to "product" (not "variant"), yellow cells may be false positives. Please verify if the data is required for that specific product.

  • Red Cells: Indicate invalid values. Use the provided drop-down menu in the cell to select a valid option.

    • Note: Currently, only single-value selection is supported in dropdowns. A multi-select solution is in development.

Understanding the Row Structure

  • Row 1: Contains the marketplace field names.

  • Row 4: Contains the corresponding Acenda field names.

  • Important: The import tool automatically ignores the first three rows, so do not delete them.

  • Tip: You can add new columns to the template. To do so, place the corresponding Acenda catalog variable in the fourth row of the new column.

Step 3: Format, Save, and Import

Finally, format a critical column, save the file correctly, and import it into the system.

  1. Format the UPC/Barcode Column

    • Caution: To prevent import errors, ensure the UPC/Barcode column is formatted in Excel to display as a 12-digit number, not in scientific notation (e.g., 1.23E+11).

  2. Save the File

    • When you are finished editing, save the file in CSV UTF-8 format.

  3. Import the Template

    • Navigate to Import/Export and click + New Import.

    • Set the import type to Super Template.

    • Locate your saved CSV file and click Start Import.

Following these steps will ensure your data is updated accurately and efficiently.

Did this answer your question?