Creating a product database in lists (Best practices and where to start?)

Hi,   I am currently creating a database of our products in SharePoint lists. I have a hard time figuring out where it is ideal to split parts into multiple lists, where to use multiple value look-...