Here are sample spreadsheets you can use to test the order import functionality:

If present, the ID will be used to identify existing orders for updates. When creating new orders, Altera will use this to group multiple rows together into a single order.

The order name is used as a key to identify existing orders during import. Order names should be unique. If left empty, Shopify will generate the next sequential order number automatically.

Phone number must include country code and be valid for the respective country. Can be different from the customer's phone number.

Contact email for the order. Can be different from the customer's email address. Must be a valid email format.

Internal notes about the order that are visible in Shopify Admin but not to customers.

Comma-separated list of tags for filtering and organization purposes.

The timestamp when the order was created. This field is export-only and cannot be imported. ISO-formatted timestamps are also supported.

The timestamp when the order was last modified. This field is export-only and cannot be imported. ISO-formatted timestamps are also supported.

The date and time when the order was processed. This appears in Shopify Admin and analytics reports. ISO-formatted timestamps are also supported.

The timestamp when the order was cancelled. Empty if the order is not cancelled. ISO-formatted timestamps are also supported.

Three-letter currency code in ISO 4217 format.

The channel where the order originated. When importing, you can set any custom value except Shopify reserved words (web, pos, iphone, android, shopify_draft_order).

This field is export-only and cannot be imported.

Shopify-generated customer ID. If specified, the order will be linked to that customer. If empty, the app will search by email or phone.

Customer's email address. Used to find existing customers or create new ones if no customer ID is provided.

Customer's phone number with country code. Used as fallback to find existing customers if email is empty.

The customer's first name.

The customer's last name.

Notes about the customer visible in Shopify Admin.

First name for the billing address.

Last name for the billing address. Required for billing address creation.

Company name for billing address, if applicable.

Phone number for billing address with country code.

First line of billing address. Required for billing address creation.

Second line of billing address (optional).

City for billing address. Required for billing address creation.

Province/state name for billing address. Must match Shopify's geographic classifier.

Two-character province/state code.

Country name for billing address. Must match Shopify's geographic classifier. Required for billing address creation.

Two-character country code for billing address.

Postal/zip code for billing address.

First name for the shipping address.

Last name for the shipping address.

Company name for shipping address, if applicable.

Phone number for shipping address with country code.

First line of shipping address.

Second line of shipping address (optional).

City for shipping address.

Province/state name for shipping address.

Two-character province/state code.

Country name for shipping address.

Two-character country code for shipping address.

Postal/zip code for shipping address.

Unique identifier for the line item. Generated by Shopify for existing items, can be any unique number for new orders.

Shopify product ID for the line item. If not found, the app will try to match by handle or SKU.

Used as secondary method to identify products when Product ID is not available.

The title of the order line item. Can be set independently of the linked product title.

Shopify variant ID for the line item. If not found, the app will try to match by SKU.

The title of the product variant included in the line item.

The SKU of the product variant. Used to identify products when ID and handle are not available.

The quantity of the line item purchased.

The price of one line item unit.

Discount amount applied to the line item. Negative value.

Calculated as (Quantity × Price) + Discount. This field is export-only and cannot be imported.

Weight per line item in grams.

Vendor name of the product purchased.

The full name of the line item, including variant details. This is typically the product title combined with variant options.

Information about how discounts are allocated to this specific line item.

The discount amount applied per individual unit of this line item.

Custom properties or attributes associated with the line item. Format as comma-separated key: value pairs with each key and value on a new line. When viewing the spreadsheet in Excel you may need to expand the row height to see the full value.

The total amount of tax applied to this line item across all tax rates.

The name or title of the first tax applied to this line item.

The rate (as a decimal) of the first tax applied to this line item. Example: 0.08 = 8%.

The monetary amount of the first tax applied to this line item.

The name or title of the second tax applied to this line item.

The rate (as a decimal) of the second tax applied to this line item. Example: 0.02 = 2%.

The monetary amount of the second tax applied to this line item.

The name or title of the third tax applied to this line item.

The rate (as a decimal) of the third tax applied to this line item. Example: 0.01 = 1%.

The monetary amount of the third tax applied to this line item.

The quantity of this line item that can still be fulfilled. This is typically the ordered quantity minus any already fulfilled quantity.

The name of the fulfillment service responsible for fulfilling this line item. Common values include manual, amazon, shipwire, etc.

The price of the line item before any taxes are applied.

Shopify-generated transaction identifier. This field is export-only and cannot be imported.

The amount of the transaction in the order currency.

Currency code for the transaction. Should match the order currency.

The name of the payment gateway used for the transaction.

Shopify-generated fulfillment ID. Used to group line items into fulfillments.

Name of the tracking company. Must match Shopify's supported tracking companies. Read tracking information updates for how to change tracking information for existing orders.

Tracking number provided by the shipping company. Read tracking information updates for how to change tracking information for existing orders.

URL for tracking the shipment provided by the shipping company. Read tracking information updates for how to change tracking information for existing orders.

Name of the location where the fulfillment is shipped from.

If TRUE, Shopify will send a notification email to the customer when the fulfillment is created or updated.

The type of payment terms applied to the order. If you are using payment terms you need to use one of the following values:

Shopify does not support custom 'Net X' payment terms. For example, 'Net 14' is not supported.

The date and time when payment terms were issued to the customer. ISO-formatted timestamps are also supported. This field is used with the Net X payment terms types. If you do not set this field, the app will use the current date.

The date when payment is due according to the payment terms. ISO-formatted timestamps are also supported. This field is only required if you use the Fixed date payment terms type.

The date and time when payment terms were completed or paid in full. Empty if payment is still pending. ISO-formatted timestamps are also supported.

Indicates whether the payment for the order is past due.

Shopify-generated refund ID. Used to group refund lines together.

Note explaining the reason for the refund.

Metafields can be imported and exported with orders to store custom metadata and additional attributes.

For detailed information about working with metafields, see our Metafields guide.

You can use these filters to limit which orders are exported:

When updating existing orders, only a limited set of fields can be modified. Most order information becomes read-only after the order is created, but you can update these specific fields:

The following fields can be updated on existing orders:

When updating tracking information for fulfillments, the following logic applies:

This ensures that tracking information is always properly associated with the correct fulfillment, whether you're updating existing fulfillments or creating new ones.