Articles in this section

Supplier Address data uploads using sFTP

Melanie
  • Updated

 

You can automate Supplier Address data uploads by sending the Supplier Address CSV file templates to Unimarket via sFTP (Secure file transfer). The upload feature must be enabled by Unimarket so please contact your account manager if you would like to discuss this option and have it enabled.

 

sFTP Setup

  1. Unimarket will enable the sFTP functionality which provides a secure location to send the CSV files.
  2. Unimarket will provide the customer with the command line for connecting to the sFTP server.
  3. Authentication needs to be established. This can be via user/pw of the integration user in. Unimarket; OR via public key provided by the customer (preferred option). 
  4. Unimarket updates the sFTP setup with the public key.
  5. The customer needs to provide Unimarket with their IP address so this can be whitelisted (note you will get a timeout if this is not done). 
  6. The customer can now connect to the sFTP server using the sFTP client.

 

Loading Files

Files sent to Unimarket must be sent in order so they process correctly. This means that each file must be sent and fully uploaded (not fully processed) before sending the next file. They should not be sent all at once. Note that once uploaded, the files will be processed.

 

Files should be sent to the correct inbound folder location on the sFTP server. Details are below.

supplier addresses.png

Once processed the files will be moved to the processed folder and the relevant sub-directory beneath. 

 

File naming convention

Supplier Addresses do not have a naming convention and should just be sent to the corresponding folder on the sFTP server.

 

Expected Behavior

    • Remittance Address

      • If Address Name matches an existing address then update that record

      • If Address Name does not match an existing, then create a new Remittance Address

    • There can be only 1 Physical and Mailing address for a specific Community Supplier ID.

      • ie: if two are included in the same file, an error will be returned

    • For Registered & Premium Suppliers, the Physical and Mailing Address will not be updated

    • Only 1 Default Remittance address for a specific Community Supplier ID will be allowed.

      • ie: 2 Remittance addresses can’t both be the default.

    • Address Code is optional 

    • There is currently a maximum of 100 remittance addresses per supplier 

 

Related articles