This guide provides detailed instructions for generating the product and connection files using our Excel-based helper file.

It walks users through the process of working with the provided template, entering product and supplier details across multiple tabs, and ensuring that the resulting data is properly structured for seamless usage in the platform.

<aside>

Table of contents

</aside>

Generate products and connections files.mp4

<aside>

Download help file

To assist you with the import process, we’ve created a help file in .xlsx format. Follow these steps to download and open the file:

Download the Helper File

Locate the “download help file”-button provided below the section “Products” and save the .xlsx file to your computer.

Open the file in a Supported Program

• You can use programs like Microsoft Excel or SharePoint to open and edit .xlsx files. Other spreadsheet programs that support .xlsx files are also compatible.
• To open it in Microsoft Excel: Simply double-click the file, and it should open in Excel if it’s installed on your computer.
• To open it in SharePoint:
  • Go to your SharePoint site and navigate to the document library where you’d like to store the file.
  • Click Upload and select the .xlsx file from your computer.
  • Once uploaded, click on the file to open it in Excel for the Web directly within SharePoint. This allows you to view and edit the file online. </aside>

<aside>

Work inside the help file

The Helper File is divided into eight tabs at the bottom, each with specific sections to help you organize and input your data for importing. Please follow these instructions carefully on each page, as this step is crucial for successful integration with the Mitigater platform.

Tab 1: Welcome

Start here by entering basic information about your business.

• Legal Business Name: The official registered name of your company.
• Address Country: The country in which your business is located.
• Address Line 1: The primary street address for your business.
• Town or City: The city where your business operates.
• Postal Code: Your business’s postal code.
• Contact Email: An email address for primary contact.

Tab 2: Products List

List each of your products here, providing details for each field.

• My Sell Product Name: Enter the name you assign to each product. This should match the product identifier provided by your supplier. Max 250 characters.
• My Sell Product Number: A unique identification number for each product.
• Alias: Nickname or alternative name commonly used for the product. Max 250 characters.
• EAN Number: The unique European Article Number (EAN) for the product.
• Description: A brief description of the product. Keep it concise but informative. Max 250 characters.
• Tags: Keywords for filtering and grouping products. Separate tags with commas.

Tab 3: Supplier Information

Enter details about each supplier associated with your products.

• Supplier Name: The official or business name of each supplier.
• Supplier Email: The email of the contact person handling files for the supplier.
• Supplier Contact Person: Name of the supplier’s contact person (ideally the same as the person associated with the email address).
• Supplier Address: The physical address of the supplier.
• Supplier Postal Code: The postal code for the supplier’s location.
• Supplier Postal City: The city where the supplier is based.

Tab 4: Generate Connections

Specify how many products or components you assemble to create a final product.

• My Sell Product Name: Automatically fetched from the Products List.

• My Sell Product Number: Automatically fetched from the Products List.

• Number of Connected Products: Enter the number of components per product.

  • Example: If you purchase one product and resell it unchanged, enter 1. If you purchase and assemble four parts into one final product, enter 4.

  Learn more about how number of connections work

Tab 5: Connection Details

Connect each product with its supplier(s) to build the supply chain structure.

• Supplier Name: Specify the supplier’s name for each product.

• Supplier Product Number: Enter the unique identifier your supplier assigns to the product.

• Supplier Product Name: Enter the name your supplier uses for the product.

  Other fields in this tab will be automatically populated based on previous entries.

Tab 6: Finished

Once you’ve completed all entries, you can submit the file for processing.

• If you are not comfortable to generate a .csv file from the created files yourself feel free to send the file to Mitigater at [email protected]. Our team will process the data and create a Product File and a Connections File based on your inputs. We’ll return these files for you to upload into the Mitigater platform.

Tab 7: Export_Connections File

This tab allows you to download the formatted connections data, which is ready for direct upload into Mitigater. To ensure the best import experience:

• Export as CSV: Save this file as a CSV format (.csv) to ensure compatibility and a smooth import process.
• Review for Accuracy: Carefully review the data before exporting to catch any potential errors that could impact the import.

Tab 8: Export_Products File

This tab contains the finalized product data, formatted for upload into Mitigater. For optimal results:

• Export as CSV: Save this file as a CSV format (.csv) to ensure compatibility and a smooth import process.
• Double-Check Entries: Like the connections file, it’s essential to review the product data for accuracy before exporting, as any discrepancies could lead to import issues.

<aside> ☝🏻

</aside>

</aside>

Next step - Import products