Shopify integration summary

Stitch’s Shopify integration replicates data using the Shopify REST Admin API (v2022-07). Refer to the Schema section for a list of objects available for replication.

Shopify feature snapshot

A high-level look at Stitch's Shopify (v1) integration, including release status, useful links, and the features supported in Stitch.

STITCH
Release status

Released on January 2, 2019

 Supported by

Stitch
Stitch plan

Standard

 API availability

Available
Singer GitHub repository

singer-io/tap-shopify
REPLICATION SETTINGS
Anchor Scheduling

Supported

 Advanced Scheduling

Supported
Table-level reset

Unsupported

 Configurable Replication Methods

Unsupported
DATA SELECTION
Table selection

Supported

 Column selection

Supported
Select all

Supported
TRANSPARENCY
Extraction Logs

Supported

 Loading Reports

Supported

Connecting Shopify

Shopify setup requirements

To set up Shopify in Stitch, you need:

  • Admin access in Shopify. This is required to allow Stitch to replicate data.

    Note: If you’re on a Shopify Plus plan, the permissions required may differ. Store owners can grant users permissions to export orders, draft orders, products, inventory, and customer data. In general, view-level permissions should be sufficient.

    Refer to the Shopify Staff permissions documentation for more information.

Step 1: Add Shopify as a Stitch data source

  1. Sign into your Stitch account.

  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the Shopify icon.

  4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.

    For example, the name “Stitch Shopify” would create a schema called stitch_shopify in the destination. Note: Schema names cannot be changed after you save the integration.

  5. In the Shopify Shop field, enter the name of the shop you want to connect to Stitch. For example: If the shop URL was stitch-data.shopify.com, you’d enter stitch-data into this field.

Step 2: Define the historical replication start date

The Sync Historical Data setting defines the starting date for your Shopify integration. This means that data equal to or newer than this date will be replicated to your data warehouse.

Change this setting if you want to replicate data beyond Shopify’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.

Step 3: Create a replication schedule

In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.

Shopify integrations support the following replication scheduling methods:

To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.

Step 4: Authorize Stitch to access Shopify

  1. Next, you’ll be prompted to sign into your Shopify account. Enter your Shopify credentials.
  2. Click Log in.
  3. After the authorization process is successfully completed, you’ll be directed back to Stitch.
  4. Click All Done.

Step 5: Set objects to replicate

The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.

Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.

For Shopify integrations, you can select:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.

  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.

  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.

  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. Click the Finalize Your Selections button at the bottom of the page to save your data selections.

Initial and historical replication jobs

After you finish setting up Shopify, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.

For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.

Free historical data loads

The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.

Shopify replication

Replicating order refunds

To extract order refund data, Stitch queries every order in your account. If you have the order_refunds table selected for replication, the process can potentially be very slow depending on how many orders and refunds exist in your Shopify account. As tables are extracted one at a time, this could cause extraction to not proceed for days at a time. To ensure timely replication of your other selected tables, consider creating a separate integration for only the order_refunds table.

Note: Creating a separate integration for your order_refunds table may negatively affect your Shopify API quota.

Shopify table reference

abandoned_checkouts

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve all abandoned checkouts

The abandoned_checkouts table contains info about abandoned checkouts. Shopify considers a checkout to be abandoned when a customer has entered billing and shipping details, but hasn’t completed the purchase.

abandoned_checkouts table schema

id
INTEGER

The abandoned checkout ID.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the checkout was last updated.

abandoned_checkout_url
STRING

The recovery URL that is sent to a customer so they can recover their checkout.

billing_address
OBJECT

The customer’s billing address details.

Click to expand billing_address

address1
STRING

The street address of the billing address.

address2
STRING

An optional field for the street address of the billing address.

city
STRING

The city of the billing address.

company
STRING

The company of the person associated with the billing address.

country
STRING

The name of the country of the billing address.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the billing address.

first_name
STRING

The first name of the person associated with the payment method.

last_name
STRING

The last name of the person associated with the payment method.

latitude
NUMBER

The latitude of the billing address.

longitude
NUMBER

The longitude of the billing address.

name
STRING

The full name of the person associated with the payment method.

phone
STRING

The phone number at the billing address.

province
STRING

The name of the state or province of the billing address.

province_code
STRING

The two-letter abbreviation of the state or province of the billing address.

zip
STRING

The zip or postal code of the billing address.
abandoned_checkouts (table), billing_address (attribute)

buyer_accepts_marketing
BOOLEAN

Indicates whether the customer wants to receive email updates from the shop.

buyer_accepts_sms_marketing
BOOLEAN

Indicates whether the customer wants to receive SMS updates from the shop.

cart_token
STRING

The ID of the cart that is attached to the checkout.

closed_at
DATE-TIME

The date and time in ISO 8601 format when the checkout was closed. If the checkout wasn’t closed, this value will be null.

completed_at
DATE-TIME

The date and time in ISO 8601 format when the checkout was completed. For abandoned checkouts, this value will always be null.

created_at
DATE-TIME

The date and time in ISO 8601 format when the checkout was created.

currency
STRING

The three-letter ISO 4217 code of the shop’s default currency at the time of checkout.

For the currency the customer used at checkout, see presentment_currency.

customer
OBJECT

Details about the customer associated with the abandoned checkout.

Click to expand customer

id
INTEGER

The customer ID.

Reference:

accepts_marketing
BOOLEAN

Indicates the customer has consented to receive marketing material via email.

created_at
DATE-TIME

The date and time in ISO 8601 format when the customer was created.

default_address
OBJECT

Details about the customer’s default address.

Click to expand default_address

address1
STRING

The street address of the customer’s address.

address2
STRING

An optional field for the street address of the customer’s address.

city
STRING

The city of the customer’s address.

company
STRING

The company of the person associated with the customer’s address.

country
STRING

The name of the country of the customer’s address.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the customer’s address.

country_name
STRING

The customer’s normalized country name.

customer_id
INTEGER

The customer’s ID.

Reference:

default
BOOLEAN

Indicates if this is the customer’s default address.

first_name
STRING

The first name of the customer.

