How to generate product names and descriptions from attributes
How to generate product names and descriptions from attributes
How can I create good product names and descriptions from attributes?
Here we show you a simple Excel formula that provides a way to create e.g. product names, descriptions/short descriptions, meta titles, etc. from various existing product data, and all of this (almost) without manual effort.
As always, you can find the step-by-step guide for reference under the demo. Have fun!
Demo
Go to the English version.
Step-by-step guide
1. Create your own view
For a better overview, start by adjusting your view for editing.
For example, you can cut out important columns such as ‘Product name’ and ‘Material’ and place them at the front for greater clarity and hide attributes that are not required.
[Here you can learn more about how to create presets for your view so that you don't have to create them from scratch each time.]
2. Insert auxiliary column
Add an auxiliary column using "Insert Cell" where you can work for now.
Make sure that the cell formatting is turned off (Data -> Data Validation -> Clear All -> OK).
[Here you can learn more about how to create auxiliary columns.]
3. Insert formula
Next, we will create the formula from which the new product name will be generated. In our case, the formula is as follows:
=[@[Product Name]] &" in "& [@Color] &" aus "& [@Material]
Since your attributes likely have different names, you can assemble the formula as you need it. Also, take a look at the article below where we have explained the structure of the formula.
💡 By the way: There is an AI called Formula Botthat can explain to you exactly what your custom formula consists of and how you can modify it. It's very simple: Click on their page on "Explain" and then paste your formula. The tool will then generate an explanation of the individual components of your formula.
Here you will find the exact explanation of our example formula.
What does the formula do?
The formula creates a text that combines the values from three columns: "Product Name," "Color," and "Material." It also adds words like "in" and "made of" to make the text more understandable.
Structure of the formula
Formula: =[@[Product Name]] &" in "& [@Color] &" aus "& [@Material]
- =: An Excel formula always starts with an =
- [@[Product Name]]: This means that Excel uses the value from the "Product Name" column in the same row where you insert the formula. The "@" indicates that only the current row is being considered.
- &: This is the concatenation operator in Excel. It combines two texts.
- "in": This is a fixed text, so just the word "in" should be inserted into the sentence.
- [@Color]: Here, Excel retrieves the value from the "Color" column, also in the same row.
- & "made of": Again a fixed text, this time "made of", which is also inserted into the sentence.
- [@Material]: Finally, the value from the "Material" column in the current row is added.
Example
Assuming the values in a row of your table are:
- Product Name: „T-Shirt“
- Color: „Red“
- Material: „Cotton“
Then the formula would generate this text: "T-shirt in red made of cotton"
Summary
- The formula combines content from multiple columns in your table.
- Fixed texts ("in", "made of") ensure that the text becomes readable.
- Each row of your table generates a complete sentence with this formula.
4. Perform process for remaining lines
After pressing ENTER, the formula will be applied. Also, click on the small square in the bottom right corner of the cell or drag it down to the last row so that the formula is also applied to the other rows.
5. Copy values and paste into the "Product name" column
The new names are not yet in the shop, as the values are currently still in the auxiliary column. In order to transfer them to cobby, copy the values and then paste them into the "Product Name" column.
Please NOTE: Use the second icon from the left (with 123) under Paste Options here to add only the values and not(!) the formula.
6. Save workbook OR "Save products" and live
If you do not want to transfer the data to the shop yet, you can use the cobby Offline Hack.
Learn more about it here.
If you want the changes to be online immediately, click on "Save Products." The changes are now being recognized in cobby and will be transferred, which is why the status of the products changes to yellow.
... done!
If the changes were successfully applied, you will now see the newly generated product names in the "Product name" column, which are composed of attributes such as material, etc., and of course also directly in your shop.
Tip (especially for SEO): You can do this for the product description and many other fields as well!
Momentan sind keine Kommentare vorhanden.