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
http://www.example.com/product-p/ID.htm
to
http://www.example.com/PRODUCT-NAME-p/ID.htm
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.
About Vikas Bhagwagar
VikasBhagwagar is Web Developer, Frontend Engineer, Interaction Designer, SEO engineer, System Admin, PSD slicer, Database Developer etc etc in-short B.E. Computer Engineer from SVNIT-Surat