The Order Export Pro app allows you to customize how your Shopify orders are exported, providing the flexibility to add various custom fields. With the app, you can easily add custom order attributes, use date filters, and configure columns to meet your specific reporting needs. This guide outlines the available fields and filters and provides examples of incorporating them into your exports.
Filters
Learn how to apply date filters and manage different date formats.
Date Format Filter
Any date field can be modified using the following format: [created_at | date_format: "YYYY-mm"]
Handled date formats:
-
YYYY: Year in 4 digits. -
YY: Year in 2 digits. -
mm: Month with a leading zero. -
m: Month without a leading zero. -
dd: Day with a leading zero. -
d: Day without a leading zero. -
H: Hours (24-hour format). -
i: Minutes. -
s: Seconds.
Objects
Understand the available fields you can include in your export, such as line items, shipping addresses, transactions, and more.
Line Items
-
[line_items.title]: The title of the product combined with the title of the variant. -
[line_items.variant_title]: The title of the product variant. -
[line_items.variant_image]: Image associated with the product variant. Falls back to the product image if no variant image is available. -
[line_items.quantity]: The quantity of the line item attributed to the staff member. -
[line_items.price]: The price of the item before discounts have been applied in the shop currency. -
[line_items.sku]: The item's SKU (stock keeping unit). -
[line_items.count]: Shows the number of items in the order. -
[line_items.totalqty_quantity]: Shows the total sum of items in the order. -
[line_items.vendor]: The name of the item's supplier. -
[line_items.grams]: The weight of the item in grams. -
[line_items.properties]: Custom information for the item that has been added to the cart. -
[line_items.properties_hidden]: Hidden custom information for the item that has been added to the cart. -
[line_items.properties.{custom_field_name}]: Specific field from custom information for the item that has been added to the cart.
Examples of custom fields:
[line_items.properties.{Add some extra fun to your gift box, the following prices are in addition to the box cost.}][line_items.properties.{Add some note to your order}]
Metafields
-
[meatafield.metafield_name]: The metafields associated with the order.
Discount Applications
-
[discount_applications.total_discounts]: Total discounts applied. -
[discount_applications.type]: The discount application type. -
[discount_applications.value]: The value of the discount application. -
[discount_applications.value_type]: The discount application type. -
[discount_applications.target_type]: The type of line on the order that the discount is applicable on.
Discount Codes
-
[discount_codes.code]: The discount code entered at checkout or the title of the applied discount. -
[discount_codes.amount]: The amount deducted from the order total. -
[discount_codes.type]: The type of discount.
Taxes
-
[tax_lines.total_tax]: Total amount added to the order for this tax in the shop currency after discounts are applied. -
[tax_lines.taxes_included]: Whether taxes are included in the order subtotal. -
[tax_lines.price]: The amount added to the order for this tax in the shop currency after discounts are applied. -
[tax_lines.rate]: The rate of tax to be applied. -
[tax_lines.title]: The name of the tax.
Shipping
-
[shipping_lines.title]: The title of the shipping method. -
[shipping_lines.price]: The price of this shipping method in the shop currency. Can't be negative. -
[shipping_lines.phone]: The phone number at the shipping address.
Fulfillments
-
[fulfillments.id]: The ID for the fulfillment. -
[fulfillments.tracking_numbers]: The tracking numbers. -
[fulfillments.tracking_urls]: The tracking URLs. -
[fulfillments.shipment_status]: The current shipment status of the fulfillment.
Transactions
-
[transactions.bin]: The issuer identification number (IIN) of the customer's credit card. -
[transactions.company]: The name of the company that issued the customer's credit card. -
[transactions.name]: The holder of the credit card. -
[transactions.number]: The customer's credit card number, with most of the leading digits redacted. -
[transactions.payment_method]: The payment method used for the transaction. -
[transactions.wallet]: Digital wallet used for the payment. -
[transactions.gateway]: The payment gateway used to process the transaction. -
[transactions.type]: The kind of transaction.
Shipping Address
-
[shipping_address.first_name]: The first name of the person associated with the shipping address. -
[shipping_address.last_name]: The last name of the person associated with the shipping address. -
[shipping_address.address1]: The street address of the shipping address. -
[shipping_address.address2]: An optional additional field for the street address of the shipping address. -
[shipping_address.city]: The city, town, or village of the shipping address. -
[shipping_address.province]: The name of the region of the shipping address. -
[shipping_address.zip]: The postal code of the shipping address. -
[shipping_address.country]: The name of the country of the shipping address.
Billing Address
-
[billing_address.first_name]: The first name of the person associated with the payment method. -
[billing_address.last_name]: The last name of the person associated with the payment method. -
[billing_address.address1]: The street address of the billing address. -
[billing_address.address2]: An optional additional field for the street address of the billing address. -
[billing_address.city]: The city, town, or village of the billing address. -
[billing_address.province]: The name of the region of the billing address. -
[billing_address.zip]: The postal code of the billing address. -
[billing_address.country]: The name of the country of the billing address.
Order Details
-
[financial_status]: The status of payments associated with the order. -
[note]: An optional note that a shop owner can attach to the order. -
[confirmed]: Whether inventory has been reserved for the order. -
[tags]: Tags attached to the order. -
[order_status_url]: The URL pointing to the order status web page, if applicable. -
[total_price]: The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. -
[fulfillment_status]: Filter orders by their fulfillment status. -
[closed_at]: The date and time when the order was closed. -
[updated_at]: The date and time when the order was last modified. -
[cancelled_at]: The date and time when the order was canceled. -
[cancel_reason]: The reason why the order was canceled. -
[total_weight]: The sum of all line item weights in grams. -
[phone]: The customer's phone number for receiving SMS notifications. -
[buyer_accepts_marketing]: Whether the customer consented to receive email updates from the shop. -
[landing_site]: The URL for the page where the buyer landed when they entered the shop. -
[referring_site]: The website where the customer clicked a link to the shop. -
[reference]: A reference to the order. -
[source_url]: A valid URL to the original order on the originating surface. -
[source_name]: The source of the checkout. -
[customer_locale]: The two or three-letter language code, optionally followed by a region modifier. -
[browser_ip]: The IP address of the browser used by the customer when they placed the order. -
[processed_at]: The date and time when an order was processed. -
[processing_method]: The processing method used for the transaction. -
[order_number]: The order's position in the shop's count of orders starting at 1001. -
[email]: The customer's email address. -
[customer.first_name]: The customer's first name. -
[order.customer.last_name]: The customer's last name. -
[subtotal_price]: The price of the order in the shop currency after discounts but before shipping, duties, taxes, and tips. -
[note_attributes]: Extra information that is added to the order. -
[currency]: The three-letter code (ISO 4217 format) for the shop currency. -
[created_at]: The autogenerated date and time when the order was created in Shopify.
