stock based off of size/color

[Malkavbug]

Okay here is the problem in a nutshell, and I have been on this site for hours without seeing it brought up much (or else I have just looked at all the wrong places).

 

I am trying to help a friend fix an issue her webpage has running oscommerce

 

She runs a retail clothing store, and thus must track the same item several times due to size differences (ie, same shirt, 3 different sizes = 3 seperate items), for inventory/order purposes.

 

Here is how I am pictures the code working, but wonder if anyone has already knocked it out (I don't know much about oscommerce, so have to learn all it's ins and outs before I start modifying myself).

 

Basically scan items in the table, spit them out with no repeats based off a column. When you goto the item page it generates a drop down box with available sizes (generated by a scan where item name=, and stock = > 0, it gets all the sizes, kills repeats, generates dropdown box and values).

 

Customers selects size/color/whatever, add to cart. scripts runs saying where item= and size= and color= etc etc, add itemid to cart (I assume it is an auto incrementing number, haven't looked yet).

 

I swear I will make better posts, just been on one of those all nighters that seems to have lasted several nights. If anyone has anything similar or can point me in the right direction I would greatly appreciate it.

 

~Vincent

~Sounding like a moron but needs to type this out while he is thinking about it

[♥ecartz]

Master Products and the QT Pro contributions both do this.

 

Hth,

Matt