Shopify Orders – Available Columns For Export And Import

Last updated on September 24, 2024

When importing or exporting Shopify order data, it is essential to have a solid understanding of the data at hand. Any errors in your import file could lead to unexpected issues with your order import and export.

This article provides a detailed overview of the data columns that can be imported or exported using the StoreRobo Import Export Suite app.

>> Download sample CSV

Basic columns

Basic columns in a Shopify orders export file typically contain the core order information essential for managing your order data.

Column	Explanation	Allowed values / Examples
ID	Unique character generated by Shopify to identify each Order.	Allowed values: Number Example: 232342332
Name	Name of the order. Shopify allows several orders to have the same name, but the app uses the Order Name as a unique identifier, similar to how a Handle functions for Products.Keeping a unique name for each order is preferred, while importing.	Allowed values: Text Example: #83537
Send Receipt	Indicates whether to send an order confirmation email to the customer when an order is created or updated. The default setting is FALSE.	Allowed values: `TRUE` `FALSE` Example: `FALSE`
Inventory Behaviour	Specifies the behavior to use when updating inventory (default: bypass). bypass: Do not claim inventory. decrement_ignoring_policy: Ignore the product’s inventory policy and claim all amounts regardless. decrement_obeying_policy: Follow the product’s inventory policy.	Allowed values: `bypass` `decrement_ignoring_policy` `decrement_obeying_policy` Example: `bypass`
Number	Serves as an internal identifier to help the import process determine where new orders begin in the file, especially when ID and Name fields are empty. If an order spans multiple rows (for example, due to multiple line items), the “Number” column ensures these rows are grouped together. Each order should have a unique number, and all rows belonging to the same order should share the same number.This number cannot be set or updated once the order is imported, reinforcing its role as a temporary identifier during the import process.	Allowed values: Number Example: 3
Phone	Phone number provided by the customer during the checkout process.Phone number can differ from the customer’s phone number saved in their profile. This allows for flexibility if the customer wants to use a different phone number for a specific order.The phone number must include the country code to ensure it is valid for the respective country.	Allowed values: Phone Number Example: +1234343233
Email	Allows for the inclusion of a contact email address for each order, which can differ from the email associated with the customer’s account.Shopify rigorously validates email addresses to ensure they correspond to real addresses. If an email address fails validation during import, it’s essential to verify the correctness of the email to avoid errors.	Allowed values: Email Example: abc@gmail.com
Note	Include any special instructions or requests provided by the customer during the checkout process. This could include customization details, delivery instructions, or gift messages.	Allowed values: Text Example: Please ensure delivery by Friday.
Tags	Categorize orders based on different attributes such as order type, status, source, or any other relevant criteria specific to your business.	Allowed values: Comma Separated List Example: Urgent, Gift, Special Occasion
Created At	Records the date and time when each order was created in your Shopify store.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Updated At	Captures the date and time of the last modification made to each order.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Cancelled At	Captures the date and time when each order was cancelled.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Cancel: Reason	Provides a space to document the reason behind each order cancellation.	Allowed values: Text Example: Payment issue
Cancel: Send Receipt	Whether a receipt or confirmation has to be sent to the customer after their order was cancelled.If the Order is already canceled, then it will fail – because it cannot send the e-mail to an already canceled order.	Allowed values: `TRUE` `FALSE` Example: `FALSE`
Cancel: Refund	Setting the Cancel: Refund column to TRUE for a canceled order triggers an automated refund process. This ensures that customers are refunded fully without manual intervention, streamlining the cancellation workflow.	Allowed values: `TRUE` `FALSE` Example: `FALSE`
Processed At	Date and time when each order was marked as processed in your Shopify store.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Closed At	Date and time when each order reached a closed state within your Shopify store.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Currency	Currency code used for pricing and transactions associated with each order.	Allowed values: Currency code in ISO 4217 format Example: USD
Source	The sales channel or marketing source responsible for generating each order. This could include channels such as web, POS (Point of Sale), iPhone, Android, or Shopify draft orders.	Allowed values: Text Example: shopify_draft_orders
Source Identifier	Allows you to include a unique custom identifier or code that provides further details about the source of each order. This could be a campaign code, affiliate ID, or any other unique identifier relevant to your business.	Allowed values: Text Example: 4f53fd1129dc1600a9de9e20c74440e9
Source URL	Reference to the original order on the originating surface. This URL provides merchants with direct access to the specific page or location where the order was originally generated.	Allowed values: URL Example: https://dummy_store.com/orders/12345
User ID	Represents a unique identifier associated with the user or customer who placed the order.	Allowed values: Number Example: 232342332
Order Status URL	Represents a URL that provides merchants with direct access to view the status of each order. This URL typically leads to a page where merchants can track the progress of orders, view order details, and take necessary actions related to order fulfillment.	Allowed values: URL Example: https://dummy_store.com/orders/4f53fd
Weight Total	Represents the total weight of the order. This weight typically includes the combined weight of all items included in the order.	Allowed values: Number Example: 2323
Price: Total Line Items `export only`	Total price of all line items within each order	Allowed values: Number Example: 2323
Price: Current Subtotal `export only`	Current value of the order, including discounts, but before shipping and taxes, after any order edits, refunds and returns.	Allowed values: Number Example: 7355
Price: Subtotal `export only`	This subtotal reflects the total price of all line items in the order including discounts, but before shipping and taxes.	Allowed values: Number Example: 7355
Tax: Title	Title or name of the tax applied to the order. You have the flexibility to specify up to 100 different tax titles or names that can be applied at the order level. `Tax 1: Title` `Tax 2: Title` `Tax 3: Title` …. `Tax 100: Title`	Allowed values: Text Example: VAT
Tax: Rate	Represents the tax rate applied to the order. Indicates the percentage or rate at which the tax is applied to the order.Ensure that tax rates are formatted as decimal values representing the percentage rate (e.g., 0.08 for 8% tax). `Tax 1: Rate` `Tax 2: Rate` `Tax 3: Rate` …… `Tax 100: Rate`	Allowed values: Decimal value less than or equal to 1 Example: 0.4
Tax: Price	Represents the actual monetary amount of tax applied to the order. `Tax 1: Price` `Tax 2: Price` `Tax 3: Price` … `Tax 100: Price`	Allowed values: Decimal Number Example: 459.5
Tax: Included	Indicates whether the tax amount is included in the prices of the order’s items, or if it should be added separately.	Allowed values: `TRUE` `FALSE` Example: `FALSE`
Tax: Total	Represents the total amount of tax applied to the entire order. This column specifies the cumulative tax amount that will be added to the order’s total in Shopify Admin.	Allowed values: Decimal Number Example: 459.5
Price: Total Discount	The total discount amount applied to the entire order. This column specifies how much the order’s total price is reduced by discounts.	Allowed values: Decimal Number Example: 9.55
Price: Total Shipping	The total shipping cost for the order.	Allowed values: Decimal Number Example: 9.55
Price: Current Total Duties	The total amount of duties applied to the order, expressed in the shop’s currency. This amount reflects the duties after any order edits, returns, and refunds.	Allowed values: Decimal Number Example: 9.55
Price: Total Duties	Orders original total duties amount in the shop currency.	Allowed values: Decimal Number Example: 33.55
Price: Current Total Fees	The total amount of additional fees applied to the order, expressed in the shop’s currency. This includes any extra charges beyond the standard product price, taxes, shipping, and duties. The amount reflects the fees after any order edits, returns, and refunds.	Allowed values: Decimal Number Example: 33.55
Price: Total Fees	The total amount of additional fees applied to the order.	Allowed values: Decimal Number Example: 33.55
Price: Total Refund	Total amount refunded for an order. This includes any refunds processed for the order, covering the entire order amount or specific items within the order.	Allowed values: Decimal Number Example: 33.55
Price: Total Outstanding	The total amount of money owed by the customer for an order. This includes any outstanding balance remaining after deducting refunds, payments, or adjustments.	Allowed values: Decimal Number Example: 33.55
Price: Current Total	Current total amount payable for an order, reflecting any changes or adjustments made to the order, including refunds, returns, discounts, taxes, shipping charges, and fees.	Allowed values: Decimal Number Example: 33.55
Price: Total	Total amount payable for an order. This includes the sum of all charges associated with the order, such as the product price, taxes, shipping fees, duties, and any additional fees.	Allowed values: Decimal Number Example: 4533.55
Payment: Status	indicates the status of payment for the order. This status reflects whether the payment for the order has been: pending: Payment is pending, which may result in failure. Recheck to ensure successful payment. authorized: Payment has been authorized. partially_paid: Payment has been partially made. paid: Payment has been completed. partially_refunded: Partial refund has been issued. refunded: Full refund has been issued. voided: Payment has been voided.	Allowed values: `pending` `authorized` `partially_paid` `paid` `partially_refunded` `refunded` `voided` Example: `partially_refunded`
Order Fulfillment Status	Denotes the status of order fulfillment. This status indicates whether the items in the order have been fulfilled, partially fulfilled, or are pending fulfillment. `<empty>`: No fulfillments have been completed for the order yet. `partial`: The order has been partially fulfilled, indicating that at least one item has been shipped. `fulfilled`: All line items within the order have been fulfilled or returned, with nothing left to fulfill.	Allowed values: `<empty>` `partial` `fulfilled` Example: `fulfilled`
Purchase Order Number	Unique identifier for a purchase order associated with the order.	Allowed values: Text Example: XD#232342332

