test
 

1. Ordering via SFTP

sftp
Order Process

This document describes the order process for customers who wants to use XML Ordering via SFTP. The XML Order process consist of three types of messages interchanging between the SFTP.

1. Productfeed

2. CreateSalesOrder

3. Invoicefeed

2. Product feed

By default, we share our product feed as a Comma Separated Value (.CSV) file format, semicolon (;) delimited and point (.) as decimal separator.

File name, products_{YourCustomerNumber}: products_123456.csvLine 1, header: Manufacturer part number, Product name, Main category, Sub category, Manufacturer name, EAN, Price, Quantity in stock, Condition, SKU, Product URL, Image URL, CNET IDLine 2 and on: Products

A new product feed will be available every 3 hours on SFTP in the Outbound folder.

Our products
Product status or condition:
  • New - New Products

  • N2 - New Bulk

  • N3 - New Spares

  • B2 - Bulk

  • W1 - Renew Gold

  • W2 - Renew Silver

  • W3 - Factory refurbished

  • A1 - Approved Selection One

  • A2 - Approved Selection Standard

  • A3 - Approved Selection Budget

  • R4 - Refurbished

  • D1 - Demo

  • D2 - Demo

  • M2 – Remanufactured

Click here for more information.

3. Example feed

SKU;Condition;Manufacturer part number;EAN;Manufacturer name;Product name;Main category;Sub category;Price list 1;Quantity in stock;Product2163926R4;R4;CP-7905G-REF;7898362231124;Cisco;"Cisco IP Phone 7905G - VoIP phone - H.323, SCCP, SIP - single-line";Telephones;Phones2252356R4;R4;7034-SB1-REF;;Lenovo;"M91p MT i5-2400/4GB/250GB/DVDRW/W7P COA #4.1";Computers;Desktops;1137.00;1;"http://www.x2212980R4;R4;LJ427AV-NL-SB65-REF;;HP;"HP EliteBook 8460p - 14"" - Core i5 2520M - 4 GB RAM - 250 GB HDD";Computers;Notebooks;22672235927R4;R4;QV997AV-SB34-REF;;HP;"HP Compaq Elite 8300 - ultra-slim desktop - Core i5 3470S 2.9 GHz - 4 GB - 320 GB";Computers;Desktop2121363R4;R4;491335-421-REF;0000491335421;Hewlett Packard Enterprise;"HPE ProLiant DL380 G6 High Efficiency - rack-mountable - Xeon L52265739R4;R4;42D0633-REF;5704875096377;IBM;"Lenovo - Hard drive - 146 GB - hot-swap - 2.5"" SFF Slim - SAS - 15000 rpm - FRU, (CRU) - T2237179R4;R4;7010DT-I3-3240/3-REF;;Dell;"Dell OptiPlex 7010 - DT - Core i3 3240 3.4 GHz - 4 GB - 250 GB";Computers;Desktops;928.00;43;"ht2234284R4;R4;SFP-H10GB-CU1M=-REF;0882658210723;Cisco;"Cisco SFP+ Copper Twinax Cable - direct attach cable - 1 m";Cables;Remaining C2260058R4;R4;CAB-RPS-1414-REF;;Cisco;"Cisco - Power cable - 14-pin RPS Connector (M) to 14-pin RPS Connector (M) - 1.2 m - for Redundant P2260310R4;R4;E734-I3-4000M-SCA/4-REF;;Fujitsu;"E734 i3-4000M/4GB/500GB/13.3"" - HD/W8P COA WLAN/BT/CAM";;;2076.00;3;"http://ww

4. Layout

column Description Additional Values
SKU Reference code for ordering 7 digits plus our status code
Condition Our product status code/condition New,N2,N3,B2,W1,W2,W3,A1,A2,A3,R4,D1,D2,M2
Manufacturer part number Reference code from manufacturer
EAN 13-digit EAN / ISBN number 13 digits. (If less than 13, supplement with leading zeros)
Manufacturer name Manufacturer name
Product name Product name Starts and ends with quotation marks: “text……..”
Main category Main category
Sub category Sub category
Price Our selling price
Quantity in stock Quantity in stock
Product URL URL to our product page Starts and ends with quotation marks: “http……..”
Image URL URL to our product image Starts and ends with quotation marks: “http……..”
CNet ID With the CNet ID you can connect to CNet and retrieve full product information

5. Create sales order

To create a sales order in our system. An XML file needs to be send to our SFTP. This *.xml file must be put into the Inbound folder where it’s picked up and processed. When the order is picked up by our system a Response message is created in the Outbound folder. Response messages with status ACK means the order is accepted by our system. In case of a response status NACK the order has been reject by any reasons. Please contact your account manager for support in case you can’t solve the issue yourselves.

Below are the XSD schemas for the technical implementation of the interface

XSD Order Request
sftp
Example XML Order Request
sftp
XSD Order Response
sftp
Example XML Order Responses
NACK:
sftp
ACK:
sftp

6. Invoices

To create a sales order in our system. An XML file needs to be send to our SFTP. This *.xml file must be put into the Inbound folder where it’s picked up and processed. When the order is picked up by our system a Response message is created in the Outbound folder. Response messages with status ACK means the order is accepted by our system. In case of a response status NACK the order has been reject by any reasons. Please contact your account manager for support in case you can’t solve the issue yourselves.

XSD Invoices
sftp
Example XML Invoices
sftp

7. SFTP Setup

SFTP:

On the SFTP location two folders exist. ‘Inbound’ and ‘outbound’

Inbound: XML request messages can be placed in this folder by the customer Outbound: XML response messages for the customer. Like the Product feed, Order responses and Invoices will be placed in this folder.

For example: To download the product feed the directory should be sftp://ftp.flexitdistribution.com/outbound.

If you have any questions, please contact your personal account manager or reach us via our general phone number.

Request SFTP access:

Please contact your personal account manager or reach us via our general phone number/E-mail.