VIDEO: Bulk Data Updates (1/1): How to Make Bulk Data Updates



Volusion's Bulk Updates feature allows you to update multiple records in an Admin Area database table at once. Bulk updates are possible on most tables in your Admin Area under the Settings drop-down menu.

Changes made with your bulk update tool cannot be undone, so before you run a bulk update, be sure to export your table to a spreadsheet in case you make an error and need to re-import the original data. For more information on exporting, see our video called How to Export Store Data.

Now let’s talk about some of the practical reasons you may need to run a bulk update. For example, if you'd like to offer free shipping on items that cost 100 dollars or more, you can make this change quickly by selecting FreeShippingItem from the Set menu. In the text box to the right, we'll enter a capital "Y" for "yes" That’s the value we want the fields to assume. Since we only want free shipping to apply to certain products, we'll use the Where clause to refine our query by specifying a data sub-set – in this case, the ProductPrice field.

Use the dropdown in the middle to specify the relationship between the field you just chose and the value you'll enter to the right. In our case, we'll choose Is Greater Than. Finally, because we want products that cost 100 dollars or more to qualify, we'll enter “99.99” here. Once we apply this query, the Free Shipping Item variable will be set to “yes” on products with a price greater than $99.99.

If you understand SQL syntax, can you click Preview Query to view and edit the SQL statement before it’s executed. Keep in mind that improper SQL syntax can corrupt your data beyond repair.

You can also add this query to the QueryBank by specifying a name and clicking Add. For more information on the Query Bank, see our video called How to Use Saved Exports. Let’s quickly generate the same query again to see the results. Now, we can see the "Y" value in columns with a product price of $99.99 dollars or more.

In the Advanced View, you can generate your own queries from scratch.

As another example, suppose you need to raise the price of all products from a certain manufacturer by 10%. First, let’s add the Product Manufacturer column to the table so we can see our update when it’s finished. Select Customize Columns from the Settings dropdown, then select Product Manufacturer and click Apply Changes.

Next, we'll apply the same value to the top two products by clicking the Edit icon on this column.

Now, in the bulk update tool, set the ProductPrice to 110% of its current value by entering "ProductPrice * 1.1".  The asterisk symbol is a mathematical multiplier in SQL. In the Where clause, set the ProductManufacturer field to Equal the column name we just entered.

After applying the query, we can see that the prices for that manufacturer's products are 10% higher than they were, and all other prices are unchanged.

Likewise, if you want to lower all prices for a manufacturer's products by 10%, use the same query but substitute "0.9" for "1.1". Now, the prices are 90% of what they were previously. With a little creativity, you can use this tool to drastically reduce your workload.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request