Shopify

Shopify is an ecommerce platform for online stores and point of sale.

With Amalgam, you can two-way sync data into Excel and Google Sheets, or enable your AI tools to take direct actions without hand-holding.

Spreadsheets

AI Chat

Routines

Reports

Category: Ecommerce
Connects By: Signing In
Reports: 14
Website: shopify.com

What You Can Do With Shopify

In a Spreadsheet

Pull data into Excel or Google Sheets, and refresh it whenever you need current numbers.

See How It Works

In an AI Chat

Connect your AI tool to Amalgam, and it can run Shopify reports to answer your questions.

See Amalgam for AI

On a Schedule

Set a routine to fetch data on a schedule and deliver it to your shared drive, inbox, or directly into a document.

How to Connect

Sign in to Shopify and approve the Amalgam app. You need the Manage and Install Apps and Channels permission on the store. Each account you connect becomes its own connection in Amalgam, and you can add as many as you need.

Read the Connection Guide

Reports14

Pull any of these into a spreadsheet, a chat or a routine, for one Shopify account or every account you connect.

Customer CohortsBeta

ShopifyQL Customer Cohort Analysis showing customer retention by cohort month.

Options: Start Date, End Date

Fulfillment Details

Shopify Fulfillments (GraphQL) showing fulfillment details with tracking and line items.

Options: Start Date, End Date

Fulfillment Details (Legacy)

Shopify Fulfillments (REST API) - legacy variant.

New vs. Returning CustomersBeta

ShopifyQL Net Sales by New vs Returning Customers aggregated by month.

Options: Start Date, End Date

Order Lines

Shopify Order Line Items (GraphQL) showing all orders with individual line items including product details, prices, shipping/billing addresses, and payment info.

Options: Start Date, End Date

Order Lines Summary

Shopify Order Lines Summary (GraphQL) showing order line items with gross sales, discounts, returns, taxes, and units.

Options: Start Date, End Date

Order Lines Summary (Legacy)

Shopify Order Lines Summary (REST API) - legacy variant of the GraphQL summary.

Options: Start Date, End Date

Orders

Shopify Orders Summary (GraphQL) showing minimal order-level data.

Options: Start Date, End Date

Orders Detail (Legacy)

Shopify Order Lines Detail with extended product and address information.

Options: Start Date, End Date

Payment Transactions

Shopify Payment Transactions (GraphQL) showing Shopify Payments transaction details.

Options: Start Date, End Date, Payout ID

Payments & Payouts (Legacy)

Shopify Transactions (REST API) - legacy variant of the GraphQL transactions report.

Options: Start Date, End Date

Payouts

Shopify Payouts (GraphQL) showing all Shopify Payments payouts with charges, refunds, adjustments, and fees.

Options: Start Date, End Date

ShopifyQL QueryBeta

ShopifyQL Generic Query allowing custom ShopifyQL queries.

Options: Query Dump, Start Date, End Date

Transactions

Shopify Transactions (GraphQL) showing all payment transactions for orders including authorization codes, amounts, and card types.

Options: Start Date, End Date

Don't See What You Need?

Tell us which Shopify report or record you're missing, and we'll build it for you, usually within a week.

More Ecommerce Integrations

All Integrations

Nabis

Try It With Your Shopify Data

Book a demo, take a tour of Amalgam, and get a free trial on us to test the different systems and see how the integrations work first hand.