I'm studying how to interface the zen database with a sophisticated program managing the store of a dress factory. I've installed the stock_by_attributes_4-7ajax module, and I begun to consider the color and the size of a dress.

The table `products_with_attributes_stock` contains the fields
`stock_id`,
`products_id`,
`stock_attributes`,
`quantity`

and in my test I've the values

(1, 9, '2,7', 11),
(2, 9, '3,5', 12),
(3, 9, '4,5', 13),
(4, 9, '3,6', 14),
(5, 9, '3,8', 15),
(6, 9, '1,6', 16),
(7, 9, '4,8', 0);

The first row tell me that the dress with the product_id=9 has a attribute combination of '2,7', and there are 11 dresses in stock.
Again in my example I have

2 = Grey 7 = size 44

The problem is that the number 2 is not the attribute identificator, but the position in the drop-down menu of the colors. The same thing is for the number 7.

The possibility to update the table from another program seems to be really very complicated!!!

Ha someone dealed with this problem and can give me some suggestion?

Thanks - Giovanni