RE: THE LIMIT OF OSC or the Product-Attribute-Stock problem.

This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=159180#159180
----------------------------------------------------------------

I am by no means an expert PHP developer, but I have written ASP code for over 3 years and basically it all the same. Right now my osCommerce is hacked beyond recognition. 

I have the same problem for my store. I am building an online yarn store for my wife's business. We have one type of yarn with 20 different colors. Well, actually, we have about 100 different types of yarn with close to a 1000 colors. I am testing the limits of the products attributes. My product attributes page takes a little while to load.

I spent the better part of a weekend hacking apart the inventory control to update quantity on both the product level and attribute level. While, I have not fully tested it, it seems to be working okay for me. 

To make a long story short, I used the product attribute contribution that addes the attributes to the product page. Then I added several new fields in the database for quantity, and active product attibutes. I can control whether a particular attribute is active or not, and if I sell out of a color, only that attribute is automagically made inactive. 

Give me a few weeks to pull it all together and I might be able to make it a contribution. I am considering rewriting it all with a more recent release. I really want to include that security proposal that is now included with the daily snapshot.