Export orders
This section explains how to export orders and transform them using an XSLT file.
Exporting orders from back office
To export orders, select the orders you want to export in the Sales area, then click Export.
The orders are exported to an XML file which, by default, has a flat structure and can be viewed in applications like Microsoft Excel. The exact format of the export file is determined by an XSLT file that can be customised by the project.
XML format of the export file
You can define which columns are exported and in which order they are displayed in the XML output by using an XSLT file. Place the file into your web\bin folder. The name of the XSLT file can be configured in web.config using the orderExportXslt setting in the studio\ecommerce section.
<ecommerce orderExportXslt="Litium.Studio.Modules.ECommerce.ExportOrders.xsl" gateWayIP="" />
To use the XSLT file for exports:
- Go to Settings > Sales > Orders in back office.
- Select the checkbox Enable XSL transform on order export.
The generated XML file will be tranformed using the above XSLT file.