Mass assign default option within a BTO category.

I think I might be doing this wrong. I used BTO Products > Update Multiple BTO Products > Assign/Remove Products & Items and Update Category Settings.

I used the first one to assign a new BTO category to multiple BTO Products and then I used Update Category Settings to set the display type, to make the category required, to show product description, and to assign config settings for the category.

However, I am unable to assign a default option to the category through these menus. This means no option is selected by default, which isn't a huge deal since the javascript catches a required category with no options, but it is a hindrance since it will slow customers down and it might cost a few sales.

I will have to either manually edit each BTO Product to assign a default option for this category, or edit groups of BTO Products who's configuration settings I will then be able to assign to a few other products. Either way I'm going to have to do quite a bit of extra work.

Is there an easy way to set a default option for a bto item category among multiple products? I'm sure there is and I will look into the code now, but it would be great if someone else already figured this out.

That saves me time looking for the table to edit. I think I'll just edit the asp file so I don't have to manually change the database each time I want to do this. Should be a fairly trivial script, and I will upload here when I'm done (probably a week since I'm not currently at the office)

I'm considering adding this query:

query="UPDATE configSpec_products SET cdefault=0 WHERE specProduct=" & pcArr1(j) & " AND configProduct=" & pcv_configPrd & " AND cdefault=1;"

Before:

query="SELECT configProduct FROM configSpec_products WHERE specProduct=" & pcArr1(j) & " AND configProduct=" & pcv_configPrd & ";"

I think that would clear all defaults for that product, preventing multiple defaults.

Edited by Brett - 23-January-2011 at 10:44am

Here's an updated version of the file which addresses the issue of having to re-set the defaults. The problem nearly solved itself. Since the radio buttons on AddRmvBTOItemsMulti4.asp are all deselected by default, I modified it so that if no radios are selected, then the previous default will not be changed. However, if one of the radios is selected, then the previous default will be cleared and the new default added. It only needed one if statement. Here is the updated file. No changes besides the ones listed in this thread have been made to the file. A diff compare on the file against the latest version of the file should show the exact changes made. AddRmvBTOItemsMulti4_2.zip

This updated file allows you to set the default option when assigning BTO item options to a BTO group across multiple products.