Customers

When you import orders with customer data into Shopify, each order can either have one associated customer or none at all.

During the import process, Shopify tries to find a match with an existing customer, mainly using either the Customer ID or Customer Email. If those fields are empty, it looks for a match based on the Customer Phone. If no match is found using the provided criteria, Shopify creates a new customer record and links it to the order.

Keep in mind, though, if you need to update a customer’s details, you can’t do it directly through the order; you’ll have to make those updates in the Customers sheet instead.

Column	Explanation	Allowed values / Examples
Customer: ID	Unique identifiers assigned to customers by the Shopify platform. When specifying an existing customer ID from the store, the order will be linked to that particular customer. If the ID is left empty, Shopify will link the order to an existing customer based on their email address.	Allowed values: Number Example: 232342332
Customer: Email	Email addresses of customers who made purchases. This column is crucial for linking orders to existing customers or creating new ones if no matching customer is found based on the provided email.	Allowed values: Email Example: abc@gmail.com
Customer: Phone	Phone numbers in a specific format to ensure accuracy and compatibility with the Shopify platform. Phone numbers must be complete, including the country code, to ensure validity and compatibility with the respective country’s phone number format. The recommended format for phone numbers is to include the country code followed by the local number, separated by spaces or dashes. For example, “+1 23456 7890”.You can prefix phone numbers with an apostrophe (‘), which allows Excel to display the plus sign (+) without requiring it in the actual data. However, the plus sign itself is not required in the data. If the email is empty, the app will search for existing customers based on the provided phone number. If a matching customer is found, the order will be attached to that customer.	Allowed values: Phone Number Example: +1234343233
Customer: First Name	First names of customers who made purchases.	Allowed values: Text Example: John
Customer: Last Name	Last names of customers who made purchases.	Allowed values: Text Example: Deo
Customer: Note	Space for any notes or additional information related to the customer. This field is often used to store special instructions, preferences, or other relevant details that can help enhance the customer’s experience or provide valuable insights for order fulfillment.	Allowed values: Text Example: Prime User
Customer: State	The status of the customer’s account. This status indicates whether the customer’s account is: disabled: Customers are disabled by default until they are invited. invited: The customer has been emailed an invitation to create an account. enabled: The customer accepted the email invitation and successfully created an account. declined: The customer declined the email invitation to create an account. If declined, you cannot generate a new Account Activation URL.	Allowed values: `disabled` `invited` `enabled` `declined` Example: `declined`
Customer: Tags	Assign tags to customers, providing a way to categorize and segment them based on specific criteria or characteristics. Tags are helpful for organizing customers, creating targeted marketing campaigns, and personalizing communication.	Allowed values: Comma Separated List Example: Friend, Premium
Customer: Email Marketing Status	Whether the Customer accepted that he can be sent Marketing e-mails. `invalid` – The customer’s email address marketing state is invalid. `not_subscribed` – The customer hasn’t subscribed to Email marketing. `pending` – The customer is in the process of subscribing to Email marketing. `redacted`– The customer’s personal data is erased. This value is internally set and read-only. `subscribed` – The customer is subscribed to Email marketing. `unsubscribed` – The customer isn’t currently subscribed to Email marketing but was previously subscribed.	Allowed values: `invalid` `not_subscribed` `pending` `redacted` `subscribed` `unsubscribed` Example: `unsubscribed`
Customer: SMS Marketing Status	Indicates a customer’s current opt-in status for receiving marketing messages via SMS. not_subscribed: This signifies the customer has not opted-in to receive SMS marketing messages. pending: This indicates the customer has initiated the opt-in process for SMS marketing but hasn’t completed it yet (possible double opt-in scenario). subscribed: This means the customer has explicitly consented to receive marketing messages via SMS. unsubscribed – The customer isn’t currently subscribed to SMS marketing but was previously subscribed.	Allowed values: `not_subscribed` `pending` `subscribed` `unsubscribed` Example: `unsubscribed`
Customer: Tax Exempt	Indicates whether a customer is exempt from sales tax.	Allowed values: `TRUE` `FALSE` Example: `FALSE`
Customer: Orders Count	The total number of orders that this customer has placed	Allowed values: Number Example: 6
Customer: Total Spent	Represents the total amount of money a customer has spent on orders. It is important to note that Shopify does not update this field in real-time through the API. There can be a delay of up to 24 hours for the sync, meaning the exported value might differ from the current actual total spent by the customer.	Allowed values: Decimal Number Example: 6472.42
Billing: First Name	First name of the customer associated with the billing address for the order	Allowed values: Text Example: John
Billing: Last Name	Last name of the customer associated with the billing address for the order	Allowed values: Text Example: Doe
Billing: Name	Specifies the full name of the customer associated with the billing address for an order. When importing, Shopify gives priority to the Billing: First Name and Billing: Last Name columns if they are present. If these columns are not included, the Billing: Name column will be used instead, and Shopify will automatically split the name into first and last names.	Allowed values: Text Example: John Deo
Billing: Company	Name of the company associated with the billing address for an order.	Allowed values: Text Example: Abc
Billing: Phone	The phone number associated with the billing address for an order. Country Code: Start with the country code, which is “+1” for the United States and Canada. Regional Code: Followed by the regional or area code, which varies depending on the location. Local Number: Include the remaining digits of the phone number without any spaces or dashes.	Allowed values: Phone Number Example: ‘+15417543002
Billing: Address 1	The first line of the billing address associated with an order. Required. If empty, the address will not be created.	Allowed values: Text Example: 123 Main Street
Billing: Address 2	The second line of the billing address associated with an order.	Allowed values: Text Example: Suite 200
Billing: Zip	The postal or zip code associated with the billing address for an order	Allowed values: Zip Example: 123455
Billing: City	Name of the city associated with the billing address for an order. you must provide a city name for each billing address entry in your import file. If this field is left empty, Shopify will not create the address, and the import process will fail for that specific entry.	Allowed values: Text Example: New York
Billing: Province	Specifies the province, state, or region associated with the billing address for an order. The column should contain valid province names recognized by Shopify’s geographic classifier. This ensures that the billing address information is accurately represented in the system and can be used for order processing and shipping.	Allowed values: Text Example: California
Billing: Province Code	Specifies the code associated with the province, state, or region of the billing address.	Allowed values: Province Code Example: CA
Billing: Country	The country associated with the billing address for an order.	Allowed values: Country Name Example: United States
Billing: Country Code	The code associated with the country of the billing address for an order.	Allowed values: Country Code Example: US
Shipping: First Name	First name of the recipient associated with the shipping address for an order.	Allowed values: Text Example: John
Shipping: Last Name	Last name of the recipient associated with the shipping address for an order.	Allowed values: Text Example: Doe
Shipping: Name	Specifies the full name of the customer associated with the billing address for an order. When importing, Shopify gives priority to the Shipping: First Name and Shipping: Last Name columns if they are present. If these columns are not included, the Shipping: Name column will be used instead, and Shopify will automatically split the name into first and last names.	Allowed values: Text Example: John Deo
Shipping: Company	Name of the company associated with the billing address for an order.	Allowed values: Text Example: Abc
Shipping: Phone	The phone number associated with the billing address for an order. Country Code: Start with the country code, which is “+1” for the United States and Canada. Regional Code: Followed by the regional or area code, which varies depending on the location. Local Number: Include the remaining digits of the phone number without any spaces or dashes.	Allowed values: Phone Number Example: ‘+15417543002
Shipping: Address 1	The first line of the billing address associated with an order. Required. If empty, the address will not be created.	Allowed values: Text Example: 123 Main Street
Shipping: Address 2	The second line of the billing address associated with an order.	Allowed values: Text Example: Suite 200
Shipping: Zip	The postal or zip code associated with the shipping address for an order	Allowed values: Zip Example: 123455
Shipping: City	Name of the city associated with the shipping address for an order. you must provide a city name for each shipping address entry in your import file. If this field is left empty, Shopify will not create the address, and the import process will fail for that specific entry.	Allowed values: Text Example: New York
Shipping: Province	Specifies the province, state, or region associated with the shipping address for an order. The column should contain valid province names recognized by Shopify’s geographic classifier. This ensures that the shipping address information is accurately represented in the system and can be used for order processing and shipping.	Allowed values: Text Example: California
Shipping: Province Code	Specifies the code associated with the province, state, or region of the shipping address.	Allowed values: Province Code Example: CA
Shipping: Country	The country associated with the shipping address for an order.	Allowed values: Country Name Example: United States
Shipping: Country Code	The code associated with the country of the shipping address for an order.	Allowed values: Country Code Example: US

