Hello,

Currently we update our accounts on salesforce by an automatic batch that use data loader.
We do an insert of our new accounts each day.
Then we recuperate the salesforce ID for each account.
And finally we do an update of accounts.

We would like to use the functionnality upsert to simplify the treatment. We can create an external ID on salesforce with our ID to use upsert.
I doesn't test this part but I have no problem with this.
My problem is because we have a hierarchical field on account.
So if we use our id for an upsert I still need the Salesforce id for the hierarchical field. 
Could we use the external id (our id) for the hierarchical information too please? And how can I do that?

Thanks for your help.

Hello,

Currently we update our accounts on salesforce by an automatic batch that use data loader.
We do an insert of our new accounts each day.
Then we recuperate the salesforce ID for each account.
And finally we do an update of accounts.

We would like to use the functionnality upsert to simplify the treatment. We can create an external ID on salesforce with our ID to use upsert.
I doesn't test this part but I have no problem with this.
My problem is because we have a hierarchical field on account.
So if we use our id for an upsert I still need the Salesforce id for the hierarchical field. 
Could we use the external id (our id) for the hierarchical information too please? And how can I do that?

Thanks for your help.