id
INTEGER

The address ID.

last_name
STRING

The last name of the customer.

name
STRING

The customer’s first and last name.

phone
STRING

The customer’s phone number at this address.

province
STRING

The customer’s region name.

province_code
STRING

The two-letter province code for the customer’s region.

zip
STRING

The customer’s postal or zip code.
abandoned_checkouts (table), default_address (attribute)

email
STRING

The customer’s email address.

first_name
STRING

The first name of the customer.

last_name
STRING

The last name of the customer.

last_order_id
INTEGER

The ID of the customer’s last order.

Reference:

last_order_name
STRING

The name of the customer’s last order. This is related to the name field in the orders table.

multipass_identifier
STRING

The customer’s Multipass login ID.

note
STRING

A note about the customer.

orders_count
INTEGER

The number of orders associated with the customer.

phone
STRING

The phone number for the customer, in E.164 format.

state
STRING

The state of the customer’s account with a shop. Possible values are:

  • disabled - The customer doesn’t have an active account.
  • invited - The customer has received an email invite to create an account.
  • enabled - The customer has created an account.
  • declined - The customer has declined the eamil invite to create an account.

tags
STRING

Tags that the shop owner has attached to the customer.

tax_exempt
BOOLEAN

Indicates if the customer is exempt from paying taxes on their order. If true, taxes will not be applied to an order at checkout.

total_spent
STRING

The total amount of money that the customer has spent across their order history.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the customer was last updated.

verified_email
BOOLEAN

Indicates if the customer has verified their email address.
abandoned_checkouts (table), customer (attribute)

customer_id
INTEGER

The ID of the customer associated with the abandoned checkout.

customer_locale
STRING

The two or three-letter language code, optionally followed by a region modifier.

device_id
INTEGER

The ID of the Shopify POS device that created the checkout.

discount_codes
ARRAY

The discount codes applied to the checkout.

Click to expand discount_codes

amount
NUMBER

The amount of the discount.

code
STRING

The discount code.

type
STRING

The type of discount. Possible values are:

  • percentage
  • shipping
  • fixed_amount
abandoned_checkouts (table), discount_codes (attribute)

email
STRING

The customer’s email address.

gateway
STRING

The payment gateway used by the checkout. For abandoned checkouts, this value will always be null.

landing_site
STRING

The URL for the page where the customer entered the shop.

line_items
ARRAY

A list of line items in the checkout.

Click to expand line_items

id
STRING

The line item ID.

applied_discount
INTEGER

The amount of the discount applied to the line item.

applied_discounts
ARRAY

compare_at_price
STRING

The price of a line item before a sale or discount.

destination_location
OBJECT

Details about the line item’s destination location.

Click to expand destination_location

address1
STRING

The street address.

address2
STRING

An optional second line for the address.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the destination address.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
abandoned_checkouts (table), destination_location (attribute)

destination_location_id
INTEGER

The ID of the destination location.

discount_allocations
ARRAY

An ordered list of amounts allocated by discount applications. Each discount allocation is associated to a particular application.

Click to expand discount_allocations

amount
NUMBER

The discount amount allocated to the line.

discount_application_index
INTEGER

The index of the associated discount application in the order’s discount_allocations list.
abandoned_checkouts (table), discount_allocations (attribute)

fulfillable_quantity
INTEGER

The amount available to fulfill, calculated as follows:

quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity

fulfillment_service
STRING

The fulfillment service provider for the item.

fulfillment_status
STRING

The status of the item’s fulfillment. Possible values are:

  • fulfilled
  • null
  • partial

gift_card
BOOLEAN

Indicates if the line item is a gift card.

grams
INTEGER

The weight of the item in grams.

key
STRING

A unique identifier for the line item, constructed from the line item’s variant_id plus a hash of the line item’s properties, even if the item has no additional properties.

line_price
STRING

This field has been deprecated by Shopify.

name
STRING

The name of the line item.

origin_location
OBJECT

Details about the line item’s origin location.

Click to expand origin_location

address1
STRING

The street address.

address2
STRING

An optional second line for the address.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the destination address.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
abandoned_checkouts (table), origin_location (attribute)

origin_location_id
INTEGER

The ID of the origin location associated with the line item.

pre_tax_price
NUMBER

The pre-tax price of the item.

price
NUMBER

The price of the item before discounts were applied.

product_exists
BOOLEAN

Indicates if the product exists.

product_id
INTEGER

The product ID of the item.

Reference:

properties
ARRAY

Details about custom info for the item.

Click to expand properties

name
STRING

value
STRING

abandoned_checkouts (table), properties (attribute)

quantity
INTEGER

The number of items purchased.

requires_shipping
BOOLEAN

Indicates if the item requires shipping.

sku
STRING

The item’s SKU.

tax_code
STRING

tax_lines
ARRAY

Details about the line item’s tax lines, each of which details a tax applicable to this line item.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

abandoned_checkouts (table), tax_lines (attribute)

taxable
BOOLEAN

Indicates if the item is taxable.

title
STRING

The title of the product.

total_discount
NUMBER

The total of any discounts applied to the line item.

variant_id
INTEGER

The product variant ID.

variant_inventory_management
STRING

The name of the inventory management system.

variant_title
STRING

The title of the product variant.

vendor
STRING

The name of the item’s supplier.
abandoned_checkouts (table), line_items (attribute)

location_id
INTEGER

The ID of the physical location where the checkout was processed.

name
STRING

The order name as represented by a number.

note_attributes
ARRAY

Click to expand note_attributes

name
STRING

value
STRING

abandoned_checkouts (table), note_attributes (attribute)

note
STRING

An optional note attached to the order.

phone
STRING

The customer’s phone number.

presentment_currency
STRING

The three-letter ISO 4217 code of the currency that the customer used at checkout.

referring_site
STRING

The website that referred the customer to the shop.

shipping_address
OBJECT

Details about the shipping address associated with the checkout.

Click to expand shipping_address

address1
STRING

The street address of the shipping address.

address2
STRING

An optional field for the street address of the shipping address.

city
STRING

The city of the shipping address.

company
STRING

