I just started new company and need to create 10,000 of new Skus is there any good way to relate them with the old ones for sales and purchasing reporting?

I have done a Parent Child relationship in the past

Are the old ones in netsuite? If so I would create a new field “Replaced SKU” and point the new to old. Then inactive the old