I basically wanted to duplicate a product and have all the same BOM information, but attach a different code. I thought a good way would be able to send the sheet to Excel, copy all the data and paste it rather than manually have to process this and save time consumption
This Tool from Adept can do it https://www.adepttools.co.uk/adept-sage-50-product-csv/