Send orders via FTP
You can transfer orders to Lagersystem via FTP using our XML order format. Each file describes one order. It is preferred that each file be named ordernumber.xml. The file must be in Unicode UTF-8 format.
The order files are uploaded to a folder on the FTP server called new-orders. Once Lagersystem has imported the file, it will automatically be removed from the FTP folder.
You can get the login details for the FTP server from your contact person at Lagersystem.
Before specifying any particular payment or shipping solutions, make sure your Lagersystem is configured to use that solution. For example, if you want to use PostNord for your orders, your API credentials for Pacsoft must be set up in Lagersystem. If you need help with this, feel free to contact us.
Below you will find a table with all supported data fields and their possible values.
You can download an example order file here:
| Field | Data type | Required? | Description |
|---|---|---|---|
| OrderID | Integer | Yes | Numeric order identifier, must be unique. Max integer 2147483647 |
| OrderTimestamp | Datetime | Yes | Timestamp for initial order placement. Format YYYY-MM-DD HH:MM:SS |
| Customer → Name | String | Yes | Name of customer (or contact if company) |
| Customer → Address | String | Yes | Streetname and number etc. |
| Customer → Address2 | String | No | Street 2 |
| Customer → City | String | Yes | Cityname |
| Customer → ZipCode | String | Yes | Zipcode of customer |
| Customer → Email | String | Yes | Valid email of customer |
| Customer → Phone | String | No | Phone no. |
| Customer → CompanyNumber | Integer | No | VAT No in case of company |
| Customer → CompanyName | String | No | Name of company |
| Customer → CountryID | String | Yes | ISO 3166-1 alfa-2 country identifier |
| ShipTo → Name | String | Yes | Recipient name or contact |
| ShipTo → Address | String | Yes | Delivery street |
| ShipTo → Address2 | String | No | Delivery street2 |
| ShipTo → City | String | Yes | Delivery city |
| ShipTo → ZipCode | String | Yes | Delivery zipcode |
| ShipTo → Email | String | Yes/No | Email for pickup person. Mandatory for deposit services. |
| ShipTo → Phone | String | Yes/No | Phone for pickup person. Mandatory for deposit services. |
| ShipTo → CompanyName | String | No | Name of company |
| ShipTo → CountryID | String | Yes | Country of shipping destination. ISO 3166-1 alfa-2. |
| ShipTo → DepositID | Integer | No | Numeric identifier of the deposit/parcel shop/pickup point |
| InternalNote | String | No | Internal note for warehouse staff, ie. ”order has been delayed, please add free items” or ”dont ship until monday”. |
| ShipmentNote | String | Yes/No | Note from customer to add on shipment label, mandatory for shipment types with hand-off if not home. |
| Ref | String | No | Additional Reference |
| CurrencyCode | String | Yes | Currency of order. |
| ShippingPrice | Price | Yes | Price charged for shipment. Can be 0 if not charged. |
| OrderTotal | Price | Yes | Grand total of order including shipping price, payment fees and VAT. Important for orders that need live payment capture. |
| Payment → Type | Enum String | Yes | Possible types are: – nopayment – quickpay – epay – dandomain – icepay – klarna – paymill |
| Payment → TransactionID | String | Yes/No | Mandatory for all payment types except NoPayment. |
| ShipmentType | Enum String | Yes | See table below. |
| Lines → Line → Title | String | Yes | Product title |
| Lines → Line → UnitPrice | Price | Yes | Product price per unit. |
| Lines → Line → VatPct | Integer | No | VAT amount for item, defaulting to 25% if not present. |
| Lines → Line → Itemnumber | String | Yes | Itemnumber of product. |
| Lines → Line → UOM | String(10) | No | Unit of Measurement (Default STK) |
| Lines → Line → Amount | Integer | Yes | Quantity of product |
| Lines → Line → ImageURL | URL | No | If present, an product image will be displayed for warehouse personnel when picking order. |
| Lines → Line → TextLine | Boolean | No | If present, the line will be considered a textline. |
Shipping types
| Code | Description | |
|---|---|---|
| postdk_direct | => | PostNord Home delivery |
| postdk_pickup | => | PostNord Parcel shop |
| postdk_erhverv | => | PostNord Business |
| postdk_varebrev | => | PostNord Small Parcel – International |
| gls_direct | => | GLS Home delivery |
| gls_pickup | => | GLS Parcel shop |
| gls_erhverv | => | GLS Business |
| bring_direct | => | Bring Home delivery |
| bring_pickup | => | Bring Parcel shop |
| bring_erhverv | => | Bring Business |
| dao_direct | => | DAO356 Home delivery |
| dao_pickup | => | DAO356 Parcel shop |
| dfm | => | Danske Fragtmænd |
| ups | => | UPS International |
| dhlexpress | => | DHL Express |
| pickup | => | Pickup |