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.
Navigate to Import/Export and select the Exports tab.
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.
Navigate to Admin > Integrations > Sales Channel > Posting Templates.
Locate the desired template and click Edit.
Select the Template Export tab.
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.
Click Generate Super Template.
Allow a few moments for the file to be created. When it is ready, a Download Super Template button will appear.
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.
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).
Save the File
When you are finished editing, save the file in CSV UTF-8 format.
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.