Shopify Order Mapping

Below we outline how we map orders within Shopify to orders within ChannelApe. The left side is the ChannelApe field while the right side is the corresponding Shopify field.

NOTE: Please refer to Shopify Order API documentation found here for further information concerning available Shopify Order fields.

Order → Shopify Order

Channel Order ID → Order ID

Status → Cancelled At has value then CANCELED, Closed At has value then CLOSED, otherwise OPEN

Currency → Currency

Total Price → Total Price

Subtotal Price → Subtotal Price

Total Tax → Total Tax

Total Grams → Total Weight

Purchased At → Processed At

Canceled At → Canceled At

Canceled Reason → Cancel Reason

Order Customer → Shopify Order Customer

First Name → First Name

Last Name → Last Name

Email → Email

Order Customer Billing Address → Shopify Order Billing Address

Name → Name

First Name → First Name

Last Name → Last Name

Address 1 → Address 1

Address 2 → Address 2

City → City

Province → Province

Province Code → Province Code

Country → Country

Country Code → Country Code

Postal Code → Zip

Order Customer Shipping Address → Shopify Order Shipping Address

Name → Name

First Name → First Name

Last Name → Last Name

Address 1 → Address 1

Address 2 → Address 2

City → City

Province → Province

Province Code → Province Code

Country → Country

Country Code → Country Code

Postal Code → Zip

Order Customer Additional Fields

accepts_marketing → Shopify Customer Accepts Marketing

orders_count → Shopify Customer Orders Count

total_spent → Shopify Customer Total Spent

note → Shopify Customer Note

state → Shopify Customer State

Order Line Items → Shopify Order Line Items

ID → ID

SKU → SKU

UPC →

Quantity → Quantity

Price → Price

Title → Name

Vendor → Vendor

Grams → Grams

Order Line Item Additional Fields

variant_id → Variant ID

title → Title

variant_title → Variant Title

product_id → Product ID

requires_shipping → Requires Shipping

taxable → Taxable

gift_card → Gift Card

variant_inventory_management → Variant Inventory Management

fulfillable_quantity→ Fulfillable Quantity

total_discount → Total Discount

fulfillment_status→ Fulfillment Status

Order Fulfillments → Shopify Order Fulfillments

NOTE: If a fulfillment is created within ChannelApe some of these Shopify specific fields may not be present. This mapping is just for fulfillments created within ChannelApe when pulling orders from Shopify.

Status → If Shopify Fulfillment Status is “fulfilled” then SUCCESS otherwise OPEN

ID → ID

Shipping Company → Tracking Company

Shipping Method →

Tracking Number → Tracking Number

Order Fulfillment Line Items → Shopify Order Fulfillment Line Items

Same mapping as Order Line Items above.

Order Fulfillment Additional Fields

order_id → Order ID

tracking_url → Tracking URL

fulfillment_created_by_channelape → false

shopify_fulfillment_id → ID

Order Additional Fields

closed_at → Closed At

number → Number

note → Note

token → Token

taxes_included → Taxes Included

financial_status → Financial Status

total_discounts → Total Discounts

total_line_items_price → Total Line Items Price

cart_token → Cart Token

buyer_accepts_marketing → Buyer Accepts Marketing

name → Name

referring_site → Referring Site

landing_site → Landing Site

cancelled_at → Cancelled At

cancel_reason→ Cancel Reason

user_id → User ID

location_id → Location ID

browser_ip → Browser IP

order_number → Order Number

processing_method → Processing Method

source_name → Source Name

fulfillment_status → Fulfillment Status

tags → Tags

order_status_url → Order Status URL