Companies

When creating an order, you have the option to link it to a company as well. To establish this link, you need to specify the following:

Customer: ID and/or Customer: Email
Company: ID and/or Company: Name
Company: Location ID and/or Company: Location Name

Column	Explanation	Allowed values / Examples
Company: ID	Internal ID created for the company by Shopify.	Allowed values: Number Example: 636847622
Company: Name	Name of the company or organization associated with an order.	Allowed values: Text Example: Abc Inc
Company: External ID `Export only`	External ID for the Company linked to the Order.	Allowed values: Text Example: shopify-associate-company
Company: Location ID	Shopify internal ID for the Company Location linked to the Order.	Allowed values: Number Example: 636847622
Company: Location Name	Company Location Name linked to Order.	Allowed values: Text Example: New Street
Company: Location External ID	Company Location External ID linked to the Order.	Allowed values: Text Example: shopify-associate-company

Line Items

Line Items section refers to the individual products or services included in an order. Each line item typically represents one product or service and includes details such as quantity, price, SKU, and more.

Column	Explanation	Allowed values / Examples
Line: Type	Specifies the type of line item in the order. Categorizes different components of an order, ensuring accurate processing and reconciliation with actual order data. Each type has specific attributes and columns associated with it. `Line Item:` Description: Represents a product or service in the order. Details: Filled in the standard Line Item columns (e.g., title, quantity, price). `Discount:` Description: Represents a discount applied to the entire order. Details: There can only be one discount line per order. Specific discount columns may be used. `Shipping Line:` Description: Represents the shipping cost for the entire order. Details: There can only be one shipping line per order. Specific shipping cost columns are used. `Transaction:` Description: Represents a financial transaction related to the order. Details: Each transaction line represents one actual transaction. Specific transaction columns must be filled. Refund transactions reference several refund lines through common refund columns. `Refund Line:` Description: Represents items being refunded in the order. Details: Must have the same attributes as line items, showing quantities and totals in reverse for refunds. Refund columns need to be filled for each refund line. An order can have multiple refunds. `Refund Shipping`: Description: Represents the refund of shipping costs. Details: These details need to be entered in a specific line. Shipping can be refunded multiple times until the total amount matches the initial shipping line amount. `Fulfillment Line`: Description: Represents fulfillment details of an order. Details: Each order can have multiple fulfillments, and each fulfillment can have several lines, one per item being fulfilled. Additional fulfillments can be added until all items are fulfilled. `Ignore`: Description: Used for custom lines, such as constructing formulas, which are not related to the order data. Details: The app will ignore these lines and not process them as part of the order.	Allowed values: `Line Item` `Discount` `Shipping Line` `Transaction` `Refund Line` `Refund Shipping` `Fulfillment Line` `Ignore` Example: `Shipping Line`
Line: ID	Unique identifier for each line item within an order. `Line Item:` ID Requirement: Each line item will have its own unique Line ID generated by Shopify. When Creating New Order: Must be filled with any unique number. `Discount:` ID Requirement: No Line ID is needed. `Shipping Line:` ID Requirement: Has an ID generated by Shopify. When Creating New Order: Can be left empty. `Transaction:` ID Requirement: No Line ID is needed. The Transaction ID is stored in the Transaction: ID column. `Refund Line:` ID Requirement: Has the same ID as the Line Item being refunded. This allows for precise matching in reports. When Creating New Order: Can be left empty. `Refund Shipping`: ID Requirement: Has a specific ID taken from the shipping refund entry. When Creating New Order: Can be left empty. `Fulfillment Line:` ID Requirement: Has the same ID as the Line Item being fulfilled. This allows for precise matching in reports. When Creating New Order: Can be left empty.	Allowed values: Number Example: 636847622
Line: Product ID	Unique identifier for the product associated with each line item.	Allowed values: Number Example: 636847622
Line: Product Handle	The handle of the product associated with each line item within an order. The product handle is a unique string used in Shopify URLs and is typically derived from the product’s title, with spaces replaced by hyphens and all characters converted to lowercase.	Allowed values: Text Example: crop-top
Line: Title	Title of the order line item, which represents the product being purchased or refunded. Order Line Item: The title specified in this column represents the product being purchased. Even if the linked product has a different title, this title will be used for the order line item. Discount: For discounts, this column typically specifies the type of discount, such as percentage, fixed_amount, or shipping. If the discount type is shipping or fixed_amount, the value from the Line: Discount column is used. For percentage discounts, the percentage is derived from the Line: Price column. Shipping Line: This column contains the shipping title in free-form text. Transaction: This column is left empty for transaction line items. Refund Line: The title specified in this column must match the Line: Title of the line item being refunded. It is part of the key used to identify the refunded line item. Refund Shipping: This column is left empty for refund shipping line items. Fulfillment Line: The title specified in this column must match the Line: Title of the item being fulfilled. It is part of the key used to identify the fulfilled line item.	Allowed values: Text Example: Personalized Crop Top
Line: Name	Name of each line item within an order. This column provides additional information about the line item, such as a variant name or any other descriptive text associated with the product. Line Item: The Line Item column for order line items contains the full name of the order line item, which includes both the product title and the variant title, formatted as <product title> – <variant title>. Discount: For discount line items, the Line Item column contains the free text comment written for the discount, or if a discount code was used, it will be displayed here. Shipping Line: The Line Item column for shipping line items usually contains the shipping code, often with the value custom. Transaction: This column is left empty for transaction line items. Refund Line: In export files, the Line Item column for refund line items matches the name of the line item being refunded. In import files, this column can contain any value, as it will be saved but not visible on the order screen. Refund Shipping: This column is left empty for refund shipping line items. Fulfillment Line: In export files, the Line Item column for fulfillment line items matches the name of the line item being fulfilled. In import files, this column can contain any value, as it will be saved but not visible on the order screen.	Allowed values: Text Example: Personalized Crop Top – Red / L
Line: Variant ID	Contains the variant ID generated by Shopify if the line item is a product. This ID links the line item to a specific variant of a product in the Shopify store. If the line item is a custom item, this ID will be empty. When importing an order, you can use a real variant ID from the store. If the ID is not found for that product, the app will try to match it by the Line: SKU column value.	Allowed values: Number Example: 636847622
Line: Variant Title	Title of the variant associated with each line item within an order.Line Item: Contains the title of the product variant included in the line item. Discount: Typically left empty. Shipping Line: Contains the shipping source, usually “Shopify”. Transaction: Typically left empty. Refund Line: Must match the “Line: Variant Title” of the line item being refunded. Refund Shipping: Typically left empty. Fulfillment Line: Must match the “Line: Variant Title” of the item being fulfilled.	Allowed values: Text Example: Red / L
Line: SKU	SKU (Stock Keeping Unit) associated with each line item within an order. This SKU acts as a unique identifier for each variant of a product and helps streamline inventory management and order processing. Line Item: Contains the SKU of the product variant included in the line item. If there is no “Line: Product ID” and “Line: Product Handle” in the file, the app will use the SKU to find an existing product and link the line item to the product. Discount: Empty. Shipping Line: Empty. Transaction: Empty. Refund Line: Must match the “Line: SKU” of the line item being refunded. Refund Shipping: Empty. Fulfillment Line: Must match the “Line: SKU” of the item being fulfilled.	Allowed values: Text Example: SKU-23232412
Line: Quantity	Has different values depending on the line type. Line Item: Represents the quantity of the line item purchased. Discount: Typically left empty for this column as discounts do not have quantities. Shipping Line: Typically left empty for this column as shipping lines do not have quantities. Transaction: Typically left empty for this column as transactions do not have quantities. Refund Line: Represents the quantity restocked back if a refund is done with restocking. The number is negative. Refund Shipping: Typically left empty for this column as refund shipping lines do not have quantities. Fulfillment Line: Represents the quantity being fulfilled in that particular line of fulfillment. The number is positive.	Allowed values: Number Example: 63
Line: Price	The price associated with each line item in an order. Line Item: Represents the price of one line item purchased. Discount: If the discount type in “Line: Title” is percentage, this column will show the percentage value. Shipping Line: Represents the price of the shipping applied to the order. Transaction: Typically left empty for this column as transactions have their own specific amount fields. Refund Line: Must match the “Line: Price” of the line item that is being refunded, as it is used as part of the key identifying the refunded line item. Refund Shipping: Represents the amount of shipping being refunded. It should be a positive number. Fulfillment Line: Must match the “Line: Price” of the item that is being fulfilled, as it is used as part of the key identifying the fulfilled line item.	Allowed values: Decimal Number Example: 10.9
Line: Discount	Has different values depending on the line type. Line Item: Represents the discount applied to a specific line item. Negative value. Discount: Represents the discount applied to the entire order. Negative value. Shipping Line: Empty Transaction: Empty Refund Line: Empty Refund Shipping: Empty Fulfillment Line: Empty	Allowed values: Number Example: -23.21
Line: Discount Allocation	Indicates the allocation of the order discount amount to individual line items. The values in this column provide insight into how the order-level discount is divided among the line items. Each value represents the portion of the total discount allocated to a specific line item.	Allowed values: Currency Example: 53.43
Line: Total	The total amount for each line in the order, and its value varies based on the line type: Line Item: Represents the line item’s total, calculated as Quantity * Price + Discount (since Discount is negative). Discount: Represents the total discount amount applied to the entire order. Negative value. Shipping Line: Represents the price of the shipping applied to the order. Transaction: Empty Refund Line: Represents the total amount of a refunded line item, calculated as the refunded quantity * Price. Since the refunded quantity is negative, the result will also be negative. Refund Shipping: This represents the total amount of shipping being refunded. Negative value. When importing, the app will read the shipping refund value from this column. If it’s empty, it will read from Line: Price. Fulfillment Line: Empty	Allowed values: Currency Example: 5332.43
Line: Requires Shipping	Indicates whether a line item requires shipping. Line Item: `TRUE` if the line item requires shipping. `FALSE` if it does not. Discount: empty Shipping Line: empty Transaction: empty Refund Line: `TRUE` if the line item requires shipping. `FALSE` if it does not. Refund Shipping: empty Fulfillment Line: `TRUE` if the line item requires shipping. `FALSE` if it does not.	Allowed values: `TRUE` `FALSE` Example: `TRUE`
Line: Vendor	Vendor or supplier associated with each line item in the order. Line Item: Specifies the vendor name of the product purchased for each line item. Discount: empty Shipping Line: Contains the shipping carrier identifier, referencing the carrier service that provided the shipping rate. Present when the rate was computed by a third-party carrier service. Transaction: empty Refund Line: Contains the same vendor name as the corresponding line item that was refunded. Fulfillment Line: Contains the same vendor name as the corresponding line item that was fulfilled.	Allowed values: Text Example: Carlo Inc
Line: Gift Card	Indicates if the line item corresponds to a gift card. If a line item refers to a purchased gift card, you would enter `TRUE` in this column. For regular product line items, `FALSE` would be entered.	Allowed values: `TRUE` `FALSE` Example: `TRUE`
Line: Force Gift Card	Indicates if the line item should be treated as a gift card, regardless of any default settings. No: Importing with “No” treats the line item as a custom item, preventing Shopify from automatically sending out gift cards to customers. Yes: Allows the creation of fulfillment for the gift card, triggering its delivery to the customer. However, this may fail if Shopify is also configured to auto-fulfill gift cards. Shopify: Creates a real gift card line item and delegates the fulfillment action based on the settings configured in Shopify’s admin panel under Settings -> Checkout.	Allowed values: `No` `Yes` `Shopify` Example:`Yes`
Line: Taxable	Determines whether a line item is taxable or not.	Allowed values: `TRUE` `FALSE` Example: `TRUE`
Line: Tax Total	Represents the total amount of tax applied to each line item.	Allowed values: Currency Example: 5332.43
Line: Tax Title	Name or title of the tax applied to each line item. When importing, it is important to remember: This column is used to apply tax to specific line items directly. If you need to split a tax between all taxable line items, you should use the order-level tax columns instead. This tax can be applied to both Line Item and Shipping Line rows. Up to 100 different taxes can be applied to each line item. In the export, the first 3 Line Item Tax columns will appear among other Order Line Item columns. If there are more than 3 Line Item taxes, those additional columns will be added at the end of the file. Tax title/name columns: `Line: Tax 1 Title` `Line: Tax 2 Title` `Line: Tax 3 Title` … `Line: Tax 100 Title`	Allowed values: Text Example: VAT
Line: Tax Rate	Tax rate applied to the corresponding tax for each line item. This column is used to apply a specific percentage rate to the line item tax. Value `1` = 100%Tax rate columns: `Line: Tax 1 Rate` `Line: Tax 2 Rate` `Line: Tax 3 Rate` … `Line: Tax 100 Rate`	Allowed values: Number <= 1 Example: 0.34
Line: Tax Price	This column defines the total tax amount for the line item. The amount should be a positive decimal value. This value is directly added to the line item’s total, reflecting the tax included in the line item’s cost.	Allowed values: Decimal Number Example: 624.34
Line: Fulfillable Quantity `Export only`	Quantity of the line item that is yet to be fulfilled.	Allowed values: Number Example: 62
Line: Fulfillment Service	Indicates the fulfillment service used for the shipping method, particularly if a third-party service is involved. It cannot be set for order line items and is primarily used for shipping line rows during the import process.	Allowed values: `manual` `amazon` `shipware` `<other provider handle>` Example: `manual`
Line: Fulfillment Status	Indicates the fulfillment status of each line item in an order. It helps in tracking whether items in the order have been fulfilled, are pending, or are in another fulfillment state.	Allowed values: `fulfilled` `partial` `<empty>` Example: `partial`
Shipping: ID	Identifier for the shipping line of an order. This ID is generated by Shopify and is unique to each shipping line associated with an order.	Allowed values: Number Example: 623243234
Shipping: Title	Name or title of the shipping method applied to an order.	Allowed values: Text Example: Standard Shipping
Shipping: Code	Identifier associated with the shipping method used in an order. This code can be useful for internal tracking purposes or for integration with third-party systems.	Allowed values: Text Example: STD-001
Shipping: Carrier Identifier	Identifier associated with the carrier or shipping service provider used for an order’s shipment. This identifier helps in tracking and managing shipments, especially when integrating with external shipping systems or carriers.	Allowed values: Text Example: UPS
Shipping: Source	Source or origin of the shipping method applied to an order.	Allowed values: Text Example: Dropshipping
Shipping: Price	Cost associated with the shipping method applied to an order. It denotes the amount charged to the customer for shipping their items.	Allowed values: Decimal Number Example: 62.32
Shipping: Tax Total	Indicates the total amount of tax applied to the shipping cost for an order. It represents the additional tax charges associated with the shipping method.	Allowed values: Decimal Number Example: 62.32
Shipping: Tax Title	Title or name of the tax applied specifically to the shipping cost for an order. It indicates the type or category of tax associated with the shipping charges. You can add upto a 100 different taxes. `Shipping: Tax 1 Title` `Shipping: Tax 2 Title` `Shipping: Tax 3 Title` … `Shipping: Tax 100 Title`	Allowed values: Text Example: VAT
Shipping: Tax Rate	The rate at which tax is applied to the shipping cost for an order. It denotes the percentage of the shipping charge that is allocated as tax.Value `1` = 100%Tax rate columns: `Shipping: Tax 1 Rate` `Shipping: Tax 2 Rate` `Shipping: Tax 3 Rate` … `Shipping: Tax 100 Rate`	Allowed values: Number <= 1 Example: 0.23
Shipping: Tax Price	Amount of tax charged on the shipping cost for an order.	Allowed values: Decimal Number Example: 322.23
Discount: Type	Specifies the type or category of discount applied to an order. It indicates whether the discount is a percentage discount, a fixed amount discount, or a discount applied specifically to shipping costs.	Allowed values: `Amount Off` `Free Shipping` `Buy X Get Y` `Percentage` Examples: `Free Shipping`
Discount: Code	Unique code or identifier associated with a discount applied to an order.	Allowed values: Text Example: SPRINGSALE20
Discount: Value	The monetary value of the discount applied to an order. This value represents the amount deducted from the total order value as a result of the discount.	Allowed values: Negative Number Example: -42
Discount: Percentage	Indicates the percentage of discount applied to an order. This value represents the proportion of the total order value that is deducted as a discount.	Allowed values: Number Example: 12