The company of the person associated with the shipping address.

country
STRING

The name of the country of the shipping address.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the shipping address.

first_name
STRING

The first name of the person associated with the payment method.

last_name
STRING

The last name of the person associated with the payment method.

latitude
NUMBER

The latitude of the shipping address.

longitude
NUMBER

The longitude of the shipping address.

name
STRING

The full name of the person associated with the payment method.

phone
STRING

The phone number at the shipping address.

province
STRING

The name of the state or province of the shipping address.

province_code
STRING

The two-letter abbreviation of the state or province of the shipping address.

zip
STRING

The zip or postal code of the shipping address.
abandoned_checkouts (table), shipping_address (attribute)

shipping_lines
ARRAY

Details about the shipping methods associated with the order.

Click to expand shipping_lines

id
INTEGER

The shipping line ID.

applied_discounts
ARRAY

carrier_identifier
STRING

The shipping carrier’s identifier.

code
STRING

A reference to the shipping method.

custom_tax_lines
ARRAY

delivery_category
STRING

markup
STRING

phone
STRING

The phone number associated with the shipping method.

price
NUMBER

The price of the shipping method.

requested_fulfillment_service_id
STRING

A reference to the fulfillment service being requested for the shipping method. Present if the shipping method requires processing by a third party fulfillment service; null otherwise.

source
STRING

The channel where the checkout originated.

tax_lines
ARRAY

Details about the shipping line’s tax lines, each of which details a tax applicable to this shipping line.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

abandoned_checkouts (table), tax_lines (attribute)

title
STRING

The title of the shipping method.

validation_context
STRING

abandoned_checkouts (table), shipping_lines (attribute)

sms_marketing_phone
STRING

The phone number used to opt in to SMS marketing during checkout.

source
STRING

The channel where the checkout originated.

source_identifier
STRING

source_name
STRING

Where the checkout originated. Possible values are:

  • web
  • pos
  • iphone
  • android

source_url
STRING

subtotal_price
NUMBER

The price of the checkout before shipping and taxes.

tax_lines
ARRAY

Details about the taxes applicable to the checkout.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

abandoned_checkouts (table), tax_lines (attribute)

taxes_included
BOOLEAN

Indicates if taxes are included in the price.

token
STRING

A unique ID for the checkout.

total_discounts
NUMBER

The total amount of discounts to be applied.

total_duties
STRING

The total duties of the checkout in presentment currency.

total_line_items_price
NUMBER

The sum of the prices of all line items in the checkout.

total_price
NUMBER

The sum of the prices of all line items in the checkout, discounts, shipping costs, and taxes

total_tax
NUMBER

The sum of all the taxes applied to the checkout.

total_weight
INTEGER

The sum of all the weights in grams of the line items in the checkout.

user_id
INTEGER

The ID of the user who created the checkout.

collects

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve all collects for the shop

The collects table contains info about collects, which are used to manage relationships between products and custom collections. For every product in a custom collection, there’s a collect that tracks the ID of both the product and the custom collection.

collects table schema

id
INTEGER

The collect ID.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the collect was last updated.

collection_id
INTEGER

The ID of the custom collection containing the product.

Reference:

created_at
DATE-TIME

The date and time in ISO 8601 format when the collect was created.

featured
BOOLEAN

Indicates whether the collect is featured.

position
INTEGER

The position of the product in a manually sorted custom collection.

product_id
INTEGER

The ID of the product in the custom collection.

Reference:

sort_value
STRING

The same value as position, but padded with leading zeroes to make it alphanumeric-sortable.

customers

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of customers

The customers table contains info about the shop’s customers. This includes their contact details, order history, and email marketing preferences.

Customer metafield data

To replicate customer metafield data, you must set this table and the metafields table to replicate.

customers table schema

id
INTEGER

The customer ID.

Reference:

updated_at
DATE-TIME

The date and time in ISO 8601 format when the customer was last updated.

accepts_marketing
BOOLEAN

Indicates if the customer has consented to receive marketing emails.

accepts_marketing_updated_at
DATE-TIME

An ISO 8601-formated date of when the customer consented to receive marketing emails.

addresses
ARRAY

A list of the 10 most recently updated addresses for the customer.

Click to expand addresses

address1
STRING

The street address.

address2
STRING

The second line of the street address.

city
STRING

The city, town, or village.

company
STRING

The company associated with the address.

country
STRING

The country associated with the address.

country_code
STRING

The two-letter country code corresponding to the country.

country_name
STRING

The normalized country name.

customer_id
INTEGER

The customer’s ID.

Reference:

default
BOOLEAN

Indicates if the address is the default address for the customer.

first_name
STRING

The customer’s first name.

id
INTEGER

The address ID.

last_name
STRING

The customer’s last name.

name
STRING

The customer’s first and last names.

phone
STRING

The customer’s phone number at this address.

province
STRING

The customer’s region name.

province_code
STRING

The two-letter province code for the region.

zip
STRING

The customer’s postal or zip code.
customers (table), addresses (attribute)

created_at
DATE-TIME

The date and time in ISO 8601 format when the customer was created.

default_address
OBJECT

Details about the default address for the customer.

Click to expand default_address

address1
STRING

The street address.

address2
STRING

The second line of the street address.

city
STRING

The city, town, or village.

company
STRING

The company associated with the address.

country
STRING

The country associated with the address.

country_code
STRING

The two-letter country code corresponding to the country.

country_name
STRING

The normalized country name.

customer_id
INTEGER

The customer’s ID.

Reference:

default
BOOLEAN

Indicates if the address is the default address for the customer.

first_name
STRING

The customer’s first name.

id
INTEGER

The address ID.

last_name
STRING

The customer’s last name.

name
STRING

The customer’s first and last names.

phone
STRING

The customer’s phone number at this address.

province
STRING

The customer’s region name.

province_code
STRING

The two-letter province code for the region.

zip
STRING

The customer’s postal or zip code.
customers (table), default_address (attribute)

email
STRING

The customer’s email address.

email_marketing_consent
OBJECT

The marketing consent information when the customer consented to receiving marketing material by email.

