Build a Shopify customer sales report using Airtable

Get a better picture of your customers by using Airtable's powerful relationship columns. Since your Customers are linked to your Orders in Airtable you can use rollup columns in some pretty interesting ways. Here's an example:

  1. Create a Total Order Amount column in your Customers sheet
  2. Make the column a Rollup and make it sum the "Total" column of the Orders sheet
  3. And voila - you now have the total amount the customer has ordered from your store!

© 2019 Intelaria Corporation