Line Items: Product Data

Column	Explanation	Allowed values / Examples
Line: Product Type	Refers to the type or category of the product associated with the line item in an order.	Allowed values: Text Example: T-shirt
Line: Product Tags	User-defined keywords associated with the product associated with the line item in an order. These tags are not categories or product types, but rather additional labels that help with organization and filtering. Multiple values can be separated with a comma.	Allowed values: Text Example: Color: RedType: Skirt
Line: Variant SKU	Unique alphanumeric code assigned to each individual variant within a product associated with the line item. It acts as an internal identifier for tracking inventory and managing specific variations	Allowed values: Text Example: BDJN3434S
Line: Variant Barcode	Weight assigned to each variant of a product associated with the line item. This becomes important when calculating shipping costs, which can vary depending on the weight of the item being shipped.	Allowed values: Text Example: 32322-43343
Line: Variant Weight	Weight assigned to each individual variant of a product associated with the line item. This becomes important when calculating shipping costs, which can vary depending on the weight of the item being shipped.	Allowed values: Decimal Number Example: 5.42
Line: Variant Weight Unit	Refers to the unit of measurement you assign to the weight of each individual variant within a product.	Allowed values: `g` `kg` `oz` `lb` Example: `lb`
Line: Variant Inventory Qty	Refers to the actual number of units available in stock for a specific variant within a product	Allowed values: Number Example: 592
Line: Variant Cost	The cost associated with the specific variant of a product included in the line item of an order. This cost represents the expenses incurred by the business to procure or produce the variant.	Allowed values: Decimal Number Example: 59.33
Line: Variant Price	The price of the specific variant included in the line item of an order. This price represents the amount charged to the customer for purchasing the variant.	Allowed values: Decimal Number Example: 59.33
Line: Variant Compare At Price	The original or regular price of the variant included in the line item, typically used for comparison purposes. This value indicates the price at which the variant was initially listed before any discounts or promotional offers.	Allowed values: Decimal Number Example: 59.33
Line: Variant Country of Origin	Refers to the two-digit code for the country where a specific variant within a product was manufactured or substantially transformed	Allowed values: Country code Example: US
Line: Variant Province of Origin	The two-digit code for the province where the Variant was made. Used only if the shipping provider for the inventory item is Canada Post.	Allowed values: Province Code Example: QC
Line: Variant HS Code	The general Harmonized System (HS) code for the Variant.	Allowed values: Number Example: 342232

