> For the complete documentation index, see [llms.txt](https://brainence.gitbook.io/easy-export/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://brainence.gitbook.io/easy-export/overview/configuration/column-settings.md).

# Column Settings

Configure the report structure, filters and sorting

On the Column settings page you can add/ remove/ change the order of the columns you are interested in as well as change naming, apply filters, and sorting to the data.

Once the tab is opened a standard set of columns is displayed

<figure><img src="https://4209137600-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYVcapucfzjS7gPXPQ1HM%2Fuploads%2FNYct1lrpVVmaJ6sLzglT%2FEE16.png?alt=media&amp;token=d7f700e7-0302-467c-b98e-d23bc4a40676" alt=""><figcaption></figcaption></figure>

You can add more columns by clicking on the ![](https://4209137600-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYVcapucfzjS7gPXPQ1HM%2Fuploads%2FIZzMSDro08cXWD7DgGQl%2Fimage.png?alt=media\&token=676682fa-bea0-4b62-a665-06d878dbaf2e) button

For the user's convenience, the data is split into the following sections:

<details>

<summary>Customer Info:</summary>

* Channel Buyer Name
* Shipping Address Email
* Shipping Address First Line
* Shipping Address Second Line
* Shipping Address Third Line
* Shipping Address Town
* Shipping Address Region
* Shipping Address Post Code
* Shipping Address Country
* Shipping Address Continent
* Shipping Address Full Name
* Shipping Address Company
* Shipping Address Phone Number
* Billing Address Email
* Billing Address First Line
* Billing Address Second Line
* Billing Address Third Line
* Billing Address Town
* Billing Address Region
* Billing Address Post Code
* Billing Address Country
* Billing Address Continent
* Billing Address Full Name
* Billing Address Company
* Billing Address Phone Number

</details>

<details>

<summary>General Order Info:</summary>

* Order Number
* Reference Number
* Secondary Reference
* External Reference Number
* Received Date
* Source
* SubSource
* Folder Names
* Order Status
* Label Printed
* Label Error
* Invoice Printed
* Pick List Printed
* Is Rule Run
* Notes Quantity
* Is Part Shipped
* Is Parked
* HoldOrCancel
* SiteCode
* Items Quantity
* Stock Allocation Type
* Fulfillment State
* Purchase Order State
* <mark style="color:blue;">**Any existing order identifier could be added as a column**</mark>
* <mark style="color:blue;">**Any existing order extended property could be added as a column**</mark>

</details>

<details>

<summary>Item Info:</summary>

* Item Number On Channel
* Item SKU
* Item Source
* Item Title
* Item Quantity
* Item Category
* Is Stock Level Specified
* Level Due In Purchase Orders
* Purchase Order External Invoice Number
* Purchase Order Date Of Delivery
* Purchase Order Quoted Delivery Date
* Purchase Order Supplier Name
* Quantity In Open Orders
* Current Stock Level
* Minimum Stock Level
* Available Stock Level
* Price Per Unit
* Unit Cost
* Despatch Stock Unit Cost
* Discount Percentage
* Item Tax
* Item Tax Rate
* Total Item Cost Excluding Tax
* Total Item Cost Including Tax
* Is Service
* Sales Tax
* Is Tax Is Included In A Cost
* Is Part Shipped
* Item Weight
* Product Barcode
* Market
* Channel SKU
* Item Title On Channel
* Discount Value
* Has Image
* Main Image Link
* Stock Level Indicator
* Shipping Cost
* Part Shipped Quantity
* Item Name
* Is Batch Number Scan Required
* Is Serial Number Scan Required
* Item BinRack
* Is Batched Stock Item
* Is Warehouse Managed
* Is Unlinked
* Stock Item Id
* <mark style="color:blue;">**Any existing item additional info could be added as a column**</mark>
* <mark style="color:blue;">**Any existing stock item extended property could be added as a column**</mark>

</details>

<details>

<summary>Shipping info:</summary>

* Label Printed
* Label Error
* Invoice Printed
* Pick List Printed
* Despatch By Date
* Delivery Scheduled From
* Delivery Scheduled To
* Has Scheduled Delivery
* Shipping Vendor
* Postal Service Name
* Total Weight
* Package Category
* Package Type
* Postage Cost
* Postage Cost Excluding Tax
* Tracking Number
* Was Manually Adjusted

</details>

<details>

<summary>Totals:</summary>

* Subtotal
* Order Tax
* Total Charge
* Payment Method
* Profit Margin
* Total Discount
* Currency
* Country Tax Rate
* Conversion Rate
* Tax Number

</details>

<details>

<summary>Refund info:</summary>

* Refund Creation Date
* Refund Header Id
* Entire Refund External Reference
* Refund Currency
* Entire Refund Amount
* Refund Status
* Entire Refund Actioned
* Refund Last Action Date
* Is Shipping Refund Line
* Is Cancellation
* Line Cancelled Quantity
* Line Refund Error
* Refund Line Quantity
* Item Refund Reason
* Service Refund Reason

and others

</details>

<details>

<summary>Return info:</summary>

* RMA Header Id
* RMA Created Date
* Return Reason
* Return Reason Tag
* Must Have Refund
* RMA Actioned
* RMA Line Return Quantity
* RMA Line Scrap Quantity
* RMA Line Reason Category
* RMA Line Resend Quantity
* RMA Line Exchange Quantity
* RMA Status

and others

</details>

Once the preferred columns are selected you can change the naming of any column by simply clicking on the Edit icon next to the current name ![](https://4209137600-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYVcapucfzjS7gPXPQ1HM%2Fuploads%2Fs09HijQyRaIQOAl87zfF%2Fimage.png?alt=media\&token=f4e302a7-2188-4939-a027-12780eea5e95)

<figure><img src="https://4209137600-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYVcapucfzjS7gPXPQ1HM%2Fuploads%2FfDxK1JXGI1QqAGEHwHEf%2FEE31.png?alt=media&amp;token=6567cd90-4125-4955-bd6a-f1fc7c168a18" alt=""><figcaption></figcaption></figure>

If any of the columns was added by mistake, you can remove it by clicking on the X icon near the column name ![](https://4209137600-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FYVcapucfzjS7gPXPQ1HM%2Fuploads%2Fwu1ErCOB7ZPdfY3ycRsk%2Fimage.png?alt=media\&token=db5feadb-0c81-41ac-a072-131359da19c3)

If you are not happy with the order of the columns, you can easily change it with drag-and-drop function. Just click and hold left mouth button and drag the column to the preferred place

{% hint style="info" %}
Once the columns are selected and sorted in the correct order you can check the results on the screen and the configuration will be saved for the scheduled exported files
{% endhint %}

#### After the report setup is completed, you can proceed to the Export file format and destination configuration.
