Ulf Dittmer wrote:I'm not sure I understand what you're asking, but each product will have variables. In a relational DB, those might be modeled as attributes.
i'am trying to modeling something that can handle different product variant but stuck on a complete solution
here what i have done now :
OptionGroups (ID , Name) such (1, size) , (2 , color)
Options (ID , Name , IDOptionsGroups) such (1, Medium , 1) , (2 , Large , 1) , ( 3, Blue, 2)
Product(ID , SKU , ParentSKU , Title , Attriboptions1 , Attriboptions2, price , qte ) such
(1, 20 , null , tshirt , null , null , null , null )
(2, 20_1 , 20 , tshirt , 1 , 3 , 15 , 50 ) #tshirt blue medium
but problem some product can have only one attribut like color or size or so
Thank you