Change in Parent ID increasing by one number for an ERP web

HI All,

I am currently facing an issue, when i am trying to automate excel upload to a web ERP, where we are having multiple Raws and column’s in the excel. currently I am using for each row logic to pick the data in from excel, and inserting it with set text which i have mapped to the fields in web ERP.
And after inserting the first lines data into Web, the parent ID changes when it enters to the second line, due which the process is getting stuck. Is there any way if we can pre define the parent id by adding +1 logic or do we have a different approach there.

Please let me know.
Thanks in advance!