Description:
This process is used to import orders to Speed4Trade CONNECT. For this purpose, Speed4Trade CONNECT provides an XML format for orders.
Fieldlist:
Name |
Type |
Cardinality |
Max Length |
Description |
---|---|---|---|---|
orders |
Element |
1 |
|
Wrapper element that combines the data of an order. It can contain several order-nodes. |
order |
Element |
1..N |
|
Wrapper element that contains all the data of one order. |
external_order_number_1 |
string |
0..1 |
100 |
First external order number, e.g. ERP order number. Can be used for order matching. |
external_order_number_2 |
string |
0..1 |
100 |
Second external order number, e.g. ERP order number. Can be used for order matching. |
transaction_id_1 |
string |
0..1 |
70 |
First payment transaction id. Can be used for order matching. |
transaction_id_2 |
string |
0..1 |
70 |
Second payment transaction id. Can be used for order matching. |
marketplace_order_id_1 |
string |
0..1 |
50 |
First marketplace order id. Can be used for order matching. |
marketplace_order_id_2 |
string |
0..1 |
50 |
Second marketplace order id. Can be used for order matching. |
order_date |
datetime |
0..1 |
|
Timestamp when the order was placed on the trading platform. |
dispatch_provider_identifier |
string |
0..1 |
100 |
Identifier of the dispatch provider. |
dispatch_provider_external_id |
string |
0..1 |
100 |
External ID of the dispatch provider. |
currency_code_iso |
string |
0..1 |
|
Current currency of the order in ISO 4217. |
payment_method_charge |
decimal |
0..1 |
|
A fee for the payment method. |
payment_method_identifier |
string |
0..1 |
|
Identifier of the payment method |
cash_on_delivery_charge |
decimal |
0..1 |
|
An extra fee for cash on delivery. |
customer_type_identifier |
string |
0..1 |
|
Identifier of the customer type. See table of values below for further description. |
customer_number |
integer |
0..1 |
10 |
Customer number of Speed4Trade CONNECT. |
customer_external_id_1 |
string |
0..1 |
50 |
First external customer id. |
customer_external_id_2 |
string |
0..1 |
50 |
Second external customer id. |
customer_country_code_iso |
string |
0..1 |
|
Country code of the customer in ISO 3166-1 alpha-2. |
invoice_number |
integer |
0..1 |
10 |
Invoice number of Speed4Trade CONNECT. |
invoice_salutation_identifier |
string |
0..1 |
|
Identifier of salutation in invoice address. See table of values below for further description |
invoice_title |
string |
0..1 |
|
Title in invoice address. |
invoice_company_name |
string |
0..1 |
200 |
Company name in invoice address. |
invoice_first_name |
string |
0..1 |
200 |
First name in invoice address. |
invoice_last_name |
string |
0..1 |
400 |
Last name in invoice address. |
invoice_street |
string |
0..1 |
400 |
Street in invoice address. |
invoice_house_number |
string |
0..1 |
100 |
House number in invoice address. |
invoice_street_addition |
string |
0..1 |
400 |
Additional street field in invoice address. |
invoice_postal_code |
string |
0..1 |
100 |
Postal code in invoice address. |
invoice_city |
string |
0..1 |
400 |
City in invoice address. |
invoice_country_code_iso |
string |
0..1 |
|
Country code in invoice address in ISO 3166-1 alpha-2. |
invoice_phone_number |
string |
0..1 |
50 |
Phone number in invoice address. |
invoice_email_address |
string |
0..1 |
100 |
Email address in invoice address. |
delivery_salutation_identifier |
string |
0..1 |
|
Identifier of salutation in alternative delivery address. See table of values below for further description |
delivery_title |
string |
0..1 |
|
Title in alternative delivery address. |
delivery_company_name |
string |
0..1 |
200 |
Company name in alternative delivery address. |
delivery_first_name |
string |
0..1 |
200 |
First name in alternative delivery address. |
delivery_last_name |
string |
0..1 |
400 |
Last name in alternative delivery address. |
delivery_street |
string |
0..1 |
400 |
Street in alternative delivery address. |
delivery_house_number |
string |
0..1 |
100 |
House number in alternative delivery address. |
delivery_street_addition |
string |
0..1 |
400 |
Additional street field in alternative delivery address. |
delivery_postal_code |
string |
0..1 |
100 |
Postal code in alternative delivery address. |
delivery_city |
string |
0..1 |
400 |
City in alternative delivery address. |
delivery_country_code_iso |
string |
0..1 |
|
Country code in alternative delivery address in ISO 3166-1 alpha-2. |
delivery_phone_number |
string |
0..1 |
50 |
Phone number in alternative delivery address. |
on_hold_reason_note |
string |
0..1 |
|
Note to the on hold reason. |
on_hold_reason_identifier |
string |
0..1 |
|
Identifier of the on hold reason. This can be one out of the table of values below or an individual reason. |
dispatch_type_identifier |
string |
0..1 |
100 |
Name of the individually managed dispatch types in Speed4Trade CONNECT. |
dispatch_type_external_id |
string |
0..1 |
100 |
External id of dispatch type. |
dispatch_handling_identifier |
string |
0..1 |
100 |
|
price_type_identifier |
string |
0..1 |
|
Identifier of the price type. See table of values below for further description. |
order_status_identifier |
string |
0..1 |
|
Identifier for order status. See table of values below for further description. |
payment_status_identifier |
string |
0..1 |
|
Identifier for payment status. See table of values below for further description. |
shipping_charge |
decimal |
0..1 |
|
Extra fee for shipping method. |
weight |
decimal |
0..1 |
|
Weight of the order. |
tax_id_number |
string |
0..1 |
50 |
VAT ID. |
coupon_value |
decimal |
0..1 |
|
The amount of the coupon. No percentage. |
discount_amount |
decimal |
0..1 |
|
The amount of the monetary discount. |
marketplace_actualisation_deactivated_at |
datetime |
0..1 |
|
Timestamp when the synchronization with the trading platform was deactivated at. |
marketplace_username |
string |
0..1 |
100 |
Username on the trading platform. |
ready_for_collection_date |
datetime |
0..1 |
|
Timestamp when to order can be collected in a branch. |
packstation |
boolean |
0..1 |
|
Flag, if the delivery address is a Packstation. |
tags |
Element |
0..1 |
|
Element that combines the data of order tags. It can contain several tag-nodes. |
tag |
string |
1..N |
|
Name of an order tag. This can be one out of the table of values below or an individual one. |
order_items |
Element |
0..1 |
|
Element that combines the data of order items. It can contain several order_item-nodes. |
order_item |
Element |
1..N |
|
Element that contains all data of one order item. |
item_identifier |
string |
0..1 |
200 |
Identifier of the item. Can be used for order matching. |
item_internal_number |
string |
0..1 |
50 |
Internal number of the item. Can be used for order matching. |
item_match_code |
string |
0..1 |
100 |
Matchcode of the item. Can be used for order matching. |
item_ean_code |
string |
0..1 |
30 |
EAN number of the item. Can be used for order matching. |
item_upc_code |
string |
0..1 |
12 |
UPC number of the item. Can be used for order matching. |
item_isbn |
string |
0..1 |
13 |
ISBN number of the item. Can be used for order matching. |
position_number |
integer |
0..1 |
|
Sequential number of the item. |
order_date |
datetime |
0..1 |
|
The date when the position was added to the order. Mandatory for new order items. |
quantity |
integer |
0..1 |
|
Quantity of the ordered item. |
price |
decimal |
0..1 |
|
Price of one ordered item. |
purchase_price |
decimal |
0..1 |
|
Purchase price of the item. |
tax_rate |
decimal |
0..1 |
|
Tax rate in percent. |
note |
string |
0..1 |
|
Note for this order item. |
serial_number |
string |
0..1 |
50 |
Serial number of the item. |
type_identifier |
string |
0..1 |
|
Type of the order item. See table of values below for further description. |
reference_number |
string |
0..1 |
400 |
A free field for reference number. |
channel_item_number |
string |
0..1 |
|
The item number of the trading platform. |
coupon_percent |
decimal |
0..1 |
|
Coupon percentage value. |
expected_delivery_date |
datetime |
0..1 |
|
The expected delivery date. |
cancel_date |
datetime |
0..1 |
|
The timestamp when the entire order was canceled. |
discount_value |
decimal |
0..1 |
|
The discount value (no percentage) of one ordered item. |
additional_order_item_data |
Element |
0..1 |
|
Element that combines the data of additional order item data. It can contain several order_item_data-nodes. |
order_item_data |
Element |
1.N |
|
Element that contains all additional data for one order item. |
key |
string |
0..1 |
|
The key of the additional data. |
value |
string |
0..1 |
|
The value of the additional data. |
order_notices |
Element |
0..1 |
|
Element that combines all order notices. It can contain several order_note-nodes. |
order_note |
Element |
1..N |
|
Element that contains all data of one order note. |
text |
string |
0..1 |
1000 |
The content of the order note. |
type |
string |
0..1 |
|
The type of the order note. See table of values below for further description. |
payment_instructions |
Element |
0..1 |
|
Element that combines the data of payment instructions. It can contain several payment_instruction-nodes. |
payment_instruction |
Element |
0..N |
|
Element that contains all data for one payment instruction. |
external _id |
string |
0..1 |
50 |
External ID of the payment. |
recipient |
string |
0..1 |
150 |
The recipient of the payment. |
iban |
string |
0..1 |
34 |
IBAN of the payment. |
bic |
string |
0..1 |
11 |
BIC of the payment. |
bank_name |
string |
0..1 |
150 |
Name of the Bank. |
payment_reason |
string |
0..1 |
140 |
The purpose of the payment. |
note_to_buyer |
string |
0..1 |
300 |
A note for the buyer. |
url |
string |
0..1 |
300 |
URL for payment. |
transaction_number |
string |
0..1 |
50 |
The payment transaction number. |
receipt_printing |
boolean |
0..1 |
|
This flag controls whether the payment information is printed in the receipt. |
amount |
decimal |
0..1 |
|
The amount of the payment instruction. |
currency_code_iso |
string |
0..1 |
|
Current currency of the order in ISO 4217. |
due_date |
datetime |
0..1 |
|
The due date of the payment. |
sepa_mandate_url |
string |
0..1 |
2083 |
The URL for downloading the SEPA mandate. |
sepa_mandate_reference |
string |
0..1 |
35 |
The reference number of the SEPA mandate. |
packets |
Element |
0..1 |
|
Element that combines the data of packets. It can contain several packet-nodes. |
packet |
Element |
1..N |
|
Element that contains all data of one packet. |
tracking_number |
string |
0..1 |
200 |
The tracking number of the packet. |
dispatch_provider_identifier |
string |
0..1 |
100 |
Name of the individually managed dispatch providers in Speed4Trade CONNECT. |
dispatch_provider_external_id |
string |
0..1 |
100 |
External ID of dispatch provider. |
dispatch_type_identifier |
string |
0..1 |
100 |
Name of the individually managed dispatch types in Speed4Trade CONNECT. |
dispatch_type_external_id |
string |
0..1 |
100 |
External ID of dispatch type. |
shipping_date |
datetime |
0..1 |
|
The shipping date of the packet. |
estimated_arrival_date |
datetime |
0..1 |
|
The estimated date of arrival of the packet. |
packet_content |
Element |
0..1 |
|
Element that combines the data of packet content. It can contain several content-nodes. |
content |
Element |
1..N |
|
Element that contains all data of the packet content. |
item_identifier |
string |
0..1 |
200 |
Identifier of the item. Can be used for order matching. |
item_internal_number |
string |
0..1 |
50 |
Internal number of the item. Can be used for order matching. |
item_match_code |
string |
0..1 |
100 |
Matchcode of the item. Can be used for order matching. |
item_ean_code |
string |
0..1 |
30 |
EAN number of the item. Can be used for order matching. |
item_upc_code |
string |
0..1 |
12 |
UPC number of the item. Can be used for order matching. |
item_isbn |
string |
0..1 |
13 |
ISBN number of the item. Can be used for order matching. |
quantity |
integer |
0..1 |
|
Quantity of the item within the packet. |
additional_order_data |
Element |
0..1 |
|
Element that combines the data of additional order data. It can contain severeal order_data-nodes. |
order_data |
Element |
1..N |
|
Element that contains all additional data for one order. |
key |
string |
0..1 |
|
The key of the additional data. |
value |
string |
0..1 |
|
The value of the additional data. |
Table of Values - order_status_identifier
order_status_identifier |
Description |
|
---|---|---|
10 |
new |
New order. |
120 |
outstanding payment |
The order is confirmed but the payment is outstanding. |
130 |
paid shipping |
The order is paid and can be shipped. |
140 |
shipped complete |
The order is shipped and completed. |
220 |
confirmed shipping |
The order is confirmed and can be shipped. |
230 |
shipped outstanding |
The order is shipped but the payment is outstanding. |
240 |
paid complete |
The order is paid and completed. |
320 |
confirmed pickup |
The order is confirmed and can be picked up. |
330 |
pickedup completed |
The order is picked up and completed. |
985 |
regrouped |
The order items are regrouped to another order. |
990 |
canceled |
The order is canceled. |
995 |
back order |
The order is parked in back order, e.g. until the confirmation of the trading platform receives. |
Table of Values - type_identifier
type_identifier |
Description |
|
---|---|---|
0 |
default |
The default type for order items. |
1 |
coupon fixvalue |
The order item is a coupon position with a fix value. |
2 |
coupon percentvalue |
The order item is a coupon position with a percentual value. |
3 |
additional service |
The order item is a service for another order item. |
4 |
reversal item |
The order item is a reversal item. |
Table of Values - customer_type_identifier
customer_type_identifier |
Description |
---|---|
business |
The customer is a business client. |
private |
The customer is a private client. |
Table of Values - salutation_identifier
salutation_identifier |
Description |
---|---|
mr |
Salutation for male clients. |
ms |
Salutation for female clients. |
business |
Salutation for companies. |
Table of Values - on_hold_reason_identifier
on_hold_reason_identifier |
Description |
---|---|
Set shipment status failed |
Setting the shipment status failed. |
Manuelle Rückstellung |
The order was set on hold manually. |
Klarna-Auftrag schwebend |
Klarna order pending. |
Klarna-Auftrag verweigert |
Klarna order denied. |
Outdated |
Order date too old. |
Table of Values - price_type_identifier
price_type_identifier |
Description |
---|---|
gross |
All prices of the order are incl. VAT. |
net |
All prices of the order are excl. VAT. |
Table of Values - payment_status_identifier
payment_status_identifier |
Description |
---|---|
unpaid |
There exists no payment for this order. |
underpaid |
This order is not fully paid. |
paid |
This order is full paid. |
overpaid |
The customer paid too much for this order. |
tag |
Description |
---|---|
PRIORITY |
Priority shipping required. |
EXTERNAL_INVOICING |
Indicator for external invoice creation. |
B2B |
Indicator for B2B orders. |
Table of Values - order note_type
tag |
Description |
---|---|
internal |
Internal order note. |
external |
External order note. This will be used for document print-out. |
Table of Values - payment_methods
payment_method_identifier |
order-state-workflow |
Description |
---|---|---|
amazon pay |
200 |
Pay by Amazon payment. |
billsafe |
200 |
Pay by Billsafe. |
cash |
300 |
Pay cash on pickup. |
cash on delivery |
100 |
Pay by cash on delivery. |
credit card |
100 |
Pay by Creditcard. |
debit |
100 |
Pay by debit. |
finance |
100 |
Pay by finance. |
giropay |
200 |
Pay by Giropay. |
invoice |
200 |
Pay by invoice. |
klarna account |
200 |
Pay by rate to Klarna. |
klarna invoice |
200 |
Pay by invoice to Klarna. |
marketplace payment |
200 |
Pay by method which is defined from marketplace. |
paypal |
100 |
Pay by PayPal. |
prepay |
100 |
Pay by prepay. |
RatePAY |
200 |
Pay by rate to RatePAY. |
sofortueberweisung |
100 |
Pay by Sofortueberweisung. |
Example Order:
<?xml version="1.0" encoding="UTF-8"?> <note_to_buyer>Bitte überweisen Sie EUR 10,00 bis 2017-01-01 auf das Bankkonto von PayPal. Empfänger: "PayPal Europe". IBAN: "DE281207008880011197". BIC: "DEUTDEDBPAL". Name der Bank: "Deutsche Bank". Referenznummer: "7GH234816E0900S4T".</note_to_buyer> <currency_code_iso>EUR</currency_code_iso> </payment_instruction> |
|