CSV Order Connector
A new order is being transformed into a CSV file and uploaded to the retailer FTP server.
If the order contains multiple products, the CSV file may include multiple rows for each product.
As the simplified checkout only fetches one address, the CSV file may return the same address for both the invoice and the shipping address.
The CSV file is structured as follows:
| Field | Description |
|---|---|
| INVOICE_NAME1 | The first name of the invoice recipient. |
| INVOICE_NAME2 | The last name of the invoice recipient. |
| INVOICE_STREET | The street address of the invoice recipient. |
| INVOICE_HOUSENUMBER | The house number of the invoice recipient. |
| INVOICE_PLZ | The postal code of the invoice recipient. |
| INVOICE_CITY | The city of the invoice recipient. |
| INVOICE_COUNTRY | The country of the invoice recipient. |
| INVOICE_EMAIL | The email address of the invoice recipient. |
| INVOICE_TELEFON | The telephone number of the invoice recipient. |
| SHIPPING_NAME1 | The first name of the shipping recipient. |
| SHIPPING_NAME2 | The last name of the shipping recipient. |
| SHIPPING_STREET | The street address of the shipping recipient. |
| SHIPPING_HOUSENUMBER | The house number of the shipping recipient. |
| SHIPPING_PLZ | The postal code of the shipping recipient. |
| SHIPPING_CITY | The city of the shipping recipient. |
| SHIPPING_COUNTRY | The country of the shipping recipient. |
| PRODUCT_SKU | The stock keeping unit of the product. |
| PRODUCT_NAME | The name of the product. |
| PRODUCT_QUANTITY | The quantity of the product. |
| PRODUCT_PRICE | The price of the product. |
| SHIPPING_COST | The cost of shipping. |
| TOTAL_COST | The total cost of the order. |
| ORDER_NUMBER | The order number. |
| PAYMENT_ID | The payment identifier. |