Your question suggests that you are having two technical problems:
First - you are confusing the difference between:
Recording transaction data
Presenting transaction information for analysis
Second - products variants (color, size, design):
how to take these into account when making sales.
Each transaction should be recorded in a single ...