FTP or sFTP Order Integration
- Shanley Compton (Unlicensed)
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 | HS Code used by customs to determine product type |
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 |
SKUImage | N | URL of product image. Displays in the returns portal |
SupplierName | N | Supplier name |
Â
Example file
Â
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 |