Refunds

The Refunds section pertains to the handling of refunds within the CSV file. It includes various columns that detail refund-related information such as refund IDs, creation dates, notes, restocking details, and more.

Column	Explanation	Allowed values / Examples
Refund: ID	A unique identifier assigned to each refund transaction processed for an order.	Allowed values: Number Example: 3422323243
Refund: Created At	Represents the date and time when the refund was initiated or created. When importing a new refund, the app will set this date as Refund Processed At date in Shopify.	Allowed values: Date & Time Example: 342024-05-21 11:20:30 +0200
Refund: Note	Additional comments, remarks, or notes associated with the refund transaction.	Allowed values: Text Example: Not expected quality
Refund: Restock	Specifies whether the refunded item will be restocked back into inventory.	Allowed values: `True` `False` Example: `False`
Refund: Restock Type	If the Refund: Restock column is set as TRUE, the “Refund: Restock Type” column specifies the method or type of restocking to be applied. Cancel: Use this option when restocking unfulfilled line items. When canceled, the refunded quantity will be added back to the available count, and the number of fulfillable units for this line item will decrease. Return: Employ this option when restocking fulfilled line items that are returned to inventory. When items are returned, the refunded quantity will be added back to the available count, but the number of fulfillable units for this line item will remain unchanged.	Allowed values: `cancel` `return` Example: `return`
Refund: Restock Location	Specifies the location where restocked items will be returned to. This is particularly useful if you have multiple fulfillment locations set up in your Shopify store and you want to specify where the restocked items should be placed.	Allowed values: Location Example: Main Warehouse
Refund: Send Receipt	Specifies whether a receipt should be sent to the customer when a refund is processed. If set to TRUE, a receipt will be automatically sent to the customer’s email address.	Allowed values: `True` `False` Example: `False`
Refund: Generate Transaction	Controls whether transactions are automatically generated for refunds during import. When set to FALSE, no additional transactions are created unless explicitly linked in the import file. If set to TRUE, transactions are automatically generated. If this column is omitted or left empty during import, the default behavior is to generate transactions.	Allowed values: `True` `False` Example: `False`
Refund Adjustment: ID	Represents the Shopify-generated ID for the refund adjustment. This ID is assigned by Shopify when a refund adjustment is created.	Allowed values: Number Example: 3422323243
Refund Adjustment: Amount	The monetary value of the refund adjustment. This amount reflects any adjustments made during the refund process, such as restocking fees, processing fees, or other deductions or additions to the refund amount.	Allowed values: Decimal Number Example: 59.33
Refund: Adjustment Tax	Represents the tax amount associated with any refund adjustments made. This tax amount typically applies to any additional fees or adjustments applied during the refund process, such as restocking fees or processing fees.	Allowed values: Decimal Number Example: 59.33
Refund: Adjustment Kind	Specifies the type of adjustment made during a refund, such as a restocking fee or shipping adjustment.	Allowed values: Text Example: restocking
Refund: Adjustment Reason	Reason for any financial adjustments made during a refund, like discrepancies in shipping costs or promotional differences.	Allowed values: Text Example: restocking adjustment

