Downloading the reports from the Main admin CMS will create a .csv file that can be saved directly on to your computer to be open with you own commercial software application.
The below table gives you a list of all the named reports (First Column in Grey) with a list of all the header column's that pull in the required data of those column headings
Sales Orders Report | Gift Cards | Gift Card Transactions | Gift Card Liability | Stripe Report | Vendor Report | Best Selling Reporting |
Order number | Delivery method | Order Number | Delivery method | balance_transaction_id | Order number | Product Name |
Storefront | Card Type | Serial Number | Card Type | created_utc | Storefront | Vendor Name |
Vendor | Gift Card Created Date | Card Store Code | Gift Card Created Date | created | Vendor | Storefront |
Vendor Timezone | Gift Card Last Updated | Ts Campaign Stores | Gift Card Liability Date | available_on_utc | Vendor Timezone | Sku |
Date Placed | Gift Card Valid Date | Currency | Gift Card Valid Date | available_on | Date Placed | Variant Options |
Order Status | Card Status | Amount | Card Status | currency | Time Placed | No. of Sales |
Customer Full Name | Bonus Card | Action | Recipient First Name | gross | Order Status | Total |
Customer Address | Recipient First Name | Trans Store Currency | Recipient Last Name | fee | Product name |
|
Customer First Name | Recipient Last Name | trans_amount | Recipient Email Address | net | Product Sku |
|
Customer Last Name | Recipient Email Address | Service Fee | Recipient Phone | reporting_category | Vendor Sku |
|
Shipping Delivery Country | Recipient Phone | Exch Rate | Serial Number | Refund Reason | Variant |
|
Customer Phone | Serial Number | Balance | Order Number | description | Product quantity |
|
Customer Email | Gift Card Associated Order Ref | Card Status | Gift Card Original Balance | invoice_id | Product price |
|
Product name | Gift Card Original Balance | Operator ID | Currency | connected_account | Delivery/Pick-up Date |
|
Brand Name | Currency | Operator Name | Balance | customer_email | Delivery/Pick-up Time |
|
Product Sku | Report Currency Sub Total | Department | Liability | charge_created | Shipped Date |
|
Vendor Sku | Report Currency Code | Delivery method | Campaign Code | card_country | Shipped Time |
|
Barcode Number | Report Currency Exchange Rate | Card Type | Checkout Storefront |
| Order currency |
|
Variant | Balance | Action Date | Ts Campaign Stores |
| Vendor Currency |
|
Product quantity | Campaign Code | Action Time |
| Exchange Rate |
| |
Product price | Checkout Storefront | Comment Field | Role |
| Sub Total |
|
Unit Cost Price | Ts Campaign Stores | Action Store Name | Monetary Liability |
| Tax(inclusive) |
|
Delivery/Pick-up Date | Campaign Code | Experience Liability |
| Tax(exclusive) |
| |
Delivery/Pick-up Time | Role | Message |
| Shipping amount |
| |
Shipped Date | Message | Role |
|
| Total Shipping amount |
|
Shipped Time |
| Message |
|
| Discount amount |
|
Order currency |
|
|
|
| Associated Order Value |
|
Vendor Currency |
|
|
|
| Promo Code |
|
Exchange Rate |
|
|
|
| Order payment method |
|
Sub Total |
|
|
|
| Shipping Method |
|
Report Currency sub Total |
|
|
|
| Order shipped |
|
Report Currency Code |
|
|
|
| Tags |
|
Report Currency Exchange Rate |
|
|
|
| Gift Card Number |
|
Tax(inclusive) |
|
|
|
| Gift Card Iso Number |
|
Tax(exclusive) |
|
|
|
| Bonus Card |
|
Shipping amount |
|
|
|
| Card Type |
|
Total Shipping amount |
|
|
|
| Marketing Enabled |
|
Discount Amount |
|
|
|
| Product Tag |
|
Order Subtotal |
|
|
|
|
|
|
Associated Order Value |
|
|
|
|
|
|
Promo Code |
|
|
|
|
|
|
Order payment method |
|
|
|
|
|
|
Shipping Method |
|
|
|
|
|
|
Order shipped |
|
|
|
|
|
|
Tags |
|
|
|
|
|
|
Gift Card Number |
|
|
|
|
|
|
Gift Card Iso Number |
|
|
|
|
|
|
Special Message |
|
|
|
|
|
|
Card Type |
|
|
|
|
|
|
Recipient Name |
|
|
|
|
|
|
Recipients First Name |
|
|
|
|
|
|
Recipients Last Name |
|
|
|
|
|
|
Recipient Email |
|
|
|
|
|
|
Recipient Phone Number |
|
|
|
|
|
|
Marketing Enabled |
|
|
|
|
|
|
Product Tag |
|
|
|
|
|
|
Reference Number |
|
|
|
|
|
|
Notes / Comments |
|
|
|
|
|
|