This problem occurred since when the data was given for migration, it was not sorted and also we don't know about the brand wise part number. based on id, some brands might have this problem when a new product is added. informed jobin