I am making a CMS system for an e-shop.
The goal is client would be able to manage their own catalogue including categories and products.
I don't have any problem creating categories that has many products.
But I cant think of how to allow user configure their own product's attributes.
For example: a fashion store has color and size for their product, while others don't.
How to make the structure without duplicating the item record? all i can think of is having several records of the items with same name, price, summary, description but with different color and size (color and size column is customized, so may not be there also).
I hope everyone can understand what I'm trying to explain.
Please help me. Many thanks in advance.