Update primary key from Database to Salesforce

Issue 1 : How to update Salesforce using status writer when there are no fields to map with the external Id from database table.

Description: This happens when you try to integrate from Salesforce to Database, Lets say there is no external id of salesforce to map with primary key of a table in db then you will not the update status back to Salesforce.

Resolution 1: Create a rule in a process which would sync data from Salesforce to Database along with Salesforce Id.In the next step add one more rule and use update operation to bring back the Salesforce Id from database to Salesforce, this way we can successful update the status back to Salesforce.

Issue 2 : We have an external ID in order object of Salesforce (Order_external_ID__c) which should be the SeqNo that is being created in Database. So, when we create new order in Database, we get SeqNo which I need to update back Salesforce on success map which is not visible on success map.

Description : This issue occurs when an user try to hit the update select from the web-connector. The cause of this issue when an web connector is configured by an non - admin user of the QuickBooks but later the user is deleted from the QuickBooks. The error is as shown in the below image.

Resolution : SEQNO is a autonumber in Database and it should not be mapped at all as it does not hold the value we provide externally. we should map the externalID (Order_external_ID__c) to some other field in database, and then after sync we can get this value and update back to Salesforce.