Magento adds product size and inventory attribute

Question

I think this is a common situation, I sell clothes and shoes and I need to have an option for sizes and an attribute of the inventory level for each . How can i do this?

Here is an example, I sell shoes ranging in size from 41 to 45. I have 5 pairs each, except for size 45, which I have only 2. (Keep in mind that clothes and shoes do not have the same measurement parameters).

It would be great if I could do this for all products in the category at the same time, even if that means you have to go through the DB.

Thanks.

Answer 1

Creating a Custom Product

There are several steps:

• Create attributes that will be configured by the user - for our example, they will be size and color
• Create a set of attributes that will be assigned to variant products - for our example, name it “T-shirt” well
• Create individual product options
• Create a custom product and add the T-shirt attribute.
• Add standalone options to this custom product.

http://www.magentocommerce.com/knowledge-base/entry/tutorial-creating-a-configurable-product/

Adding a new attribute to a table is not difficult, but you need to find a good way to make sure that it is not dirty. You do not want to add empty attributes to make sure that you have enough space for enough products, and you do not want to have too few. I was recommended to use implode for an array to put it in a variable in which each element of the original ray is stored and separated by a symbol. Then you can place this in one column. You can find useful information for updating the magenta table: http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-6-magento-setup-resources/