first_name
STRING

The customer’s first name.

last_name
STRING

The customer’s last name.

last_order_id
INTEGER

The ID of the customer’s last order.

Reference:

last_order_name
STRING

The name of the customer’s last order.

multipass_identifier
STRING

The ID of the customer’s Multipass login.

note
STRING

A note about the customer.

orders_count
INTEGER

The number of orders associated with the customer.

phone
STRING

The phone number for the customer, in E.164 format.

state
STRING

The state of the customer’s account with a shop. Possible values are:

  • disabled - The customer doesn’t have an active account.
  • invited - The customer has received an email invite to create an account.
  • enabled - The customer has created an account.
  • declined - The customer has declined the eamil invite to create an account.

tags
STRING

Tags that the shop owner has attached to the customer.

tax_exempt
BOOLEAN

Indicates if the customer is exempt from paying taxes on their order. If true, taxes will not be applied to an order at checkout.

total_spent
STRING

The total amount of money that the customer has spent across their order history.

verified_email
BOOLEAN

Indicates if the customer has verified their email address.

custom_collections

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of custom collections

The custom_collections table contains info about custom collections. A custom collection is a grouping of products that a merchant creates to make their store easier to browse.

custom_collections table schema

id
INTEGER

The custom collection ID.

Reference:

updated_at
STRING

The date and time in ISO 8601 format when the custom collection was last updated.

body_html
STRING

The description of the custom collection in HTML format.

handle
STRING

A human-readable string for the custom collection, automatically generated from its title.

image
OBJECT

Details about images associated with the custom collection.

Click to expand image

alt
STRING

Alternative text that describes the collection image.

created_at
STRING

The date and time in ISO 8601 format when the image was created.

height
INTEGER

The height of the image in pixels.

src
STRING

The source URL that specifies the location of the image.

width
INTEGER

The width of the image in pixels.
custom_collections (table), image (attribute)

published_at
STRING

The date and time in ISO 8601 format when the custom collection was published. This will be null for a hidden custom collection.

published_scope
STRING

Indicates if the collection is published to the Point of Sale channel. Possible values are:

  • web - The custom collection is published to the Online Store channel, but not to the Point of Sale channel.
  • global - The custom collection is published to both the Online Store and Point of Sale channels.

sort_order
STRING

The order in which products in the custom collection appear. Possible values are:

  • alpha-asc - Alphabetically, in ascending order (A - Z).
  • alpha-desc - Alphabetically, in descending order (Z - A).
  • best-selling - By best-selling products.
  • created - By date created, in ascending order (oldest - newest).
  • created-desc - By date created, in descending order (newest - oldest).
  • manual - Order created by the shop owner.
  • price-asc - By price, in ascending order (lowest - highest).
  • price-desc - By price, in descending order (highest - lowest).

template_suffix
STRING

The suffix of the Liquid template being used. For example: If the value is custom, the collection is using the collection.custom.liquid template.

title
STRING

The name of the custom collection.

events

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created_at
Primary Key :

id

 API endpoint :

Retrieve a list of events

The events table contains info about events in the shop.

events table schema

id
INTEGER

The event ID.

created_at
DATE-TIME

The date and time in ISO 8601 format when the event was created.

body
STRING

A text field containing information about the event.

path
STRING

The relative URL to the resource the event is for.

message
STRING

The description of the event. It can contain HTML formatting.

subject_id
INTEGER

The ID of the resource that generated the event.

subject_type
STRING

The type of the resource that generated the event

verb
STRING

The type of event that occurred.

author
STRING

The author of the event.

description
STRING

The description of the event.

arguments
STRING, ARRAY

A certain event and its resources.

Click to expand arguments

argument
STRING

events (table), arguments (attribute)

inventory_items

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of inventory items

The inventory_items table contains info about items in a shop.

inventory_items table schema

id
INTEGER

The inventory item ID.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the inventory item was last updated.

admin_graphql_api_id
STRING

created_at
DATE-TIME

The date and time in ISO 8601 format when the inventory item was created.

sku
STRING

The unique SKU (stock keeping unit) of the inventory item.

requires_shipping
BOOLEAN

Whether a customer needs to provide a shipping address when placing an order containing the inventory item.

cost
STRING

The unit cost of the inventory item.

country_code_of_origin
STRING

The ISO 3166-1 alpha-2 country code of where the item came from.

province_code_of_origin
STRING

The ISO 3166-2 alpha-2 province code of where the item came from.

harmonized_system_code
INTEGER

The general Harmonized System (HS) code for the inventory item.

tracked
BOOLEAN

Whether inventory levels are tracked for the item.

country_harmonized_system_codes
ARRAY

The country-specific Harmonized System (HS) codes for the item.

Click to expand country_harmonized_system_codes

harmonized_system_code
STRING

The Harmonized System (HS) code.

country_code
STRING

The ISO 3166-1 alpha-2 country code.
inventory_items (table), country_harmonized_system_codes (attribute)

inventory_levels

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

created_at
Primary Key :

inventory_item_id : location_id

 API endpoint :

Retrieve a list of inventory levels

The inventory_levels table contains info about quantities of an inventory item for a location.

inventory_levels table schema

inventory_item_id
INTEGER

The ID of the inventory item associated with the inventory level.

location_id
INTEGER

The ID of the location that the inventory level belongs to.

created_at
DATE-TIME

The date and time in ISO 8601 format when the inventory level was modified.

admin_graphql_api_id
STRING

available
INTEGER

The available quantity of an inventory item at the inventory level’s associated location.

locations

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of locations

The locations table contains info about .

locations table schema

id
INTEGER

The event ID.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the location was last updated.

admin_graphql_api_id
STRING

created_at
STRING

The date and time in ISO 8601 format when the location was created.

country_code
STRING

The two-letter code (ISO 3166-1 alpha-2 format) corresponding to country the location is in.

name
STRING

The name of the location.

address1
STRING

The location’s street address.

address2
STRING

The second line of the location’s street address.

city
STRING

The city the location is in.

province_code
STRING

The province, state, or district code (ISO 3166-2 alpha-2 format) of the location.

