MX Kart Forum :: Multiple options and linked quantities

 I have run into an issue that a client raised recently and I have hit a brick wall trying to find a solution to it. My client wants a clothing store which will sell many clothing lines all having quite a few options. So i designed a db structure which I thought would handle the problem.

I made a table for the product info and then made two other table's one called Selected Main Product Option and the second called Selected Sub Product Option which is linked by a foreign ID.  These are synchronised copies of the Main Tables but with the addition of a select field (check box) Example 1 attached

The idea behind this is to enable the site admin to add a new Main option  for example "Size"  and then add sub options that link to size that are stored in the Sub Options table. This would then be available to every item in the store as an option if the select field had been ticked. All this works perfect, but I over looked one part. While I can retrieve all of the main & sub options available to one product how can I store the quantity for each combination? Eg.

Product   |   Main Option  | Sub Option | Qty

I hope I am making myself clear!

Any suggestions or an alternative structure method would be most welcome

Hello,

If I understand correctly, the database structure used in MX Kart should work for you. I see that you are registered to the MX Kart product, so you should find the structure you need in the product archive.

Regards,
Razvan RACASANU

The problem is I am not using MX Kart as it is no longer supported in CS3 so I am using another cart program (webassist ecart), but this is not the the problem as i am using nextensio to make a admin side for the store.