Easy Insight Logo
Call 1-(720)-316-8174

eCommerce and Inventory Dashboard

Custom Field Start

Sell products through eCommerce sites like Shopify or Woo Commerce? Track inventory fulfillment through DEAR Systems, Locate Inventory, or KatanaMRP? You can automatically create a dashboard in just a few clicks in Easy Insight to look at your entire business through marketing, CRM, eCommerce, inventory fulfillment, and accounting.

Combining Data Sources

First, connect Easy Insight to your various data sources from the Connections page. For example, you might connect Google Analytics and Facebook Ads for marketing, Hubspot or Salesforce for CRM, Shopify or Woo Commerce for eCommerce, DEAR Systems, Locate Inventory, or KatanaMRP for inventory, and Xero or QuickBooks Online for accounting.

If you have multiple sources for a given connection, that's fine! For example, you might have multiple Shopify storefronts or a separate DEAR Systems instance for each business unit. If so, create a connection to each, then combine the sources through 'Combine as Federated Source.' See the federated source documentation for more information.

Once you have your data connected, you can create a single combined data source by clicking on Connections -> Combine Sources or simply clicking 'Combine Sources' from any of your newly created individual sources:

A setup wizard will guide you through creating the combined source. You'll need to choose the sources to include and how the sources are joined together. You can use the automatic suggestions to start with:

Once you click Create and name your data source, Easy Insight will start generating the automatic dashboard for you. Once created, you'll be redirected over to the newly created dashboard.

Your Business Dashboard

The first page of the dashboard includes a diagram of your business, showing the customer flow from lead generation into eCommerce into fulfillment and finally into accounting. You can click on any of the underlined metrics to pull up the prebuilt dashboard for the matching data source. For example, clicking on Shopify Order Total in the screenshot below pulls up the Shopify prebuilt dashboard:

The Metrics Month over Month table gives you a month over month view of metrics across all of your data sources:

Custom Field Start

The Trends tab includes trend charts from all of your data sources, helping you to visually understand changes in your business:

The Customer tab provides a view of your customers from across all of your systems. For each customer, you can see the various key metrics matching to each customer. You can click on the underlined customer email to pull up a single consolidated view of the customer across all systems. In the example below, we can see the sales activites, Shopify orders, and DEAR orders all matching to one customer. We can also click on the 'View in Hubspot', 'View in Shopify', or 'View in DEAR Systems' links to jump to the specific customer record in that system.

Custom Field Start

The Product tab does the same thing as the Customer tab, but with product SKUs and related metrics. Again, you can click into a particular SKU to see everything tied to that SKU across all of your systems:

Custom Field Start

Finally, the Invoice Validation tab gives you a comparison of invoices to your accounting system, helping you to identify where data is mismatched between different systems:

Custom Field Start

Next Steps

From here, you can customize any of these reports in the usual way you'd change anything in Easy Insight, but you can use this dashboard and its reports as a starting point to fully visualize your business. For next steps, we recommend checking out Report Basics and Dashboard Basics for customizing your reports and dashboard.

RESOURCES
Twitter Logo