Add size attributes to all products (SQL query)

[blacksymmetry]

Hello I would like to ask:
I would like to add size attributes from size XS to XXXL to all products in e-shop.

Is it possible by SQL query or something else in Prestashop?

I used Virtuemart before and there it was otherwise.

Thanks very much for help and i hope to help it anybody else.

[tomerg3]

The attribute information is store is multiple tables, so there's no simple SQL query for that.

You can try my attribute order module, it lets you sort the attributes in any order you need, and also has a feature to copy attributes from one product to another, or to all the products in a category.

http://www.prestashop.com/forums/viewthread/39687/