· DataEase · Documentation  · 6 min read

Orders

An Order is what you get after a customer checks out.
With DataEase you can:

  • Fix prices, quantities, or tags across hundreds of orders.
  • Add tracking numbers, send invoices, or refund lines in bulk.
  • Export full order history for reports or accounting.

Shopify order guide.

Table of Contents

  1. Export
  2. Import
  3. Field reference
  4. Filters

2. Export

  1. Pick CSV (best for very large files) or Excel.
  2. Select Order.
  3. Choose columns you need—name, financialStatus, lineItemQuantity, etc.
  4. Run the task and download your file.
    More details: Export guide

3. Import

Commands

Order row command → CREATE, UPDATE, REPLACE, DELETE, IGNORE
Line row itemCommand → CREATE, UPDATE, MERGE, DELETE, IGNORE
Other line types follow the same pattern.
Special action column (import-only):
COMPLETE, CANCEL, SEND_CONFIRMATION, FULFILL, REFUND

Tip: For CREATE you must give at least email or phone (or an existing customerId).

Steps

  1. Grab the sample file: Order-import-sample.xlsx
  2. Edit header row (LineType = ORDER), then add extra rows for LINE_ITEM, SHIPPING_LINE, etc.
  3. Map columns in DataEase, upload, and start.
    Full instructions: Import guide

4. Field reference

Below is a shortened** list of the most-used columns.
Gray rows in your export are export-only (can’t be changed by import).

Order-level (LineType = ORDER)

id

Order ID. Needed for UPDATE, REPLACE, DELETE.

command

Row action: CREATE | UPDATE | REPLACE | DELETE | IGNORE.

currencyCode

Shop currency when order was placed. Leave blank to use store default.

presentmentCurrencyCode

Currency shopper paid in (multi-currency shops).

email

Customer email for receipts.

phone

Customer phone number.

tags

Comma-separated tags. See tag guide.

tagsCommand

ADD, REMOVE, or REPLACE tags on the order.

buyerAcceptsMarketing

true if buyer opted-in to marketing.

poNumber

Purchase-order number.

taxesIncluded

true if item prices already include tax.

displayFinancialStatus

AUTHORIZED, PAID, REFUNDED, etc. (Export-only)

displayFulfillmentStatus

FULFILLED, PARTIALLY_FULFILLED, etc. (Export-only)

Line items (LineType = LINE_ITEM)

lineItemVariantId

Variant ID to add / update. Leave blank for custom item.

lineItemQuantity

Quantity ordered.

lineItemSku

SKU (used to locate variant if variantId is blank).

lineItemOriginalUnitPrice

Price before discounts (shop currency).

lineItemAppliedDiscountValue

Discount value on this line.

lineItemAppliedDiscountValueType

FIXED_AMOUNT or PERCENTAGE.

Shipping lines (LineType = SHIPPING_LINE)

shippingLineTitle

Name of the shipping service.

shippingLinePrice

Price in shop currency.

shippingLinePresentmentPrice

Price in shopper currency.

Fulfillments (LineType = FULFILLMENT)

fulfillmentTrackingCompany

Tracking carrier (exact name from Shopify list).

fulfillmentTrackingNumbers

Tracking numbers (comma-separated if multiple).

fulfillmentLocationId

Location ID to deduct inventory from.

fulfillmentNotifyCustomer

true to email shipping confirmation.

Transactions & Refunds (LineType = TRANSACTION or REFUND)

transactionKind

AUTHORIZATION | CAPTURE | REFUND | SALE | VOID.

transactionAmount

Amount in shop currency.

refundLineItemRestockType

RETURN or CANCEL when restocking items.

Metafields

metafields

Custom columns for extra data. See Metafields guide.

Export-only fields

Below are all the extra “gray-only” columns that DataEase exports for Orders. They’re read-only – you can’t change them by import, but they’re handy for reports, fraud checks, marketing, and support.

Order totals & prices

totalPrice

Order grand-total in shop currency (taxes + shipping + discounts included).

totalShippingPrice

Shipping cost before discounts or refunds.

totalWeight

Total weight of all items (grams).

totalTax

Total tax charged on the order.

subtotalPrice

Item subtotal after item-level discounts, before tax & shipping.

currentSubtotalPrice

Subtotal after returns or edits.

totalShopCurrencyDiscount

All discounts (order + items) in shop currency at creation.

totalPresentmentCurrencyDiscount

Current order-level discount in shopper currency.

currentTotalDuties

Duties owed after returns (null if not used).

currentTotalAdditionalFees

Extra fees (gift-wrap, recycling, etc.) after returns.

originalTotalAdditionalFeesSet

Extra fees at the moment the order was created.

totalOutstandingSet

Balance still to pay (+) or refund (–) on the order.

