Skip to main content

Splitting attribute sets

You have received new product data and these should now be assigned to the correct attribute sets and transferred to the store as quickly as possible. The "Split to Attribute set" function helps you to do this and distributes the product data to the attribute sets assigned to them with just one click.

There are two cases to distinguish: one is the application of the function without template, the other is with template.

Case 1: without template​

Initial situation: We have received an excel spreadsheet with new products/product data.

Goal: These products must be created in the associated attribute sets.

Procedure:

  • Open the Excel folder with the new product data and format it into a table (key combination Ctrl&A and Ctrl&L).
  • Provide the column headers with a prefix so that the columns can be clearly distinguished from the store columns. To do this, insert another line above the column headers with the formula ="Prefix"& cell column name.

Example: ="her-"&TabelleElectronics[[#Header];[Article number]]

Apply this formula to all column headers by dragging them to the right. Now overwrite the old column headers by copying the new row and pasting only the values as new column headers. Then remove the newly added row again.

  • Add an "Attribute Set" column to your table and define the attribute set for each product by inserting the name of the set. If necessary, this process can also be facilitated with the help of formulas.
  • Load the import mode with the default template.
  • Click the "Split to Attributeset" button.

What happens?

In each attribute set, yellow new columns are added, which contain the column names and values of the product data.

  • Now it is our task to assign the data of the yellow columns to the Magento attributes. This is done via formulas.

Examples:

  • direct assignment

=[@[her-Article number]]

  • assignment as composition of several supplier columns

=[@[her-Name]]&" possibly a fixed text "&[@[her-Höhe]]&" "&[@[her-Breite]]&" "&[@[her-Tiefe]]

=Madison LX2200 possibly a fixed text 67.5 mm 48.85 mm 26.25 mm

  • assignment via matching tables with translation

Initial situation: a table containing your color names and the manufacturer's color names

=INDEX(Colors[own color];EVALUATION([@[her-Color]];Colors[manufacturer color];0))

  • Once you have created these formulas and all the initial data has been mapped to the attribute columns, click "Save Products" and the new products/data will be imported into your store.
  • If you want to perform this process regularly with the same data, save the formulas as a template. To do this, remove the contents of the yellow columns in each attribute set, select the drop-down menu from Load products → Template → Save. Saving a template is useful, for example, for recurring product lists from the same manufacturer or daily made price comparisons, and much more.

Case 2: with an already existing template​

Initial situation:

You want to create new products and have a list of these new products with all attributes formatted as a table in an Excel sheet. Likewise, it is not the first time that you want to transfer data from this supplier to the store and therefore already have a template that represents the assignment and creation of the products.

Goal: Using your template, you want to import the products into the store.

Procedure:

  • Open the file of your supplier.
  • Load the already existing template.
  • For each attribute set, perform an exact match of the added yellow column headers with the column headers of the supplier data. At the slightest inaccuracy (e.g. a space, differences in upper and lower case) the formula relationships already created in the template will not work.
  • A useful way to avoid matching is to use the Excel add-in Power Query to convert the data to the "target format".
  • Click "Split to Attribute Set".
  • Your data will be transferred to the yellow columns of the respective attribute sets and assigned directly to the "Magento attributes" using the existing formulas of your template.
  • Check once if all formulas worked and if the data was matched into the attribute cells as desired.
  • Click "Save products" to complete the process of creating new products.