we handled it in 2 different ways in two different projects.
one was to evry time change the variable to "Stag" or "prod" before execution in your batch file or in your global excel ,so based on that variable it will fetch the prodURL or STageURl, so all your prod and stage variables can be in the very first row of your data sheet
second way was more tedious , to maintain than execute ,we maintained two different sets with almost same scripts but different datsheet ,
first set contained details of Prod
second contained sTAG,
the folder structure and every thing was named accordingly and we use to run different folder for different environments
one was to evry time change the variable to "Stag" or "prod" before execution in your batch file or in your global excel ,so based on that variable it will fetch the prodURL or STageURl, so all your prod and stage variables can be in the very first row of your data sheet
second way was more tedious , to maintain than execute ,we maintained two different sets with almost same scripts but different datsheet ,
first set contained details of Prod
second contained sTAG,
the folder structure and every thing was named accordingly and we use to run different folder for different environments