currentTotalPriceSet

Final grand-total after any edits or returns.

Order status & metadata

publicationSource

Sales channel that created the order (Online Store, POS, etc.).

statusPageUrl

Customer “order status” page link.

displayFulfillmentStatus

Friendly fulfillment state (FULFILLED, PARTIALLY_FULFILLED…).

clientIp

IP address that placed the order.

canNotifyCustomer

true if an email address exists for notifications.

daysToConversion

Days from first shop visit to purchase.

cancellationNote

Staff note recorded when the order was cancelled.

riskRecommendation

Fraud-risk advice: ACCEPT, INVESTIGATE, or CANCEL.

createdAt

Date/time the order was made.

updatedAt

Last time anything changed on the order.

cancelledAt

When the order was cancelled (null if never).

Marketing / visit tracking

lastVisitLandingPage

First page the buyer landed on in their purchase session.

lastVisitSource

Marketing source (Google, Email, Direct, etc.).

lastVisitSourceType

Marketing tactic type (ad, social, referral…).

lastVisitUtmCampaign

UTM campaign name.

lastVisitUtmContent

UTM content tag.

lastVisitUtmMedium

UTM medium (banner, email, cpc…).

lastVisitUtmSource

UTM source (google, newsletter…).

lastVisitUtmTerm

UTM search term.

Customer snapshot (export-only fields)

customerCreatedAt

When the customer record was first created.

customerLocale

Buyer’s preferred language.

customerNumberOfOrders

Lifetime order count for this customer.

customerState

Account state – INVITED, ENABLED, DISABLED, or DECLINED.

customerAmountSpentAmount

Lifetime spend amount.

customerAmountSpentCurrencyCode

Currency of lifetime spend.

customerTags

Tags already on the customer profile.

customerSmsMarketingConsent

Last SMS-marketing consent update time.

customerEmailMarketingConsent

Last email-marketing consent update time.

customerCompanyName

B2B company name (if any).

customerCompanyId

Company ID linked to order.

customerCompanyExternalId

External ERP/CRM company ID.

customerLocationId

Company location ID.

customerLocationExternalId

External ID for the company location.

customerLocationName

Friendly name of the company location.

Extra ship & address info

shippingCity

City part of the shipping address.

shippingCountry

Country name of shipping address.

shippingProvince

State / province name of shipping address.

Line-item analytics

lineItemName

Product title with variant title at time of sale.

lineItemOriginalTotal

Line-item total before any discounts.

lineItemTotalPresentmentCurrencyDiscount

Discount applied to this line (shopper currency).

lineItemVariantSku

Variant SKU captured at order time.

lineItemVariantProductTags

Product tags for this variant (snapshot).

lineItemVariantInventoryQuantity

Stock on hand for the variant when exported.

lineItemOriginalUnitPrice

Unit price at order creation (shop currency).

lineItemVariantProductHandle

Product handle recorded at sale time.

lineItemDiscountAllocations

JSON blob of discount splits on this item.

lineItemDiscountPerItem

Discount total per unit in shop currency.

lineItemVariantProductType

Product type snapshot.

lineItemVariantWeightUnit

Weight unit (g, kg, oz, lb).

lineItemVariantWeight

Weight value.

lineItemVariantCost

Cost per unit (requires “view product costs” permission).

lineItemVariantCountryCodeOfOrigin

Country of origin code.

lineItemVariantHSCode

Harmonized tariff code (6–13 digits).

lineItemVariantProvinceCodeOfOrigin

Province/state of origin code.

Fulfillment audit

fulfillmentStatus

Fulfillment state (SUCCESS, FAILURE, etc.).

fulfillmentName

Reference name (e.g., “F-1001”).

fulfillmentCreatedAt

When fulfillment record was made.

fulfillmentUpdatedAt

Last change to the fulfillment record.

fulfillmentDeliveredAt

Date package was delivered (if carrier updates).

fulfillmentEstimatedDeliveryAt

Estimated delivery date.

fulfillmentInTransitAt

When carrier marked parcel “in transit”.

fulfillmentRequiresShipping

true if any line in this fulfillment requires shipping.

fulfillmentTotalQuantity

Sum of all line-item quantities inside this fulfillment.

fulfillmentDisplayStatus

Friendly status (IN_TRANSIT, DELIVERED…).

fulfillmentCountry

Country name of the fulfillment location.

Shipping-rate details

shippingLineSource

Where the rate came from (Manual, App, Carrier).

shippingLineDiscountedPrice

Shipping price after discounts (shop currency).

shippingLineDiscountedPresentmentPrice

Shipping price after discounts (shopper currency).

Transaction analytics

transactionPaymentId

Gateway’s payment reference ID.

transactionCreatedAt

