View sales and profit by Product and Variant

You don't need a separate app to see your store's profitability. Just use Airtable's formulas to give you the full picture.

Here's an example:

  1. Sync your Order and Order Item data into Airtable, using BaseGenius' integration
  2. During the sync the Orders and Order Items will be linked to your Products
  3. Add Airtable Rollup columns to count the number of orders each product has received and the total revenue
  4. Using the product cost (in a separate column) and total revenue columns as inputs, create a new formula column to calculate raw profitability per product. The cool thing is that all these numbers will update in real-time as new orders come in
© 2019 Intelaria Corporation