Description:
This process is a base export for transferring orders information of Speed4Trade CONNECT to the trading platform. For this purpose, Speed4Trade CONNECT provides an XML format for orders. This export contains also invoice information and invoice files encoded as Base64 string. The export of the base64 data must be activated in the job options.
The order export includes all needed information about the order after the changed will be set in Speed4Trade CONNECT. The trading platform must independently determine which information it needs from the export for the corresponding status update. It may need more than once export to get the needed information. If the export not include the needed information the trading platform need to skip it themself.
How orders can be export?
•Export all orders to local path on Speed4Trade CONNECT server
•Export orders as delta to local path on Speed4Trade CONNECT server
•Export all orders to (s)ftp account (ftp server can be configured in Speed4Trade CONNECT)
•Export orders as delta to (s)ftp account (ftp server can be configured in Speed4Trade CONNECT)
Fieldlist:
Name |
Type |
Cardinality |
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. |
order_number |
integer |
0..1 |
Order number of Speed4Trade CONNECT. Can be used for matching. |
order_number_prefix |
string |
0..1 |
Prefix for the order number of Speed4Trade CONNECT. Can be used for order matching. |
external_order_number_1 |
string |
0..1 |
First external order number, e.g. ERP order number. Can be used for order matching. |
external_order_number_2 |
string |
0..1 |
Second external order number, e.g. ERP order number. Can be used for order matching. |
transaction_id_1 |
string |
0..1 |
First payment transaction id. Can be used for order matching. |
transaction_id_2 |
string |
0..1 |
Second payment transaction id. Can be used for order matching. |
marketplace_order_id_1 |
string |
0..1 |
First marketplace order id. Can be used for order matching. |
marketplace_order_id_2 |
string |
0..1 |
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 |
Identifier of the dispatch provider. |
dispatch_provider_external_id |
string |
0..1 |
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 |
Customer number of Speed4Trade CONNECT. |
customer_external_id_1 |
string |
0..1 |
First external customer id. |
customer_external_id_2 |
string |
0..1 |
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 |
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 |
Company name in invoice address. |
invoice_first_name |
string |
0..1 |
First name in invoice address. |
invoice_last_name |
string |
0..1 |
Last name in invoice address. |
invoice_street |
string |
0..1 |
Street in invoice address. |
invoice_house_number |
string |
0..1 |
House number in invoice address. |
invoice_street_addition |
string |
0..1 |
Additional street field in invoice address. |
invoice_postal_code |
string |
0..1 |
Postal code in invoice address. |
invoice_city |
string |
0..1 |
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 |
Phone number in invoice address. |
invoice_email_address |
string |
0..1 |
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 |
Company name in alternative delivery address. |
delivery_first_name |
string |
0..1 |
First name in alternative delivery address. |
delivery_last_name |
string |
0..1 |
Last name in alternative delivery address. |
delivery_street |
string |
0..1 |
Street in alternative delivery address. |
delivery_house_number |
string |
0..1 |
House number in alternative delivery address. |
delivery_street_addition |
string |
0..1 |
Additional street field in alternative delivery address. |
delivery_postal_code |
string |
0..1 |
Postal code in alternative delivery address. |
delivery_city |
string |
0..1 |
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 |
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 |
Name of the individually managed dispatch types in Speed4Trade CONNECT. |
dispatch_type_external_id |
string |
0..1 |
External id of dispatch type. |
dispatch_handling_identifier |
string |
0..1 |
|
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 |
VAT ID. |
coupon_value |
decimal |
0..1 |
The amount of the coupon. No percentage. |
exported_at |
datetime |
0..1 |
Timestamp of the export to an ERP system. |
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 |
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 |
Identifier of the item. Can be used for order matching. |
item_internal_number |
string |
0..1 |
Internal number of the item. Can be used for order matching. |
item_match_code |
string |
0..1 |
Matchcode of the item. Can be used for order matching. |
item_ean_code |
string |
0..1 |
EAN number of the item. Can be used for order matching. |
item_upc_code |
string |
0..1 |
UPC number of the item. Can be used for order matching. |
item_isbn |
string |
0..1 |
ISBN number of the item. Can be used for order matching. |
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 |
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 |
A free field for reference number. |
coupon_percent |
decimal |
0..1 |
Coupon percentage value. |
expected_delivery_date |
datetime |
0..1 |
The expected delivery date. |
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 |
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 |
External ID of the payment. |
recipient |
string |
0..1 |
The recipient of the payment. |
iban |
string |
0..1 |
IBAN of the payment. |
bic |
string |
0..1 |
BIC of the payment. |
bank_name |
string |
0..1 |
Name of the Bank. |
payment_reason |
string |
0..1 |
The purpose of the payment. |
note_to_buyer |
string |
0..1 |
A note for the buyer. |
url |
string |
0..1 |
URL for payment. |
transaction_number |
string |
0..1 |
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 |
The URL for downloading the SEPA mandate. |
sepa_mandate_reference |
string |
0..1 |
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 |
The tracking number of the packet. |
dispatch_provider_identifier |
string |
0..1 |
Name of the individually managed dispatch providers in Speed4Trade CONNECT. |
dispatch_provider_external_id |
string |
0..1 |
External ID of dispatch provider. |
dispatch_type_identifier |
string |
0..1 |
Name of the individually managed dispatch types in Speed4Trade CONNECT. |
dispatch_type_external_id |
string |
0..1 |
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. |
return_number |
string |
0..1 |
The RMA number of the return. |
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 |
Identifier of the item. Can be used for order matching. |
item_internal_number |
string |
0..1 |
Internal number of the item. Can be used for order matching. |
item_match_code |
string |
0..1 |
Matchcode of the item. Can be used for order matching. |
item_ean_code |
string |
0..1 |
EAN number of the item. Can be used for order matching. |
item_upc_code |
string |
0..1 |
UPC number of the item. Can be used for order matching. |
item_isbn |
string |
0..1 |
ISBN number of the item. Can be used for order matching. |
tracking_number |
string |
0..1 |
The tracking number of the packet. |
quantity |
integer |
0..1 |
Quantity of the item within the packet. |
export_flags |
Element |
0..1 |
Element that combines the data of export flags. It can contain several content-nodes. |
export_flag |
Element |
1..N |
Element that contains all data of the export flag. |
export_identifier |
string |
0..1 |
Identifier of the export flag. |
export_time |
datetime |
0..1 |
The date and time of the export. |
additional_order_data |
Element |
0..1 |
Element that combines the data of additional order data. It can contain several 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. |
order_documents |
Element |
0..1 |
Element that combines the data of order documents. It can contain several order_document-nodes. Hint: the section order documents only exists if an invoice export type is set in job options. |
order_document |
Element |
1..N |
Element that contains all data of the order document. |
type |
string |
1 |
Type of the order document, e.g. "INVOICE". See table of values below for further description. |
pos |
decimal |
0..1 |
Position of the order document to separate order documents with the same type. |
external_id |
string |
0..1 |
The external ID of the order document. |
filename |
string |
0..1 |
The file name of the order document. |
base64 |
string |
0..1 |
The BASE64 encoded file content. |
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 |
---|---|
Fulfillment by Amazon |
The fulfillment is made by Amazon. |
Fulfillment by Amazon failed |
The fulfillment by Amazon has failed. |
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. |
Shopgate-Auftrag schwebend |
Shopgate order pending. |
Otto-Auftrags-Avisierung |
Otto order notification. |
eBay pending |
On hold because the order is still being checked by eBay. |
OXID pending |
On hold because the order is still being checked by OXID. |
Magento pending |
On hold because the order is still being checked by Magento. |
Outdated |
Order date too old. |
COMMERCE pending |
On hold because the order is still being checked by COMMERCE. |
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. |
ISPU |
In-store-pick-up for eBay Click and Collect. |
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 - order document type
tag |
Description |
---|---|
CANCELLATION INVOICE |
Cancelled invoice |
DELIVERY NOTE |
Delivery note |
INVOICE |
Invoice |
OFFER |
Offer |
ORDER |
Order |
PARCEL LABEL 1 |
Parcel label 1 |
PARCEL LABEL 2 |
Parcel label 2 |
RETURN TICKET |
Return ticket |
SEPA DEBIT AGREEMENT |
Sepa debit agreement |
SHIPPING LABEL |
Shipping label |
Example Order:
<?xml version="1.0" encoding="UTF-8"?> <return_number>132654</return_number> <packet_content> |