Magento change product meta data by SQL Queries

Posted In: blog |

Editing contents of meta data for a big product base, can be very time consuming. But You can always use SQL…

1. Get atributte_id for meta data:

The result should be similiar to:

We’ll use the attribute_id in the next query. The backend_type determines in which table the data is kept. For example it’d be catalog_product_entity_varchar for an attribute with varchar backend_type.

2. Replace desired content with queries


Post Tags: magento | sql |


Comments Off on Magento change product meta data by SQL Queries