Hi all,

I was so enthusiastic about converting my shop to the latest version of Zencart that I didn't pay close enough attention to setting up the default display-only size attribute when setting up my products.

As a result, test orders revealed that it was possible to head to checkout without actually selecting a size. I fixed this by creating a default display-only attribute option "Select..." on a dummy product and then copying this new attribute to all my categories. (Thanks sooooo much to the all the forum posters who detailed this fix in other threads like this one)

Unfortunately it wasn't a complete fix as it looks like ALL my size attributes have a setting of 'default' - so the pre-selected size turns out to just be last one on every product page.

I've been going through my products in admin and poking the orange button to fix this on individual pages, but I was wondering if there is a faster way to fix this through phpMyAdmin?

Is it possible to do a batch update in phpMyAdmin of all the

Small
Medium
Large
X-Large

... attributes on the site so that none of them are set as default?

This post seemed to be close to what I needed to know, but not entirely.

Thanks in advance.