When the transaction record was made.

transactionErrorCode

Gateway error code if payment failed.

transactionAuthorizationExpiresAt

When an auth will expire (Plus only).

transactionFormattedGateway

Friendly gateway name (e.g., “Stripe”).

transactionManuallyCapturable

true if payment can be captured by hand later.

transactionMaximumRefundableAmount

Remaining refundable amount (for suggested refunds).

transactionMultiCapturable

true if multiple captures allowed.

transactionProcessedAt

Timestamp of transaction processing.

Payment-card details (masked)

paymentDetailsAvsResultCode

Address-verification code from gateway.

paymentDetailsBin

First six digits of the card (BIN/IIN).

paymentDetailsNumber

Masked card number (XXXX-XXXX-1234).

paymentDetailsName

Cardholder name.

paymentDetailsExpirationYear

Card expiry year.

paymentDetailsExpirationMonth

Card expiry month.

paymentDetailsCvvResultCode

CVV match result.

paymentDetailsCompany

Card brand (Visa, MasterCard…).

paymentDetailsPaymentMethodName

Gateway-specific method (e.g., “visa_debit”).

paymentDetailsWallet

Digital wallet used (APPLE_PAY, GOOGLE_PAY…).

Refund audit

refundId

Refund record ID.

refundCreatedAt

When refund was made.

refundedAmount

Total refunded amount (shop currency).

refundedPresentmentAmount

Total refunded amount (shopper currency).

refundLineItemLocationId

Location inventory was returned to.

refundLineItemRestocked

true if stock was restocked.

refundLineItemRefundedAmount

Refund amount for that line (shop currency).

refundLineItemRefundedPresentmentAmount

Refund amount for that line (shopper currency).

5. Filters

Use these when exporting to narrow the result set:

Id

Exact order ID.

Name

Shopify order number (e.g., #1001).

CreatedAt

Creation date / range.

ProcessedAt

Payment-processed date / range.

UpdatedAt

Last change date / range.

ClosedAt

Order-closed date / range.

CancelledAt

Cancellation date / range.

CancelReason

Reason for cancellation (CUSTOMER, INVENTORY, …).

FinancialStatus

PENDING, PAID, PARTIALLY_PAID, REFUNDED, …

DisplayFinancialStatus

Aggregated financial status for UI.

FulfillmentStatus

UNFULFILLED, PARTIALLY_FULFILLED, FULFILLED, …

DisplayFulfillmentStatus

Aggregated fulfillment status for UI.

OrderFulfillmentStatus

Shipment status filter (scheduled, in_progress, …).

ReturnStatus

NONE, PARTIALLY_RETURNED, RETURNED.

RiskLevel

LOW, MEDIUM, HIGH fraud risk.

RiskRecommendation

ACCEPT, INVESTIGATE, CANCEL.

ChargebackStatus

NONE, UNDER_REVIEW, WON, LOST.

Gateway

Payment gateway name (PayPal, Shopify Payments, …).

PaymentId

Specific payment identifier.

PaymentProviderId

Provider-side payment ID.

CreditCardLast4

Last four digits of the card.

TransactionKind

AUTHORIZATION, CAPTURE, REFUND, …

TransactionStatus

SUCCESS, FAILURE, PENDING.

Test

true / false — test orders only.

Channel

POS, Online Store, Draft, etc.

ChannelId

Internal sales-channel ID.

SalesChannel

Human-readable channel name (Shop App, IG Shop, …).

SourceName

Source tag (web, pos, api, draft_order).

SourceIdentifier

External POS / third-party order ID.

CheckoutToken

Checkout session token.

CartToken

Cart ID tied to the order.

DeliveryMethod

SHIPPING, LOCAL_PICKUP, LOCAL_DELIVERY.

FulfillmentLocationId

Location that fulfilled the order.

ReferenceLocationId

POS / origin location reference.

LocationId

Store location where order was created.

PoNumber

Purchase-order reference number.

ConfirmationNumber

External confirmation / receipt number.

Sku

Orders containing a specific SKU.

SubtotalLineItemsQuantity

Total item quantity (supports ranges).

DiscountCode

Orders that used a given discount code.

Tag

Orders tagged with a specific tag.

Email

Customer email match.

Phone

Customer phone match.

CustomerId

All orders for one customer.

CustomerState

ENABLED, INVITED, DECLINED, DISABLED.

CompanyId

B2B company ID.

FraudProtectionLevel

NOT_PROTECTED or PROTECTED.

Status

OPEN, CLOSED, CANCELLED.

CartToken

Filter by original cart token.

ChargebackStatus

Chargeback state of the order.

lastVisitUtmMedium

UTM medium captured at purchase.

Need help? Our support team answers within 24 hours.

Share: