Difference between revisions of "Downloading Your Orders"

From Spiffy Stores Knowledge Base

Line 7: Line 7:
 
A line is created for each line item ordered.  The downloaded file contains the following fields:
 
A line is created for each line item ordered.  The downloaded file contains the following fields:
  
{| width="100%" border="0" padding="5" class="wikitable"
+
{| width="100%" border="0" cellpadding="5" class="wikitable"
 
|-
 
|-
 
| '''HEADER'''
 
| '''HEADER'''

Revision as of 11:22, 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
  • Email
  • Created
  • Payment Status
  • Shipping Status
  • Closed Status
  • Currency
  • Payment Method
  • Subtotal
  • Shipping
  • Discount
  • Tax
  • Total
  • Tax Label
  • Shipping Method
  • Discount Code
  • Billing Name
  • Billing Company
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing State
  • Billing Postcode
  • Billing Country
  • Billing Phone
  • Shipping Name
  • Shipping Company
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping State
  • Shipping Postcode
  • Shipping Country
  • Shipping Phone
  • Note
  • 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