Need a macro creating to create parent items for products

I have different csv files from different suppliers and they list all products, some with colour, size or style variations (i.e. garment in sizes small,medium and large).

each variation needs to be a child and a script needs to be created to add product parents for each set of children.

for size its not too bad to work out however colour and style variations are a little harder as they vary.

Some files have plenty of columns to use but others have minimal information.

It needs to be flawless as it will be used to run on a weekly basis.