Orders
Orders with line items, customer and addresses, totals, discounts, shipping lines, taxes, fulfillments (shipments), refunds and payment transactions. Returns, disputes, payment terms and fraud analysis are not included.
321 fields backed up
Whether the customer can be notified by email
Cancellation reason
Date the order was cancelled
Whether payment can still be captured
Order-level discount amount when the order was created · amount + currency
Whether the order is closed (archived)
Date the order was closed
Confirmation number shown to the customer
Date the order was created
Store currency of the order
Current order-level discount total, after refunds and edits · amount + currency
Current shipping price, after refunds and discounts · amount + currency
Current number of items, after returns, refunds and edits
Current subtotal, after returns and refunds · amount + currency
Current total of additional fees · amount + currency
Current total discounts, after returns and refunds · amount + currency
Current total duties · amount + currency
Current order total, after returns and refunds · amount + currency
Current total tax, after returns and refunds · amount + currency
Current total weight in grams
Whether the customer accepted marketing at checkout
Language the customer checked out in
Discount code used
All discount codes used · list
Payment status (paid, pending, refunded, etc.)
Fulfillment status (fulfilled, unfulfilled, partially fulfilled, etc.)
Whether duties are included in the price
Whether the order has been edited
Customer email on the order
Whether taxes are estimated rather than final
Whether there are items left to fulfill
Shopify ID
Order number (e.g. #1001)
Net payment received, after refunds and adjustments · amount + currency
Order note
Original total of additional fees, before returns and edits · amount + currency
Original total duties, before returns and edits · amount + currency
Original order total when created, before returns, refunds and edits · amount + currency
Payment gateways used · list
Customer phone on the order
Purchase order number
Currency the customer paid in
Date the order was placed
Difference between expected and actual refund amounts · amount + currency
Whether the order can still be refunded
Whether any item requires shipping
Whether items can be restocked
Return status
Source identifier (e.g. POS receipt number)
Where the order came from (online store, POS, draft order, an app, etc.)
Number of items when the order was created
Subtotal before returns, after discounts · amount + currency
Tags · list
Whether the order is tax exempt
Whether prices include taxes
Whether this is a test order
Amount authorized but not yet captured · amount + currency
Total discounts before returns · amount + currency
Amount still unpaid · amount + currency
Order total before returns, including taxes and discounts · amount + currency
Total amount paid · amount + currency
Total amount refunded · amount + currency
Total shipping refunded · amount + currency
Total shipping price · amount + currency
Total tax before returns · amount + currency
Tip received · amount + currency
Total weight in grams
Date the order was last updated
Additional fees (duties, import fees, special handling)list — each item includes
Shopify ID of the fee
Fee name
Fee amount · amount + currency
Taxes applied to the feelist — each item includes
Tax amount · amount + currency
Tax rate (as a fraction, e.g. 0.21)
Tax rate as a percentage
Where the tax rate came from (e.g. Shopify, an app)
Tax name (e.g. VAT)
App or channel the order was created through
Shopify ID of the app
App name
Billing address
Address line 1
Address line 2
City
Company
Country
Country code
First name
Shopify ID of the address
Last name
Full name
Phone number
Province / state
Province / state code
ZIP / postal code
Cancellation details
Staff note added when cancelling
Current taxes, after returnslist — each item includes
Tax amount · amount + currency
Tax rate (as a fraction, e.g. 0.21)
Tax rate as a percentage
Where the tax rate came from (e.g. Shopify, an app)
Tax name (e.g. VAT)
Additional details (custom key-value notes attached to the order)list — each item includes
Attribute name
Attribute value
Customer
First name
Shopify ID of the customer
Last name
Customer email
Email address
Customer phone
Phone number
Every discount applied (discount codes, automatic discounts, manual discounts)list — each item includes
How the discount is spread across items (across, each or one)
Order in which the discount was applied
Which items it applies to (all, entitled or explicit)
What it applies to (line items or shipping)
Discount value (fixed amount or percentage)
Fixed discount amount
Fixed discount currency
Discount percentage
Address shown on the order (shipping address, or billing address when nothing is shipped)
Address line 1
Address line 2
City
Company
Country
Country code
First name
Shopify ID of the address
Last name
Full name
Phone number
Province / state
Province / state code
ZIP / postal code
Fulfillments (shipments)list — each item includes
Date the fulfillment was created
Delivery date
Shipment status shown in admin (in transit, delivered, etc.)
Estimated delivery date
Shopify ID of the fulfillment
Date the shipment went in transit
Fulfillment name (e.g. #1001.1)
Whether the fulfillment requires shipping
Fulfillment status (success, cancelled, error, etc.)
Number of items in the fulfillment
Location it was fulfilled from
Shopify ID of the location
Location name
Address it was shipped from
Address line 1
Address line 2
City
Country code
Province / state code
ZIP / postal code
Fulfillment service that handled it
Service handle
Shopify ID of the service
Tracking detailslist — each item includes
Shipping carrier
Tracking number
Line items (products ordered)list — each item includes
Shopify ID of the line item
Whether the item is a gift card
Whether the line item can still be edited
Item name (product and variant)
Quantity that cannot be fulfilled
Original line total before discounts · amount + currency
Quantity ordered
Quantity that can still be refunded
Whether the item requires shipping
SKU
Linked product
Shopify ID of the product
Product title
Country-specific fields required for local regulations (e.g. tax IDs)list — each item includes
Country the field applies to
Field key
Purpose (shipping or tax)
Field title
Field value
App acting as merchant of record (handling taxes)
Shopify ID of the app
App name
Metafieldslist — each item includes
Date the metafield was created
Shopify ID of the metafield
Metafield key
Metafield namespace
Metafield value type (e.g. single line text, JSON, product reference)
Date the metafield was last updated
Metafield value
Line items that cannot be fulfilled (e.g. removed in an order edit)list — each item includes
Shopify ID of the line item
Whether the item is a gift card
Whether the line item can still be edited
Item name (product and variant)
Quantity that cannot be fulfilled
Original line total before discounts · amount + currency
Quantity ordered
Quantity that can still be refunded
Whether the item requires shipping
SKU
Linked product
Shopify ID of the product
Product title
Refundslist — each item includes
Date the refund was created
Refund note
Total amount of the refund · amount + currency
Refunded dutieslist — each item includes
Refunded duty amount · amount + currency
Duty being refunded
Shopify ID of the duty
Refunded itemslist — each item includes
Shopify ID of the refunded item entry
Unit price refunded · amount + currency
Quantity refunded
Refunded subtotal for the item · amount + currency
Refunded tax for the item · amount + currency
Line item being refunded
Shopify ID of the line item
Item name
Refunded shippinglist — each item includes
Shopify ID of the refunded shipping entry
Refunded shipping amount · amount + currency
Refunded shipping tax · amount + currency
Shipping line being refunded
Shopify ID of the shipping line
Shipping method name
Point of sale location the order was placed at
Shopify ID of the location
Location name
Location address
Address line 1
Address line 2
City
Country
Country code
Phone number
Province / state
Province / state code
ZIP / postal code
Shipping address
Address line 1
Address line 2
City
Company
Country
Country code
First name
Shopify ID of the address
Last name
Full name
Phone number
Province / state
Province / state code
ZIP / postal code
Shipping methods on the orderlist — each item includes
Carrier identifier
Shipping method code
Delivery category
Shipping price after discounts · amount + currency
Shipping price before discounts · amount + currency
Phone number for the shipping method
Shipping rate handle
Where the rate came from (e.g. shopify, a carrier app)
Shipping method name
Taxes on the order before returnslist — each item includes
Tax amount · amount + currency
Tax rate (as a fraction, e.g. 0.21)
Tax rate as a percentage
Where the tax rate came from (e.g. Shopify, an app)
Tax name (e.g. VAT)
Cash rounding adjustments (for currencies rounded at the till)
Rounding applied to the payment · amount + currency
Rounding applied to refunds · amount + currency
Payment transactions (authorizations, captures, sales, refunds, voids)list — each item includes
Masked payment account number (e.g. last card digits)
Cash rounding on the transaction · amount + currency
Transaction amount · amount + currency
Authorization code from the payment provider
Date the authorization expires
Date the transaction was created
Error code, if the transaction failed
Payment gateway display name
Payment gateway
Shopify ID of the transaction
Transaction kind (authorization, capture, sale, refund, void)
Whether it was a manual payment method
Whether it can be captured manually
Maximum amount still refundable · amount + currency
Payment ID from the payment provider
Date the transaction was processed
Currency the payment was settled in
Exchange rate used for settlement
Transaction status (success, pending, failure, error)
Whether it was a test transaction
Amount not yet paid out by the payment provider · amount + currency
Processing feeslist — each item includes
Fee amount · amount + currency
Flat part of the fee · amount + currency
Flat fee name
Shopify ID of the fee
Percentage rate of the fee
Rate name
Tax on the fee · amount + currency
Fee type
Transaction this one relates to (e.g. the authorization a capture belongs to)
Shopify ID of the parent transaction
Shopify Payments details
Extended authorization dates
Date the extended authorization expires
Date the standard authorization expires
Refund details
Acquirer reference number (ARN) of the refund
Generated from the queries the backup runs, so this list always matches what is stored. Themes are backed up as complete theme files and are not listed field by field.
TinyBackup