sFTP Supplier Addresses File

  • Updated

When updating supplier profiles or addresses via automated sFTP uploads, you may receive email notifications indicating an Integration failure. This guide explains how to locate these errors and resolve the most common validation issues.

 

Sample of sFTP supplier addresses error email notification:

 

1. Locating Error Details 

If you receive an email notification regarding a failed update, follow these steps in the Unimarket portal:

  1. Go to the Administration module and select File Processing.
  2. In the Purpose field, select Supplier Address (or the relevant import type).
  3. In the State field, select Error.
  4. Locate the line item associated with the date and time, mentioned in your email notification.
  5. Hover over the blue encircled "i" icon to view the specific error message.

 

2. Common Error Definitions & Resolutions

Error MessageMeaningResolution
Vendor ID not foundThe supplier ID is not present in Unimarket, at the time the file was sent.
  • Verify the ID in your ERP matches, the Unimarket record exactly. 
  • If missing, create or correct the supplier before resending the file.
Supplier already exists

A supplier with this name and Vendor ID already exists in Unimarket.

This indicates a duplicate record within your upload file. 

  • Remove duplicates or update the file, to reference the correct supplier.
Failed to ParseThere is no data in the file, or the data within the file is corrupted/unreadable.
  • If no data: Disregard the error.
  • If data exists: Download the file from the File Processing screen, to inspect for formatting issues.

Pro-Tip: Frequent "Failed to Parse" errors on files that do contain data often point to a hidden special character or an incorrect header row in your sFTP generation script.

Supplier ID belongs to more than one supplierUnimarket encountered an ERP/Internal ID associated with two or more supplier profiles.See the "Duplicate Supplier ID" section below for resolution steps.

 

3. Resolving the "Duplicate Supplier ID" Error

This occurs when your internal ERP ID is mapped to multiple supplier profiles, in the Unimarket community.

Step 1: Confirm Multiple Profiles

  1. Go to Administration > Suppliers > Search Suppliers.
  2. In the Search Suppliers field, insert the problematic Supplier ID number.
  3. Select the "x" in the State field (to search all states, including Inactive).
  4. Click Search.

Step 2: Resolution Options

  • Change Supplier IDs: If there are multiple profiles, change the Supplier ID numbers for the profiles you do not wish to use. This breaks the link to the duplicate record.

     

4. Sync Timing and Workato

  • Same Day Resolution: If changes (like fixing a duplicate ID or reactivating a vendor) are made the same day the error file was received. The error will be resolved upon the next processing attempt.
  • Next Scheduled Upload: If changes are made after the initial error was generated, the next scheduled sFTP file upload will automatically resolve the error, in Unimarket.
  • Workato Integration: If your community has opted into Workato, the file can be resent immediately by requesting a Collaborator Role within the Workato platform to trigger a manual sync.