Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

FTP

Seko has a FTP location which can be utilised to receive an order file, this order file is then processed and available for customers to create returns with.

SFTP

If you have your own SFTP location, we can connect to retrieve and process an order file. These orders are then available for customers to create returns with.

Order File format

Field Name

Mandatory

Definition

OrderNumber

Y

Order number used to create order

SKU

Y

SKU of product in order

Quantity

Quantity of SKU ordered

StyleNumber

Y

Style Number of product

Category

N

Category of product

SubCategory

N

Sub Category of product

EAN

Y

EAN of product

ProductName

Y

Customer facing name of product

ItemValue

Y

Amount customer paid for x1 of the item

Currency

Y

Currency order was placed in

ItemWeight KG

Y - Either ItemWeight or OrderWeight must be supplied

Weight of product

OrderWeight KG

Y - Either ItemWeight or OrderWeight must be supplied

Weight of all products in order

CommodityCode

Y

ProductCountryOfOrigin

Y

Origin country of product

CommodityName

N

CommodityShortName

N

CustomerName

Y

Name of customer who placed the order

CustomerEmail

Y

Email address used to place order

Building

N

Building Name of delivery address

Street

Y

Street number and name of delivery address

Suburb

Y

Suburb of delivery address

State

Y

State of delivery address

Town

Y

Town of delivery address

DeliveryPostcode

Y

Postcode/zipcode of delivery address

DeliveryCountry

Y

Two letter Code of Country of delivery address. Please see table below

DateDespatched

N - If not provided, a returns window cannot be set

Date order was dispatched

Returnable

Y

Determines if product can be returned via the OmniReturns Portal
Y = Yes
N = No

SKUImage

N

URL of product image. Displays in the returns portal

SupplierName

N

Supplier name

Example file

View file
nameOrderFileExample.csv

Country Codes

Country

Code

Australia

AU

Austria

AT

Belgium

BE

Canada

CA

Croatia (Hrvatska)

HR

Cyprus

CY

Czech Republic

CZ

Denmark

DK

Estonia

EE

Finland

FI

France

FR

Germany

DE

Gibraltar

GI

Greece

GR

Hong Kong S.A.R.

HK

Hungary

HU

Ireland

IE

Italy

IT

Liechtenstein

LI

Luxembourg

LU

Netherlands The

NL

New Zealand

NZ

Singapore

SG

Slovakia

SK

Slovenia

SI

Spain

ES

Sweden

SE

Switzerland

CH

United Arab Emirates

AE

GREAT BRITAIN

GB

United States

US