Connectors: Excel, Merge Tables and New Tabs


In Excel connectors, it is possible to extract information from different tables separately, either in different Excel tabs, or in different files. For these options, select the parameter page in the initial configuration. From there we can choose if we want to merge a table of products with variants, for example, or of products with categories.

Merge Categories

Then, when configuring the tables, we can choose if we want to activate those tables or deactivate them.

Category & Products in Connectors

In addition, it is possible to add new tabs, for example  we can incorporate tables of sales material, or eliminate them.

Adding a New Table in Connectors

In the specific case of the Excel connector, it is possible to request these pages to be integrated in the same file. To do this, return to parameters and activate “Export a single excel with multiple sheets” (which by default is NO):

Export Excel

The tabs will have the name we have chosen in each of them, but we can rename them, an option that appears in the configuration of each table:

Tabs in Connectors

It is important to keep in mind that if we want to merge tables and take them out of an Excel, both pages must be called the same.

Note: Except for multi page options, much of what is described is applicable to other connectors such as Csv.

Warning: In case of merging tables (categories + products + variants), it is not possible to give different names to the excel sheets.

Tip: The page names of the different tables in the Output Data tab cannot exceed 31 characters.