FlexIT¶

FlexIT Distribution is a European IT distributor specializing in refurbished and circular IT equipment. They offer a broad range of certified refurbished devices including smartphones, laptops, and tablets. FlexIT provides a drop-ship service, with offer feeds delivered via SFTP and orders submitted via REST API.

Website

flexitdistribution.com
Drop-ship

Direct shipment from Refurbisher to end customer
Feed Type

SFTP — CSV file transfer
Currency

EUR

Status¶

Artifact	Acceptatie	Productie
Refurbisher	`ID: 15` · → IRP	`ID: 15` · → IRP
Supplier	`ID: 10` · → IRP	`ID: 10` · → IRP
Offer connector	SFTP · CSV · SFTP credentials · →	SFTP · CSV · SFTP credentials · →
Order connector	Web POST · Client credentials · →	Web POST · Client credentials · →
Shipment webhook	Not configured	Not configured

IRP¶

Field	Value
Refurbisher ID	`15`
Supplier ID	`10`
Odoo Vendor ID	`21469`
Currency	`EUR`
Shipping Costs	`€10.00`
Home Copy Tax	`€3.18`
Default Margin	`17%`
Stock Threshold	`1`
Approved Refurbished	Yes
Drop-ship	Yes

Monitoring Thresholds¶

Metric	Threshold
Latest order (hours)	`48`
Offers stock (hours)	`48`
Open order (days)	`4`
Offers endpoint HTTP status	`200`

Refurbisher Connector Config¶

config/refurbishers.json

"flexit": {
  "name": "flexit",
  "refurbisher_id": 15,
  "offers": {
    "connection": "sftp",
    "auth": {
      "host": "sftp.flexitdistribution.com",
      "path": "Outbound/FlexIT_Feed.csv",
      "username": "xmlorder_218535",
      "password": "XXXXXXXXXXXXXXX"
    },
    "type": "csv",
    "separator": ";",
    "heading": true,
    "price_locale": "nl_NL",
    "mapping": {
      "name": "Description",
      "sku": "Flex IT Part Number",
      "stock_available": "Stock Quantity",
      "ean": "EAN",
      "price_purchase_amount": "Sales Price",
      "price_consumer_amount": "SRP"
    }
  },
  "order": {
    "connection": "web",
    "endpoint": "https://api.flexitdistribution.com/order/api/order",
    "auth": {
      "type": "client_id_secret",
      "client_id": "XXXXXXXXXXXXXXX",
      "client_secret": "XXXXXXXXXXXXXXX"
    },
    "order_object": {
      "customerNumber": "!(int)218535",
      "yourReference": "order.order_number",
      "externalDocumentNumber": "(string)id",
      "currencyCode": "!EUR",
      "shipping.isBlindShip": "!(bool)true",
      "shipping.contact.name": "orderShippingAddress.full_name",
      "shipping.contact.email": "!no-reply@iused.nl",
      "shipping.contact.phoneNumber": "!0612345678",
      "shipping.address.postalCode": "orderShippingAddress.zipcode",
      "shipping.address.name": "orderShippingAddress.full_name",
      "shipping.address.countryCode": "orderShippingAddress.country->getIsoAlpha2",
      "shipping.address.city": "orderShippingAddress.city",
      "shipping.address.addressLine1": "orderShippingAddress.full_address",
      "lines": "%ITEMS%"
    },
    "item_object": {
      "sku": "productVariant.refurbisherOffer.sku",
      "quantity": "quantity",
      "unitPrice": "(float)unit_price_tax_excl->formatByDecimal"
    },
    "response_object": {
      "asserts": { "status": "in:201", "OrderNumber": "present|filled" },
      "fields": { "externalOrderReference": "OrderNumber" }
    }
  }
}

API Integration¶

FlexIT uses SFTP for offer retrieval (CSV) and a REST API for order submission, secured with Client ID / Client Secret authentication.

Credentials

Stored in 1Password under iUsed - IRP - Refurbisher: FlexIT.

Authentication Endpoints Offer Feed Order Response

Offer feed (SFTP): Username/password authentication.

Field	Value
Host	`sftp.flexitdistribution.com`
Path	`Outbound/FlexIT_Feed.csv`
Username	`xmlorder_218535`
Password	Stored in 1Password

Order API: Client ID / Client Secret authentication.

Field	Value
Client ID	Stored in 1Password
Client Secret	Stored in 1Password

Method	Endpoint	Description
`SFTP GET`	`sftp.flexitdistribution.com/Outbound/FlexIT_Feed.csv`	Retrieve offer feed (CSV)
`POST`	`https://api.flexitdistribution.com/order/api/order`	Submit a new order

The offer feed is a CSV file retrieved from an SFTP server.

Field	CSV Column
Name	`Description`
SKU	`Flex IT Part Number`
Stock	`Stock Quantity`
EAN	`EAN`
Purchase Price	`Sales Price`
Consumer Price	`SRP`

Format details

Connection: sftp
Separator: ;
Has heading row: Yes
Price locale: nl_NL

Assert	Rule
`status`	`in:201`
`OrderNumber`	`present\|filled`

The OrderNumber field is stored as the external order reference.

Blind shipment

Orders are submitted with shipping.isBlindShip: true — the shipment will not reveal iUsed's identity to the end customer.