Transactions

The Transaction columns extend the rows where the Line: Type column has the value Transaction. These columns contain data about transactions associated with orders. During the import of orders, if the file lacks rows with Line: Type set to Transaction, the app will still import transactions from other rows where the relevant Transaction columns are filled.

Column	Explanation	Allowed values / Examples
Transaction: ID `Export only`	The unique identifier for a transaction generated by Shopify. For a refund, the transaction must also include the Refund: ID column, with the same refund ID that was assigned to all refund line items. This links the transaction to the refund.	Allowed values: Number Example: 3422323243
Transaction: Kind	Specifies the type of transaction being recorded. authorization: Represents an amount reserved against the cardholder’s funding source. Money is not transferred until an authorization is captured by a “capture” transaction. Only one authorization transaction is allowed per order. capture: The transfer of the reserved money from an authorization. Multiple capture transactions can occur per order until the total authorized amount is reached. sale: Combines authorization and capture in a single step, usually by pressing the “Paid” button in Shopify Admin. There will be no separate card transactions. Only one sale transaction is allowed per order. You can import a sale transaction for an existing order with the remaining amount to mark it as paid. refund: A partial or full return of captured funds. Refunds can only occur after a capture or sale transaction and cannot exceed the original transaction amount. Multiple refund transactions are allowed, with one per refund. void: Cancels a transaction, effectively nullifying it.	Allowed values: `authorization` `sale` `capture` `refund` `void` Example: `refund`
Transaction: Processed At	Indicates the exact date and time when a transaction was processed. This helps track when payments were made or refunds were issued.	Allowed values: Date & Time Example: 342024-05-21 11:20:30 +0200
Transaction: Amount	The total amount of money processed in a transaction, including payments or refunds.	Allowed values: Currency Example: 342
Transaction: Currency	Specifies the currency used for the transaction, such as USD, CAD, EUR, etc. This helps in managing financial records across different currencies.	Allowed values: Text Example: USD
Transaction: Status	Current status of a transaction, such as ‘pending’, ‘success’, or ‘failed’. This helps you track the progress and outcome of transactions.	Allowed values: `success` `pending` `failure` `error` Example: `failure`
Transaction: Message `Export only`	Provides details or notes about the transaction, such as error	Allowed values: Text Example: Payment on hold
Transaction: Gateway	The payment gateway used to process the transaction. This is the service that authorizes and processes payments, such as PayPal, Stripe, or Shopify Payments.	Allowed values: Text Example: PayPal
Transaction: Force Gateway `Imported only`	If the transaction was processed with a different gateway than the one recorded in Shopify, this column can be used to force the update.	Allowed values: `True` `False` Example: `False`
Transaction: Test	Indicates whether the transaction is a test transaction.	Allowed values: `True` `False` Example: `False`
Transaction: Authorization	The authorization code provided by the payment gateway for this transaction. When importing transactions, this field is used to link the transaction with its authorization in the payment gateway.	Allowed values: Number Example: 34223
Transaction: Payment ID	The ID of the payment associated with this transaction. When importing transactions, this field is used to link the transaction with its corresponding payment in the payment gateway.	Allowed values: Number Example: 342235323234
Transaction: Device ID	The unique identifier for the device used to process the transaction.	Allowed values: Number Example: 342235323234
Transaction: User ID	The identifier for the user associated with the transaction.	Allowed values: Number Example: 342235323234
Transaction: Parent ID	Parent transaction ID will be utilized by the app when importing Capture transactions. If there’s no transaction with this ID, then the app will use the Transaction: Authorization column instead.	Allowed values: Number Example: 342235323234
Transaction: Error Code `Export only`	The Error Code associated with a transaction, if applicable, will be included in this column. It indicates any error that occurred during the transaction process.	Allowed values: `incorrect_number` `invalid_number` `invalid_expiry_date` `invalid_cvc` `expired_card` `incorrect_cvc` `incorret_zip` `incorrect_address` `card_declined` `processing_error` `call_issuer` `pick_up_card` Example: `card_declined`
Transaction: CC AVS Result `Export only`	The CC AVS (Address Verification System) Result associated with a credit card transaction. It indicates whether the address provided by the customer matches the address on file with the card issuer.	Allowed values: Single Character Example: X
Transaction: CC Bin `Export only`	Typically refers to the first few digits of a credit card number, which are known as the Bank Identification Number (BIN).	Allowed values: Number Example: 4123
Transaction: CC CVV Result `Export only`	contains the result of the Card Verification Value (CVV) check performed during a credit card transaction. The CVV is a security feature represented by the three or four-digit code found on the back of most credit cards. The result indicates whether the CVV provided during the transaction matches the one associated with the card.	Allowed values: Single Character Example: X
Transaction: CC Number `Export only`	contains the last four digits of the credit card number used in the transaction. This information is often included for reference and tracking purposes but is usually truncated for security reasons to protect sensitive cardholder data.	Allowed values: Masked Card Number Example: •••• •••• •••• 4242
Transaction: CC Company `Export only`	contains the name of the credit card company associated with the credit card used in the transaction. It identifies the issuer of the credit card, such as Visa, Mastercard, American Express, etc. This information is helpful for merchants to understand which types of cards their customers are using for purchases.	Allowed values: Text Example: Visa

