When an error occurs with a record in either salesforce and/or shopify , does the sync fail entirely or are other successful records allowed to pass?

No, the sync does not fail. Successful records are allowed to pass through. Any failed records are logged in the ‘Error Messages’ tab, which contains error logs for each record that encountered an issue.