Back-end + Database Design

I am asked to provide a website that looks similar to solopress.com.

Looking at that site I can see there's categories + products but each product has mu开发者_高级运维ltiple sizes and quantities + 2 or 1 side options.

I've thought of many ways to implement this ... but always end-up producing a complex example like having to add each item multiple times or adding all items inside the product at once.

I don't see how to make it simple for a user to add products ... so I need help/ideas on the back-end design & the database side if there's something required by your idea.

Thanks in advance.

Basically, you need two tables. One for the parts, and one for the attributes. Then the parts only get entered once, and the attributes are what get added instead. It can get complex, but it works out.

Come up with a possible database structure and post it back here if you think it can be improved.

And welcome to SO!