Risks

The Risks section of the CSV file offers valuable insights into potential risks associated with orders. It encompasses data points like risk ID, source, score, recommendations, and messages. Examining this section empowers merchants to recognize and address risks linked to fraudulent activities, payment issues, or other possible concerns.

Column	Explanation	Allowed values / Examples
Risk: ID `Export only`	Contains the unique identifier or reference number associated with any risk assessment or fraud detection processes applied to the transaction.	Allowed values: Number Example: 412343534
Risk: Source `Export only`	Specifies the source or origin of the risk assessment or fraud detection information associated with the transaction. This could indicate the specific system, tool, or service used to evaluate the transaction for potential risks or fraudulent activity. It provides insight into where the risk assessment data was generated or obtained from.	Allowed values: Text Example: Shopify
Risk: Score `Export only`	Indicates the numerical score assigned to the transaction based on the risk assessment or fraud detection process. This score quantifies the level of risk associated with the transaction, with higher scores typically indicating a higher likelihood of fraudulent activity or other risks.	Allowed values: Number between 0 to 1 Example: 0.5
Risk: Recommendation `Export only`	Provides guidance or suggested actions based on the risk assessment score associated with the transaction. It typically offers recommendations on how to proceed with the transaction based on the assessed level of risk. cancel: This order should be canceled by the merchant. investigate: This order might be fraudulent and needs further investigation. accept: This check found no indication of fraud.	Allowed values: `cancel` `investigate` `accept` Example: `accept`
Risk: Cause Cancel `Export only`	Indicates whether a transaction should be canceled due to the identified risk. If the value in this column is set to true, it suggests that the transaction should be canceled or declined because it poses a significant risk according to the risk assessment.	Allowed values: `True` `False` Example: `False`
Risk: Message `Export only`	Provides information about the risk assessment result for a transaction. It typically includes details about any potential risks associated with the transaction, such as suspicious activity, fraudulent behavior, or other factors that may warrant further review or action.	Allowed values: Text Example:This transaction was made from an anonymous proxy.

