Magento add product size and attribute inventory

denislexic picture denislexic · Jun 28, 2012 · Viewed 17.1k times · Source

I think this is a common situation, I'm selling clothes and shoes and I need to have an option for sizes and attribute an inventory level for each. How could I do that?

Here is an example, I m selling shoes in sizes 41 to 45. I have 5 pairs of each except the size 45 which I only have 2. (Keep in mind that clothes and shoes don t have the same measurement options).

Would be awesome if I could do it for all products in a category at the same time, even if that means having to go through the DB.

Thanks.

Answer

Sturm picture Sturm · Jun 28, 2012

Creating a Configurable Product

There are a few steps involved:

  • Create the attributes that will be configurable by the user - for our example they will be Size and Color
  • Create the attribute set that will be assigned to the variant products - for our example, we’ll call it “T-shirt”
  • Create the individual variant products
  • Create the configurable product, and add the “T-shirt” attribute set
  • Add the individual variants to this configurable product

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

Adding a new attribute to the table isn't to difficult, but you need to find a good way of making sure it's not dirty. You do not want to add empty attributes to make sure you have room for enough products and you don't want to have too few. I was recommended using implode on an array to put it into a variable in which each element of the original ray is stored and separated by a character. You could then put this into one column. You can find some good information for updating a magento table here: http://www.magentocommerce.com/knowledge-base/entry/magento-for-dev-part-6-magento-setup-resources/