Export Orders

Our app exports each order’s data across multiple rows.

• Row with linetype = order represents the order data.
• Rows with linetype = lineItems represent the order items.

By default, line item rows do not contain order-related data in the order columns:

linetype	orderNumber	orderStatus	paymentStatus	amountTotal	Subtotal	Total excluding VAT
order	10002	open	open	122.4	110.4	102.85
lineItems	10002
lineItems	10003

To fill line item rows with order data, select the export option Fill all order line with order data in export profile settings.

When this option is enabled, all rows will contain the data from their related order.

linetype	orderNumber	orderStatus	paymentStatus	amountTotal	Subtotal	Total excluding VAT
order	10002	open	open	122.4	110.4	102.85
lineItems	10002	open	open	122.4	110.4	102.85
lineItems	10003	open	open	122.4	110.4	102.85