Volusion Software has a feature of interacting Microsoft SQL database with SQL queries. You could mass update your products using SQL queries. In this simple tutorial, we will see how to update thousand of products attributes at once to perform SEO tasks quickly.
Let’s we want to achieve two tasks here.
- Mass Updating product title tags in volusion shopping cart software with store url appended.
- Mass Updating product url-slugs (you need to activate Enable SEO Friendly URIs before) that include products name in clean urls
Mass Updating title tags
- Login to your volusion admin panel
- Find Inventory Menu and Choose Products
- Find “Bulk Updates” link at top right of your products table and click it
- Then click “Switch To Advanced View” in “Bulk Updates” dialog box and copy paste following SQL.
UPDATE Products_Joined SET METATAG_Title = ProductName + ' - example.com'
- Click “Apply Changes”
Mass Updating URL structure for products
To change product url from
Use following SQL Query to mass update safely.
UPDATE Products_Joined SET ProductNameShort = SUBSTRING (ProductName,0,49)
Above SQL query will make ensure that ProductNameShort won’t go beyond its limit of 50 letters.