Same IDs for duplicate values

[nostobunaev]

I have a transaction sheet for different products.
I would like to assign an additional ID for them, where there would be the same ID for the same products(and their options). Conversely, for unique products(and their options), a unique ID.

Something like this:

Item ID |   Product   | Color   | Size | Count    |

     1         | ProductB  | Yellow | M     |  Single   |

     2         | ProductB  | Yellow | M     |  Bundle |

     2         | ProductB  | Yellow | M     |  Bundle |

     3         | ProductA  | Yellow | S       |  Single  |

     1          | ProductB  | Yellow | M     |  Single   |

And as you can see, 

ProductB with options Yellow, M, Bundle should have the same ID,

while ProductA with options Yellow, S, Single should have a different ID.

[Joseph_Seddik]

Please read these guides:

Data: The Essentials | AppSheet Help Center 

References Between Tables | AppSheet Help Center