Fulfillment

The Fulfillment section of the CSV file provides comprehensive details about the fulfillment process for each order. It encompasses crucial data, including fulfillment ID, status, creation date, tracking details, and more. By analyzing this section, you can effectively monitor the progress of order fulfillment, keep track of shipment statuses, and guarantee timely delivery to customers.

Column	Explanation	Allowed values / Examples
Fulfillment: ID	A unique identifier assigned to each fulfillment in Shopify. This ID is generated by Shopify and is used to uniquely identify each fulfillment within the system. When importing or updating fulfillments, this column helps ensure that the correct fulfillment is associated with the corresponding order.	Allowed values: Number Example: 412343534
Fulfillment: Status	Indicates the current status of the fulfillment. It specifies whether the fulfillment is pending, in progress, or completed. success: The fulfillment was successful. cancelled: The fulfillment was cancelled. error: There was an error with the fulfillment request. failure: The fulfillment request failed.on import, only `success` and `cancelled` can be set for the Order Fulfillment.	Allowed values: `success` `cancelled` `error` `failure` Example: `error`
Fulfillment: Created At `Export only`	The date and time when the fulfillment was created. During import, this timestamp reflects the moment of importation.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Fulfillment: Updated At `Export only`	The date and time when the fulfillment was last updated.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Fulfillment: Tracking Company	Refers to the shipping carrier or company responsible for handling the delivery of the fulfillment. Keep either empty or exactly as required by Shopify.	Allowed values: Text Example: AGS
Fulfillment: Location	Indicates the location from which the fulfillment is being shipped.	Allowed values: Location Name Example: Main Warehouse
Fulfillment: Shipment Status	Indicates the delivery status for the order shipment. label_printed: A shipping label was purchased and printed. label_purchased: A shipping label was purchased but not printed. attempted_delivery: Delivery was attempted but could not be completed. ready_for_pickup: The shipment is ready for pickup at a depot. confirmed: The carrier is aware of the shipment but hasn’t received it yet. in_transit: The shipment is en route between facilities. out_for_delivery: The shipment is out for delivery to its final destination. delivered: The shipment was successfully delivered. failure: An issue occurred with tracking information, such as an invalid tracking number or a canceled shipment.	Allowed values: `label_printed` `label_purchased` `attempted_delivery` `ready_for_pickup` `confirmed` `in_transit` `out_for_delivery` `delivered` `failure` Example: `out_for_delivery`
Fulfillment: Processed At `Import only`	The date and time for your last Fulfillment Event. If Fulfillment: Shipment Status is set to delivered or failure, this field represents the delivery or delivery failure date displayed in Shopify.	Allowed values: Date & Time Example: 2018-12-17 18:20:07 +0200
Fulfillment: Tracking Number	The tracking number associated with the fulfillment. If there are multiple tracking numbers, they should be separated by commas.	Allowed values: Comma separated strings Example: `EF123456789US, EF123456789CN`
Fulfillment: Tracking URL	The URL link provided by the shipping carrier that allows the customer to track their package. This link directs the user to the carrier’s tracking page, pre-filled with the tracking number, so they can see the current status and history of their shipment.	Allowed values: URL Example: https://track2.net/code=EF123456789US
Fulfillment: Send Receipt	If this column is set to TRUE, a receipt will be sent to the customer upon fulfillment. If set to FALSE, no receipt will be sent.	Allowed values: `True` `False` Example: `False`

Meta Fields

The Meta Field column in the Shopify export data refers to custom data you’ve added to your products, collections, orders, or customers. Shopify itself doesn’t have data fields for every specific detail you might want to track. Meta fields are a way for you to add your own custom fields to store that extra information. For more info on meta fields and how to import/export them, refer to Import/Export Shopify Meta Data.

📚

Also read

Article by Arjun

Technical writer for WebToffee. When I'm not crafting words, you'll find me either exploring hidden trails on my bike or curled up with a good sci-fi movie on Netflix.

Cookie	Description
__cfruid	Cloudflare sets this cookie to identify trusted web traffic.
__stripe_mid	Stripe sets this cookie cookie to process payments.
__stripe_sid	Stripe sets this cookie cookie to process payments.
cookielawinfo-checkbox-advertisement	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category .
cookielawinfo-checkbox-necessary	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category .
cookielawinfo-checkbox-preferences	This cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
CookieLawInfoConsent	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
PHPSESSID	This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policy	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.

Cookie	Description
_ga	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_ga_BQH8MSKD4M	This cookie is installed by Google Analytics.
_gat_gtag	Identification code of website for tracking visits.
_gid	This cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjAbsoluteSessionInProgress	Hotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.
_hjFirstSeen	Hotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.
_hjid	Hotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.
_hjIncludedInSample	This cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
_hjIncludedInSessionSample	Hotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.
_hjSessionUser_1376571	No description
_hjTLDTest	To determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.
CONSENT	YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
has_recent_activity	This cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_ai	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lr	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_or	This cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qs	Gathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3d	The cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.

Cookie	Description
_fbp	This cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
fr	The cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
VISITOR_INFO1_LIVE	A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSC	YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devices	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-id	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.

Cookie	Duration	Description
_hjSession_1376571	30 minutes	No description
_octo	1 year	No description available.
_zendesk_authenticated	past	No description
_zendesk_session	session	No description available.
_zendesk_shared_session	session	No description available.
edd_wp_session	12 hours	No description available.
logged_in	1 year	No description available.
m	2 years	No description available.

Shopify Orders – Available Columns For Export And Import

Basic columns

Customers

Companies

Line Items

Line Items: Product Data

Refunds

Transactions

Risks

Fulfillment

Meta Fields

Got any query? Please leave a comment or reach out to our support
Cancel reply

Got any query? Please leave a comment or reach out to our support

Shopify Orders – Available Columns For Export And Import

Basic columns

Customers

Companies

Line Items

Line Items: Product Data

Refunds

Transactions

Risks

Fulfillment

Meta Fields

Got any query? Please leave a comment or reach out to our support Cancel reply

Got any query? Please leave a comment or reach out to our support

Got any query? Please leave a comment or reach out to our support
Cancel reply