Import product data

Hi

We have been through the sample data file. We are quite familiar with importing and exporting product data. The issue we have is that our source data has 3.5k individual products and they are all slightly different, some have 83 different colours and some only 3 or 4.

We can not see which field to add the hex codes in the data base to create the swatches.

Can you help please?

Thanks, Steven