What data is included in Export Orders Reports?

DecoNetwork allows you to export a number of reports from the system allowing you to gain insights into your business achievements. You can export reports on your orders, purchase orders, and payments. The report that contains the most information is the orders report. This article shows you what data is included in the orders report.

Watch the following video for an explanation of the data that is included in order reports exported from DecoNetwork. See below for a written list.

You can choose to export order reports in the form of a summary or you can choose to include order line items in the order reports. For each export method you choose, you can select what information is included.

Order Summary Report

The following information can be included in the order summary export:

• Order Number
• Order Type
• Status
• Production Status
• Priority Order
• PO Number
• Supplier PO Number
• Order Job Name
• Sales Team Member
• Date Ordered
• Date Invoiced
• Date Shipped
• Date Due
• Date Produced
• Date Scheduled
• Order Total
• Shipping Total
• Tax Total
• Tax Exempt
• Rush Order Cost
• Coupon Discount
• Coupon
• Gift Certificate
• Gift Certificate Value
• Credits
• Final Discount
• Amount Billed
• Payment Due Date
• Payment Date
• Payment Terms
• Payment Method
• Affiliate Commission
• Referral Commission
• Affiliate Transaction Fee
• My Store
• Wholesale Price
• Base Cost
• Site Id
• Site Name
• Site Address
• Store Group
• Billing Id
• Billing Salutation
• Billing First Name
• Billing Last Name
• Billing Company
• Billing Email Address
• Billing Address
• Billing City
• Billing State
• Billing Country
• Billing Post Code
• Billing Phone Number
• Shipping Salutation
• Shipping First Name
• Shipping Last Name
• Shipping Company
• Shipping Address
• Shipping City
• Shipping State
• Shipping Country
• Shipping Post Code
• Shipping Phone Number
• Shipping Method
• Weight Total
• Tax Names (column per tax)
• Custom Customer Fields (column per field)

Order Line Item Report

The following information can be included in the order item export:

• Order Number
• Order Line Id
• Date Ordered
• Date Shipped
• Date Due
• Date Produced
• Date Scheduled
• Product Name
• Product Code
• Category
• Size
• Color
• SKU
• GTIN
• SKU Qty
• Options
• Line Qty
• Blank Product Price
• Decoration Price
• Decoration Process
• Unit Price
• Line Total
• Discount
• Tax
• Tax Exempt
• Order Total
• Order Shipping Total
• Order Coupon Discount
• Order Coupon
• PO Number
• Supplier PO Number
• Supplier
• Supplier Base Cost
• Production Team Member
• Production Status
• Order Job Name
• Store Commission
• Store Name
• Store Url
• Store Group
• Company
• Billing SalutationBilling First Name
• Billing Last Name
• Billing Email Address
• Billing Address
• Billing City
• Billing State
• Billing Postcode/zip
• Billing Country
• Billing Phone No.
• Shipping Salutation
• Shipping First Name
• Shipping Last Name
• Shipping Address
• Shipping Address 2 (40 char limit)
• Shipping City
• Shipping State
• Shipping Postcode/zip
• Shipping Country
• Shipping Phone No.
• Shipping Company
• Shipping Method
• Weight Total
• Design Name
• Design Price
• Thumbnail Image URL
• Customer ID