zip
STRING

The zip or postal code.

localized_province_name
STRING

localized_country_name
STRING

The localized name of the location’s country.

province
STRING

The localized name of the location’s region.

phone
STRING

The phone number of the location.

legacy
BOOLEAN

Whether this is a fulfillment service location.

country
STRING

The country the location is in.

active
BOOLEAN

Whether the location is active.

metafields

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of metafields that belong to a resource

The metafields table contains info about resource metafields. These are arbitrary fields used to store additional information about resources.

Metafield replication and resource types

By default, this table will include only shop-level metafield data. To replicate the metafields for a given resource type, this table and the table for the resource must be set to replicate.

For example: To replicate metafield data for Orders, the orders table must also be set to replicate.

Metafield data is available for customers, products, and orders.

metafields table schema

id
INTEGER

The metafield ID.

updated_at
DATE-TIME

The date and time in ISO 8601 format when the metafield was last updated.

created_at
DATE-TIME

The date and time in ISO 8601 format when the customer was created.

description
STRING

A description of the info that the metafield contains.

key
STRING

The name of the metafield.

namespace
STRING

A container for a set of metafields.

owner_id
INTEGER

The ID of the resource that the metafield is attached to.

owner_resource
STRING

The type of resource that the metafield is attached to. Possible values are:

  • Customer
  • Order
  • Product

type
STRING

The type of data that the metafield stores.

value
INTEGER, OBJECT, STRING

The information to be stored as metadata.

value_type
STRING

The metafield’s information type. Possible values are:

  • string
  • integer
  • json_strong

orders

View table schema on GitHub
Replication Method :

Key-based Incremental

 Replication Key :

updated_at
Primary Key :

id

 API endpoint :

Retrieve a list of orders

The orders table contains info about a shop’s completed orders.

Order metafield data

To replicate order metafield data, you must set this table and the metafields table to replicate.

orders table schema

id
INTEGER

The order ID.

updated_at
DATE-TIME

app_id
INTEGER

The ID of the app that created the order.

billing_address
OBJECT

Details about the mailing address associated with the payment method. This address is an optional field that won’t be available on orders that don’t require a payment method.

Click to expand billing_address

address1
STRING

The street address of the billing address.

address2
STRING

An optional additional field for the street address of the of the billing address.

city
STRING

The city, town or village of the billing address.

company
STRING

The company of the person associated with the billing address.

country
STRING

The name of the country of the billing address.

country_code
STRING

The two-letter ISO 3166-1 code for the country of the billing address.

first_name
STRING

The first name of the person associated with the payment method.

last_name
STRING

The last name of the person associated with the payment method.

latitude
NUMBER

The latitude of the billing address.

longitude
NUMBER

The longitude of the billing address.

name
STRING

The full name of the person associated with the payment method.

phone
STRING

The phone number at the billing address.

province
STRING

The name of the region of the billing address.

province_code
STRING

The two-letter of the region of the billing address.

zip
STRING

The postal code of the billing address.
orders (table), billing_address (attribute)

browser_ip
STRING

The IP address of the browser used by the customer when they placed the order.

buyer_accepts_marketing
BOOLEAN

Indicates whether the customer consented to receive email updates from the shop.

cancel_reason
STRING

The reason why the order was canceled. Possible values are:

  • customer - The customer canceled the order.
  • fraud - The order was fraudulent.
  • inventory - Items in the order weren’t in inventory.
  • declined - The payment was declined.
  • other - A reason not in this list.

cancelled_at
DATE-TIME

cart_token
STRING

The ID for the cart associated with the order.

checkout_id
INTEGER

The checkout ID associated with the order.

checkout_token
STRING

The checkout token associated with the order.

client_details
OBJECT

Details about the browser the customer used when the order was placed.

Click to expand client_details

accept_language
STRING

The languages and locales that the browser understands.

browser_height
INTEGER

The browser’s screen height in pixels.

browser_ip
STRING

The browser’s IP address.

browser_width
INTEGER

The browser’s screen width in pixels.

session_hash
STRING

A hash of the session.

user_agent
STRING

Details of the browsing client, including software and operating versions.
orders (table), client_details (attribute)

closed_at
DATE-TIME

confirmed
BOOLEAN

Indicates if the order has been confirmed.

contact_email
STRING

The contact email associated with the order.

created_at
DATE-TIME

currency
STRING

The three-letter ISO 4217 code for the currency used for the payment.

customer
OBJECT

Details about the customer associated with the abandoned checkout.

Click to expand customer

accepts_marketing
BOOLEAN

Indicates the customer has consented to receive marketing material via email.

created_at
DATE-TIME

default_address
OBJECT

Details about the customer’s default address.

Click to expand default_address

address1
STRING

The street address of the customer’s address.

address2
STRING

An optional field for the street address of the customer’s address.

city
STRING

The city of the customer’s address.

company
STRING

The company of the person associated with the customer’s address.

country
STRING

The name of the country of the customer’s address.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country of the customer’s address.

country_name
STRING

The customer’s normalized country name.

customer_id
INTEGER

The customer’s ID.

Reference:

default
BOOLEAN

Indicates if this is the customer’s default address.

first_name
STRING

The first name of the customer.

id
INTEGER

The address ID.

last_name
STRING

The last name of the customer.

name
STRING

The customer’s first and last name.

phone
STRING

The customer’s phone number at this address.

province
STRING

The customer’s region name.

province_code
STRING

The two-letter province code for the customer’s region.

zip
STRING

The customer’s postal or zip code.
orders (table), default_address (attribute)

email
STRING

The customer’s email address.

first_name
STRING

The first name of the customer.

id
INTEGER

The customer ID.

Reference:

last_name
STRING

The last name of the customer.

multipass_identifier
STRING

The customer’s Multipass login ID.

note
STRING

A note about the customer.

phone
STRING

The phone number for the customer, in E.164 format.

state
STRING

The state of the customer’s account with a shop. Possible values are:

  • disabled - The customer doesn’t have an active account.
  • invited - The customer has received an email invite to create an account.
  • enabled - The customer has created an account.
  • declined - The customer has declined the eamil invite to create an account.

