To improve your site’s search engine optimization, your products meta data quality and accuracy is very important. By default, Magento does a fair amount of optimization, but adding good keyword-rich content to your products meta data fields will improve your optimization further. You could do this to each product individually, but Magento provides two basic tools to accomplish this in bulk.
Exporting your products
The first step in this process is to generate a list of all your current products with their meta data. To generate this list, login to your store’s admin panel and navigate to System → Import/Export → Export.
On the next screen, select “Products” from the Entity Type drop down. If you would like to reduce the amount of information that will be exported, you may check the boxes next to the attribute name to skip them. This may be required for very large catalogs as the export file will be very large if you do not skip the attributes. At a minimum, you will need to export the “Name”, “Meta Title”, “Meta Description”, and “Meta Keywords” attributes. Sometimes you may also find it is good to export the “Description” attribute so you can reference on page content will generating your meta fields, but often the “Name” attribute is enough.
Once you have selected the attributes you want to skip, click the “Continue” button at the bottom of the page. This process may take a while to complete, but when it does you should automatically download a CSV file.
Note: You can further reduce the number of potential products you will need to write meta data for by use several filters. However, these filters will depend on how you have configured your store. In general, setting the “Visibility” attribute to “Catalog, Search” and the “Status” attribute to “Enabled” will remove disabled and variant simple products from the export. Inserting meta data for your variant products may have no impact as typical Magento configuration will only display the configurable product and not the underlying simple products.
Importing meta data
So you have exported your products, added your meta data content per product and now need to return this information to Magento. First let’s quickly cover the format of the CSV file Magento will expect you to upload.
Magento expects the header row of your file to formatted in a particular way. In this case, the columns required for import would be: sku, meta_title, meta_description, meta_keywords. Any other columns will need to be removed as well as rows that contain blank values in the sku column. The values in the header row must exactly match the “Attribute Code” from the export file. You can also find a reference to this code within the export page where you generate the file.
Next, login to your Magento admin panel and navigate to System → Import/Export → Import.
Once on the import screen, select “Products” from the Entity Type drop down, “Replace Existing Complex Data” from the “Import Behavior” drop down, and select your formatted file. Then click the “Check Data” button in the upper right.
Note: If you are importing a large amount of data you may have to split the file into multiple parts and repeat this process. You should see a tool tip on the import screen that tells you what the maximum file size for upload is.
When the check data process completes you should see a report about the number of checked entities, invalid rows and total errors with the option to import. If there are errors you will have the option to skip the rows with errors and import the rest.
After clicking the “Import” button you should see the following message.
The final step is to check the information has been stored by navigating to Catalog → Manage Products and review one of the products from your file for changes. If the changes are present you can then safely clear caches so that the new content will show on the front-end of the store.