Shopify

Shopify Functions & Syntax

Overview

Shopify is a cloud-based, multi-channel e-commerce platform designed for small and medium-sized businesses. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can quickly lookup and work with customer data, product information, and current orders from your Shopify store without leaving your spreadsheet.

What you can do

With this integration, you can:

  • Interactively search and filter orders and products
  • Lookup and track current order activity
  • Lookup information for a list of customers
  • Enrich your spreadsheet with data from your Shopify store

What you need

You need to have a Shopify account to use this integration. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Shopify Customers

Returns a list of customers from Shopify

Syntax

=FLEX("YOUR_TEAM_NAME/shopify-customers", [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/shopify-customers", "")
=FLEX("YOUR_TEAM_NAME/shopify-customers", "id, email, first_name, last_name")

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. false
filter string Filter to apply with key/values specified as a URL query string where the keys correspond to the properties to filter. false

Returns

Property Type Description
id integer The unique identifier for the customer
first_name string The first name of the customer
last_name string The last name of the customer
email string The email for the customer
verified_email boolean Whether or not the email for the customer is verified
phone string The phone number for the customer
created_at string The date when the customer was created
updated_at string The date the information for the customer was last updated
state string The state of the shop for the customer
tax_exempt boolean Whether or not the customer is exempt from paying taxes on their order
tax_exemptions string List of specific tax exemptions for the customer
orders_count integer The number of orders associated with the customer
total_spent integer The total amount spent by the customer
currency string The currency that the customer used when they paid for their last order
last_order_id integer The id of the last order for the customer
last_order_name string The name of the last order for the customer
accepts_marketing boolean Whether the customer has consented to receive marketing material via email
marketing_opt_in_level string The marketing subscription opt-in level that the customer gave when they consented to receive marketing material by email
accepts_marketing_updated_at string The date when the customer consented or objected to receiving marketing material by email
note string A note about the customer
tags string The tags associated with the customer given as a comma-delimited list
address_id integer The identifier for the default address for the customer
address_customer_id integer The customer identifier for the default address for the customer
address_first_name string The first name listed for the default address for the customer
address_last_name string The last name listed for the default address for the customer
address_name string The name listed for the default address for the customer
address_phone string The phone number associated with the default address for the customer
address_company string The company listed for the default address for the customer
address1 string The first line of the default address for the customer
address2 string The second line of the default address for the customer
address_city string The city of the default address for the customer
address_province string The province of the default address for the customer
address_province_code string The province code of the default address for the customer
address_zip string The postal code of the default address for the customer
address_country string The country of the default address for the customer
address_country_code string The country code of the default address for the customer
address_country_name string The normalized country name of the default address for the customer
address_default boolean Whether or not the address is the default address for the customer

Notes

Shopify Orders

Returns a list of orders from Shopify

Syntax

=FLEX("YOUR_TEAM_NAME/shopify-orders", [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/shopify-orders", "")
=FLEX("YOUR_TEAM_NAME/shopify-orders", "id, customer_id, created_at, total_price")

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. false
filter string Filter to apply with key/values specified as a URL query string where the keys correspond to the properties to filter. false

Returns

Property Type Description
id integer The id of the order
app_id integer The id of the app that created the order
customer_id integer The id associated with the customer placing the order
billing_address_first_name string undefined
billing_address_last_name string undefined
billing_address_name string undefined
billing_address_phone string The phone number at the billing address
billing_address_company string The company of the person associated with the billing address
billing_address_street1 string The street address of the billing address
billing_address_street2 string An optional additional field for the street address of the billing address
billing_address_city string The city, town, or village of the billing address
billing_address_province string undefined
billing_address_province_code string The two-letter abbreviation of the region of the billing address
billing_address_zip string The postal code of the billing address
billing_address_country string undefined
billing_address_country_code string The two-letter code (ISO 3166-1 format) for the country of the billing address
billing_address_latitude number The latitude of the billing address
billing_address_longitude number The longitude of the billing address
shipping_address_first_name string undefined
shipping_address_last_name string undefined
shipping_address_name string undefined
shipping_address_phone string The phone number at the shipping address
shipping_address_company string The company of the person associated with the shipping address
shipping_address_street1 string The street address of the shipping address
shipping_address_street2 string An optional additional field for the street address of the shipping address
shipping_address_city string The city, town, or village of the shipping address
shipping_address_province string undefined
shipping_address_province_code string The two-letter abbreviation of the region of the shipping address
shipping_address_zip string The postal code of the shipping address
shipping_address_country string undefined
shipping_address_country_code string The two-letter code (ISO 3166-1 format) for the country of the shipping address
shipping_address_latitude number The latitude of the shipping address
shipping_address_longitude number The longitude of the shipping address
created_at string The date and time when the order was created
updated_at string The date and time when the order was last modified
processed_at string The date and time when an order was processed
cancelled_at string The date and time when the order was canceled
closed_at string The date and time when the order was closed
currency string The three-letter code (ISO 4217 format) for the shop currency
total_weight integer The sum of all line item weights in grams
total_line_items_price number The sum of all line item prices in the shop currency
total_discounts number The total discounts applied to the price of the order in the shop currency
subtotal_price number The price of the order in the shop currency after discounts but before shipping, taxes, and tips
total_shipping number The sum of all the shipping amoutns in the order in the shop currency
total_tip_received number The sum of all the tips in the order in the shop currency
total_tax number The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency
total_price number The sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency

Notes

Shopify Products

Returns a list of products from Shopify

Syntax

=FLEX("YOUR_TEAM_NAME/shopify-products", [properties], [filter])

Sample Usage

=FLEX("YOUR_TEAM_NAME/shopify-products", "")
=FLEX("YOUR_TEAM_NAME/shopify-products", "id, title, sku, price")

Parameters

Property Type Description Required
properties array The properties to return (defaults to all properties). See "Returns" for a listing of the available properties. false
filter string Filter to apply with key/values specified as a URL query string where the keys correspond to the properties to filter. false

Returns

Property Type Description
id integer The unique identifer for the product
title string The title for the product
body_html string A description of the product
handle string A human-friendly string for the product
vendor string The name of the vendor of the product
product_type string A categorization of the product used for filtering and searching products
created_at string The date the product was created
updated_at string The date the product was last updated
published_at string The date the product was published
published_scope string The channel to which the product is published
template_suffix string The suffix of the Liquid tempate used for the product page
tags string A comma-separated list of tags that are used for filtering and searching products
variant_id integer The unique identifier for a product variant
variant_title string The title of the product variant
variant_option1 string A custom property used to define product variants
variant_option2 string A custom property used to define product variants
variant_option3 string A custom property used to define product variants
variant_created_at string The date the product variant was created
variant_updated_at string The date the product variant was last updated
sku string A unique identifier for the product variant in the shop
barcode string The barcode, UPC, or ISBN number for a product variant
price number The price of the product variant
compare_at_price number The original price of the product variant before an adjustment or a sale
inventory_policy string Whether or not customers are allowed to place an order for out-of-stock product variants
inventory_management string The fullfillment service that tracks the number of items in tock for the product variant
fulfillment_service string The fullfillment service associated with the product variant
taxable boolean Whether or not a tax is charged when the product variant is sold
grams number The weight of the product variant in grams
weight number The weight of the product variant in the units given by weight_unit
weight_unit string The unit of measurement that applies to the weight of the product variant
inventory_item_id integer The unique identifier for the product variant in inventory
inventory_quantity integer The total inventory for the product variant across all locations
image_id integer The unique identifier for an image for the product
image_created_at string The date the image for the product was created
image_udpated_at string The date the image for the product was last updated
image_width integer The width of the image for the product
image_height integer The height of the image for the product
image_src string A link to the image for the product

Notes

Need help?

Have questions? Need help getting started? Need other Shopify templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!