Here is the revised article. I have added the video tutorials in a dedicated section at the top for high visibility, improved the formatting for better readability in Intercom (using headers, bolding for UI elements, and clear warnings), and refined the instructions for clarity.
How to Generate and Import a Super Template
This guide walks you through creating, editing, and importing a Super Template to efficiently manage your product data.
📹 Video Tutorials
Prefer watching over reading? Check out these tutorials for specific workflows:
⚠️ Before You Begin: Back Up Your Data
Critical Best Practice: Always back up your catalog before making changes. This allows you to revert to a previous state if errors occur during the import.
Navigate to Import/Export and select the Exports tab.
Choose Catalog as the model.
Click Export to save a backup file of your current data.
Step 1: Map Required Fields
Your posting templates must have all required fields mapped before you can generate a Super Template.
For instructions on ensuring your templates are mapped correctly, please refer to: Building a Posting Template: A How-To Guide.
Step 2: Generate the Super Template
Once your fields are mapped, generate the template file directly 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:
Select Data: Check the boxes for the specific data fields you wish to modify.
Enable XLSM: Check the box for XLSM (Experimental). This enables advanced editing features, including multi-value selection dropdowns.
Click Generate Super Template.
Allow a few moments for the file to process. When the Download Super Template button appears, click it to save the file.
💡 Pro Tip for New Products: If you are creating a template to import new products, it is best to generate a blank template. To do this, leave all data boxes unchecked (except for the XLSM option). This ensures all necessary image columns are included automatically.
Step 3: Review and Edit the Super Template
Open the downloaded file in Microsoft Excel.
Requirement: You must use the latest version of Microsoft Excel for the multi-value dropdown features to function correctly.
Understanding the Formatting
Red Column Headers: Indicate required fields that must be filled.
Yellow Cells: Indicate missing values.
Note: In rows where the group field is set to "product" (parent) rather than "variant," yellow cells may be false positives. Verify if the data is truly required for the parent product.
Red Cells: Indicate invalid values. Use the provided drop-down menu in the cell to select a valid option.
Multi-Value Selection: You can now select multiple options within the dropdown menus provided in the XLSM file.
Understanding the Row Structure
Row 1: Marketplace field names.
Row 4: Corresponding Acenda field names.
Important: The import tool automatically ignores the first three rows—do not delete them.
Adding Columns: You can add new columns to the template. Place the corresponding Acenda catalog variable in the fourth row of the new column.
Step 4: Format, Save, and Import
Finally, prepare your file for upload.
1. Format the UPC/Barcode Column
Caution: Excel often defaults large numbers to scientific notation (e.g., 1.23E+11), which will cause import errors.
Highlight your UPC/Barcode column.
Format the cells as Number (with 0 decimal places) to ensure the full 12-digit number is visible.
2. Save the File
When you are finished editing your XLSM file, you must save the final version as a CSV UTF-8 file. The system cannot import the .xlsm file directly.
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 using the new multi-value capabilities.