Difference between revisions of "Downloading Your Orders"

From Spiffy Stores Knowledge Base

Line 25: Line 25:
 
|-
 
|-
 
| Payment Status
 
| Payment Status
| One of { pending, authorized, partially_paid, paid, partially_refunded, refunded, voided }
+
| One of pending, authorized, partially_paid, paid, partially_refunded, refunded, voided
 
|-
 
|-
 
| Shipping Status
 
| Shipping Status
|
+
| One of shipped, unshipped, partial
 
|-
 
|-
 
| Closed Status
 
| Closed Status
|  
+
| True or False
 
|-
 
|-
 
| Currency
 
| Currency
|  
+
| Three letter currency abbreviation that the customer paid with. Note: you only capture in the currency you have set in the "Preferences -> Standards and Formats" section of your store's Toolbox.
 
|-
 
|-
 
| Payment Method
 
| Payment Method
|  
+
| Name of payment gateway used to check out
 
|-
 
|-
 
| Subtotal
 
| Subtotal
|  
+
| Order total before tax & shipping
 
|-
 
|-
 
| Shipping
 
| Shipping
|  
+
| Cost to the customer for shipping
 
|-
 
|-
 
| Discount
 
| Discount
|  
+
| Amount the order was discounted – Zero (0) if no discount was applied
 
|-
 
|-
 
| Tax
 
| Tax
|  
+
| Sum of local, federal, and shipping taxes
 
|-
 
|-
 
| Total
 
| Total
|  
+
| Order total = subtotal + shipping + taxes
 
|-
 
|-
 
| Tax Label
 
| Tax Label
|  
+
| The type of tax charged as specified in the "Preferences -> Regions & Taxes" section of  your store's Toolbox
 
|-
 
|-
 
| Shipping Method
 
| Shipping Method
|  
+
| Name of the shipping rate selected by customer
 
|-
 
|-
 
| Discount Code
 
| Discount Code
|  
+
| Name of the discount code if one was applied during checkout – empty if none used
 
|-
 
|-
 
| Billing Name
 
| Billing Name
|  
+
| First and last names of the customer
 
|-
 
|-
 
| Billing Company
 
| Billing Company
|  
+
| Name of the company entered for billing address. This is often empty
 
|-
 
|-
 
| Billing Address 1
 
| Billing Address 1
|  
+
| Line 1 of billing address – e.g. "123 George Street"
 
|-
 
|-
 
| Billing Address 2
 
| Billing Address 2
|  
+
| Line 2 of billing address – e.g. "Suite 201". This is often empty
 
|-
 
|-
 
| Billing City
 
| Billing City
|  
+
| Name of the customer's city
 
|-
 
|-
 
| Billing State
 
| Billing State
|  
+
| The name of the state or region if applicable in your country (otherwise, this field is empty)
 
|-
 
|-
 
| Billing Postcode
 
| Billing Postcode
|  
+
| Zip codes, postal codes, etc... varies by your region
 
|-
 
|-
 
| Billing Country
 
| Billing Country
|  
+
| The name of the country entered for billing address.
 
|-
 
|-
 
| Billing Phone
 
| Billing Phone
|  
+
| Phone number entered during checkout
 
|-
 
|-
 
| Shipping Name
 
| Shipping Name
Line 118: Line 118:
 
|-
 
|-
 
| Note
 
| Note
|  
+
| Notes can be entered on the order in your Toolbox.  If your theme supports it, this can also include a note from the cutomer entered on the cart page, or in the comments section of the checkout (if you have enabled "Additional Checkout Comments" in the "Preferences -> Checkout & Payment" section of your store's Toolbox
 
|-
 
|-
 
| Line Item Quantity
 
| Line Item Quantity
Line 141: Line 141:
 
|  
 
|  
 
|-
 
|-
|  
+
| Line Item Instalments
|
 
|-
 
|
 
 
|  
 
|  
 
|-
 
|-
|  
+
| Line Item Fulfilment Service
 
|  
 
|  
 
|-
 
|-
|  
+
| Line Item Comment
 
|  
 
|  
 
|-
 
|-
|  
+
| Line Item Shipping Code
 
|  
 
|  
 
|}
 
|}
  
 
* Line Item Instalments
 
* Line Item Fulfilment Service
 
* Line Item Comment
 
* Line Item Shipping Code
 
  
 
Filter your order view…
 
Filter your order view…

Revision as of 11:57, 19 August 2014

You may want to export a list of your orders if you're passing them on to a fulfillment service, or for your own records or book keeping.

We've made it easy to export your orders to an Excel or CSV file. You can filter your view of orders, so you only download orders that meet specific criteria.

The orders.csv file explained

A line is created for each line item ordered. The downloaded file contains the following fields:

HEADER WHAT IS IT?
Order ID The unique identifier that you use to reference the order. This can be seen in your order notificxation emails, on the order summary page, and when viewing the order.
Name The name of the person that placed the order
Email The email address entered during checkout
Created Date the order was created - date format is yyyy-mm-dd hh:mm:ss
Payment Status One of pending, authorized, partially_paid, paid, partially_refunded, refunded, voided
Shipping Status One of shipped, unshipped, partial
Closed Status True or False
Currency Three letter currency abbreviation that the customer paid with. Note: you only capture in the currency you have set in the "Preferences -> Standards and Formats" section of your store's Toolbox.
Payment Method Name of payment gateway used to check out
Subtotal Order total before tax & shipping
Shipping Cost to the customer for shipping
Discount Amount the order was discounted – Zero (0) if no discount was applied
Tax Sum of local, federal, and shipping taxes
Total Order total = subtotal + shipping + taxes
Tax Label The type of tax charged as specified in the "Preferences -> Regions & Taxes" section of your store's Toolbox
Shipping Method Name of the shipping rate selected by customer
Discount Code Name of the discount code if one was applied during checkout – empty if none used
Billing Name First and last names of the customer
Billing Company Name of the company entered for billing address. This is often empty
Billing Address 1 Line 1 of billing address – e.g. "123 George Street"
Billing Address 2 Line 2 of billing address – e.g. "Suite 201". This is often empty
Billing City Name of the customer's city
Billing State The name of the state or region if applicable in your country (otherwise, this field is empty)
Billing Postcode Zip codes, postal codes, etc... varies by your region
Billing Country The name of the country entered for billing address.
Billing Phone Phone number entered during checkout
Shipping Name
Shipping Company
Shipping Address 1
Shipping Address 2
Shipping City
Shipping State
Shipping Postcode
Shipping Country
Shipping Phone
Note Notes can be entered on the order in your Toolbox. If your theme supports it, this can also include a note from the cutomer entered on the cart page, or in the comments section of the checkout (if you have enabled "Additional Checkout Comments" in the "Preferences -> Checkout & Payment" section of your store's Toolbox
Line Item Quantity
Line Item Description
Line Item SKU
Line Item Total Weight
Line Item Price
Line Item Discount
Line Item Discount Description
Line Item Instalments
Line Item Fulfilment Service
Line Item Comment
Line Item Shipping Code


Filter your order view… Order status

All orders Open orders Closed orders Abandoned orders Cancelled orders Deleted orders Payment status

All orders Pending payment Authorised orders Paid orders Shipping Status

All orders Unshipped orders Partially shipped orders Shipped orders Selected date range

Choose the required date range to filter your orders. Click on the range links to cycle through all the options. Show all orders Apply selected date range