How to Bulk Update your 'ProductCondition' in the Volusion Admin Panel

Take Note Volusion Customers: Froogle Requiring Product Condition 
`

I got this email from our #1 affliate to our Online Store:

Hello,

We'd like to let you know about an important change we're making to the Product Search data feed requirements. As you know, you can help shoppers find your products by including high quality, frequently updated product information in the form of attributes.  In order to provide shoppers with the most useful information, we'll be making the "condition" attribute required starting on June 30th, 2009.

In order to keep your feeds active past this date, please remember to include the "condition" attribute for all of your items if you're not already doing so.  Please include one of three values to describe your product: new, used, or refurbished.

For more information on formatting the condition attribute, please visit http://base.google.com/support/bin/answer.py?hl=en&answer=148684

` 
I took care of it ASAP and if your business depends on Google Product Search (aka Froogle) for conversions you should too before June 30th 2009 comes.
`
Here is how you do it:

1. Login to you Volusion Admin Panel
2. Click Inventory > Products > View All > Customize this View
• Check the Following: Google_Product_Type & ProductCondition
3. Click Apply Preferences

 

  

 

` 
Now you can Bulk Update your Products to the Condition they are in: (new, used or refurbished) 

Here is how in Easy Mode:

1. Click Bulk Updates
2. Set ProductCondition = New (or Used, Refurbished, only choose 1)
3. Where Google_Product_Type CONTAINS FOOBAR (replace FOOBAR with your Product Type, ie Office Supplies)
4. Click Apply Changes
   `
   

` 

Here is an example in Advanced Mode:

` 

` 

 UPDATE Products_Extended SET ProductCondition = 'New' WHERE ProductID IN (SELECT ProductID FROM Products_Extended WHERE Google_Product_Type = 'Office Supplies')

`
And there you have it. If you have any questions, post them below and I will try my hardest to help.
`
Thanks to Tasha D for her instructions.

To Learn more about bulk updating check out this video: Click Here