Dear Skyvia Support Team,
We are experiencing another issue during Vendor data import.
While importing records into the Vendor table, the process is validating the name against the Customer table. If the same name already exists as a Customer, the import fails with a duplicate/conflict error.
This validation is causing issues because, in our business case, a company can be both a Customer and a Vendor, and the names may legitimately be the same.
Could you please clarify:
Is this validation rule enforced by Skyvia or by the target system?
Is there a configuration setting to prevent cross-entity name validation?
What is the recommended approach to handle scenarios where the same entity exists as both Customer and Vendor?
We kindly request your assistance in resolving this issue, as it is affecting our data synchronization process.
Looking forward to your response.
Best regards,
Vijay