Shopify Get Orders
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Version | Date | Created / Updated | Notes |
|---|---|---|---|
| v1.0 | Hristiyan | First publish |
API Docs : https://shopify.dev/docs/api/admin-rest/2024-01/resources/order#get-orders?status=any
API Call : /admin/api/2024-01/orders.json?status=any
Parameters:
limit: Always 250
updated_at_max: Get the date form last_date_run with overlap of 90mins ISO 8601
status: Always “Any”
source_name: Add this parameter only if we have Account Shopify > Orders Source Name Filter
Please note as part of the get new orders flow we want to store as well the order item location ids using Shopify Get Order Item Locations and every new order downloaded in Hemi should have all the details including the order item location ids
Example Response:
HTTP/1.1 200 OK
{
"orders": [
{
"id": 450789469,
"admin_graphql_api_id": "gid://shopify/Order/450789469",
"app_id": null,
"browser_ip": "0.0.0.0",
"buyer_accepts_marketing": false,
"cancel_reason": null,
"cancelled_at": null,
"cart_token": "68778783ad298f1c80c3bafcddeea02f",
"checkout_id": 901414060,
"checkout_token": "bd5a8aa1ecd019dd3520ff791ee3a24c",
"client_details": {
"accept_language": null,
"browser_height": null,
"browser_ip": "0.0.0.0",
"browser_width": null,
"session_hash": null,
"user_agent": null
},
"closed_at": null,
"confirmation_number": null,
"confirmed": true,
"contact_email": "bob.norman@mail.example.com",
"created_at": "2008-01-10T11:00:00-05:00",
"currency": "USD",
"current_subtotal_price": "195.67",
"current_subtotal_price_set": {
"shop_money": {
"amount": "195.67",
"currency_code": "USD"
},
"presentment_money": {
"amount": "195.67",
"currency_code": "USD"
}
},
"current_total_additional_fees_set": null,
"current_total_discounts": "3.33",
"current_total_discounts_set": {
"shop_money": {
"amount": "3.33",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.33",
"currency_code": "USD"
}
},
"current_total_duties_set": null,
"current_total_price": "199.65",
"current_total_price_set": {
"shop_money": {
"amount": "199.65",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.65",
"currency_code": "USD"
}
},
"current_total_tax": "3.98",
"current_total_tax_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"customer_locale": null,
"device_id": null,
"discount_codes": [
{
"code": "TENOFF",
"amount": "10.00",
"type": "fixed_amount"
}
],
"email": "bob.norman@mail.example.com",
"estimated_taxes": false,
"financial_status": "partially_refunded",
"fulfillment_status": null,
"landing_site": "http://www.example.com?source=abc",
"landing_site_ref": "abc",
"location_id": null,
"merchant_of_record_app_id": null,
"name": "#1001",
"note": null,
"note_attributes": [
{
"name": "custom engraving",
"value": "Happy Birthday"
},
{
"name": "colour",
"value": "green"
}
],
"number": 1,
"order_number": 1001,
"order_status_url": "https://jsmith.myshopify.com/548380009/orders/b1946ac92492d2347c6235b4d2611184/authenticate?key=imasecretipod",
"original_total_additional_fees_set": null,
"original_total_duties_set": null,
"payment_gateway_names": [
"bogus"
],
"phone": "+557734881234",
"po_number": "ABC123",
"presentment_currency": "USD",
"processed_at": "2008-01-10T11:00:00-05:00",
"reference": "fhwdgads",
"referring_site": "http://www.otherexample.com",
"source_identifier": "fhwdgads",
"source_name": "web",
"source_url": null,
"subtotal_price": "597.00",
"subtotal_price_set": {
"shop_money": {
"amount": "597.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "597.00",
"currency_code": "USD"
}
},
"tags": "",
"tax_exempt": false,
"tax_lines": [
{
"price": "11.94",
"rate": 0.06,
"title": "State Tax",
"price_set": {
"shop_money": {
"amount": "11.94",
"currency_code": "USD"
},
"presentment_money": {
"amount": "11.94",
"currency_code": "USD"
}
},
"channel_liable": null
}
],
"taxes_included": false,
"test": false,
"token": "b1946ac92492d2347c6235b4d2611184",
"total_discounts": "10.00",
"total_discounts_set": {
"shop_money": {
"amount": "10.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "10.00",
"currency_code": "USD"
}
},
"total_line_items_price": "597.00",
"total_line_items_price_set": {
"shop_money": {
"amount": "597.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "597.00",
"currency_code": "USD"
}
},
"total_outstanding": "0.00",
"total_price": "598.94",
"total_price_set": {
"shop_money": {
"amount": "598.94",
"currency_code": "USD"
},
"presentment_money": {
"amount": "598.94",
"currency_code": "USD"
}
},
"total_shipping_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"total_tax": "11.94",
"total_tax_set": {
"shop_money": {
"amount": "11.94",
"currency_code": "USD"
},
"presentment_money": {
"amount": "11.94",
"currency_code": "USD"
}
},
"total_tip_received": "0.00",
"total_weight": 0,
"updated_at": "2008-01-10T11:00:00-05:00",
"user_id": null,
"billing_address": {
"first_name": "Bob",
"address1": "Chestnut Street 92",
"phone": "+1(502)-459-2181",
"city": "Louisville",
"zip": "40202",
"province": "Kentucky",
"country": "United States",
"last_name": "Norman",
"address2": "",
"company": null,
"latitude": 45.41634,
"longitude": -75.6868,
"name": "Bob Norman",
"country_code": "US",
"province_code": "KY"
},
"customer": {
"id": 207119551,
"email": "bob.norman@mail.example.com",
"created_at": "2024-01-02T08:59:11-05:00",
"updated_at": "2024-01-02T08:59:11-05:00",
"first_name": "Bob",
"last_name": "Norman",
"state": "disabled",
"note": null,
"verified_email": true,
"multipass_identifier": null,
"tax_exempt": false,
"phone": "+16136120707",
"email_marketing_consent": {
"state": "not_subscribed",
"opt_in_level": null,
"consent_updated_at": "2004-06-13T11:57:11-04:00"
},
"sms_marketing_consent": {
"state": "not_subscribed",
"opt_in_level": "single_opt_in",
"consent_updated_at": "2024-01-02T08:59:11-05:00",
"consent_collected_from": "OTHER"
},
"tags": "Léon, Noël",
"currency": "USD",
"tax_exemptions": [],
"admin_graphql_api_id": "gid://shopify/Customer/207119551",
"default_address": {
"id": 207119551,
"customer_id": 207119551,
"first_name": null,
"last_name": null,
"company": null,
"address1": "Chestnut Street 92",
"address2": "",
"city": "Louisville",
"province": "Kentucky",
"country": "United States",
"zip": "40202",
"phone": "555-625-1199",
"name": "",
"province_code": "KY",
"country_code": "US",
"country_name": "United States",
"default": true
}
},
"discount_applications": [
{
"target_type": "line_item",
"type": "discount_code",
"value": "10.0",
"value_type": "fixed_amount",
"allocation_method": "across",
"target_selection": "all",
"code": "TENOFF"
}
],
"fulfillments": [
{
"id": 255858046,
"admin_graphql_api_id": "gid://shopify/Fulfillment/255858046",
"created_at": "2024-01-02T08:59:11-05:00",
"location_id": 655441491,
"name": "#1001.0",
"order_id": 450789469,
"origin_address": {},
"receipt": {
"testcase": true,
"authorization": "123456"
},
"service": "manual",
"shipment_status": null,
"status": "failure",
"tracking_company": "USPS",
"tracking_number": "1Z2345",
"tracking_numbers": [
"1Z2345"
],
"tracking_url": "https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=1Z2345",
"tracking_urls": [
"https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=1Z2345"
],
"updated_at": "2024-01-02T08:59:11-05:00",
"line_items": [
{
"id": 466157049,
"admin_graphql_api_id": "gid://shopify/LineItem/466157049",
"current_quantity": 0,
"fulfillable_quantity": 0,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - green",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [
{
"name": "Custom Engraving Front",
"value": "Happy Birthday"
},
{
"name": "Custom Engraving Back",
"value": "Merry Christmas"
}
],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008GREEN",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 39072856,
"variant_inventory_management": "shopify",
"variant_title": "green",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.34",
"amount_set": {
"shop_money": {
"amount": "3.34",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.34",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
}
]
}
],
"line_items": [
{
"id": 466157049,
"admin_graphql_api_id": "gid://shopify/LineItem/466157049",
"current_quantity": 0,
"fulfillable_quantity": 0,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - green",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [
{
"name": "Custom Engraving Front",
"value": "Happy Birthday"
},
{
"name": "Custom Engraving Back",
"value": "Merry Christmas"
}
],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008GREEN",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 39072856,
"variant_inventory_management": "shopify",
"variant_title": "green",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.34",
"amount_set": {
"shop_money": {
"amount": "3.34",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.34",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
},
{
"id": 518995019,
"admin_graphql_api_id": "gid://shopify/LineItem/518995019",
"current_quantity": 1,
"fulfillable_quantity": 1,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - red",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008RED",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 49148385,
"variant_inventory_management": "shopify",
"variant_title": "red",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.33",
"amount_set": {
"shop_money": {
"amount": "3.33",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.33",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
},
{
"id": 703073504,
"admin_graphql_api_id": "gid://shopify/LineItem/703073504",
"current_quantity": 0,
"fulfillable_quantity": 0,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - black",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008BLACK",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 457924702,
"variant_inventory_management": "shopify",
"variant_title": "black",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.33",
"amount_set": {
"shop_money": {
"amount": "3.33",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.33",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
}
],
"payment_terms": null,
"refunds": [
{
"id": 509562969,
"admin_graphql_api_id": "gid://shopify/Refund/509562969",
"created_at": "2024-01-02T08:59:11-05:00",
"note": "it broke during shipping",
"order_id": 450789469,
"processed_at": "2024-01-02T08:59:11-05:00",
"restock": true,
"total_additional_fees_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"total_duties_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"user_id": 548380009,
"order_adjustments": [],
"transactions": [
{
"id": 179259969,
"admin_graphql_api_id": "gid://shopify/OrderTransaction/179259969",
"amount": "209.00",
"authorization": "authorization-key",
"created_at": "2005-08-05T12:59:12-04:00",
"currency": "USD",
"device_id": null,
"error_code": null,
"gateway": "bogus",
"kind": "refund",
"location_id": null,
"message": null,
"order_id": 450789469,
"parent_id": 801038806,
"payment_id": "#1001.3",
"processed_at": "2005-08-05T12:59:12-04:00",
"receipt": {},
"source_name": "web",
"status": "success",
"test": false,
"user_id": null
}
],
"refund_line_items": [
{
"id": 104689539,
"line_item_id": 703073504,
"location_id": 487838322,
"quantity": 1,
"restock_type": "legacy_restock",
"subtotal": 195.66,
"subtotal_set": {
"shop_money": {
"amount": "195.66",
"currency_code": "USD"
},
"presentment_money": {
"amount": "195.66",
"currency_code": "USD"
}
},
"total_tax": 3.98,
"total_tax_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"line_item": {
"id": 703073504,
"admin_graphql_api_id": "gid://shopify/LineItem/703073504",
"current_quantity": 0,
"fulfillable_quantity": 0,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - black",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008BLACK",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 457924702,
"variant_inventory_management": "shopify",
"variant_title": "black",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.33",
"amount_set": {
"shop_money": {
"amount": "3.33",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.33",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
}
},
{
"id": 709875399,
"line_item_id": 466157049,
"location_id": 487838322,
"quantity": 1,
"restock_type": "legacy_restock",
"subtotal": 195.67,
"subtotal_set": {
"shop_money": {
"amount": "195.67",
"currency_code": "USD"
},
"presentment_money": {
"amount": "195.67",
"currency_code": "USD"
}
},
"total_tax": 3.98,
"total_tax_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"line_item": {
"id": 466157049,
"admin_graphql_api_id": "gid://shopify/LineItem/466157049",
"current_quantity": 0,
"fulfillable_quantity": 0,
"fulfillment_service": "manual",
"fulfillment_status": null,
"gift_card": false,
"grams": 200,
"name": "IPod Nano - 8gb - green",
"price": "199.00",
"price_set": {
"shop_money": {
"amount": "199.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "199.00",
"currency_code": "USD"
}
},
"product_exists": true,
"product_id": 632910392,
"properties": [
{
"name": "Custom Engraving Front",
"value": "Happy Birthday"
},
{
"name": "Custom Engraving Back",
"value": "Merry Christmas"
}
],
"quantity": 1,
"requires_shipping": true,
"sku": "IPOD2008GREEN",
"taxable": true,
"title": "IPod Nano - 8gb",
"total_discount": "0.00",
"total_discount_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"variant_id": 39072856,
"variant_inventory_management": "shopify",
"variant_title": "green",
"vendor": null,
"tax_lines": [
{
"channel_liable": null,
"price": "3.98",
"price_set": {
"shop_money": {
"amount": "3.98",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.98",
"currency_code": "USD"
}
},
"rate": 0.06,
"title": "State Tax"
}
],
"duties": [],
"discount_allocations": [
{
"amount": "3.34",
"amount_set": {
"shop_money": {
"amount": "3.34",
"currency_code": "USD"
},
"presentment_money": {
"amount": "3.34",
"currency_code": "USD"
}
},
"discount_application_index": 0
}
]
}
}
],
"duties": [],
"additional_fees": []
}
],
"shipping_address": {
"first_name": "Bob",
"address1": "Chestnut Street 92",
"phone": "+1(502)-459-2181",
"city": "Louisville",
"zip": "40202",
"province": "Kentucky",
"country": "United States",
"last_name": "Norman",
"address2": "",
"company": null,
"latitude": 45.41634,
"longitude": -75.6868,
"name": "Bob Norman",
"country_code": "US",
"province_code": "KY"
},
"shipping_lines": [
{
"id": 369256396,
"carrier_identifier": null,
"code": "Free Shipping",
"discounted_price": "0.00",
"discounted_price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"phone": null,
"price": "0.00",
"price_set": {
"shop_money": {
"amount": "0.00",
"currency_code": "USD"
},
"presentment_money": {
"amount": "0.00",
"currency_code": "USD"
}
},
"requested_fulfillment_service_id": null,
"source": "shopify",
"title": "Free Shipping",
"tax_lines": [],
"discount_allocations": []
}
]
}
]
}Response Mapping :
| Shopify FIeld | Hemi Field | Notes | ||||||
|---|---|---|---|---|---|---|---|---|
orders |
||||||||
id |
Orders > Marketplace Order Id | |||||||
admin_graphql_api_id |
N/A | |||||||
app_id |
N/A | |||||||
browser_ip |
N/A | |||||||
buyer_accepts_marketing |
N/A | |||||||
cancel_reason |
||||||||
cancelled_atcart_token |
||||||||
checkout_id |
||||||||
checkout_token |
||||||||
client_details |
||||||||
accept_language |
N/A | |||||||
"browser_height": null, |
N/A | |||||||
browser_ip |
N/A | |||||||
browser_width |
N/A | |||||||
session_hash |
N/A | |||||||
user_agent |
N/A | |||||||
closed_at |
N/A | |||||||
confirmation_number |
||||||||
confirmed |
||||||||
contact_email |
||||||||
created_at |
||||||||
currency |
||||||||
current_subtotal_price |
||||||||
current_subtotal_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
current_total_additional_fees_set |
||||||||
current_total_discounts |
||||||||
current_total_discounts_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
current_total_duties_set |
||||||||
current_total_price |
||||||||
current_total_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
current_total_tax |
||||||||
current_total_tax_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
customer_locale |
N/A | |||||||
device_id |
N/A | |||||||
discount_codes |
||||||||
code |
||||||||
amount |
||||||||
type |
||||||||
email |
||||||||
estimated_taxes |
||||||||
financial_status |
||||||||
fulfillment_status |
||||||||
landing_site |
||||||||
landing_site_ref |
||||||||
location_id |
||||||||
merchant_of_record_app_id |
N/A | |||||||
name |
||||||||
note |
||||||||
note_attributes |
||||||||
name |
||||||||
value |
||||||||
number |
||||||||
order_number |
||||||||
order_status_url |
||||||||
original_total_additional_fees_set |
||||||||
original_total_duties_set |
||||||||
payment_gateway_names |
||||||||
phone |
||||||||
po_number |
||||||||
presentment_currency |
||||||||
processed_at |
||||||||
reference |
||||||||
referring_site |
||||||||
source_identifier |
||||||||
source_name |
||||||||
source_url |
||||||||
subtotal_price |
||||||||
subtotal_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
tags |
||||||||
tax_exempt |
||||||||
tax_lines |
||||||||
price |
||||||||
rate |
||||||||
title |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
channel_liable |
||||||||
taxes_included |
||||||||
test |
||||||||
token |
||||||||
total_discounts |
||||||||
total_discounts_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_line_items_price |
||||||||
total_line_items_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_outstanding |
||||||||
total_price |
||||||||
total_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_shipping_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_tax |
||||||||
total_tax_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_tip_received |
||||||||
total_weight |
||||||||
updated_at |
||||||||
user_id |
||||||||
billing_address |
||||||||
first_name |
||||||||
address1 |
||||||||
phone |
||||||||
city |
||||||||
zip |
||||||||
province |
||||||||
country |
||||||||
last_name |
||||||||
address2 |
||||||||
company |
||||||||
latitude |
||||||||
longitude |
||||||||
name |
||||||||
country_code |
||||||||
province_code |
||||||||
customer |
||||||||
id |
||||||||
email |
||||||||
created_at |
||||||||
updated_at |
||||||||
first_name |
||||||||
last_name |
||||||||
state |
||||||||
note |
||||||||
verified_email |
||||||||
multipass_identifier |
||||||||
tax_exempt |
||||||||
phone |
||||||||
email_marketing_consent |
||||||||
state |
N/A | |||||||
opt_in_level |
N/A | |||||||
consent_updated_at |
N/A | |||||||
sms_marketing_consent |
||||||||
state |
N/A | |||||||
opt_in_level |
N/A | |||||||
consent_updated_at |
N/A | |||||||
consent_collected_from |
N/A | |||||||
tags |
||||||||
currency |
||||||||
tax_exemptions |
||||||||
admin_graphql_api_id |
N/A | |||||||
default_address |
||||||||
id |
||||||||
customer_id |
||||||||
first_name |
||||||||
last_name |
||||||||
company |
||||||||
address1 |
||||||||
address2 |
||||||||
city |
||||||||
province |
||||||||
country |
||||||||
zip |
||||||||
phone |
||||||||
name |
||||||||
province_code |
||||||||
country_code |
||||||||
country_name |
||||||||
default |
||||||||
discount_applications |
||||||||
target_type |
||||||||
type |
||||||||
value |
||||||||
value_type |
||||||||
allocation_method |
||||||||
target_selection |
||||||||
code |
||||||||
fulfillments |
||||||||
id |
||||||||
admin_graphql_api_id |
||||||||
created_at |
||||||||
location_id |
||||||||
name |
||||||||
order_id |
||||||||
origin_address |
||||||||
receipt |
||||||||
testcase |
||||||||
authorization |
||||||||
service |
||||||||
shipment_status |
||||||||
status |
||||||||
tracking_company |
||||||||
tracking_number |
||||||||
tracking_numbers |
||||||||
tracking_url |
||||||||
tracking_urls |
||||||||
updated_at |
||||||||
line_items |
||||||||
id |
||||||||
admin_graphql_api_id |
N/A | |||||||
current_quantity |
||||||||
fulfillable_quantity |
||||||||
fulfillment_service |
||||||||
fulfillment_status |
||||||||
gift_card |
||||||||
grams |
||||||||
name |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
product_exists |
||||||||
product_id |
||||||||
properties |
||||||||
name |
||||||||
value |
||||||||
quantity |
||||||||
requires_shipping |
||||||||
sku |
||||||||
taxable |
||||||||
title |
||||||||
total_discount |
||||||||
total_discount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
variant_id |
||||||||
variant_inventory_management |
||||||||
variant_title |
||||||||
vendor |
||||||||
tax_lines |
||||||||
channel_liable |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
rate |
||||||||
title |
||||||||
duties |
||||||||
discount_allocations |
||||||||
amount |
||||||||
amount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
discount_application_index |
||||||||
line_items |
||||||||
id |
||||||||
admin_graphql_api_id |
||||||||
current_quantity |
||||||||
fulfillable_quantity |
||||||||
fulfillment_service |
||||||||
fulfillment_status |
||||||||
gift_card |
||||||||
grams |
||||||||
name |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
product_exists |
||||||||
product_id |
||||||||
properties |
||||||||
name |
||||||||
value |
||||||||
quantity |
||||||||
requires_shipping |
||||||||
sku |
||||||||
taxable |
||||||||
title |
||||||||
total_discount |
||||||||
total_discount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
variant_id |
||||||||
variant_inventory_management |
||||||||
variant_title |
||||||||
vendor |
||||||||
tax_lines |
||||||||
channel_liable |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
rate |
||||||||
title |
||||||||
duties |
||||||||
discount_allocations |
||||||||
amount |
||||||||
amount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
discount_application_index |
||||||||
payment_terms |
||||||||
refunds |
||||||||
id |
||||||||
admin_graphql_api_id |
||||||||
created_at |
||||||||
note |
||||||||
order_id |
||||||||
processed_at |
||||||||
restock |
||||||||
total_additional_fees_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_duties_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
user_id |
||||||||
order_adjustments |
||||||||
transactions |
||||||||
id |
||||||||
admin_graphql_api_id |
||||||||
amount |
||||||||
authorization |
||||||||
created_at |
||||||||
currency |
||||||||
device_id |
||||||||
error_code |
||||||||
gateway |
||||||||
kind |
||||||||
location_id |
||||||||
message |
||||||||
order_id |
||||||||
parent_id |
||||||||
payment_id |
||||||||
processed_at |
||||||||
receipt |
||||||||
source_name |
||||||||
status |
||||||||
test |
||||||||
user_id |
||||||||
refund_line_items |
||||||||
id |
||||||||
line_item_id |
||||||||
location_id |
||||||||
quantity |
||||||||
restock_type |
||||||||
subtotal |
||||||||
subtotal_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
total_tax |
||||||||
total_tax_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
line_item |
||||||||
id |
||||||||
admin_graphql_api_id |
||||||||
current_quantity |
||||||||
fulfillable_quantity |
||||||||
fulfillment_service |
||||||||
fulfillment_status |
||||||||
gift_card |
||||||||
grams |
||||||||
name |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
product_exists |
||||||||
product_id |
||||||||
properties |
||||||||
quantity |
||||||||
requires_shipping |
||||||||
sku |
||||||||
taxable |
||||||||
title |
||||||||
total_discount |
||||||||
total_discount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
variant_id |
||||||||
variant_inventory_management |
||||||||
variant_title |
||||||||
vendor |
||||||||
tax_lines |
||||||||
channel_liable |
||||||||
price |
||||||||
price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
rate |
||||||||
title |
||||||||
duties |
||||||||
discount_allocations |
||||||||
amount |
||||||||
amount_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
discount_application_index |
||||||||
duties |
||||||||
additional_fees |
||||||||
shipping_address |
||||||||
first_name |
||||||||
address1 |
||||||||
phone |
||||||||
city |
||||||||
zip |
||||||||
province |
||||||||
country |
||||||||
last_name |
||||||||
address2 |
||||||||
company |
||||||||
latitude |
||||||||
longitude |
||||||||
name |
||||||||
country_code |
||||||||
province_code |
||||||||
shipping_lines |
||||||||
id |
||||||||
carrier_identifier |
||||||||
code |
||||||||
discounted_price |
||||||||
discounted_price_set |
||||||||
shop_money |
||||||||
amount |
||||||||
currency_code |
||||||||
presentment_money |
||||||||
amount |
||||||||
currency_code |
||||||||
requested_fulfillment_service_id |
||||||||
source |
||||||||
title |
||||||||
tax_lines |
||||||||
discount_allocations |