Adding words to over 4,000 products, does it have to be done manually?

Question

I have a magento store that sells products but in the meta description of every single product I want it to be formatted like this.

Product Name 1 Product Name 2 Product Name 3

Is there any possible way I could add automatically do this instead of manually?

Changing it to:

Sell Product Name 1 Here Sell Product Name 2 Here Sell Product Name 3 Here

I want to add words to the beginning and the end automatically of every single listing if possible, if anyone knows a way please let me know. Manually doing this would be a two year job.

Answer 1

To expand on pspahn's solution, I would do the following:

Create a one-off PHP script in the magento root folder called 'script.php' (or whatever you want).

<?php
require_once 'app/Mage.php';
Mage::app('default');

$products = Mage::getModel('catalog/product')->getCollection();
$products->addAttributeToSelect('meta_title');

foreach ($products as $product) {
    $product->setMetaTitle('Sell '.$product->getMetaTitle().' Here');
    $product->getResource()->saveAttribute($product, 'meta_title');
}

Then from bash (while current directory is magento root folder), run

php script.php

$product->getResource()->saveAttribute() is MUCH faster then calling save() on the original model, so your script would finish in I would guess about a tenth of the time. Also, I doubt the actual attribute is meta_title, probably description, or meta_description, so change the script accordingly.

Answer 2

You can do this with the "Update Attributes" feature of the Magento Catalog grid.

1. Navigate to Catalog > Manage Products

2. Select the products you wish to update with the checkbox, select Update Attributes from the dropdown and then click Submit

   

3. Update meta keywords and click Save

   

Answer 3

You can rewrite block catalog-product-view and add the prefix and posfix for metas in the _prepareLayout method.

Answer 4

If your intention is to do this just once (since you want to change all the products to the new meta title) you can use something like the following (haven't tested this, and with thousands of products, it'll probably take a bit to finish):

$products = Mage::getModel('catalog/product')->getCollection();
$products->addAttributeToSelect('meta_title');

foreach ($products as $product) {
    $oldMeta = $product->getMetaTitle();
    $newMeta = "Buy " . $oldMeta . " Supplements Online"
    $product->setMetaTitle($newMeta);
    $product->save();
}

You could run this from your own module, as an external script, whatever you want. I've actually run some things like this just from whatever template I happen to have open. You're running it once and then getting rid of it.

Note that there are some spots if you place this code it will run multiple times for a single page load. Leaving you with something like "Buy Buy My Product Supplements Online Supplements Online". Make sure it is run just once.