tags
STRING

Tags that the shop owner has attached to the customer.

tax_exempt
BOOLEAN

Indicates if the customer is exempt from paying taxes on their order. If true, taxes will not be applied to an order at checkout.

updated_at
DATE-TIME

The last time the customer was updated.

verified_email
BOOLEAN

Indicates if the customer has verified their email address.
orders (table), customer (attribute)

customer_locale
STRING

The two or three-letter language code, optionally followed by a region modifier.

device_id
INTEGER

The ID of the Shopify POS device that created the order.

discount_applications
ARRAY

Details about the discount applications associated with the order.

Click to expand discount_applications

allocation_method
STRING

The method used to allocate the discount application.

code
STRING

The discount code.

description
STRING

A description of the discount.

target_selection
STRING

Indicates how a discount selects line items in the cart to be discounted. Possible values are:

  • all - The discount applies to all line items.
  • entitled - The discount applies to a particular subset of line items, often defined by a condition.
  • explicit - The discount applies to a specifically selected line item or shipping line.

target_type
STRING

Indicates the type of item that a discount applies to. Possible values are:

  • line_item
  • shipping_line

title
STRING

The customer-facing name of the discount.

type
STRING

The type of the discount. Possible values are:

  • automatic
  • discount_code
  • manual
  • script

value
NUMBER

The value of the discount. This value is in the customer’s local (presentment) currency.

value_type
STRING

The value type of the discount. Possible values are:

  • fixed_amount
  • percentage
orders (table), discount_applications (attribute)

discount_codes
ARRAY

The discount codes applied to the checkout.

Click to expand discount_codes

amount
NUMBER

The amount of the discount.

code
STRING

The discount code.

type
STRING

The type of discount. Possible values are:

  • percentage
  • shipping
  • fixed_amount
orders (table), discount_codes (attribute)

email
STRING

The customer’s email address.

email_marketing_consent
OBJECT

The marketing consent information when the customer consented to receiving marketing material by email.

financial_status
STRING

The order’s financial status. Possible falues are:

  • authorized
  • pending
  • paid
  • partially_paid
  • refunded
  • voided
  • partially_refunded
  • unpaid

fulfillment_status
STRING

The order’s fulfillment status. Possible values are:

  • shipped
  • partial
  • unshipped

fulfillments
ARRAY

Details about the fulfillments associated with the order.

Click to expand fulfillments

id
INTEGER

The fulfillment ID.

created_at
DATE-TIME

line_items
ARRAY

Details about the line items associated with the fulfillment.

Click to expand line_items

applied_discount
INTEGER

The discount applied to the line item, if applicable.

compare_at_price
STRING

The line item’s compare at price.

destination_location
OBJECT

Details about the line item’s destination location.

Click to expand destination_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), destination_location (attribute)

destination_location_id
INTEGER

The ID of the destination location.

discount_allocations
ARRAY

An ordered list of amounts allocated by discount applications. Each discount allocation is associated to a particular appliction.

Click to expand discount_allocations

amount
NUMBER

The discount amount allocated to the line.

discount_application_index
INTEGER

The index of the associated discount application in the order’s discount_allocations list.
orders (table), discount_allocations (attribute)

fulfillable_quantity
INTEGER

The amount available to fulfill, calculated as follows:

quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity

fulfillment_service
STRING

The service provider that fulfilled the item. Possible values are manual or the name of the provider, such as amazon or shipwire

fulfillment_status
STRING

Indicates how far along an order is in terms of line items fulfilled. Possible values are:

  • null
  • fulfilled
  • partial
  • not_eligible

gift_card
BOOLEAN

Indicates whether the line item is a gift card.

grams
INTEGER

The weight of the item in grams.

key
STRING

A unique identifier for the line item, constructed from the line item’s variant_id plus a hash of the line item’s properties, even if the item has no additional properties.

line_price
STRING

This field has been deprecated by Shopify.

name
STRING

The name of the product variant.

origin_location
OBJECT

Details about the origin location associated with the refund line item.

Click to expand origin_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), origin_location (attribute)

origin_location_id
INTEGER

The ID of the origin location associated with the refund line item.

pre_tax_price
NUMBER

The pre-tax price of the item.

price
NUMBER

The price of the item before discounts were applied.

product_exists
BOOLEAN

Indicates whether the product exists.

product_id
INTEGER

The product ID.

Reference:

properties
ARRAY

Details about custom info for the item.

Click to expand properties

name
STRING

value
STRING

orders (table), properties (attribute)

quantity
INTEGER

The number of items purchased.

requires_shipping
BOOLEAN

Indicates if the item requires shipping.

sku
STRING

The item’s SKU.

tax_code
STRING

tax_lines
ARRAY

Details about the line item’s tax lines, each of which details a tax applicable to this line item.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

orders (table), tax_lines (attribute)

taxable
BOOLEAN

Indicates if the item is taxable.

title
STRING

The title of the product.

total_discount
NUMBER

The total of any discounts applied to the line item.

variant_id
INTEGER

The product variant ID.

variant_inventory_management
STRING

The name of the inventory management system.

variant_title
STRING

The title of the product variant.

vendor
STRING

The name of the item’s supplier.
orders (table), line_items (attribute)

location_id
INTEGER

The ID of the physical location where the fulfillment was processed.

name
STRING

The fulfillment name as represented by a number.

receipt
OBJECT

Click to expand receipt

authorization
STRING

testcase
BOOLEAN

orders (table), receipt (attribute)

service
STRING

shipment_status
STRING

status
STRING

tracking_company
STRING

The name of the service performing the fulfillment.

tracking_number
STRING

The tracking number of a fulfillment, if it exists.

tracking_numbers
ARRAY

A list of the fulfillment’s tracking numbers.

Click to expand tracking_numbers

value
STRING

The fulfillment’s tracking number.
orders (table), tracking_numbers (attribute)

tracking_url
STRING

The URL for a tracking number.

tracking_urls
ARRAY

A list of URLs for the fulfillment’s tracking numbers.

Click to expand tracking_urls

value
STRING

