Orders represent purchases made by customers in your Shopify store. Each order contains details about the customer, items purchased, payments, fulfillment, and more.
Sample File
Download a sample spreadsheet with order data to import.
Order Fields
These are all the fields you can import or export for orders in Altera.
General
Field | Description | Example Value |
ID | Unique order identifier | 12345678 |
Name | Order name/number | #1001 |
Command | Action to perform on this order | MERGE |
Send Receipt | Whether to send order receipt | true |
Phone | Customer's phone number | |
Customer's email address | ||
Note | Internal order notes | Priority shipping requested |
Tags | Order tags | wholesale, urgent |
Created At | When order was created | 2023-06-01T10:00:00Z |
Processed At | When order was processed | 2023-06-01T10:05:00Z |
Cancelled At | When order was cancelled | null |
Currency | Order currency code | USD |
Source | Order source/channel | online_store |
Payment Status | Payment status | paid |
Fulfillment Status | Order fulfillment status | fulfilled |
Customer Information
Field | Description | Example Value |
Customer ID | Unique customer identifier | 987654 |
Customer Email | Customer's email | |
Customer First Name | Customer's first name | Jane |
Customer Last Name | Customer's last name | Smith |
Billing Address | Complete billing address | 123 Main St, Suite 100 |
Shipping Address | Complete shipping address | 123 Main St, Suite 100 |
Line Items
Field | Description | Example Value |
Line Item ID | Unique line item identifier | 45678 |
Product ID | Associated product ID | 98765 |
Variant ID | Associated variant ID | 12345 |
Title | Product title | Blue T-Shirt |
Quantity | Number of items ordered | 2 |
Price | Item price | 29.99 |
SKU | Product SKU | BTS-001 |
Fulfillable Quantity | Quantity that can be fulfilled | 2 |
Total Discount | Total discount amount | 5.00 |
Financial Details
Field | Description | Example Value |
Subtotal | Order subtotal | 59.98 |
Total Tax | Total tax amount | 6.00 |
Total Discounts | Total discounts applied | 5.00 |
Total | Order total | 60.98 |
Total Outstanding | Amount still owed | 0.00 |
Total Refunded | Amount refunded | 0.00 |
Order Filters
You can use these filters to limit which orders are exported:
created_at: Filter by creation dateprocessed_at: Filter by processing datecustomer_id: Filter by customerfinancial_status: Filter by payment status (paid, pending, refunded, etc.)fulfillment_status: Filter by fulfillment status (fulfilled, unfulfilled, partial)status: Filter by order status (open, closed, cancelled)tag: Filter by tag (include)tag_not: Filter by tag (exclude)