Skip to content
DataEase
Try for free

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

Section titled “Table of Contents”
  1. Export
  2. Import
  3. Field reference
  4. Filters

2. Export

Section titled “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

Section titled “3. Import”

Commands

Section titled “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).

When creating orders on a trial or dev store, there’s a cap: up to 5 new orders per minute.

Refunds are never sent twice. If an earlier attempt of the same refund in this import failed, Shopify refuses to repeat it (IDEMPOTENCY_PREVIOUS_ATTEMPT_FAILED). DataEase doesn’t retry it with a new request (that could refund twice): the refund rows get the error “Refund was not applied…”. Check the rows and run the import again.

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

Section titled “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)

Section titled “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)

Section titled “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)

Section titled “Shipping lines (LineType = SHIPPING_LINE)”

  • shippingLineTitle — Name of the shipping service.

  • shippingLinePrice — Price in shop currency.

  • shippingLinePresentmentPrice — Price in shopper currency.

Fulfillments (LineType = FULFILLMENT)

Section titled “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)

Section titled “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

Section titled “Metafields”

Export-only fields

Section titled “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

Section titled “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

Section titled “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

Section titled “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)

Section titled “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

Section titled “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

Section titled “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

Section titled “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

Section titled “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

Section titled “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)

Section titled “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

Section titled “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

Section titled “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.

Additional fields

Section titled “Additional fields”

More columns DataEase supports for this entity:

  • discountCodes — Discount codes applied to the order.
  • note — Internal note about the order.
  • customAttributes — Custom attributes for the order in JSON format.
  • retailLocationId — ID of the retail location associated with the order.
  • isTest — Indicates if the order is a test order.
  • refundOnCancellation — Whether to refund the order upon cancellation.
  • storeCreditRefundExpiration — Expiration date for store credit refunds.
  • restockOnCancellation — Whether to restock items upon order cancellation.
  • sourceUrl — URL where the order originated.
  • lastVisitReferrerUrl — URL of the last referrer before the order was placed.
  • inventoryBehaviour — Inventory behavior for the order.
  • sendFulfillmentReceipt — Whether to send a fulfillment receipt to the customer.
  • sendReceipt — Whether to send an order receipt to the customer.
  • notifyCustomerOnUpdate — Notify customer when the order is updated.
  • updateOrderStaffNote — Staff note to update on the order.
  • freeShippingDiscountCode — Discount code for free shipping.
  • fixedDiscountShopAmount — Fixed discount amount in shop currency.
  • fixedDiscountPresentmentAmount — Fixed discount amount in presentment currency.
  • fixedDiscountCode — Discount code for a fixed amount discount.
  • percentageDiscountCode — Discount code for a percentage discount.
  • percentageDiscountCodePercentage — Percentage value of the discount code.
  • orderFulfillmentLocationId — Location ID for order fulfillment.
  • orderFulfillmentShipmentStatus — Shipment status of the order fulfillment.
  • orderFulfillmentNotifyCustomer — Notify customer about order fulfillment.
  • orderFulfillmentTrackingCompany — Tracking company for order fulfillment.
  • orderFulfillmentTrackingNumber — Tracking number for order fulfillment.
  • customerEmail — Email address of the customer.
  • customerFirstName — First name of the customer.
  • customerLastName — Last name of the customer.
  • customerNote — Note from the customer.
  • customerPhone — Phone number of the customer.
  • customerTaxExempt — Indicates if the customer is tax-exempt.
  • billingFirstName — First name for billing.
  • billingLastName — Last name for billing.
  • billingName — Full name for billing.
  • billingCompany — Company name for billing.
  • billingPhone — Phone number for billing.
  • billingAddress1 — First line of the billing address.
  • billingAddress2 — Second line of the billing address.
  • billingCity — City for billing.
  • billingCountry — Country for billing.
  • billingCountryCode — Country code for billing.
  • billingZip — ZIP code for billing.
  • billingProvince — Province for billing.
  • billingProvinceCode — Province code for billing.
  • shippingFirstName — First name for shipping.
  • shippingLastName — Last name for shipping.
  • shippingName — Full name for shipping.
  • shippingCompany — Company name for shipping.
  • shippingPhone — Phone number for shipping.
  • shippingAddress1 — First line of the shipping address.
  • shippingAddress2 — Second line of the shipping address.
  • shippingCountryCode — Country code for shipping.
  • shippingZip — ZIP code for shipping.
  • shippingProvinceCode — Province code for shipping.
  • lineItemId — ID of the line item.
  • lineItemTaxable — Indicates if the line item is taxable.
  • lineItemTitle — Title of the line item.
  • lineItemVariantBarcode — Barcode of the line item variant.
  • lineItemVariantTitle — Title of the line item variant.
  • lineItemVendor — Vendor of the line item.
  • lineItemUnitPrice — Unit price of the line item.
  • lineItemUnitPresentmentPrice — Presentment price of the line item unit.
  • lineItemIsGiftCard — Indicates if the line item is a gift card.
  • lineItemRequiresShipping — Indicates if the line item requires shipping.
  • lineItemProductId — Product ID of the line item.
  • lineItemCustomAttributes — Custom attributes for the line item in JSON format.
  • lineItemLocationId — Location ID for the line item.
  • LineItemQuantityRestock — Restock quantity for the line item.
  • LineItemAllowDuplicates — Allow duplicate line items.
  • fulfillmentId — ID of the fulfillment.
  • fulfillmentTrackingUrls — Tracking URLs for the fulfillment.
  • fulfillmentAddress1 — First line of the fulfillment address.
  • fulfillmentAddress2 — Second line of the fulfillment address.
  • fulfillmentCity — City for fulfillment.
  • fulfillmentCountryCode — Country code for fulfillment.
  • fulfillmentProvince — Province for fulfillment.
  • fulfillmentProvinceCode — Province code for fulfillment.
  • fulfillmentZip — ZIP code for fulfillment.
  • fulfillmentMessage — Message for the fulfillment.
  • shippingLineId — ID of the shipping line.
  • shippingLineCode — Code of the shipping line.
  • transactionId — ID of the transaction.
  • transactionPresentmentAmount — Presentment amount of the transaction.
  • transactionAuthorizationCode — Authorization code for the transaction.
  • transactionGateway — Payment gateway for the transaction.
  • transactionTest — Indicates if the transaction is a test.
  • transactionParentTransactionId — Parent transaction ID.
  • transactionGiftCardId — Gift card ID used in the transaction.
  • transactionReceiptJson — Transaction receipt in JSON format.
  • refundNote — Note for the refund.
  • refundDiscrepancyReason — Reason for refund discrepancy.
  • refundNotifyCustomer — Notify customer about the refund.
  • refundFullShippingAmount — Refund the full shipping amount.
  • refundShippingPresentmentAmount — Presentment amount for shipping refund.
  • lineType — Type of line item.
  • taxLines — Tax lines associated with the order.