The URL for a tracking number.
orders (table), tracking_urls (attribute)

updated_at
DATE-TIME

orders (table), fulfillments (attribute)

gateway
STRING

The payment gateway used by the checkout.

landing_site
STRING

The URL for the page where the customer entered the shop.

line_items
ARRAY

Details about the line items in the order.

Click to expand line_items

applied_discount
INTEGER

The discount applied to the line item, if applicable.

compare_at_price
STRING

The line item’s compare at price.

destination_location
OBJECT

Details about the line item’s destination location.

Click to expand destination_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), destination_location (attribute)

destination_location_id
INTEGER

The ID of the destination location.

discount_allocations
ARRAY

An ordered list of amounts allocated by discount applications. Each discount allocation is associated to a particular appliction.

Click to expand discount_allocations

amount
NUMBER

The discount amount allocated to the line.

discount_application_index
INTEGER

The index of the associated discount application in the order’s discount_allocations list.
orders (table), discount_allocations (attribute)

fulfillable_quantity
INTEGER

The amount available to fulfill, calculated as follows:

quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity

fulfillment_service
STRING

The service provider that fulfilled the item. Possible values are manual or the name of the provider, such as amazon or shipwire

fulfillment_status
STRING

Indicates how far along an order is in terms of line items fulfilled. Possible values are:

  • null
  • fulfilled
  • partial
  • not_eligible

gift_card
BOOLEAN

Indicates whether the line item is a gift card.

grams
INTEGER

The weight of the item in grams.

key
STRING

A unique identifier for the line item, constructed from the line item’s variant_id plus a hash of the line item’s properties, even if the item has no additional properties.

line_price
STRING

This field has been deprecated by Shopify.

name
STRING

The name of the product variant.

origin_location
OBJECT

Details about the origin location associated with the refund line item.

Click to expand origin_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), origin_location (attribute)

origin_location_id
INTEGER

The ID of the origin location associated with the refund line item.

pre_tax_price
NUMBER

The pre-tax price of the item.

price
NUMBER

The price of the item before discounts were applied.

product_exists
BOOLEAN

Indicates whether the product exists.

product_id
INTEGER

The product ID.

Reference:

properties
ARRAY

Details about custom info for the item.

Click to expand properties

name
STRING

value
STRING

orders (table), properties (attribute)

quantity
INTEGER

The number of items purchased.

requires_shipping
BOOLEAN

Indicates if the item requires shipping.

sku
STRING

The item’s SKU.

tax_code
STRING

tax_lines
ARRAY

Details about the line item’s tax lines, each of which details a tax applicable to this line item.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

orders (table), tax_lines (attribute)

taxable
BOOLEAN

Indicates if the item is taxable.

title
STRING

The title of the product.

total_discount
NUMBER

The total of any discounts applied to the line item.

variant_id
INTEGER

The product variant ID.

variant_inventory_management
STRING

The name of the inventory management system.

variant_title
STRING

The title of the product variant.

vendor
STRING

The name of the item’s supplier.
orders (table), line_items (attribute)

location_id
INTEGER

The ID of the physical location where the order was processed.

name
STRING

The order name as represented by a number.

note
STRING

An optional note the shop owner attached to the order.

note_attributes
ARRAY

Additional info added to the order, as it appears in the Additional details section of an order page.

Click to expand note_attributes

name
STRING

value
STRING

orders (table), note_attributes (attribute)

number
INTEGER

An identifier unique to the shop. Numbers are sequential and start at 1000.

order_adjustments
ARRAY

A list of order adjustments attached to the order.

Click to expand order_adjustments

id
INTEGER

The order adjustment ID.

order_id
INTEGER

The ID of the order associated with the order adjustment.

Reference:

refund_id
INTEGER

The ID of the refund associated with the order adjustment.

Reference:

amount
NUMBER

The value of the discrepancy between the calculated refund and the actual refund. If the kind attribute’s value is shipping_refund, then amount is the value of shipping charges refunded to the customer.

kind
STRING

The order adjustment type. Possible values are:

  • shipping_refund
  • refund_discrepancy

reason
STRING

The reason for the order adjustment.

tax_amount
NUMBER

The tax amount of the order adjustment in shop and presentment currencies.
orders (table), order_adjustments (attribute)

order_number
INTEGER

A unique identifier for the order, used by the shop owner and customer. This is different from the id attribute.

order_status_url
STRING

The URL of the order’s status page.

payment_details
OBJECT

Details about the payment used for the order.

Click to expand payment_details

avs_result_code
STRING

The response code from the address verification system. Refer to Electronic Merchant System’s documentation for a list of possible codes and definitions.

credit_card_bin
STRING

The issuer identification number (IIN), formerly known as bank identification number (BIN) of the customer’s credit card. This is made up of the first few digits of the credit card number.

credit_card_company
STRING

The name of the company that issued the customer’s credit card.

credit_card_number
STRING

The customer’s credit card number, with most of the leading digits redacted.

cvv_result_code
STRING

The response code from the credit card company indicating whether the customer entered the card security code or card verification value (CVV) correctly. Refer to Electronic Merchant System’s documentation for a list of possible codes and defintions.
orders (table), payment_details (attribute)

payment_gateway_names
ARRAY

The list of payment gateways used for the order.

Click to expand payment_gateway_names

value
STRING

The payment gateway used for the order.
orders (table), payment_gateway_names (attribute)

phone
STRING

The customer’s phone number.

processed_at
DATE-TIME

processing_method
STRING

Indicates how the payment was processed. Possible values are:

  • checkout
  • direct
  • manual
  • offsite
  • express

reference
STRING

referring_site
STRING

The website where the customer clicked a link to the shop.

refunds
ARRAY

A list of refunds applied to the order.

Click to expand refunds

id
INTEGER

Reference:

created_at
DATE-TIME

note
STRING

An optional note attached to a refund.

order_adjustments
ARRAY

A list of order adjustments attached to the refund. Order adjustments are generated to account for refunded shipping costs and differences between calculated and actual refund amounts.

Click to expand order_adjustments

id
INTEGER

The order adjustment ID.

