I want to add the Manufacturer into the Product Title like:
"Nike" Shoe XYZ or "Apple" iPhone 5s
The manufacturer
Attribute is already set in Backend. But i want to import our 15k Products via csv import.
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityI want to add the Manufacturer into the Product Title like:
"Nike" Shoe XYZ or "Apple" iPhone 5s
The manufacturer
Attribute is already set in Backend. But i want to import our 15k Products via csv import.
If you want to have it as "real magento" Product Title then you should join it during import. If it is a pure display issue, then it will be enough to adapt the templates that display product names (e.g. display/frontend/package/default/template/catalog/prodcut/view.phtml
) or for the other places (categories, sidebars, carts) alike.
There you mostly find something like $_product->getName()
. That has to be adapted to concatenate Manufacturer and Name.
If you use a helper for the manufacturer it also easy to display a product logo instead of just the manufacturer string.
$_product->getName()
will result in the concatenated information.
Oct 23, 2014 at 9:23
Maurice, it sounds as if you wish to add the product manufacturer to the product name BEFORE importing to magento correct?
So is it possible in your CSV file you have one column for "name" and one column for "manufacturer"?
If so you can concatenate the date BEFORE you load it into magento using Microsoft Excel
For example if name is column C (Red Basketball Shoe Size 14) and manufacturer is column B (Nike)
1)Make a new column D.
2)in D2, use the formula =concatenate(b2," ",c2)
3)Your end result in d2 will be "Nike Red Basketball Shoe Size 14".
4)You should then copy all of column D, and paste special just the values over all of Column C (name)
5)Make sure you then change c1 back to "name"
Now when you import into magento all your products will have Manufacturer at the beginning of the name.
By doing this BEFORE importing to magento, it will use this data in the Product Url Key (if you did not specify in your file), as well as name on product pages, and product meta page titles by default.
However the downside of this is your category / search listings will all have the manufacturer name at the front of product names too and might look very repetitive to the user's eyes.
The benefit of this approach is you do not risk injuring your magento if you are not confident in your abilities there as well as obtain the SEO benefits you are trying to achieve.