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 |
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 |
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 |
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!