order_id
INTEGER

The ID of the order associated with the order adjustment.

Reference:

refund_id
INTEGER

The ID of the refund associated with the order adjustment.

Reference:

amount
NUMBER

The value of the discrepancy between the calculated refund and the actual refund. If the kind attribute’s value is shipping_refund, then amount is the value of shipping charges refunded to the customer.

kind
STRING

The order adjustment type. Possible values are:

  • shipping_refund
  • refund_discrepancy

reason
STRING

The reason for the order adjustment.

tax_amount
NUMBER

The tax amount of the order adjustment in shop and presentment currencies.
orders (table), order_adjustments (attribute)

processed_at
DATE-TIME

refund_line_items
ARRAY

A list of refunded line items.

Click to expand refund_line_items

id
INTEGER

The refund line item ID.

line_item
OBJECT

Details about the refund line item.

Click to expand line_item

applied_discount
INTEGER

The discount applied to the line item, if applicable.

compare_at_price
STRING

The line item’s compare at price.

destination_location
OBJECT

Details about the line item’s destination location.

Click to expand destination_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), destination_location (attribute)

destination_location_id
INTEGER

The ID of the destination location.

discount_allocations
ARRAY

An ordered list of amounts allocated by discount applications. Each discount allocation is associated to a particular appliction.

Click to expand discount_allocations

amount
NUMBER

The discount amount allocated to the line.

discount_application_index
INTEGER

The index of the associated discount application in the order’s discount_allocations list.
orders (table), discount_allocations (attribute)

fulfillable_quantity
INTEGER

The amount available to fulfill, calculated as follows:

quantity - max(refunded_quantity, fulfilled_quantity) - pending_fulfilled_quantity - open_fulfilled_quantity

fulfillment_service
STRING

The service provider that fulfilled the item. Possible values are manual or the name of the provider, such as amazon or shipwire

fulfillment_status
STRING

Indicates how far along an order is in terms of line items fulfilled. Possible values are:

  • null
  • fulfilled
  • partial
  • not_eligible

gift_card
BOOLEAN

Indicates whether the line item is a gift card.

grams
INTEGER

The weight of the item in grams.

key
STRING

A unique identifier for the line item, constructed from the line item’s variant_id plus a hash of the line item’s properties, even if the item has no additional properties.

line_price
STRING

This field has been deprecated by Shopify.

name
STRING

The name of the product variant.

origin_location
OBJECT

Details about the origin location associated with the refund line item.

Click to expand origin_location

address1
STRING

The street address.

address2
STRING

An optional second address line.

city
STRING

The city.

country_code
STRING

The two letter code (ISO 3166-1 alpha-2) format for the country.

id
INTEGER

The address ID.

name
STRING

The first and last name of the person associated with the address.

province_code
STRING

The two-letter province code for the region associated with the address.

zip
STRING

The postal or zip code associated with the address.
orders (table), origin_location (attribute)

origin_location_id
INTEGER

The ID of the origin location associated with the refund line item.

pre_tax_price
NUMBER

The pre-tax price of the item.

price
NUMBER

The price of the item before discounts were applied.

product_exists
BOOLEAN

Indicates whether the product exists.

product_id
INTEGER

The product ID.

Reference:

properties
ARRAY

Details about custom info for the item.

Click to expand properties

name
STRING

value
STRING

orders (table), properties (attribute)

quantity
INTEGER

The number of items purchased.

requires_shipping
BOOLEAN

Indicates if the item requires shipping.

sku
STRING

The item’s SKU.

tax_code
STRING

tax_lines
ARRAY

Details about the line item’s tax lines, each of which details a tax applicable to this line item.

Click to expand tax_lines

compare_at
STRING

position
INTEGER

price
NUMBER

The amount of tax to be charged.

rate
NUMBER

The rate of tax to be applied.

source
STRING

title
STRING

The name of the tax.

zone
STRING

orders (table), tax_lines (attribute)

taxable
BOOLEAN

Indicates if the item is taxable.

title
STRING

The title of the product.

total_discount
NUMBER

The total of any discounts applied to the line item.

variant_id
INTEGER

The product variant ID.

variant_inventory_management
STRING

The name of the inventory management system.

variant_title
STRING

The title of the product variant.

vendor
STRING

The name of the item’s supplier.
orders (table), line_item (attribute)

line_item_id
INTEGER

The ID of the related line item in the order.

location_id
INTEGER

The ID of the location where the items will be restocked.

quantity
INTEGER

The quantity of the associated line item that was returned.

restock_type
STRING

Indicates how the refund line item affects inventory levels. Possible values are:

  • no_restock - Refunding these items won’t affect inventory. The number of fulfillable units for this line item will remain unchanged. For example, a refund payment can be issued but no items will be returned or made available for sale again.

  • cancel - The items have not yet been fulfilled. The canceled quantity will be added back to the available count. The number of fulfillable units for this line item will decrease.

  • return - The items were already delivered, and will be returned to the merchant. The returned quantity will be added back to the available count. The number of fulfillable units for this line item will remain unchanged.

  • legacy_restock - The deprecated restock property was used for this refund. These items were made available for sale again.

subtotal
NUMBER

The subtotal of the refund line item.

total_tax
NUMBER

The total tax on the refund line item.
orders (table), refund_line_items (attribute)

restock
BOOLEAN

Indicates if the line items will be added back to the store’s inventory.

user_id
INTEGER

The ID of the user who performed the refund.
orders (table), refunds (attribute)

shipping_address
OBJECT

Details about the shipping address associated with the order.

Click to expand shipping_address

address1
STRING

The street address of the billing address.

address2
STRING

An optional additional field for the street address of the of the billing address.

city
STRING

The city, town or village of the billing address.

company
STRING

The company of the person associated with the billing address.

country
STRING

The name of the country of the billing address.

country_code
STRING

The two-letter ISO 3166-1 code for the country of the billing address.

first_name
STRING

The first name of the person associated with the payment method.

last_name
STRING

The last name of the person associated with the payment method.

latitude
NUMBER

The latitude of the billing address.

longitude
NUMBER

The longitude of the billing address.