Analyze your store's performance
You don't need a separate app to see your store's profitabily. Just use Airtable's formulas to give you the full picture.
Here's an example:
- Sync your Order and Order Item data into Airtable, using BaseGenius' integration
- During the sync the Orders and Order Items will be linked to your Products
- Add Airtable Rollup columns to count the number of orders each product has received and the total revenue
- 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 number will update in real-time as new orders come in